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

Line 235: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');

231: );
232: --
233: if l_rep_req_id = 0 then
234: --
235: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');
236: raise FND_API.G_EXC_ERROR ;
237: --
238: end if;
239:

Line 965: -- Calls FND_MESSAGE server package to set the Message Stack. This message is

961: /* ----------------------------------------------------------------------- */
962:
963: -- Define a Message Token with a Value and set the Message Name
964:
965: -- Calls FND_MESSAGE server package to set the Message Stack. This message is
966: -- retrieved by the calling program.
967:
968: PROCEDURE add_message(appname IN VARCHAR2,
969: msgname IN VARCHAR2) AS

Line 978: FND_MESSAGE.SET_NAME(appname, msgname);

974:
975: if ((appname is not null) and
976: (msgname is not null)) then
977:
978: FND_MESSAGE.SET_NAME(appname, msgname);
979:
980: if no_msg_tokens is not null then
981:
982: for i in 1..no_msg_tokens loop

Line 983: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));

979:
980: if no_msg_tokens is not null then
981:
982: for i in 1..no_msg_tokens loop
983: FND_MESSAGE.SET_TOKEN(msg_tok_names(i), msg_tok_val(i));
984: end loop;
985:
986: end if;
987:

Line 2947: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');

2943: );
2944: --
2945: if l_rep_req_id = 0 then
2946: --
2947: fnd_message.set_name('PSB', 'PSB_FAIL_TO_SUBMIT_REQUEST');
2948: raise FND_API.G_EXC_ERROR ;
2949: --
2950: end if;
2951:

Line 3371: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3367: l_success := fnd_submit.set_request_set('PSB', 'PSBRSDER');
3368:
3369: IF NOT(l_success)
3370: THEN
3371: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3372: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set_Request_Set Failed');
3373: FND_MSG_PUB.Add;
3374:
3375: RAISE FND_API.G_EXC_ERROR; -- Bug #4451621

Line 3372: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set_Request_Set Failed');

3368:
3369: IF NOT(l_success)
3370: THEN
3371: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3372: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set_Request_Set Failed');
3373: FND_MSG_PUB.Add;
3374:
3375: RAISE FND_API.G_EXC_ERROR; -- Bug #4451621
3376: END IF;

Line 3392: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3388: );
3389:
3390: IF ( NOT l_success )
3391: THEN
3392: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3393: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 1 failed');
3394: FND_MSG_PUB.Add;
3395: END IF;
3396:

Line 3393: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 1 failed');

3389:
3390: IF ( NOT l_success )
3391: THEN
3392: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3393: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 1 failed');
3394: FND_MSG_PUB.Add;
3395: END IF;
3396:
3397: /* submit program PSBCPCDA which is in stage ST2 */

Line 3412: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3408: );
3409:
3410: IF ( NOT l_success )
3411: THEN
3412: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3413: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 2 failed');
3414: FND_MSG_PUB.Add;
3415: END IF;
3416:

Line 3413: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 2 failed');

3409:
3410: IF ( NOT l_success )
3411: THEN
3412: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3413: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 2 failed');
3414: FND_MSG_PUB.Add;
3415: END IF;
3416:
3417: /* submit program PSBCPCDE which is in stage ST2 */

Line 3432: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3428: argument7 => chr(0)
3429: );
3430:
3431: IF ( NOT l_success ) THEN
3432: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3433: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 2 failed');
3434: FND_MSG_PUB.Add;
3435: END IF;
3436:

Line 3433: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 2 failed');

3429: );
3430:
3431: IF ( NOT l_success ) THEN
3432: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3433: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 2 failed');
3434: FND_MSG_PUB.Add;
3435: END IF;
3436:
3437: /* submit program PSBCPCPS which is in stage ST3 */

Line 3452: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3448: );
3449:
3450: IF ( NOT l_success )
3451: THEN
3452: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3453: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 3 failed');
3454: FND_MSG_PUB.Add;
3455: END IF;
3456:

Line 3453: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 3 failed');

3449:
3450: IF ( NOT l_success )
3451: THEN
3452: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3453: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 3 failed');
3454: FND_MSG_PUB.Add;
3455: END IF;
3456:
3457: /* submit program PSBCPSAL which is in stage ST5 */

Line 3476: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3472: );
3473:
3474: IF ( NOT l_success )
3475: THEN
3476: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3477: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 5 failed');
3478: FND_MSG_PUB.Add;
3479: END IF;
3480:

Line 3477: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 5 failed');

3473:
3474: IF ( NOT l_success )
3475: THEN
3476: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3477: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 5 failed');
3478: FND_MSG_PUB.Add;
3479: END IF;
3480:
3481: /* submit program PSBCPATT which is in stage ST5 */

Line 3500: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3496: );
3497:
3498: IF ( NOT l_success )
3499: THEN
3500: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3501: FND_MESSAGE.SET_TOKEN('MESSAGE', '2ndprogram in Stage 5 failed');
3502: FND_MSG_PUB.Add;
3503: END IF;
3504:

Line 3501: FND_MESSAGE.SET_TOKEN('MESSAGE', '2ndprogram in Stage 5 failed');

3497:
3498: IF ( NOT l_success )
3499: THEN
3500: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3501: FND_MESSAGE.SET_TOKEN('MESSAGE', '2ndprogram in Stage 5 failed');
3502: FND_MSG_PUB.Add;
3503: END IF;
3504:
3505: /* submit program PSBCPPOS which is in stage ST5 */

Line 3526: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3522: );
3523:
3524: IF ( NOT l_success )
3525: THEN
3526: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3527: FND_MESSAGE.SET_TOKEN('MESSAGE', '3rd program in Stage 5 failed');
3528: FND_MSG_PUB.Add;
3529: END IF;
3530:

Line 3527: FND_MESSAGE.SET_TOKEN('MESSAGE', '3rd program in Stage 5 failed');

3523:
3524: IF ( NOT l_success )
3525: THEN
3526: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3527: FND_MESSAGE.SET_TOKEN('MESSAGE', '3rd program in Stage 5 failed');
3528: FND_MSG_PUB.Add;
3529: END IF;
3530:
3531: /* submit program PSBCPEMP which is in stage ST6 */

Line 3554: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3550:
3551:
3552: IF ( NOT l_success )
3553: THEN
3554: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3555: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 6 failed');
3556: FND_MSG_PUB.Add;
3557: END IF;
3558:

Line 3555: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 6 failed');

3551:
3552: IF ( NOT l_success )
3553: THEN
3554: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3555: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 6 failed');
3556: FND_MSG_PUB.Add;
3557: END IF;
3558:
3559: /* submit program PSBCPDIS which is in stage ST7 */

Line 3579: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3575: );
3576:
3577: IF ( NOT l_success )
3578: THEN
3579: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3580: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 7 failed');
3581: FND_MSG_PUB.Add;
3582: END IF;
3583:

Line 3580: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 7 failed');

3576:
3577: IF ( NOT l_success )
3578: THEN
3579: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3580: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 7 failed');
3581: FND_MSG_PUB.Add;
3582: END IF;
3583:
3584:

Line 3605: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3601: );
3602:
3603: IF ( NOT l_success )
3604: THEN
3605: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3606: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 7 failed');
3607: FND_MSG_PUB.Add;
3608: END IF;
3609:

Line 3606: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 7 failed');

3602:
3603: IF ( NOT l_success )
3604: THEN
3605: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3606: FND_MESSAGE.SET_TOKEN('MESSAGE', '2nd program in Stage 7 failed');
3607: FND_MSG_PUB.Add;
3608: END IF;
3609:
3610: /* Bug 4179764 Start */

Line 3626: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3622: );
3623:
3624: IF ( NOT l_success )
3625: THEN
3626: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3627: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 4 failed');
3628: FND_MSG_PUB.Add;
3629: END IF;
3630:

Line 3627: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 4 failed');

3623:
3624: IF ( NOT l_success )
3625: THEN
3626: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3627: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 4 failed');
3628: FND_MSG_PUB.Add;
3629: END IF;
3630:
3631: /* Bug 4179764 End */

Line 3648: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3644: );
3645:
3646: IF ( NOT l_success )
3647: THEN
3648: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3649: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 8 failed');
3650: FND_MSG_PUB.Add;
3651: END IF;
3652:

Line 3649: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 8 failed');

3645:
3646: IF ( NOT l_success )
3647: THEN
3648: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3649: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 8 failed');
3650: FND_MSG_PUB.Add;
3651: END IF;
3652:
3653:

Line 3670: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3666: );
3667:
3668: IF ( NOT l_success )
3669: THEN
3670: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3671: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 9 failed');
3672: FND_MSG_PUB.Add;
3673: END IF;
3674:

Line 3671: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 9 failed');

3667:
3668: IF ( NOT l_success )
3669: THEN
3670: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3671: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 9 failed');
3672: FND_MSG_PUB.Add;
3673: END IF;
3674:
3675: /* submit program PSBCPFPD which is in stage ST10 */

Line 3690: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3686: );
3687:
3688: IF ( NOT l_success )
3689: THEN
3690: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3691: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 10 failed');
3692: FND_MSG_PUB.Add;
3693: END IF;
3694:

Line 3691: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 10 failed');

3687:
3688: IF ( NOT l_success )
3689: THEN
3690: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3691: FND_MESSAGE.SET_TOKEN('MESSAGE', '1st program in Stage 10 failed');
3692: FND_MSG_PUB.Add;
3693: END IF;
3694:
3695: /* Submit the Request set */

Line 3701: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');

3697: p_request_id := l_request_id ;
3698:
3699: IF (l_request_id = 0)
3700: THEN
3701: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3702: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set Submission Failed');
3703: FND_MSG_PUB.Add;
3704: END IF;
3705:

Line 3702: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set Submission Failed');

3698:
3699: IF (l_request_id = 0)
3700: THEN
3701: FND_MESSAGE.SET_NAME('PSB','PSB_DEBUG_MESSAGE');
3702: FND_MESSAGE.SET_TOKEN('MESSAGE', 'Set Submission Failed');
3703: FND_MSG_PUB.Add;
3704: END IF;
3705:
3706: END IF; -- SET_REQUEST_SET Successful.

Line 3801: FND_MESSAGE.SET_NAME('PSB', 'PSB_DUPLICATE_NAME');

3797:
3798: --in case the name is already in use, abort the process and report the
3799: --user through the logs generated
3800: IF l_name_already_exist > 0 THEN
3801: FND_MESSAGE.SET_NAME('PSB', 'PSB_DUPLICATE_NAME');
3802: FND_MSG_PUB.ADD;
3803: RAISE FND_API.G_EXC_ERROR;
3804: END IF;
3805: