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.

APPS.PO_LINES_PKG_SL dependencies on FND_LOG

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

130: -- For debug purposes
131: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
132: BEGIN
133: IF (g_fnd_debug = 'Y') THEN
134: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.begin','lock rows');
135: END IF;
136: OPEN C;
137: FETCH C INTO Recinfo;
138: if (C%NOTFOUND) then

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

461: --
462: ) then
463:
464: IF (g_fnd_debug = 'Y') THEN
465: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','no lock error');
466: END IF;
467:
468: return;
469: else

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

471: IF (g_fnd_debug = 'Y') THEN
472:
473: --Included for Debugging Purposes
474: IF (NVL(p_contract_id,-999) <> NVL(Recinfo.contract_id,-999)) THEN
475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contract_id '||p_contract_id ||' Database contract_id '||Recinfo.contract_id);
476: END IF;
477: IF (NVL(TRIM(X_type_1099),'-999') <> NVL(TRIM(Recinfo.type_1099),'-999') ) THEN
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_1099 '||X_type_1099 ||' Database type_1099 '||Recinfo.type_1099);
479: END IF;

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

474: IF (NVL(p_contract_id,-999) <> NVL(Recinfo.contract_id,-999)) THEN
475: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contract_id '||p_contract_id ||' Database contract_id '||Recinfo.contract_id);
476: END IF;
477: IF (NVL(TRIM(X_type_1099),'-999') <> NVL(TRIM(Recinfo.type_1099),'-999') ) THEN
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_1099 '||X_type_1099 ||' Database type_1099 '||Recinfo.type_1099);
479: END IF;
480: IF (NVL(TRIM(X_capital_expense_flag),'-999') <> NVL(TRIM(Recinfo.capital_expense_flag),'-999')) THEN
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form capital_expense_flag '||X_capital_expense_flag ||' Database capital_expense_flag '||Recinfo.capital_expense_flag);
482: END IF;

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

477: IF (NVL(TRIM(X_type_1099),'-999') <> NVL(TRIM(Recinfo.type_1099),'-999') ) THEN
478: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form type_1099 '||X_type_1099 ||' Database type_1099 '||Recinfo.type_1099);
479: END IF;
480: IF (NVL(TRIM(X_capital_expense_flag),'-999') <> NVL(TRIM(Recinfo.capital_expense_flag),'-999')) THEN
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form capital_expense_flag '||X_capital_expense_flag ||' Database capital_expense_flag '||Recinfo.capital_expense_flag);
482: END IF;
483: IF (NVL(TRIM(X_negotiated_by_preparer_flag),'-999') <> NVL(TRIM(Recinfo.negotiated_by_preparer_flag),'-999') ) THEN
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form negotiated_by_preparer_flag '||X_negotiated_by_preparer_flag ||' Database negotiated_by_preparer_flag '||Recinfo.negotiated_by_preparer_flag);
485: END IF;

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

480: IF (NVL(TRIM(X_capital_expense_flag),'-999') <> NVL(TRIM(Recinfo.capital_expense_flag),'-999')) THEN
481: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form capital_expense_flag '||X_capital_expense_flag ||' Database capital_expense_flag '||Recinfo.capital_expense_flag);
482: END IF;
483: IF (NVL(TRIM(X_negotiated_by_preparer_flag),'-999') <> NVL(TRIM(Recinfo.negotiated_by_preparer_flag),'-999') ) THEN
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form negotiated_by_preparer_flag '||X_negotiated_by_preparer_flag ||' Database negotiated_by_preparer_flag '||Recinfo.negotiated_by_preparer_flag);
485: END IF;
486: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.Attribute_Category),'-999')) THEN
487: 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);
488: END IF;

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

483: IF (NVL(TRIM(X_negotiated_by_preparer_flag),'-999') <> NVL(TRIM(Recinfo.negotiated_by_preparer_flag),'-999') ) THEN
484: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form negotiated_by_preparer_flag '||X_negotiated_by_preparer_flag ||' Database negotiated_by_preparer_flag '||Recinfo.negotiated_by_preparer_flag);
485: END IF;
486: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.Attribute_Category),'-999')) THEN
487: 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);
488: END IF;
489: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.Attribute1),'-999')) THEN
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
491: END IF;

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

486: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.Attribute_Category),'-999')) THEN
487: 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);
488: END IF;
489: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.Attribute1),'-999')) THEN
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
491: END IF;
492: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.Attribute2),'-999')) THEN
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
494: END IF;

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

489: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.Attribute1),'-999')) THEN
490: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute1 '||X_Attribute1 ||' Database Attribute1 '||Recinfo.Attribute1);
491: END IF;
492: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.Attribute2),'-999')) THEN
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
494: END IF;
495: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.Attribute3),'-999')) THEN
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
497: END IF;

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

492: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.Attribute2),'-999')) THEN
493: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute2 '||X_Attribute2 ||' Database Attribute2 '||Recinfo.Attribute2);
494: END IF;
495: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.Attribute3),'-999')) THEN
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
497: END IF;
498: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.Attribute4),'-999')) THEN
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
500: END IF;

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

495: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.Attribute3),'-999')) THEN
496: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute3 '||X_Attribute3 ||' Database Attribute3 '||Recinfo.Attribute3);
497: END IF;
498: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.Attribute4),'-999')) THEN
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
500: END IF;
501: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.Attribute5),'-999')) THEN
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
503: END IF;

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

498: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.Attribute4),'-999')) THEN
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute4 '||X_Attribute4 ||' Database Attribute4 '||Recinfo.Attribute4);
500: END IF;
501: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.Attribute5),'-999')) THEN
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
503: END IF;
504: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.Attribute6),'-999')) THEN
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
506: END IF;

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

501: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.Attribute5),'-999')) THEN
502: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute5 '||X_Attribute5 ||' Database Attribute5 '||Recinfo.Attribute5);
503: END IF;
504: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.Attribute6),'-999')) THEN
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
506: END IF;
507: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.Attribute7),'-999')) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
509: END IF;

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

504: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.Attribute6),'-999')) THEN
505: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute6 '||X_Attribute6 ||' Database Attribute6 '||Recinfo.Attribute6);
506: END IF;
507: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.Attribute7),'-999')) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
509: END IF;
510: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.Attribute8),'-999')) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
512: END IF;

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

507: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.Attribute7),'-999')) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute7 '||X_Attribute7 ||' Database Attribute7 '||Recinfo.Attribute7);
509: END IF;
510: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.Attribute8),'-999')) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
512: END IF;
513: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.Attribute9),'-999')) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
515: END IF;

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

510: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.Attribute8),'-999')) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute8 '||X_Attribute8 ||' Database Attribute8 '||Recinfo.Attribute8);
512: END IF;
513: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.Attribute9),'-999')) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
515: END IF;
516: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.Attribute10),'-999')) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
518: END IF;

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

513: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.Attribute9),'-999')) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute9 '||X_Attribute9 ||' Database Attribute9 '||Recinfo.Attribute9);
515: END IF;
516: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.Attribute10),'-999')) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
518: END IF;
519: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.Attribute11),'-999')) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
521: END IF;

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

516: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.Attribute10),'-999')) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute10 '||X_Attribute10 ||' Database Attribute10 '||Recinfo.Attribute10);
518: END IF;
519: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.Attribute11),'-999')) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
521: END IF;
522: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.Attribute12),'-999')) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
524: END IF;

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

519: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.Attribute11),'-999')) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute11 '||X_Attribute11 ||' Database Attribute11 '||Recinfo.Attribute11);
521: END IF;
522: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.Attribute12),'-999')) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
524: END IF;
525: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.Attribute13),'-999')) THEN
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
527: END IF;

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

522: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.Attribute12),'-999')) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute12 '||X_Attribute12 ||' Database Attribute12 '||Recinfo.Attribute12);
524: END IF;
525: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.Attribute13),'-999')) THEN
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
527: END IF;
528: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.Attribute14),'-999')) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
530: END IF;

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

525: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.Attribute13),'-999')) THEN
526: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute13 '||X_Attribute13 ||' Database Attribute13 '||Recinfo.Attribute13);
527: END IF;
528: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.Attribute14),'-999')) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
530: END IF;
531: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.Attribute15),'-999')) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
533: END IF;

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

528: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.Attribute14),'-999')) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute14 '||X_Attribute14 ||' Database Attribute14 '||Recinfo.Attribute14);
530: END IF;
531: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.Attribute15),'-999')) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
533: END IF;
534: IF (NVL(X_min_release_amount,-999) <> NVL(Recinfo.min_release_amount,-999)) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_release_amount '||X_min_release_amount ||' Database min_release_amount '||Recinfo.min_release_amount);
536: END IF;

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

531: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.Attribute15),'-999')) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Attribute15 '||X_Attribute15 ||' Database Attribute15 '||Recinfo.Attribute15);
533: END IF;
534: IF (NVL(X_min_release_amount,-999) <> NVL(Recinfo.min_release_amount,-999)) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_release_amount '||X_min_release_amount ||' Database min_release_amount '||Recinfo.min_release_amount);
536: END IF;
537: IF (NVL(TRIM(X_price_type_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_type_lookup_code),'-999')) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_type_lookup_code '||X_price_type_lookup_code ||' Database price_type_lookup_code '||Recinfo.price_type_lookup_code);
539: END IF;

Line 538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_type_lookup_code '||X_price_type_lookup_code ||' Database price_type_lookup_code '||Recinfo.price_type_lookup_code);

534: IF (NVL(X_min_release_amount,-999) <> NVL(Recinfo.min_release_amount,-999)) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_release_amount '||X_min_release_amount ||' Database min_release_amount '||Recinfo.min_release_amount);
536: END IF;
537: IF (NVL(TRIM(X_price_type_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_type_lookup_code),'-999')) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_type_lookup_code '||X_price_type_lookup_code ||' Database price_type_lookup_code '||Recinfo.price_type_lookup_code);
539: END IF;
540: IF (NVL(TRIM(X_closed_code),'-999') <> NVL(TRIM(Recinfo.closed_code),'-999')) THEN
541: 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);
542: END IF;

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

537: IF (NVL(TRIM(X_price_type_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_type_lookup_code),'-999')) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_type_lookup_code '||X_price_type_lookup_code ||' Database price_type_lookup_code '||Recinfo.price_type_lookup_code);
539: END IF;
540: IF (NVL(TRIM(X_closed_code),'-999') <> NVL(TRIM(Recinfo.closed_code),'-999')) THEN
541: 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);
542: END IF;
543: IF (NVL(TRIM(X_price_break_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_break_lookup_code),'-999')) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_break_lookup_code '||X_price_break_lookup_code ||' Database price_break_lookup_code '||Recinfo.price_break_lookup_code);
545: END IF;

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

540: IF (NVL(TRIM(X_closed_code),'-999') <> NVL(TRIM(Recinfo.closed_code),'-999')) THEN
541: 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);
542: END IF;
543: IF (NVL(TRIM(X_price_break_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_break_lookup_code),'-999')) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_break_lookup_code '||X_price_break_lookup_code ||' Database price_break_lookup_code '||Recinfo.price_break_lookup_code);
545: END IF;
546: IF (NVL(TRIM(X_government_context),'-999') <> NVL(TRIM(Recinfo.government_context),'-999')) THEN
547: 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);
548: END IF;

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

543: IF (NVL(TRIM(X_price_break_lookup_code),'-999') <> NVL(TRIM(Recinfo.price_break_lookup_code),'-999')) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_break_lookup_code '||X_price_break_lookup_code ||' Database price_break_lookup_code '||Recinfo.price_break_lookup_code);
545: END IF;
546: IF (NVL(TRIM(X_government_context),'-999') <> NVL(TRIM(Recinfo.government_context),'-999')) THEN
547: 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);
548: END IF;
549: IF (X_closed_date <> Recinfo.closed_date) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_date '||X_closed_date ||' Database closed_date '||Recinfo.closed_date);
551: END IF;

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

546: IF (NVL(TRIM(X_government_context),'-999') <> NVL(TRIM(Recinfo.government_context),'-999')) THEN
547: 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);
548: END IF;
549: IF (X_closed_date <> Recinfo.closed_date) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_date '||X_closed_date ||' Database closed_date '||Recinfo.closed_date);
551: END IF;
552: IF (NVL(X_closed_by,'-999') <> NVL(Recinfo.closed_by ,'-999')) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_by '||X_closed_by ||' Database closed_by '||Recinfo.closed_by);
554: END IF;

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

549: IF (X_closed_date <> Recinfo.closed_date) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_date '||X_closed_date ||' Database closed_date '||Recinfo.closed_date);
551: END IF;
552: IF (NVL(X_closed_by,'-999') <> NVL(Recinfo.closed_by ,'-999')) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_by '||X_closed_by ||' Database closed_by '||Recinfo.closed_by);
554: END IF;
555: IF (NVL(TRIM(X_closed_reason),'-999') <> NVL(TRIM(Recinfo.closed_reason),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_reason '||X_closed_reason ||' Database closed_reason '||Recinfo.closed_reason);
557: END IF;

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

552: IF (NVL(X_closed_by,'-999') <> NVL(Recinfo.closed_by ,'-999')) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_by '||X_closed_by ||' Database closed_by '||Recinfo.closed_by);
554: END IF;
555: IF (NVL(TRIM(X_closed_reason),'-999') <> NVL(TRIM(Recinfo.closed_reason),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_reason '||X_closed_reason ||' Database closed_reason '||Recinfo.closed_reason);
557: END IF;
558: IF (NVL(TRIM(X_transaction_reason_code),'-999') <> NVL(TRIM(Recinfo.transaction_reason_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transaction_reason_code '||X_transaction_reason_code ||' Database transaction_reason_code '||Recinfo.transaction_reason_code);
560: END IF;

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

555: IF (NVL(TRIM(X_closed_reason),'-999') <> NVL(TRIM(Recinfo.closed_reason),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_reason '||X_closed_reason ||' Database closed_reason '||Recinfo.closed_reason);
557: END IF;
558: IF (NVL(TRIM(X_transaction_reason_code),'-999') <> NVL(TRIM(Recinfo.transaction_reason_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transaction_reason_code '||X_transaction_reason_code ||' Database transaction_reason_code '||Recinfo.transaction_reason_code);
560: END IF;
561: IF (X_Expiration_Date <> Recinfo.Expiration_Date ) THEN
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expiration_Date '||X_Expiration_Date ||' Database Expiration_Date '||Recinfo.Expiration_Date);
563: END IF;

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

558: IF (NVL(TRIM(X_transaction_reason_code),'-999') <> NVL(TRIM(Recinfo.transaction_reason_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form transaction_reason_code '||X_transaction_reason_code ||' Database transaction_reason_code '||Recinfo.transaction_reason_code);
560: END IF;
561: IF (X_Expiration_Date <> Recinfo.Expiration_Date ) THEN
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expiration_Date '||X_Expiration_Date ||' Database Expiration_Date '||Recinfo.Expiration_Date);
563: END IF;
564: IF (NVL(TRIM(X_Secondary_unit_of_measure),'-999') <> NVL(TRIM(Recinfo.Secondary_unit_of_measure),'-999') ) THEN
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_unit_of_measure '||X_Secondary_unit_of_measure ||' Database Secondary_unit_of_measure '||Recinfo.Secondary_unit_of_measure);
566: END IF;

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

561: IF (X_Expiration_Date <> Recinfo.Expiration_Date ) THEN
562: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Expiration_Date '||X_Expiration_Date ||' Database Expiration_Date '||Recinfo.Expiration_Date);
563: END IF;
564: IF (NVL(TRIM(X_Secondary_unit_of_measure),'-999') <> NVL(TRIM(Recinfo.Secondary_unit_of_measure),'-999') ) THEN
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_unit_of_measure '||X_Secondary_unit_of_measure ||' Database Secondary_unit_of_measure '||Recinfo.Secondary_unit_of_measure);
566: END IF;
567: IF (NVL(X_Secondary_quantity,-999) <> NVL(Recinfo.Secondary_quantity,-999)) THEN
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_quantity '||X_Secondary_quantity||' Database Secondary_quantity '||Recinfo.Secondary_quantity);
569: END IF;

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

564: IF (NVL(TRIM(X_Secondary_unit_of_measure),'-999') <> NVL(TRIM(Recinfo.Secondary_unit_of_measure),'-999') ) THEN
565: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_unit_of_measure '||X_Secondary_unit_of_measure ||' Database Secondary_unit_of_measure '||Recinfo.Secondary_unit_of_measure);
566: END IF;
567: IF (NVL(X_Secondary_quantity,-999) <> NVL(Recinfo.Secondary_quantity,-999)) THEN
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_quantity '||X_Secondary_quantity||' Database Secondary_quantity '||Recinfo.Secondary_quantity);
569: END IF;
570: IF (NVL(TRIM(X_preferred_grade),'-999') <> NVL( TRIM(Recinfo.preferred_grade),'-999')) THEN
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_preferred_grade ||' Database preferred_grade '||Recinfo.preferred_grade);
572: END IF;

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

567: IF (NVL(X_Secondary_quantity,-999) <> NVL(Recinfo.Secondary_quantity,-999)) THEN
568: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Secondary_quantity '||X_Secondary_quantity||' Database Secondary_quantity '||Recinfo.Secondary_quantity);
569: END IF;
570: IF (NVL(TRIM(X_preferred_grade),'-999') <> NVL( TRIM(Recinfo.preferred_grade),'-999')) THEN
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_preferred_grade ||' Database preferred_grade '||Recinfo.preferred_grade);
572: END IF;
573: IF (NVL(TRIM(X_global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_Category),'-999')) THEN
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute_Category '||X_global_attribute_Category ||' Database global_attribute_Category '||Recinfo.global_attribute_Category);
575: END IF;

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

570: IF (NVL(TRIM(X_preferred_grade),'-999') <> NVL( TRIM(Recinfo.preferred_grade),'-999')) THEN
571: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form preferred_grade '||X_preferred_grade ||' Database preferred_grade '||Recinfo.preferred_grade);
572: END IF;
573: IF (NVL(TRIM(X_global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_Category),'-999')) THEN
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute_Category '||X_global_attribute_Category ||' Database global_attribute_Category '||Recinfo.global_attribute_Category);
575: END IF;
576: IF (NVL(TRIM(X_global_attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute1 '||X_global_attribute1 ||' Database global_attribute1 '||Recinfo.global_attribute1);
578: END IF;

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

573: IF (NVL(TRIM(X_global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_Category),'-999')) THEN
574: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute_Category '||X_global_attribute_Category ||' Database global_attribute_Category '||Recinfo.global_attribute_Category);
575: END IF;
576: IF (NVL(TRIM(X_global_attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute1 '||X_global_attribute1 ||' Database global_attribute1 '||Recinfo.global_attribute1);
578: END IF;
579: IF (NVL(TRIM(X_global_attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute2 '||X_global_attribute2 ||' Database global_attribute2 '||Recinfo.global_attribute2);
581: END IF;

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

576: IF (NVL(TRIM(X_global_attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute1 '||X_global_attribute1 ||' Database global_attribute1 '||Recinfo.global_attribute1);
578: END IF;
579: IF (NVL(TRIM(X_global_attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute2 '||X_global_attribute2 ||' Database global_attribute2 '||Recinfo.global_attribute2);
581: END IF;
582: IF (NVL(TRIM(X_global_attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute3 '||X_global_attribute3 ||' Database global_attribute3 '||Recinfo.global_attribute3);
584: END IF;

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

579: IF (NVL(TRIM(X_global_attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute2 '||X_global_attribute2 ||' Database global_attribute2 '||Recinfo.global_attribute2);
581: END IF;
582: IF (NVL(TRIM(X_global_attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute3 '||X_global_attribute3 ||' Database global_attribute3 '||Recinfo.global_attribute3);
584: END IF;
585: IF (NVL(TRIM(X_global_attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute4 '||X_global_attribute4 ||' Database global_attribute4 '||Recinfo.global_attribute4);
587: END IF;

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

582: IF (NVL(TRIM(X_global_attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute3 '||X_global_attribute3 ||' Database global_attribute3 '||Recinfo.global_attribute3);
584: END IF;
585: IF (NVL(TRIM(X_global_attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute4 '||X_global_attribute4 ||' Database global_attribute4 '||Recinfo.global_attribute4);
587: END IF;
588: IF (NVL(TRIM(X_global_attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute5 '||X_global_attribute5 ||' Database global_attribute5 '||Recinfo.global_attribute5);
590: END IF;

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

585: IF (NVL(TRIM(X_global_attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute4 '||X_global_attribute4 ||' Database global_attribute4 '||Recinfo.global_attribute4);
587: END IF;
588: IF (NVL(TRIM(X_global_attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute5 '||X_global_attribute5 ||' Database global_attribute5 '||Recinfo.global_attribute5);
590: END IF;
591: IF (NVL(TRIM(X_global_attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute6 '||X_global_attribute6 ||' Database global_attribute6 '||Recinfo.global_attribute6);
593: END IF;

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

588: IF (NVL(TRIM(X_global_attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute5 '||X_global_attribute5 ||' Database global_attribute5 '||Recinfo.global_attribute5);
590: END IF;
591: IF (NVL(TRIM(X_global_attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute6 '||X_global_attribute6 ||' Database global_attribute6 '||Recinfo.global_attribute6);
593: END IF;
594: IF (NVL(TRIM(X_global_attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute7 '||X_global_attribute7 ||' Database global_attribute7 '||Recinfo.global_attribute7);
596: END IF;

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

591: IF (NVL(TRIM(X_global_attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute6 '||X_global_attribute6 ||' Database global_attribute6 '||Recinfo.global_attribute6);
593: END IF;
594: IF (NVL(TRIM(X_global_attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute7 '||X_global_attribute7 ||' Database global_attribute7 '||Recinfo.global_attribute7);
596: END IF;
597: IF (NVL(TRIM(X_global_attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute8 '||X_global_attribute8 ||' Database global_attribute8 '||Recinfo.global_attribute8);
599: END IF;

Line 598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute8 '||X_global_attribute8 ||' Database global_attribute8 '||Recinfo.global_attribute8);

594: IF (NVL(TRIM(X_global_attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute7 '||X_global_attribute7 ||' Database global_attribute7 '||Recinfo.global_attribute7);
596: END IF;
597: IF (NVL(TRIM(X_global_attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute8 '||X_global_attribute8 ||' Database global_attribute8 '||Recinfo.global_attribute8);
599: END IF;
600: IF (NVL(TRIM(X_global_attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute9 '||X_global_attribute9 ||' Database global_attribute9 '||Recinfo.global_attribute9);
602: END IF;

Line 601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute9 '||X_global_attribute9 ||' Database global_attribute9 '||Recinfo.global_attribute9);

597: IF (NVL(TRIM(X_global_attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute8 '||X_global_attribute8 ||' Database global_attribute8 '||Recinfo.global_attribute8);
599: END IF;
600: IF (NVL(TRIM(X_global_attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute9 '||X_global_attribute9 ||' Database global_attribute9 '||Recinfo.global_attribute9);
602: END IF;
603: IF (NVL(TRIM(X_global_attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute10 '||X_global_attribute10 ||' Database global_attribute10 '||Recinfo.global_attribute10);
605: END IF;

Line 604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute10 '||X_global_attribute10 ||' Database global_attribute10 '||Recinfo.global_attribute10);

600: IF (NVL(TRIM(X_global_attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
601: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute9 '||X_global_attribute9 ||' Database global_attribute9 '||Recinfo.global_attribute9);
602: END IF;
603: IF (NVL(TRIM(X_global_attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute10 '||X_global_attribute10 ||' Database global_attribute10 '||Recinfo.global_attribute10);
605: END IF;
606: IF (NVL(TRIM(X_global_attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
607: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute11 '||X_global_attribute11 ||' Database global_attribute11 '||Recinfo.global_attribute11);
608: END IF;

Line 607: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute11 '||X_global_attribute11 ||' Database global_attribute11 '||Recinfo.global_attribute11);

603: IF (NVL(TRIM(X_global_attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
604: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute10 '||X_global_attribute10 ||' Database global_attribute10 '||Recinfo.global_attribute10);
605: END IF;
606: IF (NVL(TRIM(X_global_attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
607: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute11 '||X_global_attribute11 ||' Database global_attribute11 '||Recinfo.global_attribute11);
608: END IF;
609: IF (NVL(TRIM(X_global_attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute12 '||X_global_attribute12 ||' Database global_attribute12 '||Recinfo.global_attribute12);
611: END IF;

Line 610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute12 '||X_global_attribute12 ||' Database global_attribute12 '||Recinfo.global_attribute12);

606: IF (NVL(TRIM(X_global_attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
607: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute11 '||X_global_attribute11 ||' Database global_attribute11 '||Recinfo.global_attribute11);
608: END IF;
609: IF (NVL(TRIM(X_global_attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute12 '||X_global_attribute12 ||' Database global_attribute12 '||Recinfo.global_attribute12);
611: END IF;
612: IF (NVL(TRIM(X_global_attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
613: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute13 '||X_global_attribute13 ||' Database global_attribute13 '||Recinfo.global_attribute13);
614: END IF;

Line 613: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute13 '||X_global_attribute13 ||' Database global_attribute13 '||Recinfo.global_attribute13);

609: IF (NVL(TRIM(X_global_attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
610: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute12 '||X_global_attribute12 ||' Database global_attribute12 '||Recinfo.global_attribute12);
611: END IF;
612: IF (NVL(TRIM(X_global_attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
613: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute13 '||X_global_attribute13 ||' Database global_attribute13 '||Recinfo.global_attribute13);
614: END IF;
615: IF (NVL(TRIM(X_global_attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
616: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute14 '||X_global_attribute14 ||' Database global_attribute14 '||Recinfo.global_attribute14);
617: END IF;

Line 616: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute14 '||X_global_attribute14 ||' Database global_attribute14 '||Recinfo.global_attribute14);

612: IF (NVL(TRIM(X_global_attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
613: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute13 '||X_global_attribute13 ||' Database global_attribute13 '||Recinfo.global_attribute13);
614: END IF;
615: IF (NVL(TRIM(X_global_attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
616: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute14 '||X_global_attribute14 ||' Database global_attribute14 '||Recinfo.global_attribute14);
617: END IF;
618: IF (NVL(TRIM(X_global_attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
619: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute15 '||X_global_attribute15 ||' Database global_attribute15 '||Recinfo.global_attribute15);
620: END IF;

Line 619: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute15 '||X_global_attribute15 ||' Database global_attribute15 '||Recinfo.global_attribute15);

615: IF (NVL(TRIM(X_global_attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
616: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute14 '||X_global_attribute14 ||' Database global_attribute14 '||Recinfo.global_attribute14);
617: END IF;
618: IF (NVL(TRIM(X_global_attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
619: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute15 '||X_global_attribute15 ||' Database global_attribute15 '||Recinfo.global_attribute15);
620: END IF;
621: IF (NVL(TRIM(X_global_attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute16 '||X_global_attribute16 ||' Database global_attribute16 '||Recinfo.global_attribute16);
623: END IF;

Line 622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute16 '||X_global_attribute16 ||' Database global_attribute16 '||Recinfo.global_attribute16);

618: IF (NVL(TRIM(X_global_attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
619: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute15 '||X_global_attribute15 ||' Database global_attribute15 '||Recinfo.global_attribute15);
620: END IF;
621: IF (NVL(TRIM(X_global_attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute16 '||X_global_attribute16 ||' Database global_attribute16 '||Recinfo.global_attribute16);
623: END IF;
624: IF (NVL(TRIM(X_global_attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute17 '||X_global_attribute17 ||' Database global_attribute17 '||Recinfo.global_attribute17);
626: END IF;

Line 625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute17 '||X_global_attribute17 ||' Database global_attribute17 '||Recinfo.global_attribute17);

621: IF (NVL(TRIM(X_global_attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute16 '||X_global_attribute16 ||' Database global_attribute16 '||Recinfo.global_attribute16);
623: END IF;
624: IF (NVL(TRIM(X_global_attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute17 '||X_global_attribute17 ||' Database global_attribute17 '||Recinfo.global_attribute17);
626: END IF;
627: IF (NVL(TRIM(X_global_attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute18 '||X_global_attribute18 ||' Database global_attribute18 '||Recinfo.global_attribute18);
629: END IF;

Line 628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute18 '||X_global_attribute18 ||' Database global_attribute18 '||Recinfo.global_attribute18);

624: IF (NVL(TRIM(X_global_attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute17 '||X_global_attribute17 ||' Database global_attribute17 '||Recinfo.global_attribute17);
626: END IF;
627: IF (NVL(TRIM(X_global_attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute18 '||X_global_attribute18 ||' Database global_attribute18 '||Recinfo.global_attribute18);
629: END IF;
630: IF (NVL(TRIM(X_global_attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute19 '||X_global_attribute19 ||' Database global_attribute19 '||Recinfo.global_attribute19);
632: END IF;

Line 631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute19 '||X_global_attribute19 ||' Database global_attribute19 '||Recinfo.global_attribute19);

627: IF (NVL(TRIM(X_global_attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute18 '||X_global_attribute18 ||' Database global_attribute18 '||Recinfo.global_attribute18);
629: END IF;
630: IF (NVL(TRIM(X_global_attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute19 '||X_global_attribute19 ||' Database global_attribute19 '||Recinfo.global_attribute19);
632: END IF;
633: IF (NVL(TRIM(X_global_attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute20 '||X_global_attribute20 ||' Database global_attribute20 '||Recinfo.global_attribute20);
635: END IF;

Line 634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute20 '||X_global_attribute20 ||' Database global_attribute20 '||Recinfo.global_attribute20);

630: IF (NVL(TRIM(X_global_attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute19 '||X_global_attribute19 ||' Database global_attribute19 '||Recinfo.global_attribute19);
632: END IF;
633: IF (NVL(TRIM(X_global_attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute20 '||X_global_attribute20 ||' Database global_attribute20 '||Recinfo.global_attribute20);
635: END IF;
636: IF (NVL(X_job_id,'-999') <> NVL( Recinfo.job_id,'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form job_id '||X_job_id ||' Database job_id '||Recinfo.job_id);
638: END IF;

Line 637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form job_id '||X_job_id ||' Database job_id '||Recinfo.job_id);

633: IF (NVL(TRIM(X_global_attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form global_attribute20 '||X_global_attribute20 ||' Database global_attribute20 '||Recinfo.global_attribute20);
635: END IF;
636: IF (NVL(X_job_id,'-999') <> NVL( Recinfo.job_id,'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form job_id '||X_job_id ||' Database job_id '||Recinfo.job_id);
638: END IF;
639: IF (NVL(TRIM(X_contractor_first_name),'-999') <> NVL( TRIM(Recinfo.contractor_first_name),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_first_name '||X_contractor_first_name ||' Database contractor_first_name '||Recinfo.contractor_first_name);
641: END IF;

Line 640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_first_name '||X_contractor_first_name ||' Database contractor_first_name '||Recinfo.contractor_first_name);

636: IF (NVL(X_job_id,'-999') <> NVL( Recinfo.job_id,'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form job_id '||X_job_id ||' Database job_id '||Recinfo.job_id);
638: END IF;
639: IF (NVL(TRIM(X_contractor_first_name),'-999') <> NVL( TRIM(Recinfo.contractor_first_name),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_first_name '||X_contractor_first_name ||' Database contractor_first_name '||Recinfo.contractor_first_name);
641: END IF;
642: IF (NVL(TRIM(X_contractor_last_name),'-999') <> NVL( TRIM(Recinfo.contractor_last_name),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_last_name '||X_contractor_last_name ||' Database contractor_last_name '||Recinfo.contractor_last_name);
644: END IF;

Line 643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_last_name '||X_contractor_last_name ||' Database contractor_last_name '||Recinfo.contractor_last_name);

639: IF (NVL(TRIM(X_contractor_first_name),'-999') <> NVL( TRIM(Recinfo.contractor_first_name),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_first_name '||X_contractor_first_name ||' Database contractor_first_name '||Recinfo.contractor_first_name);
641: END IF;
642: IF (NVL(TRIM(X_contractor_last_name),'-999') <> NVL( TRIM(Recinfo.contractor_last_name),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_last_name '||X_contractor_last_name ||' Database contractor_last_name '||Recinfo.contractor_last_name);
644: END IF;
645: IF ( X_assignment_start_date <> Recinfo.start_date) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_assignment_start_date ||' Database start_date '||Recinfo.start_date);
647: END IF;

Line 646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_assignment_start_date ||' Database start_date '||Recinfo.start_date);

642: IF (NVL(TRIM(X_contractor_last_name),'-999') <> NVL( TRIM(Recinfo.contractor_last_name),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form contractor_last_name '||X_contractor_last_name ||' Database contractor_last_name '||Recinfo.contractor_last_name);
644: END IF;
645: IF ( X_assignment_start_date <> Recinfo.start_date) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_assignment_start_date ||' Database start_date '||Recinfo.start_date);
647: END IF;
648: IF (NVL(X_amount_db,-999) <> NVL( Recinfo.amount,-999)) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount '||X_amount_db ||' Database X_amount_db '||Recinfo.amount);
650: END IF;

Line 649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount '||X_amount_db ||' Database X_amount_db '||Recinfo.amount);

645: IF ( X_assignment_start_date <> Recinfo.start_date) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_assignment_start_date ||' Database start_date '||Recinfo.start_date);
647: END IF;
648: IF (NVL(X_amount_db,-999) <> NVL( Recinfo.amount,-999)) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount '||X_amount_db ||' Database X_amount_db '||Recinfo.amount);
650: END IF;
651: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
653: END IF;

Line 652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);

648: IF (NVL(X_amount_db,-999) <> NVL( Recinfo.amount,-999)) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form amount '||X_amount_db ||' Database X_amount_db '||Recinfo.amount);
650: END IF;
651: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
653: END IF;
654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed second if statement when comparing fields');
655: END IF; --end g_fnd_debug = 'Y'
656: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed second if statement when comparing fields');

650: END IF;
651: IF (NVL(TRIM(X_Reference_Num),'-999') <> NVL( TRIM(Recinfo.reference_num),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form reference_num '||X_Reference_Num ||' Database reference_num '||Recinfo.reference_num);
653: END IF;
654: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed second if statement when comparing fields');
655: END IF; --end g_fnd_debug = 'Y'
656: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
657: APP_EXCEPTION.RAISE_EXCEPTION;
658: END IF;

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

660: --only display discrepancy when fnd debug is enabled
661: IF (g_fnd_debug = 'Y') THEN
662: --Included for Debugging Purposes
663: IF (NVL(X_Po_Header_Id ,-999) <> NVL(Recinfo.Po_Header_Id,-999) ) THEN
664: 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);
665: END IF;
666: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.Po_Line_Id,-999)) THEN
667: 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);
668: END IF;

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

663: IF (NVL(X_Po_Header_Id ,-999) <> NVL(Recinfo.Po_Header_Id,-999) ) THEN
664: 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);
665: END IF;
666: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.Po_Line_Id,-999)) THEN
667: 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);
668: END IF;
669: IF (NVL(X_line_type_id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id '||X_line_type_id||' Database line_type_id '||Recinfo.line_type_id);
671: END IF;

Line 670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id '||X_line_type_id||' Database line_type_id '||Recinfo.line_type_id);

666: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.Po_Line_Id,-999)) THEN
667: 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);
668: END IF;
669: IF (NVL(X_line_type_id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id '||X_line_type_id||' Database line_type_id '||Recinfo.line_type_id);
671: END IF;
672: IF (NVL(X_Line_Num ,-999) <> NVL( Recinfo.Line_Num,-999)) THEN
673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Num '||X_Line_Num ||' Database Line_Num '||Recinfo.Line_Num);
674: END IF;

Line 673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Num '||X_Line_Num ||' Database Line_Num '||Recinfo.Line_Num);

669: IF (NVL(X_line_type_id,-999) <> NVL(Recinfo.line_type_id,-999)) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_type_id '||X_line_type_id||' Database line_type_id '||Recinfo.line_type_id);
671: END IF;
672: IF (NVL(X_Line_Num ,-999) <> NVL( Recinfo.Line_Num,-999)) THEN
673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Num '||X_Line_Num ||' Database Line_Num '||Recinfo.Line_Num);
674: END IF;
675: IF (NVL(X_item_id ,-999) <> NVL( Recinfo.item_id,-999)) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id '||X_item_id ||' Database item_id '||Recinfo.item_id);
677: END IF;

Line 676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id '||X_item_id ||' Database item_id '||Recinfo.item_id);

672: IF (NVL(X_Line_Num ,-999) <> NVL( Recinfo.Line_Num,-999)) THEN
673: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Line_Num '||X_Line_Num ||' Database Line_Num '||Recinfo.Line_Num);
674: END IF;
675: IF (NVL(X_item_id ,-999) <> NVL( Recinfo.item_id,-999)) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id '||X_item_id ||' Database item_id '||Recinfo.item_id);
677: END IF;
678: IF (NVL(TRIM(X_item_revision),'-999') <> NVL( TRIM(Recinfo.item_revision),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_item_revision ||' Database item_revision '||Recinfo.item_revision);
680: END IF;

Line 679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_item_revision ||' Database item_revision '||Recinfo.item_revision);

675: IF (NVL(X_item_id ,-999) <> NVL( Recinfo.item_id,-999)) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_id '||X_item_id ||' Database item_id '||Recinfo.item_id);
677: END IF;
678: IF (NVL(TRIM(X_item_revision),'-999') <> NVL( TRIM(Recinfo.item_revision),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_item_revision ||' Database item_revision '||Recinfo.item_revision);
680: END IF;
681: IF (NVL(X_category_id,-999) <> NVL( Recinfo.category_id,-999)) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id '||X_category_id ||' Database category_id '||Recinfo.category_id);
683: END IF;

Line 682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id '||X_category_id ||' Database category_id '||Recinfo.category_id);

678: IF (NVL(TRIM(X_item_revision),'-999') <> NVL( TRIM(Recinfo.item_revision),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_revision '||X_item_revision ||' Database item_revision '||Recinfo.item_revision);
680: END IF;
681: IF (NVL(X_category_id,-999) <> NVL( Recinfo.category_id,-999)) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id '||X_category_id ||' Database category_id '||Recinfo.category_id);
683: END IF;
684: IF (NVL(TRIM(X_item_description) ,'-999') <> NVL( TRIM(Recinfo.item_description) ,'-999')) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_item_description ||' Database item_description '||Recinfo.item_description);
686: END IF;

Line 685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_item_description ||' Database item_description '||Recinfo.item_description);

681: IF (NVL(X_category_id,-999) <> NVL( Recinfo.category_id,-999)) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form category_id '||X_category_id ||' Database category_id '||Recinfo.category_id);
683: END IF;
684: IF (NVL(TRIM(X_item_description) ,'-999') <> NVL( TRIM(Recinfo.item_description) ,'-999')) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_item_description ||' Database item_description '||Recinfo.item_description);
686: END IF;
687: IF (NVL(TRIM(X_unit_meas_lookup_code),'-999') <> NVL(TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_unit_meas_lookup_code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
689: END IF;

Line 688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_unit_meas_lookup_code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);

684: IF (NVL(TRIM(X_item_description) ,'-999') <> NVL( TRIM(Recinfo.item_description) ,'-999')) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form item_description '||X_item_description ||' Database item_description '||Recinfo.item_description);
686: END IF;
687: IF (NVL(TRIM(X_unit_meas_lookup_code),'-999') <> NVL(TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_unit_meas_lookup_code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
689: END IF;
690: IF (NVL(X_quantity_committed,-999) <> NVL( Recinfo.quantity_committed,-999)) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_committed '||X_quantity_committed ||' Database quantity_committed '||Recinfo.quantity_committed);
692: END IF;

Line 691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_committed '||X_quantity_committed ||' Database quantity_committed '||Recinfo.quantity_committed);

687: IF (NVL(TRIM(X_unit_meas_lookup_code),'-999') <> NVL(TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unit_meas_lookup_code '||X_unit_meas_lookup_code ||' Database unit_meas_lookup_code '||Recinfo.unit_meas_lookup_code);
689: END IF;
690: IF (NVL(X_quantity_committed,-999) <> NVL( Recinfo.quantity_committed,-999)) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_committed '||X_quantity_committed ||' Database quantity_committed '||Recinfo.quantity_committed);
692: END IF;
693: IF (NVL(X_committed_amount,-999) <> NVL( Recinfo.committed_amount,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form committed_amount '||X_committed_amount ||' Database committed_amount '||Recinfo.committed_amount);
695: END IF;

Line 694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form committed_amount '||X_committed_amount ||' Database committed_amount '||Recinfo.committed_amount);

690: IF (NVL(X_quantity_committed,-999) <> NVL( Recinfo.quantity_committed,-999)) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_committed '||X_quantity_committed ||' Database quantity_committed '||Recinfo.quantity_committed);
692: END IF;
693: IF (NVL(X_committed_amount,-999) <> NVL( Recinfo.committed_amount,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form committed_amount '||X_committed_amount ||' Database committed_amount '||Recinfo.committed_amount);
695: END IF;
696: IF (NVL(TRIM(X_allow_price_override_flag),'-999') <> NVL( TRIM(Recinfo.allow_price_override_flag),'-999')) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_price_override_flag '||X_allow_price_override_flag ||' Database allow_price_override_flag '||Recinfo.allow_price_override_flag);
698: END IF;

Line 697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_price_override_flag '||X_allow_price_override_flag ||' Database allow_price_override_flag '||Recinfo.allow_price_override_flag);

693: IF (NVL(X_committed_amount,-999) <> NVL( Recinfo.committed_amount,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form committed_amount '||X_committed_amount ||' Database committed_amount '||Recinfo.committed_amount);
695: END IF;
696: IF (NVL(TRIM(X_allow_price_override_flag),'-999') <> NVL( TRIM(Recinfo.allow_price_override_flag),'-999')) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_price_override_flag '||X_allow_price_override_flag ||' Database allow_price_override_flag '||Recinfo.allow_price_override_flag);
698: END IF;
699: IF (NVL(X_not_to_exceed_price,-999) <> NVL( Recinfo.not_to_exceed_price ,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form not_to_exceed_price '||X_not_to_exceed_price ||' Database not_to_exceed_price '||Recinfo.not_to_exceed_price);
701: END IF;

Line 700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form not_to_exceed_price '||X_not_to_exceed_price ||' Database not_to_exceed_price '||Recinfo.not_to_exceed_price);

696: IF (NVL(TRIM(X_allow_price_override_flag),'-999') <> NVL( TRIM(Recinfo.allow_price_override_flag),'-999')) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_price_override_flag '||X_allow_price_override_flag ||' Database allow_price_override_flag '||Recinfo.allow_price_override_flag);
698: END IF;
699: IF (NVL(X_not_to_exceed_price,-999) <> NVL( Recinfo.not_to_exceed_price ,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form not_to_exceed_price '||X_not_to_exceed_price ||' Database not_to_exceed_price '||Recinfo.not_to_exceed_price);
701: END IF;
702: IF (NVL(X_list_price_per_unit,-999) <> NVL( Recinfo.list_price_per_unit,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form list_price_per_unit '||X_list_price_per_unit ||' Database list_price_per_unit '||Recinfo.list_price_per_unit);
704: END IF;

Line 703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form list_price_per_unit '||X_list_price_per_unit ||' Database list_price_per_unit '||Recinfo.list_price_per_unit);

699: IF (NVL(X_not_to_exceed_price,-999) <> NVL( Recinfo.not_to_exceed_price ,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form not_to_exceed_price '||X_not_to_exceed_price ||' Database not_to_exceed_price '||Recinfo.not_to_exceed_price);
701: END IF;
702: IF (NVL(X_list_price_per_unit,-999) <> NVL( Recinfo.list_price_per_unit,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form list_price_per_unit '||X_list_price_per_unit ||' Database list_price_per_unit '||Recinfo.list_price_per_unit);
704: END IF;
705: IF (NVL(X_base_unit_price,-999) <> NVL(Recinfo.base_unit_price,-999) ) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form base_unit_price '||X_base_unit_price ||' Database base_unit_price '||Recinfo.base_unit_price);
707: END IF;

Line 706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form base_unit_price '||X_base_unit_price ||' Database base_unit_price '||Recinfo.base_unit_price);

702: IF (NVL(X_list_price_per_unit,-999) <> NVL( Recinfo.list_price_per_unit,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form list_price_per_unit '||X_list_price_per_unit ||' Database list_price_per_unit '||Recinfo.list_price_per_unit);
704: END IF;
705: IF (NVL(X_base_unit_price,-999) <> NVL(Recinfo.base_unit_price,-999) ) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form base_unit_price '||X_base_unit_price ||' Database base_unit_price '||Recinfo.base_unit_price);
707: END IF;
708: IF (NVL(X_unit_price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_unit_price ||' Database unit_price '||Recinfo.unit_price);
710: END IF;

Line 709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_unit_price ||' Database unit_price '||Recinfo.unit_price);

705: IF (NVL(X_base_unit_price,-999) <> NVL(Recinfo.base_unit_price,-999) ) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form base_unit_price '||X_base_unit_price ||' Database base_unit_price '||Recinfo.base_unit_price);
707: END IF;
708: IF (NVL(X_unit_price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_unit_price ||' Database unit_price '||Recinfo.unit_price);
710: END IF;
711: IF (NVL(X_quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
712: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity '||X_quantity ||' Database quantity '||Recinfo.quantity);
713: END IF;

Line 712: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity '||X_quantity ||' Database quantity '||Recinfo.quantity);

708: IF (NVL(X_unit_price,-999) <> NVL(Recinfo.unit_price,-999)) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form Rate '||X_unit_price ||' Database unit_price '||Recinfo.unit_price);
710: END IF;
711: IF (NVL(X_quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
712: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity '||X_quantity ||' Database quantity '||Recinfo.quantity);
713: END IF;
714: IF (NVL(X_un_number_id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id '||X_un_number_id ||' Database un_number_id '||Recinfo.un_number_id);
716: END IF;

Line 715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id '||X_un_number_id ||' Database un_number_id '||Recinfo.un_number_id);

711: IF (NVL(X_quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
712: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity '||X_quantity ||' Database quantity '||Recinfo.quantity);
713: END IF;
714: IF (NVL(X_un_number_id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id '||X_un_number_id ||' Database un_number_id '||Recinfo.un_number_id);
716: END IF;
717: IF (NVL(X_hazard_class_id,-999) <> NVL(Recinfo.hazard_class_id ,-999)) THEN
718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id '||X_hazard_class_id ||' Database hazard_class_id '||Recinfo.hazard_class_id);
719: END IF;

Line 718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id '||X_hazard_class_id ||' Database hazard_class_id '||Recinfo.hazard_class_id);

714: IF (NVL(X_un_number_id,-999) <> NVL(Recinfo.un_number_id,-999)) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form un_number_id '||X_un_number_id ||' Database un_number_id '||Recinfo.un_number_id);
716: END IF;
717: IF (NVL(X_hazard_class_id,-999) <> NVL(Recinfo.hazard_class_id ,-999)) THEN
718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id '||X_hazard_class_id ||' Database hazard_class_id '||Recinfo.hazard_class_id);
719: END IF;
720: IF (NVL(TRIM(X_note_to_vendor),'-999') <> NVL(TRIM(Recinfo.note_to_vendor),'-999')) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_vendor '||X_note_to_vendor ||' Database note_to_vendor '||Recinfo.note_to_vendor);
722: END IF;

Line 721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_vendor '||X_note_to_vendor ||' Database note_to_vendor '||Recinfo.note_to_vendor);

717: IF (NVL(X_hazard_class_id,-999) <> NVL(Recinfo.hazard_class_id ,-999)) THEN
718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form hazard_class_id '||X_hazard_class_id ||' Database hazard_class_id '||Recinfo.hazard_class_id);
719: END IF;
720: IF (NVL(TRIM(X_note_to_vendor),'-999') <> NVL(TRIM(Recinfo.note_to_vendor),'-999')) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_vendor '||X_note_to_vendor ||' Database note_to_vendor '||Recinfo.note_to_vendor);
722: END IF;
723: IF (NVL(X_from_header_id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_header_id '||X_from_header_id ||' Database from_header_id '||Recinfo.from_header_id);
725: END IF;

Line 724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_header_id '||X_from_header_id ||' Database from_header_id '||Recinfo.from_header_id);

720: IF (NVL(TRIM(X_note_to_vendor),'-999') <> NVL(TRIM(Recinfo.note_to_vendor),'-999')) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form note_to_vendor '||X_note_to_vendor ||' Database note_to_vendor '||Recinfo.note_to_vendor);
722: END IF;
723: IF (NVL(X_from_header_id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_header_id '||X_from_header_id ||' Database from_header_id '||Recinfo.from_header_id);
725: END IF;
726: IF (NVL(X_from_line_id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_id '||X_from_line_id ||' Database from_line_id '||Recinfo.from_line_id);
728: END IF;

Line 727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_id '||X_from_line_id ||' Database from_line_id '||Recinfo.from_line_id);

723: IF (NVL(X_from_header_id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_header_id '||X_from_header_id ||' Database from_header_id '||Recinfo.from_header_id);
725: END IF;
726: IF (NVL(X_from_line_id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_id '||X_from_line_id ||' Database from_line_id '||Recinfo.from_line_id);
728: END IF;
729: IF (NVL(X_from_line_location_id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
730: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_location_id '||X_from_line_location_id ||' Database from_line_location_id '||Recinfo.from_line_location_id);
731: END IF;

Line 730: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_location_id '||X_from_line_location_id ||' Database from_line_location_id '||Recinfo.from_line_location_id);

726: IF (NVL(X_from_line_id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
727: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_id '||X_from_line_id ||' Database from_line_id '||Recinfo.from_line_id);
728: END IF;
729: IF (NVL(X_from_line_location_id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
730: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_location_id '||X_from_line_location_id ||' Database from_line_location_id '||Recinfo.from_line_location_id);
731: END IF;
732: IF ( NVL(X_min_order_quantity,-999) <> NVL(Recinfo.min_order_quantity,-999) ) THEN
733: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_order_quantity '||X_min_order_quantity ||' Database min_order_quantity '||Recinfo.min_order_quantity);
734: END IF;

Line 733: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_order_quantity '||X_min_order_quantity ||' Database min_order_quantity '||Recinfo.min_order_quantity);

729: IF (NVL(X_from_line_location_id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
730: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form from_line_location_id '||X_from_line_location_id ||' Database from_line_location_id '||Recinfo.from_line_location_id);
731: END IF;
732: IF ( NVL(X_min_order_quantity,-999) <> NVL(Recinfo.min_order_quantity,-999) ) THEN
733: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_order_quantity '||X_min_order_quantity ||' Database min_order_quantity '||Recinfo.min_order_quantity);
734: END IF;
735: IF (NVL(X_max_order_quantity,-999) <> NVL(Recinfo.max_order_quantity,-999)) THEN
736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form max_order_quantity '||X_max_order_quantity ||' Database max_order_quantity '||Recinfo.max_order_quantity);
737: END IF;

Line 736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form max_order_quantity '||X_max_order_quantity ||' Database max_order_quantity '||Recinfo.max_order_quantity);

732: IF ( NVL(X_min_order_quantity,-999) <> NVL(Recinfo.min_order_quantity,-999) ) THEN
733: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form min_order_quantity '||X_min_order_quantity ||' Database min_order_quantity '||Recinfo.min_order_quantity);
734: END IF;
735: IF (NVL(X_max_order_quantity,-999) <> NVL(Recinfo.max_order_quantity,-999)) THEN
736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form max_order_quantity '||X_max_order_quantity ||' Database max_order_quantity '||Recinfo.max_order_quantity);
737: END IF;
738: IF ( NVL(X_qty_rcv_tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999) ) THEN
739: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_tolerance '||X_qty_rcv_tolerance ||' Database qty_rcv_tolerance '||Recinfo.qty_rcv_tolerance);
740: END IF;

Line 739: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_tolerance '||X_qty_rcv_tolerance ||' Database qty_rcv_tolerance '||Recinfo.qty_rcv_tolerance);

735: IF (NVL(X_max_order_quantity,-999) <> NVL(Recinfo.max_order_quantity,-999)) THEN
736: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form max_order_quantity '||X_max_order_quantity ||' Database max_order_quantity '||Recinfo.max_order_quantity);
737: END IF;
738: IF ( NVL(X_qty_rcv_tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999) ) THEN
739: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_tolerance '||X_qty_rcv_tolerance ||' Database qty_rcv_tolerance '||Recinfo.qty_rcv_tolerance);
740: END IF;
741: IF (NVL(TRIM(X_over_tolerance_error_flag),'-999') <> NVL(TRIM(Recinfo.over_tolerance_error_flag),'-999')) THEN
742: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form over_tolerance_error_flag '||X_over_tolerance_error_flag ||' Database over_tolerance_error_flag '||Recinfo.over_tolerance_error_flag);
743: END IF;

Line 742: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form over_tolerance_error_flag '||X_over_tolerance_error_flag ||' Database over_tolerance_error_flag '||Recinfo.over_tolerance_error_flag);

738: IF ( NVL(X_qty_rcv_tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999) ) THEN
739: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_tolerance '||X_qty_rcv_tolerance ||' Database qty_rcv_tolerance '||Recinfo.qty_rcv_tolerance);
740: END IF;
741: IF (NVL(TRIM(X_over_tolerance_error_flag),'-999') <> NVL(TRIM(Recinfo.over_tolerance_error_flag),'-999')) THEN
742: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form over_tolerance_error_flag '||X_over_tolerance_error_flag ||' Database over_tolerance_error_flag '||Recinfo.over_tolerance_error_flag);
743: END IF;
744: IF (NVL(X_market_price,-999) <> NVL(Recinfo.market_price,-999)) THEN
745: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form market_price '||X_market_price ||' Database market_price '||Recinfo.market_price);
746: END IF;

Line 745: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form market_price '||X_market_price ||' Database market_price '||Recinfo.market_price);

741: IF (NVL(TRIM(X_over_tolerance_error_flag),'-999') <> NVL(TRIM(Recinfo.over_tolerance_error_flag),'-999')) THEN
742: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form over_tolerance_error_flag '||X_over_tolerance_error_flag ||' Database over_tolerance_error_flag '||Recinfo.over_tolerance_error_flag);
743: END IF;
744: IF (NVL(X_market_price,-999) <> NVL(Recinfo.market_price,-999)) THEN
745: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form market_price '||X_market_price ||' Database market_price '||Recinfo.market_price);
746: END IF;
747: IF (NVL(TRIM(X_unordered_flag),'-999') <> NVL(TRIM(Recinfo.unordered_flag),'-999')) THEN
748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unordered_flag '||X_unordered_flag ||' Database unordered_flag '||Recinfo.unordered_flag);
749: END IF;

Line 748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unordered_flag '||X_unordered_flag ||' Database unordered_flag '||Recinfo.unordered_flag);

744: IF (NVL(X_market_price,-999) <> NVL(Recinfo.market_price,-999)) THEN
745: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form market_price '||X_market_price ||' Database market_price '||Recinfo.market_price);
746: END IF;
747: IF (NVL(TRIM(X_unordered_flag),'-999') <> NVL(TRIM(Recinfo.unordered_flag),'-999')) THEN
748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unordered_flag '||X_unordered_flag ||' Database unordered_flag '||Recinfo.unordered_flag);
749: END IF;
750: IF (NVL(TRIM(X_closed_flag),'-999') <> NVL(TRIM(Recinfo.closed_flag),'-999')) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_flag '||X_closed_flag ||' Database closed_flag '||Recinfo.closed_flag);
752: END IF;

Line 751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_flag '||X_closed_flag ||' Database closed_flag '||Recinfo.closed_flag);

747: IF (NVL(TRIM(X_unordered_flag),'-999') <> NVL(TRIM(Recinfo.unordered_flag),'-999')) THEN
748: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form unordered_flag '||X_unordered_flag ||' Database unordered_flag '||Recinfo.unordered_flag);
749: END IF;
750: IF (NVL(TRIM(X_closed_flag),'-999') <> NVL(TRIM(Recinfo.closed_flag),'-999')) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_flag '||X_closed_flag ||' Database closed_flag '||Recinfo.closed_flag);
752: END IF;
753: IF ( NVL(TRIM(X_user_hold_flag),'-999') <> NVL(TRIM(Recinfo.user_hold_flag),'-999') ) THEN
754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form user_hold_flag '||X_user_hold_flag ||' Database user_hold_flag '||Recinfo.user_hold_flag);
755: END IF;

Line 754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form user_hold_flag '||X_user_hold_flag ||' Database user_hold_flag '||Recinfo.user_hold_flag);

750: IF (NVL(TRIM(X_closed_flag),'-999') <> NVL(TRIM(Recinfo.closed_flag),'-999')) THEN
751: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form closed_flag '||X_closed_flag ||' Database closed_flag '||Recinfo.closed_flag);
752: END IF;
753: IF ( NVL(TRIM(X_user_hold_flag),'-999') <> NVL(TRIM(Recinfo.user_hold_flag),'-999') ) THEN
754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form user_hold_flag '||X_user_hold_flag ||' Database user_hold_flag '||Recinfo.user_hold_flag);
755: END IF;
756: IF (NVL(TRIM(X_cancel_flag),'-999') <> NVL(TRIM(Recinfo.cancel_flag),'-999')) THEN
757: 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);
758: END IF;

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

753: IF ( NVL(TRIM(X_user_hold_flag),'-999') <> NVL(TRIM(Recinfo.user_hold_flag),'-999') ) THEN
754: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form user_hold_flag '||X_user_hold_flag ||' Database user_hold_flag '||Recinfo.user_hold_flag);
755: END IF;
756: IF (NVL(TRIM(X_cancel_flag),'-999') <> NVL(TRIM(Recinfo.cancel_flag),'-999')) THEN
757: 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);
758: END IF;
759: IF ( NVL(X_cancelled_by,'-999') <> NVL(Recinfo.cancelled_by,'-999') ) THEN
760: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancelled_by '||X_cancelled_by ||' Database cancelled_by '||Recinfo.cancelled_by);
761: END IF;

Line 760: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancelled_by '||X_cancelled_by ||' Database cancelled_by '||Recinfo.cancelled_by);

756: IF (NVL(TRIM(X_cancel_flag),'-999') <> NVL(TRIM(Recinfo.cancel_flag),'-999')) THEN
757: 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);
758: END IF;
759: IF ( NVL(X_cancelled_by,'-999') <> NVL(Recinfo.cancelled_by,'-999') ) THEN
760: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancelled_by '||X_cancelled_by ||' Database cancelled_by '||Recinfo.cancelled_by);
761: END IF;
762: IF (X_cancel_date <> Recinfo.cancel_date) THEN
763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_cancel_date ||' Database cancel_date '||Recinfo.cancel_date);
764: END IF;

Line 763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_cancel_date ||' Database cancel_date '||Recinfo.cancel_date);

759: IF ( NVL(X_cancelled_by,'-999') <> NVL(Recinfo.cancelled_by,'-999') ) THEN
760: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancelled_by '||X_cancelled_by ||' Database cancelled_by '||Recinfo.cancelled_by);
761: END IF;
762: IF (X_cancel_date <> Recinfo.cancel_date) THEN
763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_cancel_date ||' Database cancel_date '||Recinfo.cancel_date);
764: END IF;
765: IF (NVL(TRIM(X_cancel_reason),'-999') <> NVL(TRIM(Recinfo.cancel_reason),'-999')) THEN
766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_cancel_reason ||' Database cancel_reason '||Recinfo.cancel_reason);
767: END IF;

Line 766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_cancel_reason ||' Database cancel_reason '||Recinfo.cancel_reason);

762: IF (X_cancel_date <> Recinfo.cancel_date) THEN
763: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_date '||X_cancel_date ||' Database cancel_date '||Recinfo.cancel_date);
764: END IF;
765: IF (NVL(TRIM(X_cancel_reason),'-999') <> NVL(TRIM(Recinfo.cancel_reason),'-999')) THEN
766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_cancel_reason ||' Database cancel_reason '||Recinfo.cancel_reason);
767: END IF;
768: IF (NVL(TRIM(X_firm_status_lookup_code),'-999') <> NVL(TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_status_lookup_code '||X_firm_status_lookup_code ||' Database firm_status_lookup_code '||Recinfo.firm_status_lookup_code);
770: END IF;

Line 769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_status_lookup_code '||X_firm_status_lookup_code ||' Database firm_status_lookup_code '||Recinfo.firm_status_lookup_code);

765: IF (NVL(TRIM(X_cancel_reason),'-999') <> NVL(TRIM(Recinfo.cancel_reason),'-999')) THEN
766: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form cancel_reason '||X_cancel_reason ||' Database cancel_reason '||Recinfo.cancel_reason);
767: END IF;
768: IF (NVL(TRIM(X_firm_status_lookup_code),'-999') <> NVL(TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_status_lookup_code '||X_firm_status_lookup_code ||' Database firm_status_lookup_code '||Recinfo.firm_status_lookup_code);
770: END IF;
771: IF (X_firm_date <> Recinfo.firm_date) THEN
772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_date '||X_firm_date ||' Database firm_date '||Recinfo.firm_date);
773: END IF;

Line 772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_date '||X_firm_date ||' Database firm_date '||Recinfo.firm_date);

768: IF (NVL(TRIM(X_firm_status_lookup_code),'-999') <> NVL(TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
769: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_status_lookup_code '||X_firm_status_lookup_code ||' Database firm_status_lookup_code '||Recinfo.firm_status_lookup_code);
770: END IF;
771: IF (X_firm_date <> Recinfo.firm_date) THEN
772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_date '||X_firm_date ||' Database firm_date '||Recinfo.firm_date);
773: END IF;
774: IF (NVL(TRIM(X_vendor_product_num),-999) <> NVL(TRIM(Recinfo.vendor_product_num),-999)) THEN
775: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_product_num '||X_vendor_product_num ||' Database vendor_product_num '||Recinfo.vendor_product_num);
776: END IF;

Line 775: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_product_num '||X_vendor_product_num ||' Database vendor_product_num '||Recinfo.vendor_product_num);

771: IF (X_firm_date <> Recinfo.firm_date) THEN
772: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form firm_date '||X_firm_date ||' Database firm_date '||Recinfo.firm_date);
773: END IF;
774: IF (NVL(TRIM(X_vendor_product_num),-999) <> NVL(TRIM(Recinfo.vendor_product_num),-999)) THEN
775: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_product_num '||X_vendor_product_num ||' Database vendor_product_num '||Recinfo.vendor_product_num);
776: END IF;
777: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed first if statement when comparing fields');
778: END IF; --end g_fnd_debug = 'Y'
779: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 777: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed first if statement when comparing fields');

773: END IF;
774: IF (NVL(TRIM(X_vendor_product_num),-999) <> NVL(TRIM(Recinfo.vendor_product_num),-999)) THEN
775: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form vendor_product_num '||X_vendor_product_num ||' Database vendor_product_num '||Recinfo.vendor_product_num);
776: END IF;
777: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name || '.end','Failed first if statement when comparing fields');
778: END IF; --end g_fnd_debug = 'Y'
779: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
780: APP_EXCEPTION.RAISE_EXCEPTION;
781: END IF;