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

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
590: EAM_ERROR_MESSAGE_PVT.Write_Debug('') ;
591: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Start============================================================================') ;
592: END IF ;
593:

Line 594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling CHECK_BO_NETWORK ...') ; END IF ;

590: EAM_ERROR_MESSAGE_PVT.Write_Debug('') ;
591: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Start============================================================================') ;
592: END IF ;
593:
594: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling CHECK_BO_NETWORK ...') ; END IF ;
595:
596:
597: CHECK_BO_NETWORK
598: ( p_eam_wo_tbl => l_eam_wo_tbl

Line 679: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;

675: l_out_eam_op_comp_tbl.delete;
676: l_out_eam_request_tbl.delete;
677:
678:
679: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : CHECK_BO_NETWORK completed with status ='||l_return_status) ; END IF ;
680:
681: if nvl(l_return_status,FND_API.G_RET_STS_ERROR) <> FND_API.G_RET_STS_SUCCESS then
682:
683: l_out_mesg_token_tbl := l_mesg_token_tbl;

Line 754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

750: l_eam_wo_comp_mr_read_tbl := l_out_eam_wo_comp_mr_read_tbl;
751: l_eam_op_comp_tbl := l_out_eam_op_comp_tbl;
752: l_eam_request_tbl := l_out_eam_request_tbl;
753:
754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
755: THEN
756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
758: END IF;

Line 768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

764: return;
765: end if;
766:
767:
768: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
769: THEN
770: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
771: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
772: END IF;

Line 1038: -- 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: and l_return_status = 'S' then
1035: l_eam_wo_list(l_eam_wo_list.count + 1) := l_out_eam_wo_rec.wip_entity_name;
1036: end if;
1037:
1038: -- 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 ;
1039:
1040: if l_out_eam_wo_rec.transaction_type is not null then
1041: l_eam_wo_tbl(l_out_eam_wo_rec.row_id) := l_out_eam_wo_rec;
1042: end if;

Line 1254: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

1250:
1251:
1252:
1253: -- Set the global variable for debug.
1254: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
1255:
1256: IF l_debug_flag = 'Y'
1257: THEN
1258:

Line 1408: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

1404: l_debug_flag := 'N';
1405:
1406: END IF;
1407:
1408: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
1409:
1410: IF l_debug_flag = 'Y'
1411: THEN
1412: l_out_mesg_token_tbl := l_mesg_token_tbl;

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

1421: l_mesg_token_tbl := l_out_mesg_token_tbl;
1422:
1423: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1424: THEN
1425: EAM_PROCESS_WO_PVT.Set_Debug('N');
1426: END IF;
1427: END IF;
1428:
1429: END IF;

Line 1454: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates ') ; END IF ;

1450:
1451:
1452: l_temp_wip_entity_id := l_eam_wo_relations_tbl(i).PARENT_OBJECT_ID;
1453:
1454: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates ') ; END IF ;
1455:
1456: FOR l_temp_index in 1..2 LOOP
1457:
1458: if (l_eam_wo_relations_tbl(i).parent_relationship_type = 1) then

Line 1473: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN

1469: x_msg_count => l_msg_count,
1470: x_msg_data => l_msg_data
1471: );
1472:
1473: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN
1474: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for parent wo completed with status of '||l_return_status) ;
1475: END IF ;
1476: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN
1477: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for child wo completed with status of '||l_return_status) ;

Line 1476: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN

1472:
1473: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 1 ) THEN
1474: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for parent wo completed with status of '||l_return_status) ;
1475: END IF ;
1476: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y' AND l_temp_index = 2 ) THEN
1477: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Check_Wo_Dates for child wo completed with status of '||l_return_status) ;
1478: END IF ;
1479:
1480: IF l_return_status = FND_API.G_RET_STS_ERROR OR

Line 1517: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the AEAM_WO_NETWORK_DEFAULT_PVT.add_WO_To_Network ') ; END IF ;

1513: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1514:
1515: SAVEPOINT Add_WO_To_Network_Start;
1516:
1517: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the AEAM_WO_NETWORK_DEFAULT_PVT.add_WO_To_Network ') ; END IF ;
1518:
1519: EAM_WO_NETWORK_DEFAULT_PVT.Add_WO_To_Network(
1520: p_api_version => 1.0,
1521: p_init_msg_list => FND_API.G_FALSE,

Line 1621: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency') ; END IF ;

1617: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1618:
1619: SAVEPOINT Add_Dependency_Start;
1620:
1621: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency') ; END IF ;
1622:
1623: EAM_WO_NETWORK_DEFAULT_PVT.Add_Dependency
1624: (
1625: p_api_version => 1.0,

Line 1728: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delink_Child_From_parent procedure ... ') ; END IF ;

1724: if l_eam_wo_relations_tbl(i).parent_relationship_type in (1,3,4) then
1725:
1726: SAVEPOINT Delink_Relation_Start;
1727:
1728: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delink_Child_From_parent procedure ... ') ; END IF ;
1729:
1730: EAM_WO_NETWORK_DEFAULT_PVT.Delink_Child_From_Parent
1731: (
1732: p_api_version => 1.0,

Line 1833: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delete_Dependency procedure ... ') ; END IF ;

1829:
1830: elsif l_eam_wo_relations_tbl(i).parent_relationship_type = 2 then
1831:
1832: SAVEPOINT Delete_Dependency_Start;
1833: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Delete_Dependency procedure ... ') ; END IF ;
1834:
1835: EAM_WO_NETWORK_DEFAULT_PVT.Delete_Dependency
1836: (
1837: p_api_version => 1.0,

Line 1950: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Validate_Structure procedure ... ') ; END IF ;

1946: -- Call Validate Structure. If it returns error, then rollback everything
1947:
1948: 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
1949:
1950: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : Calling the Validate_Structure procedure ... ') ; END IF ;
1951:
1952: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
1953: (
1954: p_api_version => 1.0,

Line 2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2104: end if;
2105:
2106: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
2107:
2108: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2109: THEN
2110: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2111: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2112: END IF;

Line 2119: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : End ==================================================== ') ; END IF ;

2115: IF p_commit = 'Y' THEN
2116: COMMIT WORK;
2117: END IF;
2118:
2119: IF ( EAM_PROCESS_WO_PVT.Get_Debug = 'Y') THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_MASTER_CHILD_WO : End ==================================================== ') ; END IF ;
2120:
2121: EXCEPTION
2122:
2123: WHEN OTHERS THEN

Line 2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

2198: l_eam_wo_comp_mr_read_tbl := l_out_eam_wo_comp_mr_read_tbl;
2199: l_eam_op_comp_tbl := l_out_eam_op_comp_tbl;
2200: l_eam_request_tbl := l_out_eam_request_tbl;
2201:
2202: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
2203: THEN
2204: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
2205: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
2206: END IF;

Line 3234: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

3230: EAM_ERROR_MESSAGE_PVT.Initialize;
3231: END IF;
3232:
3233: -- Set the global variable for debug.
3234: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3235:
3236: IF l_debug_flag = 'Y'
3237: THEN
3238:

Line 3398: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);

3394: l_debug_flag := 'N';
3395:
3396: END IF;
3397:
3398: EAM_PROCESS_WO_PVT.Set_Debug(l_debug_flag);
3399:
3400: IF l_debug_flag = 'Y'
3401: THEN
3402: l_out_mesg_token_tbl := l_mesg_token_tbl;

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

3411: l_mesg_token_tbl := l_out_mesg_token_tbl;
3412:
3413: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3414: THEN
3415: EAM_PROCESS_WO_PVT.Set_Debug('N');
3416: END IF;
3417: END IF;
3418:
3419: END IF;

Line 3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN

3417: END IF;
3418:
3419: END IF;
3420:
3421: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' THEN
3422: EAM_ERROR_MESSAGE_PVT.write_debug('==================================================Work Order==============================================================');
3423: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Start ========= fnd_global.user_id: '||FND_GLOBAL.user_id||' fnd_global.resp_id: '||fnd_global.resp_id||' login_id: '||FND_GLOBAL.login_id);
3424: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Workorder: ' || p_eam_wo_rec.wip_entity_name||' Wip Entity Id : '||p_eam_wo_rec.wip_entity_id);
3425: EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Transaction Type : '||l_eam_wo_rec.TRANSACTION_TYPE||' (1:Create / 2:Update / 3:Delete / 4:Complete / 5:UnComplete)');

Line 3453: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling Check_BO_Record procedure, BO record validation'); END IF;

3449:
3450: --
3451: -- Verify if all the entity record(s) belong to the same business object
3452: --
3453: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling Check_BO_Record procedure, BO record validation'); END IF;
3454:
3455: CHECK_BO_RECORD
3456: ( p_eam_wo_rec => l_eam_wo_rec
3457: , p_eam_op_tbl => l_eam_op_tbl

Line 3481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : BO record validation Successful'); END IF;

3477:
3478: IF l_return_status <> 'S' THEN
3479: RAISE G_EXC_SEV_QUIT_OBJECT;
3480: END IF;
3481: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : BO record validation Successful'); END IF;
3482:
3483: --
3484: -- Call the Private API for performing further business rules validation
3485: --

Line 3493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling the EAM_PROCESS_WO_PVT.PROCESS_WO procedure'); END IF;

3489: OR (p_eam_res_tbl.COUNT >0) OR (p_eam_res_inst_tbl.COUNT >0) OR (p_eam_sub_res_tbl.COUNT >0)
3490: OR (p_eam_mat_req_tbl.COUNT >0) OR (p_eam_direct_items_tbl.COUNT >0) OR (p_eam_res_usage_tbl.COUNT>0)
3491: THEN
3492:
3493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling the EAM_PROCESS_WO_PVT.PROCESS_WO procedure'); END IF;
3494:
3495: EAM_PROCESS_WO_PVT.PROCESS_WO
3496: ( p_api_version_number => p_api_version_number
3497: , x_return_status => x_return_status

Line 3495: EAM_PROCESS_WO_PVT.PROCESS_WO

3491: THEN
3492:
3493: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS__WO : Calling the EAM_PROCESS_WO_PVT.PROCESS_WO procedure'); END IF;
3494:
3495: EAM_PROCESS_WO_PVT.PROCESS_WO
3496: ( p_api_version_number => p_api_version_number
3497: , x_return_status => x_return_status
3498: , x_msg_count => x_msg_count
3499: , p_eam_wo_rec => l_eam_wo_rec

Line 3604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

3600:
3601:
3602: x_return_status := l_return_status;
3603:
3604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
3605: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : End ======= Return Status from EAM_PROCESS_WO_PVT.PROCESS_WO : ' ||l_return_status||' Wip Entity Id: '||x_eam_wo_rec.wip_entity_id) ;
3606: END IF ;
3607:
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;

Line 3605: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : End ======= Return Status from EAM_PROCESS_WO_PVT.PROCESS_WO : ' ||l_return_status||' Wip Entity Id: '||x_eam_wo_rec.wip_entity_id) ;

3601:
3602: x_return_status := l_return_status;
3603:
3604: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
3605: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : End ======= Return Status from EAM_PROCESS_WO_PVT.PROCESS_WO : ' ||l_return_status||' Wip Entity Id: '||x_eam_wo_rec.wip_entity_id) ;
3606: END IF ;
3607:
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3609:

Line 3610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3606: END IF ;
3607:
3608: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3609:
3610: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3611: THEN
3612: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3613: IF p_eam_request_tbl.COUNT = 0 THEN
3614: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;

Line 3636: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER') ; END IF ;

3632:
3633: END IF;
3634:
3635: IF (p_eam_wo_comp_rec.transaction_type is not null) THEN
3636: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER') ; END IF ;
3637:
3638:
3639: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER
3640: (

Line 3639: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER

3635: IF (p_eam_wo_comp_rec.transaction_type is not null) THEN
3636: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER') ; END IF ;
3637:
3638:
3639: EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER
3640: (
3641: p_eam_wo_comp_rec => p_eam_wo_comp_rec
3642: , p_eam_wo_quality_tbl => p_eam_wo_quality_tbl
3643: , p_eam_meter_reading_tbl => p_eam_meter_reading_tbl

Line 3659: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER: '||l_return_status); END IF ;

3655: );
3656:
3657: x_return_status := l_return_status;
3658: x_msg_count := l_msg_count;
3659: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER: '||l_return_status); END IF ;
3660:
3661:
3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3663: THEN

Line 3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3658: x_msg_count := l_msg_count;
3659: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_WORKORDER: '||l_return_status); END IF ;
3660:
3661:
3662: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3663: THEN
3664: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3665: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3666: END IF;

Line 3672: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION') ; END IF ;

3668:
3669: END IF;
3670:
3671: IF p_eam_op_comp_tbl.COUNT > 0 THEN
3672: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION') ; END IF ;
3673:
3674: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION
3675: (
3676: p_eam_op_compl_tbl => p_eam_op_comp_tbl

Line 3674: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION

3670:
3671: IF p_eam_op_comp_tbl.COUNT > 0 THEN
3672: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION') ; END IF ;
3673:
3674: EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION
3675: (
3676: p_eam_op_compl_tbl => p_eam_op_comp_tbl
3677: , p_eam_wo_quality_tbl => p_eam_wo_quality_tbl
3678: , x_eam_op_comp_tbl => x_eam_op_comp_tbl

Line 3686: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION: '||l_return_status); END IF ;

3682: );
3683:
3684: x_return_status := l_return_status;
3685: x_msg_count := l_msg_count;
3686: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION: '||l_return_status); END IF ;
3687:
3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3689: THEN
3690: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;

Line 3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3684: x_return_status := l_return_status;
3685: x_msg_count := l_msg_count;
3686: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.COMP_UNCOMP_OPERATION: '||l_return_status); END IF ;
3687:
3688: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3689: THEN
3690: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3691: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3692: END IF;

Line 3699: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO'); END IF ;

3695: END IF;
3696:
3697:
3698: IF p_eam_request_tbl.COUNT > 0 THEN
3699: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO'); END IF ;
3700: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO
3701: (
3702: p_eam_request_tbl => l_eam_request_tbl
3703: , x_eam_request_tbl => x_eam_request_tbl

Line 3700: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO

3696:
3697:
3698: IF p_eam_request_tbl.COUNT > 0 THEN
3699: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Calling EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO'); END IF ;
3700: EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO
3701: (
3702: p_eam_request_tbl => l_eam_request_tbl
3703: , x_eam_request_tbl => x_eam_request_tbl
3704: , x_return_status => l_return_status

Line 3711: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO : '||l_return_status); END IF ;

3707:
3708: x_return_status := l_return_status;
3709: x_msg_count := l_msg_count;
3710:
3711: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO : '||l_return_status); END IF ;
3712:
3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3714: THEN
3715: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;

Line 3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3709: x_msg_count := l_msg_count;
3710:
3711: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Return status from EAM_PROCESS_WO_PVT.SERVICE_WORKREQUEST_ASSO : '||l_return_status); END IF ;
3712:
3713: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3714: THEN
3715: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3716: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3717: END IF;

Line 3754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3750: x_eam_wo_comp_mr_read_tbl := l_eam_wo_comp_mr_read_tbl;
3751: x_eam_op_comp_tbl := l_eam_op_comp_tbl;
3752: x_eam_request_tbl := l_eam_request_tbl;
3753:
3754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3755: THEN
3756: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3757: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3758: END IF;

Line 3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3848:
3849: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3850: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3851:
3852: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3853: THEN
3854: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3855: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3856: END IF;

Line 3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'

3955:
3956: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_UNEXPECTED;
3957: x_msg_count := EAM_ERROR_MESSAGE_PVT.Get_Message_Count;
3958:
3959: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y'
3960: THEN
3961: EAM_ERROR_MESSAGE_PVT.Dump_Message_List;
3962: EAM_ERROR_MESSAGE_PVT.Close_Debug_Session;
3963: END IF;

Line 4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;

4021: l_eam_wc_wo_assoc_tbl EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_tbl_type;
4022:
4023: BEGIN
4024:
4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;
4026:
4027: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Preparing permit header and association tables'); END IF ;
4028:
4029: -- copy old table in 12.1.3 code to 12.2 code.

Line 4027: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Preparing permit header and association tables'); END IF ;

4023: BEGIN
4024:
4025: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Start ====================='); END IF ;
4026:
4027: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Preparing permit header and association tables'); END IF ;
4028:
4029: -- copy old table in 12.1.3 code to 12.2 code.
4030:
4031: IF(p_eam_permit_tbl IS NOT NULL AND p_eam_permit_tbl.COUNT>0) THEN

Line 4139: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Calling PROCESS_WO with Permits and clearances'); END IF;

4135: END IF;
4136:
4137: -- Delegate call to new signature
4138:
4139: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : Calling PROCESS_WO with Permits and clearances'); END IF;
4140:
4141: PROCESS_WO
4142: ( p_bo_identifier => p_bo_identifier
4143: , p_api_version_number => p_api_version_number

Line 4192: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : End : Status : '||x_return_status); END IF;

4188: , p_debug_filename =>p_debug_filename
4189: , p_debug_file_mode =>p_debug_file_mode
4190: );
4191:
4192: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits : End : Status : '||x_return_status); END IF;
4193:
4194: END PROCESS_WO;
4195:
4196:

Line 4275: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Start ==========='); END IF ;

4271: i number;
4272:
4273: BEGIN
4274:
4275: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Start ==========='); END IF ;
4276:
4277: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Calling plain PROCESS_WO'); END IF ;
4278:
4279: PROCESS_WO

Line 4277: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Calling plain PROCESS_WO'); END IF ;

4273: BEGIN
4274:
4275: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Start ==========='); END IF ;
4276:
4277: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Calling plain PROCESS_WO'); END IF ;
4278:
4279: PROCESS_WO
4280: ( p_bo_identifier => p_bo_identifier
4281: , p_api_version_number => p_api_version_number

Line 4326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

4322: , p_debug_filename => p_debug_filename
4323: , p_debug_file_mode => p_debug_file_mode
4324: );
4325:
4326: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4327: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Overloaded procedure for Safety Permits and Clearances : Return status from plain PROCESS_WO: '||l_return_status);
4328: END IF ;
4329:
4330: x_return_status := l_return_status ;

Line 4349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

4345: ELSIF p_eam_permit_wo_assoc_tbl.COUNT > 0 THEN
4346: l_wip_entity_id :=p_eam_permit_wo_assoc_tbl(1).TARGET_REF_ID;
4347: END IF;
4348:
4349: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4350: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances : Preparing Permit header ('||p_eam_permit_tbl.COUNT||') and association ('||p_eam_permit_wo_assoc_tbl.COUNT||') tables');
4351: END IF ;
4352:
4353: -- Process new permit records(create WO)

Line 4359: IF l_work_permit_header_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN

4355: IF p_eam_permit_tbl.COUNT > 0 THEN
4356: FOR i in p_eam_permit_tbl.FIRST..p_eam_permit_tbl.LAST LOOP
4357:
4358: l_work_permit_header_rec := p_eam_permit_tbl(i);
4359: IF l_work_permit_header_rec.transaction_type=EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
4360: --build association record using permit header record
4361:
4362: l_permit_wo_association_rec.HEADER_ID :=1;
4363: l_permit_wo_association_rec.BATCH_ID :=l_wip_entity_id;

Line 4369: l_permit_wo_association_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PVT.G_OPR_CREATE;

4365: l_permit_wo_association_rec.SAFETY_ASSOCIATION_ID := null;
4366: l_permit_wo_association_rec.SOURCE_ID :=null;
4367: l_permit_wo_association_rec.TARGET_REF_ID := l_wip_entity_id;
4368: l_permit_wo_association_rec.ASSOCIATION_TYPE :=3;
4369: l_permit_wo_association_rec.TRANSACTION_TYPE :=EAM_PROCESS_WO_PVT.G_OPR_CREATE;
4370: l_permit_wo_association_rec.ORGANIZATION_ID :=l_work_permit_header_rec.ORGANIZATION_ID;
4371: l_permit_wo_association_rec.ATTRIBUTE_CATEGORY :=l_work_permit_header_rec.ATTRIBUTE_CATEGORY;
4372: l_permit_wo_association_rec.ATTRIBUTE1 :=l_work_permit_header_rec.ATTRIBUTE1;
4373: l_permit_wo_association_rec.ATTRIBUTE2 :=l_work_permit_header_rec.ATTRIBUTE2;

Line 4461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

4457: );
4458:
4459: */
4460:
4461: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4462: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT Permit name: '||l_work_permit_header_rec.permit_name);
4463: END IF ;
4464:
4465: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_PERMIT(

Line 4510: ( p_validation_level => EAM_PROCESS_WO_PVT.G_OPR_UPDATE

4506: i := i+1;
4507:
4508: /*
4509: EAM_PROCESS_PERMIT_PVT.PERMIT_WORK_ORDER_ASSOCIATION
4510: ( p_validation_level => EAM_PROCESS_WO_PVT.G_OPR_UPDATE
4511: , p_organization_id => p_eam_wo_rec.organization_id
4512: , p_permit_wo_association_tbl => l_permit_wo_association_tbl
4513: , p_work_permit_id => l_permit_wo_association_tbl(1).SOURCE_ID
4514: , x_permit_wo_association_tbl => lx_permit_wo_association_tbl

Line 4550: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN

4546: FOR i in p_eam_work_clearance_tbl.FIRST..p_eam_work_clearance_tbl.LAST LOOP
4547:
4548: l_eam_work_clearance_rec := p_eam_work_clearance_tbl(i);
4549:
4550: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
4551: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :Calling EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE Clearance name: '||l_eam_work_clearance_rec.WORK_CLEARANCE_NAME);
4552: END IF ;
4553: EAM_PROCESS_SAFETY_PUB.PROCESS_WORK_CLEARANCE(
4554: p_init_msg_list => TRUE

Line 4607: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :End :Status: '||x_return_status); END IF ;

4603: END IF; -- if(l_return_staus='S'.....)
4604:
4605: x_return_status :='S'; -- Return success if the program is through other procedure calls.
4606:
4607: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.PROCESS_WO : Permits and Clearances :End :Status: '||x_return_status); END IF ;
4608:
4609: END PROCESS_WO;
4610:
4611:

Line 4665: EAM_PROCESS_WO_PVT.PROCESS_WO

4661: l_eam_wo_rec.RETURN_STATUS := null;
4662: l_eam_wo_rec.TRANSACTION_TYPE := 2;
4663:
4664:
4665: EAM_PROCESS_WO_PVT.PROCESS_WO
4666: ( p_api_version_number => p_api_version
4667: , x_return_status => x_return_status
4668: , x_msg_count => x_msg_count
4669: , p_eam_wo_rec => l_eam_wo_rec

Line 5018: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OP record'); END IF;

5014: l_organization_id := p_eam_wo_rec.organization_id;
5015: END IF;
5016: -- end - baroy
5017:
5018: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OP record'); END IF;
5019:
5020: FOR I IN 1..p_eam_op_tbl.COUNT LOOP
5021: IF p_eam_op_tbl(I).wip_entity_id is not null AND (
5022: p_eam_op_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5030: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OPN record'); END IF;

5026: l_other_message := 'EAM_WO_BO_REC_INVALID';
5027: END IF;
5028: END LOOP;
5029:
5030: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating OPN record'); END IF;
5031:
5032: FOR I IN 1..p_eam_op_network_tbl.COUNT LOOP
5033: IF p_eam_op_network_tbl(I).wip_entity_id is not null AND (
5034: p_eam_op_network_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5042: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES record'); END IF;

5038: l_other_message := 'EAM_WO_BO_REC_INVALID';
5039: END IF;
5040: END LOOP;
5041:
5042: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES record'); END IF;
5043:
5044: FOR I IN 1..p_eam_res_tbl.COUNT LOOP
5045:
5046: IF p_eam_res_tbl(I).wip_entity_id is not null AND (

Line 5055: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_INST record'); END IF;

5051: l_other_message := 'EAM_WO_BO_REC_INVALID';
5052: END IF;
5053: END LOOP;
5054:
5055: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_INST record'); END IF;
5056:
5057: FOR I IN 1..p_eam_res_inst_tbl.COUNT LOOP
5058: IF p_eam_res_inst_tbl(I).wip_entity_id is not null AND (
5059: p_eam_res_inst_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5067: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating SUB_RES record'); END IF;

5063: l_other_message := 'EAM_WO_BO_REC_INVALID';
5064: END IF;
5065: END LOOP;
5066:
5067: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating SUB_RES record'); END IF;
5068:
5069: FOR I IN 1..p_eam_sub_res_tbl.COUNT LOOP
5070: IF p_eam_sub_res_tbl(I).wip_entity_id is not null AND (
5071: p_eam_sub_res_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5079: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_USAGE record'); END IF;

5075: l_other_message := 'EAM_WO_BO_REC_INVALID';
5076: END IF;
5077: END LOOP;
5078:
5079: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating RES_USAGE record'); END IF;
5080:
5081: FOR I IN 1..p_eam_res_usage_tbl.COUNT LOOP
5082: IF p_eam_res_usage_tbl(I).wip_entity_id is not null AND (
5083: p_eam_res_usage_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5091: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating MAT_REQ record'); END IF;

5087: l_other_message := 'EAM_WO_BO_REC_INVALID';
5088: END IF;
5089: END LOOP;
5090:
5091: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating MAT_REQ record'); END IF;
5092:
5093: FOR I IN 1..p_eam_mat_req_tbl.COUNT LOOP
5094: IF p_eam_mat_req_tbl(I).wip_entity_id is not null AND (
5095: p_eam_mat_req_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5103: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating DI record'); END IF;

5099: l_other_message := 'EAM_WO_BO_REC_INVALID';
5100: END IF;
5101: END LOOP;
5102:
5103: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating DI record'); END IF;
5104:
5105: FOR I IN 1..p_eam_direct_items_tbl.COUNT LOOP
5106: IF p_eam_direct_items_tbl(I).wip_entity_id is not null AND (
5107: p_eam_direct_items_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5186: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Quality record'); END IF;

5182: l_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;
5183: l_eam_wo_comp_mr_read_tbl := p_eam_wo_comp_mr_read_tbl;
5184:
5185:
5186: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Quality record'); END IF;
5187:
5188: FOR I IN 1..l_eam_wo_quality_tbl.COUNT LOOP
5189: IF p_eam_wo_quality_tbl(I).wip_entity_id is not null AND (
5190: p_eam_wo_quality_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5198: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter record'); END IF;

5194: l_other_message := 'EAM_WO_BO_REC_INVALID';
5195: END IF;
5196: END LOOP;
5197:
5198: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter record'); END IF;
5199:
5200: FOR I IN 1..l_eam_meter_reading_tbl.COUNT LOOP
5201: IF p_eam_meter_reading_tbl(I).wip_entity_id is not null AND (
5202: p_eam_meter_reading_tbl(I).wip_entity_id <> l_wip_entity_id

Line 5210: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Counter Properties record'); END IF;

5206: l_other_message := 'EAM_WO_BO_REC_INVALID';
5207: END IF;
5208: END LOOP;
5209:
5210: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Counter Properties record'); END IF;
5211:
5212: FOR I IN 1..l_eam_counter_prop_tbl.COUNT LOOP
5213: IF p_eam_counter_prop_tbl(I).wip_entity_id is not null AND (
5214: p_eam_counter_prop_tbl(I).wip_entity_id <> l_wip_entity_id

Line 5223: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter Completion record'); END IF;

5219: END IF;
5220: END LOOP;
5221:
5222:
5223: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Meter Completion record'); END IF;
5224:
5225: FOR I IN 1..l_eam_wo_comp_rebuild_tbl.COUNT LOOP
5226: IF p_eam_wo_comp_rebuild_tbl(I).wip_entity_id is not null AND (
5227: p_eam_wo_comp_rebuild_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5235: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Rebuild Completion record'); END IF;

5231: l_other_message := 'EAM_WO_BO_REC_INVALID';
5232: END IF;
5233: END LOOP;
5234:
5235: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : Validating Rebuild Completion record'); END IF;
5236:
5237: FOR I IN 1..l_eam_wo_comp_mr_read_tbl.COUNT LOOP
5238: IF p_eam_wo_comp_mr_read_tbl(I).wip_entity_id is not null AND (
5239: p_eam_wo_comp_mr_read_tbl(I).wip_entity_id <> l_wip_entity_id OR

Line 5305: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : End === Status : '||x_return_status||' ==================='); END IF;

5301:
5302:
5303: x_return_status := 'S';
5304:
5305: IF EAM_PROCESS_WO_PVT.get_debug = 'Y' then EAM_ERROR_MESSAGE_PVT.write_debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_PUB.CHECK_BO_RECORD : End === Status : '||x_return_status||' ==================='); END IF;
5306:
5307: RETURN;
5308:
5309: END CHECK_BO_RECORD;

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

5629:
5630:
5631: l_old_activity_id := l_eam_wo_rec.asset_activity_id;
5632: l_eam_wo_rec.asset_activity_id := null;
5633: l_eam_wo_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5634: l_eam_wo_rec.return_status := null;
5635:
5636: l_eam_wo_rec.date_released := null;
5637: l_eam_wo_rec.cycle_id := null;

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

5646:
5647: l_eam_op_rec.header_id := 1;
5648: l_eam_op_rec.batch_id := 1;
5649: l_eam_op_rec.wip_entity_id := null;
5650: l_eam_op_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5651: l_eam_op_rec.return_status := null;
5652:
5653: l_eam_op_rec.organization_id := opRec.organization_id;
5654: l_eam_op_rec.operation_seq_num := opRec.operation_seq_num;

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

5687: FOR opRes IN l_op_resources LOOP
5688: l_eam_res_rec.header_id := 1;
5689: l_eam_res_rec.batch_id := 1;
5690: l_eam_res_rec.wip_entity_id := null;
5691: l_eam_res_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5692: l_eam_res_rec.return_status := null;
5693:
5694: l_eam_res_rec.organization_id := opRes.organization_id ;
5695: l_eam_res_rec.operation_seq_num := opRes.operation_seq_num ;

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

5738:
5739: l_eam_res_inst_rec.header_id := 1;
5740: l_eam_res_inst_rec.batch_id := 1;
5741: l_eam_res_inst_rec.wip_entity_id := null;
5742: l_eam_res_inst_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5743: l_eam_res_inst_rec.return_status := null;
5744:
5745: l_eam_res_inst_rec.organization_id := opResInst.organization_id ;
5746: l_eam_res_inst_rec.operation_seq_num := opResInst.operation_seq_num ;

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

5761:
5762: l_eam_op_network_rec.header_id := 1;
5763: l_eam_op_network_rec.batch_id := 1;
5764: l_eam_op_network_rec.wip_entity_id := null;
5765: l_eam_op_network_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5766: l_eam_op_network_rec.return_status := null;
5767:
5768: l_eam_op_network_rec.organization_id := opNetwork.organization_id ;
5769: l_eam_op_network_rec.prior_operation := opNetwork.prior_operation ;

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

5795:
5796: l_eam_mat_req_rec.header_id := 1;
5797: l_eam_mat_req_rec.batch_id := 1;
5798: l_eam_mat_req_rec.wip_entity_id := null;
5799: l_eam_mat_req_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5800: l_eam_mat_req_rec.return_status := null;
5801:
5802: l_eam_mat_req_rec.organization_id := opMaterial.organization_id ;
5803: l_eam_mat_req_rec.operation_seq_num := opMaterial.operation_seq_num ;

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

5842:
5843: l_eam_di_rec.header_id := 1;
5844: l_eam_di_rec.batch_id := 1;
5845: l_eam_di_rec.wip_entity_id := null;
5846: l_eam_di_rec.transaction_type := EAM_PROCESS_WO_PVT.G_OPR_CREATE;
5847: l_eam_di_rec.return_status := null;
5848:
5849: l_eam_di_rec.description := opDirectItem.description ;
5850: l_eam_di_rec.purchasing_category_id := opDirectItem.purchasing_category_id ;