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.

[Home] [Help]

APPS.EAM_MATERIALISSUE_PVT dependencies on FND_LOG

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

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

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

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

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

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

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

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

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

140: -- Initialize API return status to success
141: x_return_status := FND_API.G_RET_STS_SUCCESS;
142:
143: -- API body
144: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
145: 'Start of ' || l_full_name || '('
146: || 'p_commit='|| p_commit ||','
147: || 'p_wip_entity_type='|| p_wip_entity_type || ','
148: || 'p_organization_id='|| p_organization_id || ','

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

172: into l_material_issue_by_mo, l_project_id, l_task_id
173: from wip_discrete_jobs where
174: wip_entity_id=p_wip_entity_id
175: and organization_id=p_organization_id;
176: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
177: 'l_material_issue_by_mo=' || l_material_issue_by_mo);
178: end if;
179: if (l_project_id is null) then l_project_id := fnd_api.G_MISS_NUM;
180: end if;

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

184: l_issue_by_mo := false;
185: end if;
186:
187: --selecting the item name,UOM,serial_control_code
188: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
189: 'Getting serial, lot control codes');
190: end if;
191: --fix for 3454251.added code to fetch material name
192: select primary_uom_code,

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

463: begin ----------------(1)
464: --quantity signed is reversed when values are inserted in MTI
465: l_quantity:=-1*p_requested_quantity;
466: begin
467: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
468: 'Calling PROCESSMTLTXN');
469: end if;
470: savepoint before_insert_mti;
471: --inserting values into MTI Table

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

547: and mp.maint_organization_id = p_organization_id
548: and eam_item_type = 3 --3 for rebuild
549: and rownum = 1;
550: end if;
551: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
552: 'Inserting rebuild item id: '|| l_rebuild_item_id);
553: end if;
554: update mtl_transactions_interface
555: set rebuild_item_id=l_rebuild_item_id

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

575: where concatenated_segments = p_rebuild_activity_name
576: and organization_id = p_organization_id
577: and eam_item_type = 2; --2 for activity
578: end if;
579: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
580: 'Inserting rebuild activity id: '|| l_rebuild_activity_id);
581: end if;
582: update mtl_transactions_interface
583: set rebuild_activity_id=l_rebuild_activity_id

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

584: where transaction_interface_id= x_tmp_id;
585: end;
586: end if;
587:
588: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
589: 'inserting rebuild job');
590: end if;
591: if ((p_rebuild_job_name is null) and (l_rebuild_item_id is not null))then
592:

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

631:
632:
633: -- only call txn processor if online processing. 4(form level) is treated as 1.
634: if (EAM_MATERIALISSUE_PVT.get_tx_processor_mode() in (1,4)) then
635: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
636: 'Calling INV_TXN_MANAGER_PUB.process_Transactions');
637: end if;
638: l_txmgr_ret_code := INV_TXN_MANAGER_PUB.process_Transactions(
639: p_api_version => 1.0,

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

643: x_msg_count => x_msg_count,
644: x_trans_count => l_tx_count,
645: x_msg_data => x_error_mssg1);
646: if (l_sLog) then
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
648: 'INV_TXN_MANAGER_PUB finished with return code='|| l_txmgr_ret_code);
649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
650: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
651: end if;

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

645: x_msg_data => x_error_mssg1);
646: if (l_sLog) then
647: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
648: 'INV_TXN_MANAGER_PUB finished with return code='|| l_txmgr_ret_code);
649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
650: 'INV_TXN_MANAGER_PUB finished with return status='|| x_wip_ret_status);
651: end if;
652:
653: if(x_wip_ret_status = FND_API.G_RET_STS_UNEXP_ERROR OR

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

697: end if;
698:
699: end;-----{1}
700:
701: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
702: 'End of ' || l_full_name );
703: end if;
704: -- End of API body.
705:

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

715: EXCEPTION
716: WHEN OTHERS THEN
717: ROLLBACK TO fork_logic;
718: if (l_log) then
719: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured' );
720: end if;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
723: THEN

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

