DBA Data[Home] [Help]

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 288: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

284: l_progress PLS_INTEGER;
285:
286: -- Logging Infra
287: l_procedure_name CONSTANT VARCHAR2(30) := 'get_cost_center';
288: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
289:
290: BEGIN
291:
292: -- Logging Infra: Setting up runtime level

Line 293: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

289:
290: BEGIN
291:
292: -- Logging Infra: Setting up runtime level
293: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
294: l_progress := 100;
295:
296: begin
297: select fs.segment_num, gls.chart_of_accounts_id

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

332: -- Logging Infra: Statement level
333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
334: l_log_msg := 'Error in fnd_flex_ext.get_segments... returning empty string : SQLERRM= ' ||
335: SQLERRM || ' : Progress= ' || l_progress;
336: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
337: END IF;
338:
339: l_cost_center := '';
340: RETURN l_cost_center;

Line 498: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

494: l_counter INTEGER := 1;
495: l_cannotread BOOLEAN := TRUE;
496: l_options_value VARCHAR2(100) := 'N';
497: l_procedure_name CONSTANT VARCHAR2(30) := 'get_document_number';
498: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
499: l_inc_val NUMBER := 1;
500: BEGIN
501:
502: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 502: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

498: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
499: l_inc_val NUMBER := 1;
500: BEGIN
501:
502: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
503: WHILE (l_counter <= l_no_of_trials AND l_cannotread) LOOP
504: BEGIN
505: SELECT (current_max_unique_identifier + 1) INTO l_po_num
506: FROM po_unique_identifier_control

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

509: IF (l_po_num < 0) THEN
510: IF (g_fnd_debug = 'Y') THEN
511: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
512: l_log_msg := 'New Header Number(Negative): '|| l_po_num;
513: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
514: END IF;
515: END IF;
516: l_inc_val := l_inc_val + 1;
517: IF (l_inc_val > 3) THEN

Line 1012: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1008: l_is_ame_approval varchar2(30);
1009:
1010: l_progress VARCHAR2(100);
1011: l_procedure_name CONSTANT VARCHAR2(30) := 'update_notif_header_attr';
1012: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1013:
1014:
1015: cursor ame_child_wf (l_wf_itemtype varchar2,l_wf_itemkey varchar2) is
1016: select item_type, item_key

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

1158: when others then
1159: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
1160: l_log_msg := 'Error in update_notif_header_attr... : SQLERRM= ' ||
1161: SQLERRM || ' : Progress= ' || l_progress;
1162: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME||l_procedure_name, l_log_msg);
1163: END IF;
1164:
1165: raise;
1166: END update_notif_header_attr;

Line 2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2389: l_pending_emp_id PO_ACTION_HISTORY.EMPLOYEE_ID%TYPE;
2390:
2391: -- Logging Infra
2392: l_procedure_name CONSTANT VARCHAR2(30) := 'withdraw_req';
2393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2394:
2395: CURSOR action_cursor IS
2396: SELECT action_code, employee_id
2397: FROM PO_ACTION_HISTORY

Line 2411: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2407: xAmeTransactionType VARCHAR2(1000);
2408: BEGIN
2409:
2410: -- Logging Infra: Setting up runtime level
2411: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2412:
2413: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');
2415: END IF;

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

2410: -- Logging Infra: Setting up runtime level
2411: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2412:
2413: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2414: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering withdraw_req...');
2415: END IF;
2416: -- check if ame then clearallapprovals
2417: IF (POR_AME_APPROVAL_LIST.is_ame_reqapprv_workflow(pReqHeaderId =>p_headerId, pIsRcoApproval=> FALSE , xAmeTransactionType=> xAmeTransactionType ) = 'Y' ) then
2418: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2419: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'its ame then clearallapprovals...');

2415: END IF;
2416: -- check if ame then clearallapprovals
2417: IF (POR_AME_APPROVAL_LIST.is_ame_reqapprv_workflow(pReqHeaderId =>p_headerId, pIsRcoApproval=> FALSE , xAmeTransactionType=> xAmeTransactionType ) = 'Y' ) then
2418: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2419: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'its ame then clearallapprovals...');
2420: END IF;
2421: begin
2422:
2423: ame_api2.clearAllApprovals( applicationIdIn => por_ame_approval_list.applicationId ,

Line 2430: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'iclearallapprovals. raised exception' || SQLERRM || 'code =' || sqlcode);

2426: );
2427: EXCEPTION
2428: WHEN OTHERS THEN
2429: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2430: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'iclearallapprovals. raised exception' || SQLERRM || 'code =' || sqlcode);
2431: END IF;
2432:
2433: END;
2434: END IF;

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

2485: IF (l_activity_status <> 'COMPLETE') THEN
2486: l_progress := '070';
2487:
2488: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2489: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Parent Workflow: ' || l_item_key || ' : ' || l_item_type);
2490: END IF;
2491:
2492: WF_Engine.AbortProcess(l_item_type, l_item_key);
2493: END IF;

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

2521:
2522: IF (l_activity_status <> 'COMPLETE') THEN
2523:
2524: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2525: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Child Workflow: ' || c1_rec.item_key || ' : ' || l_item_type);
2526: END IF;
2527:
2528: l_progress := '100';
2529:

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

2588: --BUg 6442891 end
2589:
2590:
2591: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2592: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving withdraw_req...');
2593: END IF;
2594:
2595: EXCEPTION
2596: WHEN OTHERS THEN

Line 3251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3247: ikey varchar2(240);
3248:
3249: -- Logging Infra
3250: l_procedure_name CONSTANT VARCHAR2(30) := 'cancel_workflow';
3251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3252:
3253: BEGIN
3254:
3255: -- Logging Infra: Setting up runtime level

Line 3256: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3252:
3253: BEGIN
3254:
3255: -- Logging Infra: Setting up runtime level
3256: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3257:
3258: -- Logging Infra: Statement level
3259: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3260: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');

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

3256: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3257:
3258: -- Logging Infra: Statement level
3259: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3260: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Entering cancel_workflow...');
3261: END IF;
3262:
3263: -- get item_type and item_key
3264: select wf_item_type, wf_item_key

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

3266: from po_requisition_headers
3267: where requisition_header_id = p_headerId;
3268:
3269: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
3271: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
3272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
3273: END IF;
3274:

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

3267: where requisition_header_id = p_headerId;
3268:
3269: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
3271: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
3272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
3273: END IF;
3274:
3275: for c1_rec in c1(itype, ikey) LOOP

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

3268:
3269: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3270: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' p_headerId = ' || p_headerId);
3271: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_type = ' || itype);
3272: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' wf_item_key = ' || ikey);
3273: END IF;
3274:
3275: for c1_rec in c1(itype, ikey) LOOP
3276:

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

3274:
3275: for c1_rec in c1(itype, ikey) LOOP
3276:
3277: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3278: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Cancelling Nid = ' || c1_rec.notification_id);
3279: END IF;
3280:
3281: wf_notification.cancel (c1_rec.notification_id, NULL);
3282:

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

3282:
3283: end LOOP;
3284:
3285: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
3286: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, 'Leaving cancel_workflow...');
3287: END IF;
3288:
3289: EXCEPTION
3290: when others then

Line 3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;

3341:
3342: l_progress VARCHAR2(4) := '000';
3343: l_api_name CONSTANT VARCHAR2(100) := 'create_info_template';
3344: l_api_version CONSTANT NUMBER := 1.0;
3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
3346: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
3347: l_commit_size NUMBER := 50;
3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3349:

Line 3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3344: l_api_version CONSTANT NUMBER := 1.0;
3345: l_msg_data FND_LOG_MESSAGES.message_text%TYPE;
3346: xDBVersion NUMBER := ICX_POR_EXT_UTL.getDatabaseVersion;
3347: l_commit_size NUMBER := 50;
3348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3349:
3350: counter NUMBER;
3351: l_info_templ_count NUMBER;
3352:

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

3367: p_caller_version_number => p_api_version,
3368: p_api_name => l_api_name,
3369: p_pkg_name => 'POR_UTIL_PKG')
3370: THEN
3371: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3372: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3373: module => l_api_name || '.begin',
3374: message => l_progress||' - Checking API Compatibility - Failed');
3375: END IF;

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

3368: p_api_name => l_api_name,
3369: p_pkg_name => 'POR_UTIL_PKG')
3370: THEN
3371: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3372: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3373: module => l_api_name || '.begin',
3374: message => l_progress||' - Checking API Compatibility - Failed');
3375: END IF;
3376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3378:
3379: OPEN c_parent_info_template;
3380:
3381: l_progress := '020';
3382: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3383: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3384: module => l_api_name || '.begin',
3385: message => l_progress||' - Looping through Existing Lines');
3386: END IF;

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

3379: OPEN c_parent_info_template;
3380:
3381: l_progress := '020';
3382: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3383: FND_LOG.string(log_level => FND_LOG.LEVEL_STATEMENT,
3384: module => l_api_name || '.begin',
3385: message => l_progress||' - Looping through Existing Lines');
3386: END IF;
3387:

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

3552:
3553: EXCEPTION
3554:
3555: WHEN OTHERS THEN
3556: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3557: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3558: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3559: END IF;
3560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

3554:
3555: WHEN OTHERS THEN
3556: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3557: l_log_msg := 'Error in create_info_template : Progress= ' || l_progress;
3558: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
3559: END IF;
3560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3561: --Close the cursor
3562: IF (c_parent_info_template%ISOPEN) THEN

Line 3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3574: -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
3575:
3576: PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER) IS
3577: l_progress VARCHAR2(4) := '000';
3578: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3579: l_api_name CONSTANT VARCHAR2(100) := 'update_attachment_to_standard';
3580: l_procedure_name CONSTANT VARCHAR2(30) := 'update_attachment_to_standard';
3581: TYPE fnd_doc_id_tb IS TABLE OF fnd_attached_documents.document_id%TYPE INDEX BY PLS_INTEGER;
3582: doc_id_v fnd_doc_id_tb;

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

3591: FROM po_requisition_lines_all prl, po_requisition_headers_all prh
3592: WHERE prl.requisition_header_id = prh.requisition_header_id AND prh.requisition_header_id=to_number(p_req_header_id));
3593:
3594: BEGIN
3595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3596: l_log_msg := 'Start procedure -> '||l_procedure_name||' l_progress -> '||l_progress ;
3597: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3598: END IF;
3599:

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

3593:
3594: BEGIN
3595: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3596: l_log_msg := 'Start procedure -> '||l_procedure_name||' l_progress -> '||l_progress ;
3597: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3598: END IF;
3599:
3600: OPEN l_fnd_document_id_csr;
3601: l_progress := '010';

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

3605: FORALL indx IN doc_id_v.FIRST .. doc_id_v.LAST
3606: UPDATE fnd_documents SET usage_type = 'S' WHERE document_id=doc_id_v(indx);
3607: END LOOP;
3608: l_progress := '020';
3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3610: l_log_msg := 'End procedure -> '||l_procedure_name||' l_progress -> '||l_progress ;
3611: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3612: END IF;
3613: EXCEPTION

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

3607: END LOOP;
3608: l_progress := '020';
3609: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3610: l_log_msg := 'End procedure -> '||l_procedure_name||' l_progress -> '||l_progress ;
3611: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3612: END IF;
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

3611: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3612: END IF;
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3616: l_log_msg := 'Exception raised. l_progress => '||l_progress;
3617: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3618: END IF;
3619: RAISE_APPLICATION_ERROR(-20000,

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

3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3616: l_log_msg := 'Exception raised. l_progress => '||l_progress;
3617: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3618: END IF;
3619: RAISE_APPLICATION_ERROR(-20000,
3620: 'Exception at POR_UTL_PKG.update_attachment_to_standard(p_req_header_id:'
3621: || p_req_header_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);

Line 3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3722: p_user_id := fnd_global.user_id;
3723: p_resp_id := fnd_global.resp_id;
3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);

Line 3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');

3723: p_resp_id := fnd_global.resp_id;
3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
3731: END IF;

Line 3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);

3724: p_appl_id := fnd_global.resp_appl_id;
3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
3731: END IF;
3732:

Line 3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);

3725:
3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
3731: END IF;
3732:
3733: ProfileValue := PO_CLM_CLO_UTIL.checkCLMResp(p_user_id, p_resp_id, p_appl_id);

