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_LANDEDCOST_PUB dependencies on FND_API

Line 10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

6: -- Function :
7: -- Pre-reqs : None
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_ship_header_id IN NUMBER Required
13: --
14: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

7: -- Pre-reqs : None
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_ship_header_id IN NUMBER Required
13: --
14: -- OUT : x_return_status OUT NOCOPY VARCHAR2
15: -- x_msg_count OUT NOCOPY NUMBER

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

23:
24: --Bug#14158274 Procedure has been redesigned
25: PROCEDURE Get_LandedCost(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_ship_header_id IN NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,

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

24: --Bug#14158274 Procedure has been redesigned
25: PROCEDURE Get_LandedCost(
26: p_api_version IN NUMBER,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_ship_header_id IN NUMBER,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,

Line 92: IF FND_API.to_Boolean( p_init_msg_list ) THEN

88: -- Standard Start of API savepoint
89: SAVEPOINT Get_LandedCost_PVT2;
90:
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Check for call compatibility.

Line 97: IF NOT FND_API.Compatible_API_Call (

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call (
98: l_api_version,
99: p_api_version,
100: l_proc_name,
101: g_pkg_name)

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: p_api_version,
100: l_proc_name,
101: g_pkg_name)
102: THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize API return status to success
107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- Initialize API return status to success
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: BEGIN
110: l_debug_info := 'Get landed cost info for ship_header_id: ' || p_ship_header_id;
111: INL_LOGGING_PVT.Log_Statement (

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: INL_LOGGING_PVT.Log_Statement (
211: p_module_name => g_module_name,
212: p_procedure_name => l_proc_name,
213: p_debug_info => 'unexpected component_type: '||l_landed_cost_lst(j).component_type);
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: END LOOP;
217: END IF;
218: END;

Line 226: IF FND_API.To_Boolean( p_commit ) THEN

222: p_procedure_name => l_proc_name,
223: p_debug_info => l_debug_info);
224:
225: -- Standard check of p_commit.
226: IF FND_API.To_Boolean( p_commit ) THEN
227: COMMIT WORK;
228: END IF;
229:
230: -- Standard call to get message count and if count is 1, get message info.

Line 232: p_encoded => FND_API.g_false,

228: END IF;
229:
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,
234: p_data => x_msg_data);
235:
236: -- Standard End of Procedure/Function Logging

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: INL_LOGGING_PVT.Log_EndProc (
238: p_module_name => g_module_name,
239: p_procedure_name => l_proc_name);
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: INL_LOGGING_PVT.Log_Statement
243: (p_module_name => g_module_name,
244: p_procedure_name => l_proc_name,
245: p_debug_info => 'G_EXC_ERROR:'||SQLERRM);

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: INL_LOGGING_PVT.Log_ExpecError (
248: p_module_name => g_module_name,
249: p_procedure_name => l_proc_name);
250: ROLLBACK TO Get_LandedCost_PVT2;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);

Line 253: p_encoded => FND_API.g_false,

249: p_procedure_name => l_proc_name);
250: ROLLBACK TO Get_LandedCost_PVT2;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: INL_LOGGING_PVT.Log_Statement

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: INL_LOGGING_PVT.Log_Statement
258: (p_module_name => g_module_name,
259: p_procedure_name => l_proc_name,
260: p_debug_info => 'G_EXC_UNEXPECTED_ERROR:'||SQLERRM);

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

262: INL_LOGGING_PVT.Log_UnexpecError (
263: p_module_name => g_module_name,
264: p_procedure_name => l_proc_name);
265: ROLLBACK TO Get_LandedCost_PVT2;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: FND_MSG_PUB.Count_And_Get(
268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data);

Line 268: p_encoded => FND_API.g_false,

264: p_procedure_name => l_proc_name);
265: ROLLBACK TO Get_LandedCost_PVT2;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: FND_MSG_PUB.Count_And_Get(
268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271: WHEN OTHERS THEN
272: INL_LOGGING_PVT.Log_Statement

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

277: INL_LOGGING_PVT.Log_UnexpecError (
278: p_module_name => g_module_name,
279: p_procedure_name => l_proc_name);
280: ROLLBACK TO Get_LandedCost_PVT2;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
283: THEN
284: FND_MSG_PUB.Add_Exc_Msg(
285: g_pkg_name,

Line 289: p_encoded => FND_API.g_false,

285: g_pkg_name,
286: l_proc_name);
287: END IF;
288: FND_MSG_PUB.Count_And_Get(
289: p_encoded => FND_API.g_false,
290: p_count => x_msg_count,
291: p_data => x_msg_data);
292: END Get_LandedCost;
293:

Line 300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

296: -- Function :
297: -- Pre-reqs : None
298: -- Parameters :
299: -- IN : p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
302: -- p_ship_line_id IN NUMBER Required
303: --
304: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

297: -- Pre-reqs : None
298: -- Parameters :
299: -- IN : p_api_version IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
302: -- p_ship_line_id IN NUMBER Required
303: --
304: -- OUT : x_return_status OUT NOCOPY VARCHAR2
305: -- x_msg_count OUT NOCOPY NUMBER

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

323: -- Notes :
324: --Bug#14158274 Procedure has been redesigned
325: PROCEDURE Get_LandedCost(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_ship_line_id IN NUMBER,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,

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

324: --Bug#14158274 Procedure has been redesigned
325: PROCEDURE Get_LandedCost(
326: p_api_version IN NUMBER,
327: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
328: p_commit IN VARCHAR2 := FND_API.G_FALSE,
329: p_ship_line_id IN NUMBER,
330: x_return_status OUT NOCOPY VARCHAR2,
331: x_msg_count OUT NOCOPY NUMBER,
332: x_msg_data OUT NOCOPY VARCHAR2,

Line 403: IF FND_API.to_Boolean( p_init_msg_list ) THEN

399: -- Standard Start of API savepoint
400: SAVEPOINT Get_LandedCost_PVT3;
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: -- Check for call compatibility.

Line 408: IF NOT FND_API.Compatible_API_Call (

404: FND_MSG_PUB.initialize;
405: END IF;
406:
407: -- Check for call compatibility.
408: IF NOT FND_API.Compatible_API_Call (
409: l_api_version,
410: p_api_version,
411: l_proc_name,
412: g_pkg_name)

Line 414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

410: p_api_version,
411: l_proc_name,
412: g_pkg_name)
413: THEN
414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:
417: -- Initialize API return status to success
418: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416:
417: -- Initialize API return status to success
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: BEGIN
421: l_debug_info := 'Get landed cost info for ship_line_id: ' || p_ship_line_id;
422: INL_LOGGING_PVT.Log_Statement (

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: INL_LOGGING_PVT.Log_Statement (
497: p_module_name => g_module_name,
498: p_procedure_name => l_proc_name,
499: p_debug_info => 'unexpected component_type: '||l_landed_cost_lst(j).component_type);
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501: END IF;
502: END LOOP;
503: END IF;
504: END;

Line 518: IF FND_API.To_Boolean( p_commit ) THEN

514: p_var_name => 'x_adjustment_num',
515: p_var_value => x_adjustment_num);
516:
517: -- Standard check of p_commit.
518: IF FND_API.To_Boolean( p_commit ) THEN
519: COMMIT WORK;
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.

Line 524: p_encoded => FND_API.g_false,

520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get(
524: p_encoded => FND_API.g_false,
525: p_count => x_msg_count,
526: p_data => x_msg_data);
527:
528: -- Standard End of Procedure/Function Logging

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: INL_LOGGING_PVT.Log_EndProc (
530: p_module_name => g_module_name,
531: p_procedure_name => l_proc_name);
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: -- Standard Expected Error Logging
535: INL_LOGGING_PVT.Log_ExpecError (
536: p_module_name => g_module_name,
537: p_procedure_name => l_proc_name);

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: INL_LOGGING_PVT.Log_ExpecError (
536: p_module_name => g_module_name,
537: p_procedure_name => l_proc_name);
538: ROLLBACK TO Get_LandedCost_PVT3;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.Count_And_Get(
541: p_encoded => FND_API.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data);

Line 541: p_encoded => FND_API.g_false,

537: p_procedure_name => l_proc_name);
538: ROLLBACK TO Get_LandedCost_PVT3;
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: FND_MSG_PUB.Count_And_Get(
541: p_encoded => FND_API.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data);
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: -- Standard Unexpected Error Logging

Line 544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

540: FND_MSG_PUB.Count_And_Get(
541: p_encoded => FND_API.g_false,
542: p_count => x_msg_count,
543: p_data => x_msg_data);
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: -- Standard Unexpected Error Logging
546: INL_LOGGING_PVT.Log_UnexpecError (
547: p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);

Line 550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

546: INL_LOGGING_PVT.Log_UnexpecError (
547: p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Get_LandedCost_PVT3;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get(
552: p_encoded => FND_API.g_false,
553: p_count => x_msg_count,
554: p_data => x_msg_data);

Line 552: p_encoded => FND_API.g_false,

548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Get_LandedCost_PVT3;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: FND_MSG_PUB.Count_And_Get(
552: p_encoded => FND_API.g_false,
553: p_count => x_msg_count,
554: p_data => x_msg_data);
555: WHEN OTHERS THEN
556: -- Standard Unexpected Error Logging

Line 561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

557: INL_LOGGING_PVT.Log_UnexpecError (
558: p_module_name => g_module_name,
559: p_procedure_name => l_proc_name);
560: ROLLBACK TO Get_LandedCost_PVT3;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563: THEN
564: FND_MSG_PUB.Add_Exc_Msg(
565: g_pkg_name,

Line 569: p_encoded => FND_API.g_false,

565: g_pkg_name,
566: l_proc_name);
567: END IF;
568: FND_MSG_PUB.Count_And_Get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data);
572: END Get_LandedCost;
573: