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_PVT dependencies on FND_API

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: WF_CORE.CONTEXT('Enterprise Asset Management...',l_event_name,'Exception during event construction and raise: ' || SQLERRM);
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: END RAISE_WORKFLOW_EVENTS;
334:
335:
336:

Line 493: x_return_status := FND_API.G_RET_STS_SUCCESS;

489:
490: BEGIN
491: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_res_usage_tbl.COUNT ||' records passed') ; END IF ;
492:
493: x_return_status := FND_API.G_RET_STS_SUCCESS;
494:
495: -- Init local table variables.
496: l_return_status := 'S' ;
497: l_bo_return_status := 'S' ;

Line 533: IF (l_eam_res_usage_rec.return_status IS NULL OR l_eam_res_usage_rec.return_status = FND_API.G_MISS_CHAR)

529: END IF;
530:
531: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
532:
533: IF (l_eam_res_usage_rec.return_status IS NULL OR l_eam_res_usage_rec.return_status = FND_API.G_MISS_CHAR)
534: AND
535: (NOT l_parent_exists
536: OR
537: (l_parent_exists AND

Line 549: l_return_status := FND_API.G_RET_STS_SUCCESS;

545:
546: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
547:
548:
549: l_return_status := FND_API.G_RET_STS_SUCCESS;
550: l_eam_res_usage_rec.return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: VALIDATE_TRANSACTION_TYPE
553: ( p_transaction_type => l_eam_res_usage_rec.transaction_type

Line 550: l_eam_res_usage_rec.return_status := FND_API.G_RET_STS_SUCCESS;

546: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
547:
548:
549: l_return_status := FND_API.G_RET_STS_SUCCESS;
550: l_eam_res_usage_rec.return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: VALIDATE_TRANSACTION_TYPE
553: ( p_transaction_type => l_eam_res_usage_rec.transaction_type
554: , p_entity_name => 'RESOURCE_SEQ_NUM'

Line 1046: x_return_status := FND_API.G_RET_STS_SUCCESS;

1042:
1043: BEGIN
1044: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_sub_res_tbl.COUNT ||' records passed') ; END IF ;
1045:
1046: x_return_status := FND_API.G_RET_STS_SUCCESS;
1047:
1048: -- Init local table variables.
1049: l_return_status := 'S' ;
1050: l_bo_return_status := 'S' ;

Line 1085: IF (l_eam_sub_res_rec.return_status IS NULL OR l_eam_sub_res_rec.return_status = FND_API.G_MISS_CHAR)

1081: END IF;
1082:
1083: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
1084:
1085: IF (l_eam_sub_res_rec.return_status IS NULL OR l_eam_sub_res_rec.return_status = FND_API.G_MISS_CHAR)
1086: AND
1087: (NOT l_parent_exists
1088: OR
1089: (l_parent_exists AND

Line 1100: l_return_status := FND_API.G_RET_STS_SUCCESS;

1096:
1097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
1098:
1099:
1100: l_return_status := FND_API.G_RET_STS_SUCCESS;
1101: l_eam_sub_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1102:
1103: VALIDATE_TRANSACTION_TYPE
1104: ( p_transaction_type => l_eam_sub_res_rec.transaction_type

Line 1101: l_eam_sub_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1097: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
1098:
1099:
1100: l_return_status := FND_API.G_RET_STS_SUCCESS;
1101: l_eam_sub_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1102:
1103: VALIDATE_TRANSACTION_TYPE
1104: ( p_transaction_type => l_eam_sub_res_rec.transaction_type
1105: , p_entity_name => 'RESOURCE_SEQ_NUM'

Line 1756: x_return_status := FND_API.G_RET_STS_SUCCESS;

1752:
1753: BEGIN
1754: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_res_inst_tbl.COUNT ||' records passed') ; END IF ;
1755:
1756: x_return_status := FND_API.G_RET_STS_SUCCESS;
1757:
1758: IF x_bottomup_scheduled = G_NON_FIRM_WORKORDER THEN
1759: x_schedule_wo := G_SCHEDULE_WO;
1760: END IF;

Line 1799: IF (l_eam_res_inst_rec.return_status IS NULL OR l_eam_res_inst_rec.return_status = FND_API.G_MISS_CHAR)

1795: END IF;
1796:
1797: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
1798:
1799: IF (l_eam_res_inst_rec.return_status IS NULL OR l_eam_res_inst_rec.return_status = FND_API.G_MISS_CHAR)
1800: AND
1801: (NOT l_parent_exists
1802: OR
1803: (l_parent_exists AND

Line 1814: l_return_status := FND_API.G_RET_STS_SUCCESS;

1810: THEN
1811:
1812: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
1813:
1814: l_return_status := FND_API.G_RET_STS_SUCCESS;
1815: l_eam_res_inst_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1816:
1817: VALIDATE_TRANSACTION_TYPE
1818: ( p_transaction_type => l_eam_res_inst_rec.transaction_type

Line 1815: l_eam_res_inst_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1811:
1812: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
1813:
1814: l_return_status := FND_API.G_RET_STS_SUCCESS;
1815: l_eam_res_inst_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1816:
1817: VALIDATE_TRANSACTION_TYPE
1818: ( p_transaction_type => l_eam_res_inst_rec.transaction_type
1819: , p_entity_name => 'RESOURCE_INSTANCE'

Line 2430: x_return_status := FND_API.G_RET_STS_SUCCESS;

2426:
2427: BEGIN
2428: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_op_network_tbl.COUNT ||' records passed') ; END IF ;
2429:
2430: x_return_status := FND_API.G_RET_STS_SUCCESS;
2431:
2432: -- Init local table variables.
2433: l_return_status := 'S' ;
2434: l_bo_return_status := 'S' ;

Line 2466: IF (l_eam_op_network_rec.return_status IS NULL OR l_eam_op_network_rec.return_status = FND_API.G_MISS_CHAR)

2462: END IF;
2463:
2464: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
2465:
2466: IF (l_eam_op_network_rec.return_status IS NULL OR l_eam_op_network_rec.return_status = FND_API.G_MISS_CHAR)
2467: AND
2468: (NOT l_parent_exists
2469: OR
2470: (l_parent_exists AND

Line 2479: l_return_status := FND_API.G_RET_STS_SUCCESS;

2475: THEN
2476:
2477: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
2478:
2479: l_return_status := FND_API.G_RET_STS_SUCCESS;
2480: l_eam_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2481:
2482: VALIDATE_TRANSACTION_TYPE
2483: ( p_transaction_type => l_eam_op_network_rec.transaction_type

Line 2480: l_eam_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2476:
2477: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
2478:
2479: l_return_status := FND_API.G_RET_STS_SUCCESS;
2480: l_eam_op_network_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2481:
2482: VALIDATE_TRANSACTION_TYPE
2483: ( p_transaction_type => l_eam_op_network_rec.transaction_type
2484: , p_entity_name => 'OPERATION_NETWORK'

Line 3073: x_return_status := FND_API.G_RET_STS_SUCCESS;

3069:
3070: BEGIN
3071: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_mat_req_tbl.COUNT ||' records passed') ; END IF ;
3072:
3073: x_return_status := FND_API.G_RET_STS_SUCCESS;
3074:
3075: -- Init local table variables.
3076: l_return_status := 'S' ;
3077: l_bo_return_status := 'S' ;

Line 3137: IF (l_eam_mat_req_rec.return_status IS NULL OR l_eam_mat_req_rec.return_status = FND_API.G_MISS_CHAR)

3133: END IF;
3134:
3135: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
3136:
3137: IF (l_eam_mat_req_rec.return_status IS NULL OR l_eam_mat_req_rec.return_status = FND_API.G_MISS_CHAR)
3138: AND
3139: (NOT l_parent_exists
3140: OR
3141: (l_parent_exists AND

Line 3153: l_return_status := FND_API.G_RET_STS_SUCCESS;

3149: THEN
3150:
3151: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
3152:
3153: l_return_status := FND_API.G_RET_STS_SUCCESS;
3154: l_eam_mat_req_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3155:
3156: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
3157:

Line 3154: l_eam_mat_req_rec.return_status := FND_API.G_RET_STS_SUCCESS;

3150:
3151: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
3152:
3153: l_return_status := FND_API.G_RET_STS_SUCCESS;
3154: l_eam_mat_req_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3155:
3156: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
3157:
3158: VALIDATE_TRANSACTION_TYPE

Line 3454: p_init_msg_list => fnd_api.g_false,

3450: IF(l_eam_mat_req_rec.requested_quantity IS NOT NULL) THEN
3451:
3452: EAM_MATERIAL_REQUEST_PVT.allocate
3453: (p_api_version => 1.0,
3454: p_init_msg_list => fnd_api.g_false,
3455: p_commit => fnd_api.g_false,
3456: p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id,
3457: p_organization_id => l_eam_mat_req_rec.organization_id,
3458: p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num,

Line 3455: p_commit => fnd_api.g_false,

3451:
3452: EAM_MATERIAL_REQUEST_PVT.allocate
3453: (p_api_version => 1.0,
3454: p_init_msg_list => fnd_api.g_false,
3455: p_commit => fnd_api.g_false,
3456: p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id,
3457: p_organization_id => l_eam_mat_req_rec.organization_id,
3458: p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num,
3459: p_inventory_item_id => l_eam_mat_req_rec.inventory_item_id,

Line 3522: ,p_init_msg_list => FND_API.G_FALSE

3518:
3519:
3520: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3521: ( p_api_version => 1.0
3522: ,p_init_msg_list => FND_API.G_FALSE
3523: ,p_commit => FND_API.G_FALSE
3524: ,p_validate_only => FND_API.G_TRUE
3525: ,x_return_status => l_api_return_status
3526: ,x_msg_count => l_api_msg_count

Line 3523: ,p_commit => FND_API.G_FALSE

3519:
3520: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3521: ( p_api_version => 1.0
3522: ,p_init_msg_list => FND_API.G_FALSE
3523: ,p_commit => FND_API.G_FALSE
3524: ,p_validate_only => FND_API.G_TRUE
3525: ,x_return_status => l_api_return_status
3526: ,x_msg_count => l_api_msg_count
3527: ,x_msg_data => l_api_msg_data

Line 3524: ,p_validate_only => FND_API.G_TRUE

3520: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3521: ( p_api_version => 1.0
3522: ,p_init_msg_list => FND_API.G_FALSE
3523: ,p_commit => FND_API.G_FALSE
3524: ,p_validate_only => FND_API.G_TRUE
3525: ,x_return_status => l_api_return_status
3526: ,x_msg_count => l_api_msg_count
3527: ,x_msg_data => l_api_msg_data
3528: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id

Line 3621: ,p_init_msg_list => FND_API.G_FALSE

3617: -- IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('creating reqs for quantity'||l_total_req_qty ||' required qty :'||l_eam_mat_req_rec.required_quantity); END IF;
3618:
3619: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3620: ( p_api_version => 1.0
3621: ,p_init_msg_list => FND_API.G_FALSE
3622: ,p_commit => FND_API.G_FALSE
3623: ,p_validate_only => FND_API.G_TRUE
3624: ,x_return_status => l_api_return_status
3625: ,x_msg_count => l_api_msg_count

Line 3622: ,p_commit => FND_API.G_FALSE

3618:
3619: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3620: ( p_api_version => 1.0
3621: ,p_init_msg_list => FND_API.G_FALSE
3622: ,p_commit => FND_API.G_FALSE
3623: ,p_validate_only => FND_API.G_TRUE
3624: ,x_return_status => l_api_return_status
3625: ,x_msg_count => l_api_msg_count
3626: ,x_msg_data => l_api_msg_data

Line 3623: ,p_validate_only => FND_API.G_TRUE

3619: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3620: ( p_api_version => 1.0
3621: ,p_init_msg_list => FND_API.G_FALSE
3622: ,p_commit => FND_API.G_FALSE
3623: ,p_validate_only => FND_API.G_TRUE
3624: ,x_return_status => l_api_return_status
3625: ,x_msg_count => l_api_msg_count
3626: ,x_msg_data => l_api_msg_data
3627: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id

Line 3990: x_return_status := FND_API.G_RET_STS_SUCCESS;

3986:
3987: BEGIN
3988: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_direct_items_tbl.COUNT ||' records passed') ; END IF ;
3989:
3990: x_return_status := FND_API.G_RET_STS_SUCCESS;
3991:
3992: -- Init local table variables.
3993: l_return_status := 'S' ;
3994: l_bo_return_status := 'S' ;

Line 4054: IF (l_eam_direct_items_rec.return_status IS NULL OR l_eam_direct_items_rec.return_status = FND_API.G_MISS_CHAR)

4050: END IF;
4051:
4052: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
4053:
4054: IF (l_eam_direct_items_rec.return_status IS NULL OR l_eam_direct_items_rec.return_status = FND_API.G_MISS_CHAR)
4055: AND
4056: (NOT l_parent_exists
4057: OR
4058: (l_parent_exists AND

Line 4070: l_return_status := FND_API.G_RET_STS_SUCCESS;

4066: THEN
4067:
4068: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4069:
4070: l_return_status := FND_API.G_RET_STS_SUCCESS;
4071: l_eam_direct_items_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4072:
4073: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
4074:

Line 4071: l_eam_direct_items_rec.return_status := FND_API.G_RET_STS_SUCCESS;

4067:
4068: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4069:
4070: l_return_status := FND_API.G_RET_STS_SUCCESS;
4071: l_eam_direct_items_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4072:
4073: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
4074:
4075: VALIDATE_TRANSACTION_TYPE

Line 4351: ,p_init_msg_list => FND_API.G_FALSE

4347: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('create requisitions for description direct items'); END IF;
4348:
4349: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4350: ( p_api_version => 1.0
4351: ,p_init_msg_list => FND_API.G_FALSE
4352: ,p_commit => FND_API.G_FALSE
4353: ,p_validate_only => FND_API.G_TRUE
4354: ,x_return_status => l_api_return_status
4355: ,x_msg_count => l_api_msg_count

Line 4352: ,p_commit => FND_API.G_FALSE

4348:
4349: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4350: ( p_api_version => 1.0
4351: ,p_init_msg_list => FND_API.G_FALSE
4352: ,p_commit => FND_API.G_FALSE
4353: ,p_validate_only => FND_API.G_TRUE
4354: ,x_return_status => l_api_return_status
4355: ,x_msg_count => l_api_msg_count
4356: ,x_msg_data => l_api_msg_data

Line 4353: ,p_validate_only => FND_API.G_TRUE

4349: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4350: ( p_api_version => 1.0
4351: ,p_init_msg_list => FND_API.G_FALSE
4352: ,p_commit => FND_API.G_FALSE
4353: ,p_validate_only => FND_API.G_TRUE
4354: ,x_return_status => l_api_return_status
4355: ,x_msg_count => l_api_msg_count
4356: ,x_msg_data => l_api_msg_data
4357: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id

Line 4418: ,p_init_msg_list => FND_API.G_FALSE

4414: /*Added union, 6118897-- end---*/
4415:
4416: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4417: ( p_api_version => 1.0
4418: ,p_init_msg_list => FND_API.G_FALSE
4419: ,p_commit => FND_API.G_FALSE
4420: ,p_validate_only => FND_API.G_TRUE
4421: ,x_return_status => l_api_return_status
4422: ,x_msg_count => l_api_msg_count

Line 4419: ,p_commit => FND_API.G_FALSE

4415:
4416: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4417: ( p_api_version => 1.0
4418: ,p_init_msg_list => FND_API.G_FALSE
4419: ,p_commit => FND_API.G_FALSE
4420: ,p_validate_only => FND_API.G_TRUE
4421: ,x_return_status => l_api_return_status
4422: ,x_msg_count => l_api_msg_count
4423: ,x_msg_data => l_api_msg_data

Line 4420: ,p_validate_only => FND_API.G_TRUE

4416: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4417: ( p_api_version => 1.0
4418: ,p_init_msg_list => FND_API.G_FALSE
4419: ,p_commit => FND_API.G_FALSE
4420: ,p_validate_only => FND_API.G_TRUE
4421: ,x_return_status => l_api_return_status
4422: ,x_msg_count => l_api_msg_count
4423: ,x_msg_data => l_api_msg_data
4424: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id

Line 4781: x_return_status := FND_API.G_RET_STS_SUCCESS;

4777:
4778: BEGIN
4779: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_res_tbl.COUNT ||' records passed') ; END IF ;
4780:
4781: x_return_status := FND_API.G_RET_STS_SUCCESS;
4782:
4783: -- Init local table variables.
4784: l_return_status := 'S' ;
4785: l_bo_return_status := 'S' ;

Line 4816: IF (l_eam_res_rec.return_status IS NULL OR l_eam_res_rec.return_status = FND_API.G_MISS_CHAR)

4812: THEN
4813: l_parent_exists := TRUE;
4814: END IF;
4815:
4816: IF (l_eam_res_rec.return_status IS NULL OR l_eam_res_rec.return_status = FND_API.G_MISS_CHAR)
4817: AND
4818: (NOT l_parent_exists
4819: OR
4820: (l_parent_exists AND

Line 4830: l_return_status := FND_API.G_RET_STS_SUCCESS;

4826: THEN
4827:
4828: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4829:
4830: l_return_status := FND_API.G_RET_STS_SUCCESS;
4831: l_eam_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4832:
4833: VALIDATE_TRANSACTION_TYPE
4834: ( p_transaction_type => l_eam_res_rec.transaction_type

Line 4831: l_eam_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;

4827:
4828: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4829:
4830: l_return_status := FND_API.G_RET_STS_SUCCESS;
4831: l_eam_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4832:
4833: VALIDATE_TRANSACTION_TYPE
4834: ( p_transaction_type => l_eam_res_rec.transaction_type
4835: , p_entity_name => 'OPERATION_RESOURCE'

Line 5595: x_return_status := FND_API.G_RET_STS_SUCCESS;

5591:
5592: BEGIN
5593: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(p_eam_op_tbl.COUNT ||' records passed') ; END IF ;
5594:
5595: x_return_status := FND_API.G_RET_STS_SUCCESS;
5596:
5597: -- Init local table variables.
5598: l_return_status := 'S' ;
5599: l_bo_return_status := 'S' ;

Line 5632: IF (l_eam_op_rec.return_status IS NULL OR l_eam_op_rec.return_status = FND_API.G_MISS_CHAR)

5628: THEN
5629: l_parent_exists := TRUE;
5630: END IF;
5631:
5632: IF (l_eam_op_rec.return_status IS NULL OR l_eam_op_rec.return_status = FND_API.G_MISS_CHAR)
5633: AND
5634: (NOT l_parent_exists
5635: OR
5636: (l_parent_exists AND

Line 5645: l_return_status := FND_API.G_RET_STS_SUCCESS;

5641: THEN
5642:
5643: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5644:
5645: l_return_status := FND_API.G_RET_STS_SUCCESS;
5646: l_eam_op_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5647:
5648: VALIDATE_TRANSACTION_TYPE
5649: ( p_transaction_type => l_eam_op_rec.transaction_type

Line 5646: l_eam_op_rec.return_status := FND_API.G_RET_STS_SUCCESS;

5642:
5643: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5644:
5645: l_return_status := FND_API.G_RET_STS_SUCCESS;
5646: l_eam_op_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5647:
5648: VALIDATE_TRANSACTION_TYPE
5649: ( p_transaction_type => l_eam_op_rec.transaction_type
5650: , p_entity_name => 'OPERATION'

Line 6667: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

6663: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
6664:
6665: l_error_text VARCHAR2(2000);
6666: l_valid_transaction BOOLEAN := TRUE;
6667: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6668: l_pick_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6669: l_msg_count NUMBER := 0;
6670:
6671: l_bo_return_status VARCHAR2(1) := 'S';

Line 6668: l_pick_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

6664:
6665: l_error_text VARCHAR2(2000);
6666: l_valid_transaction BOOLEAN := TRUE;
6667: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6668: l_pick_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6669: l_msg_count NUMBER := 0;
6670:
6671: l_bo_return_status VARCHAR2(1) := 'S';
6672: l_return_value NUMBER;

Line 6706: x_return_status := FND_API.G_RET_STS_SUCCESS;

6702: l_min_open_period_date DATE;
6703:
6704: BEGIN
6705:
6706: x_return_status := FND_API.G_RET_STS_SUCCESS;
6707: l_wip_entity_id:=p_wip_entity_id;
6708:
6709: -- baroy - Skip the header validations if header is null
6710: -- If condition #101

Line 6728: l_eam_wo_rec.return_status <> FND_API.G_MISS_CHAR

6724:
6725: l_eam_wo_rec := p_eam_wo_rec;
6726:
6727: IF l_eam_wo_rec.return_status IS NOT NULL AND
6728: l_eam_wo_rec.return_status <> FND_API.G_MISS_CHAR
6729: THEN
6730: x_return_status := l_return_status;
6731: x_eam_wo_rec := l_eam_wo_rec;
6732: x_eam_op_tbl := l_eam_op_tbl;

Line 6743: l_return_status := FND_API.G_RET_STS_SUCCESS;

6739: x_eam_direct_items_tbl := l_eam_direct_items_tbl;
6740: RETURN;
6741: END IF;
6742:
6743: l_return_status := FND_API.G_RET_STS_SUCCESS;
6744: l_eam_wo_rec.return_status := FND_API.G_RET_STS_SUCCESS;
6745:
6746:
6747: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order: Transaction Type Validity . . . '); END IF;

Line 6744: l_eam_wo_rec.return_status := FND_API.G_RET_STS_SUCCESS;

6740: RETURN;
6741: END IF;
6742:
6743: l_return_status := FND_API.G_RET_STS_SUCCESS;
6744: l_eam_wo_rec.return_status := FND_API.G_RET_STS_SUCCESS;
6745:
6746:
6747: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Order: Transaction Type Validity . . . '); END IF;
6748:

Line 6796: IF ((l_eam_wo_rec.rebuild_serial_number is not null and l_eam_wo_rec.rebuild_serial_number <> FND_API.G_MISS_CHAR )or l_eam_wo_rec.asset_number is not null ) then

6792: --Changes for IB
6793: --If this is a work order on a predefined rebuild, create an instance for it NOW
6794: --If this is a automatic rebuild work order and the serial number has just been provided, update NOW
6795:
6796: IF ((l_eam_wo_rec.rebuild_serial_number is not null and l_eam_wo_rec.rebuild_serial_number <> FND_API.G_MISS_CHAR )or l_eam_wo_rec.asset_number is not null ) then
6797: select msn.current_status
6798: into l_current_status
6799: from mtl_serial_numbers msn
6800: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id, l_eam_wo_rec.asset_group_id)

Line 6807: ,P_INIT_MSG_LIST => fnd_api.g_false

6803: IF (l_current_status = 1 OR l_eam_wo_rec.maintenance_object_type = 2) THEN
6804: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM WO: Calling CREATE_ASSET procedure . . .'); END IF;
6805: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
6806: P_API_VERSION => 1.0
6807: ,P_INIT_MSG_LIST => fnd_api.g_false
6808: ,P_COMMIT => fnd_api.g_false
6809: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
6810: ,X_EAM_WO_REC => l_eam_wo_rec
6811: ,X_RETURN_STATUS => l_return_status

Line 6808: ,P_COMMIT => fnd_api.g_false

6804: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM WO: Calling CREATE_ASSET procedure . . .'); END IF;
6805: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
6806: P_API_VERSION => 1.0
6807: ,P_INIT_MSG_LIST => fnd_api.g_false
6808: ,P_COMMIT => fnd_api.g_false
6809: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
6810: ,X_EAM_WO_REC => l_eam_wo_rec
6811: ,X_RETURN_STATUS => l_return_status
6812: ,X_MSG_COUNT => l_msg_count

Line 6809: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full

6805: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
6806: P_API_VERSION => 1.0
6807: ,P_INIT_MSG_LIST => fnd_api.g_false
6808: ,P_COMMIT => fnd_api.g_false
6809: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
6810: ,X_EAM_WO_REC => l_eam_wo_rec
6811: ,X_RETURN_STATUS => l_return_status
6812: ,X_MSG_COUNT => l_msg_count
6813: ,X_MSG_DATA => l_error_text

Line 6816: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

6812: ,X_MSG_COUNT => l_msg_count
6813: ,X_MSG_DATA => l_error_text
6814: );
6815:
6816: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
6817: l_other_message := 'EAM_IB_INST_FAILED';
6818: l_other_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
6819: l_other_token_tbl(1).token_value := l_eam_wo_rec.wip_entity_name;
6820: RAISE EXC_UNEXP_SKIP_OBJECT;

Line 7356: IF l_firm_planned_flag IS NULL OR l_firm_planned_flag = FND_API.G_MISS_NUM THEN

7352: l_eam_wo_rec.pending_flag:='Y'; --if approval required set the pending flag and system status to previous status
7353: l_new_system_status := l_eam_wo_rec.status_type;
7354: l_eam_wo_rec.status_type := NVL(l_old_eam_wo_rec.status_type,17);
7355: /* Bug # 4597756 : revert back the firm_planned_flag */
7356: IF l_firm_planned_flag IS NULL OR l_firm_planned_flag = FND_API.G_MISS_NUM THEN
7357: l_eam_wo_rec.firm_planned_flag := 2;
7358: ELSE
7359: l_eam_wo_rec.firm_planned_flag := l_firm_planned_flag;
7360: END IF;

Line 7370: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)

7366:
7367: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Writing the WO Record to database...') ; END IF;
7368:
7369: if ((l_eam_wo_rec.pm_suggested_start_date is null or
7370: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)
7371: and (l_eam_wo_rec.pm_suggested_end_date is null or
7372: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
7373: and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
7374: ) then

Line 7372: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)

7368:
7369: if ((l_eam_wo_rec.pm_suggested_start_date is null or
7370: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)
7371: and (l_eam_wo_rec.pm_suggested_end_date is null or
7372: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
7373: and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
7374: ) then
7375: select pm_suggested_start_date, pm_suggested_end_date into
7376: l_eam_wo_rec.pm_suggested_start_date,

Line 7441: x_return_status := FND_API.G_RET_STS_SUCCESS;

7437: l_eam_sub_res_tbl := l_out_eam_sub_res_tbl;
7438: l_eam_mat_req_tbl := l_out_eam_mat_req_tbl;
7439: l_eam_direct_items_tbl := l_out_eam_direct_items_tbl;
7440: l_eam_res_usage_tbl := l_out_eam_res_usage_tbl;
7441: x_return_status := FND_API.G_RET_STS_SUCCESS;
7442:
7443: END IF;
7444:
7445: /* Bug # 4926626 : Disable hiearchy if automatic (replaced) rebuild WO is updated

Line 7574: , p_error_status => FND_API.G_RET_STS_ERROR

7570: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7571: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7572: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7573: , p_mesg_token_tbl => l_mesg_token_tbl
7574: , p_error_status => FND_API.G_RET_STS_ERROR
7575: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
7576: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
7577: , x_eam_wo_rec => l_out_eam_wo_rec
7578: , x_eam_op_tbl => l_out_eam_op_tbl

Line 7633: , p_error_status => FND_API.G_RET_STS_ERROR

7629: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7630: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7631: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7632: , p_mesg_token_tbl => l_mesg_token_tbl
7633: , p_error_status => FND_API.G_RET_STS_ERROR
7634: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
7635: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
7636: , p_other_message => l_other_message
7637: , p_other_token_tbl => l_other_token_tbl

Line 7695: , p_error_status => FND_API.G_RET_STS_ERROR

7691: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7692: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7693: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7694: , p_mesg_token_tbl => l_mesg_token_tbl
7695: , p_error_status => FND_API.G_RET_STS_ERROR
7696: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
7697: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
7698: , p_other_message => l_other_message
7699: , p_other_token_tbl => l_other_token_tbl

Line 7758: , p_error_status => FND_API.G_RET_STS_ERROR

7754: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7755: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7756: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7757: , p_mesg_token_tbl => l_mesg_token_tbl
7758: , p_error_status => FND_API.G_RET_STS_ERROR
7759: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
7760: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
7761: , p_other_message => l_other_message
7762: , p_other_token_tbl => l_other_token_tbl

Line 7821: , p_error_status => FND_API.G_RET_STS_ERROR

7817: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7818: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7819: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7820: , p_mesg_token_tbl => l_mesg_token_tbl
7821: , p_error_status => FND_API.G_RET_STS_ERROR
7822: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
7823: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
7824: , p_other_message => l_other_message
7825: , p_other_token_tbl => l_other_token_tbl

Line 8319: l_eam_wo_rec.date_released = FND_API.G_MISS_DATE) THEN

8315: )
8316: THEN
8317:
8318: IF(l_eam_wo_rec.date_released IS NULL OR
8319: l_eam_wo_rec.date_released = FND_API.G_MISS_DATE) THEN
8320:
8321: /*Bug#4425025 - set date_released to greatest of min open period start date
8322: *and scheduled start date if scheduled start date is in past*/
8323:

Line 8373: l_return_status := FND_API.G_RET_STS_ERROR;

8369: );
8370:
8371: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Status Change WO completed with status ' || l_return_status) ; END IF ;
8372: IF NVL(l_return_status, 'S') <> 'S' THEN
8373: l_return_status := FND_API.G_RET_STS_ERROR;
8374: RAISE G_ERR_STATUS_CHANGE;
8375:
8376: END IF;
8377:

Line 8432: and (l_eam_wo_rec.asset_activity_id is null or l_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM)) then

8428:
8429: -- if activity is deleted then also scheduler should get call
8430: if (x_schedule_wo <> G_SCHEDULE_WO and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
8431: and l_old_eam_wo_rec.asset_activity_id is not null
8432: and (l_eam_wo_rec.asset_activity_id is null or l_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM)) then
8433: x_schedule_wo := G_SCHEDULE_WO;
8434: end if;
8435:
8436:

Line 8537: p_init_msg_list => fnd_api.g_false,

8533: BEGIN
8534: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling the Estimate_Workorder_Grp procedure ...') ; END IF ;
8535: CSTPECEP.Estimate_WorkOrder_Grp(
8536: p_api_version => 1.0,
8537: p_init_msg_list => fnd_api.g_false,
8538: p_commit => fnd_api.g_false,
8539: p_validation_level => fnd_api.g_valid_level_full,
8540: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
8541: p_organization_id => l_eam_wo_rec.organization_id,

Line 8538: p_commit => fnd_api.g_false,

8534: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling the Estimate_Workorder_Grp procedure ...') ; END IF ;
8535: CSTPECEP.Estimate_WorkOrder_Grp(
8536: p_api_version => 1.0,
8537: p_init_msg_list => fnd_api.g_false,
8538: p_commit => fnd_api.g_false,
8539: p_validation_level => fnd_api.g_valid_level_full,
8540: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
8541: p_organization_id => l_eam_wo_rec.organization_id,
8542: x_return_status => l_return_status,

Line 8539: p_validation_level => fnd_api.g_valid_level_full,

8535: CSTPECEP.Estimate_WorkOrder_Grp(
8536: p_api_version => 1.0,
8537: p_init_msg_list => fnd_api.g_false,
8538: p_commit => fnd_api.g_false,
8539: p_validation_level => fnd_api.g_valid_level_full,
8540: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
8541: p_organization_id => l_eam_wo_rec.organization_id,
8542: x_return_status => l_return_status,
8543: x_msg_data => l_err_text,

Line 8552: l_bo_return_status := FND_API.G_RET_STS_ERROR;

8548: l_bo_return_status := l_return_status;
8549: END IF;
8550: EXCEPTION
8551: WHEN OTHERS THEN
8552: l_bo_return_status := FND_API.G_RET_STS_ERROR;
8553: END;
8554: END IF;--end of department check
8555: END IF;--end of check for activity present
8556:

Line 8598: l_return_status := FND_API.G_RET_STS_ERROR;

8594: , p_token_tbl => l_token_tbl
8595: );
8596: l_mesg_token_tbl := l_out_mesg_token_tbl;
8597:
8598: l_return_status := FND_API.G_RET_STS_ERROR;
8599:
8600: l_out_eam_wo_rec := l_eam_wo_rec;
8601: l_out_eam_op_tbl := l_eam_op_tbl;
8602: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 8620: , p_error_status => FND_API.G_RET_STS_ERROR

8616: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8617: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8618: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8619: , p_mesg_token_tbl => l_mesg_token_tbl
8620: , p_error_status => FND_API.G_RET_STS_ERROR
8621: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8622: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8623: , p_other_message => l_other_message
8624: , p_other_token_tbl => l_other_token_tbl

Line 8674: l_return_status := FND_API.G_RET_STS_ERROR;

8670: , p_token_tbl => l_token_tbl
8671: );
8672: l_mesg_token_tbl := l_out_mesg_token_tbl;
8673:
8674: l_return_status := FND_API.G_RET_STS_ERROR;
8675:
8676: l_out_eam_wo_rec := l_eam_wo_rec;
8677: l_out_eam_op_tbl := l_eam_op_tbl;
8678: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 8696: , p_error_status => FND_API.G_RET_STS_ERROR

8692: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8693: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8694: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8695: , p_mesg_token_tbl => l_mesg_token_tbl
8696: , p_error_status => FND_API.G_RET_STS_ERROR
8697: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8698: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8699: , p_other_message => l_other_message
8700: , p_other_token_tbl => l_other_token_tbl

Line 8790: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

8786: *********************************************************************/
8787:
8788: PROCEDURE PROCESS_WO
8789: ( p_api_version_number IN NUMBER := 1.0
8790: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
8791: , x_return_status OUT NOCOPY VARCHAR2
8792: , x_msg_count OUT NOCOPY NUMBER
8793: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
8794: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type

Line 8926: x_return_status := FND_API.G_RET_STS_SUCCESS;

8922:
8923: -- Business Object Starts with a status of Success
8924:
8925: l_eam_return_status := 'S';
8926: x_return_status := FND_API.G_RET_STS_SUCCESS;
8927:
8928:
8929: -- baroy - query the old row for use in scheduling decisions later on
8930: -- in this procedure.

Line 9220: p_init_msg_list => FND_API.G_FALSE,

9216:
9217: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates
9218: (
9219: p_api_version => 1.0,
9220: p_init_msg_list => FND_API.G_FALSE,
9221: p_commit => FND_API.G_FALSE,
9222: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9223:
9224: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,

Line 9221: p_commit => FND_API.G_FALSE,

9217: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates
9218: (
9219: p_api_version => 1.0,
9220: p_init_msg_list => FND_API.G_FALSE,
9221: p_commit => FND_API.G_FALSE,
9222: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9223:
9224: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9225:

Line 9222: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9218: (
9219: p_api_version => 1.0,
9220: p_init_msg_list => FND_API.G_FALSE,
9221: p_commit => FND_API.G_FALSE,
9222: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9223:
9224: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9225:
9226: x_return_status => l_return_status,

Line 9242: , p_commit => FND_API.G_FALSE

9238: --Added parameter p_woru_modified to the procedure. This is done to ensure that dates are changed correctly from summary tab in Create Update WO page
9239:
9240: EAM_SCHED_BOTTOM_UP_PVT.schedule_bottom_up_pvt (
9241: p_api_version_number => 1.0
9242: , p_commit => FND_API.G_FALSE
9243: , p_wip_entity_id => l_eam_wo_rec.wip_entity_id
9244: , p_org_id => l_eam_wo_rec.organization_id
9245: , p_woru_modified => l_woru_modified
9246: , x_return_status => l_return_status

Line 9263: -- l_return_status := FND_API.G_RET_STS_ERROR;

9259: , p_token_tbl => l_token_tbl
9260: );
9261: l_mesg_token_tbl := l_out_mesg_token_tbl;
9262:
9263: -- l_return_status := FND_API.G_RET_STS_ERROR;
9264:
9265: l_out_eam_wo_rec := l_eam_wo_rec;
9266: l_out_eam_op_tbl := l_eam_op_tbl;
9267: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9285: , p_error_status => FND_API.G_RET_STS_ERROR

9281: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9282: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9283: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9284: , p_mesg_token_tbl => l_mesg_token_tbl
9285: , p_error_status => FND_API.G_RET_STS_ERROR
9286: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9287: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9288: , p_other_message => l_other_message
9289: , p_other_token_tbl => l_other_token_tbl

Line 9369: p_init_msg_list => FND_API.G_FALSE,

9365:
9366: EAM_OP_VALIDATE_PVT.Check_Operation_Netwrok_Dates
9367: (
9368: p_api_version => 1.0,
9369: p_init_msg_list => FND_API.G_FALSE,
9370: p_commit => FND_API.G_FALSE,
9371: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9372: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9373: x_return_status => l_return_status,

Line 9370: p_commit => FND_API.G_FALSE,

9366: EAM_OP_VALIDATE_PVT.Check_Operation_Netwrok_Dates
9367: (
9368: p_api_version => 1.0,
9369: p_init_msg_list => FND_API.G_FALSE,
9370: p_commit => FND_API.G_FALSE,
9371: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9372: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9373: x_return_status => l_return_status,
9374: x_pri_operation_no => l_prior_op_no,

Line 9371: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9367: (
9368: p_api_version => 1.0,
9369: p_init_msg_list => FND_API.G_FALSE,
9370: p_commit => FND_API.G_FALSE,
9371: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9372: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9373: x_return_status => l_return_status,
9374: x_pri_operation_no => l_prior_op_no,
9375: x_next_operation_no => l_next_op_no

Line 9401: p_init_msg_list => FND_API.G_FALSE,

9397:
9398: EAM_WO_NETWORK_DEFAULT_PVT.Check_Resource_Dates
9399: (
9400: p_api_version => 1.0,
9401: p_init_msg_list => FND_API.G_FALSE,
9402: p_commit => FND_API.G_FALSE,
9403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9404:
9405: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,

Line 9402: p_commit => FND_API.G_FALSE,

9398: EAM_WO_NETWORK_DEFAULT_PVT.Check_Resource_Dates
9399: (
9400: p_api_version => 1.0,
9401: p_init_msg_list => FND_API.G_FALSE,
9402: p_commit => FND_API.G_FALSE,
9403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9404:
9405: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9406:

Line 9403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9399: (
9400: p_api_version => 1.0,
9401: p_init_msg_list => FND_API.G_FALSE,
9402: p_commit => FND_API.G_FALSE,
9403: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9404:
9405: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9406:
9407: x_return_status => l_return_status,

Line 9426: p_init_msg_list => FND_API.G_FALSE,

9422: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling Check_Wo_Negative_Dates procedure ... ') ; END IF ;
9423: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Negative_Dates
9424: (
9425: p_api_version => 1.0,
9426: p_init_msg_list => FND_API.G_FALSE,
9427: p_commit => FND_API.G_FALSE,
9428: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9429: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9430: p_organization_id => l_eam_wo_rec.organization_id,

Line 9427: p_commit => FND_API.G_FALSE,

9423: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Negative_Dates
9424: (
9425: p_api_version => 1.0,
9426: p_init_msg_list => FND_API.G_FALSE,
9427: p_commit => FND_API.G_FALSE,
9428: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9429: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9430: p_organization_id => l_eam_wo_rec.organization_id,
9431: x_return_status => l_return_status,

Line 9428: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9424: (
9425: p_api_version => 1.0,
9426: p_init_msg_list => FND_API.G_FALSE,
9427: p_commit => FND_API.G_FALSE,
9428: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9429: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9430: p_organization_id => l_eam_wo_rec.organization_id,
9431: x_return_status => l_return_status,
9432: x_msg_count => l_msg_count,

Line 9454: p_init_msg_list => FND_API.G_FALSE,

9450:
9451: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
9452: (
9453: p_api_version => 1.0,
9454: p_init_msg_list => FND_API.G_FALSE,
9455: p_commit => FND_API.G_FALSE,
9456: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9457:
9458: p_work_object_id => l_eam_wo_rec.wip_entity_id,

Line 9455: p_commit => FND_API.G_FALSE,

9451: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
9452: (
9453: p_api_version => 1.0,
9454: p_init_msg_list => FND_API.G_FALSE,
9455: p_commit => FND_API.G_FALSE,
9456: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9457:
9458: p_work_object_id => l_eam_wo_rec.wip_entity_id,
9459: p_work_object_type_id => 1,

Line 9456: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9452: (
9453: p_api_version => 1.0,
9454: p_init_msg_list => FND_API.G_FALSE,
9455: p_commit => FND_API.G_FALSE,
9456: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9457:
9458: p_work_object_id => l_eam_wo_rec.wip_entity_id,
9459: p_work_object_type_id => 1,
9460: p_exception_logging => 'Y',

Line 9617: p_init_msg_list => fnd_api.g_false,

9613: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Calling material Allocation procedure at wo release/cancel ... ') ; END IF ;
9614:
9615: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
9616: p_api_version => 1.0,
9617: p_init_msg_list => fnd_api.g_false,
9618: p_commit => fnd_api.g_false,
9619: p_validation_level => fnd_api.g_valid_level_full,
9620: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9621: p_organization_id => l_eam_wo_rec.organization_id,

Line 9618: p_commit => fnd_api.g_false,

9614:
9615: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
9616: p_api_version => 1.0,
9617: p_init_msg_list => fnd_api.g_false,
9618: p_commit => fnd_api.g_false,
9619: p_validation_level => fnd_api.g_valid_level_full,
9620: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9621: p_organization_id => l_eam_wo_rec.organization_id,
9622: p_status_type => l_eam_wo_rec.status_type,

Line 9619: p_validation_level => fnd_api.g_valid_level_full,

9615: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
9616: p_api_version => 1.0,
9617: p_init_msg_list => fnd_api.g_false,
9618: p_commit => fnd_api.g_false,
9619: p_validation_level => fnd_api.g_valid_level_full,
9620: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9621: p_organization_id => l_eam_wo_rec.organization_id,
9622: p_status_type => l_eam_wo_rec.status_type,
9623: x_return_status => l_return_status,

Line 9647: p_init_msg_list => fnd_api.g_false,

9643:
9644: EAM_MATERIALISSUE_PVT.comp_alloc_chng_qty
9645: (
9646: p_api_version => 1.0,
9647: p_init_msg_list => fnd_api.g_false,
9648: p_commit => fnd_api.g_false,
9649: p_validation_level => fnd_api.g_valid_level_full,
9650: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9651: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,

Line 9648: p_commit => fnd_api.g_false,

9644: EAM_MATERIALISSUE_PVT.comp_alloc_chng_qty
9645: (
9646: p_api_version => 1.0,
9647: p_init_msg_list => fnd_api.g_false,
9648: p_commit => fnd_api.g_false,
9649: p_validation_level => fnd_api.g_valid_level_full,
9650: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9651: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,
9652: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,

Line 9649: p_validation_level => fnd_api.g_valid_level_full,

9645: (
9646: p_api_version => 1.0,
9647: p_init_msg_list => fnd_api.g_false,
9648: p_commit => fnd_api.g_false,
9649: p_validation_level => fnd_api.g_valid_level_full,
9650: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9651: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,
9652: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
9653: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,

Line 9670: p_init_msg_list => fnd_api.g_false,

9666: THEN
9667: EAM_MATERIALISSUE_PVT.cancel_alloc_matl_del
9668: (
9669: p_api_version => 1.0,
9670: p_init_msg_list => fnd_api.g_false,
9671: p_commit => fnd_api.g_false,
9672: p_validation_level => fnd_api.g_valid_level_full,
9673: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9674: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,

Line 9671: p_commit => fnd_api.g_false,

9667: EAM_MATERIALISSUE_PVT.cancel_alloc_matl_del
9668: (
9669: p_api_version => 1.0,
9670: p_init_msg_list => fnd_api.g_false,
9671: p_commit => fnd_api.g_false,
9672: p_validation_level => fnd_api.g_valid_level_full,
9673: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9674: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
9675: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,

Line 9672: p_validation_level => fnd_api.g_valid_level_full,

9668: (
9669: p_api_version => 1.0,
9670: p_init_msg_list => fnd_api.g_false,
9671: p_commit => fnd_api.g_false,
9672: p_validation_level => fnd_api.g_valid_level_full,
9673: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
9674: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
9675: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,
9676: p_wip_entity_type => WIP_CONSTANTS.EAM,

Line 9734: l_return_status := FND_API.G_RET_STS_ERROR;

9730: , p_token_tbl => l_token_tbl
9731: );
9732: l_mesg_token_tbl := l_out_mesg_token_tbl;
9733:
9734: l_return_status := FND_API.G_RET_STS_ERROR;
9735:
9736: l_out_eam_wo_rec := l_eam_wo_rec;
9737: l_out_eam_op_tbl := l_eam_op_tbl;
9738: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9756: , p_error_status => FND_API.G_RET_STS_ERROR

9752: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9753: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9754: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9755: , p_mesg_token_tbl => l_mesg_token_tbl
9756: , p_error_status => FND_API.G_RET_STS_ERROR
9757: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9758: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9759: , p_other_message => l_other_message
9760: , p_other_token_tbl => l_other_token_tbl

Line 9818: , p_error_status => FND_API.G_RET_STS_ERROR

9814: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9815: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9816: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9817: , p_mesg_token_tbl => l_mesg_token_tbl
9818: , p_error_status => FND_API.G_RET_STS_ERROR
9819: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9820: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9821: , p_other_message => l_other_message
9822: , p_other_token_tbl => l_other_token_tbl

Line 9873: l_return_status := FND_API.G_RET_STS_ERROR;

9869: , p_token_tbl => l_token_tbl
9870: );
9871: l_mesg_token_tbl := l_out_mesg_token_tbl;
9872:
9873: l_return_status := FND_API.G_RET_STS_ERROR;
9874:
9875: l_out_eam_wo_rec := l_eam_wo_rec;
9876: l_out_eam_op_tbl := l_eam_op_tbl;
9877: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9895: , p_error_status => FND_API.G_RET_STS_ERROR

9891: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9892: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9893: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9894: , p_mesg_token_tbl => l_mesg_token_tbl
9895: , p_error_status => FND_API.G_RET_STS_ERROR
9896: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9897: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9898: , p_other_message => l_other_message
9899: , p_other_token_tbl => l_other_token_tbl

Line 9949: l_return_status := FND_API.G_RET_STS_ERROR;

9945: , p_token_tbl => l_token_tbl
9946: );
9947: l_mesg_token_tbl := l_out_mesg_token_tbl;
9948:
9949: l_return_status := FND_API.G_RET_STS_ERROR;
9950:
9951: l_out_eam_wo_rec := l_eam_wo_rec;
9952: l_out_eam_op_tbl := l_eam_op_tbl;
9953: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9971: , p_error_status => FND_API.G_RET_STS_ERROR

9967: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9968: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9969: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9970: , p_mesg_token_tbl => l_mesg_token_tbl
9971: , p_error_status => FND_API.G_RET_STS_ERROR
9972: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9973: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9974: , p_other_message => l_other_message
9975: , p_other_token_tbl => l_other_token_tbl

Line 10026: l_return_status := FND_API.G_RET_STS_ERROR;

10022: , p_token_tbl => l_token_tbl
10023: );
10024: l_mesg_token_tbl := l_out_mesg_token_tbl;
10025:
10026: l_return_status := FND_API.G_RET_STS_ERROR;
10027:
10028: l_out_eam_wo_rec := l_eam_wo_rec;
10029: l_out_eam_op_tbl := l_eam_op_tbl;
10030: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10048: , p_error_status => FND_API.G_RET_STS_ERROR

10044: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10045: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10046: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10047: , p_mesg_token_tbl => l_mesg_token_tbl
10048: , p_error_status => FND_API.G_RET_STS_ERROR
10049: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10050: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10051: , p_other_message => l_other_message
10052: , p_other_token_tbl => l_other_token_tbl

Line 10103: l_return_status := FND_API.G_RET_STS_ERROR;

10099: , p_token_tbl => l_token_tbl
10100: );
10101: l_mesg_token_tbl := l_out_mesg_token_tbl;
10102:
10103: l_return_status := FND_API.G_RET_STS_ERROR;
10104:
10105: l_out_eam_wo_rec := l_eam_wo_rec;
10106: l_out_eam_op_tbl := l_eam_op_tbl;
10107: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10125: , p_error_status => FND_API.G_RET_STS_ERROR

10121: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10122: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10123: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10124: , p_mesg_token_tbl => l_mesg_token_tbl
10125: , p_error_status => FND_API.G_RET_STS_ERROR
10126: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10127: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10128: , p_other_message => l_other_message
10129: , p_other_token_tbl => l_other_token_tbl

Line 10187: l_return_status := FND_API.G_RET_STS_ERROR;

10183: , p_token_tbl => l_token_tbl
10184: );
10185: l_mesg_token_tbl := l_out_mesg_token_tbl;
10186:
10187: l_return_status := FND_API.G_RET_STS_ERROR;
10188:
10189: l_out_eam_wo_rec := l_eam_wo_rec;
10190: l_out_eam_op_tbl := l_eam_op_tbl;
10191: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10209: , p_error_status => FND_API.G_RET_STS_ERROR

10205: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10206: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10207: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10208: , p_mesg_token_tbl => l_mesg_token_tbl
10209: , p_error_status => FND_API.G_RET_STS_ERROR
10210: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10211: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10212: , p_other_message => l_other_message
10213: , p_other_token_tbl => l_other_token_tbl

Line 10270: l_return_status := FND_API.G_RET_STS_ERROR;

10266: , p_token_tbl => l_token_tbl
10267: );
10268: l_mesg_token_tbl := l_out_mesg_token_tbl;
10269:
10270: l_return_status := FND_API.G_RET_STS_ERROR;
10271:
10272: l_out_eam_wo_rec := l_eam_wo_rec;
10273: l_out_eam_op_tbl := l_eam_op_tbl;
10274: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10292: , p_error_status => FND_API.G_RET_STS_ERROR

10288: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10289: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10290: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10291: , p_mesg_token_tbl => l_mesg_token_tbl
10292: , p_error_status => FND_API.G_RET_STS_ERROR
10293: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10294: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10295: , p_other_message => l_other_message
10296: , p_other_token_tbl => l_other_token_tbl

Line 10346: l_return_status := FND_API.G_RET_STS_ERROR;

10342: , p_token_tbl => l_token_tbl
10343: );
10344: l_mesg_token_tbl := l_out_mesg_token_tbl;
10345:
10346: l_return_status := FND_API.G_RET_STS_ERROR;
10347:
10348: l_out_eam_wo_rec := l_eam_wo_rec;
10349: l_out_eam_op_tbl := l_eam_op_tbl;
10350: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10368: , p_error_status => FND_API.G_RET_STS_ERROR

10364: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10365: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10366: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10367: , p_mesg_token_tbl => l_mesg_token_tbl
10368: , p_error_status => FND_API.G_RET_STS_ERROR
10369: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10370: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10371: , p_other_message => l_other_message
10372: , p_other_token_tbl => l_other_token_tbl

Line 10419: l_return_status := FND_API.G_RET_STS_ERROR;

10415: , p_token_tbl => l_token_tbl
10416: );
10417: l_mesg_token_tbl := l_out_mesg_token_tbl;
10418:
10419: l_return_status := FND_API.G_RET_STS_ERROR;
10420:
10421: l_out_eam_wo_rec := l_eam_wo_rec;
10422: l_out_eam_op_tbl := l_eam_op_tbl;
10423: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10441: , p_error_status => FND_API.G_RET_STS_ERROR

10437: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10438: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10439: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10440: , p_mesg_token_tbl => l_mesg_token_tbl
10441: , p_error_status => FND_API.G_RET_STS_ERROR
10442: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10443: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10444: , p_other_message => l_other_message
10445: , p_other_token_tbl => l_other_token_tbl

Line 10535: , p_error_status => FND_API.G_RET_STS_ERROR

10531: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10532: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10533: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10534: , p_mesg_token_tbl => l_mesg_token_tbl
10535: , p_error_status => FND_API.G_RET_STS_ERROR
10536: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10537: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10538: , p_other_message => l_other_message
10539: , p_other_token_tbl => l_other_token_tbl

Line 10609: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

10605: x_valid_transaction := TRUE;
10606:
10607:
10608: IF (p_entity_name IN ('WORK_ORDER')
10609: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
10610: )
10611: OR
10612: (p_entity_name IN ('OPERATION','OPERATION_RESOURCE','RESOURCE_INSTANCE','SUB_RESOURCE','DIRECT_ITEMS','MATERIAL_REQUIREMENTS')
10613: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

Line 10613: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

10609: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
10610: )
10611: OR
10612: (p_entity_name IN ('OPERATION','OPERATION_RESOURCE','RESOURCE_INSTANCE','SUB_RESOURCE','DIRECT_ITEMS','MATERIAL_REQUIREMENTS')
10613: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
10614: )
10615: OR
10616: (p_entity_name IN ('OPERATION_NETWORK', 'RESOURCE_USAGE')
10617: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

Line 10617: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)

10613: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_SYNC, EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
10614: )
10615: OR
10616: (p_entity_name IN ('OPERATION_NETWORK', 'RESOURCE_USAGE')
10617: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
10618: )
10619: OR
10620: (p_entity_name IN ('WORK_ORDER_COMPLETEION','OPERATION_COMPLETEION')
10621: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_COMPLETE, EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)

Line 10621: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_COMPLETE, EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)

10617: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_DELETE)
10618: )
10619: OR
10620: (p_entity_name IN ('WORK_ORDER_COMPLETEION','OPERATION_COMPLETEION')
10621: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_COMPLETE, EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)
10622: )
10623: OR
10624: (p_entity_name IN ('QUALITY_ENTRY','METER_READING')
10625: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)

Line 10625: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)

10621: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_COMPLETE, EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE)
10622: )
10623: OR
10624: (p_entity_name IN ('QUALITY_ENTRY','METER_READING')
10625: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)
10626: )
10627: OR
10628: (p_entity_name IN ('WORK_ORDER_COMPL_REBUILD','W_ORDER_COMPL_METER_READING')
10629: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

Line 10629: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

10625: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)
10626: )
10627: OR
10628: (p_entity_name IN ('WORK_ORDER_COMPL_REBUILD','W_ORDER_COMPL_METER_READING')
10629: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
10630: )
10631: OR
10632: (p_entity_name IN ('WORK_SERVICE_REQUEST')
10633: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE,EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

Line 10633: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE,EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

10629: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
10630: )
10631: OR
10632: (p_entity_name IN ('WORK_SERVICE_REQUEST')
10633: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE,EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
10634: )
10635:
10636: THEN
10637:

Line 11115: x_return_status := FND_API.G_RET_STS_SUCCESS;

11111:
11112: l_eam_failure_entry_record := p_eam_wo_comp_rec.eam_failure_entry_record;
11113: l_eam_failure_codes_tbl := p_eam_wo_comp_rec.eam_failure_codes_tbl;
11114:
11115: x_return_status := FND_API.G_RET_STS_SUCCESS;
11116: l_eam_wo_comp_rec := p_eam_wo_comp_rec;
11117:
11118: SELECT wip_entity_name INTO l_wip_entity_name
11119: FROM wip_entities

Line 11492: , p_error_status => FND_API.G_RET_STS_ERROR

11488: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
11489: , x_eam_request_tbl => l_out_eam_request_tbl
11490:
11491: , p_mesg_token_tbl => l_mesg_token_tbl
11492: , p_error_status => FND_API.G_RET_STS_ERROR
11493: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
11494: , p_other_message => l_other_message
11495: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
11496: , p_other_token_tbl => l_other_token_tbl

Line 11556: , p_error_status => FND_API.G_RET_STS_ERROR

11552: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
11553: , x_eam_request_tbl => l_out_eam_request_tbl
11554:
11555: , p_mesg_token_tbl => l_mesg_token_tbl
11556: , p_error_status => FND_API.G_RET_STS_ERROR
11557: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
11558: , p_other_message => l_other_message
11559: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
11560: , p_other_token_tbl => l_other_token_tbl

Line 11612: l_return_status := FND_API.G_RET_STS_ERROR;

11608: l_other_message := 'EAM_WOCMPL_MAND_PLAN';
11609: l_other_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
11610: l_other_token_tbl(1).token_value := l_wip_entity_name;
11611:
11612: l_return_status := FND_API.G_RET_STS_ERROR;
11613:
11614: RAISE EXC_SEV_QUIT_RECORD;
11615:
11616: /* l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 11628: x_return_status := FND_API.G_RET_STS_ERROR;

11624: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11625: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
11626: );
11627:
11628: x_return_status := FND_API.G_RET_STS_ERROR;
11629:
11630: raise EXC_SEV_QUIT_RECORD; */
11631:
11632: END IF;

Line 11745: errMsg := Fnd_Msg_Pub.Get(1,Fnd_Api.G_FALSE);

11741: );
11742:
11743: /* IF l_return_status <> 'S' THEN
11744: errCode := 1;
11745: errMsg := Fnd_Msg_Pub.Get(1,Fnd_Api.G_FALSE);
11746: return;
11747: END IF; */
11748: IF NVL(l_return_status, 'T') <> 'S' THEN
11749: l_return_status := 'E';

Line 11787: x_return_status := FND_API.G_RET_STS_ERROR;

11783: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11784: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
11785: );
11786:
11787: x_return_status := FND_API.G_RET_STS_ERROR;
11788:
11789: RAISE EXC_SEV_QUIT_RECORD;
11790: END ;
11791:

Line 11815: x_return_status := FND_API.G_RET_STS_ERROR;

11811: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
11812: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
11813: );
11814:
11815: x_return_status := FND_API.G_RET_STS_ERROR;
11816:
11817: RAISE EXC_SEV_QUIT_RECORD;
11818: END IF;
11819:

Line 12180: , p_error_status => FND_API.G_RET_STS_ERROR

12176: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12177: , x_eam_request_tbl => l_out_eam_request_tbl
12178:
12179: , p_mesg_token_tbl => l_mesg_token_tbl
12180: , p_error_status => FND_API.G_RET_STS_ERROR
12181: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12182: , p_other_message => l_other_message
12183: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12184: , p_other_token_tbl => l_other_token_tbl

Line 12294: x_return_status := FND_API.G_RET_STS_SUCCESS;

12290: BEGIN
12291:
12292: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion procedure begin '); END IF;
12293:
12294: x_return_status := FND_API.G_RET_STS_SUCCESS;
12295: l_return_status := FND_API.G_RET_STS_SUCCESS;
12296:
12297: l_eam_wo_quality_tbl := p_eam_wo_quality_tbl;
12298: l_eam_op_comp_rec := p_eam_op_compl_tbl(p_eam_op_compl_tbl.FIRST);

Line 12295: l_return_status := FND_API.G_RET_STS_SUCCESS;

12291:
12292: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion procedure begin '); END IF;
12293:
12294: x_return_status := FND_API.G_RET_STS_SUCCESS;
12295: l_return_status := FND_API.G_RET_STS_SUCCESS;
12296:
12297: l_eam_wo_quality_tbl := p_eam_wo_quality_tbl;
12298: l_eam_op_comp_rec := p_eam_op_compl_tbl(p_eam_op_compl_tbl.FIRST);
12299: l_org_id := l_eam_op_comp_rec.organization_id;

Line 12508: x_return_status:=FND_API.G_RET_STS_ERROR;

12504: );
12505:
12506:
12507: IF l_return_status <> 'S' THEN
12508: x_return_status:=FND_API.G_RET_STS_ERROR;
12509: l_other_message := 'EAM_OP_QUAINSERT_CSEV_SKIP';
12510: l_other_token_tbl(1).token_name := 'OP_SEQ';
12511: l_other_token_tbl(1).token_value := l_eam_wo_quality_rec.operation_seq_number;
12512: RAISE EXC_SEV_QUIT_RECORD;

Line 12553: x_return_status := FND_API.G_RET_STS_ERROR;

12549: l_other_message := 'EAM_OPCMPL_MAND_PLAN';
12550: l_other_token_tbl(1).token_name := 'OP_SEQ';
12551: l_other_token_tbl(1).token_value := l_eam_op_comp_rec.operation_seq_num;
12552:
12553: x_return_status := FND_API.G_RET_STS_ERROR;
12554:
12555: raise EXC_SEV_QUIT_RECORD;
12556: END IF;
12557: END;

Line 12588: x_return_status := FND_API.G_RET_STS_ERROR;

12584: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
12585: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
12586: );
12587:
12588: x_return_status := FND_API.G_RET_STS_ERROR;
12589:
12590: raise EXC_SEV_QUIT_RECORD;
12591: END ;
12592:

Line 12616: x_return_status := FND_API.G_RET_STS_ERROR;

12612: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
12613: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
12614: );
12615:
12616: x_return_status := FND_API.G_RET_STS_ERROR;
12617:
12618: raise EXC_SEV_QUIT_RECORD;
12619: END IF;
12620:

Line 12704: , p_error_status => FND_API.G_RET_STS_ERROR

12700: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12701: , x_eam_request_tbl => l_out_eam_request_tbl
12702:
12703: , p_mesg_token_tbl => l_mesg_token_tbl
12704: , p_error_status => FND_API.G_RET_STS_ERROR
12705: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12706: , p_other_message => l_other_message
12707: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12708: , p_other_token_tbl => l_other_token_tbl

Line 12715: x_return_status := FND_API.G_RET_STS_ERROR;

12711: );
12712:
12713: l_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
12714:
12715: x_return_status := FND_API.G_RET_STS_ERROR;
12716: x_msg_count := l_msg_count;
12717:
12718: RETURN;
12719: END ; -- End for op count > 0

Line 12773: x_return_status := FND_API.G_RET_STS_SUCCESS;

12769: BEGIN
12770:
12771: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request Service Request association procedure begin '); END IF;
12772:
12773: x_return_status := FND_API.G_RET_STS_SUCCESS;
12774: l_return_status := FND_API.G_RET_STS_SUCCESS;
12775:
12776: l_eam_request_tbl := p_eam_request_tbl;
12777:

Line 12774: l_return_status := FND_API.G_RET_STS_SUCCESS;

12770:
12771: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request Service Request association procedure begin '); END IF;
12772:
12773: x_return_status := FND_API.G_RET_STS_SUCCESS;
12774: l_return_status := FND_API.G_RET_STS_SUCCESS;
12775:
12776: l_eam_request_tbl := p_eam_request_tbl;
12777:
12778: l_eam_request_rec := p_eam_request_tbl(p_eam_request_tbl.FIRST);

Line 12885: x_eam_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;

12881: l_other_token_tbl(1).token_value := l_eam_request_rec.request_id;
12882: RAISE EXC_SEV_QUIT_RECORD;
12883: END IF;
12884:
12885: x_eam_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;
12886: END;
12887: END LOOP;
12888:
12889: EXCEPTION

Line 12909: , p_error_status => FND_API.G_RET_STS_ERROR

12905: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12906: , x_eam_request_tbl => l_out_eam_request_tbl
12907:
12908: , p_mesg_token_tbl => l_mesg_token_tbl
12909: , p_error_status => FND_API.G_RET_STS_ERROR
12910: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12911: , p_other_message => l_other_message
12912: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12913: , p_other_token_tbl => l_other_token_tbl