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_SIMULATION_PVT dependencies on INL_LOGGING_PVT

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

89:
90: BEGIN
91:
92: -- Standard Beginning of Procedure/Function Logging
93: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
94: p_procedure_name => l_api_name) ;
95:
96: -- Standard Start of API savepoint
97: SAVEPOINT Duplicate_Tax_GRP;

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

111:
112: -- Initialize API return status to success
113: x_return_status := FND_API.G_RET_STS_SUCCESS;
114:
115: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
116: p_procedure_name => l_api_name,
117: p_var_name => 'p_current_ship_header_id',
118: p_var_value => p_current_ship_header_id);
119: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

115: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
116: p_procedure_name => l_api_name,
117: p_var_name => 'p_current_ship_header_id',
118: p_var_value => p_current_ship_header_id);
119: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
120: p_procedure_name => l_api_name,
121: p_var_name => 'p_new_ship_header_id',
122: p_var_value => p_new_ship_header_id);
123: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

119: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
120: p_procedure_name => l_api_name,
121: p_var_name => 'p_new_ship_header_id',
122: p_var_value => p_new_ship_header_id);
123: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
124: p_procedure_name => l_api_name,
125: p_var_name => 'p_to_parent_table_name',
126: p_var_value => p_to_parent_table_name);
127: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

123: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
124: p_procedure_name => l_api_name,
125: p_var_name => 'p_to_parent_table_name',
126: p_var_value => p_to_parent_table_name);
127: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
128: p_procedure_name => l_api_name,
129: p_var_name => 'p_current_to_parent_table_id',
130: p_var_value => p_current_to_parent_table_id);
131: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

127: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
128: p_procedure_name => l_api_name,
129: p_var_name => 'p_current_to_parent_table_id',
130: p_var_value => p_current_to_parent_table_id);
131: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
132: p_procedure_name => l_api_name,
133: p_var_name => 'p_new_to_parent_table_id',
134: p_var_value => p_new_to_parent_table_id);
135:

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

138: CLOSE TaxLines;
139:
140: FOR i IN 1..TaxLines_List.COUNT
141: LOOP
142: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
143: p_procedure_name => l_api_name,
144: p_var_name => 'tax_line_id',
145: p_var_value => TaxLines_List(i).tax_line_id);
146:

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

143: p_procedure_name => l_api_name,
144: p_var_name => 'tax_line_id',
145: p_var_value => TaxLines_List(i).tax_line_id);
146:
147: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
148: p_procedure_name => l_api_name,
149: p_debug_info => 'Get the next Tax Line Id');
150:
151: -- Get Charge Line nextval

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

152: SELECT inl_tax_lines_s.NEXTVAL
153: INTO l_tax_line_id
154: FROM dual;
155:
156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
157: p_procedure_name => l_api_name,
158: p_debug_info => 'Insert into INL_TAX_LINES');
159:
160: INSERT INTO inl_tax_lines (tax_line_id,

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

201: fnd_global.user_id,
202: SYSDATE,
203: fnd_global.login_id);
204:
205: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
206: p_procedure_name => l_api_name,
207: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
208:
209: INSERT INTO inl_associations (association_id,

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

243: p_count => x_msg_count,
244: p_data => x_msg_data) ;
245:
246: -- Standard End of Procedure/Function Logging
247: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
248: p_procedure_name => l_api_name);
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN

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

249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: -- Standard Expected Error Logging
253: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
254: p_procedure_name => l_api_name);
255: ROLLBACK TO Duplicate_Tax_GRP;
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: -- Standard Unexpected Error Logging
262: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
263: p_procedure_name => l_api_name);
264: -- ROLLBACK TO Import_FromPO_GRP;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

267: p_count => x_msg_count,
268: p_data => x_msg_data);
269: WHEN OTHERS THEN
270: -- Standard Unexpected Error Logging
271: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
272: p_procedure_name => l_api_name);
273: ROLLBACK TO Duplicate_Tax_GRP;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(

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

392:
393: BEGIN
394:
395: -- Standard Beginning of Procedure/Function Logging
396: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
397: p_procedure_name => l_api_name) ;
398:
399: -- Standard Start of API savepoint
400: SAVEPOINT Duplicate_Charge_GRP;

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

414:
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;
417:
418: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
419: p_procedure_name => l_api_name,
420: p_var_name => 'p_current_ship_header_id',
421: p_var_value => p_current_ship_header_id);
422: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

