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

Line 523: x_error_message := FND_MESSAGE.get;

519:
520: IF l_return_status <> 'S' THEN
521:
522: x_result := -1;
523: x_error_message := FND_MESSAGE.get;
524: return;
525:
526: END IF;
527: */

Line 638: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');

634: fnd_log.string(fnd_log.level_statement,g_log_head,'Exception1 : '||SQLERRM);
635: END IF;
636:
637: x_result:=-1;
638: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
639: /*
640: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
641: WHERE prh.requisition_header_id = prl.requisition_header_id
642: AND prl.requisition_line_id = t_req_lines(i);

Line 644: fnd_message.set_token('REQ_NUM', x_req_num);

640: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
641: WHERE prh.requisition_header_id = prl.requisition_header_id
642: AND prl.requisition_line_id = t_req_lines(i);
643:
644: fnd_message.set_token('REQ_NUM', x_req_num);
645: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
646: */
647: rollback to CHECK_LOCK;
648: x_error_message := fnd_message.get;

Line 645: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

641: WHERE prh.requisition_header_id = prl.requisition_header_id
642: AND prl.requisition_line_id = t_req_lines(i);
643:
644: fnd_message.set_token('REQ_NUM', x_req_num);
645: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
646: */
647: rollback to CHECK_LOCK;
648: x_error_message := fnd_message.get;
649: RETURN;

Line 648: x_error_message := fnd_message.get;

644: fnd_message.set_token('REQ_NUM', x_req_num);
645: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
646: */
647: rollback to CHECK_LOCK;
648: x_error_message := fnd_message.get;
649: RETURN;
650:
651: WHEN OTHERS THEN
652: /* This is to see if req line is locked */

Line 660: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');

656:
657: if (SQLCODE=-54)
658: THEN
659: x_result:=-1;
660: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
661: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
662: WHERE prh.requisition_header_id = prl.requisition_header_id
663: AND prl.requisition_line_id = t_req_lines(i);
664:

Line 665: fnd_message.set_token('REQ_NUM', x_req_num);

661: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
662: WHERE prh.requisition_header_id = prl.requisition_header_id
663: AND prl.requisition_line_id = t_req_lines(i);
664:
665: fnd_message.set_token('REQ_NUM', x_req_num);
666: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
667:
668: x_error_message := fnd_message.get;
669: rollback to CHECK_LOCK;

Line 666: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

662: WHERE prh.requisition_header_id = prl.requisition_header_id
663: AND prl.requisition_line_id = t_req_lines(i);
664:
665: fnd_message.set_token('REQ_NUM', x_req_num);
666: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
667:
668: x_error_message := fnd_message.get;
669: rollback to CHECK_LOCK;
670: RETURN;

Line 668: x_error_message := fnd_message.get;

664:
665: fnd_message.set_token('REQ_NUM', x_req_num);
666: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
667:
668: x_error_message := fnd_message.get;
669: rollback to CHECK_LOCK;
670: RETURN;
671: else
672: x_result:=-1;

Line 688: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');

684: if (x_req_in_pool_flag='N')
685: then
686: /* The req line has been auto created already. */
687: x_result:=-1;
688: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
689: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
690: WHERE prh.requisition_header_id = prl.requisition_header_id
691: AND prl.requisition_line_id = t_req_lines(i);
692:

Line 699: fnd_message.set_token('REQ_NUM', x_req_num);

695: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
696: END IF;
697:
698:
699: fnd_message.set_token('REQ_NUM', x_req_num);
700: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
701:
702:
703: x_error_message := fnd_message.get;

Line 700: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

696: END IF;
697:
698:
699: fnd_message.set_token('REQ_NUM', x_req_num);
700: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
701:
702:
703: x_error_message := fnd_message.get;
704: ROLLBACK TO CHECK_LOCK;

Line 703: x_error_message := fnd_message.get;

699: fnd_message.set_token('REQ_NUM', x_req_num);
700: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
701:
702:
703: x_error_message := fnd_message.get;
704: ROLLBACK TO CHECK_LOCK;
705: RETURN;
706:
707: elsif (x_cancel_flag = 'Y') then

Line 710: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');

706:
707: elsif (x_cancel_flag = 'Y') then
708: /* The req line has been cancelled. */
709: x_result:=-1;
710: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
711: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
712: WHERE prh.requisition_header_id = prl.requisition_header_id
713: AND prl.requisition_line_id = t_req_lines(i);
714:

Line 715: fnd_message.set_token('REQ_NUM', x_req_num);

711: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
712: WHERE prh.requisition_header_id = prl.requisition_header_id
713: AND prl.requisition_line_id = t_req_lines(i);
714:
715: fnd_message.set_token('REQ_NUM', x_req_num);
716: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
717:
718:
719: x_error_message := fnd_message.get;

Line 716: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

712: WHERE prh.requisition_header_id = prl.requisition_header_id
713: AND prl.requisition_line_id = t_req_lines(i);
714:
715: fnd_message.set_token('REQ_NUM', x_req_num);
716: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
717:
718:
719: x_error_message := fnd_message.get;
720: ROLLBACK TO CHECK_LOCK;

Line 719: x_error_message := fnd_message.get;

715: fnd_message.set_token('REQ_NUM', x_req_num);
716: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
717:
718:
719: x_error_message := fnd_message.get;
720: ROLLBACK TO CHECK_LOCK;
721: RETURN;
722:
723: elsif (x_closed_code = 'FINALLY CLOSED') then

Line 726: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');

722:
723: elsif (x_closed_code = 'FINALLY CLOSED') then
724: /* The req line has been auto created already. */
725: x_result:=-1;
726: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
727: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
728: WHERE prh.requisition_header_id = prl.requisition_header_id
729: AND prl.requisition_line_id = t_req_lines(i);
730:

Line 731: fnd_message.set_token('REQ_NUM', x_req_num);

727: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
728: WHERE prh.requisition_header_id = prl.requisition_header_id
729: AND prl.requisition_line_id = t_req_lines(i);
730:
731: fnd_message.set_token('REQ_NUM', x_req_num);
732: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
733:
734:
735: x_error_message := fnd_message.get;

Line 732: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

728: WHERE prh.requisition_header_id = prl.requisition_header_id
729: AND prl.requisition_line_id = t_req_lines(i);
730:
731: fnd_message.set_token('REQ_NUM', x_req_num);
732: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
733:
734:
735: x_error_message := fnd_message.get;
736: ROLLBACK TO CHECK_LOCK;

Line 735: x_error_message := fnd_message.get;

731: fnd_message.set_token('REQ_NUM', x_req_num);
732: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
733:
734:
735: x_error_message := fnd_message.get;
736: ROLLBACK TO CHECK_LOCK;
737: RETURN;
738:
739: end if;

Line 1393: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;

1389:
1390: x_result := -1;
1391: --
1392: IF (x_error_message IS NULL) THEN
1393: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
1394: END IF;
1395: --
1396: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
1397: -- logme( 'In Exception of create_negotiation() - progress is ' || x_progress || ' sqlcode is ' || SQLCODE);

Line 2596: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');

2592: fnd_log.string(fnd_log.level_statement,g_log_head,'Excep 1 : '||SQLERRM);
2593: END IF;
2594:
2595: x_result:=-1;
2596: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
2597: rollback to CHECK_LOCK;
2598: x_error_message := fnd_message.get;
2599: RETURN;
2600:

Line 2598: x_error_message := fnd_message.get;

2594:
2595: x_result:=-1;
2596: fnd_message.set_name('PO', 'PO_ALL_REQ_LINE_DLTD_CANT_AC');
2597: rollback to CHECK_LOCK;
2598: x_error_message := fnd_message.get;
2599: RETURN;
2600:
2601: WHEN OTHERS THEN
2602: /* This is to see if req line is locked */

Line 2610: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');

2606:
2607: if (SQLCODE=-54)
2608: THEN
2609: x_result:=-1;
2610: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_LOCKED_CANT_AC');
2611: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2612: WHERE prh.requisition_header_id = prl.requisition_header_id
2613: AND prl.requisition_line_id = p_req_line_id;
2614:

Line 2615: fnd_message.set_token('REQ_NUM', x_req_num);

2611: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2612: WHERE prh.requisition_header_id = prl.requisition_header_id
2613: AND prl.requisition_line_id = p_req_line_id;
2614:
2615: fnd_message.set_token('REQ_NUM', x_req_num);
2616: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2617:
2618: x_error_message := fnd_message.get;
2619: rollback to CHECK_LOCK;

Line 2616: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

2612: WHERE prh.requisition_header_id = prl.requisition_header_id
2613: AND prl.requisition_line_id = p_req_line_id;
2614:
2615: fnd_message.set_token('REQ_NUM', x_req_num);
2616: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2617:
2618: x_error_message := fnd_message.get;
2619: rollback to CHECK_LOCK;
2620: RETURN;

Line 2618: x_error_message := fnd_message.get;

2614:
2615: fnd_message.set_token('REQ_NUM', x_req_num);
2616: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2617:
2618: x_error_message := fnd_message.get;
2619: rollback to CHECK_LOCK;
2620: RETURN;
2621: else
2622: x_result:=-1;

Line 2632: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');

2628: if (x_req_in_pool_flag='N')
2629: then
2630: /* The req line has been auto created already. */
2631: x_result:=-1;
2632: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_ALREADY_AC');
2633: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2634: WHERE prh.requisition_header_id = prl.requisition_header_id
2635: AND prl.requisition_line_id = p_req_line_id;
2636:

Line 2642: fnd_message.set_token('REQ_NUM', x_req_num);

2638: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num : '||x_req_num);
2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
2640: END IF;
2641:
2642: fnd_message.set_token('REQ_NUM', x_req_num);
2643: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2644:
2645:
2646: x_error_message := fnd_message.get;

Line 2643: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

2639: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num : '||x_line_num);
2640: END IF;
2641:
2642: fnd_message.set_token('REQ_NUM', x_req_num);
2643: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2644:
2645:
2646: x_error_message := fnd_message.get;
2647: ROLLBACK TO CHECK_LOCK;

Line 2646: x_error_message := fnd_message.get;

2642: fnd_message.set_token('REQ_NUM', x_req_num);
2643: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2644:
2645:
2646: x_error_message := fnd_message.get;
2647: ROLLBACK TO CHECK_LOCK;
2648: RETURN;
2649:
2650: elsif (x_cancel_flag = 'Y') then

Line 2653: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');

2649:
2650: elsif (x_cancel_flag = 'Y') then
2651: /* The req line has been cancelled. */
2652: x_result:=-1;
2653: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_CNCLD_CANT_AC');
2654: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2655: WHERE prh.requisition_header_id = prl.requisition_header_id
2656: AND prl.requisition_line_id = p_req_line_id;
2657:

Line 2663: fnd_message.set_token('REQ_NUM', x_req_num);

2659: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num1 : '||x_req_num);
2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);
2661: END IF;
2662:
2663: fnd_message.set_token('REQ_NUM', x_req_num);
2664: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2665:
2666:
2667: x_error_message := fnd_message.get;

Line 2664: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

2660: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num1 : '||x_line_num);
2661: END IF;
2662:
2663: fnd_message.set_token('REQ_NUM', x_req_num);
2664: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2665:
2666:
2667: x_error_message := fnd_message.get;
2668: ROLLBACK TO CHECK_LOCK;

Line 2667: x_error_message := fnd_message.get;

2663: fnd_message.set_token('REQ_NUM', x_req_num);
2664: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2665:
2666:
2667: x_error_message := fnd_message.get;
2668: ROLLBACK TO CHECK_LOCK;
2669: RETURN;
2670:
2671: elsif (x_closed_code = 'FINALLY CLOSED') then

Line 2674: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');

2670:
2671: elsif (x_closed_code = 'FINALLY CLOSED') then
2672: /* The req line has been auto created already. */
2673: x_result:=-1;
2674: fnd_message.set_name('PO', 'PO_ALL_RQ_LINE_FCLSD_CANT_AC');
2675: SELECT prh.segment1,prl.line_num INTO x_req_num,x_line_num FROM po_requisition_headers_all prh,po_requisition_lines_all prl
2676: WHERE prh.requisition_header_id = prl.requisition_header_id
2677: AND prl.requisition_line_id = p_req_line_id;
2678:

Line 2684: fnd_message.set_token('REQ_NUM', x_req_num);

2680: fnd_log.string(fnd_log.level_statement,g_log_head,'x_req_num2 : '||x_req_num);
2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);
2682: END IF;
2683:
2684: fnd_message.set_token('REQ_NUM', x_req_num);
2685: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2686:
2687:
2688: x_error_message := fnd_message.get;

Line 2685: fnd_message.set_token('REQ_LINE_NUM',x_line_num);

2681: fnd_log.string(fnd_log.level_statement,g_log_head,'x_line_num2 : '||x_line_num);
2682: END IF;
2683:
2684: fnd_message.set_token('REQ_NUM', x_req_num);
2685: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2686:
2687:
2688: x_error_message := fnd_message.get;
2689: ROLLBACK TO CHECK_LOCK;

Line 2688: x_error_message := fnd_message.get;

2684: fnd_message.set_token('REQ_NUM', x_req_num);
2685: fnd_message.set_token('REQ_LINE_NUM',x_line_num);
2686:
2687:
2688: x_error_message := fnd_message.get;
2689: ROLLBACK TO CHECK_LOCK;
2690: RETURN;
2691:
2692: end if;

Line 3144: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;

3140:
3141: x_result := -1;
3142:
3143: IF (x_error_message IS NULL) THEN
3144: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
3145: END IF;
3146: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
3147: -- logme( 'In Exception of create_negotiation() - progress is ' || x_progress || ' sqlcode is ' || SQLCODE);
3148: END add_line_to_negotiation;