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

Line 207: l_fnd_message VARCHAR2(4000) := NULL ;

203: l_msg_text VARCHAR2(32767) ;
204: l_num_apps NUMBER := 0;
205: l_operation VARCHAR2(4000) := NULL ;
206: l_description VARCHAR2(4000) := NULL ;
207: l_fnd_message VARCHAR2(4000) := NULL ;
208:
209: l_order_id NUMBER;
210: l_wi_instance_id NUMBER;
211: l_fa_instance_id NUMBER ;

Line 323: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;

319: EXCEPTION
320: WHEN e_MSG_DELIVERY_ERROR THEN
321: ROLLBACK to deliver_msg ;
322:
323: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
324: fnd_message.set_token ('CALLBACK',
325: app.callback_proc_name);
326: fnd_message.set_token ('ERROR_CODE',
327: TO_CHAR(l_error_code)) ;

Line 324: fnd_message.set_token ('CALLBACK',

320: WHEN e_MSG_DELIVERY_ERROR THEN
321: ROLLBACK to deliver_msg ;
322:
323: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
324: fnd_message.set_token ('CALLBACK',
325: app.callback_proc_name);
326: fnd_message.set_token ('ERROR_CODE',
327: TO_CHAR(l_error_code)) ;
328: fnd_message.set_token ('ERROR_MESSAGE',

Line 326: fnd_message.set_token ('ERROR_CODE',

322:
323: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
324: fnd_message.set_token ('CALLBACK',
325: app.callback_proc_name);
326: fnd_message.set_token ('ERROR_CODE',
327: TO_CHAR(l_error_code)) ;
328: fnd_message.set_token ('ERROR_MESSAGE',
329: l_error_message) ;
330:

Line 328: fnd_message.set_token ('ERROR_MESSAGE',

324: fnd_message.set_token ('CALLBACK',
325: app.callback_proc_name);
326: fnd_message.set_token ('ERROR_CODE',
327: TO_CHAR(l_error_code)) ;
328: fnd_message.set_token ('ERROR_MESSAGE',
329: l_error_message) ;
330:
331: l_fnd_message:= fnd_message.get ;
332:

Line 331: l_fnd_message:= fnd_message.get ;

327: TO_CHAR(l_error_code)) ;
328: fnd_message.set_token ('ERROR_MESSAGE',
329: l_error_message) ;
330:
331: l_fnd_message:= fnd_message.get ;
332:
333: xnp_message.update_status(
334: p_msg_id=>l_msg_header.message_id,
335: p_status=>'FAILED',

Line 336: p_error_desc=>l_fnd_message,

332:
333: xnp_message.update_status(
334: p_msg_id=>l_msg_header.message_id,
335: p_status=>'FAILED',
336: p_error_desc=>l_fnd_message,
337: p_order_id=>l_order_id,
338: p_wi_instance_id=>l_wi_instance_id,
339: p_fa_instance_id=>l_fa_instance_id) ;
340:

Line 345: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;

341:
342: WHEN e_MSG_PROCESSING_ERROR THEN
343: ROLLBACK to deliver_msg ;
344:
345: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
346: fnd_message.set_token ('MSG_CODE',
347: l_msg_header.message_code) ;
348: fnd_message.set_token ('ERROR_CODE',
349: TO_CHAR(l_error_code)) ;

Line 346: fnd_message.set_token ('MSG_CODE',

342: WHEN e_MSG_PROCESSING_ERROR THEN
343: ROLLBACK to deliver_msg ;
344:
345: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
346: fnd_message.set_token ('MSG_CODE',
347: l_msg_header.message_code) ;
348: fnd_message.set_token ('ERROR_CODE',
349: TO_CHAR(l_error_code)) ;
350: fnd_message.set_token ('ERROR_MESSAGE',

Line 348: fnd_message.set_token ('ERROR_CODE',

344:
345: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
346: fnd_message.set_token ('MSG_CODE',
347: l_msg_header.message_code) ;
348: fnd_message.set_token ('ERROR_CODE',
349: TO_CHAR(l_error_code)) ;
350: fnd_message.set_token ('ERROR_MESSAGE',
351: l_error_message) ;
352: l_fnd_message := fnd_message.get ;

Line 350: fnd_message.set_token ('ERROR_MESSAGE',

346: fnd_message.set_token ('MSG_CODE',
347: l_msg_header.message_code) ;
348: fnd_message.set_token ('ERROR_CODE',
349: TO_CHAR(l_error_code)) ;
350: fnd_message.set_token ('ERROR_MESSAGE',
351: l_error_message) ;
352: l_fnd_message := fnd_message.get ;
353:
354: xnp_message.update_status(

Line 352: l_fnd_message := fnd_message.get ;

348: fnd_message.set_token ('ERROR_CODE',
349: TO_CHAR(l_error_code)) ;
350: fnd_message.set_token ('ERROR_MESSAGE',
351: l_error_message) ;
352: l_fnd_message := fnd_message.get ;
353:
354: xnp_message.update_status(
355: p_msg_id=>l_msg_header.message_id,
356: p_status=>'FAILED',

Line 357: p_error_desc=>l_fnd_message,

353:
354: xnp_message.update_status(
355: p_msg_id=>l_msg_header.message_id,
356: p_status=>'FAILED',
357: p_error_desc=>l_fnd_message,
358: p_order_id=>l_order_id,
359: p_wi_instance_id=>l_wi_instance_id,
360: p_fa_instance_id=>l_fa_instance_id) ;
361:

Line 367: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;

363:
364: ROLLBACK ;
365:
366: l_fatal_error := TRUE;
367: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
368: fnd_message.set_token ('MSG_ID',
369: l_msg_header.message_id) ;
370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;

Line 368: fnd_message.set_token ('MSG_ID',

364: ROLLBACK ;
365:
366: l_fatal_error := TRUE;
367: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
368: fnd_message.set_token ('MSG_ID',
369: l_msg_header.message_id) ;
370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
372: l_fnd_message:= FND_MESSAGE.get ;

Line 370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

366: l_fatal_error := TRUE;
367: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
368: fnd_message.set_token ('MSG_ID',
369: l_msg_header.message_id) ;
370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
372: l_fnd_message:= FND_MESSAGE.get ;
373:
374: xnp_message.update_statuS(

Line 371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;

367: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
368: fnd_message.set_token ('MSG_ID',
369: l_msg_header.message_id) ;
370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
372: l_fnd_message:= FND_MESSAGE.get ;
373:
374: xnp_message.update_statuS(
375: p_msg_id=>l_msg_header.message_id,

Line 372: l_fnd_message:= FND_MESSAGE.get ;

368: fnd_message.set_token ('MSG_ID',
369: l_msg_header.message_id) ;
370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
372: l_fnd_message:= FND_MESSAGE.get ;
373:
374: xnp_message.update_statuS(
375: p_msg_id=>l_msg_header.message_id,
376: p_status=>'FAILED',

Line 377: p_error_desc=>l_fnd_message,

373:
374: xnp_message.update_statuS(
375: p_msg_id=>l_msg_header.message_id,
376: p_status=>'FAILED',
377: p_error_desc=>l_fnd_message,
378: p_order_id=>l_order_id,
379: p_wi_instance_id=>l_wi_instance_id,
380: p_fa_instance_id=>l_fa_instance_id) ;
381: END ;

Line 414: fnd_message.set_name ('XNP',

410:
411: EXCEPTION
412: WHEN e_MSG_VALIDATION_ERROR THEN
413: ROLLBACK to after_pop;
414: fnd_message.set_name ('XNP',
415: 'MSG_VALIDATION_ERROR') ;
416: fnd_message.set_token ('MSG_CODE',
417: l_msg_header.message_code) ;
418: fnd_message.set_token ('ERROR_CODE',

Line 416: fnd_message.set_token ('MSG_CODE',

412: WHEN e_MSG_VALIDATION_ERROR THEN
413: ROLLBACK to after_pop;
414: fnd_message.set_name ('XNP',
415: 'MSG_VALIDATION_ERROR') ;
416: fnd_message.set_token ('MSG_CODE',
417: l_msg_header.message_code) ;
418: fnd_message.set_token ('ERROR_CODE',
419: TO_CHAR(l_error_code)) ;
420: fnd_message.set_token ('ERROR_MESSAGE',

Line 418: fnd_message.set_token ('ERROR_CODE',

414: fnd_message.set_name ('XNP',
415: 'MSG_VALIDATION_ERROR') ;
416: fnd_message.set_token ('MSG_CODE',
417: l_msg_header.message_code) ;
418: fnd_message.set_token ('ERROR_CODE',
419: TO_CHAR(l_error_code)) ;
420: fnd_message.set_token ('ERROR_MESSAGE',
421: l_error_message) ;
422: l_fnd_message:= FND_MESSAGE.get ;

Line 420: fnd_message.set_token ('ERROR_MESSAGE',

416: fnd_message.set_token ('MSG_CODE',
417: l_msg_header.message_code) ;
418: fnd_message.set_token ('ERROR_CODE',
419: TO_CHAR(l_error_code)) ;
420: fnd_message.set_token ('ERROR_MESSAGE',
421: l_error_message) ;
422: l_fnd_message:= FND_MESSAGE.get ;
423:
424:

Line 422: l_fnd_message:= FND_MESSAGE.get ;

418: fnd_message.set_token ('ERROR_CODE',
419: TO_CHAR(l_error_code)) ;
420: fnd_message.set_token ('ERROR_MESSAGE',
421: l_error_message) ;
422: l_fnd_message:= FND_MESSAGE.get ;
423:
424:
425: xnp_message.update_status(
426: p_msg_id=>l_msg_header.message_id,

Line 428: p_error_desc=>l_fnd_message,

424:
425: xnp_message.update_status(
426: p_msg_id=>l_msg_header.message_id,
427: p_status=>'FAILED',
428: p_error_desc=>l_fnd_message,
429: p_order_id=>l_order_id,
430: p_wi_instance_id=>l_wi_instance_id,
431: p_fa_instance_id=>l_fa_instance_id) ;
432:

Line 435: fnd_message.set_name ('XNP',

431: p_fa_instance_id=>l_fa_instance_id) ;
432:
433: WHEN e_DEFAULT_PROCESSING_ERROR THEN
434: ROLLBACK to after_pop;
435: fnd_message.set_name ('XNP',
436: 'DFLT_PROCESSING_ERROR') ;
437: fnd_message.set_token ('MSG_CODE',
438: l_msg_header.message_code) ;
439: fnd_message.set_token ('ERROR_CODE',

Line 437: fnd_message.set_token ('MSG_CODE',

433: WHEN e_DEFAULT_PROCESSING_ERROR THEN
434: ROLLBACK to after_pop;
435: fnd_message.set_name ('XNP',
436: 'DFLT_PROCESSING_ERROR') ;
437: fnd_message.set_token ('MSG_CODE',
438: l_msg_header.message_code) ;
439: fnd_message.set_token ('ERROR_CODE',
440: TO_CHAR(l_error_code)) ;
441: fnd_message.set_token ('ERROR_MESSAGE',

Line 439: fnd_message.set_token ('ERROR_CODE',

435: fnd_message.set_name ('XNP',
436: 'DFLT_PROCESSING_ERROR') ;
437: fnd_message.set_token ('MSG_CODE',
438: l_msg_header.message_code) ;
439: fnd_message.set_token ('ERROR_CODE',
440: TO_CHAR(l_error_code)) ;
441: fnd_message.set_token ('ERROR_MESSAGE',
442: l_error_message) ;
443: l_fnd_message:= FND_MESSAGE.get ;

Line 441: fnd_message.set_token ('ERROR_MESSAGE',

437: fnd_message.set_token ('MSG_CODE',
438: l_msg_header.message_code) ;
439: fnd_message.set_token ('ERROR_CODE',
440: TO_CHAR(l_error_code)) ;
441: fnd_message.set_token ('ERROR_MESSAGE',
442: l_error_message) ;
443: l_fnd_message:= FND_MESSAGE.get ;
444:
445: xnp_message.update_status(

Line 443: l_fnd_message:= FND_MESSAGE.get ;

439: fnd_message.set_token ('ERROR_CODE',
440: TO_CHAR(l_error_code)) ;
441: fnd_message.set_token ('ERROR_MESSAGE',
442: l_error_message) ;
443: l_fnd_message:= FND_MESSAGE.get ;
444:
445: xnp_message.update_status(
446: p_msg_id=>l_msg_header.message_id,
447: p_status=>'FAILED',

Line 448: p_error_desc=>l_fnd_message,

444:
445: xnp_message.update_status(
446: p_msg_id=>l_msg_header.message_id,
447: p_status=>'FAILED',
448: p_error_desc=>l_fnd_message,
449: p_order_id=>l_order_id,
450: p_wi_instance_id=>l_wi_instance_id,
451: p_fa_instance_id=>l_fa_instance_id) ;
452:

Line 457: fnd_message.set_name ('XNP',

453: WHEN OTHERS THEN
454:
455: ROLLBACK ;
456: l_fatal_error := TRUE;
457: fnd_message.set_name ('XNP',
458: 'MSG_SERVER_EXCEPTION') ;
459: fnd_message.set_token ('MSG_ID',
460: l_msg_header.message_id) ;
461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

Line 459: fnd_message.set_token ('MSG_ID',

455: ROLLBACK ;
456: l_fatal_error := TRUE;
457: fnd_message.set_name ('XNP',
458: 'MSG_SERVER_EXCEPTION') ;
459: fnd_message.set_token ('MSG_ID',
460: l_msg_header.message_id) ;
461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
462: fnd_message.set_token ('ERROR_MESSAGE',
463: SQLERRM) ;

Line 461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

457: fnd_message.set_name ('XNP',
458: 'MSG_SERVER_EXCEPTION') ;
459: fnd_message.set_token ('MSG_ID',
460: l_msg_header.message_id) ;
461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
462: fnd_message.set_token ('ERROR_MESSAGE',
463: SQLERRM) ;
464: l_fnd_message:= FND_MESSAGE.get ;
465:

Line 462: fnd_message.set_token ('ERROR_MESSAGE',

458: 'MSG_SERVER_EXCEPTION') ;
459: fnd_message.set_token ('MSG_ID',
460: l_msg_header.message_id) ;
461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
462: fnd_message.set_token ('ERROR_MESSAGE',
463: SQLERRM) ;
464: l_fnd_message:= FND_MESSAGE.get ;
465:
466: xnp_message.update_status(

Line 464: l_fnd_message:= FND_MESSAGE.get ;

460: l_msg_header.message_id) ;
461: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
462: fnd_message.set_token ('ERROR_MESSAGE',
463: SQLERRM) ;
464: l_fnd_message:= FND_MESSAGE.get ;
465:
466: xnp_message.update_status(
467: p_msg_id=>l_msg_header.message_id,
468: p_status=>'FAILED',

Line 469: p_error_desc=>l_fnd_message,

465:
466: xnp_message.update_status(
467: p_msg_id=>l_msg_header.message_id,
468: p_status=>'FAILED',
469: p_error_desc=>l_fnd_message,
470: p_order_id=>l_order_id,
471: p_wi_instance_id=>l_wi_instance_id,
472: p_fa_instance_id=>l_fa_instance_id) ;
473: END;

Line 520: l_fnd_message VARCHAR2(4000) := NULL ;

516: l_msg_text VARCHAR2(32767) ;
517: l_num_apps NUMBER := 0;
518: l_operation VARCHAR2(4000) := NULL ;
519: l_description VARCHAR2(4000) := NULL ;
520: l_fnd_message VARCHAR2(4000) := NULL ;
521:
522: l_order_id NUMBER;
523: l_wi_instance_id NUMBER;
524: l_fa_instance_id NUMBER ;

Line 630: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;

626: EXCEPTION
627: WHEN e_MSG_DELIVERY_ERROR THEN
628: ROLLBACK to deliver_msg ;
629:
630: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
631: fnd_message.set_token ('CALLBACK',
632: app.callback_proc_name);
633: fnd_message.set_token ('ERROR_CODE',
634: TO_CHAR(l_error_code)) ;

Line 631: fnd_message.set_token ('CALLBACK',

627: WHEN e_MSG_DELIVERY_ERROR THEN
628: ROLLBACK to deliver_msg ;
629:
630: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
631: fnd_message.set_token ('CALLBACK',
632: app.callback_proc_name);
633: fnd_message.set_token ('ERROR_CODE',
634: TO_CHAR(l_error_code)) ;
635: fnd_message.set_token ('ERROR_MESSAGE',

Line 633: fnd_message.set_token ('ERROR_CODE',

629:
630: fnd_message.set_name ('XNP', 'MSG_DELIVERY_ERROR') ;
631: fnd_message.set_token ('CALLBACK',
632: app.callback_proc_name);
633: fnd_message.set_token ('ERROR_CODE',
634: TO_CHAR(l_error_code)) ;
635: fnd_message.set_token ('ERROR_MESSAGE',
636: l_error_message) ;
637:

Line 635: fnd_message.set_token ('ERROR_MESSAGE',

631: fnd_message.set_token ('CALLBACK',
632: app.callback_proc_name);
633: fnd_message.set_token ('ERROR_CODE',
634: TO_CHAR(l_error_code)) ;
635: fnd_message.set_token ('ERROR_MESSAGE',
636: l_error_message) ;
637:
638: l_fnd_message:= fnd_message.get ;
639:

Line 638: l_fnd_message:= fnd_message.get ;

634: TO_CHAR(l_error_code)) ;
635: fnd_message.set_token ('ERROR_MESSAGE',
636: l_error_message) ;
637:
638: l_fnd_message:= fnd_message.get ;
639:
640: xnp_message.update_status(
641: p_msg_id=>l_msg_header.message_id,
642: p_status=>'FAILED',

Line 643: p_error_desc=>l_fnd_message,

639:
640: xnp_message.update_status(
641: p_msg_id=>l_msg_header.message_id,
642: p_status=>'FAILED',
643: p_error_desc=>l_fnd_message,
644: p_order_id=>l_order_id,
645: p_wi_instance_id=>l_wi_instance_id,
646: p_fa_instance_id=>l_fa_instance_id) ;
647:

Line 652: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;

648:
649: WHEN e_MSG_PROCESSING_ERROR THEN
650: ROLLBACK to deliver_msg ;
651:
652: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
653: fnd_message.set_token ('MSG_CODE',
654: l_msg_header.message_code) ;
655: fnd_message.set_token ('ERROR_CODE',
656: TO_CHAR(l_error_code)) ;

Line 653: fnd_message.set_token ('MSG_CODE',

649: WHEN e_MSG_PROCESSING_ERROR THEN
650: ROLLBACK to deliver_msg ;
651:
652: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
653: fnd_message.set_token ('MSG_CODE',
654: l_msg_header.message_code) ;
655: fnd_message.set_token ('ERROR_CODE',
656: TO_CHAR(l_error_code)) ;
657: fnd_message.set_token ('ERROR_MESSAGE',

Line 655: fnd_message.set_token ('ERROR_CODE',

651:
652: fnd_message.set_name ('XNP', 'MSG_PROCESSING_ERROR') ;
653: fnd_message.set_token ('MSG_CODE',
654: l_msg_header.message_code) ;
655: fnd_message.set_token ('ERROR_CODE',
656: TO_CHAR(l_error_code)) ;
657: fnd_message.set_token ('ERROR_MESSAGE',
658: l_error_message) ;
659: l_fnd_message := fnd_message.get ;

Line 657: fnd_message.set_token ('ERROR_MESSAGE',

653: fnd_message.set_token ('MSG_CODE',
654: l_msg_header.message_code) ;
655: fnd_message.set_token ('ERROR_CODE',
656: TO_CHAR(l_error_code)) ;
657: fnd_message.set_token ('ERROR_MESSAGE',
658: l_error_message) ;
659: l_fnd_message := fnd_message.get ;
660:
661: xnp_message.update_status(

Line 659: l_fnd_message := fnd_message.get ;

655: fnd_message.set_token ('ERROR_CODE',
656: TO_CHAR(l_error_code)) ;
657: fnd_message.set_token ('ERROR_MESSAGE',
658: l_error_message) ;
659: l_fnd_message := fnd_message.get ;
660:
661: xnp_message.update_status(
662: p_msg_id=>l_msg_header.message_id,
663: p_status=>'FAILED',

Line 664: p_error_desc=>l_fnd_message,

660:
661: xnp_message.update_status(
662: p_msg_id=>l_msg_header.message_id,
663: p_status=>'FAILED',
664: p_error_desc=>l_fnd_message,
665: p_order_id=>l_order_id,
666: p_wi_instance_id=>l_wi_instance_id,
667: p_fa_instance_id=>l_fa_instance_id) ;
668:

Line 672: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;

668:
669: WHEN OTHERS THEN
670:
671: ROLLBACK ;
672: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
673: fnd_message.set_token ('MSG_ID',
674: l_msg_header.message_id) ;
675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;

Line 673: fnd_message.set_token ('MSG_ID',

669: WHEN OTHERS THEN
670:
671: ROLLBACK ;
672: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
673: fnd_message.set_token ('MSG_ID',
674: l_msg_header.message_id) ;
675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
677: l_fnd_message:= FND_MESSAGE.get ;

Line 675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

671: ROLLBACK ;
672: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
673: fnd_message.set_token ('MSG_ID',
674: l_msg_header.message_id) ;
675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
677: l_fnd_message:= FND_MESSAGE.get ;
678:
679: xnp_message.update_statuS(

Line 676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;

672: fnd_message.set_name ('XNP', 'MSG_SERVER_EXCEPTION') ;
673: fnd_message.set_token ('MSG_ID',
674: l_msg_header.message_id) ;
675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
677: l_fnd_message:= FND_MESSAGE.get ;
678:
679: xnp_message.update_statuS(
680: p_msg_id=>l_msg_header.message_id,

Line 677: l_fnd_message:= FND_MESSAGE.get ;

673: fnd_message.set_token ('MSG_ID',
674: l_msg_header.message_id) ;
675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
677: l_fnd_message:= FND_MESSAGE.get ;
678:
679: xnp_message.update_statuS(
680: p_msg_id=>l_msg_header.message_id,
681: p_status=>'FAILED',

Line 682: p_error_desc=>l_fnd_message,

678:
679: xnp_message.update_statuS(
680: p_msg_id=>l_msg_header.message_id,
681: p_status=>'FAILED',
682: p_error_desc=>l_fnd_message,
683: p_order_id=>l_order_id,
684: p_wi_instance_id=>l_wi_instance_id,
685: p_fa_instance_id=>l_fa_instance_id) ;
686: END ;

Line 719: fnd_message.set_name ('XNP',

715:
716: EXCEPTION
717: WHEN e_MSG_VALIDATION_ERROR THEN
718: ROLLBACK to after_pop;
719: fnd_message.set_name ('XNP',
720: 'MSG_VALIDATION_ERROR') ;
721: fnd_message.set_token ('MSG_CODE',
722: l_msg_header.message_code) ;
723: fnd_message.set_token ('ERROR_CODE',

Line 721: fnd_message.set_token ('MSG_CODE',

717: WHEN e_MSG_VALIDATION_ERROR THEN
718: ROLLBACK to after_pop;
719: fnd_message.set_name ('XNP',
720: 'MSG_VALIDATION_ERROR') ;
721: fnd_message.set_token ('MSG_CODE',
722: l_msg_header.message_code) ;
723: fnd_message.set_token ('ERROR_CODE',
724: TO_CHAR(l_error_code)) ;
725: fnd_message.set_token ('ERROR_MESSAGE',

Line 723: fnd_message.set_token ('ERROR_CODE',

719: fnd_message.set_name ('XNP',
720: 'MSG_VALIDATION_ERROR') ;
721: fnd_message.set_token ('MSG_CODE',
722: l_msg_header.message_code) ;
723: fnd_message.set_token ('ERROR_CODE',
724: TO_CHAR(l_error_code)) ;
725: fnd_message.set_token ('ERROR_MESSAGE',
726: l_error_message) ;
727: l_fnd_message:= FND_MESSAGE.get ;

Line 725: fnd_message.set_token ('ERROR_MESSAGE',

721: fnd_message.set_token ('MSG_CODE',
722: l_msg_header.message_code) ;
723: fnd_message.set_token ('ERROR_CODE',
724: TO_CHAR(l_error_code)) ;
725: fnd_message.set_token ('ERROR_MESSAGE',
726: l_error_message) ;
727: l_fnd_message:= FND_MESSAGE.get ;
728:
729:

Line 727: l_fnd_message:= FND_MESSAGE.get ;

723: fnd_message.set_token ('ERROR_CODE',
724: TO_CHAR(l_error_code)) ;
725: fnd_message.set_token ('ERROR_MESSAGE',
726: l_error_message) ;
727: l_fnd_message:= FND_MESSAGE.get ;
728:
729:
730: xnp_message.update_status(
731: p_msg_id=>l_msg_header.message_id,

Line 733: p_error_desc=>l_fnd_message,

729:
730: xnp_message.update_status(
731: p_msg_id=>l_msg_header.message_id,
732: p_status=>'FAILED',
733: p_error_desc=>l_fnd_message,
734: p_order_id=>l_order_id,
735: p_wi_instance_id=>l_wi_instance_id,
736: p_fa_instance_id=>l_fa_instance_id) ;
737:

Line 740: fnd_message.set_name ('XNP',

736: p_fa_instance_id=>l_fa_instance_id) ;
737:
738: WHEN e_DEFAULT_PROCESSING_ERROR THEN
739: ROLLBACK to after_pop;
740: fnd_message.set_name ('XNP',
741: 'DFLT_PROCESSING_ERROR') ;
742: fnd_message.set_token ('MSG_CODE',
743: l_msg_header.message_code) ;
744: fnd_message.set_token ('ERROR_CODE',

Line 742: fnd_message.set_token ('MSG_CODE',

738: WHEN e_DEFAULT_PROCESSING_ERROR THEN
739: ROLLBACK to after_pop;
740: fnd_message.set_name ('XNP',
741: 'DFLT_PROCESSING_ERROR') ;
742: fnd_message.set_token ('MSG_CODE',
743: l_msg_header.message_code) ;
744: fnd_message.set_token ('ERROR_CODE',
745: TO_CHAR(l_error_code)) ;
746: fnd_message.set_token ('ERROR_MESSAGE',

Line 744: fnd_message.set_token ('ERROR_CODE',

740: fnd_message.set_name ('XNP',
741: 'DFLT_PROCESSING_ERROR') ;
742: fnd_message.set_token ('MSG_CODE',
743: l_msg_header.message_code) ;
744: fnd_message.set_token ('ERROR_CODE',
745: TO_CHAR(l_error_code)) ;
746: fnd_message.set_token ('ERROR_MESSAGE',
747: l_error_message) ;
748: l_fnd_message:= FND_MESSAGE.get ;

Line 746: fnd_message.set_token ('ERROR_MESSAGE',

742: fnd_message.set_token ('MSG_CODE',
743: l_msg_header.message_code) ;
744: fnd_message.set_token ('ERROR_CODE',
745: TO_CHAR(l_error_code)) ;
746: fnd_message.set_token ('ERROR_MESSAGE',
747: l_error_message) ;
748: l_fnd_message:= FND_MESSAGE.get ;
749:
750: xnp_message.update_status(

Line 748: l_fnd_message:= FND_MESSAGE.get ;

744: fnd_message.set_token ('ERROR_CODE',
745: TO_CHAR(l_error_code)) ;
746: fnd_message.set_token ('ERROR_MESSAGE',
747: l_error_message) ;
748: l_fnd_message:= FND_MESSAGE.get ;
749:
750: xnp_message.update_status(
751: p_msg_id=>l_msg_header.message_id,
752: p_status=>'FAILED',

Line 753: p_error_desc=>l_fnd_message,

749:
750: xnp_message.update_status(
751: p_msg_id=>l_msg_header.message_id,
752: p_status=>'FAILED',
753: p_error_desc=>l_fnd_message,
754: p_order_id=>l_order_id,
755: p_wi_instance_id=>l_wi_instance_id,
756: p_fa_instance_id=>l_fa_instance_id) ;
757:

Line 761: fnd_message.set_name ('XNP',

757:
758: WHEN OTHERS THEN
759:
760: ROLLBACK ;
761: fnd_message.set_name ('XNP',
762: 'MSG_SERVER_EXCEPTION') ;
763: fnd_message.set_token ('MSG_ID',
764: l_msg_header.message_id) ;
765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

Line 763: fnd_message.set_token ('MSG_ID',

759:
760: ROLLBACK ;
761: fnd_message.set_name ('XNP',
762: 'MSG_SERVER_EXCEPTION') ;
763: fnd_message.set_token ('MSG_ID',
764: l_msg_header.message_id) ;
765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
766: fnd_message.set_token ('ERROR_MESSAGE',
767: SQLERRM) ;

Line 765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;

761: fnd_message.set_name ('XNP',
762: 'MSG_SERVER_EXCEPTION') ;
763: fnd_message.set_token ('MSG_ID',
764: l_msg_header.message_id) ;
765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
766: fnd_message.set_token ('ERROR_MESSAGE',
767: SQLERRM) ;
768: l_fnd_message:= FND_MESSAGE.get ;
769:

Line 766: fnd_message.set_token ('ERROR_MESSAGE',

762: 'MSG_SERVER_EXCEPTION') ;
763: fnd_message.set_token ('MSG_ID',
764: l_msg_header.message_id) ;
765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
766: fnd_message.set_token ('ERROR_MESSAGE',
767: SQLERRM) ;
768: l_fnd_message:= FND_MESSAGE.get ;
769:
770: xnp_message.update_status(

Line 768: l_fnd_message:= FND_MESSAGE.get ;

764: l_msg_header.message_id) ;
765: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
766: fnd_message.set_token ('ERROR_MESSAGE',
767: SQLERRM) ;
768: l_fnd_message:= FND_MESSAGE.get ;
769:
770: xnp_message.update_status(
771: p_msg_id=>l_msg_header.message_id,
772: p_status=>'FAILED',

Line 773: p_error_desc=>l_fnd_message,

769:
770: xnp_message.update_status(
771: p_msg_id=>l_msg_header.message_id,
772: p_status=>'FAILED',
773: p_error_desc=>l_fnd_message,
774: p_order_id=>l_order_id,
775: p_wi_instance_id=>l_wi_instance_id,
776: p_fa_instance_id=>l_fa_instance_id) ;
777: END;

Line 888: l_fnd_message VARCHAR2(4000) ;

884:
885: l_wf_activity VARCHAR2(256) ;
886: l_wf_type VARCHAR2(256) ;
887: l_wf_key VARCHAR2(256) ;
888: l_fnd_message VARCHAR2(4000) ;
889:
890: -- Should change to CLOB later
891:
892: l_msg_text VARCHAR2(32767) ;

Line 957: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;

953: END IF ;
954:
955: EXCEPTION
956: WHEN e_workflow_parameters_invalid THEN
957: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;
959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;
960: l_fnd_message := FND_MESSAGE.get ;
961:

Line 958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;

954:
955: EXCEPTION
956: WHEN e_workflow_parameters_invalid THEN
957: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;
959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;
960: l_fnd_message := FND_MESSAGE.get ;
961:
962: xnp_message.update_status(p_message_id,

Line 959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;

955: EXCEPTION
956: WHEN e_workflow_parameters_invalid THEN
957: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;
959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;
960: l_fnd_message := FND_MESSAGE.get ;
961:
962: xnp_message.update_status(p_message_id,
963: 'FAILED',

Line 960: l_fnd_message := FND_MESSAGE.get ;

956: WHEN e_workflow_parameters_invalid THEN
957: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;
959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;
960: l_fnd_message := FND_MESSAGE.get ;
961:
962: xnp_message.update_status(p_message_id,
963: 'FAILED',
964: l_fnd_message) ;

Line 964: l_fnd_message) ;

960: l_fnd_message := FND_MESSAGE.get ;
961:
962: xnp_message.update_status(p_message_id,
963: 'FAILED',
964: l_fnd_message) ;
965:
966: xnp_message.update_status(p_msg_id=>l_msg_header.message_id,
967: p_status=>'FAILED',
968: p_error_desc=>l_fnd_message) ;

Line 968: p_error_desc=>l_fnd_message) ;

964: l_fnd_message) ;
965:
966: xnp_message.update_status(p_msg_id=>l_msg_header.message_id,
967: p_status=>'FAILED',
968: p_error_desc=>l_fnd_message) ;
969:
970: x_error_code := xnp_errors.g_invalid_workflow ;
971: x_error_message := l_fnd_message ;
972:

Line 971: x_error_message := l_fnd_message ;

967: p_status=>'FAILED',
968: p_error_desc=>l_fnd_message) ;
969:
970: x_error_code := xnp_errors.g_invalid_workflow ;
971: x_error_message := l_fnd_message ;
972:
973: WHEN OTHERS THEN
974: x_error_code := SQLCODE ;
975: x_error_message := SQLERRM ;

Line 1039: l_fnd_message VARCHAR2(4000) := NULL;

1035:
1036: l_wf_activity VARCHAR2(256) ;
1037: l_wf_type VARCHAR2(256) ;
1038: l_wf_key VARCHAR2(256) ;
1039: l_fnd_message VARCHAR2(4000) := NULL;
1040: l_msg_text VARCHAR2(32767) ;
1041: l_msg_header xnp_message.msg_header_rec_type ;
1042: l_sdp_result_code VARCHAR2(3) := NULL;
1043:

Line 1053: l_fnd_message := NULL ;

1049: BEGIN
1050:
1051: x_error_code := 0 ;
1052: x_error_message := NULL ;
1053: l_fnd_message := NULL ;
1054:
1055: xnp_utils.get_wf_instance( p_process_reference, l_wf_type,
1056: l_wf_key, l_wf_activity ) ;
1057:

Line 1081: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;

1077:
1078: EXCEPTION
1079: WHEN e_workflow_parameters_invalid THEN
1080:
1081: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
1082: fnd_message.set_token ('MSG_ID',
1083: l_msg_header.message_id) ;
1084: fnd_message.set_token ('P_REFERENCE',
1085: p_process_reference) ;

Line 1082: fnd_message.set_token ('MSG_ID',

1078: EXCEPTION
1079: WHEN e_workflow_parameters_invalid THEN
1080:
1081: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
1082: fnd_message.set_token ('MSG_ID',
1083: l_msg_header.message_id) ;
1084: fnd_message.set_token ('P_REFERENCE',
1085: p_process_reference) ;
1086: l_fnd_message := FND_MESSAGE.get ;

Line 1084: fnd_message.set_token ('P_REFERENCE',

1080:
1081: fnd_message.set_name ('XNP', 'INVALID_WF_SPECIFIED') ;
1082: fnd_message.set_token ('MSG_ID',
1083: l_msg_header.message_id) ;
1084: fnd_message.set_token ('P_REFERENCE',
1085: p_process_reference) ;
1086: l_fnd_message := FND_MESSAGE.get ;
1087:
1088: xnp_message.update_status(

Line 1086: l_fnd_message := FND_MESSAGE.get ;

1082: fnd_message.set_token ('MSG_ID',
1083: l_msg_header.message_id) ;
1084: fnd_message.set_token ('P_REFERENCE',
1085: p_process_reference) ;
1086: l_fnd_message := FND_MESSAGE.get ;
1087:
1088: xnp_message.update_status(
1089: p_msg_id=>l_msg_header.message_id,
1090: p_status=>'FAILED',

Line 1091: p_error_desc=>l_fnd_message);

1087:
1088: xnp_message.update_status(
1089: p_msg_id=>l_msg_header.message_id,
1090: p_status=>'FAILED',
1091: p_error_desc=>l_fnd_message);
1092:
1093: x_error_code := XNP_ERRORS.G_INVALID_WORKFLOW ;
1094: x_error_message := l_fnd_message ;
1095:

Line 1094: x_error_message := l_fnd_message ;

1090: p_status=>'FAILED',
1091: p_error_desc=>l_fnd_message);
1092:
1093: x_error_code := XNP_ERRORS.G_INVALID_WORKFLOW ;
1094: x_error_message := l_fnd_message ;
1095:
1096: WHEN OTHERS THEN
1097: x_error_code := SQLCODE ;
1098: x_error_message := SQLERRM ;