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.POR_UTIL_PKG dependencies on FND_LOG

Line 10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

6: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7:
8: -- Logging Static Variables
9: G_CURRENT_RUNTIME_LEVEL NUMBER;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

7:
8: -- Logging Static Variables
9: G_CURRENT_RUNTIME_LEVEL NUMBER;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

8: -- Logging Static Variables
9: G_CURRENT_RUNTIME_LEVEL NUMBER;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';

Line 13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

9: G_CURRENT_RUNTIME_LEVEL NUMBER;
10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';
17:

Line 14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

10: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';
17:
18: FUNCTION bool_to_varchar(b IN BOOLEAN) RETURN VARCHAR2 IS

Line 15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

11: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
12: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
13: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
14: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
15: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
16: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_UTIL_PKG';
17:
18: FUNCTION bool_to_varchar(b IN BOOLEAN) RETURN VARCHAR2 IS
19: BEGIN

Line 278: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

274: l_progress PLS_INTEGER;
275:
276: -- Logging Infra
277: l_procedure_name CONSTANT VARCHAR2(30) := 'get_cost_center';
278: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
279:
280: BEGIN
281:
282: -- Logging Infra: Setting up runtime level

Line 283: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

279:
280: BEGIN
281:
282: -- Logging Infra: Setting up runtime level
283: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
284: l_progress := 100;
285:
286: begin
287: select fs.segment_num, gls.chart_of_accounts_id

Line 326: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

322: -- Logging Infra: Statement level
323: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
324: l_log_msg := 'Error in fnd_flex_ext.get_segments... returning empty string : SQLERRM= ' ||
325: SQLERRM || ' : Progress= ' || l_progress;
326: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
327: END IF;
328:
329: l_cost_center := '';
330: RETURN l_cost_center;

Line 466: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

462: l_counter INTEGER := 1;
463: l_cannotread BOOLEAN := TRUE;
464: l_options_value VARCHAR2(100) := 'N';
465: l_procedure_name CONSTANT VARCHAR2(30) := 'get_document_number';
466: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
467: l_inc_val NUMBER := 1;
468: BEGIN
469:
470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

466: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
467: l_inc_val NUMBER := 1;
468: BEGIN
469:
470: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
471: WHILE (l_counter <= l_no_of_trials AND l_cannotread) LOOP
472: BEGIN
473: SELECT (current_max_unique_identifier + 1) INTO l_po_num
474: FROM po_unique_identifier_control

Line 481: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);

477: IF (l_po_num < 0) THEN
478: IF (g_fnd_debug = 'Y') THEN
479: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
480: l_log_msg := 'New Header Number(Negative): '|| l_po_num;
481: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
482: END IF;
483: END IF;
484: l_inc_val := l_inc_val + 1;
485: IF (l_inc_val > 3) THEN

Line 985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

981: l_is_ame_approval varchar2(30);
982:
983: l_progress VARCHAR2(100);
984: l_procedure_name CONSTANT VARCHAR2(30) := 'update_notif_header_attr';
985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
986:
987:
988: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
989: select item_type, item_key

Line 1135: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME||l_procedure_name, l_log_msg);

1131: when others then
1132: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1133: l_log_msg := 'Error in update_notif_header_attr... : SQLERRM= ' ||
1134: SQLERRM || ' : Progress= ' || l_progress;
1135: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME||l_procedure_name, l_log_msg);
1136: END IF;
1137:
1138: raise;
1139: END update_notif_header_attr;

Line 2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2057: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2058:
2059: -- Logging Infra
2060: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2061: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2062:
2063: CURSOR action_cursor IS
2064: SELECT action_code, employee_id
2065: FROM PO_ACTION_HISTORY

Line 2079: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2075:
2076: BEGIN
2077:
2078: -- Logging Infra: Setting up runtime level
2079: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2080:
2081: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2082: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');
2083: END IF;

Line 2082: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');

2078: -- Logging Infra: Setting up runtime level
2079: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2080:
2081: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2082: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');
2083: END IF;
2084:
2085: -- abort workflow
2086: SELECT wf_item_type, wf_item_key, type_lookup_code

Line 2139: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Parent Workflow: ' || l_item_key || ' : ' || l_item_type);

2135: IF (l_activity_status <> 'COMPLETE') THEN
2136: l_progress := '070';
2137:
2138: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2139: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Parent Workflow: ' || l_item_key || ' : ' || l_item_type);
2140: END IF;
2141:
2142: WF_Engine.AbortProcess(l_item_type, l_item_key);
2143: END IF;

Line 2175: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Child Workflow: ' || c1_rec.item_key || ' : ' || l_item_type);

