DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on FND_MESSAGE

Line 118: fnd_file.put_line(fnd_file.log,fnd_message.get);

114: WHERE employee_id = p_new_personid;
115: EXCEPTION
116: WHEN NO_DATA_FOUND THEN
117: po_message_s.sql_error('Not a Valid Buyer','Not a Valid Buyer',l_progress,SQLCODE,SQLERRM);
118: fnd_file.put_line(fnd_file.log,fnd_message.get);
119: x_valid_buyer := 'N';
120: END;
121:
122: IF x_valid_buyer = 'Y' THEN

Line 484: fnd_message.set_name('PO','PO_MUB_MSG_BUYER');

480: SELECT manual_po_num_type
481: INTO po_num_type
482: FROM po_system_parameters;
483:
484: fnd_message.set_name('PO','PO_MUB_MSG_BUYER');
485: l_msg15 := fnd_message.get;
486:
487: l_progress := '003';
488:

Line 485: l_msg15 := fnd_message.get;

481: INTO po_num_type
482: FROM po_system_parameters;
483:
484: fnd_message.set_name('PO','PO_MUB_MSG_BUYER');
485: l_msg15 := fnd_message.get;
486:
487: l_progress := '003';
488:
489: IF g_debug_stmt THEN

Line 1405: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');

1401: SELECT manual_po_num_type
1402: INTO po_num_type
1403: FROM po_system_parameters;
1404:
1405: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1406: l_msg16 := fnd_message.get;
1407:
1408: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1409: l_msg17 := fnd_message.get;

Line 1406: l_msg16 := fnd_message.get;

1402: INTO po_num_type
1403: FROM po_system_parameters;
1404:
1405: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1406: l_msg16 := fnd_message.get;
1407:
1408: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1409: l_msg17 := fnd_message.get;
1410:

Line 1408: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');

1404:
1405: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1406: l_msg16 := fnd_message.get;
1407:
1408: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1409: l_msg17 := fnd_message.get;
1410:
1411: l_progress := '003';
1412:

Line 1409: l_msg17 := fnd_message.get;

1405: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1406: l_msg16 := fnd_message.get;
1407:
1408: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1409: l_msg17 := fnd_message.get;
1410:
1411: l_progress := '003';
1412:
1413: IF g_debug_stmt THEN

Line 2017: fnd_message.set_name('PO','PO_MUB_MSG_DELIVER_TO');

2013: SELECT manual_po_num_type
2014: INTO po_num_type
2015: FROM po_system_parameters;
2016:
2017: fnd_message.set_name('PO','PO_MUB_MSG_DELIVER_TO');
2018: l_msg18 := fnd_message.get;
2019:
2020: l_progress := '003';
2021:

Line 2018: l_msg18 := fnd_message.get;

2014: INTO po_num_type
2015: FROM po_system_parameters;
2016:
2017: fnd_message.set_name('PO','PO_MUB_MSG_DELIVER_TO');
2018: l_msg18 := fnd_message.get;
2019:
2020: l_progress := '003';
2021:
2022: IF g_debug_stmt THEN

Line 2565: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');

2561: PO_DEBUG.debug_var(l_log_head,l_progress,'p_supplier_name',p_supplier_name );
2562:
2563: END IF;
2564:
2565: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2566: l_msg1 := fnd_message.get;
2567:
2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;

Line 2566: l_msg1 := fnd_message.get;

2562:
2563: END IF;
2564:
2565: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2566: l_msg1 := fnd_message.get;
2567:
2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;
2570:

Line 2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');

2564:
2565: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2566: l_msg1 := fnd_message.get;
2567:
2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;
2570:
2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;

Line 2569: l_msg2 := fnd_message.get;

2565: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2566: l_msg1 := fnd_message.get;
2567:
2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;
2570:
2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;
2573:

Line 2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');

2567:
2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;
2570:
2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;
2573:
2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;

Line 2572: l_msg3 := fnd_message.get;

2568: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2569: l_msg2 := fnd_message.get;
2570:
2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;
2573:
2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;
2576:

Line 2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');

2570:
2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;
2573:
2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;
2576:
2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;

Line 2575: l_msg4 := fnd_message.get;

2571: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2572: l_msg3 := fnd_message.get;
2573:
2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;
2576:
2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;
2579:

Line 2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');

2573:
2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;
2576:
2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;
2579:
2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;

Line 2578: l_msg5 := fnd_message.get;

2574: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2575: l_msg4 := fnd_message.get;
2576:
2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;
2579:
2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;
2582:

Line 2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');

2576:
2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;
2579:
2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;
2582:
2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;

Line 2581: l_msg6 := fnd_message.get;

2577: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2578: l_msg5 := fnd_message.get;
2579:
2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;
2582:
2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;
2585:

Line 2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');

2579:
2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;
2582:
2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;
2585:
2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;

Line 2584: l_msg7 := fnd_message.get;

2580: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2581: l_msg6 := fnd_message.get;
2582:
2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;
2585:
2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;
2588:

Line 2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');

2582:
2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;
2585:
2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;
2588:
2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;

Line 2587: l_msg8 := fnd_message.get;

2583: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2584: l_msg7 := fnd_message.get;
2585:
2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;
2588:
2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;
2591:

Line 2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');

2585:
2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;
2588:
2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;
2591:
2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;

Line 2590: l_msg9 := fnd_message.get;

2586: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2587: l_msg8 := fnd_message.get;
2588:
2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;
2591:
2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;
2594:

Line 2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');

2588:
2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;
2591:
2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;
2594:
2595: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2596: l_msg11 := fnd_message.get;

Line 2593: l_msg10 := fnd_message.get;

2589: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2590: l_msg9 := fnd_message.get;
2591:
2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;
2594:
2595: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2596: l_msg11 := fnd_message.get;
2597:

Line 2595: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');

2591:
2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;
2594:
2595: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2596: l_msg11 := fnd_message.get;
2597:
2598: SAVEPOINT Print_SP;
2599:

Line 2596: l_msg11 := fnd_message.get;

2592: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2593: l_msg10 := fnd_message.get;
2594:
2595: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2596: l_msg11 := fnd_message.get;
2597:
2598: SAVEPOINT Print_SP;
2599:
2600: IF (p_update_person = 'BUYER') THEN

Line 2602: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');

2598: SAVEPOINT Print_SP;
2599:
2600: IF (p_update_person = 'BUYER') THEN
2601:
2602: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2603: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2604: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2605:
2606: ELSIF (p_update_person = 'APPROVER') THEN

Line 2603: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);

2599:
2600: IF (p_update_person = 'BUYER') THEN
2601:
2602: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2603: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2604: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2605:
2606: ELSIF (p_update_person = 'APPROVER') THEN
2607:

Line 2604: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);

2600: IF (p_update_person = 'BUYER') THEN
2601:
2602: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2603: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2604: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2605:
2606: ELSIF (p_update_person = 'APPROVER') THEN
2607:
2608: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');

Line 2608: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');

2604: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2605:
2606: ELSIF (p_update_person = 'APPROVER') THEN
2607:
2608: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2609: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2610: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2611:
2612: ELSIF (p_update_person = 'DELIVER TO') THEN

Line 2609: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);

2605:
2606: ELSIF (p_update_person = 'APPROVER') THEN
2607:
2608: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2609: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2610: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2611:
2612: ELSIF (p_update_person = 'DELIVER TO') THEN
2613:

Line 2610: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);

2606: ELSIF (p_update_person = 'APPROVER') THEN
2607:
2608: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2609: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2610: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2611:
2612: ELSIF (p_update_person = 'DELIVER TO') THEN
2613:
2614: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');

Line 2614: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');

2610: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2611:
2612: ELSIF (p_update_person = 'DELIVER TO') THEN
2613:
2614: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2615: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2616: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2617:
2618: ELSIF (p_update_person = 'ALL') THEN

Line 2615: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);

2611:
2612: ELSIF (p_update_person = 'DELIVER TO') THEN
2613:
2614: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2615: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2616: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2617:
2618: ELSIF (p_update_person = 'ALL') THEN
2619:

Line 2616: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);

2612: ELSIF (p_update_person = 'DELIVER TO') THEN
2613:
2614: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2615: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2616: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2617:
2618: ELSIF (p_update_person = 'ALL') THEN
2619:
2620: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');

Line 2620: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');

2616: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2617:
2618: ELSIF (p_update_person = 'ALL') THEN
2619:
2620: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2621: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2622: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2623:
2624: END IF;

Line 2621: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);

2617:
2618: ELSIF (p_update_person = 'ALL') THEN
2619:
2620: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2621: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2622: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2623:
2624: END IF;
2625:

Line 2622: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);

2618: ELSIF (p_update_person = 'ALL') THEN
2619:
2620: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2621: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2622: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2623:
2624: END IF;
2625:
2626: l_progress := '001';

Line 2634: l_msg12 := fnd_message.get;

2630: PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );
2631:
2632: END IF;
2633:
2634: l_msg12 := fnd_message.get;
2635:
2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2637: l_msg13 := fnd_message.get;
2638:

Line 2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');

2632: END IF;
2633:
2634: l_msg12 := fnd_message.get;
2635:
2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2637: l_msg13 := fnd_message.get;
2638:
2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;

Line 2637: l_msg13 := fnd_message.get;

2633:
2634: l_msg12 := fnd_message.get;
2635:
2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2637: l_msg13 := fnd_message.get;
2638:
2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;
2641:

Line 2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');

2635:
2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2637: l_msg13 := fnd_message.get;
2638:
2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;
2641:
2642: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2643: l_msg15 := fnd_message.get;

Line 2640: l_msg14 := fnd_message.get;

2636: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2637: l_msg13 := fnd_message.get;
2638:
2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;
2641:
2642: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2643: l_msg15 := fnd_message.get;
2644:

Line 2642: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');

2638:
2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;
2641:
2642: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2643: l_msg15 := fnd_message.get;
2644:
2645: l_progress := '002';
2646:

Line 2643: l_msg15 := fnd_message.get;

2639: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2640: l_msg14 := fnd_message.get;
2641:
2642: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2643: l_msg15 := fnd_message.get;
2644:
2645: l_progress := '002';
2646:
2647: fnd_file.put_line(fnd_file.output, l_msg1);