eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_DISTRIBUTIONS_PKG2 dependencies on FND_LOG

Line 101: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','lock rows');

97: -- For debug purposes(lswamy)
98: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
99: BEGIN
100: IF (g_fnd_debug = 'Y') THEN
101: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','lock rows');
102: END IF;
103: OPEN C;
104: FETCH C INTO Recinfo;
105: if (C%NOTFOUND) then

Line 353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','no lock error');

349:
350:
351: THEN
352: IF (g_fnd_debug = 'Y') THEN
353: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','no lock error');
354: END IF;
355:
356: return;
357:

Line 370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Distribution_Id '||X_Po_Distribution_Id ||' Database Po_Distribution_Id '||Recinfo.Po_Distribution_Id);

366: IF (g_fnd_debug = 'Y') THEN
367:
368:
369: if (nvl(X_Po_Distribution_Id,-999) <> nvl(Recinfo.Po_Distribution_Id,-999) ) then
370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Distribution_Id '||X_Po_Distribution_Id ||' Database Po_Distribution_Id '||Recinfo.Po_Distribution_Id);
371: end if;
372: if (nvl(X_Po_Header_Id ,-999) <> nvl(Recinfo.Po_Header_Id,-999) ) then
373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Header_Id '||X_Po_Header_Id ||' Database Po_Header_Id '||Recinfo.Po_Header_Id);
374: end if;

Line 373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Header_Id '||X_Po_Header_Id ||' Database Po_Header_Id '||Recinfo.Po_Header_Id);

369: if (nvl(X_Po_Distribution_Id,-999) <> nvl(Recinfo.Po_Distribution_Id,-999) ) then
370: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Distribution_Id '||X_Po_Distribution_Id ||' Database Po_Distribution_Id '||Recinfo.Po_Distribution_Id);
371: end if;
372: if (nvl(X_Po_Header_Id ,-999) <> nvl(Recinfo.Po_Header_Id,-999) ) then
373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Header_Id '||X_Po_Header_Id ||' Database Po_Header_Id '||Recinfo.Po_Header_Id);
374: end if;
375: if (nvl(X_Po_Line_Id,-999) <> nvl(Recinfo.Po_Line_Id,-999)) then
376: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Line_Id '||X_Po_Line_Id||' Database Po_Line_Id '||Recinfo.Po_Line_Id);
377: end if;

Line 376: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Line_Id '||X_Po_Line_Id||' Database Po_Line_Id '||Recinfo.Po_Line_Id);

372: if (nvl(X_Po_Header_Id ,-999) <> nvl(Recinfo.Po_Header_Id,-999) ) then
373: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Header_Id '||X_Po_Header_Id ||' Database Po_Header_Id '||Recinfo.Po_Header_Id);
374: end if;
375: if (nvl(X_Po_Line_Id,-999) <> nvl(Recinfo.Po_Line_Id,-999)) then
376: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Line_Id '||X_Po_Line_Id||' Database Po_Line_Id '||Recinfo.Po_Line_Id);
377: end if;
378: if (nvl(X_Line_Location_Id ,-999) <> nvl( Recinfo.Line_Location_Id,-999)) then
379: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Location_Id '||X_Line_Location_Id ||' Database Line_Location_Id '||Recinfo.Line_Location_Id);
380: end if;

Line 379: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Location_Id '||X_Line_Location_Id ||' Database Line_Location_Id '||Recinfo.Line_Location_Id);

375: if (nvl(X_Po_Line_Id,-999) <> nvl(Recinfo.Po_Line_Id,-999)) then
376: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Line_Id '||X_Po_Line_Id||' Database Po_Line_Id '||Recinfo.Po_Line_Id);
377: end if;
378: if (nvl(X_Line_Location_Id ,-999) <> nvl( Recinfo.Line_Location_Id,-999)) then
379: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Location_Id '||X_Line_Location_Id ||' Database Line_Location_Id '||Recinfo.Line_Location_Id);
380: end if;
381: if (nvl(X_Set_Of_Books_Id,-999) <> nvl( Recinfo.Set_Of_Books_Id,-999)) then
382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Set_Of_Books_Id '||X_Set_Of_Books_Id ||' Database Set_Of_Books_Id '||Recinfo.Set_Of_Books_Id);
383: end if;

Line 382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Set_Of_Books_Id '||X_Set_Of_Books_Id ||' Database Set_Of_Books_Id '||Recinfo.Set_Of_Books_Id);

378: if (nvl(X_Line_Location_Id ,-999) <> nvl( Recinfo.Line_Location_Id,-999)) then
379: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Location_Id '||X_Line_Location_Id ||' Database Line_Location_Id '||Recinfo.Line_Location_Id);
380: end if;
381: if (nvl(X_Set_Of_Books_Id,-999) <> nvl( Recinfo.Set_Of_Books_Id,-999)) then
382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Set_Of_Books_Id '||X_Set_Of_Books_Id ||' Database Set_Of_Books_Id '||Recinfo.Set_Of_Books_Id);
383: end if;
384: if (nvl(X_Code_Combination_Id,-999) <> nvl( Recinfo.Code_Combination_Id,-999)) then
385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Code_Combination_Id '||X_Code_Combination_Id ||' Database Code_Combination_Id '||Recinfo.Code_Combination_Id);
386: end if;

Line 385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Code_Combination_Id '||X_Code_Combination_Id ||' Database Code_Combination_Id '||Recinfo.Code_Combination_Id);

381: if (nvl(X_Set_Of_Books_Id,-999) <> nvl( Recinfo.Set_Of_Books_Id,-999)) then
382: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Set_Of_Books_Id '||X_Set_Of_Books_Id ||' Database Set_Of_Books_Id '||Recinfo.Set_Of_Books_Id);
383: end if;
384: if (nvl(X_Code_Combination_Id,-999) <> nvl( Recinfo.Code_Combination_Id,-999)) then
385: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Code_Combination_Id '||X_Code_Combination_Id ||' Database Code_Combination_Id '||Recinfo.Code_Combination_Id);
386: end if;
387:
388: po_wf_debug_pkg.insert_Debug('lak','lak','foloing should fail 1');
389: if (nvl(X_Quantity_Ordered ,-999) <> nvl( Recinfo.Quantity_Ordered ,-999)) then

Line 391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Quantity_Ordered '||X_Quantity_Ordered ||' Database Quantity_Ordered '||Recinfo.Quantity_Ordered);

387:
388: po_wf_debug_pkg.insert_Debug('lak','lak','foloing should fail 1');
389: if (nvl(X_Quantity_Ordered ,-999) <> nvl( Recinfo.Quantity_Ordered ,-999)) then
390: po_wf_debug_pkg.insert_Debug('lak','lak','foloing should fail 5');
391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Quantity_Ordered '||X_Quantity_Ordered ||' Database Quantity_Ordered '||Recinfo.Quantity_Ordered);
392: end if;
393: if (nvl(X_Po_Release_Id ,-999) <> nvl( Recinfo.Po_Release_Id ,-999)) then
394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Release_Id '||X_Po_Release_Id ||' Database Po_Release_Id '||Recinfo.Po_Release_Id);
395: end if;

Line 394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Release_Id '||X_Po_Release_Id ||' Database Po_Release_Id '||Recinfo.Po_Release_Id);

390: po_wf_debug_pkg.insert_Debug('lak','lak','foloing should fail 5');
391: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Quantity_Ordered '||X_Quantity_Ordered ||' Database Quantity_Ordered '||Recinfo.Quantity_Ordered);
392: end if;
393: if (nvl(X_Po_Release_Id ,-999) <> nvl( Recinfo.Po_Release_Id ,-999)) then
394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Release_Id '||X_Po_Release_Id ||' Database Po_Release_Id '||Recinfo.Po_Release_Id);
395: end if;
396: if (nvl(X_Req_Header_Reference_Num,-999) <> nvl( Recinfo.Req_Header_Reference_Num,-999)) then
397: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Header_Reference_Num '||X_Req_Header_Reference_Num ||' Database Req_Header_Reference_Num '||Recinfo.Req_Header_Reference_Num);
398: end if;

Line 397: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Header_Reference_Num '||X_Req_Header_Reference_Num ||' Database Req_Header_Reference_Num '||Recinfo.Req_Header_Reference_Num);

393: if (nvl(X_Po_Release_Id ,-999) <> nvl( Recinfo.Po_Release_Id ,-999)) then
394: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Po_Release_Id '||X_Po_Release_Id ||' Database Po_Release_Id '||Recinfo.Po_Release_Id);
395: end if;
396: if (nvl(X_Req_Header_Reference_Num,-999) <> nvl( Recinfo.Req_Header_Reference_Num,-999)) then
397: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Header_Reference_Num '||X_Req_Header_Reference_Num ||' Database Req_Header_Reference_Num '||Recinfo.Req_Header_Reference_Num);
398: end if;
399: if (nvl(X_Req_Line_Reference_Num,-999) <> nvl( Recinfo.Req_Line_Reference_Num,-999)) then
400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Line_Reference_Num '||X_Req_Line_Reference_Num ||' Database Req_Line_Reference_Num '||Recinfo.Req_Line_Reference_Num);
401: end if;

Line 400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Line_Reference_Num '||X_Req_Line_Reference_Num ||' Database Req_Line_Reference_Num '||Recinfo.Req_Line_Reference_Num);

396: if (nvl(X_Req_Header_Reference_Num,-999) <> nvl( Recinfo.Req_Header_Reference_Num,-999)) then
397: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Header_Reference_Num '||X_Req_Header_Reference_Num ||' Database Req_Header_Reference_Num '||Recinfo.Req_Header_Reference_Num);
398: end if;
399: if (nvl(X_Req_Line_Reference_Num,-999) <> nvl( Recinfo.Req_Line_Reference_Num,-999)) then
400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Line_Reference_Num '||X_Req_Line_Reference_Num ||' Database Req_Line_Reference_Num '||Recinfo.Req_Line_Reference_Num);
401: end if;
402: if (nvl(X_Req_Distribution_Id,-999) <> nvl( Recinfo.Req_Distribution_Id,-999)) then
403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Distribution_Id '||X_Req_Distribution_Id ||' Database Req_Distribution_Id '||Recinfo.Req_Distribution_Id);
404: end if;

Line 403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Distribution_Id '||X_Req_Distribution_Id ||' Database Req_Distribution_Id '||Recinfo.Req_Distribution_Id);

399: if (nvl(X_Req_Line_Reference_Num,-999) <> nvl( Recinfo.Req_Line_Reference_Num,-999)) then
400: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Line_Reference_Num '||X_Req_Line_Reference_Num ||' Database Req_Line_Reference_Num '||Recinfo.Req_Line_Reference_Num);
401: end if;
402: if (nvl(X_Req_Distribution_Id,-999) <> nvl( Recinfo.Req_Distribution_Id,-999)) then
403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Distribution_Id '||X_Req_Distribution_Id ||' Database Req_Distribution_Id '||Recinfo.Req_Distribution_Id);
404: end if;
405: if (nvl(X_Deliver_To_Location_Id,-999) <> nvl( Recinfo.Deliver_To_Location_Id ,-999)) then
406: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Location_Id '||X_Deliver_To_Location_Id ||' Database Deliver_To_Location_Id '||Recinfo.Deliver_To_Location_Id);
407: end if;

Line 406: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Location_Id '||X_Deliver_To_Location_Id ||' Database Deliver_To_Location_Id '||Recinfo.Deliver_To_Location_Id);

402: if (nvl(X_Req_Distribution_Id,-999) <> nvl( Recinfo.Req_Distribution_Id,-999)) then
403: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Req_Distribution_Id '||X_Req_Distribution_Id ||' Database Req_Distribution_Id '||Recinfo.Req_Distribution_Id);
404: end if;
405: if (nvl(X_Deliver_To_Location_Id,-999) <> nvl( Recinfo.Deliver_To_Location_Id ,-999)) then
406: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Location_Id '||X_Deliver_To_Location_Id ||' Database Deliver_To_Location_Id '||Recinfo.Deliver_To_Location_Id);
407: end if;
408: if (nvl(X_Deliver_To_Person_Id,-999) <> nvl( Recinfo.Deliver_To_Person_Id,-999)) then
409: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Person_Id '||X_Deliver_To_Person_Id ||' Database Deliver_To_Person_Id '||Recinfo.Deliver_To_Person_Id);
410: end if;

Line 409: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Person_Id '||X_Deliver_To_Person_Id ||' Database Deliver_To_Person_Id '||Recinfo.Deliver_To_Person_Id);

405: if (nvl(X_Deliver_To_Location_Id,-999) <> nvl( Recinfo.Deliver_To_Location_Id ,-999)) then
406: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Location_Id '||X_Deliver_To_Location_Id ||' Database Deliver_To_Location_Id '||Recinfo.Deliver_To_Location_Id);
407: end if;
408: if (nvl(X_Deliver_To_Person_Id,-999) <> nvl( Recinfo.Deliver_To_Person_Id,-999)) then
409: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Person_Id '||X_Deliver_To_Person_Id ||' Database Deliver_To_Person_Id '||Recinfo.Deliver_To_Person_Id);
410: end if;
411: if (trunc(X_Rate_Date) <> trunc(Recinfo.Rate_Date) ) then
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate_Date '||X_Rate_Date ||' Database Rate_Date '||Recinfo.Rate_Date);
413: end if;

Line 412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate_Date '||X_Rate_Date ||' Database Rate_Date '||Recinfo.Rate_Date);

408: if (nvl(X_Deliver_To_Person_Id,-999) <> nvl( Recinfo.Deliver_To_Person_Id,-999)) then
409: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Deliver_To_Person_Id '||X_Deliver_To_Person_Id ||' Database Deliver_To_Person_Id '||Recinfo.Deliver_To_Person_Id);
410: end if;
411: if (trunc(X_Rate_Date) <> trunc(Recinfo.Rate_Date) ) then
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate_Date '||X_Rate_Date ||' Database Rate_Date '||Recinfo.Rate_Date);
413: end if;
414: if (nvl(X_Rate,-999) <> nvl(Recinfo.Rate,-999)) then
415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_Rate ||' Database Rate '||Recinfo.Rate);
416: end if;

Line 415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_Rate ||' Database Rate '||Recinfo.Rate);

411: if (trunc(X_Rate_Date) <> trunc(Recinfo.Rate_Date) ) then
412: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate_Date '||X_Rate_Date ||' Database Rate_Date '||Recinfo.Rate_Date);
413: end if;
414: if (nvl(X_Rate,-999) <> nvl(Recinfo.Rate,-999)) then
415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_Rate ||' Database Rate '||Recinfo.Rate);
416: end if;
417: if (nvl(X_Amount_Billed,-999) <> nvl(Recinfo.Amount_Billed,-999)) then
418: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Amount_Billed '||X_Amount_Billed ||' Database Amount_Billed '||Recinfo.Amount_Billed);
419: end if;

Line 418: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Amount_Billed '||X_Amount_Billed ||' Database Amount_Billed '||Recinfo.Amount_Billed);

414: if (nvl(X_Rate,-999) <> nvl(Recinfo.Rate,-999)) then
415: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_Rate ||' Database Rate '||Recinfo.Rate);
416: end if;
417: if (nvl(X_Amount_Billed,-999) <> nvl(Recinfo.Amount_Billed,-999)) then
418: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Amount_Billed '||X_Amount_Billed ||' Database Amount_Billed '||Recinfo.Amount_Billed);
419: end if;
420: if (nvl(X_Accrued_Flag,'-999') <> nvl(Recinfo.Accrued_Flag,'-999')) then
421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrued_Flag '||X_Accrued_Flag ||' Database Accrued_Flag '||Recinfo.Accrued_Flag);
422: end if;

Line 421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrued_Flag '||X_Accrued_Flag ||' Database Accrued_Flag '||Recinfo.Accrued_Flag);

417: if (nvl(X_Amount_Billed,-999) <> nvl(Recinfo.Amount_Billed,-999)) then
418: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Amount_Billed '||X_Amount_Billed ||' Database Amount_Billed '||Recinfo.Amount_Billed);
419: end if;
420: if (nvl(X_Accrued_Flag,'-999') <> nvl(Recinfo.Accrued_Flag,'-999')) then
421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrued_Flag '||X_Accrued_Flag ||' Database Accrued_Flag '||Recinfo.Accrued_Flag);
422: end if;
423: if (nvl(X_Encumbered_Flag,'-999') <> nvl(Recinfo.Encumbered_Flag ,'-999')) then
424: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Flag '||X_Encumbered_Flag ||' Database Encumbered_Flag '||Recinfo.Encumbered_Flag);
425: end if;

