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
849: SELECT manual_req_num_type
850: INTO req_num_type
851: FROM po_system_parameters;
852:
853: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
854: l_msg16 := fnd_message.get;
855:
856: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
857: l_msg17 := fnd_message.get;
850: INTO req_num_type
851: FROM po_system_parameters;
852:
853: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
854: l_msg16 := fnd_message.get;
855:
856: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
857: l_msg17 := fnd_message.get;
858:
852:
853: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
854: l_msg16 := fnd_message.get;
855:
856: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
857: l_msg17 := fnd_message.get;
858:
859: l_progress := '003';
860:
853: fnd_message.set_name('PO','PO_MUB_MSG_NEW_APPROVER');
854: l_msg16 := fnd_message.get;
855:
856: fnd_message.set_name('PO','PO_MUB_MSG_APPROVER');
857: l_msg17 := fnd_message.get;
858:
859: l_progress := '003';
860:
861: IF g_debug_stmt THEN
1264: SELECT manual_req_num_type
1265: INTO req_num_type
1266: FROM po_system_parameters;
1267:
1268: fnd_message.set_name('PO','PO_MUB_MSG_REQUESTOR');
1269: l_msg18 := fnd_message.get;
1270:
1271: l_progress := '003';
1272:
1265: INTO req_num_type
1266: FROM po_system_parameters;
1267:
1268: fnd_message.set_name('PO','PO_MUB_MSG_REQUESTOR');
1269: l_msg18 := fnd_message.get;
1270:
1271: l_progress := '003';
1272:
1273: IF g_debug_stmt THEN
1609: PO_DEBUG.debug_var(l_log_head,l_progress,'p_date_to', p_date_to);
1610:
1611: END IF;
1612:
1613: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1614: l_msg1 := fnd_message.get;
1615:
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1610:
1611: END IF;
1612:
1613: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1614: l_msg1 := fnd_message.get;
1615:
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1618:
1612:
1613: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1614: l_msg1 := fnd_message.get;
1615:
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1618:
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1613: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER1');
1614: l_msg1 := fnd_message.get;
1615:
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1618:
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1621:
1615:
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1618:
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1621:
1622: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1623: l_msg4 := fnd_message.get;
1616: fnd_message.set_name('PO','PO_MUB_MSG_DATE');
1617: l_msg2 := fnd_message.get;
1618:
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1621:
1622: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1623: l_msg4 := fnd_message.get;
1624:
1618:
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1621:
1622: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1623: l_msg4 := fnd_message.get;
1624:
1625:
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1619: fnd_message.set_name('PO','PO_MUB_MSG_OU');
1620: l_msg3 := fnd_message.get;
1621:
1622: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1623: l_msg4 := fnd_message.get;
1624:
1625:
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1627: l_msg5 := fnd_message.get;
1622: fnd_message.set_name('PO','PO_MUB_MSG_OLD_PERSON');
1623: l_msg4 := fnd_message.get;
1624:
1625:
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1627: l_msg5 := fnd_message.get;
1628:
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1623: l_msg4 := fnd_message.get;
1624:
1625:
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1627: l_msg5 := fnd_message.get;
1628:
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1631:
1625:
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1627: l_msg5 := fnd_message.get;
1628:
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1631:
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1626: fnd_message.set_name('PO','PO_MUB_MSG_NEW_PERSON');
1627: l_msg5 := fnd_message.get;
1628:
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1631:
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1634:
1628:
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1631:
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1634:
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1629: fnd_message.set_name('PO','PO_MUB_MSG_DOC_SUB_TYPE');
1630: l_msg6 := fnd_message.get;
1631:
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1634:
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1637:
1631:
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1634:
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1637:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1632: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_FROM');
1633: l_msg7 := fnd_message.get;
1634:
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1637:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1640:
1634:
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1637:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1640:
1641: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1642: l_msg10 := fnd_message.get;
1635: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM_TO');
1636: l_msg8 := fnd_message.get;
1637:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1640:
1641: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1642: l_msg10 := fnd_message.get;
1643:
1637:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1640:
1641: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1642: l_msg10 := fnd_message.get;
1643:
1644: SAVEPOINT Print_SP;
1645:
1638: fnd_message.set_name('PO','PO_MUB_MSG_DATE_FROM');
1639: l_msg9 := fnd_message.get;
1640:
1641: fnd_message.set_name('PO','PO_MUB_MSG_DATE_TO');
1642: l_msg10 := fnd_message.get;
1643:
1644: SAVEPOINT Print_SP;
1645:
1646: IF (p_update_person = 'PREPARER') THEN
1644: SAVEPOINT Print_SP;
1645:
1646: IF (p_update_person = 'PREPARER') THEN
1647:
1648: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1649: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1650: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1651:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1645:
1646: IF (p_update_person = 'PREPARER') THEN
1647:
1648: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1649: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1650: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1651:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1653:
1646: IF (p_update_person = 'PREPARER') THEN
1647:
1648: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER2');
1649: fnd_message.set_token('OLD_PREPARER',p_old_preparer_name);
1650: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1651:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1653:
1654: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1650: fnd_message.set_token('NEW_PREPARER',p_new_preparer_name);
1651:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1653:
1654: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1655: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1656: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1657:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1651:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1653:
1654: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1655: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1656: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1657:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1659:
1652: ELSIF (p_update_person = 'APPROVER') THEN
1653:
1654: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER3');
1655: fnd_message.set_token('OLD_APPROVER',p_old_preparer_name);
1656: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1657:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1659:
1660: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1656: fnd_message.set_token('NEW_APPROVER',p_new_preparer_name);
1657:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1659:
1660: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1661: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1662: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1663:
1664: ELSIF (p_update_person = 'ALL') THEN
1657:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1659:
1660: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1661: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1662: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1663:
1664: ELSIF (p_update_person = 'ALL') THEN
1665:
1658: ELSIF (p_update_person = 'REQUESTOR') THEN
1659:
1660: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER4');
1661: fnd_message.set_token('OLD_REQUESTOR',p_old_preparer_name);
1662: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1663:
1664: ELSIF (p_update_person = 'ALL') THEN
1665:
1666: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1662: fnd_message.set_token('NEW_REQUESTOR',p_new_preparer_name);
1663:
1664: ELSIF (p_update_person = 'ALL') THEN
1665:
1666: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1667: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1668: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1669:
1670: END IF;
1663:
1664: ELSIF (p_update_person = 'ALL') THEN
1665:
1666: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1667: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1668: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1669:
1670: END IF;
1671:
1664: ELSIF (p_update_person = 'ALL') THEN
1665:
1666: fnd_message.set_name('PO','PO_MUB_MSG_PREPARER_HEADER5');
1667: fnd_message.set_token('OLD_PERSON',p_old_preparer_name);
1668: fnd_message.set_token('NEW_PERSON',p_new_preparer_name);
1669:
1670: END IF;
1671:
1672: l_progress := '001';
1676: PO_DEBUG.debug_var(l_log_head,l_progress,'p_update_person',p_update_person );
1677:
1678: END IF;
1679:
1680: l_msg11 := fnd_message.get;
1681:
1682: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1683: l_msg12 := fnd_message.get;
1684:
1678: END IF;
1679:
1680: l_msg11 := fnd_message.get;
1681:
1682: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1683: l_msg12 := fnd_message.get;
1684:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1679:
1680: l_msg11 := fnd_message.get;
1681:
1682: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1683: l_msg12 := fnd_message.get;
1684:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1687:
1681:
1682: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1683: l_msg12 := fnd_message.get;
1684:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1687:
1688: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1689: l_msg14 := fnd_message.get;
1682: fnd_message.set_name('PO','PO_MUB_MSG_DOC_NUM');
1683: l_msg12 := fnd_message.get;
1684:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1687:
1688: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1689: l_msg14 := fnd_message.get;
1690:
1684:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1687:
1688: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1689: l_msg14 := fnd_message.get;
1690:
1691: l_progress := '002';
1692:
1685: fnd_message.set_name('PO','PO_MUB_MSG_DOC_TYPE');
1686: l_msg13 := fnd_message.get;
1687:
1688: fnd_message.set_name('PO','PO_MUB_MSG_PERSON');
1689: l_msg14 := fnd_message.get;
1690:
1691: l_progress := '002';
1692:
1693: fnd_file.put_line(fnd_file.output, l_msg1);