DBA Data[Home] [Help]

APPS.PSP_ENC_UPDATE_LINES dependencies on PSP_ENC_UPDATE_LINES

Line 1: PACKAGE BODY PSP_ENC_UPDATE_LINES AS

1: PACKAGE BODY PSP_ENC_UPDATE_LINES AS
2: /* $Header: PSPENUPB.pls 120.3 2006/02/22 05:16:55 spchakra noship $ */
3:
4: -- Global Variable for referring REquest ID through out the package, Introduce for bug 2259310
5: g_request_id NUMBER DEFAULT fnd_global.conc_request_id;

Line 213: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path); --- added this line for 2444657

209: IF action_type_inprogress%NOTFOUND THEN
210: IF l_inprogress_count >0 THEN
211: -- this case should not arise unless some data corruption
212: g_error_api_path := 'No_create_rec_found'||g_error_api_path;
213: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path); --- added this line for 2444657
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: END IF;
216: ELSE
217: End of bug fix 3434626 ***** /

Line 383: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path || sqlerrm);

379:
380: EXCEPTION
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: g_error_api_path := 'UPDATE_ENC_LINES:'||g_error_api_path;
383: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path || sqlerrm);
384: l_retcode := fnd_api.g_ret_sts_unexp_error;
385: retcode := 2;
386: -- Introduced the following for bug fix 3434626
387: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 392: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path || sqlerrm);

388: p_print_header => FND_API.G_FALSE);
389: -- End of bug fix 3434626
390: WHEN OTHERS THEN
391: g_error_api_path := 'UPDATE_ENC_LINES:'||g_error_api_path||' UNEXPECTED ERROR';
392: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path || sqlerrm);
393: l_retcode := fnd_api.g_ret_sts_unexp_error;
394: retcode := 2;
395: -- Introduced the following for bug fix 3434626
396: psp_message_s.print_error(p_mode => FND_FILE.LOG,

Line 1090: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','VERIFY_CHANGES');

1086: l_retcode := FND_API.G_RET_STS_SUCCESS;
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: g_error_api_path := SUBSTR('VERIFY_CHANGES:'||g_error_api_path,1,230);
1090: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','VERIFY_CHANGES');
1091: l_retcode := fnd_api.g_ret_sts_unexp_error;
1092: END verify_changes;
1093:
1094: / *************************************************************************************************

Line 1179: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');

1175:
1176: EXCEPTION
1177: WHEN OTHERS THEN
1178: g_error_api_path := SUBSTR('MOVE_QKUPD_REC_TO_HIST:'||g_error_api_path,1,230);
1179: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','MOVE_QKUPD_REC_TO_HIST');
1180: p_return_status := fnd_api.g_ret_sts_unexp_error;
1181: END move_qkupd_rec_to_hist;
1182:
1183:

Line 1278: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path);

1274: p_return_status := fnd_api.g_ret_sts_success;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: g_error_api_path := substr('CLEANUP_ON_SUCCESS:'||g_error_api_path,1,230);
1278: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES',g_error_api_path);
1279: l_retcode := fnd_api.g_ret_sts_unexp_error;
1280: END cleanup_on_success;
1281:
1282: --- added the procedure for 3473294

Line 1431: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','ROLLBACK_REJECTED_ASG');

1427: p_return_status := fnd_api.g_ret_sts_success;
1428:
1429: exception
1430: when others then
1431: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','ROLLBACK_REJECTED_ASG');
1432: fnd_msg_pub.add;
1433: end;
1434: End of comment of for Creatwe and Update multi-thread *****/
1435: END psp_enc_update_lines;

Line 1435: END psp_enc_update_lines;

1431: fnd_msg_pub.add_exc_msg('PSP_ENC_UPDATE_LINES','ROLLBACK_REJECTED_ASG');
1432: fnd_msg_pub.add;
1433: end;
1434: End of comment of for Creatwe and Update multi-thread *****/
1435: END psp_enc_update_lines;