2171:
2172: IF (l_activity_status <> 'COMPLETE') THEN
2173:
2174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2175: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Child Workflow: ' || c1_rec.item_key || ' : ' || l_item_type);
2176: END IF;
2177:
2178: l_progress := '100';
2179:

Line 2242: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving withdraw_req...');

2238: --BUg 6442891 end
2239:
2240:
2241: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2242: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving withdraw_req...');
2243: END IF;
2244:
2245: EXCEPTION
2246: WHEN OTHERS THEN

Line 2882: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2878: ikey varchar2(240);
2879:
2880: -- Logging Infra
2881: l_procedure_name CONSTANT VARCHAR2(30) := 'cancel_workflow';
2882: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2883:
2884: BEGIN
2885:
2886: -- Logging Infra: Setting up runtime level

Line 2887: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2883:
2884: BEGIN
2885:
2886: -- Logging Infra: Setting up runtime level
2887: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2888:
2889: -- Logging Infra: Statement level
2890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2891: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');

Line 2891: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');

2887: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2888:
2889: -- Logging Infra: Statement level
2890: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2891: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');
2892: END IF;
2893:
2894: -- get item_type and item_key
2895: select wf_item_type, wf_item_key

Line 2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);

2897: from po_requisition_headers
2898: where requisition_header_id = p_headerId;
2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
2904: END IF;
2905:

Line 2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);

2898: where requisition_header_id = p_headerId;
2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
2904: END IF;
2905:
2906: for c1_rec in c1(itype, ikey) LOOP

Line 2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);

2899:
2900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2901: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
2902: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
2903: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
2904: END IF;
2905:
2906: for c1_rec in c1(itype, ikey) LOOP
2907:

Line 2909: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Cancelling Nid = ' || c1_rec.notification_id);

2905:
2906: for c1_rec in c1(itype, ikey) LOOP
2907:
2908: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2909: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Cancelling Nid = ' || c1_rec.notification_id);
2910: END IF;
2911:
2912: wf_notification.cancel (c1_rec.notification_id, NULL);
2913:

Line 2917: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving cancel_workflow...');

2913:
2914: end LOOP;
2915:
2916: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2917: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving cancel_workflow...');
2918: END IF;
2919:
2920: EXCEPTION
2921: when others then

Line 2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;

2972:
2973: l_progress VARCHAR2(4) := '000';
2974: l_api_name CONSTANT VARCHAR2(100) := 'create_info_template';
2975: l_api_version CONSTANT NUMBER := 1.0;
2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
2977: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
2978: l_commit_size NUMBER := 50;
2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2980:

Line 2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2975: l_api_version CONSTANT NUMBER := 1.0;
2976: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
2977: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
2978: l_commit_size NUMBER := 50;
2979: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2980:
2981: counter NUMBER;
2982: l_info_templ_count NUMBER;
2983:

Line 3002: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2998: p_caller_version_number => p_api_version,
2999: p_api_name => l_api_name,
3000: p_pkg_name => 'POR_UTIL_PKG')
3001: THEN
3002: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3003: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3004: module => l_api_name || '.begin',
3005: message => l_progress||' - Checking API Compatibility - Failed');
3006: END IF;

Line 3003: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,

2999: p_api_name => l_api_name,
3000: p_pkg_name => 'POR_UTIL_PKG')
3001: THEN
3002: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3003: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3004: module => l_api_name || '.begin',
3005: message => l_progress||' - Checking API Compatibility - Failed');
3006: END IF;
3007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3013: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3009:
3010: OPEN c_parent_info_template;
3011:
3012: l_progress := '020';
3013: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3014: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3015: module => l_api_name || '.begin',
3016: message => l_progress||' - Looping through Existing Lines');
3017: END IF;

Line 3014: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,

3010: OPEN c_parent_info_template;
3011:
3012: l_progress := '020';
3013: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3014: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3015: module => l_api_name || '.begin',
3016: message => l_progress||' - Looping through Existing Lines');
3017: END IF;
3018:

Line 3187: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3183:
3184: EXCEPTION
3185:
3186: WHEN OTHERS THEN
3187: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3188: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3189: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3190: END IF;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3189: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);

3185:
3186: WHEN OTHERS THEN
3187: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3188: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3189: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3190: END IF;
3191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3192: --Close the cursor
3193: IF (c_parent_info_template%ISOPEN) THEN

Line 3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3205: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3206:
3207: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3208: l_progress VARCHAR2(4) := '000';
3209: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3210: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3211:
3212: BEGIN
3213: l_progress := '010';