Line 3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);

3726: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3727: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Enter GET_SECURITY_CLAUSE Function');
3728: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_user_id : ' || p_user_id);
3729: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_resp_id : ' || p_resp_id);
3730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'p_appl_id : ' || p_appl_id);
3731: END IF;
3732:
3733: ProfileValue := PO_CLM_CLO_UTIL.checkCLMResp(p_user_id, p_resp_id, p_appl_id);
3734:

Line 3735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3731: END IF;
3732:
3733: ProfileValue := PO_CLM_CLO_UTIL.checkCLMResp(p_user_id, p_resp_id, p_appl_id);
3734:
3735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3736: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
3737: END IF;
3738: -- PO PAR CHANGES for CLMr4 Hiding Dummy Req Begin.
3739: IF ProfileValue <> 'N' THEN

Line 3736: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);

3732:
3733: ProfileValue := PO_CLM_CLO_UTIL.checkCLMResp(p_user_id, p_resp_id, p_appl_id);
3734:
3735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3736: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'ProfileValue : '||ProfileValue);
3737: END IF;
3738: -- PO PAR CHANGES for CLMr4 Hiding Dummy Req Begin.
3739: IF ProfileValue <> 'N' THEN
3740: l_secuirty_clause := ' NVL(PO_REQUISITION_HEADERS_CLM_V.FEDERAL_FLAG,''N'') =''Y''';

Line 3763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3759: RETURN l_secuirty_clause;
3760: -- PO PAR CHANGES for CLMr4 Hiding Dummy Req End.
3761:
3762: EXCEPTION WHEN OTHERS THEN
3763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);
3765: END IF;
3766: END GET_SECURITY_CLAUSE;
3767:

Line 3764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);

3760: -- PO PAR CHANGES for CLMr4 Hiding Dummy Req End.
3761:
3762: EXCEPTION WHEN OTHERS THEN
3763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3764: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, p_proc_name || '.invoked', 'Error : '||SQLERRM);
3765: END IF;
3766: END GET_SECURITY_CLAUSE;
3767:
3768:

Line 3783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3779: ,x_msg_data OUT NOCOPY VARCHAR2
3780: )IS
3781:
3782: l_progress VARCHAR2(4) := '000';
3783: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3784: l_api_name CONSTANT VARCHAR2(100) := 'create_req_line_from_po_line';
3785: l_procedure_name CONSTANT VARCHAR2(30) := 'create_req_line_from_po_line';
3786:
3787: l_from_template_id NUMBER;

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

3891: x_return_status := FND_API.G_RET_STS_SUCCESS;
3892:
3893: EXCEPTION
3894: WHEN OTHERS THEN
3895: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3896: l_log_msg := 'Exception raised. l_progress => '||l_progress;
3897: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3898: END IF;
3899: RAISE_APPLICATION_ERROR(-20000,

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

3893: EXCEPTION
3894: WHEN OTHERS THEN
3895: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3896: l_log_msg := 'Exception raised. l_progress => '||l_progress;
3897: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
3898: END IF;
3899: RAISE_APPLICATION_ERROR(-20000,
3900: 'Exception at POR_UTL_PKG.create_req_line_from_po_line(p_req_line_id:'
3901: || p_req_line_id || ') ' || l_progress || ' SQLERRM:' || SQLERRM);

Line 4270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4266: -- p_req_line_id IN NUMBER
4267:
4268: PROCEDURE delete_supply (p_req_header_id in NUMBER,p_req_line_id IN NUMBER) IS
4269: l_progress VARCHAR2(4) := '000';
4270: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4271: l_api_name CONSTANT VARCHAR2(100) := 'delete_supply';
4272:
4273: BEGIN
4274: l_progress := '010';

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

4281: COMMIT;
4282:
4283: EXCEPTION
4284: WHEN OTHERS THEN
4285: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4286: l_log_msg := 'Error in delete_supply : Progress= ' || l_progress;
4287: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
4288: END IF;
4289: --Rollback the transaction

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

4283: EXCEPTION
4284: WHEN OTHERS THEN
4285: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4286: l_log_msg := 'Error in delete_supply : Progress= ' || l_progress;
4287: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, l_log_msg);
4288: END IF;
4289: --Rollback the transaction
4290: ROLLBACK;
4291: END delete_supply;

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

4422: AND pod.wip_entity_id = wdj.wip_entity_id
4423: AND pod.po_distribution_id = x_dist_id;
4424:
4425: x_progress := '001';
4426: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4427: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);
4428: END IF;
4429: RETURN X_JOB_RELEASED_DATE;
4430: end if;

Line 4427: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);

4423: AND pod.po_distribution_id = x_dist_id;
4424:
4425: x_progress := '001';
4426: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4427: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);
4428: END IF;
4429: RETURN X_JOB_RELEASED_DATE;
4430: end if;
4431: x_progress := '002';

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

4428: END IF;
4429: RETURN X_JOB_RELEASED_DATE;
4430: end if;
4431: x_progress := '002';
4432: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4433: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);
4434: END IF;
4435: return X_JOB_RELEASED_DATE;
4436:

Line 4433: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);

4429: RETURN X_JOB_RELEASED_DATE;
4430: end if;
4431: x_progress := '002';
4432: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4433: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, ' get_job_released_date: Progress= ' || x_progress);
4434: END IF;
4435: return X_JOB_RELEASED_DATE;
4436:
4437: Exception

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

4482: result := 1;
4483: WHEN OTHERS THEN
4484: x_progress := '002';
4485: result := 2;
4486: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4487: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);
4488: END IF;
4489: END;
4490: end if;

Line 4487: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);

4483: WHEN OTHERS THEN
4484: x_progress := '002';
4485: result := 2;
4486: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4487: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);
4488: END IF;
4489: END;
4490: end if;
4491: end if;

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

4494:
4495: Exception
4496: WHEN OTHERS THEN
4497: po_message_s.sql_error('val_po_dist_pjt', 1, sqlcode);
4498: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4499: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);
4500: END IF;
4501: RAISE;
4502: END val_po_dist_pjt;

Line 4499: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);

4495: Exception
4496: WHEN OTHERS THEN
4497: po_message_s.sql_error('val_po_dist_pjt', 1, sqlcode);
4498: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4499: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_po_dist_pjt : Progress= ' || x_progress);
4500: END IF;
4501: RAISE;
4502: END val_po_dist_pjt;
4503:

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

4531: SELECT NAME INTO x_pjt_name FROM PA_PROJECTS_ALL WHERE project_id = x_pjt_id;
4532: EXCEPTION
4533: WHEN No_Data_Found THEN
4534: x_progress := '001';
4535: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4536: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4537: END IF;
4538: WHEN OTHERS THEN
4539: x_progress := '002';

Line 4536: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);

4532: EXCEPTION
4533: WHEN No_Data_Found THEN
4534: x_progress := '001';
4535: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4536: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4537: END IF;
4538: WHEN OTHERS THEN
4539: x_progress := '002';
4540: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

4536: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4537: END IF;
4538: WHEN OTHERS THEN
4539: x_progress := '002';
4540: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4541: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4542: END IF;
4543: END;
4544: end if;

Line 4541: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);

4537: END IF;
4538: WHEN OTHERS THEN
4539: x_progress := '002';
4540: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4541: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4542: END IF;
4543: END;
4544: end if;
4545: end if;

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

4548:
4549: Exception
4550: WHEN OTHERS THEN
4551: po_message_s.sql_error('get_po_dist_project', 1, sqlcode);
4552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4553: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4554: END IF;
4555: RAISE;
4556: END get_po_dist_project;

Line 4553: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);

4549: Exception
4550: WHEN OTHERS THEN
4551: po_message_s.sql_error('get_po_dist_project', 1, sqlcode);
4552: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4553: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_po_dist_project : Progress= ' || x_progress);
4554: END IF;
4555: RAISE;
4556: END get_po_dist_project;
4557:

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

4600: EXCEPTION
4601: WHEN OTHERS THEN
4602: x_progress := '001';
4603: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4605: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4606: END IF;
4607: RAISE;
4608: END;

Line 4605: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);

4601: WHEN OTHERS THEN
4602: x_progress := '001';
4603: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4604: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4605: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4606: END IF;
4607: RAISE;
4608: END;
4609: IF(x_valid_pjt_cnt=0) THEN

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

4619:
4620: Exception
4621: WHEN OTHERS THEN
4622: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4623: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4624: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4625: END IF;
4626: RAISE;
4627: END val_req_line_pjts;

Line 4624: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);

4620: Exception
4621: WHEN OTHERS THEN
4622: po_message_s.sql_error('val_req_line_pjts', 1, sqlcode);
4623: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4624: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in val_req_line_pjts : Progress= ' || x_progress);
4625: END IF;
4626: RAISE;
4627: END val_req_line_pjts;
4628:

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

4680: END IF;
4681: EXCEPTION
4682: WHEN No_Data_Found THEN
4683: x_progress := '001';
4684: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4685: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);
4686: END IF;
4687: WHEN OTHERS THEN
4688: x_progress := '002';

Line 4685: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);

4681: EXCEPTION
4682: WHEN No_Data_Found THEN
4683: x_progress := '001';
4684: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4685: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);
4686: END IF;
4687: WHEN OTHERS THEN
4688: x_progress := '002';
4689: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

4685: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);
4686: END IF;
4687: WHEN OTHERS THEN
4688: x_progress := '002';
4689: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4690: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);
4691: END IF;
4692: END;
4693: END IF;

Line 4690: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);

4686: END IF;
4687: WHEN OTHERS THEN
4688: x_progress := '002';
4689: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4690: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts : Progress= ' || x_progress);
4691: END IF;
4692: END;
4693: END IF;
4694: END LOOP;

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

4704: --Close the cursor
4705: IF (C_Proj%ISOPEN) THEN
4706: CLOSE C_Proj;
4707: END IF;
4708: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4709: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts: Progress= ' || x_progress);
4710: END IF;
4711: RAISE;
4712: END get_req_line_invalid_pjts;

Line 4709: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts: Progress= ' || x_progress);

4705: IF (C_Proj%ISOPEN) THEN
4706: CLOSE C_Proj;
4707: END IF;
4708: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4709: FND_LOG.STRING(G_LEVEL_STATEMENT,l_api_name, 'Error in get_req_line_invalid_pjts: Progress= ' || x_progress);
4710: END IF;
4711: RAISE;
4712: END get_req_line_invalid_pjts;
4713:

Line 4883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4879: ;
4880: l_rowid ROWID;
4881: coaWhereClause VARCHAR2(1000);
4882: l_procedure_name CONSTANT VARCHAR2(30) := 'req_imp_act_up_frm_wf';
4883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4884:
4885: CURSOR coawhereclause_csr(v_id_flex_num NUMBER)
4886: IS
4887: SELECT APPLICATION_COLUMN_NAME

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

4894: BEGIN
4895: IF (g_fnd_debug = 'Y') THEN
4896: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4897: l_log_msg := 'req_imp_act_up_frm_wf START';
4898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
4899: END IF;
4900: END IF;
4901: -- generate the charge account's segments nvl where clause
4902: BEGIN

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

5148: );
5149: IF (g_fnd_debug = 'Y') THEN
5150: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5151: l_log_msg := 'POR_UTIL_PKG:req_imp_act_up_frm_wf - SQL Error Account Generator Loop';
5152: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5153: END IF;
5154: END IF;
5155: END;
5156: END LOOP;

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

5157: CLOSE c_req_import_csr_var;
5158: IF (g_fnd_debug = 'Y') THEN
5159: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5160: l_log_msg := 'req_imp_act_up_frm_wf END';
5161: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5162: END IF;
5163: END IF;
5164: END req_imp_act_up_frm_wf;
5165:

Line 5332: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5328: ;
5329: l_rowid ROWID;
5330: coaWhereClause VARCHAR2(1000);
5331: l_procedure_name CONSTANT VARCHAR2(30) := 'req_imp_mul_dst_act_up_frm_wf';
5332: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5333:
5334: CURSOR coawhereclause_csr(v_id_flex_num NUMBER)
5335: IS
5336: SELECT APPLICATION_COLUMN_NAME

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

