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