DBA Data[Home] [Help]

APPS.PO_REQUISITION_HEADERS_PKG1 dependencies on FND_LOG

Line 203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);

199: return;
200: else
201: IF (g_fnd_debug = 'Y') THEN
202: IF (NVL(X_Requisition_Header_Id,-999) <> NVL(Recinfo.requisition_header_id,-999)) THEN
203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);
204: END IF;
205: IF (NVL(X_Preparer_Id,-999) <> NVL(Recinfo.preparer_id,-999)) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_id'||X_Preparer_Id ||' Database preparer_id '|| Recinfo.preparer_id);
207: END IF;

Line 206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_id'||X_Preparer_Id ||' Database preparer_id '|| Recinfo.preparer_id);

202: IF (NVL(X_Requisition_Header_Id,-999) <> NVL(Recinfo.requisition_header_id,-999)) THEN
203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form requisition_header_id'||X_Requisition_Header_Id ||' Database requisition_header_id '|| Recinfo.requisition_header_id);
204: END IF;
205: IF (NVL(X_Preparer_Id,-999) <> NVL(Recinfo.preparer_id,-999)) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_id'||X_Preparer_Id ||' Database preparer_id '|| Recinfo.preparer_id);
207: END IF;
208: IF (NVL(TRIM(X_Segment1),'-999') <> NVL( TRIM(Recinfo.segment1),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment1 '||X_Segment1 ||' Database segment1 '||Recinfo.segment1);
210: END IF;

Line 209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment1 '||X_Segment1 ||' Database segment1 '||Recinfo.segment1);

205: IF (NVL(X_Preparer_Id,-999) <> NVL(Recinfo.preparer_id,-999)) THEN
206: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_id'||X_Preparer_Id ||' Database preparer_id '|| Recinfo.preparer_id);
207: END IF;
208: IF (NVL(TRIM(X_Segment1),'-999') <> NVL( TRIM(Recinfo.segment1),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment1 '||X_Segment1 ||' Database segment1 '||Recinfo.segment1);
210: END IF;
211: IF (NVL(TRIM(X_Summary_Flag),'-999') <> NVL( TRIM(Recinfo.summary_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form summary_flag '||X_Summary_Flag ||' Database summary_flag '||Recinfo.summary_flag);
213: END IF;

Line 212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form summary_flag '||X_Summary_Flag ||' Database summary_flag '||Recinfo.summary_flag);

208: IF (NVL(TRIM(X_Segment1),'-999') <> NVL( TRIM(Recinfo.segment1),'-999')) THEN
209: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment1 '||X_Segment1 ||' Database segment1 '||Recinfo.segment1);
210: END IF;
211: IF (NVL(TRIM(X_Summary_Flag),'-999') <> NVL( TRIM(Recinfo.summary_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form summary_flag '||X_Summary_Flag ||' Database summary_flag '||Recinfo.summary_flag);
213: END IF;
214: IF (NVL(TRIM(X_Enabled_Flag),'-999') <> NVL( TRIM(Recinfo.enabled_flag),'-999')) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enabled_flag '||X_Enabled_Flag ||' Database enabled_flag '||Recinfo.enabled_flag);
216: END IF;

Line 215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enabled_flag '||X_Enabled_Flag ||' Database enabled_flag '||Recinfo.enabled_flag);

211: IF (NVL(TRIM(X_Summary_Flag),'-999') <> NVL( TRIM(Recinfo.summary_flag),'-999')) THEN
212: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form summary_flag '||X_Summary_Flag ||' Database summary_flag '||Recinfo.summary_flag);
213: END IF;
214: IF (NVL(TRIM(X_Enabled_Flag),'-999') <> NVL( TRIM(Recinfo.enabled_flag),'-999')) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enabled_flag '||X_Enabled_Flag ||' Database enabled_flag '||Recinfo.enabled_flag);
216: END IF;
217: IF (NVL(TRIM(X_Segment2),'-999') <> NVL( TRIM(Recinfo.segment2),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment2 '||X_Segment2 ||' Database segment2 '||Recinfo.segment2);
219: END IF;

Line 218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment2 '||X_Segment2 ||' Database segment2 '||Recinfo.segment2);

214: IF (NVL(TRIM(X_Enabled_Flag),'-999') <> NVL( TRIM(Recinfo.enabled_flag),'-999')) THEN
215: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enabled_flag '||X_Enabled_Flag ||' Database enabled_flag '||Recinfo.enabled_flag);
216: END IF;
217: IF (NVL(TRIM(X_Segment2),'-999') <> NVL( TRIM(Recinfo.segment2),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment2 '||X_Segment2 ||' Database segment2 '||Recinfo.segment2);
219: END IF;
220: IF (NVL(TRIM(X_Segment3),'-999') <> NVL( TRIM(Recinfo.segment3),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment3 '||X_Segment3 ||' Database segment3 '||Recinfo.segment3);
222: END IF;

Line 221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment3 '||X_Segment3 ||' Database segment3 '||Recinfo.segment3);

217: IF (NVL(TRIM(X_Segment2),'-999') <> NVL( TRIM(Recinfo.segment2),'-999')) THEN
218: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment2 '||X_Segment2 ||' Database segment2 '||Recinfo.segment2);
219: END IF;
220: IF (NVL(TRIM(X_Segment3),'-999') <> NVL( TRIM(Recinfo.segment3),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment3 '||X_Segment3 ||' Database segment3 '||Recinfo.segment3);
222: END IF;
223: IF (NVL(TRIM(X_Segment4),'-999') <> NVL( TRIM(Recinfo.segment4),'-999')) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment4 '||X_Segment4 ||' Database segment4 '||Recinfo.segment4);
225: END IF;

Line 224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment4 '||X_Segment4 ||' Database segment4 '||Recinfo.segment4);

220: IF (NVL(TRIM(X_Segment3),'-999') <> NVL( TRIM(Recinfo.segment3),'-999')) THEN
221: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment3 '||X_Segment3 ||' Database segment3 '||Recinfo.segment3);
222: END IF;
223: IF (NVL(TRIM(X_Segment4),'-999') <> NVL( TRIM(Recinfo.segment4),'-999')) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment4 '||X_Segment4 ||' Database segment4 '||Recinfo.segment4);
225: END IF;
226: IF (NVL(TRIM(X_Segment5),'-999') <> NVL( TRIM(Recinfo.segment5),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment5 '||X_Segment5 ||' Database segment5 '||Recinfo.segment5);
228: END IF;

Line 227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment5 '||X_Segment5 ||' Database segment5 '||Recinfo.segment5);

223: IF (NVL(TRIM(X_Segment4),'-999') <> NVL( TRIM(Recinfo.segment4),'-999')) THEN
224: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment4 '||X_Segment4 ||' Database segment4 '||Recinfo.segment4);
225: END IF;
226: IF (NVL(TRIM(X_Segment5),'-999') <> NVL( TRIM(Recinfo.segment5),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment5 '||X_Segment5 ||' Database segment5 '||Recinfo.segment5);
228: END IF;
229: IF (X_Start_Date_Active <> Recinfo.start_date_active ) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date_active '||X_Start_Date_Active ||' Database start_date_active '||Recinfo.start_date_active);
231: END IF;

Line 230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date_active '||X_Start_Date_Active ||' Database start_date_active '||Recinfo.start_date_active);

226: IF (NVL(TRIM(X_Segment5),'-999') <> NVL( TRIM(Recinfo.segment5),'-999')) THEN
227: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form segment5 '||X_Segment5 ||' Database segment5 '||Recinfo.segment5);
228: END IF;
229: IF (X_Start_Date_Active <> Recinfo.start_date_active ) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date_active '||X_Start_Date_Active ||' Database start_date_active '||Recinfo.start_date_active);
231: END IF;
232: IF (X_End_Date_Active <> Recinfo.end_date_active ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date_active '||X_End_Date_Active ||' Database end_date_active '||Recinfo.end_date_active);
234: END IF;

Line 233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date_active '||X_End_Date_Active ||' Database end_date_active '||Recinfo.end_date_active);

229: IF (X_Start_Date_Active <> Recinfo.start_date_active ) THEN
230: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date_active '||X_Start_Date_Active ||' Database start_date_active '||Recinfo.start_date_active);
231: END IF;
232: IF (X_End_Date_Active <> Recinfo.end_date_active ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date_active '||X_End_Date_Active ||' Database end_date_active '||Recinfo.end_date_active);
234: END IF;
235: IF (NVL(TRIM(X_Description),'-999') <> NVL( TRIM(Recinfo.description),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form description '||X_Description ||' Database description '||Recinfo.description);
237: END IF;

Line 236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form description '||X_Description ||' Database description '||Recinfo.description);

232: IF (X_End_Date_Active <> Recinfo.end_date_active ) THEN
233: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date_active '||X_End_Date_Active ||' Database end_date_active '||Recinfo.end_date_active);
234: END IF;
235: IF (NVL(TRIM(X_Description),'-999') <> NVL( TRIM(Recinfo.description),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form description '||X_Description ||' Database description '||Recinfo.description);
237: END IF;
238: IF (NVL(TRIM(X_Authorization_Status),'-999') <> NVL( TRIM(Recinfo.authorization_status),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form authorization_status '||X_Authorization_Status ||' Database authorization_status '||Recinfo.authorization_status);
240: END IF;

Line 239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form authorization_status '||X_Authorization_Status ||' Database authorization_status '||Recinfo.authorization_status);

235: IF (NVL(TRIM(X_Description),'-999') <> NVL( TRIM(Recinfo.description),'-999')) THEN
236: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form description '||X_Description ||' Database description '||Recinfo.description);
237: END IF;
238: IF (NVL(TRIM(X_Authorization_Status),'-999') <> NVL( TRIM(Recinfo.authorization_status),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form authorization_status '||X_Authorization_Status ||' Database authorization_status '||Recinfo.authorization_status);
240: END IF;
241: IF (NVL(TRIM(X_Note_To_Authorizer),'-999') <> NVL( TRIM(Recinfo.note_to_authorizer),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_authorizer '||X_Note_To_Authorizer ||' Database note_to_authorizer '||Recinfo.note_to_authorizer);
243: END IF;

Line 242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_authorizer '||X_Note_To_Authorizer ||' Database note_to_authorizer '||Recinfo.note_to_authorizer);

238: IF (NVL(TRIM(X_Authorization_Status),'-999') <> NVL( TRIM(Recinfo.authorization_status),'-999')) THEN
239: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form authorization_status '||X_Authorization_Status ||' Database authorization_status '||Recinfo.authorization_status);
240: END IF;
241: IF (NVL(TRIM(X_Note_To_Authorizer),'-999') <> NVL( TRIM(Recinfo.note_to_authorizer),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_authorizer '||X_Note_To_Authorizer ||' Database note_to_authorizer '||Recinfo.note_to_authorizer);
243: END IF;
244: IF (NVL(TRIM(X_Type_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.type_lookup_code),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_lookup_code '||X_Type_Lookup_Code ||' Database type_lookup_code '||Recinfo.type_lookup_code);
246: END IF;

Line 245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_lookup_code '||X_Type_Lookup_Code ||' Database type_lookup_code '||Recinfo.type_lookup_code);

241: IF (NVL(TRIM(X_Note_To_Authorizer),'-999') <> NVL( TRIM(Recinfo.note_to_authorizer),'-999')) THEN
242: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_authorizer '||X_Note_To_Authorizer ||' Database note_to_authorizer '||Recinfo.note_to_authorizer);
243: END IF;
244: IF (NVL(TRIM(X_Type_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.type_lookup_code),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_lookup_code '||X_Type_Lookup_Code ||' Database type_lookup_code '||Recinfo.type_lookup_code);
246: END IF;
247: IF (NVL(TRIM(X_Transferred_To_Oe_Flag),'-999') <> NVL( TRIM(Recinfo.transferred_to_oe_flag),'-999')) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transferred_to_oe_flag '||X_Transferred_To_Oe_Flag ||' Database transferred_to_oe_flag '||Recinfo.transferred_to_oe_flag);
249: END IF;

Line 248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transferred_to_oe_flag '||X_Transferred_To_Oe_Flag ||' Database transferred_to_oe_flag '||Recinfo.transferred_to_oe_flag);

244: IF (NVL(TRIM(X_Type_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.type_lookup_code),'-999')) THEN
245: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_lookup_code '||X_Type_Lookup_Code ||' Database type_lookup_code '||Recinfo.type_lookup_code);
246: END IF;
247: IF (NVL(TRIM(X_Transferred_To_Oe_Flag),'-999') <> NVL( TRIM(Recinfo.transferred_to_oe_flag),'-999')) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transferred_to_oe_flag '||X_Transferred_To_Oe_Flag ||' Database transferred_to_oe_flag '||Recinfo.transferred_to_oe_flag);
249: END IF;
250: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute_category '||X_Attribute_Category ||' Database attribute_category '||Recinfo.attribute_category);
252: END IF;

Line 251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute_category '||X_Attribute_Category ||' Database attribute_category '||Recinfo.attribute_category);

247: IF (NVL(TRIM(X_Transferred_To_Oe_Flag),'-999') <> NVL( TRIM(Recinfo.transferred_to_oe_flag),'-999')) THEN
248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transferred_to_oe_flag '||X_Transferred_To_Oe_Flag ||' Database transferred_to_oe_flag '||Recinfo.transferred_to_oe_flag);
249: END IF;
250: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute_category '||X_Attribute_Category ||' Database attribute_category '||Recinfo.attribute_category);
252: END IF;
253: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
255: END IF;

Line 254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);

250: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
251: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute_category '||X_Attribute_Category ||' Database attribute_category '||Recinfo.attribute_category);
252: END IF;
253: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
255: END IF;
256: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
257: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
258: END IF;

Line 257: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);

253: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
254: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
255: END IF;
256: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
257: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
258: END IF;
259: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
260: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
261: END IF;

Line 260: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);

256: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
257: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
258: END IF;
259: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
260: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
261: END IF;
262: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
264: END IF;

Line 263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);

259: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
260: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
261: END IF;
262: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
264: END IF;
265: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
266: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
267: END IF;

Line 266: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);

262: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
263: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
264: END IF;
265: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
266: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
267: END IF;
268: IF (NVL(TRIM(X_On_Line_Flag),'-999') <> NVL( TRIM(Recinfo.on_line_flag),'-999')) THEN
269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_line_flag '||X_On_Line_Flag ||' Database on_line_flag '||Recinfo.on_line_flag);
270: END IF;

Line 269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_line_flag '||X_On_Line_Flag ||' Database on_line_flag '||Recinfo.on_line_flag);

265: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
266: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
267: END IF;
268: IF (NVL(TRIM(X_On_Line_Flag),'-999') <> NVL( TRIM(Recinfo.on_line_flag),'-999')) THEN
269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_line_flag '||X_On_Line_Flag ||' Database on_line_flag '||Recinfo.on_line_flag);
270: END IF;
271: IF (NVL(TRIM(X_Preliminary_Research_Flag),'-999') <> NVL( TRIM(Recinfo.preliminary_research_flag),'-999')) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preliminary_research_flag '||X_Preliminary_Research_Flag ||' Database preliminary_research_flag '||Recinfo.preliminary_research_flag);
273: END IF;

Line 272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preliminary_research_flag '||X_Preliminary_Research_Flag ||' Database preliminary_research_flag '||Recinfo.preliminary_research_flag);

268: IF (NVL(TRIM(X_On_Line_Flag),'-999') <> NVL( TRIM(Recinfo.on_line_flag),'-999')) THEN
269: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form on_line_flag '||X_On_Line_Flag ||' Database on_line_flag '||Recinfo.on_line_flag);
270: END IF;
271: IF (NVL(TRIM(X_Preliminary_Research_Flag),'-999') <> NVL( TRIM(Recinfo.preliminary_research_flag),'-999')) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preliminary_research_flag '||X_Preliminary_Research_Flag ||' Database preliminary_research_flag '||Recinfo.preliminary_research_flag);
273: END IF;
274: IF (NVL(TRIM(X_Research_Complete_Flag),'-999') <> NVL( TRIM(Recinfo.research_complete_flag),'-999')) THEN
275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form research_complete_flag '||X_Research_Complete_Flag ||' Database research_complete_flag '||Recinfo.research_complete_flag);
276: END IF;

Line 275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form research_complete_flag '||X_Research_Complete_Flag ||' Database research_complete_flag '||Recinfo.research_complete_flag);

271: IF (NVL(TRIM(X_Preliminary_Research_Flag),'-999') <> NVL( TRIM(Recinfo.preliminary_research_flag),'-999')) THEN
272: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preliminary_research_flag '||X_Preliminary_Research_Flag ||' Database preliminary_research_flag '||Recinfo.preliminary_research_flag);
273: END IF;
274: IF (NVL(TRIM(X_Research_Complete_Flag),'-999') <> NVL( TRIM(Recinfo.research_complete_flag),'-999')) THEN
275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form research_complete_flag '||X_Research_Complete_Flag ||' Database research_complete_flag '||Recinfo.research_complete_flag);
276: END IF;
277: IF (NVL(TRIM(X_Preparer_Finished_Flag),'-999') <> NVL( TRIM(Recinfo.preparer_finished_flag),'-999')) THEN
278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_flag '||X_Preparer_Finished_Flag ||' Database preparer_finished_flag '||Recinfo.preparer_finished_flag);
279: END IF;

Line 278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_flag '||X_Preparer_Finished_Flag ||' Database preparer_finished_flag '||Recinfo.preparer_finished_flag);

274: IF (NVL(TRIM(X_Research_Complete_Flag),'-999') <> NVL( TRIM(Recinfo.research_complete_flag),'-999')) THEN
275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form research_complete_flag '||X_Research_Complete_Flag ||' Database research_complete_flag '||Recinfo.research_complete_flag);
276: END IF;
277: IF (NVL(TRIM(X_Preparer_Finished_Flag),'-999') <> NVL( TRIM(Recinfo.preparer_finished_flag),'-999')) THEN
278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_flag '||X_Preparer_Finished_Flag ||' Database preparer_finished_flag '||Recinfo.preparer_finished_flag);
279: END IF;
280: IF (X_Preparer_Finished_Date <> Recinfo.preparer_finished_date ) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_date '||X_Preparer_Finished_Date ||' Database preparer_finished_date '||Recinfo.preparer_finished_date);
282: END IF;

Line 281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_date '||X_Preparer_Finished_Date ||' Database preparer_finished_date '||Recinfo.preparer_finished_date);

277: IF (NVL(TRIM(X_Preparer_Finished_Flag),'-999') <> NVL( TRIM(Recinfo.preparer_finished_flag),'-999')) THEN
278: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_flag '||X_Preparer_Finished_Flag ||' Database preparer_finished_flag '||Recinfo.preparer_finished_flag);
279: END IF;
280: IF (X_Preparer_Finished_Date <> Recinfo.preparer_finished_date ) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_date '||X_Preparer_Finished_Date ||' Database preparer_finished_date '||Recinfo.preparer_finished_date);
282: END IF;
283: IF (NVL(TRIM(X_Agent_Return_Flag),'-999') <> NVL( TRIM(Recinfo.agent_return_flag),'-999')) THEN
284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_flag '||X_Agent_Return_Flag ||' Database agent_return_flag '||Recinfo.agent_return_flag);
285: END IF;

Line 284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_flag '||X_Agent_Return_Flag ||' Database agent_return_flag '||Recinfo.agent_return_flag);

280: IF (X_Preparer_Finished_Date <> Recinfo.preparer_finished_date ) THEN
281: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preparer_finished_date '||X_Preparer_Finished_Date ||' Database preparer_finished_date '||Recinfo.preparer_finished_date);
282: END IF;
283: IF (NVL(TRIM(X_Agent_Return_Flag),'-999') <> NVL( TRIM(Recinfo.agent_return_flag),'-999')) THEN
284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_flag '||X_Agent_Return_Flag ||' Database agent_return_flag '||Recinfo.agent_return_flag);
285: END IF;
286: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
287: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
288: END IF;

Line 287: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);

283: IF (NVL(TRIM(X_Agent_Return_Flag),'-999') <> NVL( TRIM(Recinfo.agent_return_flag),'-999')) THEN
284: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_flag '||X_Agent_Return_Flag ||' Database agent_return_flag '||Recinfo.agent_return_flag);
285: END IF;
286: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
287: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
288: END IF;
289: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
291: END IF;

Line 290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);

286: IF (NVL(TRIM(X_Agent_Return_Note),'-999') <> NVL( TRIM(Recinfo.agent_return_note),'-999')) THEN
287: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form agent_return_note '||X_Agent_Return_Note ||' Database agent_return_note '||Recinfo.agent_return_note);
288: END IF;
289: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
291: END IF;
292: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
294: END IF;

Line 293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);

289: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
290: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_flag '||X_Cancel_Flag ||' Database cancel_flag '||Recinfo.cancel_flag);
291: END IF;
292: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
294: END IF;
295: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
297: END IF;

Line 296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);

292: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
293: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
294: END IF;
295: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
297: END IF;
298: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
300: END IF;

Line 299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);

295: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
296: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
297: END IF;
298: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
300: END IF;
301: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
303: END IF;

Line 302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);

298: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
299: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
300: END IF;
301: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
303: END IF;
304: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
305: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
306: END IF;

Line 305: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);

301: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
302: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
303: END IF;
304: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
305: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
306: END IF;
307: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
309: END IF;

Line 308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);

304: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
305: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
306: END IF;
307: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
309: END IF;
310: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
311: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
312: END IF;

Line 311: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);

307: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
308: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
309: END IF;
310: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
311: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
312: END IF;
313: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
315: END IF;

Line 314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);

310: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
311: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
312: END IF;
313: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
315: END IF;
316: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
317: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
318: END IF;

Line 317: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);

313: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
314: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
315: END IF;
316: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
317: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
318: END IF;
319: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
321: END IF;

Line 320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);

316: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
317: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
318: END IF;
319: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
321: END IF;
322: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form government_context '||X_Government_Context ||' Database government_context '||Recinfo.government_context);
324: END IF;

Line 323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form government_context '||X_Government_Context ||' Database government_context '||Recinfo.government_context);

319: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
320: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
321: END IF;
322: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form government_context '||X_Government_Context ||' Database government_context '||Recinfo.government_context);
324: END IF;
325: IF (NVL(TRIM(X_Interface_Source_Code),'-999') <> NVL( TRIM(Recinfo.interface_source_code),'-999')) THEN
326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_code '||X_Interface_Source_Code ||' Database interface_source_code '||Recinfo.interface_source_code);
327: END IF;

Line 326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_code '||X_Interface_Source_Code ||' Database interface_source_code '||Recinfo.interface_source_code);

322: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
323: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form government_context '||X_Government_Context ||' Database government_context '||Recinfo.government_context);
324: END IF;
325: IF (NVL(TRIM(X_Interface_Source_Code),'-999') <> NVL( TRIM(Recinfo.interface_source_code),'-999')) THEN
326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_code '||X_Interface_Source_Code ||' Database interface_source_code '||Recinfo.interface_source_code);
327: END IF;
328: IF (NVL(X_Interface_Source_Line_Id,-999) <> NVL(Recinfo.interface_source_line_id,-999)) THEN
329: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_line_id'||X_Interface_Source_Line_Id ||' Database interface_source_line_id '|| Recinfo.interface_source_line_id);
330: END IF;

Line 329: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_line_id'||X_Interface_Source_Line_Id ||' Database interface_source_line_id '|| Recinfo.interface_source_line_id);

325: IF (NVL(TRIM(X_Interface_Source_Code),'-999') <> NVL( TRIM(Recinfo.interface_source_code),'-999')) THEN
326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_code '||X_Interface_Source_Code ||' Database interface_source_code '||Recinfo.interface_source_code);
327: END IF;
328: IF (NVL(X_Interface_Source_Line_Id,-999) <> NVL(Recinfo.interface_source_line_id,-999)) THEN
329: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_line_id'||X_Interface_Source_Line_Id ||' Database interface_source_line_id '|| Recinfo.interface_source_line_id);
330: END IF;
331: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);
333: END IF;

Line 332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);

328: IF (NVL(X_Interface_Source_Line_Id,-999) <> NVL(Recinfo.interface_source_line_id,-999)) THEN
329: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form interface_source_line_id'||X_Interface_Source_Line_Id ||' Database interface_source_line_id '|| Recinfo.interface_source_line_id);
330: END IF;
331: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_code '||X_Closed_Code ||' Database closed_code '||Recinfo.closed_code);
333: END IF;
334: END IF;
335: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
336: APP_EXCEPTION.RAISE_EXCEPTION;