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 FND_API

Line 11: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

7: --
8: -- Pre-reqs : None
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER
11: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
13: -- p_current_ship_header_id IN NUMBER
14: -- p_new_ship_header_id IN NUMBER
15: -- p_from_parent_table_id IN NUMBER

Line 12: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

8: -- Pre-reqs : None
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER
11: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
13: -- p_current_ship_header_id IN NUMBER
14: -- p_new_ship_header_id IN NUMBER
15: -- p_from_parent_table_id IN NUMBER
16: -- p_to_parent_table_name IN VARCHAR2

Line 29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

25: -- Version : Current version 1.0
26: --
27: -- Notes :
28: PROCEDURE Duplicate_Tax (p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_current_ship_header_id IN NUMBER,
32: p_new_ship_header_id IN NUMBER,
33: p_from_parent_table_id IN NUMBER,

Line 30: p_commit IN VARCHAR2 := FND_API.G_FALSE,

26: --
27: -- Notes :
28: PROCEDURE Duplicate_Tax (p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30: p_commit IN VARCHAR2 := FND_API.G_FALSE,
31: p_current_ship_header_id IN NUMBER,
32: p_new_ship_header_id IN NUMBER,
33: p_from_parent_table_id IN NUMBER,
34: p_to_parent_table_name IN VARCHAR2,

Line 46: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

42: l_return_status VARCHAR2(1);
43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(2000);
45: l_api_version CONSTANT NUMBER := 1.0;
46: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
47: l_commit VARCHAR2(1) := FND_API.G_FALSE;
48: l_debug_msg VARCHAR2(400);
49:
50: l_tax_line_id NUMBER;

Line 47: l_commit VARCHAR2(1) := FND_API.G_FALSE;

43: l_msg_count NUMBER;
44: l_msg_data VARCHAR2(2000);
45: l_api_version CONSTANT NUMBER := 1.0;
46: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
47: l_commit VARCHAR2(1) := FND_API.G_FALSE;
48: l_debug_msg VARCHAR2(400);
49:
50: l_tax_line_id NUMBER;
51:

Line 100: IF FND_API.to_Boolean(p_init_msg_list) THEN

96: -- Standard Start of API savepoint
97: SAVEPOINT Duplicate_Tax_GRP;
98:
99: -- Initialize message list if p_init_msg_list is set to TRUE.
100: IF FND_API.to_Boolean(p_init_msg_list) THEN
101: FND_MSG_PUB.initialize;
102: END IF;
103:
104: -- Standard call to check for call compatibility

Line 105: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

101: FND_MSG_PUB.initialize;
102: END IF;
103:
104: -- Standard call to check for call compatibility
105: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
106: p_caller_version_number => p_api_version,
107: p_api_name => l_api_name,
108: p_pkg_name => g_pkg_name ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
106: p_caller_version_number => p_api_version,
107: p_api_name => l_api_name,
108: p_pkg_name => g_pkg_name ) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111:
112: -- Initialize API return status to success
113: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 113: x_return_status := FND_API.G_RET_STS_SUCCESS;

109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
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',

Line 238: IF FND_API.To_Boolean(p_commit) THEN

234: fnd_global.login_id);
235: END LOOP;
236:
237: -- Standard check of p_commit.
238: IF FND_API.To_Boolean(p_commit) THEN
239: COMMIT WORK;
240: END IF;
241: -- Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

238: IF FND_API.To_Boolean(p_commit) THEN
239: COMMIT WORK;
240: END IF;
241: -- Standard call to get message count and if count is 1, get message info.
242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data) ;
245:
246: -- Standard End of Procedure/Function Logging

Line 251: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

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,
258: p_count => x_msg_count,
259: p_data => x_msg_data);
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

256: x_return_status := FND_API.G_RET_STS_ERROR;
257: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
267: p_count => x_msg_count,
268: p_data => x_msg_data);
269: WHEN OTHERS THEN

Line 266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
267: p_count => x_msg_count,
268: p_data => x_msg_data);
269: WHEN OTHERS THEN
270: -- Standard Unexpected Error Logging

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
276: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

277: ) THEN
278: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
279: p_procedure_name => l_api_name);
280: END IF;
281: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data);
284: END Duplicate_Tax;
285:

Line 293: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

289: --
290: -- Pre-reqs : None
291: -- Parameters :
292: -- IN : p_api_version IN NUMBER
293: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
294: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
295: -- p_current_ship_header_id IN NUMBER
296: -- p_new_ship_header_id IN NUMBER
297: -- p_from_parent_table_id IN NUMBER

Line 294: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

290: -- Pre-reqs : None
291: -- Parameters :
292: -- IN : p_api_version IN NUMBER
293: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
294: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
295: -- p_current_ship_header_id IN NUMBER
296: -- p_new_ship_header_id IN NUMBER
297: -- p_from_parent_table_id IN NUMBER
298: -- p_to_parent_table_name IN VARCHAR2

Line 311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

307: -- Version : Current version 1.0
308: --
309: -- Notes :
310: PROCEDURE Duplicate_Charge (p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: p_current_ship_header_id IN NUMBER,
314: p_new_ship_header_id IN NUMBER,
315: p_from_parent_table_id IN NUMBER,

Line 312: p_commit IN VARCHAR2 := FND_API.G_FALSE,

308: --
309: -- Notes :
310: PROCEDURE Duplicate_Charge (p_api_version IN NUMBER,
311: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
312: p_commit IN VARCHAR2 := FND_API.G_FALSE,
313: p_current_ship_header_id IN NUMBER,
314: p_new_ship_header_id IN NUMBER,
315: p_from_parent_table_id IN NUMBER,
316: p_to_parent_table_name IN VARCHAR2,

Line 328: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

324: l_return_status VARCHAR2(1);
325: l_msg_count NUMBER;
326: l_msg_data VARCHAR2(2000);
327: l_api_version CONSTANT NUMBER := 1.0;
328: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
329: l_commit VARCHAR2(1) := FND_API.G_FALSE;
330: l_debug_msg VARCHAR2(400);
331:
332: l_charge_line_id NUMBER;

Line 329: l_commit VARCHAR2(1) := FND_API.G_FALSE;

325: l_msg_count NUMBER;
326: l_msg_data VARCHAR2(2000);
327: l_api_version CONSTANT NUMBER := 1.0;
328: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
329: l_commit VARCHAR2(1) := FND_API.G_FALSE;
330: l_debug_msg VARCHAR2(400);
331:
332: l_charge_line_id NUMBER;
333:

Line 403: IF FND_API.to_Boolean(p_init_msg_list) THEN

399: -- Standard Start of API savepoint
400: SAVEPOINT Duplicate_Charge_GRP;
401:
402: -- Initialize message list if p_init_msg_list is set to TRUE.
403: IF FND_API.to_Boolean(p_init_msg_list) THEN
404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Standard call to check for call compatibility

Line 408: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Standard call to check for call compatibility
408: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
409: p_caller_version_number => p_api_version,
410: p_api_name => l_api_name,
411: p_pkg_name => g_pkg_name ) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
409: p_caller_version_number => p_api_version,
410: p_api_name => l_api_name,
411: p_pkg_name => g_pkg_name ) THEN
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414:
415: -- Initialize API return status to success
416: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 416: x_return_status := FND_API.G_RET_STS_SUCCESS;

412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
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',

Line 583: IF FND_API.To_Boolean(p_commit) THEN

579: fnd_global.login_id);
580: END LOOP;
581:
582: -- Standard check of p_commit.
583: IF FND_API.To_Boolean(p_commit) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 587: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

583: IF FND_API.To_Boolean(p_commit) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
588: p_count => x_msg_count,
589: p_data => x_msg_data) ;
590:
591: -- Standard End of Procedure/Function Logging

Line 596: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 601: x_return_status := FND_API.G_RET_STS_ERROR;

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,
603: p_count => x_msg_count,
604: p_data => x_msg_data);
605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 602: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

601: x_return_status := FND_API.G_RET_STS_ERROR;
602: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
612: p_count => x_msg_count,
613: p_data => x_msg_data);
614: WHEN OTHERS THEN

Line 611: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
612: p_count => x_msg_count,
613: p_data => x_msg_data);
614: WHEN OTHERS THEN
615: -- Standard Unexpected Error Logging

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
621: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

622: ) THEN
623: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
624: p_procedure_name => l_api_name);
625: END IF;
626: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data);
629: END Duplicate_Charge;
630:

Line 638: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

634: --
635: -- Pre-reqs : None
636: -- Parameters :
637: -- IN : p_api_version IN NUMBER
638: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
640: -- p_current_ship_line_group_id IN NUMBER
641: -- p_new_ship_line_group_id IN NUMBER
642: --

Line 639: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

635: -- Pre-reqs : None
636: -- Parameters :
637: -- IN : p_api_version IN NUMBER
638: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
640: -- p_current_ship_line_group_id IN NUMBER
641: -- p_new_ship_line_group_id IN NUMBER
642: --
643: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 652: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

648: -- Version : Current version 1.0
649: --
650: -- Notes :
651: PROCEDURE Duplicate_ShipLines (p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
653: p_commit IN VARCHAR2 := FND_API.G_FALSE,
654: p_current_ship_line_group_id IN NUMBER,
655: p_new_ship_line_group_id IN NUMBER,
656: x_return_status OUT NOCOPY VARCHAR2,

Line 653: p_commit IN VARCHAR2 := FND_API.G_FALSE,

649: --
650: -- Notes :
651: PROCEDURE Duplicate_ShipLines (p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
653: p_commit IN VARCHAR2 := FND_API.G_FALSE,
654: p_current_ship_line_group_id IN NUMBER,
655: p_new_ship_line_group_id IN NUMBER,
656: x_return_status OUT NOCOPY VARCHAR2,
657: x_msg_count OUT NOCOPY NUMBER,

Line 666: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

662: l_msg_count NUMBER;
663: l_msg_data VARCHAR2(2000);
664: l_api_version CONSTANT NUMBER := 1.0;
665: l_debug_msg VARCHAR2(400);
666: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
667: l_commit VARCHAR2(1) := FND_API.G_FALSE;
668:
669: l_ship_header_id NUMBER;
670: l_ship_line_id NUMBER;

Line 667: l_commit VARCHAR2(1) := FND_API.G_FALSE;

663: l_msg_data VARCHAR2(2000);
664: l_api_version CONSTANT NUMBER := 1.0;
665: l_debug_msg VARCHAR2(400);
666: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
667: l_commit VARCHAR2(1) := FND_API.G_FALSE;
668:
669: l_ship_header_id NUMBER;
670: l_ship_line_id NUMBER;
671: l_from_association_tbl from_association_tbl;

Line 768: IF FND_API.to_Boolean(p_init_msg_list) THEN

764: -- Standard Start of API savepoint
765: SAVEPOINT Duplicate_ShipLines_GRP;
766:
767: -- Initialize message list if p_init_msg_list is set to TRUE.
768: IF FND_API.to_Boolean(p_init_msg_list) THEN
769: FND_MSG_PUB.initialize;
770: END IF;
771:
772: -- Standard call to check for call compatibility

Line 773: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

769: FND_MSG_PUB.initialize;
770: END IF;
771:
772: -- Standard call to check for call compatibility
773: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
774: p_caller_version_number => p_api_version,
775: p_api_name => l_api_name,
776: p_pkg_name => g_pkg_name ) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

773: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
774: p_caller_version_number => p_api_version,
775: p_api_name => l_api_name,
776: p_pkg_name => g_pkg_name ) THEN
777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
779:
780: -- Initialize API return status to success
781: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 781: x_return_status := FND_API.G_RET_STS_SUCCESS;

777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
778: END IF;
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',

Line 1026: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1022: x_msg_count => l_msg_count,
1023: x_msg_data => l_msg_data);
1024:
1025: -- If any errors happen abort the process.
1026: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;

Line 1027: RAISE FND_API.G_EXC_ERROR;

1023: x_msg_data => l_msg_data);
1024:
1025: -- If any errors happen abort the process.
1026: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031:

Line 1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1024:
1025: -- If any errors happen abort the process.
1026: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
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

Line 1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1025: -- If any errors happen abort the process.
1026: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1027: RAISE FND_API.G_EXC_ERROR;
1028: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
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,

Line 1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1047: x_msg_count => l_msg_count,
1048: x_msg_data => l_msg_data);
1049:
1050: -- If any errors happen abort the process.
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;

Line 1052: RAISE FND_API.G_EXC_ERROR;

1048: x_msg_data => l_msg_data);
1049:
1050: -- If any errors happen abort the process.
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: END IF;

Line 1053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1049:
1050: -- If any errors happen abort the process.
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: END IF;
1057: END LOOP;

Line 1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1050: -- If any errors happen abort the process.
1051: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: RAISE FND_API.G_EXC_ERROR;
1053: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: END IF;
1057: END LOOP;
1058: END LOOP;

Line 1061: IF FND_API.To_Boolean(p_commit) THEN

1057: END LOOP;
1058: END LOOP;
1059:
1060: -- Standard check of p_commit.
1061: IF FND_API.To_Boolean(p_commit) THEN
1062: COMMIT WORK;
1063: END IF;
1064: -- Standard call to get message count and if count is 1, get message info.
1065: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1065: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1061: IF FND_API.To_Boolean(p_commit) THEN
1062: COMMIT WORK;
1063: END IF;
1064: -- Standard call to get message count and if count is 1, get message info.
1065: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data) ;
1068:
1069: -- Standard End of Procedure/Function Logging

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

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,
1081: p_count => x_msg_count,
1082: p_data => x_msg_data);
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1080: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data);
1092: WHEN OTHERS THEN

Line 1089: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data);
1092: WHEN OTHERS THEN
1093: -- Standard Unexpected Error Logging

Line 1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
1099: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 1104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1100: ) THEN
1101: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1102: p_procedure_name => l_api_name);
1103: END IF;
1104: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107: END Duplicate_ShipLines;
1108:

Line 1116: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1112: --
1113: -- Pre-reqs : None
1114: -- Parameters :
1115: -- IN : p_api_version IN NUMBER
1116: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1117: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1118: -- p_current_ship_header_id IN NUMBER
1119: -- p_new_ship_header_id IN NUMBER
1120: --

Line 1117: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1113: -- Pre-reqs : None
1114: -- Parameters :
1115: -- IN : p_api_version IN NUMBER
1116: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1117: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1118: -- p_current_ship_header_id IN NUMBER
1119: -- p_new_ship_header_id IN NUMBER
1120: --
1121: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 1130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1126: -- Version : Current version 1.0
1127: --
1128: -- Notes :
1129: PROCEDURE Duplicate_LineGroups (p_api_version IN NUMBER,
1130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1132: p_current_ship_header_id IN NUMBER,
1133: p_new_ship_header_id IN NUMBER,
1134: x_return_status OUT NOCOPY VARCHAR2,

Line 1131: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1127: --
1128: -- Notes :
1129: PROCEDURE Duplicate_LineGroups (p_api_version IN NUMBER,
1130: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1131: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1132: p_current_ship_header_id IN NUMBER,
1133: p_new_ship_header_id IN NUMBER,
1134: x_return_status OUT NOCOPY VARCHAR2,
1135: x_msg_count OUT NOCOPY NUMBER,

Line 1143: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

1139: l_return_status VARCHAR2(1);
1140: l_msg_count NUMBER;
1141: l_msg_data VARCHAR2(2000);
1142: l_api_version CONSTANT NUMBER := 1.0;
1143: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1144: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1145: l_debug_msg VARCHAR2(400);
1146:
1147: l_ship_line_group_id NUMBER;

Line 1144: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1140: l_msg_count NUMBER;
1141: l_msg_data VARCHAR2(2000);
1142: l_api_version CONSTANT NUMBER := 1.0;
1143: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1144: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1145: l_debug_msg VARCHAR2(400);
1146:
1147: l_ship_line_group_id NUMBER;
1148: l_from_association_tbl from_association_tbl;

Line 1204: IF FND_API.to_Boolean(p_init_msg_list) THEN

1200: -- Standard Start of API savepoint
1201: SAVEPOINT Duplicate_LineGroups_GRP;
1202:
1203: -- Initialize message list if p_init_msg_list is set to TRUE.
1204: IF FND_API.to_Boolean(p_init_msg_list) THEN
1205: FND_MSG_PUB.initialize;
1206: END IF;
1207:
1208: -- Standard call to check for call compatibility

Line 1209: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

1205: FND_MSG_PUB.initialize;
1206: END IF;
1207:
1208: -- Standard call to check for call compatibility
1209: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1210: p_caller_version_number => p_api_version,
1211: p_api_name => l_api_name,
1212: p_pkg_name => g_pkg_name ) THEN
1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1209: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1210: p_caller_version_number => p_api_version,
1211: p_api_name => l_api_name,
1212: p_pkg_name => g_pkg_name ) THEN
1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1214: END IF;
1215:
1216: -- Initialize API return status to success
1217: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1217: x_return_status := FND_API.G_RET_STS_SUCCESS;

1213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1214: END IF;
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',

Line 1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1368: x_msg_count => l_msg_count,
1369: x_msg_data => l_msg_data);
1370:
1371: -- If any errors happen abort the process.
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;

Line 1373: RAISE FND_API.G_EXC_ERROR;

1369: x_msg_data => l_msg_data);
1370:
1371: -- If any errors happen abort the process.
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377: END IF;

Line 1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1370:
1371: -- If any errors happen abort the process.
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377: END IF;
1378: END LOOP;

Line 1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1371: -- If any errors happen abort the process.
1372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1373: RAISE FND_API.G_EXC_ERROR;
1374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1376: END IF;
1377: END IF;
1378: END LOOP;
1379:

Line 1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1390: x_msg_count => l_msg_count,
1391: x_msg_data => l_msg_data);
1392:
1393: -- If any errors happen abort the process.
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: RAISE FND_API.G_EXC_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;

Line 1395: RAISE FND_API.G_EXC_ERROR;

1391: x_msg_data => l_msg_data);
1392:
1393: -- If any errors happen abort the process.
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: RAISE FND_API.G_EXC_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END LOOP;

Line 1396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1392:
1393: -- If any errors happen abort the process.
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: RAISE FND_API.G_EXC_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END LOOP;
1400:

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1393: -- If any errors happen abort the process.
1394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1395: RAISE FND_API.G_EXC_ERROR;
1396: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END LOOP;
1400:
1401: -- Standard check of p_commit.

Line 1402: IF FND_API.To_Boolean(p_commit) THEN

1398: END IF;
1399: END LOOP;
1400:
1401: -- Standard check of p_commit.
1402: IF FND_API.To_Boolean(p_commit) THEN
1403: COMMIT WORK;
1404: END IF;
1405: -- Standard call to get message count and if count is 1, get message info.
1406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1402: IF FND_API.To_Boolean(p_commit) THEN
1403: COMMIT WORK;
1404: END IF;
1405: -- Standard call to get message count and if count is 1, get message info.
1406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1407: p_count => x_msg_count,
1408: p_data => x_msg_data) ;
1409:
1410: -- Standard End of Procedure/Function Logging

Line 1415: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

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,
1422: p_count => x_msg_count,
1423: p_data => x_msg_data);
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433: WHEN OTHERS THEN

Line 1430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433: WHEN OTHERS THEN
1434: -- Standard Unexpected Error Logging

Line 1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
1440: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 1445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1441: ) THEN
1442: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1443: p_procedure_name => l_api_name);
1444: END IF;
1445: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data);
1448: END Duplicate_LineGroups;
1449:

Line 1457: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1453: --
1454: -- Pre-reqs : None
1455: -- Parameters :
1456: -- IN : p_api_version IN NUMBER
1457: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1458: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1459: -- p_current_simulation_id IN NUMBER
1460: -- p_new_simulation_id IN NUMBER
1461: --

