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.CST_LCMADJUSTMENTS_PVT dependencies on FND_API

Line 146: l_return_status := FND_API.G_RET_STS_SUCCESS;

142: -- Initialize message list
143: FND_MSG_PUB.initialize;
144:
145: /* Initialize API return status to success */
146: l_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: l_stmt_num := 10;
149:
150: /* Call the landed cost interface records validation proceduere */

Line 153: p_init_msg_list => FND_API.G_FALSE,

149:
150: /* Call the landed cost interface records validation proceduere */
151: Validate_Lc_Interface
152: (p_api_version => l_api_version,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: p_group_id => p_group_id,
156: p_organization_id => p_organization_id,
157: x_no_of_errored => l_no_of_errored,

Line 154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

150: /* Call the landed cost interface records validation proceduere */
151: Validate_Lc_Interface
152: (p_api_version => l_api_version,
153: p_init_msg_list => FND_API.G_FALSE,
154: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
155: p_group_id => p_group_id,
156: p_organization_id => p_organization_id,
157: x_no_of_errored => l_no_of_errored,
158: x_return_status => l_return_status);

Line 160: IF l_return_status <> FND_API.g_ret_sts_success THEN

156: p_organization_id => p_organization_id,
157: x_no_of_errored => l_no_of_errored,
158: x_return_status => l_return_status);
159:
160: IF l_return_status <> FND_API.g_ret_sts_success THEN
161: IF l_exceptionLog THEN
162: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
163: fnd_message.set_token('CALLED','Validate_Lc_Interface');
164:

Line 167: RAISE FND_API.g_exc_unexpected_error;

163: fnd_message.set_token('CALLED','Validate_Lc_Interface');
164:
165: END IF;
166:
167: RAISE FND_API.g_exc_unexpected_error;
168: END IF;
169:
170: l_stmt_num := 15;
171:

Line 190: p_init_msg_list => FND_API.G_FALSE,

186:
187: /* Populate common information related to the lcm adjustment transaction */
188: Populate_Lcm_Adjustment_Info
189: (p_api_version => l_api_version,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
192: p_group_id => p_group_id,
193: p_organization_id => p_organization_id,
194: x_ledger_id => l_ledger_id,

Line 191: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

187: /* Populate common information related to the lcm adjustment transaction */
188: Populate_Lcm_Adjustment_Info
189: (p_api_version => l_api_version,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
192: p_group_id => p_group_id,
193: p_organization_id => p_organization_id,
194: x_ledger_id => l_ledger_id,
195: x_primary_cost_method => l_primary_cost_method,

Line 199: IF l_return_status <> FND_API.g_ret_sts_success THEN

195: x_primary_cost_method => l_primary_cost_method,
196: x_wms_enabled_flag => l_wms_enabled_flag,
197: x_return_status => l_return_status);
198:
199: IF l_return_status <> FND_API.g_ret_sts_success THEN
200: IF l_exceptionLog THEN
201: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
202: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
203:

Line 205: RAISE FND_API.g_exc_unexpected_error;

201: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
202: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
203:
204: END IF;
205: RAISE FND_API.g_exc_unexpected_error;
206: END IF;
207:
208: l_stmt_num := 40;
209:

Line 213: p_init_msg_list => FND_API.G_FALSE,

209:
210: /* Populate the adjustment data into the global temporary tables */
211: Populate_Temp_Adjustment_Data
212: (p_api_version => l_api_version,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
215: p_primary_cost_method => l_primary_cost_method,
216: p_wms_enabled_flag => l_wms_enabled_flag,
217: x_return_status => l_return_status);

Line 214: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

210: /* Populate the adjustment data into the global temporary tables */
211: Populate_Temp_Adjustment_Data
212: (p_api_version => l_api_version,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
215: p_primary_cost_method => l_primary_cost_method,
216: p_wms_enabled_flag => l_wms_enabled_flag,
217: x_return_status => l_return_status);
218:

Line 219: IF l_return_status <> FND_API.g_ret_sts_success THEN

215: p_primary_cost_method => l_primary_cost_method,
216: p_wms_enabled_flag => l_wms_enabled_flag,
217: x_return_status => l_return_status);
218:
219: IF l_return_status <> FND_API.g_ret_sts_success THEN
220: IF l_exceptionLog THEN
221: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
222: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
223:

Line 226: RAISE FND_API.g_exc_unexpected_error;

222: fnd_message.set_token('CALLED','Populate_Temp_Adjustment_Data');
223:
224: END IF;
225:
226: RAISE FND_API.g_exc_unexpected_error;
227: END IF;
228:
229: l_stmt_num := 50;
230:

Line 234: p_init_msg_list => FND_API.G_FALSE,

230:
231: /* Insert the adjustment data from the GTTs into the actual tables */
232: Insert_Adjustment_Data
233: (p_api_version => l_api_version,
234: p_init_msg_list => FND_API.G_FALSE,
235: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
236: p_group_id => p_group_id,
237: p_organization_id => p_organization_id,
238: p_ledger_id => l_ledger_id,

Line 235: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

231: /* Insert the adjustment data from the GTTs into the actual tables */
232: Insert_Adjustment_Data
233: (p_api_version => l_api_version,
234: p_init_msg_list => FND_API.G_FALSE,
235: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
236: p_group_id => p_group_id,
237: p_organization_id => p_organization_id,
238: p_ledger_id => l_ledger_id,
239: x_return_status => l_return_status);

Line 241: IF l_return_status <> FND_API.g_ret_sts_success THEN

237: p_organization_id => p_organization_id,
238: p_ledger_id => l_ledger_id,
239: x_return_status => l_return_status);
240:
241: IF l_return_status <> FND_API.g_ret_sts_success THEN
242: IF l_exceptionLog THEN
243: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
244: fnd_message.set_token('CALLED','Insert_Adjustment_Data');
245:

Line 247: RAISE FND_API.g_exc_unexpected_error;

243: fnd_message.set_name('BOM','CST_LOG_EXCEPTION');
244: fnd_message.set_token('CALLED','Insert_Adjustment_Data');
245:
246: END IF;
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;
249:
250: l_stmt_num := 60;
251:

Line 289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

285: END IF;
286:
287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING',FND_MESSAGE.GET);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK;
291:
292: IF (l_ulog) THEN
293: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

Line 299: WHEN FND_API.G_EXC_ERROR THEN

295:
296: /* Set concurrent program status to error */
297: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);
298:
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK;
301:
302: IF (l_exceptionLog) THEN
303: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

Line 448: IF NOT FND_API.Compatible_API_Call ( l_api_version,

444: );
445: END IF;
446:
447: /* Standard call to check for call compatibility */
448: IF NOT FND_API.Compatible_API_Call ( l_api_version,
449: p_api_version,
450: l_api_name,
451: G_PKG_NAME )
452: THEN

Line 453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

449: p_api_version,
450: l_api_name,
451: G_PKG_NAME )
452: THEN
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: /* Initialize message list if p_init_msg_list is set to TRUE */
457: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 457: IF FND_API.to_Boolean( p_init_msg_list ) THEN

453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: /* Initialize message list if p_init_msg_list is set to TRUE */
457: IF FND_API.to_Boolean( p_init_msg_list ) THEN
458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: /* Initialize API return status to success */

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: FND_MSG_PUB.initialize;
459: END IF;
460:
461: /* Initialize API return status to success */
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: l_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: l_stmt_num := 10;
466:

Line 463: l_return_status := FND_API.G_RET_STS_SUCCESS;

459: END IF;
460:
461: /* Initialize API return status to success */
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: l_return_status := FND_API.G_RET_STS_SUCCESS;
464:
465: l_stmt_num := 10;
466:
467: /* Retrieve the organization / ledger / OU related information for the organization */

Line 1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1033: END IF;
1034:
1035: EXCEPTION
1036:
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.g_ret_sts_error;
1039: IF (l_ulog) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1041: END IF;

Line 1038: x_return_status := FND_API.g_ret_sts_error;

1034:
1035: EXCEPTION
1036:
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := FND_API.g_ret_sts_error;
1039: IF (l_ulog) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1041: END IF;
1042:

Line 1043: WHEN FND_API.G_EXC_ERROR THEN

1039: IF (l_ulog) THEN
1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1041: END IF;
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.g_ret_sts_error;
1045: IF (l_exceptionLog) THEN
1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1047: END IF;

Line 1044: x_return_status := FND_API.g_ret_sts_error;

1040: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1041: END IF;
1042:
1043: WHEN FND_API.G_EXC_ERROR THEN
1044: x_return_status := FND_API.g_ret_sts_error;
1045: IF (l_exceptionLog) THEN
1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1047: END IF;
1048:

Line 1050: x_return_status := FND_API.g_ret_sts_error;

1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1047: END IF;
1048:
1049: WHEN OTHERS THEN
1050: x_return_status := FND_API.g_ret_sts_error;
1051: IF (l_uLog) THEN
1052: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1053: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1054: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

Line 1141: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1137: );
1138: END IF;
1139:
1140: /* Standard call to check for call compatibility */
1141: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1142: p_api_version,
1143: l_api_name,
1144: G_PKG_NAME )
1145: THEN

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: p_api_version,
1143: l_api_name,
1144: G_PKG_NAME )
1145: THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: /* Initialize message list if p_init_msg_list is set to TRUE */
1150: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1150: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: /* Initialize message list if p_init_msg_list is set to TRUE */
1150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1151: FND_MSG_PUB.initialize;
1152: END IF;
1153:
1154: /* Initialize API return status to success */

Line 1155: x_return_status := FND_API.G_RET_STS_SUCCESS;

1151: FND_MSG_PUB.initialize;
1152: END IF;
1153:
1154: /* Initialize API return status to success */
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: l_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: l_stmt_num := 10;
1159:

Line 1156: l_return_status := FND_API.G_RET_STS_SUCCESS;

1152: END IF;
1153:
1154: /* Initialize API return status to success */
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156: l_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: l_stmt_num := 10;
1159:
1160: /* Create the Receipt Adjustment Events - Event type id = 15 */

Line 1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1756: END IF;
1757:
1758: EXCEPTION
1759:
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: x_return_status := FND_API.g_ret_sts_error;
1762: IF (l_uLog) THEN
1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1764: END IF;

Line 1761: x_return_status := FND_API.g_ret_sts_error;

1757:
1758: EXCEPTION
1759:
1760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1761: x_return_status := FND_API.g_ret_sts_error;
1762: IF (l_uLog) THEN
1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1764: END IF;
1765:

Line 1766: WHEN FND_API.G_EXC_ERROR THEN

1762: IF (l_uLog) THEN
1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1764: END IF;
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: x_return_status := FND_API.g_ret_sts_error;
1768: IF (l_exceptionLog) THEN
1769: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1770: END IF;

Line 1767: x_return_status := FND_API.g_ret_sts_error;

1763: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
1764: END IF;
1765:
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: x_return_status := FND_API.g_ret_sts_error;
1768: IF (l_exceptionLog) THEN
1769: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1770: END IF;
1771:

Line 1773: x_return_status := FND_API.g_ret_sts_error;

1769: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
1770: END IF;
1771:
1772: WHEN OTHERS THEN
1773: x_return_status := FND_API.g_ret_sts_error;
1774: IF (l_uLog) THEN
1775: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
1776: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
1777: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

Line 1867: IF NOT FND_API.Compatible_API_Call ( l_api_version,

1863: );
1864: END IF;
1865:
1866: /* Standard call to check for call compatibility */
1867: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1868: p_api_version,
1869: l_api_name,
1870: G_PKG_NAME )
1871: THEN

Line 1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1868: p_api_version,
1869: l_api_name,
1870: G_PKG_NAME )
1871: THEN
1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: END IF;
1874:
1875: /* Initialize message list if p_init_msg_list is set to TRUE */
1876: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1876: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1873: END IF;
1874:
1875: /* Initialize message list if p_init_msg_list is set to TRUE */
1876: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1877: FND_MSG_PUB.initialize;
1878: END IF;
1879:
1880: /* Initialize API return status to success */

Line 1881: x_return_status := FND_API.G_RET_STS_SUCCESS;

1877: FND_MSG_PUB.initialize;
1878: END IF;
1879:
1880: /* Initialize API return status to success */
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882: l_return_status := FND_API.G_RET_STS_SUCCESS;
1883:
1884: l_stmt_num := 10;
1885:

Line 1882: l_return_status := FND_API.G_RET_STS_SUCCESS;

1878: END IF;
1879:
1880: /* Initialize API return status to success */
1881: x_return_status := FND_API.G_RET_STS_SUCCESS;
1882: l_return_status := FND_API.G_RET_STS_SUCCESS;
1883:
1884: l_stmt_num := 10;
1885:
1886: /* Create RCV accounting events data from the GTT */

Line 2470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2466: END IF;
2467:
2468: EXCEPTION
2469:
2470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2471: x_return_status := FND_API.g_ret_sts_error;
2472: IF (l_uLog) THEN
2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2474: END IF;

Line 2471: x_return_status := FND_API.g_ret_sts_error;

2467:
2468: EXCEPTION
2469:
2470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2471: x_return_status := FND_API.g_ret_sts_error;
2472: IF (l_uLog) THEN
2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2474: END IF;
2475:

Line 2476: WHEN FND_API.G_EXC_ERROR THEN

2472: IF (l_uLog) THEN
2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2474: END IF;
2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: x_return_status := FND_API.g_ret_sts_error;
2478: IF (l_exceptionLog) THEN
2479: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2480: END IF;

Line 2477: x_return_status := FND_API.g_ret_sts_error;

2473: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2474: END IF;
2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477: x_return_status := FND_API.g_ret_sts_error;
2478: IF (l_exceptionLog) THEN
2479: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2480: END IF;
2481:

Line 2483: x_return_status := FND_API.g_ret_sts_error;

2479: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2480: END IF;
2481:
2482: WHEN OTHERS THEN
2483: x_return_status := FND_API.g_ret_sts_error;
2484: IF (l_uLog) THEN
2485: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2486: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2487: FND_MESSAGE.set_token('PROCEDURE',l_api_name);

Line 2579: x_return_status := FND_API.G_RET_STS_SUCCESS;

2575: );
2576: END IF;
2577:
2578: /* Initialize API return status to success */
2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: l_return_status := FND_API.G_RET_STS_SUCCESS;
2581:
2582: /* Standard call to check for call compatibility */
2583: IF NOT FND_API.Compatible_API_Call ( l_api_version,

Line 2580: l_return_status := FND_API.G_RET_STS_SUCCESS;

2576: END IF;
2577:
2578: /* Initialize API return status to success */
2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: l_return_status := FND_API.G_RET_STS_SUCCESS;
2581:
2582: /* Standard call to check for call compatibility */
2583: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2584: p_api_version,

Line 2583: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2579: x_return_status := FND_API.G_RET_STS_SUCCESS;
2580: l_return_status := FND_API.G_RET_STS_SUCCESS;
2581:
2582: /* Standard call to check for call compatibility */
2583: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2584: p_api_version,
2585: l_api_name,
2586: G_PKG_NAME )
2587: THEN

Line 2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2584: p_api_version,
2585: l_api_name,
2586: G_PKG_NAME )
2587: THEN
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: END IF;
2590:
2591: /* Initialize message list if p_init_msg_list is set to TRUE */
2592: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2592: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: END IF;
2590:
2591: /* Initialize message list if p_init_msg_list is set to TRUE */
2592: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2593: FND_MSG_PUB.initialize;
2594: END IF;
2595:
2596: l_stmt_num := 10;

Line 2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2839: END IF;
2840:
2841: EXCEPTION
2842:
2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2844: x_return_status := FND_API.g_ret_sts_error;
2845: IF (l_uLog) THEN
2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2847: END IF;

Line 2844: x_return_status := FND_API.g_ret_sts_error;

2840:
2841: EXCEPTION
2842:
2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2844: x_return_status := FND_API.g_ret_sts_error;
2845: IF (l_uLog) THEN
2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2847: END IF;
2848:

Line 2849: WHEN FND_API.G_EXC_ERROR THEN

2845: IF (l_uLog) THEN
2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2847: END IF;
2848:
2849: WHEN FND_API.G_EXC_ERROR THEN
2850: x_return_status := FND_API.g_ret_sts_error;
2851: IF (l_exceptionLog) THEN
2852: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2853: END IF;

Line 2850: x_return_status := FND_API.g_ret_sts_error;

2846: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
2847: END IF;
2848:
2849: WHEN FND_API.G_EXC_ERROR THEN
2850: x_return_status := FND_API.g_ret_sts_error;
2851: IF (l_exceptionLog) THEN
2852: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2853: END IF;
2854:

Line 2856: x_return_status := FND_API.g_ret_sts_error;

2852: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
2853: END IF;
2854:
2855: WHEN OTHERS THEN
2856: x_return_status := FND_API.g_ret_sts_error;
2857: IF (l_uLog) THEN
2858: FND_MESSAGE.set_name('BOM', 'CST_UNEXP_ERROR');
2859: FND_MESSAGE.set_token('PACKAGE', G_PKG_NAME);
2860: FND_MESSAGE.set_token('PROCEDURE',l_api_name);