743: l_api_name CONSTANT VARCHAR2(30) := 'process_mmtt';
744: l_api_version CONSTANT NUMBER := 1.0;
745: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
746: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
747: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
748: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
749: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
750: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
751:

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

744: l_api_version CONSTANT NUMBER := 1.0;
745: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
746: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
747: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
748: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
749: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
750: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
751:
752: l_msg_data VARCHAR2(50);

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

745: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
746: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
747: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
748: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
749: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
750: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
751:
752: l_msg_data VARCHAR2(50);
753: l_return_status VARCHAR2(2000);

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

746: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
747: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
748: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
749: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
750: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
751:
752: l_msg_data VARCHAR2(50);
753: l_return_status VARCHAR2(2000);
754: l_header_id number := null;

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

755: NO_ACCT_PERIOD_EXC EXCEPTION; -- Added for bug 4041420
756: l_acct_period_id number := null; -- Added for bug 4041420
757:
758: BEGIN
759: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
760: 'Start of ' || l_full_name || '('
761: || 'p_init_msg_list='|| p_init_msg_list ||','
762: || 'p_commit='|| p_commit ||','
763: || 'p_trx_tmp_id='|| to_number(p_trx_tmp_id) || ','

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

810: transaction_status = null, --Added since WIP is no longer doing this in 11.5.10
811: primary_quantity = -1* primary_quantity,
812: transaction_quantity = -1* transaction_quantity
813: where transaction_temp_id = p_trx_tmp_id;
814: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
815: 'Calling wip_mtlTempProc_grp.processTemp. p_txnHdrID=' || l_header_id);
816: end if;
817: wip_mtlTempProc_grp.processTemp(
818: p_initMsgList => fnd_api.G_TRUE,

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

819: p_processInv => fnd_api.G_TRUE, --whether or not to call inventory TM
820: p_txnHdrID => l_header_id,
821: x_returnStatus => x_return_status,
822: x_errorMsg => x_msg_data);
823: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
824: 'wip_mtlTempProc_grp.processTemp returned. x_returnStatus='||x_return_status
825: ||', x_errorMsg=' || REPLACE(x_msg_data, CHR(0), ' '));
826: end if;
827: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

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

839: /* end of fix for bug no:2719414 */
840: FND_MSG_PUB.Count_And_Get('T', x_msg_count, x_msg_data);
841: return;
842: end if;
843: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
844: end if;
845: -- End of API body.
846:
847: -- Standard check of p_commit.

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

860: /* Added for bug 4041420 - End */
861: WHEN OTHERS THEN
862: ROLLBACK TO PROCESS_MMTT;
863: if (l_log) then
864: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module, 'Exception occured');
865: end if;
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN

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

1135: x_msg_count OUT NOCOPY NUMBER) IS
1136:
1137: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
1138: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1139: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1140: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
1141: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
1142: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1143: l_api_version CONSTANT NUMBER := 1.0;

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

1136:
1137: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
1138: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1139: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1140: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
1141: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
1142: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_wip_entity_id NUMBER;

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

1137: l_api_name CONSTANT VARCHAR2(30) := 'comp_alloc_chng_qty';
1138: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1139: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1140: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
1141: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
1142: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_wip_entity_id NUMBER;
1145: l_organization_id NUMBER;

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

1138: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
1139: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1140: l_log boolean := FND_LOG.LEVEL_UNEXPECTED >= l_current_log_level ;
1141: l_plog boolean := l_log and FND_LOG.LEVEL_PROCEDURE >= l_current_log_level ;
1142: l_slog boolean := l_plog and FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1143: l_api_version CONSTANT NUMBER := 1.0;
1144: l_wip_entity_id NUMBER;
1145: l_organization_id NUMBER;
1146: l_operation_seq_num NUMBER;

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

1188:
1189: -- API body
1190:
1191: if (l_plog) then
1192: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1193: 'Start of ' || l_module || '('
1194: || 'p_organization_id='|| p_organization_id || ','
1195: || 'p_wip_entity_id='|| p_wip_entity_id || ','
1196: || 'p_operation_seq_num='|| p_operation_seq_num || ','

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