Line 424: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Flag '||X_Encumbered_Flag ||' Database Encumbered_Flag '||Recinfo.Encumbered_Flag);

420: if (nvl(X_Accrued_Flag,'-999') <> nvl(Recinfo.Accrued_Flag,'-999')) then
421: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrued_Flag '||X_Accrued_Flag ||' Database Accrued_Flag '||Recinfo.Accrued_Flag);
422: end if;
423: if (nvl(X_Encumbered_Flag,'-999') <> nvl(Recinfo.Encumbered_Flag ,'-999')) then
424: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Flag '||X_Encumbered_Flag ||' Database Encumbered_Flag '||Recinfo.Encumbered_Flag);
425: end if;
426: if (nvl(X_Encumbered_Amount,-999) <> nvl(Recinfo.Encumbered_Amount,-999)) then
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Amount '||X_Encumbered_Amount ||' Database Encumbered_Amount '||Recinfo.Encumbered_Amount);
428: end if;

Line 427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Amount '||X_Encumbered_Amount ||' Database Encumbered_Amount '||Recinfo.Encumbered_Amount);

423: if (nvl(X_Encumbered_Flag,'-999') <> nvl(Recinfo.Encumbered_Flag ,'-999')) then
424: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Flag '||X_Encumbered_Flag ||' Database Encumbered_Flag '||Recinfo.Encumbered_Flag);
425: end if;
426: if (nvl(X_Encumbered_Amount,-999) <> nvl(Recinfo.Encumbered_Amount,-999)) then
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Amount '||X_Encumbered_Amount ||' Database Encumbered_Amount '||Recinfo.Encumbered_Amount);
428: end if;
429: if (nvl(X_Unencumbered_Quantity,-999) <> nvl(Recinfo.Unencumbered_Quantity,-999)) then
430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Quantity '||X_Unencumbered_Quantity ||' Database Unencumbered_Quantity '||Recinfo.Unencumbered_Quantity);
431: end if;

Line 430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Quantity '||X_Unencumbered_Quantity ||' Database Unencumbered_Quantity '||Recinfo.Unencumbered_Quantity);

426: if (nvl(X_Encumbered_Amount,-999) <> nvl(Recinfo.Encumbered_Amount,-999)) then
427: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Encumbered_Amount '||X_Encumbered_Amount ||' Database Encumbered_Amount '||Recinfo.Encumbered_Amount);
428: end if;
429: if (nvl(X_Unencumbered_Quantity,-999) <> nvl(Recinfo.Unencumbered_Quantity,-999)) then
430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Quantity '||X_Unencumbered_Quantity ||' Database Unencumbered_Quantity '||Recinfo.Unencumbered_Quantity);
431: end if;
432: if (nvl(X_Unencumbered_Amount,-999) <> nvl(Recinfo.Unencumbered_Amount,-999)) then
433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Amount '||X_Unencumbered_Amount ||' Database Unencumbered_Amount '||Recinfo.Unencumbered_Amount);
434: end if;

Line 433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Amount '||X_Unencumbered_Amount ||' Database Unencumbered_Amount '||Recinfo.Unencumbered_Amount);

429: if (nvl(X_Unencumbered_Quantity,-999) <> nvl(Recinfo.Unencumbered_Quantity,-999)) then
430: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Quantity '||X_Unencumbered_Quantity ||' Database Unencumbered_Quantity '||Recinfo.Unencumbered_Quantity);
431: end if;
432: if (nvl(X_Unencumbered_Amount,-999) <> nvl(Recinfo.Unencumbered_Amount,-999)) then
433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Amount '||X_Unencumbered_Amount ||' Database Unencumbered_Amount '||Recinfo.Unencumbered_Amount);
434: end if;
435: if (nvl(X_Failed_Funds_Lookup_Code,'-999') <> nvl(Recinfo.Failed_Funds_Lookup_Code,'-999')) then
436: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Failed_Funds_Lookup_Code '||X_Failed_Funds_Lookup_Code ||' Database Failed_Funds_Lookup_Code '||Recinfo.Failed_Funds_Lookup_Code);
437: end if;

Line 436: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Failed_Funds_Lookup_Code '||X_Failed_Funds_Lookup_Code ||' Database Failed_Funds_Lookup_Code '||Recinfo.Failed_Funds_Lookup_Code);

432: if (nvl(X_Unencumbered_Amount,-999) <> nvl(Recinfo.Unencumbered_Amount,-999)) then
433: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Unencumbered_Amount '||X_Unencumbered_Amount ||' Database Unencumbered_Amount '||Recinfo.Unencumbered_Amount);
434: end if;
435: if (nvl(X_Failed_Funds_Lookup_Code,'-999') <> nvl(Recinfo.Failed_Funds_Lookup_Code,'-999')) then
436: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Failed_Funds_Lookup_Code '||X_Failed_Funds_Lookup_Code ||' Database Failed_Funds_Lookup_Code '||Recinfo.Failed_Funds_Lookup_Code);
437: end if;
438: if ( trunc(X_Gl_Encumbered_Date) <> trunc(Recinfo.Gl_Encumbered_Date) ) then
439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Date '||X_Gl_Encumbered_Date ||' Database Gl_Encumbered_Date '||Recinfo.Gl_Encumbered_Date);
440: end if;

Line 439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Date '||X_Gl_Encumbered_Date ||' Database Gl_Encumbered_Date '||Recinfo.Gl_Encumbered_Date);

435: if (nvl(X_Failed_Funds_Lookup_Code,'-999') <> nvl(Recinfo.Failed_Funds_Lookup_Code,'-999')) then
436: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Failed_Funds_Lookup_Code '||X_Failed_Funds_Lookup_Code ||' Database Failed_Funds_Lookup_Code '||Recinfo.Failed_Funds_Lookup_Code);
437: end if;
438: if ( trunc(X_Gl_Encumbered_Date) <> trunc(Recinfo.Gl_Encumbered_Date) ) then
439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Date '||X_Gl_Encumbered_Date ||' Database Gl_Encumbered_Date '||Recinfo.Gl_Encumbered_Date);
440: end if;
441: if (nvl(X_Gl_Encumbered_Period_Name,'-999') <> nvl(Recinfo.Gl_Encumbered_Period_Name,'-999')) then
442: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Period_Name '||X_Gl_Encumbered_Period_Name ||' Database Gl_Encumbered_Period_Name '||Recinfo.Gl_Encumbered_Period_Name);
443: end if;

Line 442: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Period_Name '||X_Gl_Encumbered_Period_Name ||' Database Gl_Encumbered_Period_Name '||Recinfo.Gl_Encumbered_Period_Name);

438: if ( trunc(X_Gl_Encumbered_Date) <> trunc(Recinfo.Gl_Encumbered_Date) ) then
439: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Date '||X_Gl_Encumbered_Date ||' Database Gl_Encumbered_Date '||Recinfo.Gl_Encumbered_Date);
440: end if;
441: if (nvl(X_Gl_Encumbered_Period_Name,'-999') <> nvl(Recinfo.Gl_Encumbered_Period_Name,'-999')) then
442: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Period_Name '||X_Gl_Encumbered_Period_Name ||' Database Gl_Encumbered_Period_Name '||Recinfo.Gl_Encumbered_Period_Name);
443: end if;
444: if ( trunc(X_Gl_Cancelled_Date) <> trunc(Recinfo.Gl_Cancelled_Date) ) then
445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Cancelled_Date '||X_Gl_Cancelled_Date ||' Database Gl_Cancelled_Date '||Recinfo.Gl_Cancelled_Date);
446: end if;

Line 445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Cancelled_Date '||X_Gl_Cancelled_Date ||' Database Gl_Cancelled_Date '||Recinfo.Gl_Cancelled_Date);

441: if (nvl(X_Gl_Encumbered_Period_Name,'-999') <> nvl(Recinfo.Gl_Encumbered_Period_Name,'-999')) then
442: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Encumbered_Period_Name '||X_Gl_Encumbered_Period_Name ||' Database Gl_Encumbered_Period_Name '||Recinfo.Gl_Encumbered_Period_Name);
443: end if;
444: if ( trunc(X_Gl_Cancelled_Date) <> trunc(Recinfo.Gl_Cancelled_Date) ) then
445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Cancelled_Date '||X_Gl_Cancelled_Date ||' Database Gl_Cancelled_Date '||Recinfo.Gl_Cancelled_Date);
446: end if;
447: if (nvl(X_Destination_Type_Code,'-999') <> nvl(Recinfo.Destination_Type_Code,'-999')) then
448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Type_Code '||X_Destination_Type_Code ||' Database Destination_Type_Code '||Recinfo.Destination_Type_Code);
449: end if;

Line 448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Type_Code '||X_Destination_Type_Code ||' Database Destination_Type_Code '||Recinfo.Destination_Type_Code);

444: if ( trunc(X_Gl_Cancelled_Date) <> trunc(Recinfo.Gl_Cancelled_Date) ) then
445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Cancelled_Date '||X_Gl_Cancelled_Date ||' Database Gl_Cancelled_Date '||Recinfo.Gl_Cancelled_Date);
446: end if;
447: if (nvl(X_Destination_Type_Code,'-999') <> nvl(Recinfo.Destination_Type_Code,'-999')) then
448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Type_Code '||X_Destination_Type_Code ||' Database Destination_Type_Code '||Recinfo.Destination_Type_Code);
449: end if;
450: if (nvl(X_Destination_Organization_Id,-999) <> nvl(Recinfo.Destination_Organization_Id,-999)) then
451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Organization_Id '||X_Destination_Organization_Id ||' Database Destination_Organization_Id '||Recinfo.Destination_Organization_Id);
452: end if;

Line 451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Organization_Id '||X_Destination_Organization_Id ||' Database Destination_Organization_Id '||Recinfo.Destination_Organization_Id);

447: if (nvl(X_Destination_Type_Code,'-999') <> nvl(Recinfo.Destination_Type_Code,'-999')) then
448: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Type_Code '||X_Destination_Type_Code ||' Database Destination_Type_Code '||Recinfo.Destination_Type_Code);
449: end if;
450: if (nvl(X_Destination_Organization_Id,-999) <> nvl(Recinfo.Destination_Organization_Id,-999)) then
451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Organization_Id '||X_Destination_Organization_Id ||' Database Destination_Organization_Id '||Recinfo.Destination_Organization_Id);
452: end if;
453: if (nvl(X_Destination_Subinventory,'-999') <> nvl(Recinfo.Destination_Subinventory,'-999')) then
454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Subinventory '||X_Destination_Subinventory ||' Database Destination_Subinventory '||Recinfo.Destination_Subinventory);
455: end if;

Line 454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Subinventory '||X_Destination_Subinventory ||' Database Destination_Subinventory '||Recinfo.Destination_Subinventory);

450: if (nvl(X_Destination_Organization_Id,-999) <> nvl(Recinfo.Destination_Organization_Id,-999)) then
451: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Organization_Id '||X_Destination_Organization_Id ||' Database Destination_Organization_Id '||Recinfo.Destination_Organization_Id);
452: end if;
453: if (nvl(X_Destination_Subinventory,'-999') <> nvl(Recinfo.Destination_Subinventory,'-999')) then
454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Subinventory '||X_Destination_Subinventory ||' Database Destination_Subinventory '||Recinfo.Destination_Subinventory);
455: end if;
456: if (nvl(X_Attribute_Category,'-999') <> nvl( Recinfo.Attribute_Category,'-999')) then
457: 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);
458: end if;

Line 457: 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);

453: if (nvl(X_Destination_Subinventory,'-999') <> nvl(Recinfo.Destination_Subinventory,'-999')) then
454: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Subinventory '||X_Destination_Subinventory ||' Database Destination_Subinventory '||Recinfo.Destination_Subinventory);
455: end if;
456: if (nvl(X_Attribute_Category,'-999') <> nvl( Recinfo.Attribute_Category,'-999')) then
457: 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);
458: end if;
459: if (nvl(X_Attribute1,'-999') <> nvl( Recinfo.Attribute1,'-999')) then
460: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
461: end if;

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

456: if (nvl(X_Attribute_Category,'-999') <> nvl( Recinfo.Attribute_Category,'-999')) then
457: 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);
458: end if;
459: if (nvl(X_Attribute1,'-999') <> nvl( Recinfo.Attribute1,'-999')) then
460: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
461: end if;
462: if (nvl(X_Attribute2,'-999') <> nvl( Recinfo.Attribute2,'-999')) then
463: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
464: end if;

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

459: if (nvl(X_Attribute1,'-999') <> nvl( Recinfo.Attribute1,'-999')) then
460: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
461: end if;
462: if (nvl(X_Attribute2,'-999') <> nvl( Recinfo.Attribute2,'-999')) then
463: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
464: end if;
465: if (nvl(X_Attribute3,'-999') <> nvl( Recinfo.Attribute3,'-999')) then
466: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
467: end if;

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

462: if (nvl(X_Attribute2,'-999') <> nvl( Recinfo.Attribute2,'-999')) then
463: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
464: end if;
465: if (nvl(X_Attribute3,'-999') <> nvl( Recinfo.Attribute3,'-999')) then
466: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
467: end if;
468: if (nvl(X_Attribute4,'-999') <> nvl( Recinfo.Attribute4,'-999')) then
469: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
470: end if;

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

465: if (nvl(X_Attribute3,'-999') <> nvl( Recinfo.Attribute3,'-999')) then
466: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
467: end if;
468: if (nvl(X_Attribute4,'-999') <> nvl( Recinfo.Attribute4,'-999')) then
469: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
470: end if;
471: if (nvl(X_Attribute5,'-999') <> nvl( Recinfo.Attribute5,'-999')) then
472: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
473: end if;

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

468: if (nvl(X_Attribute4,'-999') <> nvl( Recinfo.Attribute4,'-999')) then
469: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
470: end if;
471: if (nvl(X_Attribute5,'-999') <> nvl( Recinfo.Attribute5,'-999')) then
472: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
473: end if;
474: if (nvl(X_Attribute6,'-999') <> nvl( Recinfo.Attribute6,'-999')) then
475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
476: end if;

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

471: if (nvl(X_Attribute5,'-999') <> nvl( Recinfo.Attribute5,'-999')) then
472: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
473: end if;
474: if (nvl(X_Attribute6,'-999') <> nvl( Recinfo.Attribute6,'-999')) then
475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
476: end if;
477: if (nvl(X_Attribute7,'-999') <> nvl( Recinfo.Attribute7,'-999')) then
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
479: end if;

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

474: if (nvl(X_Attribute6,'-999') <> nvl( Recinfo.Attribute6,'-999')) then
475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
476: end if;
477: if (nvl(X_Attribute7,'-999') <> nvl( Recinfo.Attribute7,'-999')) then
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
479: end if;
480: if (nvl(X_Attribute8,'-999') <> nvl( Recinfo.Attribute8,'-999')) then
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
482: end if;

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

477: if (nvl(X_Attribute7,'-999') <> nvl( Recinfo.Attribute7,'-999')) then
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
479: end if;
480: if (nvl(X_Attribute8,'-999') <> nvl( Recinfo.Attribute8,'-999')) then
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
482: end if;
483: if (nvl(X_Attribute9,'-999') <> nvl( Recinfo.Attribute9,'-999')) then
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
485: end if;

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

480: if (nvl(X_Attribute8,'-999') <> nvl( Recinfo.Attribute8,'-999')) then
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
482: end if;
483: if (nvl(X_Attribute9,'-999') <> nvl( Recinfo.Attribute9,'-999')) then
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
485: end if;
486: if (nvl(X_Attribute10,'-999') <> nvl( Recinfo.Attribute10,'-999')) then
487: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
488: end if;

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

483: if (nvl(X_Attribute9,'-999') <> nvl( Recinfo.Attribute9,'-999')) then
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
485: end if;
486: if (nvl(X_Attribute10,'-999') <> nvl( Recinfo.Attribute10,'-999')) then
487: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
488: end if;
489: if (nvl(X_Attribute11,'-999') <> nvl( Recinfo.Attribute11,'-999')) then
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
491: end if;

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

486: if (nvl(X_Attribute10,'-999') <> nvl( Recinfo.Attribute10,'-999')) then
487: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
488: end if;
489: if (nvl(X_Attribute11,'-999') <> nvl( Recinfo.Attribute11,'-999')) then
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
491: end if;
492: if (nvl(X_Attribute12,'-999') <> nvl( Recinfo.Attribute12,'-999')) then
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
494: end if;

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

489: if (nvl(X_Attribute11,'-999') <> nvl( Recinfo.Attribute11,'-999')) then
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
491: end if;
492: if (nvl(X_Attribute12,'-999') <> nvl( Recinfo.Attribute12,'-999')) then
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
494: end if;
495: if (nvl(X_Attribute13,'-999') <> nvl( Recinfo.Attribute13,'-999')) then
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
497: end if;

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

492: if (nvl(X_Attribute12,'-999') <> nvl( Recinfo.Attribute12,'-999')) then
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
494: end if;
495: if (nvl(X_Attribute13,'-999') <> nvl( Recinfo.Attribute13,'-999')) then
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
497: end if;
498: if (nvl(X_Attribute14,'-999') <> nvl( Recinfo.Attribute14,'-999')) then
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
500: end if;

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

495: if (nvl(X_Attribute13,'-999') <> nvl( Recinfo.Attribute13,'-999')) then
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
497: end if;
498: if (nvl(X_Attribute14,'-999') <> nvl( Recinfo.Attribute14,'-999')) then
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
500: end if;
501: if (nvl(X_Attribute15,'-999') <> nvl( Recinfo.Attribute15,'-999')) then
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
503: end if;

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

498: if (nvl(X_Attribute14,'-999') <> nvl( Recinfo.Attribute14,'-999')) then
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
500: end if;
501: if (nvl(X_Attribute15,'-999') <> nvl( Recinfo.Attribute15,'-999')) then
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
503: end if;
504: if (nvl(X_Wip_Entity_Id,-999) <> nvl(Recinfo.Wip_Entity_Id,-999)) then
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Entity_Id '||X_Wip_Entity_Id ||' Database Wip_Entity_Id '||Recinfo.Wip_Entity_Id);
506: end if;

Line 505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Entity_Id '||X_Wip_Entity_Id ||' Database Wip_Entity_Id '||Recinfo.Wip_Entity_Id);

501: if (nvl(X_Attribute15,'-999') <> nvl( Recinfo.Attribute15,'-999')) then
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
503: end if;
504: if (nvl(X_Wip_Entity_Id,-999) <> nvl(Recinfo.Wip_Entity_Id,-999)) then
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Entity_Id '||X_Wip_Entity_Id ||' Database Wip_Entity_Id '||Recinfo.Wip_Entity_Id);
506: end if;
507: if (nvl(X_Wip_Operation_Seq_Num,-999) <> nvl(Recinfo.Wip_Operation_Seq_Num,-999)) then
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Operation_Seq_Num '||X_Wip_Operation_Seq_Num ||' Database Wip_Operation_Seq_Num '||Recinfo.Wip_Operation_Seq_Num);
509: end if;

Line 508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Operation_Seq_Num '||X_Wip_Operation_Seq_Num ||' Database Wip_Operation_Seq_Num '||Recinfo.Wip_Operation_Seq_Num);

504: if (nvl(X_Wip_Entity_Id,-999) <> nvl(Recinfo.Wip_Entity_Id,-999)) then
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Entity_Id '||X_Wip_Entity_Id ||' Database Wip_Entity_Id '||Recinfo.Wip_Entity_Id);
506: end if;
507: if (nvl(X_Wip_Operation_Seq_Num,-999) <> nvl(Recinfo.Wip_Operation_Seq_Num,-999)) then
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Operation_Seq_Num '||X_Wip_Operation_Seq_Num ||' Database Wip_Operation_Seq_Num '||Recinfo.Wip_Operation_Seq_Num);
509: end if;
510: if (nvl(X_Wip_Resource_Seq_Num,-999) <> nvl(Recinfo.Wip_Resource_Seq_Num,-999)) then
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Resource_Seq_Num '||X_Wip_Resource_Seq_Num ||' Database Wip_Resource_Seq_Num '||Recinfo.Wip_Resource_Seq_Num);
512: end if;

Line 511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Resource_Seq_Num '||X_Wip_Resource_Seq_Num ||' Database Wip_Resource_Seq_Num '||Recinfo.Wip_Resource_Seq_Num);

507: if (nvl(X_Wip_Operation_Seq_Num,-999) <> nvl(Recinfo.Wip_Operation_Seq_Num,-999)) then
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Operation_Seq_Num '||X_Wip_Operation_Seq_Num ||' Database Wip_Operation_Seq_Num '||Recinfo.Wip_Operation_Seq_Num);
509: end if;
510: if (nvl(X_Wip_Resource_Seq_Num,-999) <> nvl(Recinfo.Wip_Resource_Seq_Num,-999)) then
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Resource_Seq_Num '||X_Wip_Resource_Seq_Num ||' Database Wip_Resource_Seq_Num '||Recinfo.Wip_Resource_Seq_Num);
512: end if;
513: if (nvl(X_Wip_Repetitive_Schedule_Id,-999) <> nvl(Recinfo.Wip_Repetitive_Schedule_Id,-999)) then
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Repetitive_Schedule_Id '||X_Wip_Repetitive_Schedule_Id ||' Database Wip_Repetitive_Schedule_Id '||Recinfo.Wip_Repetitive_Schedule_Id);
515: end if;

Line 514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Repetitive_Schedule_Id '||X_Wip_Repetitive_Schedule_Id ||' Database Wip_Repetitive_Schedule_Id '||Recinfo.Wip_Repetitive_Schedule_Id);

510: if (nvl(X_Wip_Resource_Seq_Num,-999) <> nvl(Recinfo.Wip_Resource_Seq_Num,-999)) then
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Resource_Seq_Num '||X_Wip_Resource_Seq_Num ||' Database Wip_Resource_Seq_Num '||Recinfo.Wip_Resource_Seq_Num);
512: end if;
513: if (nvl(X_Wip_Repetitive_Schedule_Id,-999) <> nvl(Recinfo.Wip_Repetitive_Schedule_Id,-999)) then
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Repetitive_Schedule_Id '||X_Wip_Repetitive_Schedule_Id ||' Database Wip_Repetitive_Schedule_Id '||Recinfo.Wip_Repetitive_Schedule_Id);
515: end if;
516: if (nvl(X_Wip_Line_Id,-999) <> nvl(Recinfo.Wip_Line_Id ,-999)) then
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Line_Id '||X_Wip_Line_Id ||' Database Wip_Line_Id '||Recinfo.Wip_Line_Id);
518: end if;

Line 517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Line_Id '||X_Wip_Line_Id ||' Database Wip_Line_Id '||Recinfo.Wip_Line_Id);

513: if (nvl(X_Wip_Repetitive_Schedule_Id,-999) <> nvl(Recinfo.Wip_Repetitive_Schedule_Id,-999)) then
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Repetitive_Schedule_Id '||X_Wip_Repetitive_Schedule_Id ||' Database Wip_Repetitive_Schedule_Id '||Recinfo.Wip_Repetitive_Schedule_Id);
515: end if;
516: if (nvl(X_Wip_Line_Id,-999) <> nvl(Recinfo.Wip_Line_Id ,-999)) then
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Line_Id '||X_Wip_Line_Id ||' Database Wip_Line_Id '||Recinfo.Wip_Line_Id);
518: end if;
519: if (nvl(X_Bom_Resource_Id,-999) <> nvl(Recinfo.Bom_Resource_Id,-999)) then
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
521: end if;

Line 520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);

516: if (nvl(X_Wip_Line_Id,-999) <> nvl(Recinfo.Wip_Line_Id ,-999)) then
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Wip_Line_Id '||X_Wip_Line_Id ||' Database Wip_Line_Id '||Recinfo.Wip_Line_Id);
518: end if;
519: if (nvl(X_Bom_Resource_Id,-999) <> nvl(Recinfo.Bom_Resource_Id,-999)) then
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
521: end if;
522: if (nvl(X_Budget_Account_Id,-999) <> nvl(Recinfo.Budget_Account_Id,-999)) then
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Budget_Account_Id '||X_Budget_Account_Id ||' Database Budget_Account_Id '||Recinfo.Budget_Account_Id);
524: end if;

Line 523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Budget_Account_Id '||X_Budget_Account_Id ||' Database Budget_Account_Id '||Recinfo.Budget_Account_Id);

519: if (nvl(X_Bom_Resource_Id,-999) <> nvl(Recinfo.Bom_Resource_Id,-999)) then
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Bom_Resource_Id '||X_Bom_Resource_Id ||' Database Bom_Resource_Id '||Recinfo.Bom_Resource_Id);
521: end if;
522: if (nvl(X_Budget_Account_Id,-999) <> nvl(Recinfo.Budget_Account_Id,-999)) then
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Budget_Account_Id '||X_Budget_Account_Id ||' Database Budget_Account_Id '||Recinfo.Budget_Account_Id);
524: end if;
525: if (nvl(X_Accrual_Account_Id,-999) <> nvl(Recinfo.Accrual_Account_Id,-999) ) then
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrual_Account_Id '||X_Accrual_Account_Id ||' Database Accrual_Account_Id '||Recinfo.Accrual_Account_Id);
527: end if;

Line 526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrual_Account_Id '||X_Accrual_Account_Id ||' Database Accrual_Account_Id '||Recinfo.Accrual_Account_Id);

522: if (nvl(X_Budget_Account_Id,-999) <> nvl(Recinfo.Budget_Account_Id,-999)) then
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Budget_Account_Id '||X_Budget_Account_Id ||' Database Budget_Account_Id '||Recinfo.Budget_Account_Id);
524: end if;
525: if (nvl(X_Accrual_Account_Id,-999) <> nvl(Recinfo.Accrual_Account_Id,-999) ) then
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrual_Account_Id '||X_Accrual_Account_Id ||' Database Accrual_Account_Id '||Recinfo.Accrual_Account_Id);
527: end if;
528: if (nvl(X_Variance_Account_Id ,-999) <> nvl(Recinfo.Variance_Account_Id,-999) ) then
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Variance_Account_Id '||X_Variance_Account_Id ||' Database Variance_Account_Id '||Recinfo.Variance_Account_Id);
530: end if;

Line 529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Variance_Account_Id '||X_Variance_Account_Id ||' Database Variance_Account_Id '||Recinfo.Variance_Account_Id);

525: if (nvl(X_Accrual_Account_Id,-999) <> nvl(Recinfo.Accrual_Account_Id,-999) ) then
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrual_Account_Id '||X_Accrual_Account_Id ||' Database Accrual_Account_Id '||Recinfo.Accrual_Account_Id);
527: end if;
528: if (nvl(X_Variance_Account_Id ,-999) <> nvl(Recinfo.Variance_Account_Id,-999) ) then
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Variance_Account_Id '||X_Variance_Account_Id ||' Database Variance_Account_Id '||Recinfo.Variance_Account_Id);
530: end if;
531: if (nvl(X_Prevent_Encumbrance_Flag,'-999') <> nvl(Recinfo.Prevent_Encumbrance_Flag,'-999')) then
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Prevent_Encumbrance_Flag '||X_Prevent_Encumbrance_Flag||' Database Prevent_Encumbrance_Flag '||Recinfo.Prevent_Encumbrance_Flag);
533: end if;

Line 532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Prevent_Encumbrance_Flag '||X_Prevent_Encumbrance_Flag||' Database Prevent_Encumbrance_Flag '||Recinfo.Prevent_Encumbrance_Flag);

528: if (nvl(X_Variance_Account_Id ,-999) <> nvl(Recinfo.Variance_Account_Id,-999) ) then
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Variance_Account_Id '||X_Variance_Account_Id ||' Database Variance_Account_Id '||Recinfo.Variance_Account_Id);
530: end if;
531: if (nvl(X_Prevent_Encumbrance_Flag,'-999') <> nvl(Recinfo.Prevent_Encumbrance_Flag,'-999')) then
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Prevent_Encumbrance_Flag '||X_Prevent_Encumbrance_Flag||' Database Prevent_Encumbrance_Flag '||Recinfo.Prevent_Encumbrance_Flag);
533: end if;
534: if (nvl(X_Ussgl_Transaction_Code ,'-999') <> nvl( Recinfo.Ussgl_Transaction_Code,'-999')) then
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Ussgl_Transaction_Code '||X_Ussgl_Transaction_Code ||' Database Ussgl_Transaction_Code '||Recinfo.Ussgl_Transaction_Code);
536: end if;

Line 535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Ussgl_Transaction_Code '||X_Ussgl_Transaction_Code ||' Database Ussgl_Transaction_Code '||Recinfo.Ussgl_Transaction_Code);

531: if (nvl(X_Prevent_Encumbrance_Flag,'-999') <> nvl(Recinfo.Prevent_Encumbrance_Flag,'-999')) then
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Prevent_Encumbrance_Flag '||X_Prevent_Encumbrance_Flag||' Database Prevent_Encumbrance_Flag '||Recinfo.Prevent_Encumbrance_Flag);
533: end if;
534: if (nvl(X_Ussgl_Transaction_Code ,'-999') <> nvl( Recinfo.Ussgl_Transaction_Code,'-999')) then
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Ussgl_Transaction_Code '||X_Ussgl_Transaction_Code ||' Database Ussgl_Transaction_Code '||Recinfo.Ussgl_Transaction_Code);
536: end if;
537: if (nvl(X_Government_Context,'-999') <> nvl( Recinfo.Government_Context,'-999')) then
538: 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);
539: end if;

Line 538: 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);

534: if (nvl(X_Ussgl_Transaction_Code ,'-999') <> nvl( Recinfo.Ussgl_Transaction_Code,'-999')) then
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Ussgl_Transaction_Code '||X_Ussgl_Transaction_Code ||' Database Ussgl_Transaction_Code '||Recinfo.Ussgl_Transaction_Code);
536: end if;
537: if (nvl(X_Government_Context,'-999') <> nvl( Recinfo.Government_Context,'-999')) then
538: 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);
539: end if;
540: if (nvl(X_Destination_Context,'-999') <> nvl( Recinfo.Destination_Context,'-999')) then
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Context '||X_Destination_Context ||' Database Destination_Context '||Recinfo.Destination_Context);
542: end if;

Line 541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Context '||X_Destination_Context ||' Database Destination_Context '||Recinfo.Destination_Context);

537: if (nvl(X_Government_Context,'-999') <> nvl( Recinfo.Government_Context,'-999')) then
538: 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);
539: end if;
540: if (nvl(X_Destination_Context,'-999') <> nvl( Recinfo.Destination_Context,'-999')) then
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Context '||X_Destination_Context ||' Database Destination_Context '||Recinfo.Destination_Context);
542: end if;
543: if (nvl(X_Distribution_Num,-999) <> nvl( Recinfo.Distribution_Num,-999)) then
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Distribution_Num '||X_Distribution_Num ||' Database Distribution_Num '||Recinfo.Distribution_Num);
545: end if;

Line 544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Distribution_Num '||X_Distribution_Num ||' Database Distribution_Num '||Recinfo.Distribution_Num);

540: if (nvl(X_Destination_Context,'-999') <> nvl( Recinfo.Destination_Context,'-999')) then
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Destination_Context '||X_Destination_Context ||' Database Destination_Context '||Recinfo.Destination_Context);
542: end if;
543: if (nvl(X_Distribution_Num,-999) <> nvl( Recinfo.Distribution_Num,-999)) then
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Distribution_Num '||X_Distribution_Num ||' Database Distribution_Num '||Recinfo.Distribution_Num);
545: end if;
546: if (nvl(X_Source_Distribution_Id ,-999) <> nvl( Recinfo.Source_Distribution_Id ,-999)) then
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Source_Distribution_Id '||X_Source_Distribution_Id ||' Database Source_Distribution_Id '||Recinfo.Source_Distribution_Id);
548: end if;

Line 547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Source_Distribution_Id '||X_Source_Distribution_Id ||' Database Source_Distribution_Id '||Recinfo.Source_Distribution_Id);

543: if (nvl(X_Distribution_Num,-999) <> nvl( Recinfo.Distribution_Num,-999)) then
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Distribution_Num '||X_Distribution_Num ||' Database Distribution_Num '||Recinfo.Distribution_Num);
545: end if;
546: if (nvl(X_Source_Distribution_Id ,-999) <> nvl( Recinfo.Source_Distribution_Id ,-999)) then
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Source_Distribution_Id '||X_Source_Distribution_Id ||' Database Source_Distribution_Id '||Recinfo.Source_Distribution_Id);
548: end if;
549: if (nvl(X_Project_Id ,-999) <> nvl( Recinfo.Project_Id ,-999)) then
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Id '||X_Project_Id ||' Database Project_Id '||Recinfo.Project_Id);
551: end if;

Line 550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Id '||X_Project_Id ||' Database Project_Id '||Recinfo.Project_Id);

546: if (nvl(X_Source_Distribution_Id ,-999) <> nvl( Recinfo.Source_Distribution_Id ,-999)) then
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Source_Distribution_Id '||X_Source_Distribution_Id ||' Database Source_Distribution_Id '||Recinfo.Source_Distribution_Id);
548: end if;
549: if (nvl(X_Project_Id ,-999) <> nvl( Recinfo.Project_Id ,-999)) then
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Id '||X_Project_Id ||' Database Project_Id '||Recinfo.Project_Id);
551: end if;
552: if (nvl(X_Task_Id,-999) <> nvl( Recinfo.Task_Id,-999)) then
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Task_Id '||X_Task_Id ||' Database Task_Id '||Recinfo.Task_Id);
554: end if;

Line 553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Task_Id '||X_Task_Id ||' Database Task_Id '||Recinfo.Task_Id);

549: if (nvl(X_Project_Id ,-999) <> nvl( Recinfo.Project_Id ,-999)) then
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Id '||X_Project_Id ||' Database Project_Id '||Recinfo.Project_Id);
551: end if;
552: if (nvl(X_Task_Id,-999) <> nvl( Recinfo.Task_Id,-999)) then
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Task_Id '||X_Task_Id ||' Database Task_Id '||Recinfo.Task_Id);
554: end if;
555: if (nvl(X_Expenditure_Type,'-999') <> nvl( Recinfo.Expenditure_Type,'-999')) then
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Type '||X_Expenditure_Type ||' Database Expenditure_Type '||Recinfo.Expenditure_Type);
557: end if;

Line 556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Type '||X_Expenditure_Type ||' Database Expenditure_Type '||Recinfo.Expenditure_Type);

552: if (nvl(X_Task_Id,-999) <> nvl( Recinfo.Task_Id,-999)) then
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Task_Id '||X_Task_Id ||' Database Task_Id '||Recinfo.Task_Id);
554: end if;
555: if (nvl(X_Expenditure_Type,'-999') <> nvl( Recinfo.Expenditure_Type,'-999')) then
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Type '||X_Expenditure_Type ||' Database Expenditure_Type '||Recinfo.Expenditure_Type);
557: end if;
558: if (nvl(X_Project_Accounting_Context,'-999') <> nvl( Recinfo.Project_Accounting_Context,'-999')) then
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Accounting_Context '||X_Project_Accounting_Context ||' Database Project_Accounting_Context '||Recinfo.Project_Accounting_Context);
560: end if;

Line 559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Accounting_Context '||X_Project_Accounting_Context ||' Database Project_Accounting_Context '||Recinfo.Project_Accounting_Context);

555: if (nvl(X_Expenditure_Type,'-999') <> nvl( Recinfo.Expenditure_Type,'-999')) then
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Type '||X_Expenditure_Type ||' Database Expenditure_Type '||Recinfo.Expenditure_Type);
557: end if;
558: if (nvl(X_Project_Accounting_Context,'-999') <> nvl( Recinfo.Project_Accounting_Context,'-999')) then
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Accounting_Context '||X_Project_Accounting_Context ||' Database Project_Accounting_Context '||Recinfo.Project_Accounting_Context);
560: end if;
561: if (nvl(X_Expenditure_Organization_Id,-999) <> nvl( Recinfo.Expenditure_Organization_Id ,-999)) then
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Organization_Id '||X_Expenditure_Organization_Id ||' Database Expenditure_Organization_Id '||Recinfo.Expenditure_Organization_Id);
563: end if;

Line 562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Organization_Id '||X_Expenditure_Organization_Id ||' Database Expenditure_Organization_Id '||Recinfo.Expenditure_Organization_Id);

558: if (nvl(X_Project_Accounting_Context,'-999') <> nvl( Recinfo.Project_Accounting_Context,'-999')) then
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Project_Accounting_Context '||X_Project_Accounting_Context ||' Database Project_Accounting_Context '||Recinfo.Project_Accounting_Context);
560: end if;
561: if (nvl(X_Expenditure_Organization_Id,-999) <> nvl( Recinfo.Expenditure_Organization_Id ,-999)) then
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Organization_Id '||X_Expenditure_Organization_Id ||' Database Expenditure_Organization_Id '||Recinfo.Expenditure_Organization_Id);
563: end if;
564: if ( trunc(X_Gl_Closed_Date) <> trunc(Recinfo.Gl_Closed_Date) ) then
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Closed_Date '||X_Gl_Closed_Date ||' Database Gl_Closed_Date '||Recinfo.Gl_Closed_Date);
566: end if;

Line 565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Closed_Date '||X_Gl_Closed_Date ||' Database Gl_Closed_Date '||Recinfo.Gl_Closed_Date);

561: if (nvl(X_Expenditure_Organization_Id,-999) <> nvl( Recinfo.Expenditure_Organization_Id ,-999)) then
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Organization_Id '||X_Expenditure_Organization_Id ||' Database Expenditure_Organization_Id '||Recinfo.Expenditure_Organization_Id);
563: end if;
564: if ( trunc(X_Gl_Closed_Date) <> trunc(Recinfo.Gl_Closed_Date) ) then
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Closed_Date '||X_Gl_Closed_Date ||' Database Gl_Closed_Date '||Recinfo.Gl_Closed_Date);
566: end if;
567: if (nvl(X_Accrue_On_Receipt_Flag,'-999') <> nvl(Recinfo.Accrue_On_Receipt_Flag,'-999')) then
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrue_On_Receipt_Flag '||X_Accrue_On_Receipt_Flag ||' Database Accrue_On_Receipt_Flag '||Recinfo.Accrue_On_Receipt_Flag);
569: end if;

Line 568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrue_On_Receipt_Flag '||X_Accrue_On_Receipt_Flag ||' Database Accrue_On_Receipt_Flag '||Recinfo.Accrue_On_Receipt_Flag);

564: if ( trunc(X_Gl_Closed_Date) <> trunc(Recinfo.Gl_Closed_Date) ) then
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Gl_Closed_Date '||X_Gl_Closed_Date ||' Database Gl_Closed_Date '||Recinfo.Gl_Closed_Date);
566: end if;
567: if (nvl(X_Accrue_On_Receipt_Flag,'-999') <> nvl(Recinfo.Accrue_On_Receipt_Flag,'-999')) then
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrue_On_Receipt_Flag '||X_Accrue_On_Receipt_Flag ||' Database Accrue_On_Receipt_Flag '||Recinfo.Accrue_On_Receipt_Flag);
569: end if;
570: if ( trunc(X_Expenditure_Item_Date) <> trunc(Recinfo.Expenditure_Item_Date) ) then
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Item_Date '||X_Expenditure_Item_Date ||' Database Expenditure_Item_Date '||Recinfo.Expenditure_Item_Date);
572: end if;

Line 571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Item_Date '||X_Expenditure_Item_Date ||' Database Expenditure_Item_Date '||Recinfo.Expenditure_Item_Date);

567: if (nvl(X_Accrue_On_Receipt_Flag,'-999') <> nvl(Recinfo.Accrue_On_Receipt_Flag,'-999')) then
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Accrue_On_Receipt_Flag '||X_Accrue_On_Receipt_Flag ||' Database Accrue_On_Receipt_Flag '||Recinfo.Accrue_On_Receipt_Flag);
569: end if;
570: if ( trunc(X_Expenditure_Item_Date) <> trunc(Recinfo.Expenditure_Item_Date) ) then
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Item_Date '||X_Expenditure_Item_Date ||' Database Expenditure_Item_Date '||Recinfo.Expenditure_Item_Date);
572: end if;
573: if (nvl(X_End_Item_Unit_Number,-999) <> nvl(Recinfo.End_Item_Unit_Number,-999)) then
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form End_Item_Unit_Number '||X_End_Item_Unit_Number ||' Database End_Item_Unit_Number '||Recinfo.End_Item_Unit_Number);
575: end if;

Line 574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form End_Item_Unit_Number '||X_End_Item_Unit_Number ||' Database End_Item_Unit_Number '||Recinfo.End_Item_Unit_Number);

570: if ( trunc(X_Expenditure_Item_Date) <> trunc(Recinfo.Expenditure_Item_Date) ) then
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expenditure_Item_Date '||X_Expenditure_Item_Date ||' Database Expenditure_Item_Date '||Recinfo.Expenditure_Item_Date);
572: end if;
573: if (nvl(X_End_Item_Unit_Number,-999) <> nvl(Recinfo.End_Item_Unit_Number,-999)) then
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form End_Item_Unit_Number '||X_End_Item_Unit_Number ||' Database End_Item_Unit_Number '||Recinfo.End_Item_Unit_Number);
575: end if;
576: if (nvl(X_Recovery_Rate,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Recovery_Rate '||X_Recovery_Rate ||' Database Recovery_Rate '||Recinfo.Recovery_Rate);
578: end if;

Line 577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Recovery_Rate '||X_Recovery_Rate ||' Database Recovery_Rate '||Recinfo.Recovery_Rate);

573: if (nvl(X_End_Item_Unit_Number,-999) <> nvl(Recinfo.End_Item_Unit_Number,-999)) then
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form End_Item_Unit_Number '||X_End_Item_Unit_Number ||' Database End_Item_Unit_Number '||Recinfo.End_Item_Unit_Number);
575: end if;
576: if (nvl(X_Recovery_Rate,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Recovery_Rate '||X_Recovery_Rate ||' Database Recovery_Rate '||Recinfo.Recovery_Rate);
578: end if;
579: if (nvl(X_Tax_Recovery_Override_Flag,'-999') <> nvl(Recinfo.Tax_Recovery_Override_Flag ,'-999')) then
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Tax_Recovery_Override_Flag '||X_Tax_Recovery_Override_Flag ||' Database Tax_Recovery_Override_Flag '||Recinfo.Tax_Recovery_Override_Flag);
581: end if;

Line 580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Tax_Recovery_Override_Flag '||X_Tax_Recovery_Override_Flag ||' Database Tax_Recovery_Override_Flag '||Recinfo.Tax_Recovery_Override_Flag);

576: if (nvl(X_Recovery_Rate,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Recovery_Rate '||X_Recovery_Rate ||' Database Recovery_Rate '||Recinfo.Recovery_Rate);
578: end if;
579: if (nvl(X_Tax_Recovery_Override_Flag,'-999') <> nvl(Recinfo.Tax_Recovery_Override_Flag ,'-999')) then
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Tax_Recovery_Override_Flag '||X_Tax_Recovery_Override_Flag ||' Database Tax_Recovery_Override_Flag '||Recinfo.Tax_Recovery_Override_Flag);
581: end if;
582: if (nvl(p_dest_charge_account_id,-999) <> nvl(Recinfo.dest_charge_account_id,-999)) then
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_charge_account_id '||p_dest_charge_account_id ||' Database dest_charge_account_id '||Recinfo.dest_charge_account_id);
584: end if;

Line 583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_charge_account_id '||p_dest_charge_account_id ||' Database dest_charge_account_id '||Recinfo.dest_charge_account_id);

579: if (nvl(X_Tax_Recovery_Override_Flag,'-999') <> nvl(Recinfo.Tax_Recovery_Override_Flag ,'-999')) then
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Tax_Recovery_Override_Flag '||X_Tax_Recovery_Override_Flag ||' Database Tax_Recovery_Override_Flag '||Recinfo.Tax_Recovery_Override_Flag);
581: end if;
582: if (nvl(p_dest_charge_account_id,-999) <> nvl(Recinfo.dest_charge_account_id,-999)) then
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_charge_account_id '||p_dest_charge_account_id ||' Database dest_charge_account_id '||Recinfo.dest_charge_account_id);
584: end if;
585: if (nvl(trunc(p_dest_variance_account_id),-999) <> nvl(trunc(Recinfo.dest_variance_account_id),-999)) then
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_variance_account_id '||p_dest_variance_account_id ||' Database dest_variance_account_id '||Recinfo.dest_variance_account_id);
587: end if;

Line 586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_variance_account_id '||p_dest_variance_account_id ||' Database dest_variance_account_id '||Recinfo.dest_variance_account_id);

582: if (nvl(p_dest_charge_account_id,-999) <> nvl(Recinfo.dest_charge_account_id,-999)) then
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_charge_account_id '||p_dest_charge_account_id ||' Database dest_charge_account_id '||Recinfo.dest_charge_account_id);
584: end if;
585: if (nvl(trunc(p_dest_variance_account_id),-999) <> nvl(trunc(Recinfo.dest_variance_account_id),-999)) then
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_variance_account_id '||p_dest_variance_account_id ||' Database dest_variance_account_id '||Recinfo.dest_variance_account_id);
587: end if;
588: if (nvl(X_amount_ordered,-999) <> nvl(Recinfo.amount_ordered,-999)) then
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_ordered '||X_amount_ordered ||' Database amount_ordered '||Recinfo.amount_ordered);
590: end if;

Line 589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_ordered '||X_amount_ordered ||' Database amount_ordered '||Recinfo.amount_ordered);

585: if (nvl(trunc(p_dest_variance_account_id),-999) <> nvl(trunc(Recinfo.dest_variance_account_id),-999)) then
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form dest_variance_account_id '||p_dest_variance_account_id ||' Database dest_variance_account_id '||Recinfo.dest_variance_account_id);
587: end if;
588: if (nvl(X_amount_ordered,-999) <> nvl(Recinfo.amount_ordered,-999)) then
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_ordered '||X_amount_ordered ||' Database amount_ordered '||Recinfo.amount_ordered);
590: end if;
591: if (nvl(X_amount_to_encumber,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_to_encumber '||X_amount_to_encumber ||' Database amount_to_encumber '||Recinfo.amount_to_encumber);
593: end if;

Line 592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_to_encumber '||X_amount_to_encumber ||' Database amount_to_encumber '||Recinfo.amount_to_encumber);

588: if (nvl(X_amount_ordered,-999) <> nvl(Recinfo.amount_ordered,-999)) then
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_ordered '||X_amount_ordered ||' Database amount_ordered '||Recinfo.amount_ordered);
590: end if;
591: if (nvl(X_amount_to_encumber,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_to_encumber '||X_amount_to_encumber ||' Database amount_to_encumber '||Recinfo.amount_to_encumber);
593: end if;
594: if (nvl(X_distribution_type,'-999') <> nvl(Recinfo.distribution_type ,'-999')) then
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form distribution_type '||X_distribution_type ||' Database distribution_type '||Recinfo.distribution_type);
596: end if;

Line 595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form distribution_type '||X_distribution_type ||' Database distribution_type '||Recinfo.distribution_type);

591: if (nvl(X_amount_to_encumber,-999) <> nvl(Recinfo.Recovery_Rate,-999)) then
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount_to_encumber '||X_amount_to_encumber ||' Database amount_to_encumber '||Recinfo.amount_to_encumber);
593: end if;
594: if (nvl(X_distribution_type,'-999') <> nvl(Recinfo.distribution_type ,'-999')) then
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form distribution_type '||X_distribution_type ||' Database distribution_type '||Recinfo.distribution_type);
596: end if;
597:
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed when comparing fields');
599:

Line 598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed when comparing fields');

594: if (nvl(X_distribution_type,'-999') <> nvl(Recinfo.distribution_type ,'-999')) then
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form distribution_type '||X_distribution_type ||' Database distribution_type '||Recinfo.distribution_type);
596: end if;
597:
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed when comparing fields');
599:
600: END IF; --end g_fnd_debug = 'Y'
601: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
602: APP_EXCEPTION.RAISE_EXCEPTION;