418: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
419: p_procedure_name => l_api_name,
420: p_var_name => 'p_current_ship_header_id',
421: p_var_value => p_current_ship_header_id);
422: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
423: p_procedure_name => l_api_name,
424: p_var_name => 'p_new_ship_header_id',
425: p_var_value => p_new_ship_header_id);
426: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

422: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
423: p_procedure_name => l_api_name,
424: p_var_name => 'p_new_ship_header_id',
425: p_var_value => p_new_ship_header_id);
426: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
427: p_procedure_name => l_api_name,
428: p_var_name => 'p_to_parent_table_name',
429: p_var_value => p_to_parent_table_name);
430: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

426: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
427: p_procedure_name => l_api_name,
428: p_var_name => 'p_to_parent_table_name',
429: p_var_value => p_to_parent_table_name);
430: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
431: p_procedure_name => l_api_name,
432: p_var_name => 'p_current_to_parent_table_id',
433: p_var_value => p_current_to_parent_table_id);
434: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

430: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
431: p_procedure_name => l_api_name,
432: p_var_name => 'p_current_to_parent_table_id',
433: p_var_value => p_current_to_parent_table_id);
434: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
435: p_procedure_name => l_api_name,
436: p_var_name => 'p_new_to_parent_table_id',
437: p_var_value => p_new_to_parent_table_id);
438:

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

441: CLOSE ChargeLines;
442:
443: FOR i IN 1..ChargeLines_List.COUNT
444: LOOP
445: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
446: p_procedure_name => l_api_name,
447: p_var_name => 'charge_line_id',
448: p_var_value => ChargeLines_List(i).charge_line_id);
449:

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

446: p_procedure_name => l_api_name,
447: p_var_name => 'charge_line_id',
448: p_var_value => ChargeLines_List(i).charge_line_id);
449:
450: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
451: p_procedure_name => l_api_name,
452: p_debug_info => 'Get the next Charge Line Id');
453:
454: -- Get Charge Line nextval

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

455: SELECT inl_charge_lines_s.NEXTVAL
456: INTO l_charge_line_id
457: FROM dual;
458:
459: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
460: p_procedure_name => l_api_name,
461: p_debug_info => 'Insert into INL_CHARGE_LINES');
462:
463: INSERT INTO inl_charge_lines (charge_line_id,

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

546: fnd_global.user_id,
547: SYSDATE,
548: fnd_global.login_id);
549:
550: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
551: p_procedure_name => l_api_name,
552: p_debug_info => 'Insert Charge association into INL_ASSOCIATIONS');
553:
554: INSERT INTO inl_associations (association_id,

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

588: p_count => x_msg_count,
589: p_data => x_msg_data) ;
590:
591: -- Standard End of Procedure/Function Logging
592: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
593: p_procedure_name => l_api_name);
594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN

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

594:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: -- Standard Expected Error Logging
598: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
599: p_procedure_name => l_api_name);
600: ROLLBACK TO Duplicate_Charge_GRP;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

603: p_count => x_msg_count,
604: p_data => x_msg_data);
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: -- Standard Unexpected Error Logging
607: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
608: p_procedure_name => l_api_name);
609: -- ROLLBACK TO Import_FromPO_GRP;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

612: p_count => x_msg_count,
613: p_data => x_msg_data);
614: WHEN OTHERS THEN
615: -- Standard Unexpected Error Logging
616: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
617: p_procedure_name => l_api_name);
618: ROLLBACK TO Duplicate_Charge_GRP;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(

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

757:
758: BEGIN
759:
760: -- Standard Beginning of Procedure/Function Logging
761: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
762: p_procedure_name => l_api_name) ;
763:
764: -- Standard Start of API savepoint
765: SAVEPOINT Duplicate_ShipLines_GRP;

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

779:
780: -- Initialize API return status to success
781: x_return_status := FND_API.G_RET_STS_SUCCESS;
782:
783: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
784: p_procedure_name => l_api_name,
785: p_var_name => 'p_current_ship_line_group_id',
786: p_var_value => p_current_ship_line_group_id);
787: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

783: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
784: p_procedure_name => l_api_name,
785: p_var_name => 'p_current_ship_line_group_id',
786: p_var_value => p_current_ship_line_group_id);
787: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
788: p_procedure_name => l_api_name,
789: p_var_name => 'p_new_ship_line_group_id',
790: p_var_value => p_new_ship_line_group_id);
791:

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

788: p_procedure_name => l_api_name,
789: p_var_name => 'p_new_ship_line_group_id',
790: p_var_value => p_new_ship_line_group_id);
791:
792: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
793: p_procedure_name => l_api_name,
794: p_debug_info => 'Get Shipment Header Id');
795: SELECT ship_header_id
796: INTO l_ship_header_id

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

802: CLOSE ShipLines;
803:
804: FOR i IN 1..ShipLines_List.COUNT
805: LOOP
806: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
807: p_procedure_name => l_api_name,
808: p_var_name => 'ship_line_id',
809: p_var_value => ShipLines_List(i).ship_line_id);
810:

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

807: p_procedure_name => l_api_name,
808: p_var_name => 'ship_line_id',
809: p_var_value => ShipLines_List(i).ship_line_id);
810:
811: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
812: p_procedure_name => l_api_name,
813: p_debug_info => 'Get the next Shipment Line Id');
814:
815: -- Get Shipment Lines's nextval

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

816: SELECT inl_ship_lines_all_s.NEXTVAL
817: INTO l_ship_line_id
818: FROM dual;
819:
820: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
821: p_procedure_name => l_api_name,
822: p_debug_info => 'Insert into INL_SHIP_LINES_ALL');
823:
824: INSERT INTO inl_ship_lines_all (ship_header_id,

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

975: ShipLines_List(i).attribute14,
976: ShipLines_List(i).attribute15,
977: ShipLines_List(i).nrq_zero_exception_flag);
978:
979: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
980: p_procedure_name => l_api_name,
981: p_debug_info => 'Check if exists Associations for the copyed Ship. Line');
982:
983: BEGIN

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

994: END;
995:
996: -- Generate associated Charges/Taxes for the new Shipment Line
997: FOR j IN 1..l_from_association_tbl.COUNT LOOP
998: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
999: p_procedure_name => l_api_name,
1000: p_var_name => 'from_parent_table_name',
1001: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1002: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

998: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
999: p_procedure_name => l_api_name,
1000: p_var_name => 'from_parent_table_name',
1001: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1002: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1003: p_procedure_name => l_api_name,
1004: p_var_name => 'from_parent_table_id',
1005: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1006:

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

1004: p_var_name => 'from_parent_table_id',
1005: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1006:
1007: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1008: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1009: p_procedure_name => l_api_name,
1010: p_debug_info => 'Call Duplicate_Charge');
1011:
1012: Duplicate_Charge (p_api_version => 1.0,

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

1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:
1032: ELSIF l_from_association_tbl(j).from_parent_table_name = 'INL_TAX_LINES' THEN
1033: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1034: p_procedure_name => l_api_name,
1035: p_debug_info => 'Call Duplicate_Tax');
1036:
1037: Duplicate_Tax (p_api_version => 1.0,

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

1066: p_count => x_msg_count,
1067: p_data => x_msg_data) ;
1068:
1069: -- Standard End of Procedure/Function Logging
1070: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1071: p_procedure_name => l_api_name);
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN

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

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: -- Standard Expected Error Logging
1076: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1077: p_procedure_name => l_api_name);
1078: ROLLBACK TO Duplicate_ShipLines_GRP;
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1081: p_count => x_msg_count,
1082: p_data => x_msg_data);
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: -- Standard Unexpected Error Logging
1085: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1086: p_procedure_name => l_api_name);
1087: -- ROLLBACK TO Import_FromPO_GRP;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1089: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1090: p_count => x_msg_count,
1091: p_data => x_msg_data);
1092: WHEN OTHERS THEN
1093: -- Standard Unexpected Error Logging
1094: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1095: p_procedure_name => l_api_name);
1096: ROLLBACK TO Duplicate_ShipLines_GRP;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.Check_Msg_Level(

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

1193:
1194: BEGIN
1195:
1196: -- Standard Beginning of Procedure/Function Logging
1197: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1198: p_procedure_name => l_api_name) ;
1199:
1200: -- Standard Start of API savepoint
1201: SAVEPOINT Duplicate_LineGroups_GRP;

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

1215:
1216: -- Initialize API return status to success
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;
1218:
1219: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1220: p_procedure_name => l_api_name,
1221: p_var_name => 'p_current_ship_header_id',
1222: p_var_value => p_current_ship_header_id);
1223: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1219: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1220: p_procedure_name => l_api_name,
1221: p_var_name => 'p_current_ship_header_id',
1222: p_var_value => p_current_ship_header_id);
1223: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1224: p_procedure_name => l_api_name,
1225: p_var_name => 'p_new_ship_header_id',
1226: p_var_value => p_new_ship_header_id);
1227:

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

1230: CLOSE LineGroups;
1231:
1232: FOR i IN 1..LineGroups_List.COUNT
1233: LOOP
1234: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1235: p_procedure_name => l_api_name,
1236: p_var_name => 'ship_line_group_id',
1237: p_var_value => LineGroups_List(i).ship_line_group_id);
1238:

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

1235: p_procedure_name => l_api_name,
1236: p_var_name => 'ship_line_group_id',
1237: p_var_value => LineGroups_List(i).ship_line_group_id);
1238:
1239: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1240: p_procedure_name => l_api_name,
1241: p_debug_info => 'Get the next Line Group Id');
1242:
1243: -- Get Shipment Header's nextval

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

1244: SELECT inl_ship_line_groups_s.NEXTVAL
1245: INTO l_ship_line_group_id
1246: FROM dual;
1247:
1248: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1249: p_procedure_name => l_api_name,
1250: p_debug_info => 'Insert into INL_SHIP_LINE_GROUPS');
1251:
1252: INSERT INTO inl_ship_line_groups (ship_line_group_id,

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

1321: LineGroups_List(i).attribute13,
1322: LineGroups_List(i).attribute14,
1323: LineGroups_List(i).attribute15);
1324:
1325: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1326: p_procedure_name => l_api_name,
1327: p_debug_info => 'Check if exists Associations for the copyed Ship. Line Group');
1328:
1329: BEGIN

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

1340: END;
1341:
1342: -- Generate associated Charges for the new Line Group
1343: FOR j IN 1..l_from_association_tbl.COUNT LOOP
1344: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1345: p_procedure_name => l_api_name,
1346: p_var_name => 'from_parent_table_name',
1347: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1348: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1344: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1345: p_procedure_name => l_api_name,
1346: p_var_name => 'from_parent_table_name',
1347: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1348: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1349: p_procedure_name => l_api_name,
1350: p_var_name => 'from_parent_table_id',
1351: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1352:

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

1350: p_var_name => 'from_parent_table_id',
1351: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1352:
1353: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1354: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1355: p_procedure_name => l_api_name,
1356: p_debug_info => 'Call Duplicate_Charge');
1357:
1358: Duplicate_Charge (p_api_version => 1.0,

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

1376: END IF;
1377: END IF;
1378: END LOOP;
1379:
1380: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1381: p_procedure_name => l_api_name,
1382: p_debug_info => 'Call Duplicate_ShipLines');
1383:
1384: Duplicate_ShipLines (p_api_version => 1.0,

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

1407: p_count => x_msg_count,
1408: p_data => x_msg_data) ;
1409:
1410: -- Standard End of Procedure/Function Logging
1411: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1412: p_procedure_name => l_api_name);
1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN

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

1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: -- Standard Expected Error Logging
1417: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1418: p_procedure_name => l_api_name);
1419: ROLLBACK TO Duplicate_LineGroups_GRP;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1422: p_count => x_msg_count,
1423: p_data => x_msg_data);
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: -- Standard Unexpected Error Logging
1426: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1427: p_procedure_name => l_api_name);
1428: -- ROLLBACK TO Import_FromPO_GRP;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433: WHEN OTHERS THEN
1434: -- Standard Unexpected Error Logging
1435: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1436: p_procedure_name => l_api_name);
1437: ROLLBACK TO Duplicate_LineGroups_GRP;
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1439: IF FND_MSG_PUB.Check_Msg_Level(

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

1549:
1550: BEGIN
1551:
1552: -- Standard Beginning of Procedure/Function Logging
1553: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1554: p_procedure_name => l_api_name) ;
1555:
1556: -- Standard Start of API savepoint
1557: SAVEPOINT Duplicate_ShipHeaders_GRP;

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

1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;
1574:
1575: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1576: p_procedure_name => l_api_name,
1577: p_var_name => 'p_current_simulation_id',
1578: p_var_value => p_current_simulation_id);
1579: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1575: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1576: p_procedure_name => l_api_name,
1577: p_var_name => 'p_current_simulation_id',
1578: p_var_value => p_current_simulation_id);
1579: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1580: p_procedure_name => l_api_name,
1581: p_var_name => 'p_new_simulation_id',
1582: p_var_value => p_new_simulation_id);
1583:

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

1586: CLOSE ShipHeaders;
1587:
1588: FOR i IN 1..ShipHeaders_List.COUNT
1589: LOOP
1590: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1591: p_procedure_name => l_api_name,
1592: p_var_name => 'ship_header_id',
1593: p_var_value => ShipHeaders_List(i).ship_header_id);
1594:

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

1591: p_procedure_name => l_api_name,
1592: p_var_name => 'ship_header_id',
1593: p_var_value => ShipHeaders_List(i).ship_header_id);
1594:
1595: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1596: p_procedure_name => l_api_name,
1597: p_debug_info => 'Select data from_association_rec INL_SIMULATIONS');
1598:
1599: SELECT s.simulation_id,

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

1616: l_simulation_rec.freight_code
1617: FROM inl_simulations s
1618: WHERE s.simulation_id = p_new_simulation_id;
1619:
1620: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1621: p_procedure_name => l_api_name,
1622: p_var_name => 'l_simulation_rec.parent_table_name',
1623: p_var_value => l_simulation_rec.parent_table_name);
1624: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1620: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1621: p_procedure_name => l_api_name,
1622: p_var_name => 'l_simulation_rec.parent_table_name',
1623: p_var_value => l_simulation_rec.parent_table_name);
1624: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1625: p_procedure_name => l_api_name,
1626: p_var_name => 'l_simulation_rec.parent_table_revision_num',
1627: p_var_value => l_simulation_rec.parent_table_revision_num);
1628: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1624: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1625: p_procedure_name => l_api_name,
1626: p_var_name => 'l_simulation_rec.parent_table_revision_num',
1627: p_var_value => l_simulation_rec.parent_table_revision_num);
1628: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1629: p_procedure_name => l_api_name,
1630: p_var_name => 'l_simulation_rec.version_num',
1631: p_var_value => l_simulation_rec.version_num);
1632: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1628: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1629: p_procedure_name => l_api_name,
1630: p_var_name => 'l_simulation_rec.version_num',
1631: p_var_value => l_simulation_rec.version_num);
1632: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1633: p_procedure_name => l_api_name,
1634: p_var_name => 'l_simulation_rec.version_num',
1635: p_var_value => l_simulation_rec.version_num);
1636: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1632: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1633: p_procedure_name => l_api_name,
1634: p_var_name => 'l_simulation_rec.version_num',
1635: p_var_value => l_simulation_rec.version_num);
1636: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1637: p_procedure_name => l_api_name,
1638: p_var_name => 'l_sequence',
1639: p_var_value => l_sequence);
1640:

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

1651: WHERE ph.po_header_id = pr.po_header_id
1652: AND pr.po_release_id = l_simulation_rec.parent_table_id;
1653: END IF;
1654:
1655: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1656: p_procedure_name => l_api_name,
1657: p_var_name => 'l_src_number',
1658: p_var_value => l_src_number);
1659:

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

1656: p_procedure_name => l_api_name,
1657: p_var_name => 'l_src_number',
1658: p_var_value => l_src_number);
1659:
1660: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1661: p_procedure_name => l_api_name,
1662: p_debug_info => 'Call INL_CUSTOM_PUB.Get_SimulShipNum');
1663:
1664: INL_CUSTOM_PUB.Get_SimulShipNum(p_simulation_rec => l_simulation_rec,

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

1669: x_return_status => l_return_status);
1670:
1671: l_sequence := l_sequence + 1;
1672:
1673: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1674: p_procedure_name => l_api_name,
1675: p_var_name => 'l_next_ship_num',
1676: p_var_value => l_next_ship_num);
1677:

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

1674: p_procedure_name => l_api_name,
1675: p_var_name => 'l_next_ship_num',
1676: p_var_value => l_next_ship_num);
1677:
1678: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1679: p_procedure_name => l_api_name,
1680: p_debug_info => 'Get the next Shipment Header Id');
1681:
1682: -- Get Shipment Header's nextval

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

1683: SELECT inl_ship_headers_all_s.NEXTVAL
1684: INTO l_ship_header_id
1685: FROM dual;
1686:
1687: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1688: p_procedure_name => l_api_name,
1689: p_debug_info => 'Insert into INL_SHIP_HEADERS_ALL');
1690:
1691: INSERT INTO inl_ship_headers_all (ship_header_id,

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

1776: ShipHeaders_List(i).attribute13,
1777: ShipHeaders_List(i).attribute14,
1778: ShipHeaders_List(i).attribute15);
1779:
1780: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1781: p_procedure_name => l_api_name,
1782: p_debug_info => 'Check if exists Associations for the copyed Ship. Header');
1783:
1784: BEGIN

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

1796: END;
1797:
1798: -- Generate associated Charges for the new Shipment Header
1799: FOR j IN 1..l_from_association_tbl.COUNT LOOP
1800: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1801: p_procedure_name => l_api_name,
1802: p_var_name => 'from_parent_table_name',
1803: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1804: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,

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

1800: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1801: p_procedure_name => l_api_name,
1802: p_var_name => 'from_parent_table_name',
1803: p_var_value => l_from_association_tbl(j).from_parent_table_name);
1804: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
1805: p_procedure_name => l_api_name,
1806: p_var_name => 'from_parent_table_id',
1807: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1808:

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

1806: p_var_name => 'from_parent_table_id',
1807: p_var_value => l_from_association_tbl(j).from_parent_table_id);
1808:
1809: IF l_from_association_tbl(j).from_parent_table_name = 'INL_CHARGE_LINES' THEN
1810: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1811: p_procedure_name => l_api_name,
1812: p_debug_info => 'Call Duplicate_Charge');
1813:
1814: Duplicate_Charge (p_api_version => 1.0,

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

1832: END IF;
1833: END IF;
1834: END LOOP;
1835:
1836: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1837: p_procedure_name => l_api_name,
1838: p_debug_info => 'Call Duplicate_LineGroups');
1839:
1840: Duplicate_LineGroups (p_api_version => 1.0,

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

1863: p_count => x_msg_count,
1864: p_data => x_msg_data) ;
1865:
1866: -- Standard End of Procedure/Function Logging
1867: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1868: p_procedure_name => l_api_name);
1869:
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_ERROR THEN

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

1869:
1870: EXCEPTION
1871: WHEN FND_API.G_EXC_ERROR THEN
1872: -- Standard Expected Error Logging
1873: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1874: p_procedure_name => l_api_name);
1875: ROLLBACK TO Duplicate_ShipHeaders_GRP;
1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1878: p_count => x_msg_count,
1879: p_data => x_msg_data);
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1881: -- Standard Unexpected Error Logging
1882: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1883: p_procedure_name => l_api_name);
1884: -- ROLLBACK TO Import_FromPO_GRP;
1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: -- Standard Unexpected Error Logging
1891: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_api_name);
1893: ROLLBACK TO Duplicate_ShipHeaders_GRP;
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1895: IF FND_MSG_PUB.Check_Msg_Level(

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

1949:
1950: BEGIN
1951:
1952: -- Standard Beginning of Procedure/Function Logging
1953: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
1954: p_procedure_name => l_api_name) ;
1955:
1956: -- Standard Start of API savepoint
1957: SAVEPOINT Copy_Simulation_GRP;

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

1971:
1972: -- Initialize API return status to success
1973: x_return_status := FND_API.G_RET_STS_SUCCESS;
1974:
1975: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1976: p_procedure_name => l_api_name,
1977: p_var_name => 'p_simulation_id',
1978: p_var_value => p_simulation_id);
1979:

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

1977: p_var_name => 'p_simulation_id',
1978: p_var_value => p_simulation_id);
1979:
1980:
1981: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1982: p_procedure_name => l_api_name,
1983: p_debug_info => 'Acquiring lock on: ' || l_lock_name);
1984:
1985: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,

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

1988: l_lock_status := DBMS_LOCK.Request(lockhandle => l_lock_handle,
1989: lockmode => dbms_lock.x_mode);
1990:
1991: IF l_lock_status = 0 THEN -- Successfully locked
1992: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1993: p_procedure_name => l_api_name,
1994: p_debug_info => 'Get the next simulation version');
1995:
1996: SELECT MAX(a.version_num) + 1

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

2001: AND a.parent_table_id = b.parent_table_id
2002: AND a.parent_table_revision_num = b.parent_table_revision_num
2003: AND b.simulation_id = p_simulation_id;
2004:
2005: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2006: p_procedure_name => l_api_name,
2007: p_debug_info => 'Get the next Simulation Id');
2008:
2009: -- Get Simulation Id nextval

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

2010: SELECT inl_simulations_s.NEXTVAL
2011: INTO l_simulation_id
2012: FROM dual;
2013:
2014: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2015: p_procedure_name => l_api_name,
2016: p_debug_info => 'Populate Simulation record to be used on INSERT');
2017:
2018: SELECT 'N',

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

2065: l_simulation_rec.attribute15
2066: FROM inl_simulations
2067: WHERE simulation_id = p_simulation_id;
2068:
2069: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2070: p_procedure_name => l_api_name,
2071: p_debug_info => 'Insert into Simulation table a copy of the existing record');
2072:
2073: INSERT INTO inl_simulations (simulation_id,

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

2132: l_simulation_rec.attribute13,
2133: l_simulation_rec.attribute14,
2134: l_simulation_rec.attribute15);
2135:
2136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2137: p_procedure_name => l_api_name,
2138: p_debug_info => 'Call Duplicate_ShipHeaders');
2139:
2140: Duplicate_ShipHeaders (p_api_version => 1.0,

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

2173: p_count => x_msg_count,
2174: p_data => x_msg_data) ;
2175:
2176: -- Standard End of Procedure/Function Logging
2177: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2178: p_procedure_name => l_api_name);
2179:
2180: EXCEPTION
2181: WHEN FND_API.G_EXC_ERROR THEN

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

2179:
2180: EXCEPTION
2181: WHEN FND_API.G_EXC_ERROR THEN
2182: -- Standard Expected Error Logging
2183: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2184: p_procedure_name => l_api_name);
2185: ROLLBACK TO Copy_Simulation_GRP;
2186: x_return_status := FND_API.G_RET_STS_ERROR;
2187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2192: END IF;
2193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2194: -- Standard Unexpected Error Logging
2195: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2196: p_procedure_name => l_api_name);
2197: -- ROLLBACK TO Import_FromPO_GRP;
2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2204: END IF;
2205: WHEN OTHERS THEN
2206: -- Standard Unexpected Error Logging
2207: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2208: p_procedure_name => l_api_name);
2209: ROLLBACK TO Copy_Simulation_GRP;
2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2211: IF FND_MSG_PUB.Check_Msg_Level(

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

2282:
2283: BEGIN
2284:
2285: -- Standard Beginning of Procedure/Function Logging
2286: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2287: p_procedure_name => l_api_name) ;
2288:
2289: -- Standard Start of API savepoint
2290: SAVEPOINT Create_Simulation_GRP;

Line 2308: INL_LOGGING_PVT.Log_Variable (

2304:
2305: -- Initialize API return status to success
2306: x_return_status := FND_API.G_RET_STS_SUCCESS;
2307:
2308: INL_LOGGING_PVT.Log_Variable (
2309: p_module_name => g_module_name,
2310: p_procedure_name => l_api_name,
2311: p_var_name => 'p_simulation_rec.parent_table_name',
2312: p_var_value => p_simulation_rec.parent_table_name);

Line 2314: INL_LOGGING_PVT.Log_Variable (

2310: p_procedure_name => l_api_name,
2311: p_var_name => 'p_simulation_rec.parent_table_name',
2312: p_var_value => p_simulation_rec.parent_table_name);
2313:
2314: INL_LOGGING_PVT.Log_Variable (
2315: p_module_name => g_module_name,
2316: p_procedure_name => l_api_name,
2317: p_var_name => 'p_simulation_rec.parent_table_id',
2318: p_var_value => p_simulation_rec.parent_table_id);

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

2317: p_var_name => 'p_simulation_rec.parent_table_id',
2318: p_var_value => p_simulation_rec.parent_table_id);
2319:
2320:
2321: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2322: p_procedure_name => l_api_name,
2323: p_debug_info => 'Acquiring lock on: ' || l_lock_name);
2324:
2325: DBMS_LOCK.Allocate_Unique(lockname => l_lock_name,

Line 2340: INL_LOGGING_PVT.Log_Variable (

2336: WHERE sml.parent_table_name = p_simulation_rec.parent_table_name
2337: AND sml.parent_table_id = p_simulation_rec.parent_table_id
2338: AND parent_table_revision_num = p_simulation_rec.parent_table_revision_num;
2339:
2340: INL_LOGGING_PVT.Log_Variable (
2341: p_module_name => g_module_name,
2342: p_procedure_name => l_api_name,
2343: p_var_name => 'p_simulation_rec.version_num',
2344: p_var_value => p_simulation_rec.version_num );

Line 2350: INL_LOGGING_PVT.Log_Variable (

2346: SELECT inl_simulations_s.NEXTVAL
2347: INTO p_simulation_rec.simulation_id
2348: FROM dual;
2349:
2350: INL_LOGGING_PVT.Log_Variable (
2351: p_module_name => g_module_name,
2352: p_procedure_name => l_api_name,
2353: p_var_name => 'p_simulation_rec.simulation_id',
2354: p_var_value => p_simulation_rec.simulation_id );

Line 2358: INL_LOGGING_PVT.Log_Statement (

2354: p_var_value => p_simulation_rec.simulation_id );
2355:
2356: l_debug_msg := 'Call INL_CUSTOM_PUB.Get_SimulFlexFields to get flexfield valeus from Hook';
2357:
2358: INL_LOGGING_PVT.Log_Statement (
2359: p_module_name => g_module_name,
2360: p_procedure_name => l_api_name,
2361: p_debug_info => l_debug_msg);
2362:

Line 2396: INL_LOGGING_PVT.Log_Statement (

2392: l_attribute14 := l_flexfield_ln_rec.attribute14;
2393: l_attribute15 := l_flexfield_ln_rec.attribute15;
2394:
2395: l_debug_msg := 'Inserting data into inl_simulations table';
2396: INL_LOGGING_PVT.Log_Statement (
2397: p_module_name => g_module_name,
2398: p_procedure_name => l_api_name,
2399: p_debug_info => l_debug_msg);
2400:

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

2481: p_count => x_msg_count,
2482: p_data => x_msg_data) ;
2483:
2484: -- Standard End of Procedure/Function Logging
2485: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2486: p_procedure_name => l_api_name);
2487:
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN

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

2487:
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: -- Standard Expected Error Logging
2491: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2492: p_procedure_name => l_api_name);
2493: ROLLBACK TO Create_Simulation_GRP;
2494: x_return_status := FND_API.G_RET_STS_ERROR;
2495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2500: END IF;
2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2502: -- Standard Unexpected Error Logging
2503: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2504: p_procedure_name => l_api_name);
2505: ROLLBACK TO Create_Simulation_GRP;
2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2512: END IF;
2513: WHEN OTHERS THEN
2514: -- Standard Unexpected Error Logging
2515: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2516: p_procedure_name => l_api_name);
2517: ROLLBACK TO Create_Simulation_GRP;
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: IF FND_MSG_PUB.Check_Msg_Level(

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

2586: l_remove_simulated BOOLEAN := FALSE;
2587: BEGIN
2588:
2589: -- Standard Beginning of Procedure/Function Logging
2590: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
2591: p_procedure_name => l_api_name) ;
2592:
2593: -- Standard Start of API savepoint
2594: SAVEPOINT Purge_SimulShipments_GRP;

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

2615:
2616: IF p_simulation_table.COUNT <> 0 THEN
2617: l_check_simul_tbl := TRUE;
2618:
2619: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
2620: p_procedure_name => l_api_name,
2621: p_debug_info => 'Remove Simulations stored in p_simulation_table');
2622: END IF;
2623:

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

2622: END IF;
2623:
2624: FOR i IN 1..c_simul_tbl.COUNT
2625: LOOP
2626: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2627: p_procedure_name => l_api_name,
2628: p_var_name => 'c_simul_tbl(i).simulation_id',
2629: p_var_value => c_simul_tbl(i).simulation_id);
2630:

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

2639: END LOOP;
2640: END IF;
2641:
2642: IF NOT l_check_simul_tbl OR (l_check_simul_tbl AND l_remove_simulated) THEN
2643: INL_LOGGING_PVT.Log_Statement(p_module_name => g_module_name,
2644: p_procedure_name => l_api_name,
2645: p_debug_info => 'Removing simulation: ' || c_simul_tbl(i).simulation_id);
2646:
2647: OPEN c_ship_hdr(c_simul_tbl(i).simulation_id);

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

2649: CLOSE c_ship_hdr;
2650:
2651: FOR j IN 1..c_ship_hdr_tbl.COUNT
2652: LOOP
2653: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2654: p_procedure_name => l_api_name,
2655: p_var_name => 'c_ship_hdr_tbl(j).ship_header_id',
2656: p_var_value => c_ship_hdr_tbl(j).ship_header_id);
2657:

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

2680: p_count => x_msg_count,
2681: p_data => x_msg_data) ;
2682:
2683: -- Standard End of Procedure/Function Logging
2684: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
2685: p_procedure_name => l_api_name);
2686:
2687: EXCEPTION
2688: WHEN FND_API.G_EXC_ERROR THEN

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

2686:
2687: EXCEPTION
2688: WHEN FND_API.G_EXC_ERROR THEN
2689: -- Standard Expected Error Logging
2690: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2691: p_procedure_name => l_api_name);
2692: ROLLBACK TO Purge_SimulShipments_GRP;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2698: -- Standard Unexpected Error Logging
2699: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2700: p_procedure_name => l_api_name);
2701: ROLLBACK TO Purge_SimulShipments_GRP;
2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2703: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2704: p_count => x_msg_count,
2705: p_data => x_msg_data);
2706: WHEN OTHERS THEN
2707: -- Standard Unexpected Error Logging
2708: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2709: p_procedure_name => l_api_name);
2710: ROLLBACK TO Purge_SimulShipments_GRP;
2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2712: IF FND_MSG_PUB.Check_Msg_Level(