5343: BEGIN
5344: IF (g_fnd_debug = 'Y') THEN
5345: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5346: l_log_msg := 'req_imp_mul_dst_act_up_frm_wf START';
5347: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5348: END IF;
5349: END IF;
5350: --generate charge accountr's nvl condition for segments..
5351: BEGIN

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

5597: );
5598: IF (g_fnd_debug = 'Y') THEN
5599: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5600: l_log_msg := 'POR_UTIL_PKG:req_imp_mul_dst_act_up_frm_wf - SQLErr Account Generator Loop';
5601: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5602: END IF;
5603: END IF;
5604: END;
5605: END LOOP;

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

5606: CLOSE c_req_import_csr_var;
5607: IF (g_fnd_debug = 'Y') THEN
5608: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5609: l_log_msg := 'req_imp_mul_dst_act_up_frm_wf END';
5610: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name, l_log_msg);
5611: END IF;
5612: END IF;
5613: END req_imp_mul_dst_act_up_frm_wf;
5614: -- 15900708 changes ends

Line 5685: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5681: WHERE instr(acrns,',') <> 0 AND ROWNUM < 2;
5682:
5683: Begin
5684:
5685: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5686: l_key := PO_CORE_S.get_session_gt_nextval;
5687:
5688: /*Collecting the Charge Accounts, LOAs and the ACRN values populated
5689: into session gt for validation. */

Line 5723: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,

5719:
5720: l_progress := '001';
5721:
5722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5723: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,
5724: 'Progress: ' || l_progress);
5725: END IF;
5726:
5727: /*

Line 5777: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,

5773:
5774: l_progress := '002';
5775:
5776: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5777: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,
5778: 'Progress: ' || l_progress ||
5779: ' Error ICX_DUPLICATE_ACRN Occured');
5780: END IF;
5781:

Line 5827: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,

5823:
5824: l_progress := '003';
5825:
5826: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5827: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name,
5828: 'Progress: ' || l_progress ||
5829: ' Error ICX_ACRN_CHARGE_ACCOUNT Occured');
5830: END IF;
5831:

Line 5864: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,

5860:
5861: l_progress := '010';
5862:
5863: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5864: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,
5865: 'Progress: ' || l_progress || ' Start');
5866: END IF;
5867:
5868: select count(1) into l_pdf_exists

Line 5876: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,

5872:
5873: l_progress := '020';
5874:
5875: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5876: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,
5877: 'Progress: ' || l_progress || 'PDF Exists: ' || l_pdf_exists);
5878: END IF;
5879:
5880: select max(revision_num) into l_revision_num

Line 5891: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME|| l_api_name, l_progress || ' Revision Number taken as Zero');

5887: IF l_revision_num IS NULL THEN
5888: l_progress := '030';
5889: l_revision_num := 0;
5890: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
5891: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME|| l_api_name, l_progress || ' Revision Number taken as Zero');
5892: END IF;
5893: END IF;
5894:
5895: l_progress := '040';

Line 5898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,

5894:
5895: l_progress := '040';
5896:
5897: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
5898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,
5899: 'Progress: ' || l_progress || 'Launching Email WorkFlow Process');
5900: END IF;
5901:
5902: if l_pdf_exists > 0 THEN

Line 5922: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME|| l_api_name, l_progress || 'Unexpected Error Occured');

5918: exception
5919: when others then
5920: l_progress := '050';
5921: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL ) THEN
5922: FND_LOG.STRING(G_LEVEL_UNEXPECTED, G_MODULE_NAME|| l_api_name, l_progress || 'Unexpected Error Occured');
5923: END IF;
5924: raise;
5925: end Communicate;
5926:

Line 6132: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,

6128: l_rec_found NUMBER;
6129: BEGIN
6130: l_progress := 'POR_UTIL_PKG.insert_action_in_mipr_history: Start';
6131: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
6132: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,
6133: 'Progress: ' || l_progress );
6134: END IF;
6135:
6136: SELECT Count(*) INTO l_rec_found

Line 6178: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,

6174: EXCEPTION
6175: WHEN OTHERS THEN
6176: l_progress := 'POR_UTIL_PKG.insert_action_in_mipr_history: In Exception handler';
6177: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
6178: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_api_name,
6179: 'Progress: ' || l_progress );
6180: END IF;
6181:
6182: RAISE;