785:
786: -- Initialize API return status to success
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: ----------------------- FND Logging -----------------------------------
790: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
791: THEN
792: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
786: -- Initialize API return status to success
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: ----------------------- FND Logging -----------------------------------
790: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
791: THEN
792: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
794: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
788:
789: ----------------------- FND Logging -----------------------------------
790: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
791: THEN
792: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
794: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
795: );
796: FND_LOG.String
789: ----------------------- FND Logging -----------------------------------
790: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
791: THEN
792: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
794: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
795: );
796: FND_LOG.String
797: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
792: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
794: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
795: );
796: FND_LOG.String
797: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
798: , 'p_api_version:' || p_api_version
799: );
800: FND_LOG.String
793: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
794: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
795: );
796: FND_LOG.String
797: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
798: , 'p_api_version:' || p_api_version
799: );
800: FND_LOG.String
801: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
796: FND_LOG.String
797: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
798: , 'p_api_version:' || p_api_version
799: );
800: FND_LOG.String
801: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
802: , 'p_init_msg_list:' || p_init_msg_list
803: );
804: FND_LOG.String
797: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
798: , 'p_api_version:' || p_api_version
799: );
800: FND_LOG.String
801: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
802: , 'p_init_msg_list:' || p_init_msg_list
803: );
804: FND_LOG.String
805: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
800: FND_LOG.String
801: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
802: , 'p_init_msg_list:' || p_init_msg_list
803: );
804: FND_LOG.String
805: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
806: , 'p_commit:' || p_commit
807: );
808: FND_LOG.String
801: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
802: , 'p_init_msg_list:' || p_init_msg_list
803: );
804: FND_LOG.String
805: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
806: , 'p_commit:' || p_commit
807: );
808: FND_LOG.String
809: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
804: FND_LOG.String
805: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
806: , 'p_commit:' || p_commit
807: );
808: FND_LOG.String
809: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
810: , 'p_validation_level:' || p_validation_level
811: );
812: FND_LOG.String
805: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
806: , 'p_commit:' || p_commit
807: );
808: FND_LOG.String
809: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
810: , 'p_validation_level:' || p_validation_level
811: );
812: FND_LOG.String
813: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
808: FND_LOG.String
809: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
810: , 'p_validation_level:' || p_validation_level
811: );
812: FND_LOG.String
813: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
814: , 'p_incident_id:' || p_incident_id
815: );
816: FND_LOG.String
809: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
810: , 'p_validation_level:' || p_validation_level
811: );
812: FND_LOG.String
813: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
814: , 'p_incident_id:' || p_incident_id
815: );
816: FND_LOG.String
817: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
812: FND_LOG.String
813: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
814: , 'p_incident_id:' || p_incident_id
815: );
816: FND_LOG.String
817: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
818: , 'p_party_id:' || p_party_id
819: );
820: FND_LOG.String
813: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
814: , 'p_incident_id:' || p_incident_id
815: );
816: FND_LOG.String
817: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
818: , 'p_party_id:' || p_party_id
819: );
820: FND_LOG.String
821: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
816: FND_LOG.String
817: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
818: , 'p_party_id:' || p_party_id
819: );
820: FND_LOG.String
821: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
822: , 'p_account_id:' || p_account_id
823: );
824: FND_LOG.String
817: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
818: , 'p_party_id:' || p_party_id
819: );
820: FND_LOG.String
821: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
822: , 'p_account_id:' || p_account_id
823: );
824: FND_LOG.String
825: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
820: FND_LOG.String
821: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
822: , 'p_account_id:' || p_account_id
823: );
824: FND_LOG.String
825: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
826: , 'p_book_order_flag:' || p_book_order_flag
827: );
828: FND_LOG.String
821: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
822: , 'p_account_id:' || p_account_id
823: );
824: FND_LOG.String
825: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
826: , 'p_book_order_flag:' || p_book_order_flag
827: );
828: FND_LOG.String
829: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
824: FND_LOG.String
825: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
826: , 'p_book_order_flag:' || p_book_order_flag
827: );
828: FND_LOG.String
829: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
830: , 'p_submit_source:' || p_submit_source
831: );
832: FND_LOG.String
825: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
826: , 'p_book_order_flag:' || p_book_order_flag
827: );
828: FND_LOG.String
829: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
830: , 'p_submit_source:' || p_submit_source
831: );
832: FND_LOG.String
833: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
828: FND_LOG.String
829: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
830: , 'p_submit_source:' || p_submit_source
831: );
832: FND_LOG.String
833: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
834: , 'p_submit_from_system:' || p_submit_from_system
835: );
836:
829: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
830: , 'p_submit_source:' || p_submit_source
831: );
832: FND_LOG.String
833: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
834: , 'p_submit_from_system:' || p_submit_from_system
835: );
836:
837: END IF;
841: -- Local Procedure
842:
843: -- Validate parameters
844: IF (p_incident_id is null) THEN
845: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
846: THEN
847: FND_LOG.String
848: ( FND_LOG.level_statement
849: , L_LOG_MODULE || 'get_request_info_end'
843: -- Validate parameters
844: IF (p_incident_id is null) THEN
845: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
846: THEN
847: FND_LOG.String
848: ( FND_LOG.level_statement
849: , L_LOG_MODULE || 'get_request_info_end'
850: , 'invalid input parameter :' || 'p_incident_id'
851: );
844: IF (p_incident_id is null) THEN
845: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
846: THEN
847: FND_LOG.String
848: ( FND_LOG.level_statement
849: , L_LOG_MODULE || 'get_request_info_end'
850: , 'invalid input parameter :' || 'p_incident_id'
851: );
852: END IF;
857: RAISE FND_API.G_EXC_ERROR;
858: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: END IF;
860: IF (p_party_id is null) THEN
861: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
865: , 'p_party_id'
859: END IF;
860: IF (p_party_id is null) THEN
861: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
865: , 'p_party_id'
866: );
867: END IF;
860: IF (p_party_id is null) THEN
861: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
862: THEN
863: FND_LOG.String
864: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
865: , 'p_party_id'
866: );
867: END IF;
868: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
876: -- Added validations for 11.5.10 parameters. There is no validation required
877: -- for submit_from_system parameter.
878: --
879: IF (p_book_order_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)) THEN
880: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
881: THEN
882: FND_LOG.String
883: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
884: , 'p_book_order_flag'
878: --
879: IF (p_book_order_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)) THEN
880: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
881: THEN
882: FND_LOG.String
883: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
884: , 'p_book_order_flag'
885: );
886: END IF;
879: IF (p_book_order_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR)) THEN
880: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
881: THEN
882: FND_LOG.String
883: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
884: , 'p_book_order_flag'
885: );
886: END IF;
887: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
892: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
900: , 'p_submit_source'
894:
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
900: , 'p_submit_source'
901: );
902: END IF;
895: IF (p_submit_source NOT IN ('SR','DR','FS',FND_API.G_MISS_CHAR)) THEN
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
897: THEN
898: FND_LOG.String
899: ( FND_LOG.level_statement, L_LOG_MODULE || 'invalid input parameter :'
900: , 'p_submit_source'
901: );
902: END IF;
903: FND_MESSAGE.Set_Name('CS','CS_CHG_INVALID_SUBMIT_PARAMS');
917: INTO l_acct_no;
918: CLOSE acct_from_party;
919:
920: IF (l_acct_no > 0) and (p_account_id is null) THEN
921: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
922: THEN
923: FND_LOG.String
924: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
925: );
919:
920: IF (l_acct_no > 0) and (p_account_id is null) THEN
921: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
922: THEN
923: FND_LOG.String
924: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
925: );
926: END IF;
927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
920: IF (l_acct_no > 0) and (p_account_id is null) THEN
921: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
922: THEN
923: FND_LOG.String
924: ( FND_LOG.level_statement, L_LOG_MODULE , 'Missing account id'
925: );
926: END IF;
927: FND_MESSAGE.Set_Name('CS','CS_CHG_NO_ACCT_NUM_IN_SR');
928: FND_MESSAGE.Set_Token('ROUTINE',l_api_name_full);
946: -- Get modifier for OM adjustment lines
947: BEGIN
948: l_modifier_line_id := fnd_profile.value_specific('CS_CHARGE_DEFAULT_MODIFIER');
949: -- dbms_output.put_line('Default_Modifier' || l_modifier_line_id);
950: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
951: THEN
952: FND_LOG.String
953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
954: , 'The Value of profile CS_CHARGE_DEFAULT_MODIFIER :' || l_modifier_line_id
948: l_modifier_line_id := fnd_profile.value_specific('CS_CHARGE_DEFAULT_MODIFIER');
949: -- dbms_output.put_line('Default_Modifier' || l_modifier_line_id);
950: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
951: THEN
952: FND_LOG.String
953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
954: , 'The Value of profile CS_CHARGE_DEFAULT_MODIFIER :' || l_modifier_line_id
955: );
956: END IF;
949: -- dbms_output.put_line('Default_Modifier' || l_modifier_line_id);
950: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
951: THEN
952: FND_LOG.String
953: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
954: , 'The Value of profile CS_CHARGE_DEFAULT_MODIFIER :' || l_modifier_line_id
955: );
956: END IF;
957:
974: --
975: BEGIN
976:
977: l_book_order_profile := fnd_profile.value('CS_CHG_CREATE_BOOKED_ORDERS');
978: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
979: THEN
980: FND_LOG.String
981: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
982: , 'The Value of profile CS_CHG_CREATE_BOOKED_ORDERS :' || l_book_order_profile
976:
977: l_book_order_profile := fnd_profile.value('CS_CHG_CREATE_BOOKED_ORDERS');
978: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
979: THEN
980: FND_LOG.String
981: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
982: , 'The Value of profile CS_CHG_CREATE_BOOKED_ORDERS :' || l_book_order_profile
983: );
984: END IF;
977: l_book_order_profile := fnd_profile.value('CS_CHG_CREATE_BOOKED_ORDERS');
978: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
979: THEN
980: FND_LOG.String
981: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
982: , 'The Value of profile CS_CHG_CREATE_BOOKED_ORDERS :' || l_book_order_profile
983: );
984: END IF;
985: -- Set the value of the profile as 'N', if the profile has no value set.
1022: l_ctrl_orig_source := NULL;
1023: l_ctrl_source := NULL;
1024: END IF;
1025:
1026: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1027: THEN
1028: FND_LOG.String
1029: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1030: , 'The defaulted value of parameter l_ctrl_orig_source:' || l_ctrl_orig_source
1024: END IF;
1025:
1026: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1027: THEN
1028: FND_LOG.String
1029: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1030: , 'The defaulted value of parameter l_ctrl_orig_source:' || l_ctrl_orig_source
1031: );
1032: FND_LOG.String
1025:
1026: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1027: THEN
1028: FND_LOG.String
1029: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1030: , 'The defaulted value of parameter l_ctrl_orig_source:' || l_ctrl_orig_source
1031: );
1032: FND_LOG.String
1033: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1028: FND_LOG.String
1029: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1030: , 'The defaulted value of parameter l_ctrl_orig_source:' || l_ctrl_orig_source
1031: );
1032: FND_LOG.String
1033: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1034: , 'The defaulted value of parameter l_ctrl_source:' || l_ctrl_source
1035: );
1036: END IF;
1029: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1030: , 'The defaulted value of parameter l_ctrl_orig_source:' || l_ctrl_orig_source
1031: );
1032: FND_LOG.String
1033: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1034: , 'The defaulted value of parameter l_ctrl_source:' || l_ctrl_source
1035: );
1036: END IF;
1037:
1519:
1520: IF l_billing_flag = 'L' THEN
1521: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_LABOR_ITEM');
1522: l_profile_option := 'CS_REPAIR_DEFAULT_LABOR_ITEM';
1523: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1524: THEN
1525: FND_LOG.String
1526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1527: , 'The Value of profile CS_REPAIR_DEFAULT_LABOR_ITEM :' || l_inv_item_id
1521: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_LABOR_ITEM');
1522: l_profile_option := 'CS_REPAIR_DEFAULT_LABOR_ITEM';
1523: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1524: THEN
1525: FND_LOG.String
1526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1527: , 'The Value of profile CS_REPAIR_DEFAULT_LABOR_ITEM :' || l_inv_item_id
1528: );
1529: END IF;
1522: l_profile_option := 'CS_REPAIR_DEFAULT_LABOR_ITEM';
1523: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1524: THEN
1525: FND_LOG.String
1526: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1527: , 'The Value of profile CS_REPAIR_DEFAULT_LABOR_ITEM :' || l_inv_item_id
1528: );
1529: END IF;
1530: ELSIF l_billing_flag = 'M' THEN
1529: END IF;
1530: ELSIF l_billing_flag = 'M' THEN
1531: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_MATERIAL_ITEM');
1532: l_profile_option := 'CS_REPAIR_DEFAULT_MATERIAL_ITEM';
1533: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1534: THEN
1535: FND_LOG.String
1536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1537: , 'The Value of profile CS_REPAIR_DEFAULT_MATERIAL_ITEM :' || l_inv_item_id
1531: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_MATERIAL_ITEM');
1532: l_profile_option := 'CS_REPAIR_DEFAULT_MATERIAL_ITEM';
1533: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1534: THEN
1535: FND_LOG.String
1536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1537: , 'The Value of profile CS_REPAIR_DEFAULT_MATERIAL_ITEM :' || l_inv_item_id
1538: );
1539: END IF;
1532: l_profile_option := 'CS_REPAIR_DEFAULT_MATERIAL_ITEM';
1533: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1534: THEN
1535: FND_LOG.String
1536: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1537: , 'The Value of profile CS_REPAIR_DEFAULT_MATERIAL_ITEM :' || l_inv_item_id
1538: );
1539: END IF;
1540: ELSIF l_billing_flag = 'E' THEN
1539: END IF;
1540: ELSIF l_billing_flag = 'E' THEN
1541: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_EXPENSE_ITEM');
1542: l_profile_option := 'CS_REPAIR_DEFAULT_EXPENSE_ITEM';
1543: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1544: THEN
1545: FND_LOG.String
1546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1547: , 'The Value of profile CS_REPAIR_DEFAULT_EXPENSE_ITEM :' || l_inv_item_id
1541: l_inv_item_id := FND_PROFILE.VALUE_SPECIFIC('CS_REPAIR_DEFAULT_EXPENSE_ITEM');
1542: l_profile_option := 'CS_REPAIR_DEFAULT_EXPENSE_ITEM';
1543: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1544: THEN
1545: FND_LOG.String
1546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1547: , 'The Value of profile CS_REPAIR_DEFAULT_EXPENSE_ITEM :' || l_inv_item_id
1548: );
1549: END IF;
1542: l_profile_option := 'CS_REPAIR_DEFAULT_EXPENSE_ITEM';
1543: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
1544: THEN
1545: FND_LOG.String
1546: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
1547: , 'The Value of profile CS_REPAIR_DEFAULT_EXPENSE_ITEM :' || l_inv_item_id
1548: );
1549: END IF;
1550: END IF;
2233:
2234: END IF; -- If COMMS_NL_TRACKABLE_FLAG = Y
2235:
2236: --
2237: -- The ASO debug statements are replaced with the FND Logging
2238:
2239: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2240: THEN
2241: FND_LOG.String
2235:
2236: --
2237: -- The ASO debug statements are replaced with the FND Logging
2238:
2239: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2240: THEN
2241: FND_LOG.String
2242: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2243: );
2237: -- The ASO debug statements are replaced with the FND Logging
2238:
2239: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2240: THEN
2241: FND_LOG.String
2242: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2243: );
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2238:
2239: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2240: THEN
2241: FND_LOG.String
2242: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2243: );
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2246: );
2240: THEN
2241: FND_LOG.String
2242: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2243: );
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2246: );
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2241: FND_LOG.String
2242: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2243: );
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2246: );
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2249: );
2243: );
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2246: );
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2249: );
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2244: FND_LOG.String
2245: ( FND_LOG.level_statement, L_LOG_MODULE , 'Beginning Charges submission'
2246: );
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2249: );
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2252: );
2246: );
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2249: );
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2252: );
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2247: FND_LOG.String
2248: ( FND_LOG.level_statement, L_LOG_MODULE , 'Item revision is: ' || EstDtlTab(i).item_revision
2249: );
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2252: );
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2255: ) ;
2249: );
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2252: );
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2255: ) ;
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2250: FND_LOG.String
2251: ( FND_LOG.level_statement, L_LOG_MODULE , 'Estimate Detail_id is: ' || EstDtlTab(i).estimate_detail_id
2252: );
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2255: ) ;
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2258: );
2252: );
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2255: ) ;
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2258: );
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2253: FND_LOG.String
2254: ( FND_LOG.level_statement, L_LOG_MODULE , 'Selling_price: '|| EstDtlTab(i).selling_price
2255: ) ;
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2258: );
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2261: );
2255: ) ;
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2258: );
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2261: );
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2256: FND_LOG.String
2257: ( FND_LOG.level_statement, L_LOG_MODULE , 'After Warranty Cost: ' || EstDtlTab(i).after_warranty_cost
2258: );
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2261: );
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2264: );
2258: );
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2261: );
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2264: );
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2259: FND_LOG.String
2260: ( FND_LOG.level_statement, L_LOG_MODULE , 'Incident Id is: '|| EstDtlTab(i).incident_id
2261: );
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2264: );
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2267: );
2261: );
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2264: );
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2267: );
2268: FND_LOG.String
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2262: FND_LOG.String
2263: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Invoice to party site id: ' || EstDtlTab(i).invoice_to_org_id
2264: );
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2267: );
2268: FND_LOG.String
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2270: );
2264: );
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2267: );
2268: FND_LOG.String
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2270: );
2271:
2272: FND_LOG.String
2265: FND_LOG.String
2266: ( FND_LOG.level_statement, L_LOG_MODULE , 'Charges Ship to party site id: ' || EstDtlTab(i).ship_to_org_id
2267: );
2268: FND_LOG.String
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2270: );
2271:
2272: FND_LOG.String
2273: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.book_flag is: ' || l_control_rec.book_flag
2268: FND_LOG.String
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2270: );
2271:
2272: FND_LOG.String
2273: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.book_flag is: ' || l_control_rec.book_flag
2274: );
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2269: ( FND_LOG.level_statement, L_LOG_MODULE , ' '
2270: );
2271:
2272: FND_LOG.String
2273: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.book_flag is: ' || l_control_rec.book_flag
2274: );
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2277: );
2271:
2272: FND_LOG.String
2273: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.book_flag is: ' || l_control_rec.book_flag
2274: );
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2277: );
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2272: FND_LOG.String
2273: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.book_flag is: ' || l_control_rec.book_flag
2274: );
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2277: );
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2280: );
2274: );
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2277: );
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2280: );
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2275: FND_LOG.String
2276: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_control_rec.calculate_price is: ' || l_control_rec.calculate_price
2277: );
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2280: );
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2283: );
2277: );
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2280: );
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2283: );
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2278: FND_LOG.String
2279: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_id is: '|| l_header_rec.order_id
2280: );
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2283: );
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2286: );
2280: );
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2283: );
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2286: );
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2281: FND_LOG.String
2282: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Order_type_id is: '|| l_header_rec.order_type_id
2283: );
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2286: );
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2289: );
2283: );
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2286: );
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2289: );
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2284: FND_LOG.String
2285: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_source_code is: '|| l_header_rec.quote_source_code
2286: );
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2289: );
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2292: );
2286: );
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2289: );
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2292: );
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2287: FND_LOG.String
2288: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute1 is: '|| l_header_rec.attribute1
2289: );
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2292: );
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2295: );
2289: );
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2292: );
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2295: );
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2290: FND_LOG.String
2291: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute2 is: '|| l_header_rec.attribute2
2292: );
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2295: );
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2298: );
2292: );
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2295: );
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2298: );
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2293: FND_LOG.String
2294: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute3 is: '|| l_header_rec.attribute3
2295: );
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2298: );
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2301: );
2295: );
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2298: );
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2301: );
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2296: FND_LOG.String
2297: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute4 is: '|| l_header_rec.attribute4
2298: );
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2301: );
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2304: );
2298: );
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2301: );
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2304: );
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2299: FND_LOG.String
2300: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute5 is: '|| l_header_rec.attribute5
2301: );
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2304: );
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2307: );
2301: );
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2304: );
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2307: );
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2302: FND_LOG.String
2303: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute6 is: '|| l_header_rec.attribute6
2304: );
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2307: );
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2310: );
2304: );
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2307: );
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2310: );
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2305: FND_LOG.String
2306: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute7 is: '|| l_header_rec.attribute7
2307: );
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2310: );
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2313: );
2307: );
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2310: );
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2313: );
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2308: FND_LOG.String
2309: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute8 is: '|| l_header_rec.attribute8
2310: );
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2313: );
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2316: );
2310: );
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2313: );
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2316: );
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2311: FND_LOG.String
2312: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute9 is: '|| l_header_rec.attribute9
2313: );
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2316: );
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2319: );
2313: );
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2316: );
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2319: );
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2314: FND_LOG.String
2315: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute10 is: '|| l_header_rec.attribute10
2316: );
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2319: );
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2322: );
2316: );
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2319: );
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2322: );
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2317: FND_LOG.String
2318: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute11 is: '|| l_header_rec.attribute11
2319: );
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2322: );
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2325: );
2319: );
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2322: );
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2325: );
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2320: FND_LOG.String
2321: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute12 is: '|| l_header_rec.attribute12
2322: );
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2325: );
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2328: );
2322: );
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2325: );
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2328: );
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2323: FND_LOG.String
2324: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute13 is: '|| l_header_rec.attribute13
2325: );
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2328: );
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2331: );
2325: );
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2328: );
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2331: );
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2326: FND_LOG.String
2327: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute14 is: '|| l_header_rec.attribute14
2328: );
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2331: );
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2334: );
2328: );
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2331: );
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2334: );
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2329: FND_LOG.String
2330: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.attribute15 is: '|| l_header_rec.attribute15
2331: );
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2334: );
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2337: );
2331: );
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2334: );
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2332: FND_LOG.String
2333: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.Org_Id is: '|| l_header_rec.org_id
2334: );
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2340: );
2334: );
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2340: );
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2335: FND_LOG.String
2336: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.party_id (Customer_id) is: ' || l_header_rec.party_id
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2340: );
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2343: );
2337: );
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2340: );
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2343: );
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2338: FND_LOG.String
2339: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.cust_account_id (Customer_account_id) is: ' || l_header_rec.cust_account_id
2340: );
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2343: );
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2346: );
2340: );
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2343: );
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2346: );
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2341: FND_LOG.String
2342: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_header_id is: ' || l_header_rec.quote_header_id
2343: );
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2346: );
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2349: );
2343: );
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2346: );
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2344: FND_LOG.String
2345: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.original_system_reference is: ' || l_header_rec.original_system_reference
2346: );
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2352: );
2346: );
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2352: );
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2347: FND_LOG.String
2348: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.quote_number is: ' || l_header_rec.quote_number
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2352: );
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2355: );
2349: );
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2352: );
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2355: );
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2350: FND_LOG.String
2351: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate is: '|| l_header_rec.exchange_rate
2352: );
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2355: );
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2358: );
2352: );
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2355: );
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2358: );
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2353: FND_LOG.String
2354: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_type_code is: '|| l_header_rec.exchange_type_code
2355: );
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2358: );
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2361: );
2355: );
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2358: );
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2356: FND_LOG.String
2357: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.exchange_rate_date is: '|| l_header_rec.exchange_rate_date
2358: );
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2364: );
2358: );
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2364: );
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2359: FND_LOG.String
2360: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.price_list_id is: ' || l_header_rec.price_list_id
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2364: );
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2367: );
2361: );
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2364: );
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2367: );
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2362: FND_LOG.String
2363: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_header_rec.currency_code is: ' || l_header_rec.currency_code
2364: );
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2367: );
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2370: );
2364: );
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2367: );
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2370: );
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2365: FND_LOG.String
2366: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_cust_account_id: ' || l_header_rec.invoice_to_cust_account_id
2367: );
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2370: );
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2373: );
2367: );
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2370: );
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2373: );
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2368: FND_LOG.String
2369: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_id: ' || l_header_rec.invoice_to_party_id
2370: );
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2373: );
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2376: );
2370: );
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2373: );
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2376: );
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2371: FND_LOG.String
2372: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_Header_rec.invoice_to_party_site_id: ' || l_header_rec.invoice_to_party_site_id
2373: );
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2376: );
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2379: );
2373: );
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2376: );
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2379: );
2380: FND_LOG.String
2381: ( FND_LOG.level_statement, L_LOG_MODULE , 'Non_Src_Reference_Reqd_Flag: ' || l_non_src_reference_reqd
2374: FND_LOG.String
2375: ( FND_LOG.level_statement, L_LOG_MODULE , 'Update_Ib_Flag: ' || l_update_ib_flag
2376: );
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2379: );
2380: FND_LOG.String
2381: ( FND_LOG.level_statement, L_LOG_MODULE , 'Non_Src_Reference_Reqd_Flag: ' || l_non_src_reference_reqd
2382: );
2376: );
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2379: );
2380: FND_LOG.String
2381: ( FND_LOG.level_statement, L_LOG_MODULE , 'Non_Src_Reference_Reqd_Flag: ' || l_non_src_reference_reqd
2382: );
2383:
2384: if l_hd_payment_tbl.count = 0 then
2377: FND_LOG.String
2378: ( FND_LOG.level_statement, L_LOG_MODULE , 'Src_Reference_Reqd_Flag: ' || l_src_reference_reqd
2379: );
2380: FND_LOG.String
2381: ( FND_LOG.level_statement, L_LOG_MODULE , 'Non_Src_Reference_Reqd_Flag: ' || l_non_src_reference_reqd
2382: );
2383:
2384: if l_hd_payment_tbl.count = 0 then
2385: FND_LOG.String
2381: ( FND_LOG.level_statement, L_LOG_MODULE , 'Non_Src_Reference_Reqd_Flag: ' || l_non_src_reference_reqd
2382: );
2383:
2384: if l_hd_payment_tbl.count = 0 then
2385: FND_LOG.String
2386: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl does not exist'
2387: );
2388: else
2389: FND_LOG.String
2382: );
2383:
2384: if l_hd_payment_tbl.count = 0 then
2385: FND_LOG.String
2386: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl does not exist'
2387: );
2388: else
2389: FND_LOG.String
2390: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.cust_po_number is: '|| l_hd_payment_tbl(j).cust_po_number
2385: FND_LOG.String
2386: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl does not exist'
2387: );
2388: else
2389: FND_LOG.String
2390: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.cust_po_number is: '|| l_hd_payment_tbl(j).cust_po_number
2391: );
2392: FND_LOG.String
2393: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.payment_type_code is: '|| l_hd_payment_tbl(j).payment_type_code
2386: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl does not exist'
2387: );
2388: else
2389: FND_LOG.String
2390: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.cust_po_number is: '|| l_hd_payment_tbl(j).cust_po_number
2391: );
2392: FND_LOG.String
2393: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.payment_type_code is: '|| l_hd_payment_tbl(j).payment_type_code
2394: );
2388: else
2389: FND_LOG.String
2390: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.cust_po_number is: '|| l_hd_payment_tbl(j).cust_po_number
2391: );
2392: FND_LOG.String
2393: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.payment_type_code is: '|| l_hd_payment_tbl(j).payment_type_code
2394: );
2395: end if;
2396:
2389: FND_LOG.String
2390: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.cust_po_number is: '|| l_hd_payment_tbl(j).cust_po_number
2391: );
2392: FND_LOG.String
2393: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_payment_tbl.payment_type_code is: '|| l_hd_payment_tbl(j).payment_type_code
2394: );
2395: end if;
2396:
2397: if l_hd_shipment_tbl.count = 0 then
2394: );
2395: end if;
2396:
2397: if l_hd_shipment_tbl.count = 0 then
2398: FND_LOG.String
2399: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl does not exist'
2400: );
2401: else
2402: FND_LOG.String
2395: end if;
2396:
2397: if l_hd_shipment_tbl.count = 0 then
2398: FND_LOG.String
2399: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl does not exist'
2400: );
2401: else
2402: FND_LOG.String
2403: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_cust_account_id: ' || l_hd_shipment_tbl(j).ship_to_cust_account_id
2398: FND_LOG.String
2399: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl does not exist'
2400: );
2401: else
2402: FND_LOG.String
2403: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_cust_account_id: ' || l_hd_shipment_tbl(j).ship_to_cust_account_id
2404: );
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2399: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl does not exist'
2400: );
2401: else
2402: FND_LOG.String
2403: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_cust_account_id: ' || l_hd_shipment_tbl(j).ship_to_cust_account_id
2404: );
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2407: );
2401: else
2402: FND_LOG.String
2403: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_cust_account_id: ' || l_hd_shipment_tbl(j).ship_to_cust_account_id
2404: );
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2407: );
2408: FND_LOG.String
2409: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_site_id: ' || l_hd_shipment_tbl(j).ship_to_party_site_id
2402: FND_LOG.String
2403: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_cust_account_id: ' || l_hd_shipment_tbl(j).ship_to_cust_account_id
2404: );
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2407: );
2408: FND_LOG.String
2409: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_site_id: ' || l_hd_shipment_tbl(j).ship_to_party_site_id
2410: );
2404: );
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2407: );
2408: FND_LOG.String
2409: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_site_id: ' || l_hd_shipment_tbl(j).ship_to_party_site_id
2410: );
2411: end if;
2412:
2405: FND_LOG.String
2406: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_id: ' || l_hd_shipment_tbl(j).ship_to_party_id
2407: );
2408: FND_LOG.String
2409: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_hd_shipment_tbl.ship_to_party_site_id: ' || l_hd_shipment_tbl(j).ship_to_party_site_id
2410: );
2411: end if;
2412:
2413: if l_line_tbl.count = 0 then
2410: );
2411: end if;
2412:
2413: if l_line_tbl.count = 0 then
2414: FND_LOG.String
2415: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl does not exist'
2416: );
2417: else
2418: FND_LOG.String
2411: end if;
2412:
2413: if l_line_tbl.count = 0 then
2414: FND_LOG.String
2415: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl does not exist'
2416: );
2417: else
2418: FND_LOG.String
2419: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.operation_code is: '|| l_line_tbl(j).operation_code
2414: FND_LOG.String
2415: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl does not exist'
2416: );
2417: else
2418: FND_LOG.String
2419: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.operation_code is: '|| l_line_tbl(j).operation_code
2420: );
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2415: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl does not exist'
2416: );
2417: else
2418: FND_LOG.String
2419: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.operation_code is: '|| l_line_tbl(j).operation_code
2420: );
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2423: );
2417: else
2418: FND_LOG.String
2419: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.operation_code is: '|| l_line_tbl(j).operation_code
2420: );
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2423: );
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2418: FND_LOG.String
2419: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.operation_code is: '|| l_line_tbl(j).operation_code
2420: );
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2423: );
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2426: );
2420: );
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2423: );
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2426: );
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2421: FND_LOG.String
2422: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.inventory_item_id is: ' || l_line_tbl(j).inventory_item_id
2423: );
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2426: );
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2429: );
2423: );
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2426: );
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2429: );
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2424: FND_LOG.String
2425: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.UOM_code is: ' || l_line_tbl(j).UOM_code
2426: );
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2429: );
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2432: );
2426: );
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2429: );
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2432: );
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2427: FND_LOG.String
2428: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.order_line_type_id is: ' || l_line_tbl(j).order_line_type_id
2429: );
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2432: );
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2435: );
2429: );
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2432: );
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2435: );
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2430: FND_LOG.String
2431: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quantity is: ' || l_line_tbl(j).quantity
2432: );
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2435: );
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2438: );
2432: );
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2435: );
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2438: );
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2433: FND_LOG.String
2434: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.quote_line_id is: ' || l_line_tbl(j).quote_line_id
2435: );
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2438: );
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2441: );
2435: );
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2438: );
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2441: );
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2436: FND_LOG.String
2437: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.price_list_id is: ' || l_line_tbl(j).price_list_id
2438: );
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2441: );
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2444: );
2438: );
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2441: );
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2444: );
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2439: FND_LOG.String
2440: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_list_price is: ' || l_line_tbl(j).line_list_price
2441: );
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2444: );
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2447: );
2441: );
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2444: );
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2447: );
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2442: FND_LOG.String
2443: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_quote_price is: ' || l_line_tbl(j).line_quote_price
2444: );
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2447: );
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2450: );
2444: );
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2447: );
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2450: );
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2445: FND_LOG.String
2446: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.line_category_code is: ' || l_line_tbl(j).line_category_code
2447: );
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2450: );
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2453: );
2447: );
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2450: );
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2453: );
2454: FND_LOG.String
2455: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_site_id: ' || l_line_tbl(j).invoice_to_party_site_id
2448: FND_LOG.String
2449: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_cust_account_id: ' || l_line_tbl(j).invoice_to_cust_account_id
2450: );
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2453: );
2454: FND_LOG.String
2455: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_site_id: ' || l_line_tbl(j).invoice_to_party_site_id
2456: );
2450: );
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2453: );
2454: FND_LOG.String
2455: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_site_id: ' || l_line_tbl(j).invoice_to_party_site_id
2456: );
2457: end if;
2458:
2451: FND_LOG.String
2452: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_id: ' || l_line_tbl(j).invoice_to_party_id
2453: );
2454: FND_LOG.String
2455: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_tbl.invoice_to_party_site_id: ' || l_line_tbl(j).invoice_to_party_site_id
2456: );
2457: end if;
2458:
2459: if l_ln_shipment_tbl.count = 0 then
2456: );
2457: end if;
2458:
2459: if l_ln_shipment_tbl.count = 0 then
2460: FND_LOG.String
2461: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl does not exist'
2462: );
2463: else
2464: FND_LOG.String
2457: end if;
2458:
2459: if l_ln_shipment_tbl.count = 0 then
2460: FND_LOG.String
2461: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl does not exist'
2462: );
2463: else
2464: FND_LOG.String
2465: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.operation_code is: '|| l_ln_shipment_tbl(j).operation_code
2460: FND_LOG.String
2461: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl does not exist'
2462: );
2463: else
2464: FND_LOG.String
2465: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.operation_code is: '|| l_ln_shipment_tbl(j).operation_code
2466: );
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2461: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl does not exist'
2462: );
2463: else
2464: FND_LOG.String
2465: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.operation_code is: '|| l_ln_shipment_tbl(j).operation_code
2466: );
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2469: );
2463: else
2464: FND_LOG.String
2465: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.operation_code is: '|| l_ln_shipment_tbl(j).operation_code
2466: );
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2469: );
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2464: FND_LOG.String
2465: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.operation_code is: '|| l_ln_shipment_tbl(j).operation_code
2466: );
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2469: );
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2472: );
2466: );
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2469: );
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2467: FND_LOG.String
2468: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_cust_account_id: ' || l_ln_shipment_tbl(j).ship_to_cust_account_id
2469: );
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2475: );
2469: );
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2475: );
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2470: FND_LOG.String
2471: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_id: ' || l_ln_shipment_tbl(j).ship_to_party_id
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2475: );
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2478: );
2472: );
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2475: );
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2478: );
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2473: FND_LOG.String
2474: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.ship_to_party_site_id: ' || l_ln_shipment_tbl(j).ship_to_party_site_id
2475: );
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2478: );
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2481: );
2475: );
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2478: );
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2481: );
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2476: FND_LOG.String
2477: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_line_id is: ' || l_ln_shipment_tbl(j).quote_line_id
2478: );
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2481: );
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2484: );
2478: );
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2481: );
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.qte_line_index is: ' || l_ln_shipment_tbl(j).qte_line_index
2479: FND_LOG.String
2480: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quote_header_id is: ' || l_ln_shipment_tbl(j).quote_header_id
2481: );
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.qte_line_index is: ' || l_ln_shipment_tbl(j).qte_line_index
2487: );
2481: );
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.qte_line_index is: ' || l_ln_shipment_tbl(j).qte_line_index
2487: );
2488: end if;
2489:
2482: FND_LOG.String
2483: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.quantity is: ' || l_ln_shipment_tbl(j).quantity
2484: );
2485: FND_LOG.String
2486: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_ln_shipment_tbl.qte_line_index is: ' || l_ln_shipment_tbl(j).qte_line_index
2487: );
2488: end if;
2489:
2490: if l_line_dtl_tbl.count = 0 then
2487: );
2488: end if;
2489:
2490: if l_line_dtl_tbl.count = 0 then
2491: FND_LOG.String
2492: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl does not exist'
2493: );
2494: else
2495: FND_LOG.String
2488: end if;
2489:
2490: if l_line_dtl_tbl.count = 0 then
2491: FND_LOG.String
2492: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl does not exist'
2493: );
2494: else
2495: FND_LOG.String
2496: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.return_reason_code is: ' || l_line_dtl_tbl(j).return_reason_code
2491: FND_LOG.String
2492: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl does not exist'
2493: );
2494: else
2495: FND_LOG.String
2496: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.return_reason_code is: ' || l_line_dtl_tbl(j).return_reason_code
2497: );
2498: FND_LOG.String
2499: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.qte_line_index is: ' || l_line_dtl_tbl(j).qte_line_index
2492: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl does not exist'
2493: );
2494: else
2495: FND_LOG.String
2496: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.return_reason_code is: ' || l_line_dtl_tbl(j).return_reason_code
2497: );
2498: FND_LOG.String
2499: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.qte_line_index is: ' || l_line_dtl_tbl(j).qte_line_index
2500: );
2494: else
2495: FND_LOG.String
2496: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.return_reason_code is: ' || l_line_dtl_tbl(j).return_reason_code
2497: );
2498: FND_LOG.String
2499: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.qte_line_index is: ' || l_line_dtl_tbl(j).qte_line_index
2500: );
2501: end if;
2502:
2495: FND_LOG.String
2496: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.return_reason_code is: ' || l_line_dtl_tbl(j).return_reason_code
2497: );
2498: FND_LOG.String
2499: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_dtl_tbl.qte_line_index is: ' || l_line_dtl_tbl(j).qte_line_index
2500: );
2501: end if;
2502:
2503: if l_line_price_adj_tbl.count = 0 then
2500: );
2501: end if;
2502:
2503: if l_line_price_adj_tbl.count = 0 then
2504: FND_LOG.String
2505: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl does not exist'
2506: );
2507: else
2508: FND_LOG.String
2501: end if;
2502:
2503: if l_line_price_adj_tbl.count = 0 then
2504: FND_LOG.String
2505: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl does not exist'
2506: );
2507: else
2508: FND_LOG.String
2509: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operation_code is: ' || l_line_price_adj_tbl(j).operation_code
2504: FND_LOG.String
2505: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl does not exist'
2506: );
2507: else
2508: FND_LOG.String
2509: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operation_code is: ' || l_line_price_adj_tbl(j).operation_code
2510: );
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2505: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl does not exist'
2506: );
2507: else
2508: FND_LOG.String
2509: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operation_code is: ' || l_line_price_adj_tbl(j).operation_code
2510: );
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2513: );
2507: else
2508: FND_LOG.String
2509: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operation_code is: ' || l_line_price_adj_tbl(j).operation_code
2510: );
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2513: );
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2508: FND_LOG.String
2509: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operation_code is: ' || l_line_price_adj_tbl(j).operation_code
2510: );
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2513: );
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2516: );
2510: );
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2513: );
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2516: );
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2511: FND_LOG.String
2512: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.qte_line_index is: ' || l_line_price_adj_tbl(j).qte_line_index
2513: );
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2516: );
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2519: );
2513: );
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2516: );
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2519: );
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2514: FND_LOG.String
2515: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_header_id is: ' || l_line_price_adj_tbl(j).modifier_header_id
2516: );
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2519: );
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2522: );
2516: );
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2519: );
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2522: );
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2517: FND_LOG.String
2518: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.modifier_line_id is: ' || l_line_price_adj_tbl(j).modifier_line_id
2519: );
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2522: );
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2525: );
2519: );
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2522: );
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2525: );
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2520: FND_LOG.String
2521: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.operand is: ' || l_line_price_adj_tbl(j).operand
2522: );
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2525: );
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2528: );
2522: );
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2525: );
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2528: );
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2523: FND_LOG.String
2524: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.adjusted_amount is: ' || l_line_price_adj_tbl(j).adjusted_amount
2525: );
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2528: );
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2531: );
2525: );
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2528: );
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2531: );
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2526: FND_LOG.String
2527: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.updated_flag is: ' || l_line_price_adj_tbl(j).updated_flag
2528: );
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2531: );
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2534: );
2528: );
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2531: );
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2534: );
2535: FND_LOG.String
2536: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_text is: ' || l_line_price_adj_tbl(j).change_reason_text
2529: FND_LOG.String
2530: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.applied_flag is: ' || l_line_price_adj_tbl(j).applied_flag
2531: );
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2534: );
2535: FND_LOG.String
2536: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_text is: ' || l_line_price_adj_tbl(j).change_reason_text
2537: );
2531: );
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2534: );
2535: FND_LOG.String
2536: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_text is: ' || l_line_price_adj_tbl(j).change_reason_text
2537: );
2538: end if;
2539:
2532: FND_LOG.String
2533: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_code is: ' || l_line_price_adj_tbl(j).change_reason_code
2534: );
2535: FND_LOG.String
2536: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_line_price_adj_tbl.change_reason_text is: ' || l_line_price_adj_tbl(j).change_reason_text
2537: );
2538: end if;
2539:
2540: if l_lot_serial_tbl.count = 0 then
2537: );
2538: end if;
2539:
2540: if l_lot_serial_tbl.count = 0 then
2541: FND_LOG.String
2542: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl does not exist'
2543: );
2544: else
2545: FND_LOG.String
2538: end if;
2539:
2540: if l_lot_serial_tbl.count = 0 then
2541: FND_LOG.String
2542: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl does not exist'
2543: );
2544: else
2545: FND_LOG.String
2546: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_number is: ' || l_lot_serial_tbl(1).lot_number
2541: FND_LOG.String
2542: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl does not exist'
2543: );
2544: else
2545: FND_LOG.String
2546: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_number is: ' || l_lot_serial_tbl(1).lot_number
2547: );
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2542: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl does not exist'
2543: );
2544: else
2545: FND_LOG.String
2546: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_number is: ' || l_lot_serial_tbl(1).lot_number
2547: );
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2550: );
2544: else
2545: FND_LOG.String
2546: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_number is: ' || l_lot_serial_tbl(1).lot_number
2547: );
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2550: );
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2545: FND_LOG.String
2546: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_number is: ' || l_lot_serial_tbl(1).lot_number
2547: );
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2550: );
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2553: );
2547: );
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2550: );
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2553: );
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2548: FND_LOG.String
2549: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.lot_serial_id is: ' || l_lot_serial_tbl(1).lot_serial_id
2550: );
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2553: );
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2556: );
2550: );
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2553: );
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2556: );
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2551: FND_LOG.String
2552: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.quantity is: ' || l_lot_serial_tbl(1).quantity
2553: );
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2556: );
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2559: );
2553: );
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2556: );
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2559: );
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2554: FND_LOG.String
2555: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.from_serial_number is: ' || l_lot_serial_tbl(1).from_serial_number
2556: );
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2559: );
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2562: );
2556: );
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2559: );
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2562: );
2563: FND_LOG.String
2564: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.line_index is: ' || l_lot_serial_tbl(1).line_index
2557: FND_LOG.String
2558: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.to_serial_number is: ' || l_lot_serial_tbl(1).to_serial_number
2559: );
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2562: );
2563: FND_LOG.String
2564: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.line_index is: ' || l_lot_serial_tbl(1).line_index
2565: );
2559: );
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2562: );
2563: FND_LOG.String
2564: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.line_index is: ' || l_lot_serial_tbl(1).line_index
2565: );
2566: end if;
2567:
2560: FND_LOG.String
2561: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.operation is: ' || l_lot_serial_tbl(1).operation
2562: );
2563: FND_LOG.String
2564: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.line_index is: ' || l_lot_serial_tbl(1).line_index
2565: );
2566: end if;
2567:
2568: FND_LOG.String
2564: ( FND_LOG.level_statement, L_LOG_MODULE , 'l_lot_serial_tbl.line_index is: ' || l_lot_serial_tbl(1).line_index
2565: );
2566: end if;
2567:
2568: FND_LOG.String
2569: ( FND_LOG.level_statement, L_LOG_MODULE , 'Ending Charges submission'
2570: );
2571: FND_LOG.String
2572: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2565: );
2566: end if;
2567:
2568: FND_LOG.String
2569: ( FND_LOG.level_statement, L_LOG_MODULE , 'Ending Charges submission'
2570: );
2571: FND_LOG.String
2572: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2573: );
2567:
2568: FND_LOG.String
2569: ( FND_LOG.level_statement, L_LOG_MODULE , 'Ending Charges submission'
2570: );
2571: FND_LOG.String
2572: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2573: );
2574:
2575: END IF;
2568: FND_LOG.String
2569: ( FND_LOG.level_statement, L_LOG_MODULE , 'Ending Charges submission'
2570: );
2571: FND_LOG.String
2572: ( FND_LOG.level_statement, L_LOG_MODULE , '==================================================='
2573: );
2574:
2575: END IF;
2576:
3164: l_log_module CONSTANT VARCHAR2(255) := 'cs.plsql.' || l_api_name_full || '.';
3165:
3166: BEGIN
3167:
3168: ----------------------- FND Logging -----------------------------------
3169: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3170: THEN
3171: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3165:
3166: BEGIN
3167:
3168: ----------------------- FND Logging -----------------------------------
3169: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3170: THEN
3171: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3173: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3167:
3168: ----------------------- FND Logging -----------------------------------
3169: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3170: THEN
3171: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3173: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3174: );
3175: FND_LOG.String
3168: ----------------------- FND Logging -----------------------------------
3169: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
3170: THEN
3171: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3173: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3174: );
3175: FND_LOG.String
3176: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3171: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3173: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3174: );
3175: FND_LOG.String
3176: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3177: , 'p_Estimate_Detail_Id:' || p_Estimate_Detail_Id
3178: );
3179: FND_LOG.String
3172: ( FND_LOG.level_procedure , L_LOG_MODULE || 'start'
3173: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3174: );
3175: FND_LOG.String
3176: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3177: , 'p_Estimate_Detail_Id:' || p_Estimate_Detail_Id
3178: );
3179: FND_LOG.String
3180: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3175: FND_LOG.String
3176: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3177: , 'p_Estimate_Detail_Id:' || p_Estimate_Detail_Id
3178: );
3179: FND_LOG.String
3180: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3181: , 'p_order_header_Id:' || p_order_header_Id
3182: );
3183: FND_LOG.String
3176: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3177: , 'p_Estimate_Detail_Id:' || p_Estimate_Detail_Id
3178: );
3179: FND_LOG.String
3180: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3181: , 'p_order_header_Id:' || p_order_header_Id
3182: );
3183: FND_LOG.String
3184: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3179: FND_LOG.String
3180: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3181: , 'p_order_header_Id:' || p_order_header_Id
3182: );
3183: FND_LOG.String
3184: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3185: , 'p_order_line_Id:' || p_order_line_Id
3186: );
3187: FND_LOG.String
3180: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3181: , 'p_order_header_Id:' || p_order_header_Id
3182: );
3183: FND_LOG.String
3184: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3185: , 'p_order_line_Id:' || p_order_line_Id
3186: );
3187: FND_LOG.String
3188: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3183: FND_LOG.String
3184: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3185: , 'p_order_line_Id:' || p_order_line_Id
3186: );
3187: FND_LOG.String
3188: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3189: , 'p_line_submitted:' || p_line_submitted
3190: );
3191: FND_LOG.String
3184: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3185: , 'p_order_line_Id:' || p_order_line_Id
3186: );
3187: FND_LOG.String
3188: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3189: , 'p_line_submitted:' || p_line_submitted
3190: );
3191: FND_LOG.String
3192: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3187: FND_LOG.String
3188: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3189: , 'p_line_submitted:' || p_line_submitted
3190: );
3191: FND_LOG.String
3192: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3193: , 'p_submit_restriction_message:' || p_submit_restriction_message
3194: );
3195: FND_LOG.String
3188: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3189: , 'p_line_submitted:' || p_line_submitted
3190: );
3191: FND_LOG.String
3192: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3193: , 'p_submit_restriction_message:' || p_submit_restriction_message
3194: );
3195: FND_LOG.String
3196: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3191: FND_LOG.String
3192: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3193: , 'p_submit_restriction_message:' || p_submit_restriction_message
3194: );
3195: FND_LOG.String
3196: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3197: , 'p_submit_error_message:' || p_submit_error_message
3198: );
3199: FND_LOG.String
3192: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3193: , 'p_submit_restriction_message:' || p_submit_restriction_message
3194: );
3195: FND_LOG.String
3196: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3197: , 'p_submit_error_message:' || p_submit_error_message
3198: );
3199: FND_LOG.String
3200: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3195: FND_LOG.String
3196: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3197: , 'p_submit_error_message:' || p_submit_error_message
3198: );
3199: FND_LOG.String
3200: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3201: , 'p_submit_from_system:' || p_submit_from_system
3202: );
3203: END IF;
3196: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3197: , 'p_submit_error_message:' || p_submit_error_message
3198: );
3199: FND_LOG.String
3200: ( FND_LOG.level_procedure , L_LOG_MODULE || ''
3201: , 'p_submit_from_system:' || p_submit_from_system
3202: );
3203: END IF;
3204: