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

Line 4365: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4361: --------------------Initialize ----------------------------------
4362: -- Standard Start of API savepoint
4363: SAVEPOINT Change_Requirement_Item;
4364:
4365: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4366: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin',
4367: 'At the start of PLSQL procedure.');
4368: END IF;
4369:

Line 4366: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin',

4362: -- Standard Start of API savepoint
4363: SAVEPOINT Change_Requirement_Item;
4364:
4365: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4366: fnd_log.string(fnd_log.level_procedure, l_debug_key || '.begin',
4367: 'At the start of PLSQL procedure.');
4368: END IF;
4369:
4370: -- Standard call to check for call compatibility.

Line 4385: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4381: THEN
4382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4383: END IF;
4384:
4385: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4386: fnd_log.string(fnd_log.level_statement, l_debug_key, 'requirements count'||p_x_req_material_tbl.COUNT);
4387: END IF;
4388: --------------------Start of API Body-----------------------------------
4389: IF p_x_req_material_tbl.COUNT > 0 THEN

Line 4386: fnd_log.string(fnd_log.level_statement, l_debug_key, 'requirements count'||p_x_req_material_tbl.COUNT);

4382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4383: END IF;
4384:
4385: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4386: fnd_log.string(fnd_log.level_statement, l_debug_key, 'requirements count'||p_x_req_material_tbl.COUNT);
4387: END IF;
4388: --------------------Start of API Body-----------------------------------
4389: IF p_x_req_material_tbl.COUNT > 0 THEN
4390: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST

Line 4401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4397: Fnd_Msg_Pub.ADD;
4398: RAISE FND_API.G_EXC_ERROR;
4399: END IF;
4400:
4401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4402: fnd_log.string(fnd_log.level_statement, l_debug_key, 'Schedule Material ID'||l_schedule_material_id);
4403: END IF;
4404:
4405: -- Get Scheduled Material requirement details

Line 4402: fnd_log.string(fnd_log.level_statement, l_debug_key, 'Schedule Material ID'||l_schedule_material_id);

4398: RAISE FND_API.G_EXC_ERROR;
4399: END IF;
4400:
4401: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4402: fnd_log.string(fnd_log.level_statement, l_debug_key, 'Schedule Material ID'||l_schedule_material_id);
4403: END IF;
4404:
4405: -- Get Scheduled Material requirement details
4406: OPEN Get_Mtl_Req_Csr(l_schedule_material_id);

