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

APPS.INL_CHARGE_PVT dependencies on INL_LOGGING_PVT

Line 34: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

30: l_allocation_uom_code VARCHAR(30);
31:
32: BEGIN
33: -- Standard Beginning of Procedure/Function Logging
34: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
35: p_procedure_name => l_proc_name);
36:
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 41: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: l_debug_info := 'Get the Allocation Basis and UOM Code';
41: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
42: p_procedure_name => l_proc_name,
43: p_debug_info => l_debug_info);
44: SELECT icv.allocation_basis,
45: ab.base_uom_code

Line 56: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

52: AND icv.charge_line_type_id (+) = icl.charge_line_type_id
53: AND icl.charge_line_id = p_from_parent_table_id;
54:
55: l_debug_info := 'Insert into INL Associations table';
56: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
57: p_procedure_name => l_proc_name,
58: p_debug_info => l_debug_info);
59:
60: INSERT INTO inl_associations(association_id,

Line 88: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

84: SYSDATE,
85: FND_GLOBAL.login_id);
86:
87: -- Standard End of Procedure/Function Logging
88: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
89: p_procedure_name => l_proc_name);
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 189: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

185: l_charge_line_num NUMBER;
186:
187: BEGIN
188: -- Standard Beginning of Procedure/Function Logging
189: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
190: p_procedure_name => l_proc_name);
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 196: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:
195: l_debug_info := 'Get the Charge Line ID';
196: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
197: p_procedure_name => l_proc_name,
198: p_debug_info => l_debug_info);
199:
200: SELECT inl_charge_lines_s.NEXTVAL

Line 205: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

201: INTO l_charge_line_id
202: FROM dual;
203:
204: l_debug_info := 'Get the Charge Line Number';
205: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
206: p_procedure_name => l_proc_name,
207: p_debug_info => l_debug_info);
208:
209: SELECT NVL(MAX(icl.charge_line_num),0) + 1

Line 218: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

214: AND ias.from_parent_table_id = icl.charge_line_id
215: AND ias.ship_header_id = p_ship_header_id;
216:
217: l_debug_info := 'Insert into INL Charge Line table.';
218: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
219: p_procedure_name => l_proc_name,
220: p_debug_info => l_debug_info);
221:
222: INSERT INTO inl_charge_lines(charge_line_id,

Line 304: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

300: SYSDATE,
301: FND_GLOBAL.login_id);
302:
303: l_debug_info := 'Call Insert_Association(...)';
304: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
305: p_procedure_name => l_proc_name,
306: p_debug_info => l_debug_info);
307:
308: Insert_Association(p_ship_header_id => p_ship_header_id,

Line 321: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Standard End of Procedure/Function Logging
321: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
322: p_procedure_name => l_proc_name);
323: EXCEPTION
324: WHEN OTHERS THEN
325: -- Standard Unexpected Error Logging

Line 326: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

322: p_procedure_name => l_proc_name);
323: EXCEPTION
324: WHEN OTHERS THEN
325: -- Standard Unexpected Error Logging
326: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
327: p_procedure_name => l_proc_name);
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
330: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 398: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

394:
395: BEGIN
396:
397: -- Begin the procedure
398: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
399: p_procedure_name => l_proc_name);
400: -- Init return status
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:

Line 428: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

424: po_advanced_price_pvt.g_hdr.source_org_id := p_source_org_id;
425: po_advanced_price_pvt.g_hdr.expected_receipt_date := p_expected_receipt_date;
426:
427: -- End the procedure
428: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
429: p_procedure_name => l_proc_name);
430: EXCEPTION
431: WHEN OTHERS THEN
432: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 432: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

428: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
429: p_procedure_name => l_proc_name);
430: EXCEPTION
431: WHEN OTHERS THEN
432: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
433: p_procedure_name => l_proc_name);
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: END Populate_HeaderRecord;
436:

Line 501: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

497:
498: BEGIN
499:
500: -- Begin the procedure
501: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
502: p_procedure_name => l_proc_name);
503: -- Init return status
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:

Line 532: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

528: po_advanced_price_pvt.g_line.unit_price := p_unit_price;
529: po_advanced_price_pvt.g_line.quantity := p_quantity;
530:
531: -- End the procedure
532: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
533: p_procedure_name => l_proc_name);
534: EXCEPTION
535: WHEN OTHERS THEN
536: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 536: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

532: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
533: p_procedure_name => l_proc_name);
534: EXCEPTION
535: WHEN OTHERS THEN
536: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
537: p_procedure_name => l_proc_name);
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: END Populate_LineRecord;
540:

Line 624: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

620: l_cost_factor_details pon_price_element_types_vl%ROWTYPE;
621:
622: BEGIN
623: -- Begin the procedure
624: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
625: p_procedure_name => l_proc_name);
626: -- Init return status
627: x_return_status := FND_API.G_RET_STS_SUCCESS;
628:

Line 634: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

630: l_qp_cost_table := qp_price_result_tbl();
631: x_charge_ln_tbl := charge_ln_tbl();
632:
633: l_debug_info := 'Call QP_PRICE_REQUEST_CONTEXT.set_request_id';
634: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
635: p_procedure_name => l_proc_name,
636: p_debug_info => l_debug_info);
637:
638: -- Enable the price engine to identify the data in the

Line 644: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

640: -- pricing engine call.
641: QP_PRICE_REQUEST_CONTEXT.set_request_id;
642:
643: l_debug_info := 'Initialize the Global HDR Structure and QP Context';
644: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
645: p_procedure_name => l_proc_name,
646: p_debug_info => l_debug_info);
647:
648:

Line 674: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

670: p_expected_receipt_date => p_ship_ln_group_rec.expected_receipt_date,
671: x_return_status => l_return_status);
672:
673: l_debug_info := 'Call QP_ATTR_MAPPING_PUB.Build_Contexts for HEADER';
674: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
675: p_procedure_name => l_proc_name,
676: p_debug_info => l_debug_info);
677:
678: -- Build Attributes Mapping Contexts for HEADER

Line 724: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

720: l_list_price_overide_flag_tbl(l_line_index) := 'O';
721: l_line_index := l_line_index + 1;
722:
723: l_debug_info := 'Loop to initialize the Global LINE Structure and QP Context';
724: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
725: p_procedure_name => l_proc_name,
726: p_debug_info => l_debug_info);
727:
728: FOR j IN 1..p_ship_ln_tbl.COUNT LOOP

Line 730: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

726: p_debug_info => l_debug_info);
727:
728: FOR j IN 1..p_ship_ln_tbl.COUNT LOOP
729: l_debug_info := 'Call Populate_LineRecord';
730: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
731: p_procedure_name => l_proc_name,
732: p_debug_info => l_debug_info);
733:
734: -- Populate the Global Line Structure

Line 760: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

756: p_quantity => p_ship_ln_tbl(j).quantity,
757: x_return_status => l_return_status);
758:
759: l_debug_info := 'Call QP_ATTR_MAPPING_PUB.Build_Contexts for each LINE';
760: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
761: p_procedure_name => l_proc_name,
762: p_debug_info => l_debug_info);
763:
764: -- Build Attributes Mapping Contexts for LINES

Line 816: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

812: l_line_index := l_line_index + 1;
813: END LOOP;
814:
815: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
816: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
817: p_procedure_name => l_proc_name,
818: p_debug_info => l_debug_info);
819:
820: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp

Line 872: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870:
871: l_debug_info := 'Populate Control Record variables for Pricing Request Call';
872: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
873: p_procedure_name => l_proc_name,
874: p_debug_info => l_debug_info);
875:
876: l_control_rec.calculate_flag := 'Y';

Line 890: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

886: l_control_rec.function_currency := p_ship_ln_group_rec.currency_code;
887: l_control_rec.get_freight_flag := 'N';
888:
889: l_debug_info := 'Call QP_PREQ_PUB.PRICE_REQUEST';
890: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
891: p_procedure_name => l_proc_name,
892: p_debug_info => l_debug_info);
893:
894: QP_PREQ_PUB.PRICE_REQUEST(p_control_rec => l_control_rec,

Line 913: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

909:
910: -- Access the QP qp_ldets_v view to retrieve the freight charge info.
911: FOR k IN 1..l_line_index-1 LOOP
912: l_debug_info := 'Access the QP qp_ldets_v view to retrieve the freight charge info.';
913: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
914: p_procedure_name => l_proc_name,
915: p_debug_info => l_debug_info);
916:
917: SELECT charge_type_code,

Line 936: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

932: l_qp_cost_table(k).freight_charge_rec_tbl := l_freight_charge_rec_tbl;
933: l_qp_cost_table(k).line_id := l_line_id_tbl(k);
934:
935: l_debug_info := 'Get pricing_status_code and pricing_status_text from qp_preq_lines_tmp';
936: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
937: p_procedure_name => l_proc_name,
938: p_debug_info => l_debug_info);
939:
940: SELECT pricing_status_code,

Line 949: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

945: WHERE line_index = k;
946: END LOOP;
947:
948: l_debug_info := 'Check if the l_qp_cost_table has records';
949: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
950: p_procedure_name => l_proc_name,
951: p_debug_info => l_debug_info);
952:
953: IF l_qp_cost_table.COUNT < 1 THEN

Line 955: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

951: p_debug_info => l_debug_info);
952:
953: IF l_qp_cost_table.COUNT < 1 THEN
954: l_debug_info := 'l_qp_cost_table has no records';
955: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
956: p_procedure_name => l_proc_name,
957: p_debug_info => l_debug_info);
958: END IF;
959:

Line 961: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

957: p_debug_info => l_debug_info);
958: END IF;
959:
960: l_debug_info := 'Iterate through all returned l_qp_cost_table records';
961: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
962: p_procedure_name => l_proc_name,
963: p_debug_info => l_debug_info);
964:
965: FOR k IN l_qp_cost_table.FIRST..l_qp_cost_table.LAST LOOP

Line 969: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

965: FOR k IN l_qp_cost_table.FIRST..l_qp_cost_table.LAST LOOP
966: BEGIN
967: IF l_qp_cost_table(k).freight_charge_rec_tbl.COUNT < 1 THEN
968: l_debug_info := 'The l_no_freight_charge has no records';
969: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
970: p_procedure_name => l_proc_name,
971: p_debug_info => l_debug_info);
972: RAISE l_no_freight_charge;
973: END IF;

Line 977: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

973: END IF;
974:
975: l_freight_charge_tbl := l_qp_cost_table(k).freight_charge_rec_tbl;
976: l_debug_info := 'Iterate through all returned l_freight_charge_tbl records';
977: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
978: p_procedure_name => l_proc_name,
979: p_debug_info => l_debug_info);
980:
981: FOR n IN l_freight_charge_tbl.FIRST..l_freight_charge_tbl.LAST LOOP

Line 983: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

979: p_debug_info => l_debug_info);
980:
981: FOR n IN l_freight_charge_tbl.FIRST..l_freight_charge_tbl.LAST LOOP
982: l_debug_info := 'Call PON_CF_TYPE_GRP.get_cost_factor_details';
983: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
984: p_procedure_name => l_proc_name,
985: p_debug_info => l_debug_info);
986:
987: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 987: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

983: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
984: p_procedure_name => l_proc_name,
985: p_debug_info => l_debug_info);
986:
987: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
988: p_procedure_name => l_proc_name,
989: p_var_name => 'l_freight_charge_tbl(n).charge_type_code',
990: p_var_value => nvl(l_freight_charge_tbl(n).charge_type_code,'NULL'));
991:

Line 995: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

991:
992: l_cost_factor_details := PON_CF_TYPE_GRP.get_cost_factor_details(TO_NUMBER(l_freight_charge_tbl(n).charge_type_code));
993:
994: l_debug_info := 'Populate the x_charge_ln_tbl type table';
995: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
996: p_procedure_name => l_proc_name,
997: p_debug_info => l_debug_info);
998:
999: -- Populate x_charge_ln_tbl

Line 1021: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1017: END LOOP;
1018: EXCEPTION
1019: WHEN l_no_freight_charge THEN
1020: l_debug_info := 'No QP charge for the line : ' || l_qp_cost_table(k).line_id;
1021: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1022: p_procedure_name => l_proc_name,
1023: p_debug_info => l_debug_info);
1024: END;
1025: END LOOP;

Line 1028: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1024: END;
1025: END LOOP;
1026:
1027: -- End the procedure
1028: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1029: p_procedure_name => l_proc_name);
1030: EXCEPTION
1031: WHEN FND_API.G_EXC_ERROR THEN
1032: --raised expected error: assume raiser already pushed onto the stack

Line 1101: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

1097:
1098: BEGIN
1099:
1100: -- Standard Beginning of Procedure/Function Logging
1101: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1102: p_procedure_name => l_api_name);
1103:
1104: -- Standard Start of API savepoint
1105: SAVEPOINT Generate_Charges_PVT;

Line 1125: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1121: -- Initialize API return status to success
1122: x_return_status := FND_API.G_RET_STS_SUCCESS;
1123:
1124: l_debug_info := 'Getting all Shipment Line Groups from a given Shipment Header ID';
1125: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1126: p_procedure_name => l_api_name,
1127: p_debug_info => l_debug_info);
1128:
1129: SELECT ship_line_group_id

Line 1135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1131: FROM inl_ship_line_groups
1132: WHERE ship_header_id = p_ship_header_id
1133: ORDER BY ship_line_group_num;
1134:
1135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1136: p_procedure_name => l_api_name,
1137: p_var_name => 'l_ship_ln_group_id_tbl.COUNT',
1138: p_var_value => l_ship_ln_group_id_tbl.COUNT );
1139:

Line 1142: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1138: p_var_value => l_ship_ln_group_id_tbl.COUNT );
1139:
1140: IF NVL(l_ship_ln_group_id_tbl.COUNT, 0) = 0 THEN
1141: l_debug_info := 'No data found in Shipment Line Groups. Raising expected error.';
1142: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1143: p_procedure_name => l_api_name,
1144: p_debug_info => l_debug_info);
1145: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHAR_LN_GEN');
1146: FND_MSG_PUB.ADD;

Line 1151: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1147: RAISE FND_API.G_EXC_ERROR;
1148: END IF;
1149:
1150: l_debug_info := 'Delete QP Charges and Associations previously to the current Shipment';
1151: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1152: p_procedure_name => l_api_name,
1153: p_debug_info => l_debug_info);
1154:
1155: BEGIN

Line 1168: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1164: AND ias.ship_header_id = p_ship_header_id;
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: l_debug_info := 'There is no QP Charges/Associations previously created to the current line.';
1168: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1169: p_procedure_name => l_api_name,
1170: p_debug_info => l_debug_info);
1171: END;
1172:

Line 1197: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1193: END LOOP;
1194: END IF;
1195:
1196: l_debug_info := 'Iterate through all selected Shipment Line Groups';
1197: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1198: p_procedure_name => l_api_name,
1199: p_debug_info => l_debug_info);
1200:
1201: FOR i IN l_ship_ln_group_id_tbl.FIRST..l_ship_ln_group_id_tbl.LAST LOOP

Line 1203: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1199: p_debug_info => l_debug_info);
1200:
1201: FOR i IN l_ship_ln_group_id_tbl.FIRST..l_ship_ln_group_id_tbl.LAST LOOP
1202: l_debug_info := 'Populate a Shipment Line Group record type';
1203: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1204: p_procedure_name => l_api_name,
1205: p_debug_info => l_debug_info);
1206:
1207:

Line 1253: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1249: AND ilg.ship_line_group_id = l_ship_ln_group_id_tbl(i)
1250: AND ROWNUM < 2;
1251:
1252: l_debug_info := 'Populate the Shipment Lines table type';
1253: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1254: p_procedure_name => l_api_name,
1255: p_debug_info => l_debug_info);
1256:
1257: l_qp_curr_conv_type := NVL(FND_PROFILE.VALUE('INL_QP_CURRENCY_CONVERSION_TYPE'), 'Corporate');

Line 1259: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1255: p_debug_info => l_debug_info);
1256:
1257: l_qp_curr_conv_type := NVL(FND_PROFILE.VALUE('INL_QP_CURRENCY_CONVERSION_TYPE'), 'Corporate');
1258:
1259: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1260: p_procedure_name => l_api_name,
1261: p_var_name => 'l_ship_ln_group_rec.currency_code',
1262: p_var_value => l_ship_ln_group_rec.currency_code);
1263:

Line 1264: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1260: p_procedure_name => l_api_name,
1261: p_var_name => 'l_ship_ln_group_rec.currency_code',
1262: p_var_value => l_ship_ln_group_rec.currency_code);
1263:
1264: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1265: p_procedure_name => l_api_name,
1266: p_var_name => 'l_qp_curr_conv_type',
1267: p_var_value => l_qp_curr_conv_type);
1268:

Line 1337: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1333: ORDER BY isl.ship_line_num;
1334: EXCEPTION
1335: WHEN NO_DATA_FOUND THEN
1336: l_debug_info := 'No data found in Shipment Line Groups / Shipment Line. Raising expected error.';
1337: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1338: p_procedure_name => l_api_name,
1339: p_debug_info => l_debug_info);
1340: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHAR_LN_GEN');
1341: FND_MSG_PUB.ADD;

Line 1346: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1342: RAISE FND_API.G_EXC_ERROR;
1343: END;
1344:
1345: l_debug_info := 'Call INL_CHARGESHOOK_PVT.Get_Charges(...)';
1346: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1347: p_procedure_name => l_api_name,
1348: p_debug_info => l_debug_info);
1349:
1350: INL_CHARGESHOOK_PVT.Get_Charges(p_ship_ln_group_rec => l_ship_ln_group_rec,

Line 1367: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1363: -- Check whether Charges Hook overrode
1364: -- the default Generate Charges processing.
1365: IF NOT (l_override_default_processing) THEN
1366: l_debug_info := 'Call Get_ChargesFromQP(...)';
1367: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1368: p_procedure_name => l_api_name,
1369: p_debug_info => l_debug_info);
1370:
1371: -- Get Charges from QP

Line 1387: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1383: END IF;
1384: END IF;
1385:
1386: l_debug_info := 'Check whether Charge Lines were populated into l_charge_ln_tbl';
1387: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1388: p_procedure_name => l_api_name,
1389: p_debug_info => l_debug_info);
1390:
1391: -- Check whether Freight Charges were generated

Line 1394: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1390:
1391: -- Check whether Freight Charges were generated
1392: IF l_charge_ln_tbl.COUNT < 1 THEN
1393: l_debug_info := 'No Charges have been generated.';
1394: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1395: p_procedure_name => l_api_name,
1396: p_debug_info => l_debug_info);
1397: FND_MESSAGE.SET_NAME ('INL', 'INL_CANNOT_QP_CALC_CH') ;
1398: FND_MSG_PUB.ADD;

Line 1404: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1400: -- Iterate through all generated Charges to insert
1401: -- into INL Charge Lines and INL Associations table
1402: FOR j IN l_charge_ln_tbl.FIRST..l_charge_ln_tbl.LAST LOOP
1403: l_debug_info := 'Call Insert_ChargeLines(...)';
1404: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1405: p_procedure_name => l_api_name,
1406: p_debug_info => l_debug_info);
1407:
1408: Insert_ChargeLines(p_ship_header_id => p_ship_header_id,

Line 1468: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:
1467: -- Standard End of Procedure/Function Logging
1468: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1469: p_procedure_name => l_api_name);
1470:
1471: EXCEPTION
1472: WHEN FND_API.G_EXC_ERROR THEN

Line 1474: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1470:
1471: EXCEPTION
1472: WHEN FND_API.G_EXC_ERROR THEN
1473: -- Standard Expected Error Logging
1474: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1475: p_procedure_name => l_api_name);
1476: ROLLBACK TO Generate_Charges_PVT;
1477: x_return_status := FND_API.G_RET_STS_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1483: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1482: -- Standard Unexpected Error Logging
1483: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1484: p_procedure_name => l_api_name);
1485: ROLLBACK TO Generate_Charges_PVT;
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1492: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1488: p_count => x_msg_count,
1489: p_data => x_msg_data);
1490: WHEN OTHERS THEN
1491: -- Standard Unexpected Error Logging
1492: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1493: p_procedure_name => l_api_name);
1494: ROLLBACK TO Generate_Charges_PVT;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)