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
1328: SELECT manual_po_num_type
1329: INTO po_num_type
1330: FROM po_system_parameters;
1331:
1332: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1333: l_msg16 := fnd_message.get;
1334:
1335: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1336: l_msg17 := fnd_message.get;
1329: INTO po_num_type
1330: FROM po_system_parameters;
1331:
1332: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1333: l_msg16 := fnd_message.get;
1334:
1335: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1336: l_msg17 := fnd_message.get;
1337:
1331:
1332: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1333: l_msg16 := fnd_message.get;
1334:
1335: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1336: l_msg17 := fnd_message.get;
1337:
1338: l_progress := '003';
1339:
1332: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
1333: l_msg16 := fnd_message.get;
1334:
1335: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
1336: l_msg17 := fnd_message.get;
1337:
1338: l_progress := '003';
1339:
1340: IF g_debug_stmt THEN
1940: SELECT manual_po_num_type
1941: INTO po_num_type
1942: FROM po_system_parameters;
1943:
1944: fnd_message.set_name('PO','PO_MUB_MSG_DELIVER_TO');
1945: l_msg18 := fnd_message.get;
1946:
1947: l_progress := '003';
1948:
1941: INTO po_num_type
1942: FROM po_system_parameters;
1943:
1944: fnd_message.set_name('PO','PO_MUB_MSG_DELIVER_TO');
1945: l_msg18 := fnd_message.get;
1946:
1947: l_progress := '003';
1948:
1949: IF g_debug_stmt THEN
2488: PO_DEBUG.debug_var(l_log_head,l_progress,'p_supplier_name',p_supplier_name );
2489:
2490: END IF;
2491:
2492: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2493: l_msg1 := fnd_message.get;
2494:
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2489:
2490: END IF;
2491:
2492: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2493: l_msg1 := fnd_message.get;
2494:
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2497:
2491:
2492: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2493: l_msg1 := fnd_message.get;
2494:
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2497:
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2492: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER1');
2493: l_msg1 := fnd_message.get;
2494:
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2497:
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2500:
2494:
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2497:
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2500:
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2495: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
2496: l_msg2 := fnd_message.get;
2497:
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2500:
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2503:
2497:
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2500:
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2503:
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2498: fnd_message.set_name('PO','PO_MUB_MSG_OU');
2499: l_msg3 := fnd_message.get;
2500:
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2503:
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2506:
2500:
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2503:
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2506:
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2501: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
2502: l_msg4 := fnd_message.get;
2503:
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2506:
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2509:
2503:
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2506:
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2509:
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2504: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
2505: l_msg5 := fnd_message.get;
2506:
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2509:
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2512:
2506:
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2509:
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2512:
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2507: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
2508: l_msg6 := fnd_message.get;
2509:
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2512:
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2515:
2509:
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2512:
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2515:
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2510: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
2511: l_msg7 := fnd_message.get;
2512:
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2515:
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2518:
2512:
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2515:
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2518:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2513: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
2514: l_msg8 := fnd_message.get;
2515:
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2518:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2521:
2515:
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2518:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2521:
2522: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2523: l_msg11 := fnd_message.get;
2516: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
2517: l_msg9 := fnd_message.get;
2518:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2521:
2522: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2523: l_msg11 := fnd_message.get;
2524:
2518:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2521:
2522: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2523: l_msg11 := fnd_message.get;
2524:
2525: SAVEPOINT Print_SP;
2526:
2519: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
2520: l_msg10 := fnd_message.get;
2521:
2522: fnd_message.set_name('PO','PO_MUB_MSG_SUPPLIER');
2523: l_msg11 := fnd_message.get;
2524:
2525: SAVEPOINT Print_SP;
2526:
2527: IF (p_update_person = 'BUYER') THEN
2525: SAVEPOINT Print_SP;
2526:
2527: IF (p_update_person = 'BUYER') THEN
2528:
2529: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2530: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2531: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2532:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2526:
2527: IF (p_update_person = 'BUYER') THEN
2528:
2529: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2530: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2531: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2532:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2534:
2527: IF (p_update_person = 'BUYER') THEN
2528:
2529: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER2');
2530: fnd_message.set_token('OLD_BUYER',p_old_buyer_name);
2531: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2532:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2534:
2535: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2531: fnd_message.set_token('NEW_BUYER',p_new_buyer_name);
2532:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2534:
2535: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2536: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2537: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2538:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2532:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2534:
2535: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2536: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2537: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2538:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2540:
2533: ELSIF (p_update_person = 'APPROVER') THEN
2534:
2535: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER3');
2536: fnd_message.set_token('OLD_APPROVER',p_old_buyer_name);
2537: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2538:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2540:
2541: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2537: fnd_message.set_token('NEW_APPROVER',p_new_buyer_name);
2538:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2540:
2541: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2542: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2543: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2544:
2545: ELSIF (p_update_person = 'ALL') THEN
2538:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2540:
2541: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2542: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2543: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2544:
2545: ELSIF (p_update_person = 'ALL') THEN
2546:
2539: ELSIF (p_update_person = 'DELIVER TO') THEN
2540:
2541: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER4');
2542: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_buyer_name);
2543: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2544:
2545: ELSIF (p_update_person = 'ALL') THEN
2546:
2547: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2543: fnd_message.set_token('NEW_DELIVER_TO_PERSON',p_new_buyer_name);
2544:
2545: ELSIF (p_update_person = 'ALL') THEN
2546:
2547: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2548: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2549: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2550:
2551: END IF;
2544:
2545: ELSIF (p_update_person = 'ALL') THEN
2546:
2547: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2548: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2549: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2550:
2551: END IF;
2552:
2545: ELSIF (p_update_person = 'ALL') THEN
2546:
2547: fnd_message.set_name('PO','PO_MUB_MSG_BUYER_HEADER5');
2548: fnd_message.set_token('OLD_PERSON',p_old_buyer_name);
2549: fnd_message.set_token('NEW_PERSON',p_new_buyer_name);
2550:
2551: END IF;
2552:
2553: l_progress := '001';
2557: PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );
2558:
2559: END IF;
2560:
2561: l_msg12 := fnd_message.get;
2562:
2563: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2564: l_msg13 := fnd_message.get;
2565:
2559: END IF;
2560:
2561: l_msg12 := fnd_message.get;
2562:
2563: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2564: l_msg13 := fnd_message.get;
2565:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2560:
2561: l_msg12 := fnd_message.get;
2562:
2563: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2564: l_msg13 := fnd_message.get;
2565:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2568:
2562:
2563: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2564: l_msg13 := fnd_message.get;
2565:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2568:
2569: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2570: l_msg15 := fnd_message.get;
2563: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
2564: l_msg13 := fnd_message.get;
2565:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2568:
2569: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2570: l_msg15 := fnd_message.get;
2571:
2565:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2568:
2569: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2570: l_msg15 := fnd_message.get;
2571:
2572: l_progress := '002';
2573:
2566: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
2567: l_msg14 := fnd_message.get;
2568:
2569: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
2570: l_msg15 := fnd_message.get;
2571:
2572: l_progress := '002';
2573:
2574: fnd_file.put_line(fnd_file.output, l_msg1);