APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_LINES_SV4_832_UPDATE

Line 1: PACKAGE BODY PO_LINES_SV4_832_UPDATE AS

1: PACKAGE BODY PO_LINES_SV4_832_UPDATE AS
2: /* $Header: POXPILUB.pls 120.1.12000000.2 2007/07/18 12:25:14 puppulur ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 1335: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 01';

1331: l_progress VARCHAR2(300) := NULL;
1332:
1333: BEGIN
1334:
1335: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 01';
1336: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);
1337:
1338: -- initialize the return variables
1339: X_item_exist := NULL;

Line 1349: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 900 ';

1345: WHERE WI.ITEM_TYPE = X_ItemType
1346: AND WI.ITEM_KEY = X_ItemKey;
1347:
1348:
1349: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 900 ';
1350: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);
1351:
1352: EXCEPTION
1353: WHEN NO_DATA_FOUND THEN

Line 1361: wf_core.context ('PO_LINES_SV4_832_UPDATE','Item_exists','SQL error ' || sqlcode);

1357: X_item_end_date := NULL;
1358:
1359: WHEN OTHERS THEN
1360:
1361: wf_core.context ('PO_LINES_SV4_832_UPDATE','Item_exists','SQL error ' || sqlcode);
1362: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 990 - ' ||
1363: 'EXCEPTION - sql error: ' || sqlcode;
1364: IF (g_po_wf_debug = 'Y') THEN
1365: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);

Line 1362: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 990 - ' ||

1358:
1359: WHEN OTHERS THEN
1360:
1361: wf_core.context ('PO_LINES_SV4_832_UPDATE','Item_exists','SQL error ' || sqlcode);
1362: l_progress := 'PO_LINES_SV4_832_UPDATE.Item_Exists: 990 - ' ||
1363: 'EXCEPTION - sql error: ' || sqlcode;
1364: IF (g_po_wf_debug = 'Y') THEN
1365: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);
1366: END IF;

Line 1560: wf_core.context ('PO_LINES_SV4_832_UPDATE','Start_Pricat_WF','SQL error ' || sqlcode);

1556:
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559:
1560: wf_core.context ('PO_LINES_SV4_832_UPDATE','Start_Pricat_WF','SQL error ' || sqlcode);
1561: l_progress := 'PO_LINES_SV4_832_UPDATE.Start_Pricat_WF: 990 - ' || 'EXCEPTION - sql error: ' || sqlcode;
1562: IF (g_po_wf_debug = 'Y') THEN
1563: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);
1564: END IF;

Line 1561: l_progress := 'PO_LINES_SV4_832_UPDATE.Start_Pricat_WF: 990 - ' || 'EXCEPTION - sql error: ' || sqlcode;

1557: EXCEPTION
1558: WHEN OTHERS THEN
1559:
1560: wf_core.context ('PO_LINES_SV4_832_UPDATE','Start_Pricat_WF','SQL error ' || sqlcode);
1561: l_progress := 'PO_LINES_SV4_832_UPDATE.Start_Pricat_WF: 990 - ' || 'EXCEPTION - sql error: ' || sqlcode;
1562: IF (g_po_wf_debug = 'Y') THEN
1563: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_itemtype,X_itemkey,l_progress);
1564: END IF;
1565:

Line 1803: END PO_LINES_SV4_832_UPDATE;

1799:
1800: END update_price_discount;
1801:
1802:
1803: END PO_LINES_SV4_832_UPDATE;