Line 1458: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1454: -- Pre-reqs : None
1455: -- Parameters :
1456: -- IN : p_api_version IN NUMBER
1457: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1458: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1459: -- p_current_simulation_id IN NUMBER
1460: -- p_new_simulation_id IN NUMBER
1461: --
1462: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 1471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1467: -- Version : Current version 1.0
1468: --
1469: -- Notes :
1470: PROCEDURE Duplicate_ShipHeaders (p_api_version IN NUMBER,
1471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1472: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1473: p_current_simulation_id IN NUMBER,
1474: p_new_simulation_id IN NUMBER,
1475: x_return_status OUT NOCOPY VARCHAR2,

Line 1472: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1468: --
1469: -- Notes :
1470: PROCEDURE Duplicate_ShipHeaders (p_api_version IN NUMBER,
1471: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1472: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1473: p_current_simulation_id IN NUMBER,
1474: p_new_simulation_id IN NUMBER,
1475: x_return_status OUT NOCOPY VARCHAR2,
1476: x_msg_count OUT NOCOPY NUMBER,

Line 1485: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

1481: l_msg_count NUMBER;
1482: l_msg_data VARCHAR2(2000);
1483: l_api_version CONSTANT NUMBER := 1.0;
1484: l_debug_msg VARCHAR2(400);
1485: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1486: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1487:
1488: l_ship_num VARCHAR2(25);
1489: l_next_ship_num VARCHAR2(25);

Line 1486: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1482: l_msg_data VARCHAR2(2000);
1483: l_api_version CONSTANT NUMBER := 1.0;
1484: l_debug_msg VARCHAR2(400);
1485: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1486: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1487:
1488: l_ship_num VARCHAR2(25);
1489: l_next_ship_num VARCHAR2(25);
1490: l_ship_header_id NUMBER;

Line 1560: IF FND_API.to_Boolean(p_init_msg_list) THEN

1556: -- Standard Start of API savepoint
1557: SAVEPOINT Duplicate_ShipHeaders_GRP;
1558:
1559: -- Initialize message list if p_init_msg_list is set to TRUE.
1560: IF FND_API.to_Boolean(p_init_msg_list) THEN
1561: FND_MSG_PUB.initialize;
1562: END IF;
1563:
1564: -- Standard call to check for call compatibility

Line 1565: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

1561: FND_MSG_PUB.initialize;
1562: END IF;
1563:
1564: -- Standard call to check for call compatibility
1565: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1566: p_caller_version_number => p_api_version,
1567: p_api_name => l_api_name,
1568: p_pkg_name => g_pkg_name ) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1566: p_caller_version_number => p_api_version,
1567: p_api_name => l_api_name,
1568: p_pkg_name => g_pkg_name ) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: END IF;
1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: END IF;
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',

Line 1828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1824: x_msg_count => l_msg_count,
1825: x_msg_data => l_msg_data);
1826:
1827: -- If any errors happen abort the process.
1828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: x_msg_data => l_msg_data);
1826:
1827: -- If any errors happen abort the process.
1828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833: END IF;

Line 1830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1826:
1827: -- If any errors happen abort the process.
1828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833: END IF;
1834: END LOOP;

Line 1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1827: -- If any errors happen abort the process.
1828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833: END IF;
1834: END LOOP;
1835:

Line 1850: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1846: x_msg_count => l_msg_count,
1847: x_msg_data => l_msg_data);
1848:
1849: -- If any errors happen abort the process.
1850: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1851: RAISE FND_API.G_EXC_ERROR;
1852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END IF;

Line 1851: RAISE FND_API.G_EXC_ERROR;

1847: x_msg_data => l_msg_data);
1848:
1849: -- If any errors happen abort the process.
1850: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1851: RAISE FND_API.G_EXC_ERROR;
1852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END IF;
1855: END LOOP;

Line 1852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1848:
1849: -- If any errors happen abort the process.
1850: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1851: RAISE FND_API.G_EXC_ERROR;
1852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END IF;
1855: END LOOP;
1856:

Line 1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1849: -- If any errors happen abort the process.
1850: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1851: RAISE FND_API.G_EXC_ERROR;
1852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1854: END IF;
1855: END LOOP;
1856:
1857: -- Standard check of p_commit.

Line 1858: IF FND_API.To_Boolean(p_commit) THEN

1854: END IF;
1855: END LOOP;
1856:
1857: -- Standard check of p_commit.
1858: IF FND_API.To_Boolean(p_commit) THEN
1859: COMMIT WORK;
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 1862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1858: IF FND_API.To_Boolean(p_commit) THEN
1859: COMMIT WORK;
1860: END IF;
1861: -- Standard call to get message count and if count is 1, get message info.
1862: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1863: p_count => x_msg_count,
1864: p_data => x_msg_data) ;
1865:
1866: -- Standard End of Procedure/Function Logging

Line 1871: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR;

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,
1878: p_count => x_msg_count,
1879: p_data => x_msg_data);
1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 1880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1876: x_return_status := FND_API.G_RET_STS_ERROR;
1877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 1885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889: WHEN OTHERS THEN

Line 1886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data);
1889: WHEN OTHERS THEN
1890: -- Standard Unexpected Error Logging

Line 1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
1896: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

1897: ) THEN
1898: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
1899: p_procedure_name => l_api_name);
1900: END IF;
1901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1902: p_count => x_msg_count,
1903: p_data => x_msg_data);
1904: END Duplicate_ShipHeaders;
1905:

Line 1913: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1909: --
1910: -- Pre-reqs : None
1911: -- Parameters :
1912: -- IN : p_api_version IN NUMBER
1913: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1914: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1915: -- p_simulation_id IN NUMBER
1916: --
1917: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 1914: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

1910: -- Pre-reqs : None
1911: -- Parameters :
1912: -- IN : p_api_version IN NUMBER
1913: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1914: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
1915: -- p_simulation_id IN NUMBER
1916: --
1917: -- OUT : x_return_status OUT NOCOPY VARCHAR2
1918: -- x_msg_count OUT NOCOPY NUMBER

Line 1926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1922: -- Version : Current version 1.0
1923: --
1924: -- Notes :
1925: PROCEDURE Copy_Simulation (p_api_version IN NUMBER,
1926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1927: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1928: p_simulation_id IN NUMBER,
1929: x_return_status OUT NOCOPY VARCHAR2,
1930: x_msg_count OUT NOCOPY NUMBER,

Line 1927: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1923: --
1924: -- Notes :
1925: PROCEDURE Copy_Simulation (p_api_version IN NUMBER,
1926: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1927: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1928: p_simulation_id IN NUMBER,
1929: x_return_status OUT NOCOPY VARCHAR2,
1930: x_msg_count OUT NOCOPY NUMBER,
1931: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1939: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

1935: l_msg_count NUMBER;
1936: l_msg_data VARCHAR2(2000);
1937: l_api_version CONSTANT NUMBER := 1.0;
1938: l_debug_msg VARCHAR2(400);
1939: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1940: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1941:
1942: l_version_num NUMBER;
1943: l_simulation_id NUMBER;

Line 1940: l_commit VARCHAR2(1) := FND_API.G_FALSE;

1936: l_msg_data VARCHAR2(2000);
1937: l_api_version CONSTANT NUMBER := 1.0;
1938: l_debug_msg VARCHAR2(400);
1939: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;
1940: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1941:
1942: l_version_num NUMBER;
1943: l_simulation_id NUMBER;
1944: l_simulation_rec simulation_rec;

Line 1960: IF FND_API.to_Boolean(p_init_msg_list) THEN

1956: -- Standard Start of API savepoint
1957: SAVEPOINT Copy_Simulation_GRP;
1958:
1959: -- Initialize message list if p_init_msg_list is set to TRUE.
1960: IF FND_API.to_Boolean(p_init_msg_list) THEN
1961: FND_MSG_PUB.initialize;
1962: END IF;
1963:
1964: -- Standard call to check for call compatibility

Line 1965: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

1961: FND_MSG_PUB.initialize;
1962: END IF;
1963:
1964: -- Standard call to check for call compatibility
1965: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1966: p_caller_version_number => p_api_version,
1967: p_api_name => l_api_name,
1968: p_pkg_name => g_pkg_name ) THEN
1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1965: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
1966: p_caller_version_number => p_api_version,
1967: p_api_name => l_api_name,
1968: p_pkg_name => g_pkg_name ) THEN
1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1970: END IF;
1971:
1972: -- Initialize API return status to success
1973: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1973: x_return_status := FND_API.G_RET_STS_SUCCESS;

1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1970: END IF;
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',

Line 2150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2146: x_msg_count => l_msg_count,
2147: x_msg_data => l_msg_data);
2148:
2149: -- If any errors happen abort the process.
2150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2151: RAISE FND_API.G_EXC_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;

Line 2151: RAISE FND_API.G_EXC_ERROR;

2147: x_msg_data => l_msg_data);
2148:
2149: -- If any errors happen abort the process.
2150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2151: RAISE FND_API.G_EXC_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155:

Line 2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2148:
2149: -- If any errors happen abort the process.
2150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2151: RAISE FND_API.G_EXC_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155:
2156: -- Standard check of p_commit.

Line 2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2149: -- If any errors happen abort the process.
2150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2151: RAISE FND_API.G_EXC_ERROR;
2152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155:
2156: -- Standard check of p_commit.
2157: IF FND_API.To_Boolean(p_commit) THEN

Line 2157: IF FND_API.To_Boolean(p_commit) THEN

2153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2154: END IF;
2155:
2156: -- Standard check of p_commit.
2157: IF FND_API.To_Boolean(p_commit) THEN
2158: COMMIT WORK;
2159: END IF;
2160: -- Any other problems in acquiring the lock,
2161: -- raise error and return

Line 2165: RAISE FND_API.G_EXC_ERROR;

2161: -- raise error and return
2162: ELSE
2163: FND_MESSAGE.set_name('INL', 'INL_SIMUL_COPY_LOCKED');
2164: FND_MSG_PUB.Add;
2165: RAISE FND_API.G_EXC_ERROR;
2166: END IF;
2167: -- Release the lock
2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2169: l_lock_handle := NULL;

Line 2172: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2168: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2169: l_lock_handle := NULL;
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data) ;
2175:
2176: -- Standard End of Procedure/Function Logging

Line 2181: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 2186: x_return_status := FND_API.G_RET_STS_ERROR;

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,
2188: p_count => x_msg_count,
2189: p_data => x_msg_data);
2190: IF l_lock_handle IS NOT NULL THEN

Line 2187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
2188: p_count => x_msg_count,
2189: p_data => x_msg_data);
2190: IF l_lock_handle IS NOT NULL THEN
2191: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2189: p_data => x_msg_data);
2190: IF l_lock_handle IS NOT NULL THEN
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;

Line 2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: IF l_lock_handle IS NOT NULL THEN

Line 2199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data);
2202: IF l_lock_handle IS NOT NULL THEN
2203: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
2212: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2213: ) THEN
2214: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2215: p_procedure_name => l_api_name);
2216: END IF;
2217: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2218: p_count => x_msg_count,
2219: p_data => x_msg_data);
2220: IF l_lock_handle IS NOT NULL THEN
2221: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2232: -- p_init_msg_listIN VARCHAR2 := FND_API.G_FALSE

2228: --
2229: -- Pre-reqs : None
2230: -- Parameters :
2231: -- IN : p_api_version IN NUMBER,
2232: -- p_init_msg_listIN VARCHAR2 := FND_API.G_FALSE
2233: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
2234: -- p_simulation_rec IN OUT NOCOPY simulation_table
2235: --
2236: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 2233: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

2229: -- Pre-reqs : None
2230: -- Parameters :
2231: -- IN : p_api_version IN NUMBER,
2232: -- p_init_msg_listIN VARCHAR2 := FND_API.G_FALSE
2233: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
2234: -- p_simulation_rec IN OUT NOCOPY simulation_table
2235: --
2236: -- OUT x_return_status OUT NOCOPY VARCHAR2
2237: -- x_msg_count OUT NOCOPY NUMBER,

Line 2244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2240: -- Version : Current version 1.0
2241: --
2242: -- Notes :
2243: PROCEDURE Create_Simulation (p_api_version IN NUMBER,
2244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2246: p_simulation_rec IN OUT NOCOPY simulation_rec,
2247: x_return_status OUT NOCOPY VARCHAR2,
2248: x_msg_count OUT NOCOPY NUMBER,

Line 2245: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2241: --
2242: -- Notes :
2243: PROCEDURE Create_Simulation (p_api_version IN NUMBER,
2244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2246: p_simulation_rec IN OUT NOCOPY simulation_rec,
2247: x_return_status OUT NOCOPY VARCHAR2,
2248: x_msg_count OUT NOCOPY NUMBER,
2249: x_msg_data OUT NOCOPY VARCHAR2)IS

Line 2293: IF FND_API.to_Boolean(p_init_msg_list) THEN

2289: -- Standard Start of API savepoint
2290: SAVEPOINT Create_Simulation_GRP;
2291:
2292: -- Initialize message list if p_init_msg_list is set to TRUE.
2293: IF FND_API.to_Boolean(p_init_msg_list) THEN
2294: FND_MSG_PUB.initialize;
2295: END IF;
2296:
2297: -- Standard call to check for call compatibility

Line 2298: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

2294: FND_MSG_PUB.initialize;
2295: END IF;
2296:
2297: -- Standard call to check for call compatibility
2298: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
2299: p_caller_version_number => p_api_version,
2300: p_api_name => l_api_name,
2301: p_pkg_name => g_pkg_name ) THEN
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2298: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
2299: p_caller_version_number => p_api_version,
2300: p_api_name => l_api_name,
2301: p_pkg_name => g_pkg_name ) THEN
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303: END IF;
2304:
2305: -- Initialize API return status to success
2306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2306: x_return_status := FND_API.G_RET_STS_SUCCESS;

2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303: END IF;
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,

Line 2372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2368: x_flexfield_ln_rec => l_flexfield_ln_rec,
2369: x_return_status => l_return_status);
2370:
2371: -- If any errors happen abort API.
2372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;

Line 2373: RAISE FND_API.G_EXC_ERROR;

2369: x_return_status => l_return_status);
2370:
2371: -- If any errors happen abort API.
2372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377:

Line 2374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2370:
2371: -- If any errors happen abort API.
2372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377:
2378: l_attribute_category := l_flexfield_ln_rec.attribute_category;

Line 2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2371: -- If any errors happen abort API.
2372: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2373: RAISE FND_API.G_EXC_ERROR;
2374: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377:
2378: l_attribute_category := l_flexfield_ln_rec.attribute_category;
2379: l_attribute1 := l_flexfield_ln_rec.attribute1;

Line 2465: IF FND_API.To_Boolean(p_commit) THEN

2461: l_attribute14, -- 31
2462: l_attribute15); -- 32
2463:
2464: -- Standard check of p_commit.
2465: IF FND_API.To_Boolean(p_commit) THEN
2466: COMMIT WORK;
2467: END IF;
2468: -- Any other problems in acquiring the lock,
2469: -- raise error and return

Line 2473: RAISE FND_API.G_EXC_ERROR;

2469: -- raise error and return
2470: ELSE
2471: FND_MESSAGE.set_name('INL', 'INL_SIMUL_CREATE_LOCKED');
2472: FND_MSG_PUB.Add;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475: -- Release the lock
2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2477: l_lock_handle := NULL;

Line 2480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2476: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
2477: l_lock_handle := NULL;
2478:
2479: -- Standard call to get message count and if count is 1, get message info.
2480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2481: p_count => x_msg_count,
2482: p_data => x_msg_data) ;
2483:
2484: -- Standard End of Procedure/Function Logging

Line 2489: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 2494: x_return_status := FND_API.G_RET_STS_ERROR;

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,
2496: p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: IF l_lock_handle IS NOT NULL THEN

Line 2495: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
2496: p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: IF l_lock_handle IS NOT NULL THEN
2499: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2497: p_data => x_msg_data);
2498: IF l_lock_handle IS NOT NULL THEN
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;

Line 2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
2508: p_count => x_msg_count,
2509: p_data => x_msg_data);
2510: IF l_lock_handle IS NOT NULL THEN

Line 2507: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
2508: p_count => x_msg_count,
2509: p_data => x_msg_data);
2510: IF l_lock_handle IS NOT NULL THEN
2511: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
2520: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2521: ) THEN
2522: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2523: p_procedure_name => l_api_name);
2524: END IF;
2525: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2526: p_count => x_msg_count,
2527: p_data => x_msg_data);
2528: IF l_lock_handle IS NOT NULL THEN
2529: l_lock_status := DBMS_LOCK.Release(l_lock_handle);

Line 2540: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2536: --
2537: -- Pre-reqs : None
2538: -- Parameters :
2539: -- IN : p_api_version IN NUMBER
2540: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2541: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
2542: -- p_org_id IN NUMBER
2543: -- p_simulation_table simulation_id_tbl
2544: --

Line 2541: -- p_commit IN VARCHAR2 := FND_API.G_FALSE

2537: -- Pre-reqs : None
2538: -- Parameters :
2539: -- IN : p_api_version IN NUMBER
2540: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2541: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
2542: -- p_org_id IN NUMBER
2543: -- p_simulation_table simulation_id_tbl
2544: --
2545: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 2554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2550: -- Version : Current version 1.0
2551: --
2552: -- Notes :
2553: PROCEDURE Purge_Simulations(p_api_version IN NUMBER,
2554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2556: p_org_id IN NUMBER,
2557: p_simulation_table IN simulation_id_tbl,
2558: x_return_status OUT NOCOPY VARCHAR2,

Line 2555: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2551: --
2552: -- Notes :
2553: PROCEDURE Purge_Simulations(p_api_version IN NUMBER,
2554: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2555: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2556: p_org_id IN NUMBER,
2557: p_simulation_table IN simulation_id_tbl,
2558: x_return_status OUT NOCOPY VARCHAR2,
2559: x_msg_count OUT NOCOPY NUMBER,

Line 2597: IF FND_API.to_Boolean(p_init_msg_list) THEN

2593: -- Standard Start of API savepoint
2594: SAVEPOINT Purge_SimulShipments_GRP;
2595:
2596: -- Initialize message list if p_init_msg_list is set to TRUE.
2597: IF FND_API.to_Boolean(p_init_msg_list) THEN
2598: FND_MSG_PUB.initialize;
2599: END IF;
2600:
2601: -- Standard call to check for call compatibility

Line 2602: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

2598: FND_MSG_PUB.initialize;
2599: END IF;
2600:
2601: -- Standard call to check for call compatibility
2602: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
2603: p_caller_version_number => p_api_version,
2604: p_api_name => l_api_name,
2605: p_pkg_name => g_pkg_name ) THEN
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2602: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
2603: p_caller_version_number => p_api_version,
2604: p_api_name => l_api_name,
2605: p_pkg_name => g_pkg_name ) THEN
2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: -- Initialize API return status to success
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2610: x_return_status := FND_API.G_RET_STS_SUCCESS;

2606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: -- Initialize API return status to success
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611:
2612: OPEN c_simul;
2613: FETCH c_simul BULK COLLECT INTO c_simul_tbl;
2614: CLOSE c_simul;

Line 2662: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2658: INL_INTERFACE_PVT.Delete_Ship(p_ship_header_id => c_ship_hdr_tbl(j).ship_header_id,
2659: x_return_status => l_return_status);
2660:
2661: -- If any errors happen abort the process.
2662: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;

Line 2663: RAISE FND_API.G_EXC_ERROR;

2659: x_return_status => l_return_status);
2660:
2661: -- If any errors happen abort the process.
2662: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;
2667: END LOOP;

Line 2664: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2660:
2661: -- If any errors happen abort the process.
2662: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;
2667: END LOOP;
2668:

Line 2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2661: -- If any errors happen abort the process.
2662: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2666: END IF;
2667: END LOOP;
2668:
2669: DELETE FROM inl_simulations s

Line 2675: IF FND_API.To_Boolean(p_commit) THEN

2671: END IF;
2672: END LOOP;
2673:
2674: -- Standard check of p_commit.
2675: IF FND_API.To_Boolean(p_commit) THEN
2676: COMMIT WORK;
2677: END IF;
2678: -- Standard call to get message count and if count is 1, get message info.
2679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2675: IF FND_API.To_Boolean(p_commit) THEN
2676: COMMIT WORK;
2677: END IF;
2678: -- Standard call to get message count and if count is 1, get message info.
2679: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2680: p_count => x_msg_count,
2681: p_data => x_msg_data) ;
2682:
2683: -- Standard End of Procedure/Function Logging

Line 2688: WHEN FND_API.G_EXC_ERROR THEN

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
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;

Line 2693: x_return_status := FND_API.G_RET_STS_ERROR;

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,
2695: p_count => x_msg_count,
2696: p_data => x_msg_data);
2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
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

Line 2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
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;

Line 2702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
2704: p_count => x_msg_count,
2705: p_data => x_msg_data);
2706: WHEN OTHERS THEN

Line 2703: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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,
2704: p_count => x_msg_count,
2705: p_data => x_msg_data);
2706: WHEN OTHERS THEN
2707: -- Standard Unexpected Error Logging

Line 2711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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(
2713: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

Line 2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2714: ) THEN
2715: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
2716: p_procedure_name => l_api_name);
2717: END IF;
2718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2719: p_count => x_msg_count,
2720: p_data => x_msg_data);
2721: END Purge_Simulations;
2722: