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 1332: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');

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;

Line 1333: l_msg16 := 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:

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

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:

Line 1336: l_msg17 := fnd_message.get;

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

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

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:

Line 1945: l_msg18 := fnd_message.get;

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

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

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;

Line 2493: l_msg1 := 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:

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

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;

Line 2496: l_msg2 := 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:

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

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;

Line 2499: l_msg3 := 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:

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

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;

Line 2502: l_msg4 := 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:

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

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;

Line 2505: l_msg5 := 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:

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

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;

Line 2508: l_msg6 := 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:

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

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;

Line 2511: l_msg7 := 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:

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

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;

Line 2514: l_msg8 := 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:

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

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;

Line 2517: l_msg9 := 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:

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

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;

Line 2520: l_msg10 := 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:

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

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:

Line 2523: l_msg11 := fnd_message.get;

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

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

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

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

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:

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

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

Line 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

Line 2536: fnd_message.set_token('OLD_APPROVER',p_old_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
2540:

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

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

Line 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

Line 2542: fnd_message.set_token('OLD_DELIVER_TO_PERSON',p_old_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
2546:

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

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

Line 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;

Line 2548: fnd_message.set_token('OLD_PERSON',p_old_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;
2552:

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

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

Line 2561: l_msg12 := fnd_message.get;

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:

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

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;

Line 2564: l_msg13 := 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:

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

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;

Line 2567: l_msg14 := 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:

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

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:

Line 2570: l_msg15 := fnd_message.get;

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