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.DPP_BUSINESSEVENTS_PVT dependencies on FND_MESSAGE

Line 185: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

181:
182: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, L_API_NAME || ',FND_API.G_RET_STS_UNEXP_ERROR :: ' || SQLERRM);
183:
184: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
185: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
187: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
188: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
189: END IF;

Line 186: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);

182: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, L_API_NAME || ',FND_API.G_RET_STS_UNEXP_ERROR :: ' || SQLERRM);
183:
184: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
185: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
187: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
188: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
189: END IF;
190:

Line 187: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);

183:
184: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
185: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
187: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
188: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
189: END IF;
190:
191: IF FND_MSG_PUB.CHECK_MSG_LEVEL ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 188: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

184: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
185: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
186: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
187: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
188: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
189: END IF;
190:
191: IF FND_MSG_PUB.CHECK_MSG_LEVEL ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
192: THEN

Line 314: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

310:
311: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, L_API_NAME || ',FND_API.G_RET_STS_UNEXP_ERROR :: ' || SQLERRM);
312:
313: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
315: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
316: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
317: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
318: END IF;

Line 315: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);

311: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, L_API_NAME || ',FND_API.G_RET_STS_UNEXP_ERROR :: ' || SQLERRM);
312:
313: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
315: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
316: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
317: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
318: END IF;
319:

Line 316: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);

312:
313: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
315: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
316: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
317: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
318: END IF;
319:
320: IF FND_MSG_PUB.CHECK_MSG_LEVEL ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 317: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

313: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
315: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
316: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
317: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
318: END IF;
319:
320: IF FND_MSG_PUB.CHECK_MSG_LEVEL ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
321: THEN

Line 392: X_MSG_DATA := FND_MESSAGE.GET();

388:
389: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, L_API_NAME || ', Event Test : ' || L_EVENT_TEST);
390:
391: IF L_EVENT_TEST = 'NONE' THEN
392: X_MSG_DATA := FND_MESSAGE.GET();
393: DPP_UTILITY_PVT.DEBUG_MESSAGE(FND_LOG.LEVEL_STATEMENT, l_module, 'No enabled local subscriptions reference the event, or the event does not exist.');
394: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No enabled local subscriptions reference the event, or the event does not exist.');
395: FND_FILE.NEW_LINE(FND_FILE.LOG);
396: RAISE FND_API.G_EXC_ERROR;

Line 449: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');

445:
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHER_ERROR : '||SQLERRM);
447: FND_FILE.NEW_LINE(FND_FILE.LOG);
448: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
450: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
451: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
452: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
453: END IF;

Line 450: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);

446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'OTHER_ERROR : '||SQLERRM);
447: FND_FILE.NEW_LINE(FND_FILE.LOG);
448: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
450: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
451: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
452: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
453: END IF;
454:

Line 451: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);

447: FND_FILE.NEW_LINE(FND_FILE.LOG);
448: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
450: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
451: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
452: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
453: END IF;
454:
455: ROLLBACK TO START_WF_ON_EFF_DATE;

Line 452: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);

448: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
449: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
450: FND_MESSAGE.SET_TOKEN('ROUTINE', L_FULL_NAME);
451: FND_MESSAGE.SET_TOKEN('ERRNO', SQLCODE);
452: FND_MESSAGE.SET_TOKEN('REASON', SQLERRM);
453: END IF;
454:
455: ROLLBACK TO START_WF_ON_EFF_DATE;
456: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

Line 638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

634: FROM dual;
635:
636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
640: fnd_message.set_token('ERRNO', sqlcode);
641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
642: FND_MSG_PUB.add;

Line 639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

635:
636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
640: fnd_message.set_token('ERRNO', sqlcode);
641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
642: FND_MSG_PUB.add;
643: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 640: fnd_message.set_token('ERRNO', sqlcode);

636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
640: fnd_message.set_token('ERRNO', sqlcode);
641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
642: FND_MSG_PUB.add;
643: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
644: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');

637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
640: fnd_message.set_token('ERRNO', sqlcode);
641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
642: FND_MSG_PUB.add;
643: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
644: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
645: END IF;

Line 648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

644: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
645: END IF;
646: RAISE FND_API.g_exc_error;
647: WHEN OTHERS THEN
648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

645: END IF;
646: RAISE FND_API.g_exc_error;
647: WHEN OTHERS THEN
648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');

Line 650: fnd_message.set_token('ERRNO', sqlcode);

646: RAISE FND_API.g_exc_error;
647: WHEN OTHERS THEN
648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
654: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');

Line 651: fnd_message.set_token('REASON', sqlerrm);

647: WHEN OTHERS THEN
648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
654: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
655: FND_MSG_PUB.add;

Line 653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');

649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
654: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
655: FND_MSG_PUB.add;
656: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
657: END IF;

Line 654: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');

650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
654: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
655: FND_MSG_PUB.add;
656: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
657: END IF;
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

669: WHERE user_id = l_user_id ;
670:
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
675: fnd_message.set_token('ERRNO', sqlcode);
676: fnd_message.set_token('REASON', 'INVALID USER');
677: FND_MSG_PUB.add;

Line 674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

670:
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
675: fnd_message.set_token('ERRNO', sqlcode);
676: fnd_message.set_token('REASON', 'INVALID USER');
677: FND_MSG_PUB.add;
678: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 675: fnd_message.set_token('ERRNO', sqlcode);

671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
675: fnd_message.set_token('ERRNO', sqlcode);
676: fnd_message.set_token('REASON', 'INVALID USER');
677: FND_MSG_PUB.add;
678: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
679: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 676: fnd_message.set_token('REASON', 'INVALID USER');

672: WHEN NO_DATA_FOUND THEN
673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
675: fnd_message.set_token('ERRNO', sqlcode);
676: fnd_message.set_token('REASON', 'INVALID USER');
677: FND_MSG_PUB.add;
678: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
679: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
680: END IF;

Line 683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

679: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
680: END IF;
681: RAISE FND_API.g_exc_error;
682: WHEN OTHERS THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

680: END IF;
681: RAISE FND_API.g_exc_error;
682: WHEN OTHERS THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;

Line 685: fnd_message.set_token('ERRNO', sqlcode);

681: RAISE FND_API.g_exc_error;
682: WHEN OTHERS THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;
689:

Line 686: fnd_message.set_token('REASON', sqlerrm);

682: WHEN OTHERS THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;
689:
690: l_user_name := ''''||l_user_name||'''';

Line 703: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_TYPE');

699: OR p_txn_hdr_rec.process_code = 'CUSTCL' THEN
700:
701: IF p_txn_hdr_rec.claim_type_flag IS NULL THEN
702: --No claim type flag has been sent
703: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_TYPE');
704: FND_MSG_PUB.add;
705: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
706: RAISE FND_API.g_exc_error;
707: ELSE

Line 729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

725: p_txn_line_id(i)
726: );
727: EXCEPTION
728: WHEN OTHERS THEN
729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
731: fnd_message.set_token('ERRNO', sqlcode);
732: fnd_message.set_token('REASON', sqlerrm);
733: FND_MSG_PUB.add;

Line 730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

726: );
727: EXCEPTION
728: WHEN OTHERS THEN
729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
731: fnd_message.set_token('ERRNO', sqlcode);
732: fnd_message.set_token('REASON', sqlerrm);
733: FND_MSG_PUB.add;
734: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 731: fnd_message.set_token('ERRNO', sqlcode);

727: EXCEPTION
728: WHEN OTHERS THEN
729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
731: fnd_message.set_token('ERRNO', sqlcode);
732: fnd_message.set_token('REASON', sqlerrm);
733: FND_MSG_PUB.add;
734: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
735: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 732: fnd_message.set_token('REASON', sqlerrm);

728: WHEN OTHERS THEN
729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
731: fnd_message.set_token('ERRNO', sqlcode);
732: fnd_message.set_token('REASON', sqlerrm);
733: FND_MSG_PUB.add;
734: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
735: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
736: END IF;

Line 741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END;
739: END LOOP;
740: ELSE
741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
743: fnd_message.set_token('ERRNO', sqlcode);
744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
745: FND_MSG_PUB.add;

Line 742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

738: END;
739: END LOOP;
740: ELSE
741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
743: fnd_message.set_token('ERRNO', sqlcode);
744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
745: FND_MSG_PUB.add;
746: RAISE FND_API.G_EXC_ERROR;

Line 743: fnd_message.set_token('ERRNO', sqlcode);

739: END LOOP;
740: ELSE
741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
743: fnd_message.set_token('ERRNO', sqlcode);
744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
745: FND_MSG_PUB.add;
746: RAISE FND_API.G_EXC_ERROR;
747: END IF; --l_table_count

Line 744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');

740: ELSE
741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
743: fnd_message.set_token('ERRNO', sqlcode);
744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
745: FND_MSG_PUB.add;
746: RAISE FND_API.G_EXC_ERROR;
747: END IF; --l_table_count
748: ELSE

Line 759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

755: FROM dpp_transaction_lines_all
756: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
757: EXCEPTION
758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
761: fnd_message.set_token('ERRNO', sqlcode);
762: fnd_message.set_token('REASON', sqlerrm);
763: FND_MSG_PUB.add;

Line 760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

756: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
757: EXCEPTION
758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
761: fnd_message.set_token('ERRNO', sqlcode);
762: fnd_message.set_token('REASON', sqlerrm);
763: FND_MSG_PUB.add;
764: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 761: fnd_message.set_token('ERRNO', sqlcode);

757: EXCEPTION
758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
761: fnd_message.set_token('ERRNO', sqlcode);
762: fnd_message.set_token('REASON', sqlerrm);
763: FND_MSG_PUB.add;
764: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
765: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 762: fnd_message.set_token('REASON', sqlerrm);

758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
761: fnd_message.set_token('ERRNO', sqlcode);
762: fnd_message.set_token('REASON', sqlerrm);
763: FND_MSG_PUB.add;
764: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
765: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
766: END IF;

Line 779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

775: FROM dpp_customer_claims_all
776: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
777: EXCEPTION
778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
781: fnd_message.set_token('ERRNO', sqlcode);
782: fnd_message.set_token('REASON', sqlerrm);
783: FND_MSG_PUB.add;

Line 780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

776: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
777: EXCEPTION
778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
781: fnd_message.set_token('ERRNO', sqlcode);
782: fnd_message.set_token('REASON', sqlerrm);
783: FND_MSG_PUB.add;
784: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 781: fnd_message.set_token('ERRNO', sqlcode);

777: EXCEPTION
778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
781: fnd_message.set_token('ERRNO', sqlcode);
782: fnd_message.set_token('REASON', sqlerrm);
783: FND_MSG_PUB.add;
784: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
785: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 782: fnd_message.set_token('REASON', sqlerrm);

778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
781: fnd_message.set_token('ERRNO', sqlcode);
782: fnd_message.set_token('REASON', sqlerrm);
783: FND_MSG_PUB.add;
784: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
785: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
786: END IF;

Line 917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

913: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
914: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
919: fnd_message.set_token('ERRNO', sqlcode);
920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
921: FND_MSG_PUB.add;

Line 918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

914: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
919: fnd_message.set_token('ERRNO', sqlcode);
920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
921: FND_MSG_PUB.add;
922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 919: fnd_message.set_token('ERRNO', sqlcode);

915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
919: fnd_message.set_token('ERRNO', sqlcode);
920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
921: FND_MSG_PUB.add;
922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
923: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');

916: WHEN NO_DATA_FOUND THEN
917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
919: fnd_message.set_token('ERRNO', sqlcode);
920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
921: FND_MSG_PUB.add;
922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
923: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
924: END IF;

Line 927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

923: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
924: END IF;
925: RAISE FND_API.G_EXC_ERROR;
926: WHEN OTHERS THEN
927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;

Line 928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

924: END IF;
925: RAISE FND_API.G_EXC_ERROR;
926: WHEN OTHERS THEN
927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;
932: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 929: fnd_message.set_token('ERRNO', sqlcode);

925: RAISE FND_API.G_EXC_ERROR;
926: WHEN OTHERS THEN
927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;
932: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
933: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');

Line 930: fnd_message.set_token('REASON', sqlerrm);

926: WHEN OTHERS THEN
927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;
932: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
933: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');
934: FND_MSG_PUB.add;

Line 933: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');

929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;
932: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
933: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');
934: FND_MSG_PUB.add;
935: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
936: END IF;
937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1096: EXCEPTION
1097: WHEN NO_DATA_FOUND THEN
1098: l_cost_adj_acct := null;
1099: WHEN OTHERS THEN
1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;

Line 1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1097: WHEN NO_DATA_FOUND THEN
1098: l_cost_adj_acct := null;
1099: WHEN OTHERS THEN
1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;
1105: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1102: fnd_message.set_token('ERRNO', sqlcode);

1098: l_cost_adj_acct := null;
1099: WHEN OTHERS THEN
1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;
1105: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1106: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

Line 1103: fnd_message.set_token('REASON', sqlerrm);

1099: WHEN OTHERS THEN
1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;
1105: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1106: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
1107: FND_MSG_PUB.add;

Line 1106: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;
1105: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1106: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
1107: FND_MSG_PUB.add;
1108: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1109: END IF;
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1118: WHERE osp.org_id = to_number(dtha.org_id)
1119: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1124: fnd_message.set_token('ERRNO', sqlcode);
1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
1126: FND_MSG_PUB.add;

Line 1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1119: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1124: fnd_message.set_token('ERRNO', sqlcode);
1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
1126: FND_MSG_PUB.add;
1127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1124: fnd_message.set_token('ERRNO', sqlcode);

1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1124: fnd_message.set_token('ERRNO', sqlcode);
1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
1126: FND_MSG_PUB.add;
1127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');

1121: WHEN NO_DATA_FOUND THEN
1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1124: fnd_message.set_token('ERRNO', sqlcode);
1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
1126: FND_MSG_PUB.add;
1127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1129: END IF;

Line 1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1129: END IF;
1130: RAISE FND_API.G_EXC_ERROR;
1131: WHEN OTHERS THEN
1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;

Line 1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1129: END IF;
1130: RAISE FND_API.G_EXC_ERROR;
1131: WHEN OTHERS THEN
1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;
1137: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1134: fnd_message.set_token('ERRNO', sqlcode);

1130: RAISE FND_API.G_EXC_ERROR;
1131: WHEN OTHERS THEN
1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;
1137: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1138: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

Line 1135: fnd_message.set_token('REASON', sqlerrm);

1131: WHEN OTHERS THEN
1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;
1137: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1138: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
1139: FND_MSG_PUB.add;

Line 1138: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;
1137: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1138: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
1139: FND_MSG_PUB.add;
1140: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1141: END IF;
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1199: END IF;
1200: END IF;
1201: ELSE
1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1204: fnd_message.set_token('ERRNO', sqlcode);
1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
1206: FND_MSG_PUB.add;

Line 1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1199: END IF;
1200: END IF;
1201: ELSE
1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1204: fnd_message.set_token('ERRNO', sqlcode);
1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
1206: FND_MSG_PUB.add;
1207: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1204: fnd_message.set_token('ERRNO', sqlcode);

1200: END IF;
1201: ELSE
1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1204: fnd_message.set_token('ERRNO', sqlcode);
1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
1206: FND_MSG_PUB.add;
1207: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1208: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');

1201: ELSE
1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1204: fnd_message.set_token('ERRNO', sqlcode);
1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
1206: FND_MSG_PUB.add;
1207: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1208: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1209: END IF;

Line 1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1329: AND ostp.org_id = to_number(dtha.org_id)
1330: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1331: EXCEPTION
1332: WHEN NO_DATA_FOUND THEN
1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1335: fnd_message.set_token('ERRNO', sqlcode);
1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1337: FND_MSG_PUB.add;

Line 1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1330: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1331: EXCEPTION
1332: WHEN NO_DATA_FOUND THEN
1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1335: fnd_message.set_token('ERRNO', sqlcode);
1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1337: FND_MSG_PUB.add;
1338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1335: fnd_message.set_token('ERRNO', sqlcode);

1331: EXCEPTION
1332: WHEN NO_DATA_FOUND THEN
1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1335: fnd_message.set_token('ERRNO', sqlcode);
1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1337: FND_MSG_PUB.add;
1338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1339: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified

1332: WHEN NO_DATA_FOUND THEN
1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1335: fnd_message.set_token('ERRNO', sqlcode);
1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1337: FND_MSG_PUB.add;
1338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1339: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1340: END IF;

Line 1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1339: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1340: END IF;
1341: RAISE FND_API.g_exc_error;
1342: WHEN OTHERS THEN
1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1340: END IF;
1341: RAISE FND_API.g_exc_error;
1342: WHEN OTHERS THEN
1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

Line 1345: fnd_message.set_token('ERRNO', sqlcode);

1341: RAISE FND_API.g_exc_error;
1342: WHEN OTHERS THEN
1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1349: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

Line 1346: fnd_message.set_token('REASON', sqlerrm);

1342: WHEN OTHERS THEN
1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1349: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1350: FND_MSG_PUB.add;

Line 1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1349: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1350: FND_MSG_PUB.add;
1351: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1352: END IF;

Line 1349: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
1349: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
1350: FND_MSG_PUB.add;
1351: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1352: END IF;
1353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1666: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');

1662: --Check if the query returns any rows
1663: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1664: dbms_xmlquery.closeContext(l_queryCtx);
1665: ELSE
1666: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');
1667: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);
1668: FND_MSG_PUB.add;
1669: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1670: RAISE FND_API.g_exc_error;

Line 1667: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);

1663: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1664: dbms_xmlquery.closeContext(l_queryCtx);
1665: ELSE
1666: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');
1667: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);
1668: FND_MSG_PUB.add;
1669: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1670: RAISE FND_API.g_exc_error;
1671: END IF;

Line 1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1737: END IF;
1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO Raise_Business_Event;
1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1743: fnd_message.set_token('ERRNO', sqlcode);
1744: fnd_message.set_token('REASON', sqlerrm);
1745: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO Raise_Business_Event;
1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1743: fnd_message.set_token('ERRNO', sqlcode);
1744: fnd_message.set_token('REASON', sqlerrm);
1745: x_return_status := FND_API.g_ret_sts_unexp_error ;
1746: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1743: fnd_message.set_token('ERRNO', sqlcode);

1739: WHEN OTHERS THEN
1740: ROLLBACK TO Raise_Business_Event;
1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1743: fnd_message.set_token('ERRNO', sqlcode);
1744: fnd_message.set_token('REASON', sqlerrm);
1745: x_return_status := FND_API.g_ret_sts_unexp_error ;
1746: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1747: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1744: fnd_message.set_token('REASON', sqlerrm);

1740: ROLLBACK TO Raise_Business_Event;
1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1743: fnd_message.set_token('ERRNO', sqlcode);
1744: fnd_message.set_token('REASON', sqlerrm);
1745: x_return_status := FND_API.g_ret_sts_unexp_error ;
1746: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1747: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1748: END IF;

Line 1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1841: l_user_id);
1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1847: fnd_message.set_token('ERRNO', sqlcode);
1848: fnd_message.set_token('REASON', sqlerrm);
1849: FND_MSG_PUB.add;

Line 1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1847: fnd_message.set_token('ERRNO', sqlcode);
1848: fnd_message.set_token('REASON', sqlerrm);
1849: FND_MSG_PUB.add;
1850: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1847: fnd_message.set_token('ERRNO', sqlcode);

1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1847: fnd_message.set_token('ERRNO', sqlcode);
1848: fnd_message.set_token('REASON', sqlerrm);
1849: FND_MSG_PUB.add;
1850: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1851: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1848: fnd_message.set_token('REASON', sqlerrm);

1844: WHEN OTHERS THEN
1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1847: fnd_message.set_token('ERRNO', sqlcode);
1848: fnd_message.set_token('REASON', sqlerrm);
1849: FND_MSG_PUB.add;
1850: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1851: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1852: END IF;

Line 1879: FND_MESSAGE.set_name('DPP', 'DPP_CC_NO_ELIGIBLE_LINES_MSG');

1875: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Work Flow Event Raised');
1876:
1877: ELSE
1878: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Work Flow Event is not Raised');
1879: FND_MESSAGE.set_name('DPP', 'DPP_CC_NO_ELIGIBLE_LINES_MSG');
1880: FND_MSG_PUB.add;
1881: RAISE FND_API.g_exc_error;
1882: END IF; --p_row_count > 0
1883: END IF;

Line 1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1912: END IF;
1913:
1914: WHEN OTHERS THEN
1915: ROLLBACK TO Raise_Workflow_Event;
1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1918: fnd_message.set_token('ERRNO', sqlcode);
1919: fnd_message.set_token('REASON', sqlerrm);
1920: FND_MSG_PUB.add;

Line 1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1913:
1914: WHEN OTHERS THEN
1915: ROLLBACK TO Raise_Workflow_Event;
1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1918: fnd_message.set_token('ERRNO', sqlcode);
1919: fnd_message.set_token('REASON', sqlerrm);
1920: FND_MSG_PUB.add;
1921: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1918: fnd_message.set_token('ERRNO', sqlcode);

1914: WHEN OTHERS THEN
1915: ROLLBACK TO Raise_Workflow_Event;
1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1918: fnd_message.set_token('ERRNO', sqlcode);
1919: fnd_message.set_token('REASON', sqlerrm);
1920: FND_MSG_PUB.add;
1921: x_return_status := FND_API.g_ret_sts_unexp_error ;
1922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1919: fnd_message.set_token('REASON', sqlerrm);

1915: ROLLBACK TO Raise_Workflow_Event;
1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1918: fnd_message.set_token('ERRNO', sqlcode);
1919: fnd_message.set_token('REASON', sqlerrm);
1920: FND_MSG_PUB.add;
1921: x_return_status := FND_API.g_ret_sts_unexp_error ;
1922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1923: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);