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
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:
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
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;
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:
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:
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
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:
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
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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;
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:
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:
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
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
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:
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');
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
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:
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');
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
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:
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');
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;
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:
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';
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:
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;
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:
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;
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:
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:
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);