81: l_landed_cost_lst l_landed_cost_tp;
82:
83: BEGIN
84:
85: -- Standard Beginning of Procedure/Function Logging
86: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
87: p_procedure_name => l_proc_name);
88: -- Standard Start of API savepoint
89: SAVEPOINT Get_LandedCost_PVT2;
84:
85: -- Standard Beginning of Procedure/Function Logging
86: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
87: p_procedure_name => l_proc_name);
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
221: (p_module_name => g_module_name,
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:
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.
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);
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
237: INL_LOGGING_PVT.Log_EndProc (
238: p_module_name => g_module_name,
239: p_procedure_name => l_proc_name);
240: EXCEPTION
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);
246: -- Standard Expected Error Logging
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;
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);
261: -- Standard Unexpected Error Logging
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;
272: INL_LOGGING_PVT.Log_Statement
273: (p_module_name => g_module_name,
274: p_procedure_name => l_proc_name,
275: p_debug_info => 'OTHERS:'||SQLERRM);
276: -- Standard Unexpected Error Logging
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;
390: l_landed_cost_lst l_landed_cost_tp;
391:
392: BEGIN
393:
394: -- Standard Beginning of Procedure/Function Logging
395: INL_LOGGING_PVT.Log_BeginProc (
396: p_module_name => g_module_name,
397: p_procedure_name => l_proc_name
398: );
395: INL_LOGGING_PVT.Log_BeginProc (
396: p_module_name => g_module_name,
397: p_procedure_name => l_proc_name
398: );
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
513: p_procedure_name => g_module_name,
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:
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.
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);
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
529: INL_LOGGING_PVT.Log_EndProc (
530: p_module_name => g_module_name,
531: p_procedure_name => l_proc_name);
532: EXCEPTION
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);
538: ROLLBACK TO Get_LandedCost_PVT3;
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);
549: ROLLBACK TO Get_LandedCost_PVT3;
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
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;