APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_AUCTION_CREATE_PO_PKG

Line 1: PACKAGE BODY pon_auction_create_po_pkg as

1: PACKAGE BODY pon_auction_create_po_pkg as
2: /* $Header: PONCRPOB.pls 120.72.12020000.4 2013/02/09 10:33:03 hvutukur ship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_module CONSTANT VARCHAR2(50) := 'pon.plsql.pon_auction_create_po_pkg';

Line 5: g_module CONSTANT VARCHAR2(50) := 'pon.plsql.pon_auction_create_po_pkg';

1: PACKAGE BODY pon_auction_create_po_pkg as
2: /* $Header: PONCRPOB.pls 120.72.12020000.4 2013/02/09 10:33:03 hvutukur ship $ */
3:
4: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5: g_module CONSTANT VARCHAR2(50) := 'pon.plsql.pon_auction_create_po_pkg';
6:
7: ---------Variables---------------------
8: PO_SUCCESS NUMBER := 1;
9: DUPLICATE_PO_NUMBER NUMBER := 2;

Line 1725: This procedure is invoked from PON_AUCTION_CREATE_PO_PKG.GENERATE_POS procedure

1721: END START_PO_WORKFLOW;
1722:
1723: /*
1724: Creates the award purchase order structure in PDOI
1725: This procedure is invoked from PON_AUCTION_CREATE_PO_PKG.GENERATE_POS procedure
1726: which is invoked from our create po workflow (refer ponwfau7.wft)
1727:
1728: This procedure inserts data from PON tables to PO interface tables
1729:

Line 1855: PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id(pbh.trading_partner_contact_id,pbh.vendor_site_id,pbh.vendor_id) vendor_contact_id,

1851: pbh.bid_number,
1852: pbh.order_number,
1853: pbh.vendor_id,
1854: pbh.vendor_site_id,
1855: PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id(pbh.trading_partner_contact_id,pbh.vendor_site_id,pbh.vendor_id) vendor_contact_id,
1856: pbh.agent_id,
1857: pah.global_agreement_flag,
1858: round(pah.po_min_rel_amount* pbh.rate,fc.precision),
1859: pbh.po_agreed_amount,

Line 5095: wf_core.context('PON_AUCTION_CREATE_PO_PKG','checkPOStatus', itemtype, itemkey, x_progress, SQLERRM);

5091:
5092: EXCEPTION
5093:
5094: when others then
5095: wf_core.context('PON_AUCTION_CREATE_PO_PKG','checkPOStatus', itemtype, itemkey, x_progress, SQLERRM);
5096: log_error(itemtype || ' ' || itemkey || ' ' || substrb(x_progress || SQLERRM, 1, 4000));
5097: raise;
5098:
5099: END CHECK_PO_STATUS;

Line 5255: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOSuccessEmail', x_progress, SQLERRM);

5251: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
5252: EXCEPTION
5253:
5254: when others then
5255: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOSuccessEmail', x_progress, SQLERRM);
5256: log_error('PONCOMPL' || ' ' || itemkey || ' ' || substrb(x_progress||SQLERRM, 1, 4000));
5257:
5258: IF (successfulPOs%ISOPEN) THEN
5259: close successfulPOs;

Line 5440: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOFailureEmail', x_progress, SQLERRM);

5436:
5437: EXCEPTION
5438:
5439: when others then
5440: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOFailureEmail', x_progress, SQLERRM);
5441: log_error('PONCOMPL' || ' ' || itemkey || ' ' || substrb(x_progress || SQLERRM, 1, 4000));
5442:
5443: IF (failedPOs%ISOPEN) THEN
5444: close failedPOs;

Line 6238: log_message('PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id--> l_vendor_contact_id: ' || l_vendor_contact_id);

6234: WHERE per_party_id = p_trading_partner_contact_id
6235: AND vendor_site_id = p_vendor_site_id
6236: AND vendor_id = p_vendor_id
6237: AND INACTIVE_DATE > sysdate;
6238: log_message('PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id--> l_vendor_contact_id: ' || l_vendor_contact_id);
6239: RETURN l_vendor_contact_id;
6240:
6241: EXCEPTION
6242: WHEN OTHERS THEN

Line 6243: log_error('PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id' || substrb(SQLERRM, 1, 4000));

6239: RETURN l_vendor_contact_id;
6240:
6241: EXCEPTION
6242: WHEN OTHERS THEN
6243: log_error('PON_AUCTION_CREATE_PO_PKG.get_vendor_contact_id' || substrb(SQLERRM, 1, 4000));
6244: RETURN NULL;
6245:
6246: END get_vendor_contact_id;
6247:

Line 6248: END PON_AUCTION_CREATE_PO_PKG;

6244: RETURN NULL;
6245:
6246: END get_vendor_contact_id;
6247:
6248: END PON_AUCTION_CREATE_PO_PKG;
6249:
6250: