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

Line 40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

36: l_api_name CONSTANT VARCHAR2(30) := 'Fork_Logic';
37: l_api_version CONSTANT NUMBER := 1.0;
38: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
39: l_module constant varchar2(60) := 'eam.plsql.'||l_full_name;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_log constant boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
42: l_plog constant boolean := l_log and FND_LOG.LEVEL_PROCEDURE >=l_current_log_level ;
43: l_slog constant boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
44:

Line 41: l_log constant boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;

37: l_api_version CONSTANT NUMBER := 1.0;
38: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
39: l_module constant varchar2(60) := 'eam.plsql.'||l_full_name;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_log constant boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
42: l_plog constant boolean := l_log and FND_LOG.LEVEL_PROCEDURE >=l_current_log_level ;
43: l_slog constant boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
44:
45:

Line 42: l_plog constant boolean := l_log and FND_LOG.LEVEL_PROCEDURE >=l_current_log_level ;

38: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
39: l_module constant varchar2(60) := 'eam.plsql.'||l_full_name;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_log constant boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
42: l_plog constant boolean := l_log and FND_LOG.LEVEL_PROCEDURE >=l_current_log_level ;
43: l_slog constant boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
44:
45:
46: l_material_issue_by_mo varchar2(1);

Line 43: l_slog constant boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;

39: l_module constant varchar2(60) := 'eam.plsql.'||l_full_name;
40: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
41: l_log constant boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
42: l_plog constant boolean := l_log and FND_LOG.LEVEL_PROCEDURE >=l_current_log_level ;
43: l_slog constant boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
44:
45:
46: l_material_issue_by_mo varchar2(1);
47: l_project_id number := null;

Line 95: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- API body
95: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
96: 'Start of ' || l_full_name || '('
97: || 'p_commit='|| p_commit ||','
98: || 'p_wip_entity_type='|| p_wip_entity_type || ','
99: || 'p_organization_id='|| p_organization_id || ','

Line 127: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

123: into l_material_issue_by_mo, l_project_id, l_task_id
124: from wip_discrete_jobs where
125: wip_entity_id=p_wip_entity_id
126: and organization_id=p_organization_id;
127: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
128: 'l_material_issue_by_mo=' || l_material_issue_by_mo);
129: end if;
130: if (l_project_id is null) then l_project_id := fnd_api.G_MISS_NUM;
131: end if;

Line 139: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

135: l_issue_by_mo := false;
136: end if;
137:
138: --selecting the item name,UOM,serial_control_code
139: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
140: 'Getting serial, lot control codes');
141: end if;
142: --fix for 3454251.added code to fetch material name
143: select primary_uom_code,

Line 258: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

254: begin ----------------(1)
255: --quantity signed is reversed when values are inserted in MTI
256: l_quantity:=-1*p_requested_quantity;
257: begin
258: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
259: 'Calling PROCESSMTLTXN');
260: end if;
261: savepoint before_insert_mti;
262: --inserting values into MTI Table

Line 342: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

338: and mp.maint_organization_id = p_organization_id
339: and eam_item_type = 3 --3 for rebuild
340: and rownum = 1;
341: end if;
342: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
343: 'Inserting rebuild item id: '|| l_rebuild_item_id);
344: end if;
345: update mtl_transactions_interface
346: set rebuild_item_id=l_rebuild_item_id

Line 370: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

366: where concatenated_segments = p_rebuild_activity_name
367: and organization_id = p_organization_id
368: and eam_item_type = 2; --2 for activity
369: end if;
370: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
371: 'Inserting rebuild activity id: '|| l_rebuild_activity_id);
372: end if;
373: update mtl_transactions_interface
374: set rebuild_activity_id=l_rebuild_activity_id

Line 379: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

375: where transaction_interface_id= x_tmp_id;
376: end;
377: end if;
378:
379: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
380: 'inserting rebuild job');
381: end if;
382: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
383:

Line 426: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

422:
423:
424: -- only call txn processor if online processing. 4(form level) is treated as 1.
425: if (EAM_MATERIALISSUE_PVT.get_tx_processor_mode() in (1,4)) then
426: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
427: 'Calling INV_TXN_MANAGER_PUB.process_Transactions');
428: end if;
429: l_txmgr_ret_code := INV_TXN_MANAGER_PUB.process_Transactions(
430: p_api_version => 1.0,

Line 438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

434: x_msg_count => x_msg_count,
435: x_trans_count => l_tx_count,
436: x_msg_data => x_error_mssg1);
437: if (l_sLog) then
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
439: 'INV_TXN_MANAGER_PUB finished with return code='|| l_txmgr_ret_code);
440: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
441: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
442: end if;

Line 440: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

436: x_msg_data => x_error_mssg1);
437: if (l_sLog) then
438: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
439: 'INV_TXN_MANAGER_PUB finished with return code='|| l_txmgr_ret_code);
440: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
441: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
442: end if;
443:
444: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

Line 474: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

470: end if;
471:
472: end;-----{1}
473:
474: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
475: 'End of ' || l_full_name );
476: end if;
477: -- End of API body.
478:

Line 492: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );

488: EXCEPTION
489: WHEN OTHERS THEN
490: ROLLBACK TO fork_logic;
491: if (l_log) then
492: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );
493: end if;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
495: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN

Line 520: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

516: l_api_name CONSTANT VARCHAR2(30) := 'process_mmtt';
517: l_api_version CONSTANT NUMBER := 1.0;
518: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
519: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
520: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
521: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
522: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
523: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
524:

Line 521: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;

517: l_api_version CONSTANT NUMBER := 1.0;
518: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
519: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
520: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
521: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
522: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
523: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
524:
525: l_msg_data VARCHAR2(50);

Line 522: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;

518: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
519: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
520: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
521: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
522: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
523: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
524:
525: l_msg_data VARCHAR2(50);
526: l_return_status VARCHAR2(2000);

Line 523: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;

519: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
520: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
521: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
522: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
523: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
524:
525: l_msg_data VARCHAR2(50);
526: l_return_status VARCHAR2(2000);
527: l_header_id number := null;

Line 532: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

528: NO_ACCT_PERIOD_EXC EXCEPTION; -- Added for bug 4041420
529: l_acct_period_id number := null; -- Added for bug 4041420
530:
531: BEGIN
532: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
533: 'Start of ' || l_full_name || '('
534: || 'p_init_msg_list='|| p_init_msg_list ||','
535: || 'p_commit='|| p_commit ||','
536: || 'p_trx_tmp_id='|| to_number(p_trx_tmp_id) || ','

Line 587: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

583: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
584: primary_quantity = -1* primary_quantity,
585: transaction_quantity = -1* transaction_quantity
586: where transaction_temp_id = p_trx_tmp_id;
587: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
588: 'Calling wip_mtlTempProc_grp.processTemp. p_txnHdrID=' || l_header_id);
589: end if;
590: wip_mtlTempProc_grp.processTemp(
591: p_initMsgList => fnd_api.G_TRUE,

Line 596: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

592: p_processInv => fnd_api.G_TRUE, --whether or not to call inventory TM
593: p_txnHdrID => l_header_id,
594: x_returnStatus => x_return_status,
595: x_errorMsg => x_msg_data);
596: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
597: 'wip_mtlTempProc_grp.processTemp returned. x_returnStatus='||x_return_status
598: ||', x_errorMsg=' || REPLACE(x_msg_data, CHR(0), ' '));
599: end if;
600: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

Line 616: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');

612: /* end of fix for bug no:2719414 */
613: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
614: return;
615: end if;
616: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
617: end if;
618: -- End of API body.
619:
620: -- Standard check of p_commit.

Line 637: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');

633: /* Added for bug 4041420 - End */
634: WHEN OTHERS THEN
635: ROLLBACK TO PROCESS_MMTT;
636: if (l_log) then
637: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');
638: end if;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN

Line 912: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

908: x_msg_count OUT NOCOPY NUMBER) IS
909:
910: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
911: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
912: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
913: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
914: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
915: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
916: l_api_version CONSTANT NUMBER := 1.0;

Line 913: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;

909:
910: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
911: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
912: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
913: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
914: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
915: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
916: l_api_version CONSTANT NUMBER := 1.0;
917: l_wip_entity_id NUMBER;

Line 914: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;

910: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
911: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
912: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
913: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
914: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
915: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
916: l_api_version CONSTANT NUMBER := 1.0;
917: l_wip_entity_id NUMBER;
918: l_organization_id NUMBER;

Line 915: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;

911: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
912: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
913: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
914: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
915: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
916: l_api_version CONSTANT NUMBER := 1.0;
917: l_wip_entity_id NUMBER;
918: l_organization_id NUMBER;
919: l_operation_seq_num NUMBER;

Line 965: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

961:
962: -- API body
963:
964: if (l_plog) then
965: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
966: 'Start of ' || l_module || '('
967: || 'p_organization_id='|| p_organization_id || ','
968: || 'p_wip_entity_id='|| p_wip_entity_id || ','
969: || 'p_operation_seq_num='|| p_operation_seq_num || ','

Line 1354: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

1350: l_task_id NUMBER;
1351: l_status_type NUMBER;
1352: l_request_number VARCHAR2(30);
1353: l_pickslip_conc_req_id NUMBER := 0;
1354: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1355: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1356: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1357: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1358: l_msg VARCHAR2(2000);

Line 1355: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;

1351: l_status_type NUMBER;
1352: l_request_number VARCHAR2(30);
1353: l_pickslip_conc_req_id NUMBER := 0;
1354: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1355: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1356: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1357: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1358: l_msg VARCHAR2(2000);
1359:

Line 1356: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;

1352: l_request_number VARCHAR2(30);
1353: l_pickslip_conc_req_id NUMBER := 0;
1354: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1355: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1356: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1357: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1358: l_msg VARCHAR2(2000);
1359:
1360:

Line 1388: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start');

1384: -- Initialize API return status to success
1385: x_return_status := fnd_api.g_ret_sts_success;
1386:
1387: -- API body
1388: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start');
1389: end if;
1390:
1391: l_wip_entity_id := p_wip_entity_id;
1392: l_organization_id := p_organization_id;

Line 1412: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

1408: l_allocate_rec.bill_org_id := null;
1409: l_allocate_rec.alt_rtg_dsg := null;
1410: l_allocate_tbl(1) := l_allocate_rec;
1411:
1412: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1413: 'Calling wip_picking_pub.allocate');
1414: end if;
1415: wip_picking_pub.allocate(p_alloc_tbl => l_allocate_tbl,
1416: p_cutoff_date => null,

Line 1427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);

1423: if (l_sLog) then
1424: l_msg := 'wip_picking_pub.allocate returned:'|| 'x_return_status:'
1425: ||x_return_status||' x_mo_req_number:'||l_request_number;
1426: l_msg := REPLACE(l_msg, CHR(0), ' ');
1427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);
1428: end if;
1429:
1430: elsif (p_status_type = 7) then
1431: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 1431: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

1427: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);
1428: end if;
1429:
1430: elsif (p_status_type = 7) then
1431: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1432: 'Calling wip_picking_pub.cancel_allocations');
1433: end if;
1434: wip_picking_pub.cancel_allocations (p_wip_entity_id => l_wip_entity_id,
1435: p_wip_entity_type => wip_constants.eam,

Line 1439: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

1435: p_wip_entity_type => wip_constants.eam,
1436: p_repetitive_schedule_id => NULL,
1437: x_return_status => l_return_status,
1438: x_msg_data => l_msg_data);
1439: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1440: 'wip_picking_pub.cancel_allocations returned:'|| 'x_return_status:'
1441: ||x_return_status);
1442: end if;
1443: end if;

Line 1452: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');

1448: COMMIT WORK;
1449: END IF;
1450:
1451: -- Standard call to get message count and if count is 1, get message info.
1452: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
1453: end if;
1454: fnd_msg_pub.count_and_get(
1455: p_count => x_msg_count
1456: ,p_data => x_msg_data);

Line 1491: l_slog boolean := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

1487: l_proc_mode number := 1;
1488: l_api_name CONSTANT VARCHAR2(30) := 'get_tx_processor_mode';
1489: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1490: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
1491: l_slog boolean := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1492: begin
1493: l_proc_mode := FND_PROFILE.VALUE('TRANSACTION_PROCESS_MODE');
1494: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1495: 'Inventory transaction processor mode (TRANSACTION_PROCESS_MODE) = '||l_proc_mode);

Line 1494: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

1490: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
1491: l_slog boolean := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1492: begin
1493: l_proc_mode := FND_PROFILE.VALUE('TRANSACTION_PROCESS_MODE');
1494: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1495: 'Inventory transaction processor mode (TRANSACTION_PROCESS_MODE) = '||l_proc_mode);
1496: end if;
1497: return l_proc_mode;
1498: end;