1577: l_task_id NUMBER;
1578: l_status_type NUMBER;
1579: l_request_number VARCHAR2(30);
1580: l_pickslip_conc_req_id NUMBER := 0;
1581: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1582: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1583: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1584: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1585: l_msg VARCHAR2(2000);

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

1578: l_status_type NUMBER;
1579: l_request_number VARCHAR2(30);
1580: l_pickslip_conc_req_id NUMBER := 0;
1581: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1582: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1583: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1584: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1585: l_msg VARCHAR2(2000);
1586:

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

1579: l_request_number VARCHAR2(30);
1580: l_pickslip_conc_req_id NUMBER := 0;
1581: l_current_log_level constant number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1582: l_pLog BOOLEAN := FND_LOG.LEVEL_PROCEDURE >= l_current_log_level;
1583: l_sLog BOOLEAN := l_pLog AND FND_LOG.LEVEL_STATEMENT >= l_current_log_level ;
1584: l_module CONSTANT VARCHAR2(100):= 'eam.plsql.'||g_pkg_name||'.'||l_api_name;
1585: l_msg VARCHAR2(2000);
1586:
1587:

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

1611: -- Initialize API return status to success
1612: x_return_status := fnd_api.g_ret_sts_success;
1613:
1614: -- API body
1615: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'Start');
1616: end if;
1617:
1618: l_wip_entity_id := p_wip_entity_id;
1619: l_organization_id := p_organization_id;

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

1635: l_allocate_rec.bill_org_id := null;
1636: l_allocate_rec.alt_rtg_dsg := null;
1637: l_allocate_tbl(1) := l_allocate_rec;
1638:
1639: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1640: 'Calling wip_picking_pub.allocate');
1641: end if;
1642: wip_picking_pub.allocate(p_alloc_tbl => l_allocate_tbl,
1643: p_cutoff_date => null,

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

1658: if (l_sLog) then
1659: l_msg := 'wip_picking_pub.allocate returned:'|| 'x_return_status:'
1660: ||x_return_status||' x_mo_req_number:'||l_request_number;
1661: l_msg := REPLACE(l_msg, CHR(0), ' ');
1662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);
1663: end if;
1664:
1665: elsif p_status_type IN (5,7) then --status_type 5 is added for bug 7631627
1666: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

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

1662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,l_msg);
1663: end if;
1664:
1665: elsif p_status_type IN (5,7) then --status_type 5 is added for bug 7631627
1666: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1667: 'Calling wip_picking_pub.cancel_allocations');
1668: end if;
1669: wip_picking_pub.cancel_allocations (p_wip_entity_id => l_wip_entity_id,
1670: p_wip_entity_type => wip_constants.eam,

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

1678: if(l_msg_data<>null) then
1679: x_msg_data := l_msg_data;
1680: end if;
1681:
1682: if (l_sLog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1683: 'wip_picking_pub.cancel_allocations returned:'|| 'x_return_status:'
1684: ||x_return_status);
1685: end if;
1686: end if;

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

1691: COMMIT WORK;
1692: END IF;
1693:
1694: -- Standard call to get message count and if count is 1, get message info.
1695: if (l_pLog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, 'End');
1696: end if;
1697: fnd_msg_pub.count_and_get(
1698: p_count => x_msg_count
1699: ,p_data => x_msg_data);

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

1730: l_proc_mode number := 1;
1731: l_api_name CONSTANT VARCHAR2(30) := 'get_tx_processor_mode';
1732: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1733: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
1734: l_slog boolean := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1735: begin
1736: l_proc_mode := FND_PROFILE.VALUE('TRANSACTION_PROCESS_MODE');
1737: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1738: 'Inventory transaction processor mode (TRANSACTION_PROCESS_MODE) = '||l_proc_mode);

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

1733: l_module CONSTANT VARCHAR2(60) := 'eam.plsql.'||l_full_name;
1734: l_slog boolean := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
1735: begin
1736: l_proc_mode := FND_PROFILE.VALUE('TRANSACTION_PROCESS_MODE');
1737: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
1738: 'Inventory transaction processor mode (TRANSACTION_PROCESS_MODE) = '||l_proc_mode);
1739: end if;
1740: return l_proc_mode;
1741: end;