Line 4513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4509: l_new_requested_qty := l_old_wip_req_rec.required_quantity - l_material_req_rec.old_requested_quantity;
4510:
4511: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4512: --
4513: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4514: AHL_DEBUG_PUB.debug( 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4515: END IF;
4516: --Create Record in transactions table
4517: Log_Transaction_Record

Line 4533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4529: p_inventory_item_id => l_material_req_rec.old_inventory_item_id,
4530: p_required_quantity => l_new_requested_qty,
4531: p_date_required => p_x_req_material_tbl(i).requested_date
4532: );
4533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4534: fnd_log.string(fnd_log.level_statement, l_debug_key, 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4535: END IF;
4536:
4537: -- Update the original WIP requirement

Line 4534: fnd_log.string(fnd_log.level_statement, l_debug_key, 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

4530: p_required_quantity => l_new_requested_qty,
4531: p_date_required => p_x_req_material_tbl(i).requested_date
4532: );
4533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4534: fnd_log.string(fnd_log.level_statement, l_debug_key, 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4535: END IF;
4536:
4537: -- Update the original WIP requirement
4538: l_material_req_up_tbl(up_index).schedule_material_id := l_schedule_material_id;

Line 4586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4582:
4583: -- If WIP requirement exists for the new item then throw the error.
4584: -- This part needs to be changed during Marshaling
4585: IF (l_new_wip_req_rec.wip_entity_id IS NOT NULL) THEN
4586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4587: fnd_log.string(fnd_log.level_statement, l_debug_key, 'WIP entity ID already exists for Item: ' || p_x_req_material_tbl(i).inventory_item_id);
4588: END IF;
4589:
4590: OPEN Get_Item_Name_Cur(p_x_req_material_tbl(i).inventory_item_id,

Line 4587: fnd_log.string(fnd_log.level_statement, l_debug_key, 'WIP entity ID already exists for Item: ' || p_x_req_material_tbl(i).inventory_item_id);

4583: -- If WIP requirement exists for the new item then throw the error.
4584: -- This part needs to be changed during Marshaling
4585: IF (l_new_wip_req_rec.wip_entity_id IS NOT NULL) THEN
4586: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4587: fnd_log.string(fnd_log.level_statement, l_debug_key, 'WIP entity ID already exists for Item: ' || p_x_req_material_tbl(i).inventory_item_id);
4588: END IF;
4589:
4590: OPEN Get_Item_Name_Cur(p_x_req_material_tbl(i).inventory_item_id,
4591: l_material_req_rec.organization_id);

Line 4602: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4598: ELSE
4599: -- If no WIP requirement exists for the new item then create a WIP requirement.
4600: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4601: --
4602: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4603: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4604: END IF;
4605: --Create Record in transactions table
4606: Log_Transaction_Record

Line 4603: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);

4599: -- If no WIP requirement exists for the new item then create a WIP requirement.
4600: SELECT AHL_WO_OPERATIONS_TXNS_S.NEXTVAL INTO l_wo_operation_txn_id FROM DUAL;
4601: --
4602: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4603: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4604: END IF;
4605: --Create Record in transactions table
4606: Log_Transaction_Record
4607: ( p_wo_operation_txn_id => l_wo_operation_txn_id,

Line 4622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4618: p_inventory_item_id => p_x_req_material_tbl(i).inventory_item_id,
4619: p_required_quantity => p_x_req_material_tbl(i).requested_quantity,
4620: p_date_required => p_x_req_material_tbl(i).requested_date
4621: );
4622: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4623: AHL_DEBUG_PUB.debug( 'After calling log record l_wo_operation_txn_id:'||l_wo_operation_txn_id);
4624: END IF;
4625:
4626: l_material_req_cr_tbl(cr_index).schedule_material_id := l_schedule_material_id;

Line 4648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4644: END IF; -- End of existance of WIP requirement for the new item check.
4645: END IF; -- End of existance of WIP requirement for the original item check.
4646: END IF; -- End of item changed check.
4647: ELSE
4648: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4649: AHL_DEBUG_PUB.debug( 'Invalid Scedule Material Id: '||l_schedule_material_id);
4650: END IF;
4651: Fnd_Message.SET_NAME('AHL','AHL_RSV_INVALID_MTRLREQ'); -- Material Requirement is Invalid.
4652: Fnd_Msg_Pub.ADD;

Line 4656: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4652: Fnd_Msg_Pub.ADD;
4653: END IF; -- End of existance of ASM requirement for the original item check.
4654: END LOOP; -- End of p_x_req_material_tbl loop
4655: IF (l_material_req_re_tbl.COUNT > 0 ) THEN
4656: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4657: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements');
4658: END IF;
4659: -- Call wip job api
4660: AHL_EAM_JOB_PVT.process_material_req

Line 4657: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements');

4653: END IF; -- End of existance of ASM requirement for the original item check.
4654: END LOOP; -- End of p_x_req_material_tbl loop
4655: IF (l_material_req_re_tbl.COUNT > 0 ) THEN
4656: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4657: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements');
4658: END IF;
4659: -- Call wip job api
4660: AHL_EAM_JOB_PVT.process_material_req
4661: (

Line 4674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4670: x_msg_data => l_msg_data,
4671: p_material_req_tbl => l_material_req_re_tbl
4672: );
4673: --
4674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4675: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements, Status: '||l_return_status);
4676: END IF;
4677: END IF;
4678: IF (l_material_req_cr_tbl.COUNT > 0 AND l_return_status = 'S') THEN

Line 4675: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements, Status: '||l_return_status);

4671: p_material_req_tbl => l_material_req_re_tbl
4672: );
4673: --
4674: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4675: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements, Status: '||l_return_status);
4676: END IF;
4677: END IF;
4678: IF (l_material_req_cr_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 4679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4675: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to remove WIP requirements, Status: '||l_return_status);
4676: END IF;
4677: END IF;
4678: IF (l_material_req_cr_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4680: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements');
4681: END IF;
4682: -- Call wip job api
4683: AHL_EAM_JOB_PVT.process_material_req

Line 4680: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements');

4676: END IF;
4677: END IF;
4678: IF (l_material_req_cr_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4680: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements');
4681: END IF;
4682: -- Call wip job api
4683: AHL_EAM_JOB_PVT.process_material_req
4684: (

Line 4697: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4693: x_msg_data => l_msg_data,
4694: p_material_req_tbl => l_material_req_cr_tbl
4695: );
4696: --
4697: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4698: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements, Status: '||l_return_status);
4699: END IF;
4700: END IF;
4701: IF (l_material_req_up_tbl.COUNT > 0 AND l_return_status = 'S') THEN

Line 4698: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements, Status: '||l_return_status);

4694: p_material_req_tbl => l_material_req_cr_tbl
4695: );
4696: --
4697: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4698: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements, Status: '||l_return_status);
4699: END IF;
4700: END IF;
4701: IF (l_material_req_up_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4702: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 4702: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4698: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to Create WIP requirements, Status: '||l_return_status);
4699: END IF;
4700: END IF;
4701: IF (l_material_req_up_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4702: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4703: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements');
4704: END IF;
4705: -- Call wip job api
4706: AHL_EAM_JOB_PVT.process_material_req

Line 4703: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements');

4699: END IF;
4700: END IF;
4701: IF (l_material_req_up_tbl.COUNT > 0 AND l_return_status = 'S') THEN
4702: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4703: fnd_log.string(fnd_log.level_statement, l_debug_key, 'before calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements');
4704: END IF;
4705: -- Call wip job api
4706: AHL_EAM_JOB_PVT.process_material_req
4707: (

Line 4720: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4716: x_msg_data => l_msg_data,
4717: p_material_req_tbl => l_material_req_up_tbl
4718: );
4719: --
4720: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4721: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements, Status: '||l_return_status);
4722: END IF;
4723: END IF;
4724: IF (l_return_status = 'S') THEN

Line 4721: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements, Status: '||l_return_status);

4717: p_material_req_tbl => l_material_req_up_tbl
4718: );
4719: --
4720: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4721: fnd_log.string(fnd_log.level_statement, l_debug_key, 'after calling AHL_EAM_JOB_PVT.process_material_req to update WIP requirements, Status: '||l_return_status);
4722: END IF;
4723: END IF;
4724: IF (l_return_status = 'S') THEN
4725: FOR i IN p_x_req_material_tbl.FIRST..p_x_req_material_tbl.LAST

Line 4773: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4769: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4770: COMMIT;
4771: END IF;
4772: -- Debug info
4773: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4774: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.end',
4775: 'At the end of normal execution of the PLSQL procedure. Status: '||l_return_status );
4776: END IF;
4777: EXCEPTION

Line 4774: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.end',

4770: COMMIT;
4771: END IF;
4772: -- Debug info
4773: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4774: fnd_log.string(fnd_log.level_procedure, L_DEBUG_KEY || '.end',
4775: 'At the end of normal execution of the PLSQL procedure. Status: '||l_return_status );
4776: END IF;
4777: EXCEPTION
4778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5560: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

5556: l_rtn_qty := 0;
5557: END IF;
5558: l_net_qty := l_issue_qty - l_rtn_qty;
5559: -- JKJAIN BUG # 7587902
5560: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5561: -- fnd_log.string
5562: -- (
5563: -- fnd_log.level_statement,
5564: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',

Line 5561: -- fnd_log.string

5557: END IF;
5558: l_net_qty := l_issue_qty - l_rtn_qty;
5559: -- JKJAIN BUG # 7587902
5560: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5561: -- fnd_log.string
5562: -- (
5563: -- fnd_log.level_statement,
5564: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',
5565: -- 'l_net_qty -> ' || l_net_qty

Line 5563: -- fnd_log.level_statement,

5559: -- JKJAIN BUG # 7587902
5560: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5561: -- fnd_log.string
5562: -- (
5563: -- fnd_log.level_statement,
5564: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',
5565: -- 'l_net_qty -> ' || l_net_qty
5566: -- );
5567: -- END IF;

Line 5683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

5679: l_scheduled_material_id NUMBER;
5680: l_idx NUMBER;
5681: dff_default_values dff_default_values_type;
5682: BEGIN
5683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5684: fnd_log.string
5685: (
5686: fnd_log.level_procedure,
5687: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',

Line 5684: fnd_log.string

5680: l_idx NUMBER;
5681: dff_default_values dff_default_values_type;
5682: BEGIN
5683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5684: fnd_log.string
5685: (
5686: fnd_log.level_procedure,
5687: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',
5688: 'At the start of PLSQL procedure'

Line 5686: fnd_log.level_procedure,

5682: BEGIN
5683: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
5684: fnd_log.string
5685: (
5686: fnd_log.level_procedure,
5687: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',
5688: 'At the start of PLSQL procedure'
5689: );
5690: END IF;

Line 5721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

5717: --Get visit id, visit task id
5718: OPEN Visit_Task_Cur(l_prd_wooperation_tbl(i).workorder_id);
5719: FETCH Visit_Task_Cur INTO l_Visit_Task_Rec;
5720: CLOSE Visit_Task_Cur;
5721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5722: fnd_log.string
5723: (
5724: fnd_log.level_statement,
5725: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 5722: fnd_log.string

5718: OPEN Visit_Task_Cur(l_prd_wooperation_tbl(i).workorder_id);
5719: FETCH Visit_Task_Cur INTO l_Visit_Task_Rec;
5720: CLOSE Visit_Task_Cur;
5721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5722: fnd_log.string
5723: (
5724: fnd_log.level_statement,
5725: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5726: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id

Line 5724: fnd_log.level_statement,

5720: CLOSE Visit_Task_Cur;
5721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
5722: fnd_log.string
5723: (
5724: fnd_log.level_statement,
5725: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5726: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
5727: );
5728: fnd_log.string

Line 5728: fnd_log.string

5724: fnd_log.level_statement,
5725: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5726: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
5727: );
5728: fnd_log.string
5729: (
5730: fnd_log.level_statement,
5731: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5732: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id

Line 5730: fnd_log.level_statement,

5726: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
5727: );
5728: fnd_log.string
5729: (
5730: fnd_log.level_statement,
5731: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5732: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
5733: );
5734: fnd_log.string

Line 5734: fnd_log.string

5730: fnd_log.level_statement,
5731: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5732: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
5733: );
5734: fnd_log.string
5735: (
5736: fnd_log.level_statement,
5737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5738: 'Material Requirement for workorder operation seq: ' || l_prd_wooperation_tbl(i).operation_sequence_num

Line 5736: fnd_log.level_statement,

5732: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
5733: );
5734: fnd_log.string
5735: (
5736: fnd_log.level_statement,
5737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
5738: 'Material Requirement for workorder operation seq: ' || l_prd_wooperation_tbl(i).operation_sequence_num
5739: );
5740: END IF;

Line 6018: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

6014: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
6015: COMMIT;
6016: END IF;
6017: -- Debug info
6018: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6019: fnd_log.string
6020: (
6021: fnd_log.level_procedure,
6022: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',

Line 6019: fnd_log.string

6015: COMMIT;
6016: END IF;
6017: -- Debug info
6018: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6019: fnd_log.string
6020: (
6021: fnd_log.level_procedure,
6022: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',
6023: 'At the end of PLSQL procedure'

Line 6021: fnd_log.level_procedure,

6017: -- Debug info
6018: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6019: fnd_log.string
6020: (
6021: fnd_log.level_procedure,
6022: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',
6023: 'At the end of PLSQL procedure'
6024: );
6025: END IF;

Line 6174: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

6170: l_display_role_name VARCHAR2(240);
6171: l_object_notes VARCHAR2(400);
6172: l_Req_Material_Tbl Req_Material_Tbl_Type := p_Req_Material_Tbl;
6173: BEGIN
6174: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6175: fnd_log.string
6176: (
6177: fnd_log.level_procedure,
6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',

Line 6175: fnd_log.string

6171: l_object_notes VARCHAR2(400);
6172: l_Req_Material_Tbl Req_Material_Tbl_Type := p_Req_Material_Tbl;
6173: BEGIN
6174: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6175: fnd_log.string
6176: (
6177: fnd_log.level_procedure,
6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
6179: 'At the start of PLSQL procedure'

Line 6177: fnd_log.level_procedure,

6173: BEGIN
6174: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6175: fnd_log.string
6176: (
6177: fnd_log.level_procedure,
6178: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
6179: 'At the start of PLSQL procedure'
6180: );
6181: END IF;

Line 6198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

6194: l_api_name,G_PKG_NAME)
6195: THEN
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END IF;
6198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6199: fnd_log.string
6200: (
6201: fnd_log.level_statement,
6202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 6199: fnd_log.string

6195: THEN
6196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6197: END IF;
6198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6199: fnd_log.string
6200: (
6201: fnd_log.level_statement,
6202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6203: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT

Line 6201: fnd_log.level_statement,

6197: END IF;
6198: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6199: fnd_log.string
6200: (
6201: fnd_log.level_statement,
6202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6203: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT
6204: );
6205: END IF;

Line 6206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6202: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6203: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT
6204: );
6205: END IF;
6206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6207: fnd_log.string
6208: (
6209: fnd_log.level_procedure,
6210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 6207: fnd_log.string

6203: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT
6204: );
6205: END IF;
6206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6207: fnd_log.string
6208: (
6209: fnd_log.level_procedure,
6210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6211: 'Before calling Ahl_Utility_Pvt.Get_Wf_Process_Name'

Line 6209: fnd_log.level_procedure,

6205: END IF;
6206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6207: fnd_log.string
6208: (
6209: fnd_log.level_procedure,
6210: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6211: 'Before calling Ahl_Utility_Pvt.Get_Wf_Process_Name'
6212: );
6213: END IF;

Line 6224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6220: x_item_type =>l_item_type,
6221: x_return_status=>l_return_status,
6222: x_msg_count =>l_msg_count,
6223: x_msg_data =>l_msg_data);
6224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6225: fnd_log.string
6226: (
6227: fnd_log.level_procedure,
6228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 6225: fnd_log.string

6221: x_return_status=>l_return_status,
6222: x_msg_count =>l_msg_count,
6223: x_msg_data =>l_msg_data);
6224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6225: fnd_log.string
6226: (
6227: fnd_log.level_procedure,
6228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
6229: 'After calling Ahl_Utility_Pvt.Get_Wf_Process_Name, Return Status : '|| l_return_status

Line 6227: fnd_log.level_procedure,

6223: x_msg_data =>l_msg_data);
6224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6225: fnd_log.string
6226: (
6227: fnd_log.level_procedure,
6228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
6229: 'After calling Ahl_Utility_Pvt.Get_Wf_Process_Name, Return Status : '|| l_return_status
6230: );
6231: END IF;

Line 6236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

6232: -- Check Error Message stack.
6233: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
6234: RAISE FND_API.G_EXC_ERROR;
6235: END IF;
6236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6237: fnd_log.string
6238: (
6239: fnd_log.level_statement,
6240: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 6237: fnd_log.string

6233: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
6234: RAISE FND_API.G_EXC_ERROR;
6235: END IF;
6236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6237: fnd_log.string
6238: (
6239: fnd_log.level_statement,
6240: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6241: 'Active flag : '||l_active

Line 6239: fnd_log.level_statement,

6235: END IF;
6236: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6237: fnd_log.string
6238: (
6239: fnd_log.level_statement,
6240: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6241: 'Active flag : '||l_active
6242: );
6243: END IF;

Line 6286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

6282: l_body := l_body ||':' ||l_Req_Material_Tbl(i).notify_text;
6283: END IF;
6284: END IF;
6285: END LOOP;
6286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6287: fnd_log.string
6288: (
6289: fnd_log.level_statement,
6290: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 6287: fnd_log.string

6283: END IF;
6284: END IF;
6285: END LOOP;
6286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6287: fnd_log.string
6288: (
6289: fnd_log.level_statement,
6290: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6291: 'Number of records : '||l_Req_Material_Tbl.count

Line 6289: fnd_log.level_statement,

6285: END LOOP;
6286: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
6287: fnd_log.string
6288: (
6289: fnd_log.level_statement,
6290: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
6291: 'Number of records : '||l_Req_Material_Tbl.count
6292: );
6293: END IF;

Line 6317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

6313: 'GEN_MSG_SEND_TO',
6314: l_role_name);
6315: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
6316: END IF;
6317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6318: fnd_log.string
6319: (
6320: fnd_log.level_procedure,
6321: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',

Line 6318: fnd_log.string

6314: l_role_name);
6315: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
6316: END IF;
6317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6318: fnd_log.string
6319: (
6320: fnd_log.level_procedure,
6321: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',
6322: 'At the end of PLSQL procedure'

Line 6320: fnd_log.level_procedure,

6316: END IF;
6317: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
6318: fnd_log.string
6319: (
6320: fnd_log.level_procedure,
6321: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',
6322: 'At the end of PLSQL procedure'
6323: );
6324: END IF;