eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IAW_PKG dependencies on AP_IAW_PKG

Line 1: PACKAGE BODY AP_IAW_PKG AS

1: PACKAGE BODY AP_IAW_PKG AS
2: /* $Header: apiawleb.pls 120.14 2006/04/07 14:10:24 vdesu noship $ */
3:
4: --------------------------------------------------------------
5: -- Types

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_IAW_PKG';

14:
15: --------------------------------------------------------------
16: -- Global Variables --
17: --------------------------------------------------------------
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_IAW_PKG';
19: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
20: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
21: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
22: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';

33: -- G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
35: -- G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
36: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
37: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_IAW_PKG';
38:
39: -- get max notification iteration
40: -- invoice_key is invoice_id + invoice_iteration from ap_apinv_approvers
41: FUNCTION get_max_notif_iteration(p_invoice_key IN VARCHAR2)

Line 51: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

47:
48: BEGIN
49:
50: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
51: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
52: END IF;
53:
54: -- get max notification iteration
55: SELECT nvl(max(notification_iteration),0) + 1

Line 100: l_h_hist ap_iaw_pkg.r_inv_aprvl_hist;

96:
97: l_result ame_util.stringlist;
98: l_reason ame_util.stringlist;
99: l_invoice_id NUMBER;
100: l_h_hist ap_iaw_pkg.r_inv_aprvl_hist;
101: l_tr_reason VARCHAR2(240);
102: l_api_name CONSTANT VARCHAR2(200) := 'Check_Header_Requirements';
103: l_org_id NUMBER;
104: l_rejected_check BOOLEAN := FALSE;

Line 113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

109:
110: BEGIN
111:
112: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
113: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
114: END IF;
115:
116: l_debug_info := 'set variables from workflow';
117: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 346: l_l_hist ap_iaw_pkg.r_line_aprvl_hist;

342:
343: l_result ame_util.stringlist;
344: l_reason ame_util.stringlist;
345: l_invoice_id NUMBER;
346: l_l_hist ap_iaw_pkg.r_line_aprvl_hist;
347: l_tr_reason VARCHAR2(240);
348: l_api_name CONSTANT VARCHAR2(200) := 'Check_Line_Requirements';
349: l_org_id NUMBER;
350: l_required_check BOOLEAN := TRUE;

Line 359: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

355:
356: BEGIN
357:
358: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
359: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
360: END IF;
361:
362: l_debug_info := 'set variables from workflow';
363: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.identify_approver (+)');

496:
497: BEGIN
498:
499: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.identify_approver (+)');
501: END IF;
502:
503: l_debug_info := 'get variables from workflow: itemtype = ' || itemtype ||
504: ', itemkey = ' || itemkey;

Line 719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

715:
716: BEGIN
717:
718: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
719: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
720: END IF;
721:
722: l_debug_info := l_api_name || ': get variables from workflow: itemtype = ' || itemtype ||
723: ', itemkey = ' || itemkey;

Line 1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1082:
1083: BEGIN
1084:
1085: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1087: END IF;
1088:
1089: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1090:

Line 1335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1331:
1332: BEGIN
1333:
1334: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1335: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1336: END IF;
1337:
1338: --Determine if line or header level approver
1339: SELECT DECODE(nvl(Line_Number,''),'','HEADER','LINE'), invoice_key

Line 1405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1401:
1402: BEGIN
1403:
1404: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1405: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1406: END IF;
1407:
1408: --Get the current approver info
1409: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1533:
1534: BEGIN
1535:
1536: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1537: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1538: END IF;
1539:
1540: --Get the current approver info
1541: l_approver_id := WF_ENGINE.GetItemAttrNumber(itemtype,

Line 1655: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1651: 'Notification_Handler';
1652: BEGIN
1653:
1654: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1655: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1656: END IF;
1657:
1658: --users may not transfer, or reassign them
1659: IF ( funcmode = 'TRANSFER' ) THEN

Line 1705: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1701:
1702: BEGIN
1703:
1704: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1705: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1706: END IF;
1707:
1708: --Get wf attribute values
1709: l_result := WF_ENGINE.GetActivityAttrText(itemtype => itemtype,

Line 1831: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1827:
1828: BEGIN
1829:
1830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1831: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1832: END IF;
1833:
1834: --Update Approvers table
1835: UPDATE AP_APINV_APPROVERS

Line 1921: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

1917:
1918: BEGIN
1919:
1920: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1921: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
1922: END IF;
1923:
1924: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
1925:

Line 2056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.set_attribute_values (+)');

2052: l_debug_info VARCHAR2(2000);
2053:
2054: BEGIN
2055: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2056: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.set_attribute_values (+)');
2057: END IF;
2058:
2059: l_debug_info := l_api_name || ': itemtype = ' || itemtype ||
2060: ', itemkey = ' || itemkey;

Line 2269: p_inv_aprvl_hist IN ap_iaw_pkg.r_inv_aprvl_hist) IS

2265: /*When the approver for a line has been identified, this procedure places
2266: a Pending record in the history table.*/
2267:
2268: PROCEDURE Insert_Header_History(
2269: p_inv_aprvl_hist IN ap_iaw_pkg.r_inv_aprvl_hist) IS
2270:
2271: l_api_name CONSTANT VARCHAR2(200) := 'Insert_Header_History';
2272: l_hist_id NUMBER;
2273: l_debug_info VARCHAR2(2000);

Line 2279: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2275:
2276: BEGIN
2277:
2278: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2279: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2280: END IF;
2281:
2282: --set the environment
2283: fnd_client_info.set_org_context(p_inv_aprvl_hist.org_id);

Line 2353: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2349:
2350: BEGIN
2351:
2352: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2353: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2354: END IF;
2355:
2356: --Get attribute values to create record in the history table
2357: IF p_type = 'ESC' THEN

Line 2441: p_line_aprvl_hist IN ap_iaw_pkg.r_line_aprvl_hist) IS

2437: /*When the approver for a line has been identified, this procedure places
2438: a Pending record in the history table. */
2439:
2440: PROCEDURE Insert_Line_History(
2441: p_line_aprvl_hist IN ap_iaw_pkg.r_line_aprvl_hist) IS
2442:
2443: l_api_name CONSTANT VARCHAR2(200) := 'Insert_Line_History';
2444: l_debug_info VARCHAR2(2000);
2445: l_hist_id NUMBER;

Line 2450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2446: l_not_cnt NUMBER;
2447: BEGIN
2448:
2449: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2450: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2451: END IF;
2452:
2453: --Now set the environment
2454: fnd_client_info.set_org_context(p_line_aprvl_hist.org_id);

Line 2544: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2540: GROUP BY Line_Number, item_class, item_id;
2541:
2542: BEGIN
2543: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2544: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2545: END IF;
2546:
2547: --Get attribute values to create record in the history table
2548: IF p_type = 'ESC' THEN

Line 2666: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2662:
2663: BEGIN
2664:
2665: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2667: END IF;
2668:
2669: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2670: itemkey,

Line 2751: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2747:
2748: BEGIN
2749:
2750: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2751: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2752: END IF;
2753:
2754: IF p_response = 'APPROVED' THEN
2755: l_response := 'WFAPPROVED';

Line 2813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2809:
2810: BEGIN
2811:
2812: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2813: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2814: END IF;
2815:
2816: l_invoice_id := WF_ENGINE.GetItemAttrNumber(itemtype,
2817: itemkey,

Line 2893: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2889:
2890: BEGIN
2891:
2892: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2893: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2894: END IF;
2895:
2896: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2897:

Line 2944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

2940:
2941: BEGIN
2942:
2943: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2944: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
2945: END IF;
2946:
2947: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
2948:

Line 3027: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3023:
3024: BEGIN
3025:
3026: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3027: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3028: END IF;
3029:
3030: l_calling_sequence := l_api_name || ' <-' || p_calling_sequence;
3031:

Line 3180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3176:
3177: BEGIN
3178:
3179: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3180: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3181: END IF;
3182:
3183: l_calling_sequence := l_api_name;
3184:

Line 3274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3270: l_api_name CONSTANT VARCHAR2(200) := 'AP_Dist_Accounting_Flex';
3271:
3272: BEGIN
3273: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3274: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3275: END IF;
3276:
3277: SELECT dist_code_combination_id,set_of_books_id
3278: INTO l_ccid,l_sob

Line 3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3350:
3351: BEGIN
3352:
3353: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3354: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3355: END IF;
3356:
3357: IF p_context = 'header' THEN
3358: --dealing with a header level attribute

Line 3887: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3883:
3884: BEGIN
3885:
3886: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3887: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3888: END IF;
3889:
3890: for i IN 1..p_mapping_tbl.COUNT loop
3891: l_notif_iter := get_max_notif_iteration(p_item_key) + 1;

Line 3945: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

3941:
3942: end loop;
3943:
3944: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3945: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
3946: END IF;
3947:
3948: EXCEPTION
3949: WHEN OTHERS THEN

Line 4067: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4063:
4064: BEGIN
4065:
4066: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4067: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4068: END IF;
4069:
4070: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4071: itemkey,

Line 4262: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4258: END LOOP;
4259: end if;
4260:
4261: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4262: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4263: END IF;
4264:
4265: EXCEPTION
4266: WHEN OTHERS THEN

Line 4509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4505:
4506: BEGIN
4507:
4508: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4509: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4510: END IF;
4511:
4512: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
4513: itemkey,

Line 4998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

4994:
4995: BEGIN
4996:
4997: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
4998: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
4999: END IF;
5000:
5001: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5002: itemkey,

Line 5122: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

5118:
5119: BEGIN
5120:
5121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5122: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5123: END IF;
5124:
5125: l_invoice_id := WF_ENGINE.GETITEMATTRNumber(itemtype,
5126: itemkey,

Line 5178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);

5174:
5175: BEGIN
5176:
5177: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
5178: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'AP_IAW_PKG.'|| l_api_name);
5179: END IF;
5180:
5181: /*l_curr_calling_sequence := 'AP_APPROVAL_PKG.'||l_debug_loc||'<-'||
5182: p_calling_sequence;

Line 5221: END AP_IAW_PKG;

5217:
5218: end release_holds;
5219:
5220:
5221: END AP_IAW_PKG;