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.41 2007/09/14 18:15:12 sssahai 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.41 2007/09/14 18:15:12 sssahai 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 1644: This procedure is invoked from PON_AUCTION_CREATE_PO_PKG.GENERATE_POS procedure

1640: END START_PO_WORKFLOW;
1641:
1642: /*
1643: Creates the award purchase order structure in PDOI
1644: This procedure is invoked from PON_AUCTION_CREATE_PO_PKG.GENERATE_POS procedure
1645: which is invoked from our create po workflow (refer ponwfau7.wft)
1646:
1647: This procedure inserts data from PON tables to PO interface tables
1648:

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

4109:
4110: EXCEPTION
4111:
4112: when others then
4113: wf_core.context('PON_AUCTION_CREATE_PO_PKG','checkPOStatus', itemtype, itemkey, x_progress, SQLERRM);
4114: log_error(itemtype || ' ' || itemkey || ' ' || substrb(x_progress || SQLERRM, 1, 4000));
4115: raise;
4116:
4117: END CHECK_PO_STATUS;

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

4266: PON_AUCTION_PKG.UNSET_SESSION_LANGUAGE;
4267: EXCEPTION
4268:
4269: when others then
4270: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOSuccessEmail', x_progress, SQLERRM);
4271: log_error('PONCOMPL' || ' ' || itemkey || ' ' || substrb(x_progress||SQLERRM, 1, 4000));
4272:
4273: IF (successfulPOs%ISOPEN) THEN
4274: close successfulPOs;

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

4448:
4449: EXCEPTION
4450:
4451: when others then
4452: wf_core.context('PON_AUCTION_CREATE_PO_PKG','generatePOFailureEmail', x_progress, SQLERRM);
4453: log_error('PONCOMPL' || ' ' || itemkey || ' ' || substrb(x_progress || SQLERRM, 1, 4000));
4454:
4455: IF (failedPOs%ISOPEN) THEN
4456: close failedPOs;

Line 4937: END PON_AUCTION_CREATE_PO_PKG;

4933: || ' with final p_resultout=' || p_resultout);
4934:
4935: END START_PO_CREATION;
4936:
4937: END PON_AUCTION_CREATE_PO_PKG;