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_SHIPMENT_PVT dependencies on STANDARD

Line 135: -- Standard Beginning of Procedure/Function Logging

131: l_msg_count NUMBER;
132: l_msg_data VARCHAR2 (2000) ;
133: l_debug_info VARCHAR2 (200) ;
134: BEGIN
135: -- Standard Beginning of Procedure/Function Logging
136: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
137: p_procedure_name => l_proc_name) ;
138: -- Initialize return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 214: -- Standard End of Procedure/Function Logging

210: fnd_global.prog_appl_id ,
211: SYSDATE ,
212: fnd_global.conc_request_id
213: ) ;
214: -- Standard End of Procedure/Function Logging
215: INL_LOGGING_PVT.Log_EndProc
216: (
217: p_module_name => g_module_name, p_procedure_name => l_proc_name
218: )

Line 222: -- Standard Expected Error Logging

218: )
219: ;
220: EXCEPTION
221: WHEN FND_API.G_EXC_ERROR THEN
222: -- Standard Expected Error Logging
223: INL_LOGGING_PVT.Log_ExpecError
224: (
225: p_module_name => g_module_name, p_procedure_name => l_proc_name
226: )

Line 230: -- Standard Unexpected Error Logging

226: )
227: ;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
230: -- Standard Unexpected Error Logging
231: INL_LOGGING_PVT.Log_UnexpecError
232: (
233: p_module_name => g_module_name, p_procedure_name => l_proc_name
234: )

Line 238: -- Standard Unexpected Error Logging

234: )
235: ;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: WHEN OTHERS THEN
238: -- Standard Unexpected Error Logging
239: INL_LOGGING_PVT.Log_UnexpecError
240: (
241: p_module_name => g_module_name, p_procedure_name => l_proc_name
242: )

Line 302: -- Standard Beginning of Procedure/Function Logging

298: 200
299: )
300: ;
301: BEGIN
302: -- Standard Beginning of Procedure/Function Logging
303: INL_LOGGING_PVT.Log_BeginProc
304: (
305: p_module_name => g_module_name, p_procedure_name => l_proc_name
306: )

Line 333: -- Standard End of Procedure/Function Logging

329: WHERE ship_header_id = p_ship_header_id
330: AND ship_line_id = p_charge_line_id;
331: END IF;
332: END IF;
333: -- Standard End of Procedure/Function Logging
334: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
335: p_procedure_name => l_proc_name) ;
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN

Line 338: -- Standard Expected Error Logging

334: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
335: p_procedure_name => l_proc_name) ;
336: EXCEPTION
337: WHEN FND_API.G_EXC_ERROR THEN
338: -- Standard Expected Error Logging
339: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
340: p_procedure_name => l_proc_name) ;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 343: -- Standard Unexpected Error Logging

339: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
340: p_procedure_name => l_proc_name) ;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
343: -- Standard Unexpected Error Logging
344: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
345: p_procedure_name => l_proc_name) ;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: WHEN OTHERS THEN

Line 348: -- Standard Unexpected Error Logging

344: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
345: p_procedure_name => l_proc_name) ;
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: WHEN OTHERS THEN
348: -- Standard Unexpected Error Logging
349: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
350: p_procedure_name => l_proc_name) ;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 405: -- Standard Start of API savepoint

401:
402: BEGIN
403: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
404: p_procedure_name => l_api_name) ;
405: -- Standard Start of API savepoint
406: SAVEPOINT Complete_Shipment_PVT;
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean (p_init_msg_list) THEN
409: FND_MSG_PUB.initialize;

Line 525: -- Standard check of p_commit.

521: last_updated_by = fnd_global.user_id,
522: last_update_date = SYSDATE
523: WHERE ship_header_id = p_ship_header_id;
524:
525: -- Standard check of p_commit.
526: IF FND_API.To_Boolean (p_commit) THEN
527: COMMIT WORK;
528: END IF;
529: -- Standard call to get message count and if count is 1, get message info.

Line 529: -- Standard call to get message count and if count is 1, get message info.

525: -- Standard check of p_commit.
526: IF FND_API.To_Boolean (p_commit) THEN
527: COMMIT WORK;
528: END IF;
529: -- Standard call to get message count and if count is 1, get message info.
530: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
531: p_count => x_msg_count,
532: p_data => x_msg_data) ;
533: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

Line 656: -- Standard Start of API savepoint

652: l_debug_info VARCHAR2 (200) ;
653: BEGIN
654: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
655: p_procedure_name => l_api_name) ;
656: -- Standard Start of API savepoint
657: SAVEPOINT Set_ToRevalidate_PVT;
658: -- Initialize message list if p_init_msg_list is set to TRUE.
659: IF FND_API.to_Boolean (p_init_msg_list) THEN
660: FND_MSG_PUB.initialize;

Line 694: -- Standard check of p_commit.

690: UPDATE inl_ship_headers
691: SET ship_status_code = 'VALIDATION REQ'
692: WHERE ship_header_id = p_ship_header_id;
693: END IF;
694: -- Standard check of p_commit.
695: IF FND_API.To_Boolean (p_commit) THEN
696: COMMIT WORK;
697: END IF;
698: -- Standard call to get message count and if count is 1, get message info.

Line 698: -- Standard call to get message count and if count is 1, get message info.

694: -- Standard check of p_commit.
695: IF FND_API.To_Boolean (p_commit) THEN
696: COMMIT WORK;
697: END IF;
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
700: p_count => x_msg_count,
701: p_data => x_msg_data) ;
702: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,

Line 925: -- Standard Beginning of Procedure/Function Logging

921: l_converted_qty_rsl NUMBER;
922: l_total_quantity_rsl NUMBER := 0;
923:
924: BEGIN
925: -- Standard Beginning of Procedure/Function Logging
926: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
927: p_procedure_name => l_api_name) ;
928: -- Initialize message list if p_init_msg_list is set to TRUE.
929: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1050: -- Standard check of p_commit.

1046: p_procedure_name => l_api_name,
1047: p_var_name => 'p_unit_of_measure',
1048: p_var_value => p_unit_of_measure) ;
1049:
1050: -- Standard check of p_commit.
1051: IF FND_API.To_Boolean (p_commit) THEN
1052: COMMIT WORK;
1053: END IF;
1054:

Line 1055: -- Standard call to get message count and if count is 1, get message info.

1051: IF FND_API.To_Boolean (p_commit) THEN
1052: COMMIT WORK;
1053: END IF;
1054:
1055: -- Standard call to get message count and if count is 1, get message info.
1056: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data) ;
1059:

Line 1060: -- Standard End of Procedure/Function Logging

1056: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1057: p_count => x_msg_count,
1058: p_data => x_msg_data) ;
1059:
1060: -- Standard End of Procedure/Function Logging
1061: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1062: p_procedure_name => l_api_name) ;
1063: EXCEPTION
1064: WHEN FND_API.G_EXC_ERROR THEN

Line 1065: -- Standard Expected Error Logging

1061: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1062: p_procedure_name => l_api_name) ;
1063: EXCEPTION
1064: WHEN FND_API.G_EXC_ERROR THEN
1065: -- Standard Expected Error Logging
1066: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1067: p_procedure_name => l_api_name) ;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

Line 1073: -- Standard Unexpected Error Logging

1069: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1070: p_count => x_msg_count,
1071: p_data => x_msg_data) ;
1072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1073: -- Standard Unexpected Error Logging
1074: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1075: p_procedure_name => l_api_name) ;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

Line 1081: -- Standard Unexpected Error Logging

1077: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1078: p_count => x_msg_count,
1079: p_data => x_msg_data) ;
1080: WHEN OTHERS THEN
1081: -- Standard Unexpected Error Logging
1082: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1083: p_procedure_name => l_api_name) ;
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1145: -- Standard Beginning of Procedure/Function Logging

1141: x_qty_in_others_ops NUMBER;
1142: l_primary_uom_tl VARCHAR2(30);
1143:
1144: BEGIN
1145: -- Standard Beginning of Procedure/Function Logging
1146: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1147: p_procedure_name => l_proc_name) ;
1148: -- Initialize API return status to success
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1462: -- Standard Beginning of Procedure/Function Logging

1458: l_po_converted_price NUMBER;
1459: l_p_converted_PUP NUMBER;
1460: l_po_UOM_code VARCHAR2(30);
1461: BEGIN
1462: -- Standard Beginning of Procedure/Function Logging
1463: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
1464: p_procedure_name => l_proc_name) ;
1465: -- Initialize API return status to success
1466: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1618: -- Standard End of Procedure/Function Logging

1614: x_return_status => l_return_status) ;
1615: END IF;
1616: END IF;
1617: END IF;
1618: -- Standard End of Procedure/Function Logging
1619: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
1620: EXCEPTION
1621: WHEN FND_API.G_EXC_ERROR THEN
1622: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1691: -- Standard Beginning of Procedure/Function Logging

1687: l_msg_data VARCHAR2 (2000);
1688: l_debug_info VARCHAR2 (200);
1689:
1690: BEGIN
1691: -- Standard Beginning of Procedure/Function Logging
1692: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
1693: p_procedure_name => l_api_name) ;
1694: -- Standard Start of API savepoint
1695: SAVEPOINT Check_PoTolerances_PVT;

Line 1694: -- Standard Start of API savepoint

1690: BEGIN
1691: -- Standard Beginning of Procedure/Function Logging
1692: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
1693: p_procedure_name => l_api_name) ;
1694: -- Standard Start of API savepoint
1695: SAVEPOINT Check_PoTolerances_PVT;
1696:
1697: -- Initialize message list if p_init_msg_list is set to TRUE.
1698: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1739: -- Standard call to get message count and if count is 1, get message info.

1735: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1737: END IF;
1738:
1739: -- Standard call to get message count and if count is 1, get message info.
1740: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1741: p_count => x_msg_count,
1742: p_data => x_msg_data) ;
1743:

Line 1774: -- Standard check of p_commit.

1770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1771: END IF;
1772: END IF;
1773:
1774: -- Standard check of p_commit.
1775: IF FND_API.To_Boolean (p_commit) THEN
1776: COMMIT WORK;
1777: END IF;
1778:

Line 1779: -- Standard call to get message count and if count is 1, get message info.

1775: IF FND_API.To_Boolean (p_commit) THEN
1776: COMMIT WORK;
1777: END IF;
1778:
1779: -- Standard call to get message count and if count is 1, get message info.
1780: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1781: p_count => x_msg_count,
1782: p_data => x_msg_data) ;
1783:

Line 1784: -- Standard End of Procedure/Function Logging

1780: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1781: p_count => x_msg_count,
1782: p_data => x_msg_data) ;
1783:
1784: -- Standard End of Procedure/Function Logging
1785: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1786: p_procedure_name => l_api_name) ;
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN

Line 1789: -- Standard Expected Error Logging

1785: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1786: p_procedure_name => l_api_name) ;
1787: EXCEPTION
1788: WHEN FND_API.G_EXC_ERROR THEN
1789: -- Standard Expected Error Logging
1790: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1791: p_procedure_name => l_api_name) ;
1792: ROLLBACK TO Check_PoTolerances_PVT;
1793: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1798: -- Standard Unexpected Error Logging

1794: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data) ;
1797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1798: -- Standard Unexpected Error Logging
1799: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1800: p_procedure_name => l_api_name) ;
1801: ROLLBACK TO Check_PoTolerances_PVT;
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1807: -- Standard Unexpected Error Logging

1803: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data) ;
1806: WHEN OTHERS THEN
1807: -- Standard Unexpected Error Logging
1808: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1809: p_procedure_name => l_api_name) ;
1810: ROLLBACK TO Check_PoTolerances_PVT;
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1928: -- Standard Expected Error Logging

1924: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1925: p_procedure_name => l_proc_name) ;
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: -- Standard Expected Error Logging
1929: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1930: p_procedure_name => l_proc_name) ;
1931: x_return_status := FND_API.G_RET_STS_ERROR;
1932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1933: -- Standard Unexpected Error Logging

1929: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1930: p_procedure_name => l_proc_name) ;
1931: x_return_status := FND_API.G_RET_STS_ERROR;
1932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1933: -- Standard Unexpected Error Logging
1934: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1935: p_procedure_name => l_proc_name) ;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: WHEN OTHERS THEN

Line 1938: -- Standard Unexpected Error Logging

1934: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1935: p_procedure_name => l_proc_name) ;
1936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1937: WHEN OTHERS THEN
1938: -- Standard Unexpected Error Logging
1939: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1940: p_procedure_name => l_proc_name) ;
1941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1942: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2115: -- Standard Expected Error Logging

2111: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
2112: p_procedure_name => l_proc_name) ;
2113: EXCEPTION
2114: WHEN FND_API.G_EXC_ERROR THEN
2115: -- Standard Expected Error Logging
2116: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2117: p_procedure_name => l_proc_name) ;
2118: x_return_status := FND_API.G_RET_STS_ERROR;
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2120: -- Standard Unexpected Error Logging

2116: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2117: p_procedure_name => l_proc_name) ;
2118: x_return_status := FND_API.G_RET_STS_ERROR;
2119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2120: -- Standard Unexpected Error Logging
2121: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2122: p_procedure_name => l_proc_name) ;
2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2124: WHEN OTHERS THEN

Line 2125: -- Standard Unexpected Error Logging

2121: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2122: p_procedure_name => l_proc_name) ;
2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2124: WHEN OTHERS THEN
2125: -- Standard Unexpected Error Logging
2126: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2127: p_procedure_name => l_proc_name) ;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2359: -- Standard Expected Error Logging

2355: END LOOP;
2356: END IF;
2357: EXCEPTION
2358: WHEN FND_API.G_EXC_ERROR THEN
2359: -- Standard Expected Error Logging
2360: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2361: p_procedure_name => l_proc_name) ;
2362: x_return_status := FND_API.G_RET_STS_ERROR;
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2364: -- Standard Unexpected Error Logging

2360: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2361: p_procedure_name => l_proc_name) ;
2362: x_return_status := FND_API.G_RET_STS_ERROR;
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2364: -- Standard Unexpected Error Logging
2365: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2366: p_procedure_name => l_proc_name) ;
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368: WHEN OTHERS THEN

Line 2369: -- Standard Unexpected Error Logging

2365: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2366: p_procedure_name => l_proc_name) ;
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368: WHEN OTHERS THEN
2369: -- Standard Unexpected Error Logging
2370: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2371: p_procedure_name => l_proc_name) ;
2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2373: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2443: -- Standard Expected Error Logging

2439: p_procedure_name => l_proc_name) ;
2440: RETURN l_boolean_to_char;
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: -- Standard Expected Error Logging
2444: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
2445: p_procedure_name => l_proc_name) ;
2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: RETURN 'FALSE';

Line 2449: -- Standard Unexpected Error Logging

2445: p_procedure_name => l_proc_name) ;
2446: x_return_status := FND_API.G_RET_STS_ERROR;
2447: RETURN 'FALSE';
2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2449: -- Standard Unexpected Error Logging
2450: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2451: p_procedure_name => l_proc_name) ;
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453: RETURN 'FALSE';

Line 2455: -- Standard Unexpected Error Logging

2451: p_procedure_name => l_proc_name) ;
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453: RETURN 'FALSE';
2454: WHEN OTHERS THEN
2455: -- Standard Unexpected Error Logging
2456: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
2457: p_procedure_name => l_proc_name) ;
2458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2459: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2506: -- Standard Start of API savepoint

2502: BEGIN
2503: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
2504: p_procedure_name => l_api_name) ;
2505:
2506: -- Standard Start of API savepoint
2507: SAVEPOINT Validate_Shipment_PVT;
2508:
2509: -- Initialize message list if p_init_msg_list is set to TRUE.
2510: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 2594: -- Standard check of p_commit.

2590: last_update_date = SYSDATE
2591: WHERE ship_header_id = p_ship_header_id;
2592: END IF;
2593:
2594: -- Standard check of p_commit.
2595: IF FND_API.To_Boolean (p_commit) THEN
2596: COMMIT WORK;
2597: END IF;
2598:

Line 2599: -- Standard call to get message count and if count is 1, get message info.

2595: IF FND_API.To_Boolean (p_commit) THEN
2596: COMMIT WORK;
2597: END IF;
2598:
2599: -- Standard call to get message count and if count is 1, get message info.
2600: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
2601: p_count => x_msg_count,
2602: p_data => x_msg_data) ;
2603:

Line 2662: -- Standard Beginning of Procedure/Function Logging

2658: l_proc_name CONSTANT VARCHAR2 (30) := 'Create_Assoc';
2659: l_return_status VARCHAR2 (1) ;
2660: l_debug_info VARCHAR2 (200) ;
2661: BEGIN
2662: -- Standard Beginning of Procedure/Function Logging
2663: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
2664: p_procedure_name => l_proc_name) ;
2665: -- Initialize return status to success
2666: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2708: -- Standard End of Procedure/Function Logging

2704: fnd_global.user_id, /* 11 */
2705: sysdate, /* 12 */
2706: fnd_global.user_id /* 13 */
2707: );
2708: -- Standard End of Procedure/Function Logging
2709: INL_LOGGING_PVT.Log_EndProc
2710: (
2711: p_module_name => g_module_name,
2712: p_procedure_name => l_proc_name

Line 2717: -- Standard Expected Error Logging

2713: )
2714: ;
2715: EXCEPTION
2716: WHEN FND_API.G_EXC_ERROR THEN
2717: -- Standard Expected Error Logging
2718: INL_LOGGING_PVT.Log_ExpecError
2719: (
2720: p_module_name => g_module_name,
2721: p_procedure_name => l_proc_name

Line 2726: -- Standard Unexpected Error Logging

2722: )
2723: ;
2724: x_return_status := FND_API.G_RET_STS_ERROR;
2725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2726: -- Standard Unexpected Error Logging
2727: INL_LOGGING_PVT.Log_UnexpecError
2728: (
2729: p_module_name => g_module_name,
2730: p_procedure_name => l_proc_name

Line 2735: -- Standard Unexpected Error Logging

2731: )
2732: ;
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734: WHEN OTHERS THEN
2735: -- Standard Unexpected Error Logging
2736: INL_LOGGING_PVT.Log_UnexpecError
2737: (
2738: p_module_name => g_module_name,
2739: p_procedure_name => l_proc_name

Line 2787: -- Standard Beginning of Procedure/Function Logging

2783: l_debug_info VARCHAR2(200);
2784: l_tax_line_num NUMBER;
2785: l_adjustment_num NUMBER;
2786: BEGIN
2787: -- Standard Beginning of Procedure/Function Logging
2788: INL_LOGGING_PVT.Log_BeginProc (
2789: p_module_name => g_module_name,
2790: p_procedure_name => l_proc_name
2791: );

Line 2907: -- Standard End of Procedure/Function Logging

2903: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2905: END IF;
2906: END IF;
2907: -- Standard End of Procedure/Function Logging
2908: INL_LOGGING_PVT.Log_EndProc(
2909: p_module_name => g_module_name,
2910: p_procedure_name => l_proc_name
2911: );

Line 2914: -- Standard Expected Error Logging

2910: p_procedure_name => l_proc_name
2911: );
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: -- Standard Expected Error Logging
2915: INL_LOGGING_PVT.Log_ExpecError(
2916: p_module_name => g_module_name,
2917: p_procedure_name => l_proc_name
2918: );

Line 2921: -- Standard Unexpected Error Logging

2917: p_procedure_name => l_proc_name
2918: );
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2921: -- Standard Unexpected Error Logging
2922: INL_LOGGING_PVT.Log_UnexpecError(
2923: p_module_name => g_module_name,
2924: p_procedure_name => l_proc_name
2925: );

Line 2928: -- Standard Unexpected Error Logging

2924: p_procedure_name => l_proc_name
2925: );
2926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2927: WHEN OTHERS THEN
2928: -- Standard Unexpected Error Logging
2929: INL_LOGGING_PVT.Log_UnexpecError(
2930: p_module_name => g_module_name,
2931: p_procedure_name => l_proc_name
2932: );

Line 3043: -- Standard Beginning of Procedure/Function Logging

3039: l_TxLn_Assoc inl_TxLn_Assoc_tp;
3040: l_new_tax_line_id NUMBER;
3041: BEGIN
3042:
3043: -- Standard Beginning of Procedure/Function Logging
3044: INL_LOGGING_PVT.Log_BeginProc (
3045: p_module_name => g_module_name,
3046: p_procedure_name => l_proc_name
3047: );

Line 3110: -- Standard End of Procedure/Function Logging

3106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3107: END IF;
3108: END LOOP;
3109: END IF;
3110: -- Standard End of Procedure/Function Logging
3111: INL_LOGGING_PVT.Log_EndProc (
3112: p_module_name => g_module_name,
3113: p_procedure_name => l_proc_name
3114: ) ;

Line 3117: -- Standard Expected Error Logging

3113: p_procedure_name => l_proc_name
3114: ) ;
3115: EXCEPTION
3116: WHEN FND_API.G_EXC_ERROR THEN
3117: -- Standard Expected Error Logging
3118: INL_LOGGING_PVT.Log_ExpecError (
3119: p_module_name => g_module_name,
3120: p_procedure_name => l_proc_name
3121: ) ;

Line 3124: -- Standard Unexpected Error Logging

3120: p_procedure_name => l_proc_name
3121: ) ;
3122: x_return_status := FND_API.G_RET_STS_ERROR;
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: -- Standard Unexpected Error Logging
3125: INL_LOGGING_PVT.Log_UnexpecError (
3126: p_module_name => g_module_name,
3127: p_procedure_name => l_proc_name
3128: ) ;

Line 3131: -- Standard Unexpected Error Logging

3127: p_procedure_name => l_proc_name
3128: ) ;
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3130: WHEN OTHERS THEN
3131: -- Standard Unexpected Error Logging
3132: INL_LOGGING_PVT.Log_UnexpecError (
3133: p_module_name => g_module_name,
3134: p_procedure_name => l_proc_name
3135: ) ;

Line 3268: -- Standard Beginning of Procedure/Function Logging

3264: l_rejected_txn_qty NUMBER;
3265: -- Bug #7702294
3266:
3267: BEGIN
3268: -- Standard Beginning of Procedure/Function Logging
3269: INL_LOGGING_PVT.Log_BeginProc (
3270: p_module_name => g_module_name,
3271: p_procedure_name => l_api_name
3272: ) ;

Line 3273: -- Standard Start of API savepoint

3269: INL_LOGGING_PVT.Log_BeginProc (
3270: p_module_name => g_module_name,
3271: p_procedure_name => l_api_name
3272: ) ;
3273: -- Standard Start of API savepoint
3274: SAVEPOINT Adjust_ShipLines_PVT;
3275: -- Initialize message list if p_init_msg_list is set to TRUE.
3276: IF FND_API.to_Boolean (p_init_msg_list) THEN
3277: FND_MSG_PUB.initialize;

Line 3819: -- Standard check of p_commit.

3815: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3817: END IF;
3818: END IF;
3819: -- Standard check of p_commit.
3820: IF FND_API.To_Boolean (p_commit) THEN
3821: COMMIT WORK;
3822: END IF;
3823: -- Standard call to get message count and if count is 1, get message info.

Line 3823: -- Standard call to get message count and if count is 1, get message info.

3819: -- Standard check of p_commit.
3820: IF FND_API.To_Boolean (p_commit) THEN
3821: COMMIT WORK;
3822: END IF;
3823: -- Standard call to get message count and if count is 1, get message info.
3824: FND_MSG_PUB.Count_And_Get (
3825: p_encoded => FND_API.g_false,
3826: p_count => x_msg_count,
3827: p_data => x_msg_data

Line 3829: -- Standard End of Procedure/Function Logging

3825: p_encoded => FND_API.g_false,
3826: p_count => x_msg_count,
3827: p_data => x_msg_data
3828: ) ;
3829: -- Standard End of Procedure/Function Logging
3830: INL_LOGGING_PVT.Log_EndProc (
3831: p_module_name => g_module_name,
3832: p_procedure_name => l_api_name
3833: ) ;

Line 3836: -- Standard Expected Error Logging

3832: p_procedure_name => l_api_name
3833: ) ;
3834: EXCEPTION
3835: WHEN FND_API.G_EXC_ERROR THEN
3836: -- Standard Expected Error Logging
3837: INL_LOGGING_PVT.Log_ExpecError (
3838: p_module_name => g_module_name,
3839: p_procedure_name => l_api_name
3840: ) ;

Line 3849: -- Standard Unexpected Error Logging

3845: p_count => x_msg_count,
3846: p_data => x_msg_data
3847: ) ;
3848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3849: -- Standard Unexpected Error Logging
3850: INL_LOGGING_PVT.Log_UnexpecError (
3851: p_module_name => g_module_name,
3852: p_procedure_name => l_api_name
3853: ) ;

Line 3862: -- Standard Unexpected Error Logging

3858: p_count => x_msg_count,
3859: p_data => x_msg_data
3860: ) ;
3861: WHEN OTHERS THEN
3862: -- Standard Unexpected Error Logging
3863: INL_LOGGING_PVT.Log_UnexpecError (
3864: p_module_name => g_module_name,
3865: p_procedure_name => l_api_name
3866: ) ;

Line 3910: -- Standard Beginning of Procedure/Function Logging

3906: l_debug_info VARCHAR2 (200) ;
3907: l_charge_line_num NUMBER;
3908: l_adjustment_num NUMBER;
3909: BEGIN
3910: -- Standard Beginning of Procedure/Function Logging
3911: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
3912: -- Initialize return status to success
3913: x_return_status := FND_API.G_RET_STS_SUCCESS;
3914: --

Line 4068: -- Standard End of Procedure/Function Logging

4064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4066: END IF;
4067: END IF;
4068: -- Standard End of Procedure/Function Logging
4069: INL_LOGGING_PVT.Log_EndProc(
4070: p_module_name => g_module_name,
4071: p_procedure_name => l_proc_name
4072: );

Line 4075: -- Standard Expected Error Logging

4071: p_procedure_name => l_proc_name
4072: );
4073: EXCEPTION
4074: WHEN FND_API.G_EXC_ERROR THEN
4075: -- Standard Expected Error Logging
4076: INL_LOGGING_PVT.Log_ExpecError(
4077: p_module_name => g_module_name,
4078: p_procedure_name => l_proc_name
4079: );

Line 4082: -- Standard Unexpected Error Logging

4078: p_procedure_name => l_proc_name
4079: );
4080: x_return_status := FND_API.G_RET_STS_ERROR;
4081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4082: -- Standard Unexpected Error Logging
4083: INL_LOGGING_PVT.Log_UnexpecError(
4084: p_module_name => g_module_name,
4085: p_procedure_name => l_proc_name
4086: );

Line 4089: -- Standard Unexpected Error Logging

4085: p_procedure_name => l_proc_name
4086: );
4087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4088: WHEN OTHERS THEN
4089: -- Standard Unexpected Error Logging
4090: INL_LOGGING_PVT.Log_UnexpecError(
4091: p_module_name => g_module_name,
4092: p_procedure_name => l_proc_name
4093: );

Line 4318: -- Standard Beginning of Procedure/Function Logging

4314: l_new_charge_line_id NUMBER;
4315: l_level_charge_is_applied VARCHAR(5):= 'X';
4316: BEGIN
4317:
4318: -- Standard Beginning of Procedure/Function Logging
4319: INL_LOGGING_PVT.Log_BeginProc (
4320: p_module_name => g_module_name,
4321: p_procedure_name => l_proc_name
4322: );

Line 4471: -- Standard End of Procedure/Function Logging

4467: END IF;
4468: END LOOP;
4469: END IF;
4470:
4471: -- Standard End of Procedure/Function Logging
4472: INL_LOGGING_PVT.Log_EndProc (
4473: p_module_name => g_module_name,
4474: p_procedure_name => l_proc_name
4475: ) ;

Line 4478: -- Standard Expected Error Logging

4474: p_procedure_name => l_proc_name
4475: ) ;
4476: EXCEPTION
4477: WHEN FND_API.G_EXC_ERROR THEN
4478: -- Standard Expected Error Logging
4479: INL_LOGGING_PVT.Log_ExpecError (
4480: p_module_name => g_module_name,
4481: p_procedure_name => l_proc_name
4482: ) ;

Line 4485: -- Standard Unexpected Error Logging

4481: p_procedure_name => l_proc_name
4482: ) ;
4483: x_return_status := FND_API.G_RET_STS_ERROR;
4484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4485: -- Standard Unexpected Error Logging
4486: INL_LOGGING_PVT.Log_UnexpecError (
4487: p_module_name => g_module_name,
4488: p_procedure_name => l_proc_name
4489: ) ;

Line 4492: -- Standard Unexpected Error Logging

4488: p_procedure_name => l_proc_name
4489: ) ;
4490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4491: WHEN OTHERS THEN
4492: -- Standard Unexpected Error Logging
4493: INL_LOGGING_PVT.Log_UnexpecError (
4494: p_module_name => g_module_name,
4495: p_procedure_name => l_proc_name
4496: ) ;

Line 4565: -- Standard Beginning of Procedure/Function Logging

4561: l_to_parent_table_id NUMBER;
4562: l_prev_adjustment_num NUMBER := NULL;
4563: l_ChLn_Assoc inl_ChLn_Assoc_tp;
4564: BEGIN
4565: -- Standard Beginning of Procedure/Function Logging
4566: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4567: -- Standard Start of API savepoint
4568: SAVEPOINT Adjust_ChargeLines_PVT;
4569: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4567: -- Standard Start of API savepoint

4563: l_ChLn_Assoc inl_ChLn_Assoc_tp;
4564: BEGIN
4565: -- Standard Beginning of Procedure/Function Logging
4566: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4567: -- Standard Start of API savepoint
4568: SAVEPOINT Adjust_ChargeLines_PVT;
4569: -- Initialize message list if p_init_msg_list is set to TRUE.
4570: IF FND_API.to_Boolean (p_init_msg_list) THEN
4571: FND_MSG_PUB.initialize;

Line 4818: -- Standard check of p_commit.

4814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4815: END IF;
4816:
4817:
4818: -- Standard check of p_commit.
4819: IF FND_API.To_Boolean (p_commit) THEN
4820: COMMIT WORK;
4821: END IF;
4822: -- Standard call to get message count and if count is 1, get message info.

Line 4822: -- Standard call to get message count and if count is 1, get message info.

4818: -- Standard check of p_commit.
4819: IF FND_API.To_Boolean (p_commit) THEN
4820: COMMIT WORK;
4821: END IF;
4822: -- Standard call to get message count and if count is 1, get message info.
4823: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4824: -- Standard End of Procedure/Function Logging
4825: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4826: EXCEPTION

Line 4824: -- Standard End of Procedure/Function Logging

4820: COMMIT WORK;
4821: END IF;
4822: -- Standard call to get message count and if count is 1, get message info.
4823: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4824: -- Standard End of Procedure/Function Logging
4825: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4826: EXCEPTION
4827: WHEN FND_API.G_EXC_ERROR THEN
4828: -- Standard Expected Error Logging

Line 4828: -- Standard Expected Error Logging

4824: -- Standard End of Procedure/Function Logging
4825: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4826: EXCEPTION
4827: WHEN FND_API.G_EXC_ERROR THEN
4828: -- Standard Expected Error Logging
4829: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4830: ROLLBACK TO Adjust_ChargeLines_PVT;
4831: x_return_status := FND_API.G_RET_STS_ERROR;
4832: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 4834: -- Standard Unexpected Error Logging

4830: ROLLBACK TO Adjust_ChargeLines_PVT;
4831: x_return_status := FND_API.G_RET_STS_ERROR;
4832: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4834: -- Standard Unexpected Error Logging
4835: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4836: ROLLBACK TO Adjust_ChargeLines_PVT;
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4838: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 4840: -- Standard Unexpected Error Logging

4836: ROLLBACK TO Adjust_ChargeLines_PVT;
4837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4838: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
4839: WHEN OTHERS THEN
4840: -- Standard Unexpected Error Logging
4841: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4842: ROLLBACK TO Adjust_ChargeLines_PVT;
4843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4844: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 4927: -- Standard Beginning of Procedure/Function Logging

4923: l_to_parent_table_id NUMBER;
4924: l_ChLn_Assoc inl_ChLn_Assoc_tp;
4925: l_AssocLn inl_Assoc_tp;
4926: BEGIN
4927: -- Standard Beginning of Procedure/Function Logging
4928: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4929: -- Standard Start of API savepoint
4930:
4931: SAVEPOINT Adjust_ChargeLines_PVT;

Line 4929: -- Standard Start of API savepoint

4925: l_AssocLn inl_Assoc_tp;
4926: BEGIN
4927: -- Standard Beginning of Procedure/Function Logging
4928: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
4929: -- Standard Start of API savepoint
4930:
4931: SAVEPOINT Adjust_ChargeLines_PVT;
4932: -- Initialize message list if p_init_msg_list is set to TRUE.
4933: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 5218: -- Standard check of p_commit.

5214: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5216: END IF;
5217:
5218: -- Standard check of p_commit.
5219:
5220: IF FND_API.To_Boolean (p_commit) THEN
5221: COMMIT WORK;
5222: END IF;

Line 5223: -- Standard call to get message count and if count is 1, get message info.

5219:
5220: IF FND_API.To_Boolean (p_commit) THEN
5221: COMMIT WORK;
5222: END IF;
5223: -- Standard call to get message count and if count is 1, get message info.
5224: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5225: -- Standard End of Procedure/Function Logging
5226: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5227: EXCEPTION

Line 5225: -- Standard End of Procedure/Function Logging

5221: COMMIT WORK;
5222: END IF;
5223: -- Standard call to get message count and if count is 1, get message info.
5224: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5225: -- Standard End of Procedure/Function Logging
5226: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5227: EXCEPTION
5228: WHEN FND_API.G_EXC_ERROR THEN
5229: -- Standard Expected Error Logging

Line 5229: -- Standard Expected Error Logging

5225: -- Standard End of Procedure/Function Logging
5226: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5227: EXCEPTION
5228: WHEN FND_API.G_EXC_ERROR THEN
5229: -- Standard Expected Error Logging
5230: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5231: ROLLBACK TO Adjust_ChargeLines_PVT;
5232: x_return_status := FND_API.G_RET_STS_ERROR;
5233: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5235: -- Standard Unexpected Error Logging

5231: ROLLBACK TO Adjust_ChargeLines_PVT;
5232: x_return_status := FND_API.G_RET_STS_ERROR;
5233: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5235: -- Standard Unexpected Error Logging
5236: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5237: ROLLBACK TO Adjust_ChargeLines_PVT;
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5241: -- Standard Unexpected Error Logging

5237: ROLLBACK TO Adjust_ChargeLines_PVT;
5238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5239: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5240: WHEN OTHERS THEN
5241: -- Standard Unexpected Error Logging
5242: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5243: ROLLBACK TO Adjust_ChargeLines_PVT;
5244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5245: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5304: -- Standard Beginning of Procedure/Function Logging

5300: l_from_parent_table_id NUMBER;
5301: l_ship_line_id NUMBER;
5302: l_new_tax_line_id NUMBER;
5303: BEGIN
5304: -- Standard Beginning of Procedure/Function Logging
5305: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5306: -- Standard Start of API savepoint
5307: SAVEPOINT Adjust_TaxLines_PVT;
5308: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5306: -- Standard Start of API savepoint

5302: l_new_tax_line_id NUMBER;
5303: BEGIN
5304: -- Standard Beginning of Procedure/Function Logging
5305: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5306: -- Standard Start of API savepoint
5307: SAVEPOINT Adjust_TaxLines_PVT;
5308: -- Initialize message list if p_init_msg_list is set to TRUE.
5309: IF FND_API.to_Boolean (p_init_msg_list) THEN
5310: FND_MSG_PUB.initialize;

Line 5447: -- Standard check of p_commit.

5443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5444: END IF;
5445: -- The estimated tax lines will made = 0 when as actual arrived on associated line
5446: -- i.e. when a charge became and actual value the estimated taxes will made 0 too
5447: -- Standard check of p_commit.
5448: IF FND_API.To_Boolean (p_commit) THEN
5449: COMMIT WORK;
5450: END IF;
5451: -- Standard call to get message count and if count is 1, get message info.

Line 5451: -- Standard call to get message count and if count is 1, get message info.

5447: -- Standard check of p_commit.
5448: IF FND_API.To_Boolean (p_commit) THEN
5449: COMMIT WORK;
5450: END IF;
5451: -- Standard call to get message count and if count is 1, get message info.
5452: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5453: -- Standard End of Procedure/Function Logging
5454: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5455: EXCEPTION

Line 5453: -- Standard End of Procedure/Function Logging

5449: COMMIT WORK;
5450: END IF;
5451: -- Standard call to get message count and if count is 1, get message info.
5452: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5453: -- Standard End of Procedure/Function Logging
5454: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5455: EXCEPTION
5456: WHEN FND_API.G_EXC_ERROR THEN
5457: -- Standard Expected Error Logging

Line 5457: -- Standard Expected Error Logging

5453: -- Standard End of Procedure/Function Logging
5454: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5455: EXCEPTION
5456: WHEN FND_API.G_EXC_ERROR THEN
5457: -- Standard Expected Error Logging
5458: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5459: ROLLBACK TO Adjust_TaxLines_PVT;
5460: x_return_status := FND_API.G_RET_STS_ERROR;
5461: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5463: -- Standard Unexpected Error Logging

5459: ROLLBACK TO Adjust_TaxLines_PVT;
5460: x_return_status := FND_API.G_RET_STS_ERROR;
5461: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5463: -- Standard Unexpected Error Logging
5464: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5465: ROLLBACK TO Adjust_TaxLines_PVT;
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5469: -- Standard Unexpected Error Logging

5465: ROLLBACK TO Adjust_TaxLines_PVT;
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5468: WHEN OTHERS THEN
5469: -- Standard Unexpected Error Logging
5470: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5471: ROLLBACK TO Adjust_TaxLines_PVT;
5472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5473: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5529: -- Standard Beginning of Procedure/Function Logging

5525: l_existing_match_info_flag VARCHAR2(1);
5526: l_charge_line_type_id NUMBER;
5527: l_new_tax_line_id NUMBER;
5528: BEGIN
5529: -- Standard Beginning of Procedure/Function Logging
5530: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5531: -- Standard Start of API savepoint
5532:
5533: SAVEPOINT Adjust_TaxLines_2_PVT;

Line 5531: -- Standard Start of API savepoint

5527: l_new_tax_line_id NUMBER;
5528: BEGIN
5529: -- Standard Beginning of Procedure/Function Logging
5530: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5531: -- Standard Start of API savepoint
5532:
5533: SAVEPOINT Adjust_TaxLines_2_PVT;
5534: -- Initialize message list if p_init_msg_list is set to TRUE.
5535: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 5707: -- Standard check of p_commit.

5703: END IF;
5704:
5705: -- The estimated tax lines will made = 0 when as actual arrived on associated line
5706: -- i.e. when a charge became and actual value the estimated taxes will made 0 too
5707: -- Standard check of p_commit.
5708: IF FND_API.To_Boolean (p_commit) THEN
5709: COMMIT WORK;
5710: END IF;
5711: -- Standard call to get message count and if count is 1, get message info.

Line 5711: -- Standard call to get message count and if count is 1, get message info.

5707: -- Standard check of p_commit.
5708: IF FND_API.To_Boolean (p_commit) THEN
5709: COMMIT WORK;
5710: END IF;
5711: -- Standard call to get message count and if count is 1, get message info.
5712: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5713: -- Standard End of Procedure/Function Logging
5714: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5715: EXCEPTION

Line 5713: -- Standard End of Procedure/Function Logging

5709: COMMIT WORK;
5710: END IF;
5711: -- Standard call to get message count and if count is 1, get message info.
5712: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5713: -- Standard End of Procedure/Function Logging
5714: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5715: EXCEPTION
5716: WHEN FND_API.G_EXC_ERROR THEN
5717: -- Standard Expected Error Logging

Line 5717: -- Standard Expected Error Logging

5713: -- Standard End of Procedure/Function Logging
5714: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5715: EXCEPTION
5716: WHEN FND_API.G_EXC_ERROR THEN
5717: -- Standard Expected Error Logging
5718: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5719: ROLLBACK TO Adjust_TaxLines_2_PVT_PVT;
5720: x_return_status := FND_API.G_RET_STS_ERROR;
5721: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5723: -- Standard Unexpected Error Logging

5719: ROLLBACK TO Adjust_TaxLines_2_PVT_PVT;
5720: x_return_status := FND_API.G_RET_STS_ERROR;
5721: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5723: -- Standard Unexpected Error Logging
5724: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5725: ROLLBACK TO Adjust_TaxLines_2_PVT_PVT;
5726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5727: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5729: -- Standard Unexpected Error Logging

5725: ROLLBACK TO Adjust_TaxLines_2_PVT_PVT;
5726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5727: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5728: WHEN OTHERS THEN
5729: -- Standard Unexpected Error Logging
5730: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5731: ROLLBACK TO Adjust_TaxLines_2_PVT;
5732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5733: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5825: -- Standard Beginning of Procedure/Function Logging

5821: --
5822: -- Create Adjustments for Shipment Lines and Charge Lines
5823: --
5824: BEGIN
5825: -- Standard Beginning of Procedure/Function Logging
5826: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5827: -- Standard Start of API savepoint
5828: SAVEPOINT Adjust_Lines_PVT;
5829: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 5827: -- Standard Start of API savepoint

5823: --
5824: BEGIN
5825: -- Standard Beginning of Procedure/Function Logging
5826: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5827: -- Standard Start of API savepoint
5828: SAVEPOINT Adjust_Lines_PVT;
5829: -- Initialize message list if p_init_msg_list is set to TRUE.
5830: IF FND_API.to_Boolean (p_init_msg_list) THEN
5831: FND_MSG_PUB.initialize;

Line 5972: -- Standard check of p_commit.

5968: WHERE ship_header_id = p_ship_header_id;
5969: END IF;
5970: END;
5971: -- End of API Body
5972: -- Standard check of p_commit.
5973: IF FND_API.To_Boolean (p_commit) THEN
5974: COMMIT WORK;
5975: END IF;
5976: -- Standard call to get message count and if count is 1, get message info.

Line 5976: -- Standard call to get message count and if count is 1, get message info.

5972: -- Standard check of p_commit.
5973: IF FND_API.To_Boolean (p_commit) THEN
5974: COMMIT WORK;
5975: END IF;
5976: -- Standard call to get message count and if count is 1, get message info.
5977: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5978: -- Standard End of Procedure/Function Logging
5979: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5980: EXCEPTION

Line 5978: -- Standard End of Procedure/Function Logging

5974: COMMIT WORK;
5975: END IF;
5976: -- Standard call to get message count and if count is 1, get message info.
5977: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5978: -- Standard End of Procedure/Function Logging
5979: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5980: EXCEPTION
5981: WHEN FND_API.G_EXC_ERROR THEN
5982: -- Standard Expected Error Logging

Line 5982: -- Standard Expected Error Logging

5978: -- Standard End of Procedure/Function Logging
5979: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5980: EXCEPTION
5981: WHEN FND_API.G_EXC_ERROR THEN
5982: -- Standard Expected Error Logging
5983: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5984: ROLLBACK TO Adjust_Lines_PVT;
5985: x_return_status := FND_API.G_RET_STS_ERROR;
5986: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5988: -- Standard Unexpected Error Logging

5984: ROLLBACK TO Adjust_Lines_PVT;
5985: x_return_status := FND_API.G_RET_STS_ERROR;
5986: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5987: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5988: -- Standard Unexpected Error Logging
5989: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5990: ROLLBACK TO Adjust_Lines_PVT;
5991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5992: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 5994: -- Standard Unexpected Error Logging

5990: ROLLBACK TO Adjust_Lines_PVT;
5991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5992: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
5993: WHEN OTHERS THEN
5994: -- Standard Unexpected Error Logging
5995: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
5996: ROLLBACK TO Adjust_Lines_PVT;
5997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5998: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 6052: -- Standard Start of API savepoint

6048: l_api_name CONSTANT VARCHAR2 (30) := 'Get_1ary2aryQty';
6049: l_api_version CONSTANT NUMBER := 1.0;
6050: BEGIN
6051: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6052: -- Standard Start of API savepoint
6053: SAVEPOINT Get_1ary2aryQty_PVT;
6054: -- Initialize message list if p_init_msg_list is set to TRUE.
6055: IF FND_API.to_Boolean (p_init_msg_list) THEN
6056: FND_MSG_PUB.initialize;

Line 6178: -- Standard check of p_commit.

6174: p_var_name => l_debug_info,
6175: p_var_value => TO_CHAR (x_2ary_qty)) ;
6176: END IF;
6177: --==========
6178: -- Standard check of p_commit.
6179: IF FND_API.To_Boolean (p_commit) THEN
6180: COMMIT WORK;
6181: END IF;
6182: -- Standard call to get message count and if count is 1, get message info.

Line 6182: -- Standard call to get message count and if count is 1, get message info.

6178: -- Standard check of p_commit.
6179: IF FND_API.To_Boolean (p_commit) THEN
6180: COMMIT WORK;
6181: END IF;
6182: -- Standard call to get message count and if count is 1, get message info.
6183: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
6184: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6185: EXCEPTION
6186: WHEN FND_API.G_EXC_ERROR THEN

Line 6228: -- Standard Beginning of Procedure/Function Logging

6224: l_tolerable_quantity NUMBER;
6225: l_unit_of_measure VARCHAR2(30);
6226:
6227: BEGIN
6228: -- Standard Beginning of Procedure/Function Logging
6229: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
6230: p_procedure_name => l_func_name) ;
6231:
6232: -- Logging variables

Line 6272: -- Standard End of Procedure/Function Logging

6268: p_procedure_name => l_func_name,
6269: p_var_name => 'l_unit_of_measure',
6270: p_var_value => l_unit_of_measure) ;
6271:
6272: -- Standard End of Procedure/Function Logging
6273: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
6274: p_procedure_name => l_func_name) ;
6275: RETURN NVL(l_available_qty,0);
6276: END Get_SrcAvailableQty;

Line 6317: -- Standard Beginning of Procedure/Function Logging

6313: l_msg_count_validate NUMBER;
6314: l_organization_id NUMBER;
6315:
6316: BEGIN
6317: -- Standard Beginning of Procedure/Function Logging
6318: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
6319: p_procedure_name => l_api_name) ;
6320: -- Standard Start of API savepoint
6321: SAVEPOINT Run_Submit_PVT;

Line 6320: -- Standard Start of API savepoint

6316: BEGIN
6317: -- Standard Beginning of Procedure/Function Logging
6318: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
6319: p_procedure_name => l_api_name) ;
6320: -- Standard Start of API savepoint
6321: SAVEPOINT Run_Submit_PVT;
6322: -- Initialize message list if p_init_msg_list is set to TRUE.
6323: IF FND_API.to_Boolean (p_init_msg_list) THEN
6324: FND_MSG_PUB.initialize;

Line 6521: -- Standard check of p_commit.

6517: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6519: END IF;
6520:
6521: -- Standard check of p_commit.
6522: IF FND_API.To_Boolean (p_commit) THEN
6523: COMMIT WORK;
6524: END IF;
6525:

Line 6526: -- Standard call to get message count and if count is 1, get message info.

6522: IF FND_API.To_Boolean (p_commit) THEN
6523: COMMIT WORK;
6524: END IF;
6525:
6526: -- Standard call to get message count and if count is 1, get message info.
6527: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
6528: p_count => x_msg_count,
6529: p_data => x_msg_data) ;
6530:

Line 6531: -- Standard End of Procedure/Function Logging

6527: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
6528: p_count => x_msg_count,
6529: p_data => x_msg_data) ;
6530:
6531: -- Standard End of Procedure/Function Logging
6532: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
6533: p_procedure_name => l_api_name) ;
6534: EXCEPTION
6535: WHEN FND_API.G_EXC_ERROR THEN

Line 6536: -- Standard Expected Error Logging

6532: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
6533: p_procedure_name => l_api_name) ;
6534: EXCEPTION
6535: WHEN FND_API.G_EXC_ERROR THEN
6536: -- Standard Expected Error Logging
6537: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
6538: p_procedure_name => l_api_name) ;
6539: ROLLBACK TO Run_Submit_PVT;
6540: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6545: -- Standard Unexpected Error Logging

6541: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
6542: p_count => x_msg_count,
6543: p_data => x_msg_data) ;
6544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6545: -- Standard Unexpected Error Logging
6546: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
6547: p_procedure_name => l_api_name) ;
6548: ROLLBACK TO Run_Submit_PVT;
6549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 6554: -- Standard Unexpected Error Logging

6550: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
6551: p_count => x_msg_count,
6552: p_data => x_msg_data) ;
6553: WHEN OTHERS THEN
6554: -- Standard Unexpected Error Logging
6555: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
6556: p_procedure_name => l_api_name) ;
6557: ROLLBACK TO Run_Submit_PVT;
6558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6613: -- Standard Beginning of Procedure/Function Logging

6609: -- Init conc. parameters
6610: errbuf := NULL;
6611: retcode := 0;
6612:
6613: -- Standard Beginning of Procedure/Function Logging
6614: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
6615: p_procedure_name => l_proc_name) ;
6616:
6617: -- Submit only the given Shipment

Line 6701: -- Standard End of Procedure/Function Logging

6697: END LOOP;
6698: CLOSE c_pending_shipments;
6699: END IF;
6700:
6701: -- Standard End of Procedure/Function Logging
6702: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
6703: p_procedure_name => l_proc_name) ;
6704: EXCEPTION
6705: WHEN FND_API.G_EXC_ERROR THEN

Line 6706: -- Standard Expected Error Logging

6702: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
6703: p_procedure_name => l_proc_name) ;
6704: EXCEPTION
6705: WHEN FND_API.G_EXC_ERROR THEN
6706: -- Standard Expected Error Logging
6707: INL_logging_pvt.Log_ExpecError ( p_module_name => g_module_name,
6708: p_procedure_name => l_proc_name) ;
6709: retcode := 1;
6710: errbuf := errbuf ||' G_EXC_ERROR '||SQLERRM;

Line 6712: -- Standard Unexpected Error Logging

6708: p_procedure_name => l_proc_name) ;
6709: retcode := 1;
6710: errbuf := errbuf ||' G_EXC_ERROR '||SQLERRM;
6711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6712: -- Standard Unexpected Error Logging
6713: INL_logging_pvt.Log_UnexpecError ( p_module_name => g_module_name,
6714: p_procedure_name => l_proc_name) ;
6715: retcode := 2;
6716: errbuf := errbuf ||' G_EXC_UNEXPECTED_ERROR '||SQLERRM;

Line 6718: -- Standard Unexpected Error Logging

6714: p_procedure_name => l_proc_name) ;
6715: retcode := 2;
6716: errbuf := errbuf ||' G_EXC_UNEXPECTED_ERROR '||SQLERRM;
6717: WHEN OTHERS THEN
6718: -- Standard Unexpected Error Logging
6719: INL_logging_pvt.Log_UnexpecError ( p_module_name => g_module_name,
6720: p_procedure_name => l_proc_name) ;
6721: retcode := 2;
6722: errbuf := errbuf ||' OTHERS '||SQLERRM;

Line 6761: -- Standard Expected Error Logging

6757:
6758: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6759: EXCEPTION
6760: WHEN FND_API.G_EXC_ERROR THEN
6761: -- Standard Expected Error Logging
6762: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6763: x_return_status := FND_API.G_RET_STS_ERROR;
6764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6765: -- Standard Unexpected Error Logging

Line 6765: -- Standard Unexpected Error Logging

6761: -- Standard Expected Error Logging
6762: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6763: x_return_status := FND_API.G_RET_STS_ERROR;
6764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6765: -- Standard Unexpected Error Logging
6766: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6768: WHEN OTHERS THEN
6769: -- Standard Unexpected Error Logging

Line 6769: -- Standard Unexpected Error Logging

6765: -- Standard Unexpected Error Logging
6766: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6768: WHEN OTHERS THEN
6769: -- Standard Unexpected Error Logging
6770: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_proc_name) ;
6771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6773: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name, p_procedure_name => l_proc_name) ;

Line 6829: -- Standard Beginning of Procedure/Function Logging

6825: AND a.ship_header_id <> p_ship_header_id;
6826:
6827: r_affected_ship c_affected_ship%ROWTYPE;
6828: BEGIN
6829: -- Standard Beginning of Procedure/Function Logging
6830: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6831: -- Standard Start of API savepoint
6832: SAVEPOINT Delete_ChargeAssoc_PVT;
6833: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 6831: -- Standard Start of API savepoint

6827: r_affected_ship c_affected_ship%ROWTYPE;
6828: BEGIN
6829: -- Standard Beginning of Procedure/Function Logging
6830: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6831: -- Standard Start of API savepoint
6832: SAVEPOINT Delete_ChargeAssoc_PVT;
6833: -- Initialize message list if p_init_msg_list is set to TRUE.
6834: IF FND_API.to_Boolean (p_init_msg_list) THEN
6835: FND_MSG_PUB.initialize;

Line 6874: -- Standard check of p_commit.

6870: END IF;
6871: END LOOP;
6872: CLOSE c_affected_ship;
6873: END;
6874: -- Standard check of p_commit.
6875: IF FND_API.To_Boolean (p_commit) THEN
6876: COMMIT WORK;
6877: END IF;
6878: -- Standard call to get message count and if count is 1, get message info.

Line 6878: -- Standard call to get message count and if count is 1, get message info.

6874: -- Standard check of p_commit.
6875: IF FND_API.To_Boolean (p_commit) THEN
6876: COMMIT WORK;
6877: END IF;
6878: -- Standard call to get message count and if count is 1, get message info.
6879: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
6880: -- Standard End of Procedure/Function Logging
6881: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6882: EXCEPTION

Line 6880: -- Standard End of Procedure/Function Logging

6876: COMMIT WORK;
6877: END IF;
6878: -- Standard call to get message count and if count is 1, get message info.
6879: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
6880: -- Standard End of Procedure/Function Logging
6881: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6882: EXCEPTION
6883: WHEN FND_API.G_EXC_ERROR THEN
6884: -- Standard Expected Error Logging

Line 6884: -- Standard Expected Error Logging

6880: -- Standard End of Procedure/Function Logging
6881: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6882: EXCEPTION
6883: WHEN FND_API.G_EXC_ERROR THEN
6884: -- Standard Expected Error Logging
6885: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6886: ROLLBACK TO Delete_ChargeAssoc_PVT;
6887: x_return_status := FND_API.G_RET_STS_ERROR;
6888: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 6890: -- Standard Unexpected Error Logging

6886: ROLLBACK TO Delete_ChargeAssoc_PVT;
6887: x_return_status := FND_API.G_RET_STS_ERROR;
6888: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
6889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6890: -- Standard Unexpected Error Logging
6891: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6892: ROLLBACK TO Delete_ChargeAssoc_PVT;
6893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6894: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

Line 6896: -- Standard Unexpected Error Logging

6892: ROLLBACK TO Delete_ChargeAssoc_PVT;
6893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6894: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
6895: WHEN OTHERS THEN
6896: -- Standard Unexpected Error Logging
6897: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
6898: ROLLBACK TO Delete_ChargeAssoc_PVT;
6899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6900: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN