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_LINE_LOCATIONS_PKG_S1 dependencies on FND_LOG

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

495: return;
496: else
497: IF (g_fnd_debug = 'Y') THEN
498: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
500: END IF;
501: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
502: 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);
503: END IF;

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

498: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
499: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
500: END IF;
501: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
502: 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);
503: END IF;
504: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
505: 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);
506: END IF;

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

501: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
502: 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);
503: END IF;
504: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
505: 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);
506: END IF;
507: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
509: END IF;

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

504: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
505: 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);
506: END IF;
507: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
509: END IF;
510: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
512: END IF;

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

507: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
508: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
509: END IF;
510: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
512: END IF;
513: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
515: END IF;

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

510: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
511: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
512: END IF;
513: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
515: END IF;
516: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
518: END IF;

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

513: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
514: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
515: END IF;
516: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
518: END IF;
519: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
521: END IF;

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

516: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
517: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
518: END IF;
519: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
521: END IF;
522: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
524: END IF;

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

519: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
520: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
521: END IF;
522: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
524: END IF;
525: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
526: 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);
527: END IF;

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

522: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
523: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
524: END IF;
525: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
526: 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);
527: END IF;
528: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
530: END IF;

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

525: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
526: 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);
527: END IF;
528: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
530: END IF;
531: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
533: END IF;

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

528: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
529: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
530: END IF;
531: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
533: END IF;
534: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
536: END IF;

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

531: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
532: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
533: END IF;
534: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
536: END IF;
537: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
539: END IF;

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

534: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
535: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
536: END IF;
537: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
539: END IF;
540: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
542: END IF;

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

537: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
538: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
539: END IF;
540: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
542: END IF;
543: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
545: END IF;

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

540: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
541: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
542: END IF;
543: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
545: END IF;
546: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
548: END IF;

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

543: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
544: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
545: END IF;
546: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
548: END IF;
549: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
551: END IF;

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

546: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
547: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
548: END IF;
549: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
551: END IF;
552: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
554: END IF;

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

549: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
550: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
551: END IF;
552: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
554: END IF;
555: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
557: END IF;

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

552: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
553: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
554: END IF;
555: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
557: END IF;
558: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
560: END IF;

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

555: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
556: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
557: END IF;
558: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
560: END IF;
561: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
562: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
563: -- END IF;

Line 562: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);

558: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
559: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
560: END IF;
561: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
562: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
563: -- END IF;
564: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
565: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
566: -- END IF;

Line 565: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);

561: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
562: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
563: -- END IF;
564: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
565: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
566: -- END IF;
567: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
568: 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);
569: END IF;

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

564: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
565: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
566: -- END IF;
567: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
568: 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);
569: END IF;
570: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
571: 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);
572: END IF;

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

567: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
568: 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);
569: END IF;
570: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
571: 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);
572: END IF;
573: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
574: 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);
575: END IF;

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

570: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
571: 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);
572: END IF;
573: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
574: 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);
575: END IF;
576: IF (X_Start_Date <> Recinfo.start_date ) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
578: END IF;

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

573: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
574: 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);
575: END IF;
576: IF (X_Start_Date <> Recinfo.start_date ) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
578: END IF;
579: IF (X_End_Date <> Recinfo.end_date ) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
581: END IF;

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

576: IF (X_Start_Date <> Recinfo.start_date ) THEN
577: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
578: END IF;
579: IF (X_End_Date <> Recinfo.end_date ) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
581: END IF;
582: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
584: END IF;

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

579: IF (X_End_Date <> Recinfo.end_date ) THEN
580: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
581: END IF;
582: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
584: END IF;
585: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
587: END IF;

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

582: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
583: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
584: END IF;
585: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
587: END IF;
588: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
590: END IF;

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

585: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
586: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
587: END IF;
588: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
590: END IF;
591: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
593: END IF;

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

588: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
589: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
590: END IF;
591: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
593: END IF;
594: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
596: END IF;

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

591: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
592: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
593: END IF;
594: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
596: END IF;
597: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
599: END IF;

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

594: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
595: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
596: END IF;
597: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
599: END IF;
600: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
601: 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);
602: END IF;

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

597: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
598: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
599: END IF;
600: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
601: 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);
602: END IF;
603: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
604: 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);
605: END IF;

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

600: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
601: 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);
602: END IF;
603: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
604: 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);
605: END IF;
606: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
607: 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);
608: END IF;

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

603: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
604: 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);
605: END IF;
606: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
607: 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);
608: END IF;
609: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
610: 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);
611: END IF;

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

606: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
607: 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);
608: END IF;
609: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
610: 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);
611: END IF;
612: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
613: 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);
614: END IF;

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

609: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
610: 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);
611: END IF;
612: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
613: 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);
614: END IF;
615: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
616: 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);
617: END IF;

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

612: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
613: 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);
614: END IF;
615: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
616: 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);
617: END IF;
618: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
619: 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);
620: END IF;

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

615: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
616: 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);
617: END IF;
618: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
619: 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);
620: END IF;
621: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
623: END IF;

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

618: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
619: 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);
620: END IF;
621: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
623: END IF;
624: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
626: END IF;

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

621: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
622: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
623: END IF;
624: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
626: END IF;
627: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
629: END IF;

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

624: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
625: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
626: END IF;
627: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
629: END IF;
630: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
632: END IF;

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

627: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
628: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
629: END IF;
630: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
632: END IF;
633: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
635: END IF;

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

630: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
631: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
632: END IF;
633: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
635: END IF;
636: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
638: END IF;

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

633: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
634: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
635: END IF;
636: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
638: END IF;
639: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
641: END IF;

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

636: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
637: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
638: END IF;
639: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
641: END IF;
642: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
644: END IF;

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

639: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
640: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
641: END IF;
642: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
644: END IF;
645: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
647: END IF;

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

642: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
643: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
644: END IF;
645: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
647: END IF;
648: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
650: END IF;

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

645: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
646: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
647: END IF;
648: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
650: END IF;
651: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
653: END IF;

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

648: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
649: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
650: END IF;
651: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
653: END IF;
654: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
656: END IF;

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

651: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
653: END IF;
654: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
656: END IF;
657: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
658: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
659: END IF;

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

654: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
655: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
656: END IF;
657: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
658: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
659: END IF;
660: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
662: END IF;

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

657: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
658: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
659: END IF;
660: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
662: END IF;
663: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
665: END IF;

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

660: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
661: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
662: END IF;
663: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
665: END IF;
666: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
667: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
668: END IF;

Line 667: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);

663: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
664: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
665: END IF;
666: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
667: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
668: END IF;
669: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
671: END IF;

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

666: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
667: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
668: END IF;
669: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
671: END IF;
672: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
673: 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);
674: END IF;

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

669: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
670: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
671: END IF;
672: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
673: 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);
674: END IF;
675: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
677: END IF;

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

672: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
673: 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);
674: END IF;
675: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
677: END IF;
678: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
680: END IF;

Line 679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);

675: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
676: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
677: END IF;
678: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
680: END IF;
681: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
683: END IF;

Line 682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);

678: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
679: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
680: END IF;
681: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
683: END IF;
684: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
686: END IF;

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

681: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
682: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
683: END IF;
684: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
686: END IF;
687: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
689: END IF;

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

684: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
685: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
686: END IF;
687: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
689: END IF;
690: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
692: END IF;

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

687: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
688: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
689: END IF;
690: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
692: END IF;
693: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
695: END IF;

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

690: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
691: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
692: END IF;
693: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
695: END IF;
696: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
698: END IF;

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

693: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
694: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
695: END IF;
696: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
698: END IF;
699: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
701: END IF;

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

696: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
697: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
698: END IF;
699: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
701: END IF;
702: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
704: END IF;

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

699: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
700: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
701: END IF;
702: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
704: END IF;
705: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
707: END IF;

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

702: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
703: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
704: END IF;
705: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
707: END IF;
708: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
710: END IF;

Line 709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);

705: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
706: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
707: END IF;
708: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
710: END IF;
711: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
712: 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);
713: END IF;

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

708: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
709: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
710: END IF;
711: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
712: 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);
713: END IF;
714: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
716: END IF;

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

711: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
712: 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);
713: END IF;
714: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
716: END IF;
717: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
718: 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);
719: END IF;

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

714: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
715: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
716: END IF;
717: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
718: 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);
719: END IF;
720: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
722: END IF;

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

717: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
718: 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);
719: END IF;
720: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
722: END IF;
723: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
725: END IF;

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

720: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
721: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
722: END IF;
723: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
725: END IF;
726: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
727: 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);
728: END IF;

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

723: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
724: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
725: END IF;
726: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
727: 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);
728: END IF;
729: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
730: 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);
731: END IF;

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

726: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
727: 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);
728: END IF;
729: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
730: 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);
731: END IF;
732: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
733: 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);
734: END IF;

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

729: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
730: 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);
731: END IF;
732: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
733: 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);
734: END IF;
735: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
736: 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);
737: END IF;

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

732: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
733: 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);
734: END IF;
735: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
736: 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);
737: END IF;
738: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
739: 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);
740: END IF;

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

735: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
736: 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);
737: END IF;
738: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
739: 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);
740: END IF;
741: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
742: 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);
743: END IF;

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

738: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
739: 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);
740: END IF;
741: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
742: 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);
743: END IF;
744: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
745: 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);
746: END IF;

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

741: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
742: 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);
743: END IF;
744: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
745: 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);
746: END IF;
747: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
748: 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);
749: END IF;

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

744: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
745: 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);
746: END IF;
747: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
748: 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);
749: END IF;
750: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
751: 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);
752: END IF;

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

747: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
748: 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);
749: END IF;
750: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
751: 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);
752: END IF;
753: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
754: 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);
755: END IF;

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

750: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
751: 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);
752: END IF;
753: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
754: 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);
755: END IF;
756: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
757: 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);
758: END IF;

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

753: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
754: 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);
755: END IF;
756: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
757: 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);
758: END IF;
759: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
760: 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);
761: END IF;

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

756: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
757: 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);
758: END IF;
759: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
760: 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);
761: END IF;
762: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
763: 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);
764: END IF;

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

759: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
760: 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);
761: END IF;
762: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
763: 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);
764: END IF;
765: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
766: 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);
767: END IF;

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

762: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
763: 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);
764: END IF;
765: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
766: 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);
767: END IF;
768: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
769: 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);
770: END IF;

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

765: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
766: 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);
767: END IF;
768: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
769: 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);
770: END IF;
771: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
772: 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);
773: END IF;

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

768: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
769: 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);
770: END IF;
771: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
772: 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);
773: END IF;
774: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
775: 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);
776: END IF;

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

771: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
772: 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);
773: END IF;
774: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
775: 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);
776: END IF;
777: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
778: 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);
779: END IF;

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

774: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
775: 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);
776: END IF;
777: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
778: 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);
779: END IF;
780: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
781: 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);
782: END IF;

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

777: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
778: 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);
779: END IF;
780: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
781: 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);
782: END IF;
783: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
784: 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);
785: END IF;

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

780: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
781: 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);
782: END IF;
783: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
784: 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);
785: END IF;
786: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
787: 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);
788: END IF;

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

783: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
784: 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);
785: END IF;
786: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
787: 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);
788: END IF;
789: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
790: 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);
791: END IF;

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

786: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
787: 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);
788: END IF;
789: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
790: 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);
791: END IF;
792: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
793: 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);
794: END IF;

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

789: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
790: 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);
791: END IF;
792: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
793: 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);
794: END IF;
795: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
796: 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);
797: END IF;

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

792: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
793: 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);
794: END IF;
795: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
796: 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);
797: END IF;
798: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
799: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
800: END IF;

Line 799: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);

795: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
796: 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);
797: END IF;
798: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
799: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
800: END IF;
801: IF (NVL(TRIM(X_Invoice_Match_Option),'-999') <> NVL( TRIM(Recinfo.match_option),'-999')) THEN
802: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);
803: END IF;

Line 802: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);

798: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
799: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
800: END IF;
801: IF (NVL(TRIM(X_Invoice_Match_Option),'-999') <> NVL( TRIM(Recinfo.match_option),'-999')) THEN
802: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);
803: END IF;
804: END IF;
805: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
806: APP_EXCEPTION.RAISE_EXCEPTION;

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

807: end if;
808: else
809: IF (g_fnd_debug = 'Y') THEN
810: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
811: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
812: END IF;
813: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
814: 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);
815: END IF;

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

810: IF (NVL(X_Line_Location_Id,-999) <> NVL(Recinfo.line_location_id,-999)) THEN
811: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form line_location_id'||X_Line_Location_Id ||' Database line_location_id '|| Recinfo.line_location_id);
812: END IF;
813: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
814: 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);
815: END IF;
816: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
817: 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);
818: END IF;

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

813: IF (NVL(X_Po_Header_Id,-999) <> NVL(Recinfo.po_header_id,-999)) THEN
814: 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);
815: END IF;
816: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
817: 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);
818: END IF;
819: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
820: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
821: END IF;

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

816: IF (NVL(X_Po_Line_Id,-999) <> NVL(Recinfo.po_line_id,-999)) THEN
817: 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);
818: END IF;
819: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
820: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
821: END IF;
822: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
823: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
824: END IF;

Line 823: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);

819: IF (NVL(X_Quantity,-999) <> NVL(Recinfo.quantity,-999)) THEN
820: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity'||X_Quantity ||' Database quantity '|| Recinfo.quantity);
821: END IF;
822: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
823: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
824: END IF;
825: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
826: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
827: END IF;

Line 826: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);

822: IF (NVL(X_Quantity_Received,-999) <> NVL(Recinfo.quantity_received,-999)) THEN
823: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_received'||X_Quantity_Received ||' Database quantity_received '|| Recinfo.quantity_received);
824: END IF;
825: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
826: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
827: END IF;
828: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
830: END IF;

Line 829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);

825: IF (NVL(X_Quantity_Accepted,-999) <> NVL(Recinfo.quantity_accepted,-999)) THEN
826: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_accepted'||X_Quantity_Accepted ||' Database quantity_accepted '|| Recinfo.quantity_accepted);
827: END IF;
828: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
830: END IF;
831: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
833: END IF;

Line 832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);

828: IF (NVL(X_Quantity_Rejected,-999) <> NVL(Recinfo.quantity_rejected,-999)) THEN
829: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_rejected'||X_Quantity_Rejected ||' Database quantity_rejected '|| Recinfo.quantity_rejected);
830: END IF;
831: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
833: END IF;
834: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
835: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
836: END IF;

Line 835: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);

831: IF (NVL(X_Quantity_Billed,-999) <> NVL(Recinfo.quantity_billed,-999)) THEN
832: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_billed'||X_Quantity_Billed ||' Database quantity_billed '|| Recinfo.quantity_billed);
833: END IF;
834: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
835: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
836: END IF;
837: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
838: 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);
839: END IF;

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

834: IF (NVL(X_Quantity_Cancelled,-999) <> NVL(Recinfo.quantity_cancelled,-999)) THEN
835: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form quantity_cancelled'||X_Quantity_Cancelled ||' Database quantity_cancelled '|| Recinfo.quantity_cancelled);
836: END IF;
837: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
838: 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);
839: END IF;
840: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
841: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
842: END IF;

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

837: IF (NVL(TRIM(X_Unit_Meas_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.unit_meas_lookup_code),'-999')) THEN
838: 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);
839: END IF;
840: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
841: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
842: END IF;
843: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
844: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
845: END IF;

Line 844: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);

840: IF (NVL(X_Po_Release_Id,-999) <> NVL(Recinfo.po_release_id,-999)) THEN
841: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form po_release_id'||X_Po_Release_Id ||' Database po_release_id '|| Recinfo.po_release_id);
842: END IF;
843: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
844: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
845: END IF;
846: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
847: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
848: END IF;

Line 847: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);

843: IF (NVL(X_Ship_To_Location_Id,-999) <> NVL(Recinfo.ship_to_location_id,-999)) THEN
844: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_location_id'||X_Ship_To_Location_Id ||' Database ship_to_location_id '|| Recinfo.ship_to_location_id);
845: END IF;
846: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
847: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
848: END IF;
849: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
851: END IF;

Line 850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);

846: IF (NVL(TRIM(X_Ship_Via_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.ship_via_lookup_code),'-999')) THEN
847: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_via_lookup_code '||X_Ship_Via_Lookup_Code ||' Database ship_via_lookup_code '||Recinfo.ship_via_lookup_code);
848: END IF;
849: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
851: END IF;
852: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
853: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
854: END IF;

Line 853: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);

849: IF (X_Need_By_Date <> Recinfo.need_by_date ) THEN
850: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form need_by_date '||X_Need_By_Date ||' Database need_by_date '||Recinfo.need_by_date);
851: END IF;
852: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
853: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
854: END IF;
855: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
856: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
857: END IF;

Line 856: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);

852: IF (X_Promised_Date <> Recinfo.promised_date ) THEN
853: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form promised_date '||X_Promised_Date ||' Database promised_date '||Recinfo.promised_date);
854: END IF;
855: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
856: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
857: END IF;
858: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
859: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
860: END IF;

Line 859: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);

855: IF (X_Last_Accept_Date <> Recinfo.last_accept_date ) THEN
856: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form last_accept_date '||X_Last_Accept_Date ||' Database last_accept_date '||Recinfo.last_accept_date);
857: END IF;
858: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
859: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
860: END IF;
861: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
862: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
863: END IF;

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

858: IF (NVL(X_Price_Override,-999) <> NVL(Recinfo.price_override,-999)) THEN
859: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_override'||X_Price_Override ||' Database price_override '|| Recinfo.price_override);
860: END IF;
861: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
862: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
863: END IF;
864: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
866: END IF;

Line 865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);

861: IF (NVL(TRIM(X_Encumbered_Flag),'-999') <> NVL( TRIM(Recinfo.encumbered_flag),'-999')) THEN
862: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_flag '||X_Encumbered_Flag ||' Database encumbered_flag '||Recinfo.encumbered_flag);
863: END IF;
864: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
866: END IF;
867: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
869: END IF;

Line 868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);

864: IF (X_Encumbered_Date <> Recinfo.encumbered_date ) THEN
865: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form encumbered_date '||X_Encumbered_Date ||' Database encumbered_date '||Recinfo.encumbered_date);
866: END IF;
867: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
869: END IF;
870: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
871: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
872: END IF;

Line 871: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);

867: IF (NVL(TRIM(X_Fob_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.fob_lookup_code),'-999')) THEN
868: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form fob_lookup_code '||X_Fob_Lookup_Code ||' Database fob_lookup_code '||Recinfo.fob_lookup_code);
869: END IF;
870: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
871: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
872: END IF;
873: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
874: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
875: -- END IF;

Line 874: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);

870: IF (NVL(TRIM(X_Freight_Terms_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.freight_terms_lookup_code),'-999')) THEN
871: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form freight_terms_lookup_code '||X_Freight_Terms_Lookup_Code ||' Database freight_terms_lookup_code '||Recinfo.freight_terms_lookup_code);
872: END IF;
873: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
874: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
875: -- END IF;
876: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
877: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
878: -- END IF;

Line 877: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);

873: -- IF (NVL(X_Tax_Code_Id,-999) <> NVL(Recinfo.taRecinfo.code_id,-999)) THEN
874: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tacode_id'||X_Tax_Code_Id ||' Database tacode_id '|| Recinfo.taRecinfo.code_id);
875: -- END IF;
876: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
877: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
878: -- END IF;
879: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
880: 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);
881: END IF;

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

876: -- IF (NVL(TRIM(X_Tax_User_Override_Flag),'-999') <> NVL( TRIM(Recinfo.taRecinfo.user_override_flag),'-999')) THEN
877: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form tauser_override_flag '||X_Tax_User_Override_Flag ||' Database tauser_override_flag '||Recinfo.taRecinfo.user_override_flag);
878: -- END IF;
879: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
880: 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);
881: END IF;
882: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
883: 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);
884: END IF;

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

879: IF (NVL(X_From_Header_Id,-999) <> NVL(Recinfo.from_header_id,-999)) THEN
880: 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);
881: END IF;
882: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
883: 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);
884: END IF;
885: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
886: 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);
887: END IF;

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

882: IF (NVL(X_From_Line_Id,-999) <> NVL(Recinfo.from_line_id,-999)) THEN
883: 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);
884: END IF;
885: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
886: 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);
887: END IF;
888: IF (X_Start_Date <> Recinfo.start_date ) THEN
889: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
890: END IF;

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

885: IF (NVL(X_From_Line_Location_Id,-999) <> NVL(Recinfo.from_line_location_id,-999)) THEN
886: 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);
887: END IF;
888: IF (X_Start_Date <> Recinfo.start_date ) THEN
889: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
890: END IF;
891: IF (X_End_Date <> Recinfo.end_date ) THEN
892: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
893: END IF;

Line 892: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);

888: IF (X_Start_Date <> Recinfo.start_date ) THEN
889: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form start_date '||X_Start_Date ||' Database start_date '||Recinfo.start_date);
890: END IF;
891: IF (X_End_Date <> Recinfo.end_date ) THEN
892: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
893: END IF;
894: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
895: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
896: END IF;

Line 895: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);

891: IF (X_End_Date <> Recinfo.end_date ) THEN
892: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form end_date '||X_End_Date ||' Database end_date '||Recinfo.end_date);
893: END IF;
894: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
895: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
896: END IF;
897: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
899: END IF;

Line 898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);

894: IF (NVL(X_Lead_Time,-999) <> NVL(Recinfo.lead_time,-999)) THEN
895: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time'||X_Lead_Time ||' Database lead_time '|| Recinfo.lead_time);
896: END IF;
897: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
899: END IF;
900: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
901: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
902: END IF;

Line 901: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);

897: IF (NVL(TRIM(X_Lead_Time_Unit),'-999') <> NVL( TRIM(Recinfo.lead_time_unit),'-999')) THEN
898: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form lead_time_unit '||X_Lead_Time_Unit ||' Database lead_time_unit '||Recinfo.lead_time_unit);
899: END IF;
900: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
901: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
902: END IF;
903: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
904: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
905: END IF;

Line 904: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);

900: IF (NVL(X_Price_Discount,-999) <> NVL(Recinfo.price_discount,-999)) THEN
901: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form price_discount'||X_Price_Discount ||' Database price_discount '|| Recinfo.price_discount);
902: END IF;
903: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
904: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
905: END IF;
906: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
908: END IF;

Line 907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);

903: IF (NVL(X_Terms_Id,-999) <> NVL(Recinfo.terms_id,-999)) THEN
904: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form terms_id'||X_Terms_Id ||' Database terms_id '|| Recinfo.terms_id);
905: END IF;
906: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
908: END IF;
909: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
910: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
911: END IF;

Line 910: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);

906: IF (NVL(TRIM(X_Approved_Flag),'-999') <> NVL( TRIM(Recinfo.approved_flag),'-999')) THEN
907: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_flag '||X_Approved_Flag ||' Database approved_flag '||Recinfo.approved_flag);
908: END IF;
909: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
910: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
911: END IF;
912: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
913: 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);
914: END IF;

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

909: IF (X_Approved_Date <> Recinfo.approved_date ) THEN
910: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form approved_date '||X_Approved_Date ||' Database approved_date '||Recinfo.approved_date);
911: END IF;
912: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
913: 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);
914: END IF;
915: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
916: 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);
917: END IF;

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

912: IF (NVL(TRIM(X_Closed_Flag),'-999') <> NVL( TRIM(Recinfo.closed_flag),'-999')) THEN
913: 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);
914: END IF;
915: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
916: 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);
917: END IF;
918: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
919: 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);
920: END IF;

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

915: IF (NVL(TRIM(X_Cancel_Flag),'-999') <> NVL( TRIM(Recinfo.cancel_flag),'-999')) THEN
916: 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);
917: END IF;
918: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
919: 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);
920: END IF;
921: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
922: 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);
923: END IF;

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

918: IF (NVL(X_Cancelled_By,-999) <> NVL(Recinfo.cancelled_by,-999)) THEN
919: 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);
920: END IF;
921: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
922: 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);
923: END IF;
924: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
925: 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);
926: END IF;

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

921: IF (X_Cancel_Date <> Recinfo.cancel_date ) THEN
922: 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);
923: END IF;
924: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
925: 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);
926: END IF;
927: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
928: 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);
929: END IF;

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

924: IF (NVL(TRIM(X_Cancel_Reason),'-999') <> NVL( TRIM(Recinfo.cancel_reason),'-999')) THEN
925: 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);
926: END IF;
927: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
928: 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);
929: END IF;
930: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
931: 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);
932: END IF;

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

927: IF (NVL(TRIM(X_Firm_Status_Lookup_Code),'-999') <> NVL( TRIM(Recinfo.firm_status_lookup_code),'-999')) THEN
928: 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);
929: END IF;
930: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
931: 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);
932: END IF;
933: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
935: END IF;

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

930: IF (NVL(TRIM(X_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.attribute_category),'-999')) THEN
931: 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);
932: END IF;
933: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
935: END IF;
936: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
938: END IF;

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

933: IF (NVL(TRIM(X_Attribute1),'-999') <> NVL( TRIM(Recinfo.attribute1),'-999')) THEN
934: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute1 '||X_Attribute1 ||' Database attribute1 '||Recinfo.attribute1);
935: END IF;
936: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
938: END IF;
939: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
940: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
941: END IF;

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

936: IF (NVL(TRIM(X_Attribute2),'-999') <> NVL( TRIM(Recinfo.attribute2),'-999')) THEN
937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute2 '||X_Attribute2 ||' Database attribute2 '||Recinfo.attribute2);
938: END IF;
939: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
940: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
941: END IF;
942: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
943: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
944: END IF;

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

939: IF (NVL(TRIM(X_Attribute3),'-999') <> NVL( TRIM(Recinfo.attribute3),'-999')) THEN
940: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute3 '||X_Attribute3 ||' Database attribute3 '||Recinfo.attribute3);
941: END IF;
942: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
943: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
944: END IF;
945: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
946: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
947: END IF;

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

942: IF (NVL(TRIM(X_Attribute4),'-999') <> NVL( TRIM(Recinfo.attribute4),'-999')) THEN
943: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute4 '||X_Attribute4 ||' Database attribute4 '||Recinfo.attribute4);
944: END IF;
945: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
946: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
947: END IF;
948: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
950: END IF;

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

945: IF (NVL(TRIM(X_Attribute5),'-999') <> NVL( TRIM(Recinfo.attribute5),'-999')) THEN
946: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute5 '||X_Attribute5 ||' Database attribute5 '||Recinfo.attribute5);
947: END IF;
948: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
950: END IF;
951: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
953: END IF;

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

948: IF (NVL(TRIM(X_Attribute6),'-999') <> NVL( TRIM(Recinfo.attribute6),'-999')) THEN
949: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute6 '||X_Attribute6 ||' Database attribute6 '||Recinfo.attribute6);
950: END IF;
951: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
953: END IF;
954: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
955: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
956: END IF;

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

951: IF (NVL(TRIM(X_Attribute7),'-999') <> NVL( TRIM(Recinfo.attribute7),'-999')) THEN
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute7 '||X_Attribute7 ||' Database attribute7 '||Recinfo.attribute7);
953: END IF;
954: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
955: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
956: END IF;
957: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
958: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
959: END IF;

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

954: IF (NVL(TRIM(X_Attribute8),'-999') <> NVL( TRIM(Recinfo.attribute8),'-999')) THEN
955: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute8 '||X_Attribute8 ||' Database attribute8 '||Recinfo.attribute8);
956: END IF;
957: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
958: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
959: END IF;
960: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
961: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
962: END IF;

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

957: IF (NVL(TRIM(X_Attribute9),'-999') <> NVL( TRIM(Recinfo.attribute9),'-999')) THEN
958: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute9 '||X_Attribute9 ||' Database attribute9 '||Recinfo.attribute9);
959: END IF;
960: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
961: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
962: END IF;
963: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
964: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
965: END IF;

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

960: IF (NVL(TRIM(X_Attribute10),'-999') <> NVL( TRIM(Recinfo.attribute10),'-999')) THEN
961: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute10 '||X_Attribute10 ||' Database attribute10 '||Recinfo.attribute10);
962: END IF;
963: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
964: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
965: END IF;
966: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
967: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
968: END IF;

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

963: IF (NVL(TRIM(X_Attribute11),'-999') <> NVL( TRIM(Recinfo.attribute11),'-999')) THEN
964: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute11 '||X_Attribute11 ||' Database attribute11 '||Recinfo.attribute11);
965: END IF;
966: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
967: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
968: END IF;
969: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
970: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
971: END IF;

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

966: IF (NVL(TRIM(X_Attribute12),'-999') <> NVL( TRIM(Recinfo.attribute12),'-999')) THEN
967: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute12 '||X_Attribute12 ||' Database attribute12 '||Recinfo.attribute12);
968: END IF;
969: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
970: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
971: END IF;
972: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
973: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
974: END IF;

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

969: IF (NVL(TRIM(X_Attribute13),'-999') <> NVL( TRIM(Recinfo.attribute13),'-999')) THEN
970: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute13 '||X_Attribute13 ||' Database attribute13 '||Recinfo.attribute13);
971: END IF;
972: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
973: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
974: END IF;
975: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
977: END IF;

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

972: IF (NVL(TRIM(X_Attribute14),'-999') <> NVL( TRIM(Recinfo.attribute14),'-999')) THEN
973: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute14 '||X_Attribute14 ||' Database attribute14 '||Recinfo.attribute14);
974: END IF;
975: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
977: END IF;
978: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
980: END IF;

Line 979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);

975: IF (NVL(TRIM(X_Attribute15),'-999') <> NVL( TRIM(Recinfo.attribute15),'-999')) THEN
976: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form attribute15 '||X_Attribute15 ||' Database attribute15 '||Recinfo.attribute15);
977: END IF;
978: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
980: END IF;
981: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
983: END IF;

Line 982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);

978: IF (NVL(TRIM(X_Inspection_Required_Flag),'-999') <> NVL( TRIM(Recinfo.inspection_required_flag),'-999')) THEN
979: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form inspection_required_flag '||X_Inspection_Required_Flag ||' Database inspection_required_flag '||Recinfo.inspection_required_flag);
980: END IF;
981: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
983: END IF;
984: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
985: 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);
986: END IF;

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

981: IF (NVL(TRIM(X_Receipt_Required_Flag),'-999') <> NVL( TRIM(Recinfo.receipt_required_flag),'-999')) THEN
982: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_required_flag '||X_Receipt_Required_Flag ||' Database receipt_required_flag '||Recinfo.receipt_required_flag);
983: END IF;
984: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
985: 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);
986: END IF;
987: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
989: END IF;

Line 988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);

984: IF (NVL(X_Qty_Rcv_Tolerance,-999) <> NVL(Recinfo.qty_rcv_tolerance,-999)) THEN
985: 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);
986: END IF;
987: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
989: END IF;
990: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
991: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
992: END IF;

Line 991: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);

987: IF (NVL(TRIM(X_Qty_Rcv_Exception_Code),'-999') <> NVL( TRIM(Recinfo.qty_rcv_exception_code),'-999')) THEN
988: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form qty_rcv_exception_code '||X_Qty_Rcv_Exception_Code ||' Database qty_rcv_exception_code '||Recinfo.qty_rcv_exception_code);
989: END IF;
990: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
991: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
992: END IF;
993: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
994: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
995: END IF;

Line 994: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);

990: IF (NVL(TRIM(X_Enforce_Ship_To_Location),'-999') <> NVL( TRIM(Recinfo.enforce_ship_to_location_code),'-999')) THEN
991: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form enforce_ship_to_location '||X_Enforce_Ship_To_Location ||' Database enforce_ship_to_location '||Recinfo.enforce_ship_to_location_code);
992: END IF;
993: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
994: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
995: END IF;
996: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
997: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
998: END IF;

Line 997: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);

993: IF (NVL(TRIM(X_Allow_Substitute_Receipts),'-999') <> NVL( TRIM(Recinfo.allow_substitute_receipts_flag),'-999')) THEN
994: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form allow_substitute_receipts '||X_Allow_Substitute_Receipts ||' Database allow_substitute_receipts '||Recinfo.allow_substitute_receipts_flag);
995: END IF;
996: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
997: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
998: END IF;
999: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
1000: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
1001: END IF;

Line 1000: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);

996: IF (NVL(X_Days_Early_Receipt_Allowed,-999) <> NVL(Recinfo.days_early_receipt_allowed,-999)) THEN
997: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_early_receipt_allowed'||X_Days_Early_Receipt_Allowed ||' Database days_early_receipt_allowed '|| Recinfo.days_early_receipt_allowed);
998: END IF;
999: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
1000: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
1001: END IF;
1002: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
1003: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
1004: END IF;

Line 1003: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);

999: IF (NVL(X_Days_Late_Receipt_Allowed,-999) <> NVL(Recinfo.days_late_receipt_allowed,-999)) THEN
1000: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form days_late_receipt_allowed'||X_Days_Late_Receipt_Allowed ||' Database days_late_receipt_allowed '|| Recinfo.days_late_receipt_allowed);
1001: END IF;
1002: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
1003: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
1004: END IF;
1005: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
1006: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
1007: END IF;

Line 1006: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);

1002: IF (NVL(TRIM(X_Receipt_Days_Exception_Code),'-999') <> NVL( TRIM(Recinfo.receipt_days_exception_code),'-999')) THEN
1003: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receipt_days_exception_code '||X_Receipt_Days_Exception_Code ||' Database receipt_days_exception_code '||Recinfo.receipt_days_exception_code);
1004: END IF;
1005: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
1006: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
1007: END IF;
1008: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
1009: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
1010: END IF;

Line 1009: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);

1005: IF (NVL(X_Invoice_Close_Tolerance,-999) <> NVL(Recinfo.invoice_close_tolerance,-999)) THEN
1006: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_close_tolerance'||X_Invoice_Close_Tolerance ||' Database invoice_close_tolerance '|| Recinfo.invoice_close_tolerance);
1007: END IF;
1008: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
1009: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
1010: END IF;
1011: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
1012: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
1013: END IF;

Line 1012: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);

1008: IF (NVL(X_Receive_Close_Tolerance,-999) <> NVL(Recinfo.receive_close_tolerance,-999)) THEN
1009: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receive_close_tolerance'||X_Receive_Close_Tolerance ||' Database receive_close_tolerance '|| Recinfo.receive_close_tolerance);
1010: END IF;
1011: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
1012: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
1013: END IF;
1014: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
1015: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
1016: END IF;

Line 1015: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);

1011: IF (NVL(X_Ship_To_Organization_Id,-999) <> NVL(Recinfo.ship_to_organization_id,-999)) THEN
1012: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ship_to_organization_id'||X_Ship_To_Organization_Id ||' Database ship_to_organization_id '|| Recinfo.ship_to_organization_id);
1013: END IF;
1014: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
1015: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
1016: END IF;
1017: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
1019: END IF;

Line 1018: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);

1014: IF (NVL(X_Shipment_Num,-999) <> NVL(Recinfo.shipment_num,-999)) THEN
1015: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_num'||X_Shipment_Num ||' Database shipment_num '|| Recinfo.shipment_num);
1016: END IF;
1017: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
1019: END IF;
1020: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
1021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
1022: END IF;

Line 1021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);

1017: IF (NVL(X_Source_Shipment_Id,-999) <> NVL(Recinfo.source_shipment_id,-999)) THEN
1018: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form source_shipment_id'||X_Source_Shipment_Id ||' Database source_shipment_id '|| Recinfo.source_shipment_id);
1019: END IF;
1020: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
1021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
1022: END IF;
1023: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
1024: 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);
1025: END IF;

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

1020: IF (NVL(TRIM(X_Shipment_Type),'-999') <> NVL( TRIM(Recinfo.shipment_type),'-999')) THEN
1021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form shipment_type '||X_Shipment_Type ||' Database shipment_type '||Recinfo.shipment_type);
1022: END IF;
1023: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
1024: 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);
1025: END IF;
1026: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
1028: END IF;

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

1023: IF (NVL(TRIM(X_Closed_Code),'-999') <> NVL( TRIM(Recinfo.closed_code),'-999')) THEN
1024: 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);
1025: END IF;
1026: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
1028: END IF;
1029: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
1030: 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);
1031: END IF;

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

1026: IF (NVL(TRIM(X_Ussgl_Transaction_Code),'-999') <> NVL( TRIM(Recinfo.ussgl_transaction_code),'-999')) THEN
1027: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form ussgl_transaction_code '||X_Ussgl_Transaction_Code ||' Database ussgl_transaction_code '||Recinfo.ussgl_transaction_code);
1028: END IF;
1029: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
1030: 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);
1031: END IF;
1032: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
1034: END IF;

Line 1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);

1029: IF (NVL(TRIM(X_Government_Context),'-999') <> NVL( TRIM(Recinfo.government_context),'-999')) THEN
1030: 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);
1031: END IF;
1032: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
1034: END IF;
1035: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
1036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
1037: END IF;

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

1032: IF (NVL(X_Receiving_Routing_Id,-999) <> NVL(Recinfo.receiving_routing_id,-999)) THEN
1033: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form receiving_routing_id'||X_Receiving_Routing_Id ||' Database receiving_routing_id '|| Recinfo.receiving_routing_id);
1034: END IF;
1035: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
1036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
1037: END IF;
1038: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
1039: 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);
1040: END IF;

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

1035: IF (NVL(TRIM(X_Accrue_On_Receipt_Flag),'-999') <> NVL( TRIM(Recinfo.accrue_on_receipt_flag),'-999')) THEN
1036: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form accrue_on_receipt_flag '||X_Accrue_On_Receipt_Flag ||' Database accrue_on_receipt_flag '||Recinfo.accrue_on_receipt_flag);
1037: END IF;
1038: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
1039: 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);
1040: END IF;
1041: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
1042: 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);
1043: END IF;

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

1038: IF (NVL(TRIM(X_Closed_Reason),'-999') <> NVL( TRIM(Recinfo.closed_reason),'-999')) THEN
1039: 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);
1040: END IF;
1041: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
1042: 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);
1043: END IF;
1044: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
1045: 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);
1046: END IF;

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

1041: IF (X_Closed_Date <> Recinfo.closed_date ) THEN
1042: 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);
1043: END IF;
1044: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
1045: 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);
1046: END IF;
1047: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
1048: 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);
1049: END IF;

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

1044: IF (NVL(X_Closed_By,-999) <> NVL(Recinfo.closed_by,-999)) THEN
1045: 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);
1046: END IF;
1047: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
1048: 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);
1049: END IF;
1050: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
1051: 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);
1052: END IF;

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

1047: IF (NVL(TRIM(X_Global_Attribute_Category),'-999') <> NVL( TRIM(Recinfo.global_attribute_category),'-999')) THEN
1048: 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);
1049: END IF;
1050: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
1051: 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);
1052: END IF;
1053: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
1054: 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);
1055: END IF;

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

1050: IF (NVL(TRIM(X_Global_Attribute1),'-999') <> NVL( TRIM(Recinfo.global_attribute1),'-999')) THEN
1051: 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);
1052: END IF;
1053: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
1054: 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);
1055: END IF;
1056: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
1057: 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);
1058: END IF;

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

1053: IF (NVL(TRIM(X_Global_Attribute2),'-999') <> NVL( TRIM(Recinfo.global_attribute2),'-999')) THEN
1054: 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);
1055: END IF;
1056: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
1057: 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);
1058: END IF;
1059: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
1060: 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);
1061: END IF;

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

1056: IF (NVL(TRIM(X_Global_Attribute3),'-999') <> NVL( TRIM(Recinfo.global_attribute3),'-999')) THEN
1057: 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);
1058: END IF;
1059: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
1060: 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);
1061: END IF;
1062: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
1063: 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);
1064: END IF;

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

1059: IF (NVL(TRIM(X_Global_Attribute4),'-999') <> NVL( TRIM(Recinfo.global_attribute4),'-999')) THEN
1060: 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);
1061: END IF;
1062: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
1063: 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);
1064: END IF;
1065: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
1066: 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);
1067: END IF;

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

1062: IF (NVL(TRIM(X_Global_Attribute5),'-999') <> NVL( TRIM(Recinfo.global_attribute5),'-999')) THEN
1063: 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);
1064: END IF;
1065: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
1066: 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);
1067: END IF;
1068: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
1069: 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);
1070: END IF;

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

1065: IF (NVL(TRIM(X_Global_Attribute6),'-999') <> NVL( TRIM(Recinfo.global_attribute6),'-999')) THEN
1066: 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);
1067: END IF;
1068: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
1069: 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);
1070: END IF;
1071: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
1072: 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);
1073: END IF;

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

1068: IF (NVL(TRIM(X_Global_Attribute7),'-999') <> NVL( TRIM(Recinfo.global_attribute7),'-999')) THEN
1069: 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);
1070: END IF;
1071: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
1072: 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);
1073: END IF;
1074: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
1075: 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);
1076: END IF;

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

1071: IF (NVL(TRIM(X_Global_Attribute8),'-999') <> NVL( TRIM(Recinfo.global_attribute8),'-999')) THEN
1072: 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);
1073: END IF;
1074: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
1075: 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);
1076: END IF;
1077: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
1078: 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);
1079: END IF;

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

1074: IF (NVL(TRIM(X_Global_Attribute9),'-999') <> NVL( TRIM(Recinfo.global_attribute9),'-999')) THEN
1075: 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);
1076: END IF;
1077: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
1078: 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);
1079: END IF;
1080: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
1081: 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);
1082: END IF;

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

1077: IF (NVL(TRIM(X_Global_Attribute10),'-999') <> NVL( TRIM(Recinfo.global_attribute10),'-999')) THEN
1078: 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);
1079: END IF;
1080: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
1081: 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);
1082: END IF;
1083: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
1084: 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);
1085: END IF;

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

1080: IF (NVL(TRIM(X_Global_Attribute11),'-999') <> NVL( TRIM(Recinfo.global_attribute11),'-999')) THEN
1081: 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);
1082: END IF;
1083: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
1084: 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);
1085: END IF;
1086: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
1087: 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);
1088: END IF;

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

1083: IF (NVL(TRIM(X_Global_Attribute12),'-999') <> NVL( TRIM(Recinfo.global_attribute12),'-999')) THEN
1084: 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);
1085: END IF;
1086: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
1087: 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);
1088: END IF;
1089: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
1090: 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);
1091: END IF;

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

1086: IF (NVL(TRIM(X_Global_Attribute13),'-999') <> NVL( TRIM(Recinfo.global_attribute13),'-999')) THEN
1087: 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);
1088: END IF;
1089: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
1090: 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);
1091: END IF;
1092: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
1093: 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);
1094: END IF;

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

1089: IF (NVL(TRIM(X_Global_Attribute14),'-999') <> NVL( TRIM(Recinfo.global_attribute14),'-999')) THEN
1090: 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);
1091: END IF;
1092: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
1093: 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);
1094: END IF;
1095: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
1096: 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);
1097: END IF;

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

1092: IF (NVL(TRIM(X_Global_Attribute15),'-999') <> NVL( TRIM(Recinfo.global_attribute15),'-999')) THEN
1093: 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);
1094: END IF;
1095: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
1096: 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);
1097: END IF;
1098: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
1099: 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);
1100: END IF;

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

1095: IF (NVL(TRIM(X_Global_Attribute16),'-999') <> NVL( TRIM(Recinfo.global_attribute16),'-999')) THEN
1096: 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);
1097: END IF;
1098: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
1099: 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);
1100: END IF;
1101: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
1102: 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);
1103: END IF;

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

1098: IF (NVL(TRIM(X_Global_Attribute17),'-999') <> NVL( TRIM(Recinfo.global_attribute17),'-999')) THEN
1099: 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);
1100: END IF;
1101: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
1102: 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);
1103: END IF;
1104: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
1105: 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);
1106: END IF;

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

1101: IF (NVL(TRIM(X_Global_Attribute18),'-999') <> NVL( TRIM(Recinfo.global_attribute18),'-999')) THEN
1102: 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);
1103: END IF;
1104: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
1105: 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);
1106: END IF;
1107: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
1108: 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);
1109: END IF;

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

1104: IF (NVL(TRIM(X_Global_Attribute19),'-999') <> NVL( TRIM(Recinfo.global_attribute19),'-999')) THEN
1105: 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);
1106: END IF;
1107: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
1108: 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);
1109: END IF;
1110: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
1112: END IF;

Line 1111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);

1107: IF (NVL(TRIM(X_Global_Attribute20),'-999') <> NVL( TRIM(Recinfo.global_attribute20),'-999')) THEN
1108: 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);
1109: END IF;
1110: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
1112: END IF;
1113: IF (NVL(TRIM(X_Invoice_Match_Option),'-999') <> NVL( TRIM(Recinfo.match_option),'-999')) THEN
1114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);
1115: END IF;

Line 1114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);

1110: IF (NVL(TRIM(X_Country_of_Origin_Code),'-999') <> NVL( TRIM(Recinfo.country_of_origin_code),'-999')) THEN
1111: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form country_of_origin_code '||X_Country_of_Origin_Code ||' Database country_of_origin_code '||Recinfo.country_of_origin_code);
1112: END IF;
1113: IF (NVL(TRIM(X_Invoice_Match_Option),'-999') <> NVL( TRIM(Recinfo.match_option),'-999')) THEN
1114: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,c_log_head || l_api_name,' Form invoice_match_option '||X_Invoice_Match_Option ||' Database invoice_match_option '||Recinfo.match_option);
1115: END IF;
1116: END IF;
1117: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1118: APP_EXCEPTION.RAISE_EXCEPTION;