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_PROCESS_WO_PUB dependencies on EAM_PROCESS_WO_PVT

Line 242: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

238: end if;
239:
240:
241: -- Set the global variable for debug.
242: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
243:
244: IF l_debug_flag = 'Y'
245: THEN
246:

Line 406: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

402: l_debug_flag := 'N';
403:
404: END IF;
405:
406: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
407:
408: IF l_debug_flag = 'Y'
409: THEN
410: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 423: EAM_PROCESS_WO_PVT.Set_Debug('N');

419: l_mesg_token_tbl := l_out_mesg_token_tbl;
420:
421: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
422: THEN
423: EAM_PROCESS_WO_PVT.Set_Debug('N');
424: END IF;
425: END IF;
426:
427: END IF;

Line 589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CHECK_BO_NETWORK ...') ; END IF ;

585: x_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
586: x_eam_op_comp_tbl := p_eam_op_comp_tbl;
587:
588:
589: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling CHECK_BO_NETWORK ...') ; END IF ;
590:
591:
592: CHECK_BO_NETWORK
593: ( p_eam_wo_tbl => l_eam_wo_tbl

Line 674: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;

670: l_out_eam_op_comp_tbl.delete;
671: l_out_eam_request_tbl.delete;
672:
673:
674: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;
675:
676: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
677:
678: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 749: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

745: l_eam_wo_comp_mr_read_tbl := l_out_eam_wo_comp_mr_read_tbl;
746: l_eam_op_comp_tbl := l_out_eam_op_comp_tbl;
747: l_eam_request_tbl := l_out_eam_request_tbl;
748:
749: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
750: THEN
751: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
752: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
753: END IF;

Line 763: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

759: return;
760: end if;
761:
762:
763: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
764: THEN
765: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
766: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
767: END IF;

Line 1033: -- IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Size of the list of newly created work orders:'||l_eam_wo_list.count) ; END IF ;

1029: and l_return_status = 'S' then
1030: l_eam_wo_list(l_eam_wo_list.count + 1) := l_out_eam_wo_rec.wip_entity_name;
1031: end if;
1032:
1033: -- IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Size of the list of newly created work orders:'||l_eam_wo_list.count) ; END IF ;
1034:
1035: if l_out_eam_wo_rec.transaction_type is not null then
1036: l_eam_wo_tbl(l_out_eam_wo_rec.row_id) := l_out_eam_wo_rec;
1037: end if;

Line 1249: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

1245:
1246:
1247:
1248: -- Set the global variable for debug.
1249: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
1250:
1251: IF l_debug_flag = 'Y'
1252: THEN
1253:

Line 1403: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

1399: l_debug_flag := 'N';
1400:
1401: END IF;
1402:
1403: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
1404:
1405: IF l_debug_flag = 'Y'
1406: THEN
1407: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 1420: EAM_PROCESS_WO_PVT.Set_Debug('N');

1416: l_mesg_token_tbl := l_out_mesg_token_tbl;
1417:
1418: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1419: THEN
1420: EAM_PROCESS_WO_PVT.Set_Debug('N');
1421: END IF;
1422: END IF;
1423:
1424: END IF;

Line 1449: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Check_Wo_Dates procedure ... ') ; END IF ;

1445:
1446:
1447: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).PARENT_OBJECT_ID;
1448:
1449: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Check_Wo_Dates procedure ... ') ; END IF ;
1450:
1451: FOR l_temp_index in 1..2 LOOP
1452:
1453: if (l_eam_wo_relations_tbl(i).parent_relationship_type = 1) then

Line 1468: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for parent wo completed with status of '||l_return_status) ; END IF ;

1464: x_msg_count => l_msg_count,
1465: x_msg_data => l_msg_data
1466: );
1467:
1468: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for parent wo completed with status of '||l_return_status) ; END IF ;
1469: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for child wo completed with status of '||l_return_status) ; END IF ;
1470: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1471: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472:

Line 1469: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for child wo completed with status of '||l_return_status) ; END IF ;

1465: x_msg_data => l_msg_data
1466: );
1467:
1468: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for parent wo completed with status of '||l_return_status) ; END IF ;
1469: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Check_Wo_Dates for child wo completed with status of '||l_return_status) ; END IF ;
1470: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1471: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472:
1473: --Before inserting the error message, insert the confirmation message of work order creation.

Line 1507: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_WO_To_Network procedure ... ') ; END IF ;

1503: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1504:
1505: SAVEPOINT Add_WO_To_Network_Start;
1506:
1507: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_WO_To_Network procedure ... ') ; END IF ;
1508:
1509: EAM_WO_NETWORK_DEFAULT_PVT.Add_WO_To_Network(
1510: p_api_version => 1.0,
1511: p_init_msg_list => FND_API.G_FALSE,

Line 1610: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_Dependency procedure ... ') ; END IF ;

1606:
1607: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1608:
1609: SAVEPOINT Add_Dependency_Start;
1610: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Add_Dependency procedure ... ') ; END IF ;
1611:
1612: EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency
1613: (
1614: p_api_version => 1.0,

Line 1717: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delink_Child_From_parent procedure ... ') ; END IF ;

1713: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1714:
1715: SAVEPOINT Delink_Relation_Start;
1716:
1717: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delink_Child_From_parent procedure ... ') ; END IF ;
1718:
1719: EAM_WO_NETWORK_DEFAULT_PVT.Delink_Child_From_Parent
1720: (
1721: p_api_version => 1.0,

Line 1822: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delete_Dependency procedure ... ') ; END IF ;

1818:
1819: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1820:
1821: SAVEPOINT Delete_Dependency_Start;
1822: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Delete_Dependency procedure ... ') ; END IF ;
1823:
1824: EAM_WO_NETWORK_DEFAULT_PVT.Delete_Dependency
1825: (
1826: p_api_version => 1.0,

Line 1939: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Validate_Structure procedure ... ') ; END IF ;

1935: -- Call Validate Structure. If it returns error, then rollback everything
1936:
1937: IF l_eam_wo_tbl.count <> 0 and l_eam_wo_tbl(l_eam_wo_tbl.first).validate_structure = 'Y' then -- added for bug# 3544860
1938:
1939: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Entering the Validate_Structure procedure ... ') ; END IF ;
1940:
1941: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1942: (
1943: p_api_version => 1.0,

Line 2097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2093: end if;
2094:
2095: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2096:
2097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2098: THEN
2099: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2100: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2101: END IF;

Line 2189: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2185: l_eam_wo_comp_mr_read_tbl := l_out_eam_wo_comp_mr_read_tbl;
2186: l_eam_op_comp_tbl := l_out_eam_op_comp_tbl;
2187: l_eam_request_tbl := l_out_eam_request_tbl;
2188:
2189: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2190: THEN
2191: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2192: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2193: END IF;

Line 3192: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

3188: EAM_ERROR_MESSAGE_PVT.Initialize;
3189: END IF;
3190:
3191: -- Set the global variable for debug.
3192: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3193:
3194: IF l_debug_flag = 'Y'
3195: THEN
3196:

Line 3356: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

3352: l_debug_flag := 'N';
3353:
3354: END IF;
3355:
3356: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3357:
3358: IF l_debug_flag = 'Y'
3359: THEN
3360: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 3373: EAM_PROCESS_WO_PVT.Set_Debug('N');

3369: l_mesg_token_tbl := l_out_mesg_token_tbl;
3370:
3371: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3372: THEN
3373: EAM_PROCESS_WO_PVT.Set_Debug('N');
3374: END IF;
3375: END IF;
3376:
3377: END IF;

Line 3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;

3375: END IF;
3376:
3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;

Line 3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;

3376:
3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;

Line 3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;

3377: END IF;
3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;

Line 3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;

3378:
3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;

Line 3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;

3379: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('The BO as passed '); end if;
3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;

Line 3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;

3380: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('WO Rec: ' || p_eam_wo_rec.wip_entity_id); end if;
3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:

Line 3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;

3381: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.write_debug('Num of operations: ' || p_eam_op_tbl.COUNT); end if;
3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;

Line 3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;

3382: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resources: ' || p_eam_res_tbl.COUNT); END IF;
3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;

Line 3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;

3383: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of materials: ' || p_eam_mat_req_tbl.COUNT); END IF;
3384: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of direct items: ' || p_eam_direct_items_tbl.COUNT); END IF;
3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;

Line 3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;

3385: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of sub resources: ' || p_eam_sub_res_tbl.COUNT); END IF;
3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;

Line 3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;

3386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of resource inst: ' || p_eam_res_inst_tbl.COUNT); END IF;
3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;

Line 3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;

3387: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op networks: ' || p_eam_op_network_tbl.COUNT); END IF;
3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;

Line 3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;

3388:
3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;

Line 3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;

3389: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('WO Completion Rec WID: ' || l_eam_wo_comp_rec.wip_entity_id); END IF;
3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:

Line 3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;

3390: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of qua records: ' || p_eam_wo_quality_tbl.COUNT); END IF;
3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:

Line 3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;

3391: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of meter rdg recs: ' || p_eam_meter_reading_tbl.COUNT); END IF;
3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:
3399: --

Line 3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;

3392: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of counter prop recs: ' || p_eam_counter_prop_tbl.COUNT); END IF;
3393: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion rebld recs: ' || p_eam_wo_comp_rebuild_tbl.COUNT); END IF;
3394: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of completion meter rdg recs: ' || p_eam_wo_comp_mr_read_tbl.COUNT); END IF;
3395: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of op completion recs: ' || p_eam_op_comp_tbl.COUNT); END IF;
3396: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Num of work request recs: ' || p_eam_request_tbl.COUNT); END IF;
3397:
3398:
3399: --
3400: -- Verify if all the entity record(s) belong to the same business object

Line 3402: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering Check_BO_Record procedure, BO record validation'); END IF;

3398:
3399: --
3400: -- Verify if all the entity record(s) belong to the same business object
3401: --
3402: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering Check_BO_Record procedure, BO record validation'); END IF;
3403:
3404: CHECK_BO_RECORD
3405: ( p_eam_wo_rec => l_eam_wo_rec
3406: , p_eam_op_tbl => l_eam_op_tbl

Line 3430: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('BO record validation Passed'); END IF;

3426:
3427: IF l_return_status <> 'S' THEN
3428: RAISE G_EXC_SEV_QUIT_OBJECT;
3429: END IF;
3430: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('BO record validation Passed'); END IF;
3431:
3432: --
3433: -- Call the Private API for performing further business rules validation
3434: --

Line 3442: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering the PROCESS_WO private procedure'); END IF;

3438: OR (p_eam_res_tbl.COUNT >0) OR (p_eam_res_inst_tbl.COUNT >0) OR (p_eam_sub_res_tbl.COUNT >0)
3439: OR (p_eam_mat_req_tbl.COUNT >0) OR (p_eam_direct_items_tbl.COUNT >0) OR (p_eam_res_usage_tbl.COUNT>0)
3440: THEN
3441:
3442: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering the PROCESS_WO private procedure'); END IF;
3443:
3444: EAM_PROCESS_WO_PVT.PROCESS_WO
3445: ( p_api_version_number => p_api_version_number
3446: , x_return_status => x_return_status

Line 3444: EAM_PROCESS_WO_PVT.PROCESS_WO

3440: THEN
3441:
3442: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Entering the PROCESS_WO private procedure'); END IF;
3443:
3444: EAM_PROCESS_WO_PVT.PROCESS_WO
3445: ( p_api_version_number => p_api_version_number
3446: , x_return_status => x_return_status
3447: , x_msg_count => x_msg_count
3448: , p_eam_wo_rec => p_eam_wo_rec

Line 3554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3550:
3551: x_return_status := l_return_status;
3552: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3553:
3554: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3555: THEN
3556: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3557: IF p_eam_request_tbl.COUNT = 0 THEN
3558: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;

Line 3582: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER

3578:
3579: IF (p_eam_wo_comp_rec.transaction_type is not null) THEN
3580:
3581:
3582: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER
3583: (
3584: p_eam_wo_comp_rec => p_eam_wo_comp_rec
3585: , p_eam_wo_quality_tbl => p_eam_wo_quality_tbl
3586: , p_eam_meter_reading_tbl => p_eam_meter_reading_tbl

Line 3603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3599:
3600: x_return_status := l_return_status;
3601: x_msg_count := l_msg_count;
3602:
3603: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3604: THEN
3605: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3606: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3607: END IF;

Line 3614: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION

3610: END IF;
3611:
3612: IF p_eam_op_comp_tbl.COUNT > 0 THEN
3613:
3614: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION
3615: (
3616: p_eam_op_compl_tbl => p_eam_op_comp_tbl
3617: , p_eam_wo_quality_tbl => p_eam_wo_quality_tbl
3618: , x_eam_op_comp_tbl => x_eam_op_comp_tbl

Line 3627: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3623:
3624: x_return_status := l_return_status;
3625: x_msg_count := l_msg_count;
3626:
3627: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3628: THEN
3629: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3630: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3631: END IF;

Line 3639: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO

3635:
3636:
3637: IF p_eam_request_tbl.COUNT > 0 THEN
3638:
3639: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO
3640: (
3641: p_eam_request_tbl => l_eam_request_tbl
3642: , x_eam_request_tbl => x_eam_request_tbl
3643: , x_return_status => l_return_status

Line 3650: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3646:
3647: x_return_status := l_return_status;
3648: x_msg_count := l_msg_count;
3649:
3650: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3651: THEN
3652: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3653: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3654: END IF;

Line 3691: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3687: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3688: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3689: x_eam_request_tbl := l_eam_request_tbl;
3690:
3691: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3692: THEN
3693: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3694: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3695: END IF;

Line 3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3785:
3786: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3787: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3788:
3789: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3790: THEN
3791: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3792: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3793: END IF;

Line 3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3892:
3893: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3894: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3895:
3896: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3897: THEN
3898: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3899: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3900: END IF;

Line 3960: EAM_PROCESS_WO_PVT.PROCESS_WO

3956: l_eam_wo_rec.RETURN_STATUS := null;
3957: l_eam_wo_rec.TRANSACTION_TYPE := 2;
3958:
3959:
3960: EAM_PROCESS_WO_PVT.PROCESS_WO
3961: ( p_api_version_number => p_api_version
3962: , x_return_status => x_return_status
3963: , x_msg_count => x_msg_count
3964: , p_eam_wo_rec => l_eam_wo_rec

Line 4313: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OP record'); END IF;

4309: l_organization_id := p_eam_wo_rec.organization_id;
4310: END IF;
4311: -- end - baroy
4312:
4313: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OP record'); END IF;
4314:
4315: FOR I IN 1..p_eam_op_tbl.COUNT LOOP
4316: IF p_eam_op_tbl(I).wip_entity_id is not null AND (
4317: p_eam_op_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4325: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OPN record'); END IF;

4321: l_other_message := 'EAM_WO_BO_REC_INVALID';
4322: END IF;
4323: END LOOP;
4324:
4325: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating OPN record'); END IF;
4326:
4327: FOR I IN 1..p_eam_op_network_tbl.COUNT LOOP
4328: IF p_eam_op_network_tbl(I).wip_entity_id is not null AND (
4329: p_eam_op_network_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4337: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES record'); END IF;

4333: l_other_message := 'EAM_WO_BO_REC_INVALID';
4334: END IF;
4335: END LOOP;
4336:
4337: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES record'); END IF;
4338:
4339: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
4340:
4341: IF p_eam_res_tbl(I).wip_entity_id is not null AND (

Line 4350: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_INST record'); END IF;

4346: l_other_message := 'EAM_WO_BO_REC_INVALID';
4347: END IF;
4348: END LOOP;
4349:
4350: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_INST record'); END IF;
4351:
4352: FOR I IN 1..p_eam_res_inst_tbl.COUNT LOOP
4353: IF p_eam_res_inst_tbl(I).wip_entity_id is not null AND (
4354: p_eam_res_inst_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4362: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating SUB_RES record'); END IF;

4358: l_other_message := 'EAM_WO_BO_REC_INVALID';
4359: END IF;
4360: END LOOP;
4361:
4362: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating SUB_RES record'); END IF;
4363:
4364: FOR I IN 1..p_eam_sub_res_tbl.COUNT LOOP
4365: IF p_eam_sub_res_tbl(I).wip_entity_id is not null AND (
4366: p_eam_sub_res_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4374: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_USAGE record'); END IF;

4370: l_other_message := 'EAM_WO_BO_REC_INVALID';
4371: END IF;
4372: END LOOP;
4373:
4374: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating RES_USAGE record'); END IF;
4375:
4376: FOR I IN 1..p_eam_res_usage_tbl.COUNT LOOP
4377: IF p_eam_res_usage_tbl(I).wip_entity_id is not null AND (
4378: p_eam_res_usage_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating MAT_REQ record'); END IF;

4382: l_other_message := 'EAM_WO_BO_REC_INVALID';
4383: END IF;
4384: END LOOP;
4385:
4386: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating MAT_REQ record'); END IF;
4387:
4388: FOR I IN 1..p_eam_mat_req_tbl.COUNT LOOP
4389: IF p_eam_mat_req_tbl(I).wip_entity_id is not null AND (
4390: p_eam_mat_req_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4398: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating DI record'); END IF;

4394: l_other_message := 'EAM_WO_BO_REC_INVALID';
4395: END IF;
4396: END LOOP;
4397:
4398: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating DI record'); END IF;
4399:
4400: FOR I IN 1..p_eam_direct_items_tbl.COUNT LOOP
4401: IF p_eam_direct_items_tbl(I).wip_entity_id is not null AND (
4402: p_eam_direct_items_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Quality record'); END IF;

4477: l_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;
4478: l_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
4479:
4480:
4481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Quality record'); END IF;
4482:
4483: FOR I IN 1..l_eam_wo_quality_tbl.COUNT LOOP
4484: IF p_eam_wo_quality_tbl(I).wip_entity_id is not null AND (
4485: p_eam_wo_quality_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter record'); END IF;

4489: l_other_message := 'EAM_WO_BO_REC_INVALID';
4490: END IF;
4491: END LOOP;
4492:
4493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter record'); END IF;
4494:
4495: FOR I IN 1..l_eam_meter_reading_tbl.COUNT LOOP
4496: IF p_eam_meter_reading_tbl(I).wip_entity_id is not null AND (
4497: p_eam_meter_reading_tbl(I).wip_entity_id <> l_wip_entity_id

Line 4505: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Counter Properties record'); END IF;

4501: l_other_message := 'EAM_WO_BO_REC_INVALID';
4502: END IF;
4503: END LOOP;
4504:
4505: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Counter Properties record'); END IF;
4506:
4507: FOR I IN 1..l_eam_counter_prop_tbl.COUNT LOOP
4508: IF p_eam_counter_prop_tbl(I).wip_entity_id is not null AND (
4509: p_eam_counter_prop_tbl(I).wip_entity_id <> l_wip_entity_id

Line 4518: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter Completion record'); END IF;

4514: END IF;
4515: END LOOP;
4516:
4517:
4518: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Meter Completion record'); END IF;
4519:
4520: FOR I IN 1..l_eam_wo_comp_rebuild_tbl.COUNT LOOP
4521: IF p_eam_wo_comp_rebuild_tbl(I).wip_entity_id is not null AND (
4522: p_eam_wo_comp_rebuild_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4530: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Rebuild Completion record'); END IF;

4526: l_other_message := 'EAM_WO_BO_REC_INVALID';
4527: END IF;
4528: END LOOP;
4529:
4530: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug('Validating Rebuild Completion record'); END IF;
4531:
4532: FOR I IN 1..l_eam_wo_comp_mr_read_tbl.COUNT LOOP
4533: IF p_eam_wo_comp_mr_read_tbl(I).wip_entity_id is not null AND (
4534: p_eam_wo_comp_mr_read_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 4925: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

4921:
4922:
4923: l_old_activity_id := l_eam_wo_rec.asset_activity_id;
4924: l_eam_wo_rec.asset_activity_id := null;
4925: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4926: l_eam_wo_rec.return_status := null;
4927:
4928: l_eam_wo_rec.date_released := null;
4929: l_eam_wo_rec.cycle_id := null;

Line 4942: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

4938:
4939: l_eam_op_rec.header_id := 1;
4940: l_eam_op_rec.batch_id := 1;
4941: l_eam_op_rec.wip_entity_id := null;
4942: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4943: l_eam_op_rec.return_status := null;
4944:
4945: l_eam_op_rec.organization_id := opRec.organization_id;
4946: l_eam_op_rec.operation_seq_num := opRec.operation_seq_num;

Line 4983: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

4979: FOR opRes IN l_op_resources LOOP
4980: l_eam_res_rec.header_id := 1;
4981: l_eam_res_rec.batch_id := 1;
4982: l_eam_res_rec.wip_entity_id := null;
4983: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4984: l_eam_res_rec.return_status := null;
4985:
4986: l_eam_res_rec.organization_id := opRes.organization_id ;
4987: l_eam_res_rec.operation_seq_num := opRes.operation_seq_num ;

Line 5034: l_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

5030:
5031: l_eam_res_inst_rec.header_id := 1;
5032: l_eam_res_inst_rec.batch_id := 1;
5033: l_eam_res_inst_rec.wip_entity_id := null;
5034: l_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5035: l_eam_res_inst_rec.return_status := null;
5036:
5037: l_eam_res_inst_rec.organization_id := opResInst.organization_id ;
5038: l_eam_res_inst_rec.operation_seq_num := opResInst.operation_seq_num ;

Line 5057: l_eam_op_network_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

5053:
5054: l_eam_op_network_rec.header_id := 1;
5055: l_eam_op_network_rec.batch_id := 1;
5056: l_eam_op_network_rec.wip_entity_id := null;
5057: l_eam_op_network_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5058: l_eam_op_network_rec.return_status := null;
5059:
5060: l_eam_op_network_rec.organization_id := opNetwork.organization_id ;
5061: l_eam_op_network_rec.prior_operation := opNetwork.prior_operation ;

Line 5091: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

5087:
5088: l_eam_mat_req_rec.header_id := 1;
5089: l_eam_mat_req_rec.batch_id := 1;
5090: l_eam_mat_req_rec.wip_entity_id := null;
5091: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5092: l_eam_mat_req_rec.return_status := null;
5093:
5094: l_eam_mat_req_rec.organization_id := opMaterial.organization_id ;
5095: l_eam_mat_req_rec.operation_seq_num := opMaterial.operation_seq_num ;

Line 5138: l_eam_di_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;

5134:
5135: l_eam_di_rec.header_id := 1;
5136: l_eam_di_rec.batch_id := 1;
5137: l_eam_di_rec.wip_entity_id := null;
5138: l_eam_di_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5139: l_eam_di_rec.return_status := null;
5140:
5141: l_eam_di_rec.description := opDirectItem.description ;
5142: l_eam_di_rec.purchasing_category_id := opDirectItem.purchasing_category_id ;