DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on FND_MESSAGE

Line 419: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER');

415: SELECT manual_req_num_type
416: INTO req_num_type
417: FROM po_system_parameters;
418:
419: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER');
420: l_msg15 := fnd_message.get;
421:
422: l_progress := '003';
423:

Line 420: l_msg15 := fnd_message.get;

416: INTO req_num_type
417: FROM po_system_parameters;
418:
419: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER');
420: l_msg15 := fnd_message.get;
421:
422: l_progress := '003';
423:
424: IF g_debug_stmt THEN

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

845: SELECT manual_req_num_type
846: INTO req_num_type
847: FROM po_system_parameters;
848:
849: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
850: l_msg16 := fnd_message.get;
851:
852: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
853: l_msg17 := fnd_message.get;

Line 850: l_msg16 := fnd_message.get;

846: INTO req_num_type
847: FROM po_system_parameters;
848:
849: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
850: l_msg16 := fnd_message.get;
851:
852: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
853: l_msg17 := fnd_message.get;
854:

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

848:
849: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
850: l_msg16 := fnd_message.get;
851:
852: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
853: l_msg17 := fnd_message.get;
854:
855: l_progress := '003';
856:

Line 853: l_msg17 := fnd_message.get;

849: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
850: l_msg16 := fnd_message.get;
851:
852: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
853: l_msg17 := fnd_message.get;
854:
855: l_progress := '003';
856:
857: IF g_debug_stmt THEN

Line 1219: fnd_message.set_name('PO','PO_MUB_MSG_REQUESTOR');

1215: SELECT manual_req_num_type
1216: INTO req_num_type
1217: FROM po_system_parameters;
1218:
1219: fnd_message.set_name('PO','PO_MUB_MSG_REQUESTOR');
1220: l_msg18 := fnd_message.get;
1221:
1222: l_progress := '003';
1223:

Line 1220: l_msg18 := fnd_message.get;

1216: INTO req_num_type
1217: FROM po_system_parameters;
1218:
1219: fnd_message.set_name('PO','PO_MUB_MSG_REQUESTOR');
1220: l_msg18 := fnd_message.get;
1221:
1222: l_progress := '003';
1223:
1224: IF g_debug_stmt THEN

Line 1531: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');

1527: PO_DEBUG.debug_var(l_log_head,l_progress,'p_date_to', p_date_to);
1528:
1529: END IF;
1530:
1531: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1532: l_msg1 := fnd_message.get;
1533:
1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;

Line 1532: l_msg1 := fnd_message.get;

1528:
1529: END IF;
1530:
1531: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1532: l_msg1 := fnd_message.get;
1533:
1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;
1536:

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

1530:
1531: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1532: l_msg1 := fnd_message.get;
1533:
1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;
1536:
1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;

Line 1535: l_msg2 := fnd_message.get;

1531: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1532: l_msg1 := fnd_message.get;
1533:
1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;
1536:
1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;
1539:

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

1533:
1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;
1536:
1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;
1539:
1540: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1541: l_msg4 := fnd_message.get;

Line 1538: l_msg3 := fnd_message.get;

1534: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1535: l_msg2 := fnd_message.get;
1536:
1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;
1539:
1540: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1541: l_msg4 := fnd_message.get;
1542:

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

1536:
1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;
1539:
1540: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1541: l_msg4 := fnd_message.get;
1542:
1543:
1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');

Line 1541: l_msg4 := fnd_message.get;

1537: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1538: l_msg3 := fnd_message.get;
1539:
1540: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1541: l_msg4 := fnd_message.get;
1542:
1543:
1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1545: l_msg5 := fnd_message.get;

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

1540: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1541: l_msg4 := fnd_message.get;
1542:
1543:
1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1545: l_msg5 := fnd_message.get;
1546:
1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;

Line 1545: l_msg5 := fnd_message.get;

1541: l_msg4 := fnd_message.get;
1542:
1543:
1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1545: l_msg5 := fnd_message.get;
1546:
1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;
1549:

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

1543:
1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1545: l_msg5 := fnd_message.get;
1546:
1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;
1549:
1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;

Line 1548: l_msg6 := fnd_message.get;

1544: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1545: l_msg5 := fnd_message.get;
1546:
1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;
1549:
1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;
1552:

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

1546:
1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;
1549:
1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;
1552:
1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;

Line 1551: l_msg7 := fnd_message.get;

1547: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1548: l_msg6 := fnd_message.get;
1549:
1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;
1552:
1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;
1555:

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

1549:
1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;
1552:
1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;
1555:
1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;

Line 1554: l_msg8 := fnd_message.get;

1550: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1551: l_msg7 := fnd_message.get;
1552:
1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;
1555:
1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;
1558:

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

1552:
1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;
1555:
1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;
1558:
1559: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1560: l_msg10 := fnd_message.get;

Line 1557: l_msg9 := fnd_message.get;

1553: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1554: l_msg8 := fnd_message.get;
1555:
1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;
1558:
1559: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1560: l_msg10 := fnd_message.get;
1561:

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

1555:
1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;
1558:
1559: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1560: l_msg10 := fnd_message.get;
1561:
1562: SAVEPOINT Print_SP;
1563:

Line 1560: l_msg10 := fnd_message.get;

1556: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1557: l_msg9 := fnd_message.get;
1558:
1559: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1560: l_msg10 := fnd_message.get;
1561:
1562: SAVEPOINT Print_SP;
1563:
1564: IF (p_update_person = 'PREPARER') THEN

Line 1566: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');

1562: SAVEPOINT Print_SP;
1563:
1564: IF (p_update_person = 'PREPARER') THEN
1565:
1566: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1567: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1568: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1569:
1570: ELSIF (p_update_person = 'APPROVER') THEN

Line 1567: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);

1563:
1564: IF (p_update_person = 'PREPARER') THEN
1565:
1566: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1567: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1568: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1569:
1570: ELSIF (p_update_person = 'APPROVER') THEN
1571:

Line 1568: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);

1564: IF (p_update_person = 'PREPARER') THEN
1565:
1566: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1567: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1568: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1569:
1570: ELSIF (p_update_person = 'APPROVER') THEN
1571:
1572: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');

Line 1572: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');

1568: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1569:
1570: ELSIF (p_update_person = 'APPROVER') THEN
1571:
1572: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1573: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1574: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1575:
1576: ELSIF (p_update_person = 'REQUESTOR') THEN

Line 1573: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);

1569:
1570: ELSIF (p_update_person = 'APPROVER') THEN
1571:
1572: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1573: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1574: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1575:
1576: ELSIF (p_update_person = 'REQUESTOR') THEN
1577:

Line 1574: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);

1570: ELSIF (p_update_person = 'APPROVER') THEN
1571:
1572: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1573: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1574: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1575:
1576: ELSIF (p_update_person = 'REQUESTOR') THEN
1577:
1578: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');

Line 1578: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');

1574: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1575:
1576: ELSIF (p_update_person = 'REQUESTOR') THEN
1577:
1578: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1579: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1580: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1581:
1582: ELSIF (p_update_person = 'ALL') THEN

Line 1579: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);

1575:
1576: ELSIF (p_update_person = 'REQUESTOR') THEN
1577:
1578: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1579: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1580: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1581:
1582: ELSIF (p_update_person = 'ALL') THEN
1583:

Line 1580: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);

1576: ELSIF (p_update_person = 'REQUESTOR') THEN
1577:
1578: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1579: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1580: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1581:
1582: ELSIF (p_update_person = 'ALL') THEN
1583:
1584: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');

Line 1584: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');

1580: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1581:
1582: ELSIF (p_update_person = 'ALL') THEN
1583:
1584: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1585: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1586: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1587:
1588: END IF;

Line 1585: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);

1581:
1582: ELSIF (p_update_person = 'ALL') THEN
1583:
1584: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1585: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1586: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1587:
1588: END IF;
1589:

Line 1586: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);

1582: ELSIF (p_update_person = 'ALL') THEN
1583:
1584: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1585: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1586: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1587:
1588: END IF;
1589:
1590: l_progress := '001';

Line 1598: l_msg11 := fnd_message.get;

1594: PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );
1595:
1596: END IF;
1597:
1598: l_msg11 := fnd_message.get;
1599:
1600: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1601: l_msg12 := fnd_message.get;
1602:

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

1596: END IF;
1597:
1598: l_msg11 := fnd_message.get;
1599:
1600: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1601: l_msg12 := fnd_message.get;
1602:
1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;

Line 1601: l_msg12 := fnd_message.get;

1597:
1598: l_msg11 := fnd_message.get;
1599:
1600: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1601: l_msg12 := fnd_message.get;
1602:
1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;
1605:

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

1599:
1600: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1601: l_msg12 := fnd_message.get;
1602:
1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;
1605:
1606: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1607: l_msg14 := fnd_message.get;

Line 1604: l_msg13 := fnd_message.get;

1600: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1601: l_msg12 := fnd_message.get;
1602:
1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;
1605:
1606: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1607: l_msg14 := fnd_message.get;
1608:

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

1602:
1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;
1605:
1606: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1607: l_msg14 := fnd_message.get;
1608:
1609: l_progress := '002';
1610:

Line 1607: l_msg14 := fnd_message.get;

1603: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1604: l_msg13 := fnd_message.get;
1605:
1606: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1607: l_msg14 := fnd_message.get;
1608:
1609: l_progress := '002';
1610:
1611: fnd_file.put_line(fnd_file.output, l_msg1);