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 335: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 498: x_return_status := FND_API.G_RET_STS_SUCCESS;

494: BEGIN
495:
496: 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_PVT.RESOURCE_USAGES : Start=== '||p_eam_res_usage_tbl.COUNT ||' records passed =======================') ; END IF ;
497:
498: x_return_status := FND_API.G_RET_STS_SUCCESS;
499:
500: -- Init local table variables.
501: l_return_status := 'S' ;
502: l_bo_return_status := 'S' ;

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

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

Line 552: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1050: x_return_status := FND_API.G_RET_STS_SUCCESS;

1046: BEGIN
1047:
1048: 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_PVT.SUB_RESOURCES : Start=== '||p_eam_sub_res_tbl.COUNT ||' records passed =======================') ; END IF ;
1049:
1050: x_return_status := FND_API.G_RET_STS_SUCCESS;
1051:
1052: -- Init local table variables.
1053: l_return_status := 'S' ;
1054: l_bo_return_status := 'S' ;

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

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

Line 1103: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1760: x_return_status := FND_API.G_RET_STS_SUCCESS;

1756: BEGIN
1757:
1758: 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_PVT.RESOURCE_INSTANCES : Start=== '||p_eam_res_inst_tbl.COUNT ||' records passed ================') ; END IF ;
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761:
1762: IF x_bottomup_scheduled = G_NON_FIRM_WORKORDER THEN
1763: x_schedule_wo := G_SCHEDULE_WO;
1764: END IF;

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

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

Line 1817: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 2435: x_return_status := FND_API.G_RET_STS_SUCCESS;

2431: BEGIN
2432:
2433: 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_PVT.OPERATION_NETWORKS : Start=== '||p_eam_op_network_tbl.COUNT ||' records passed =======================') ; END IF ;
2434:
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;
2436:
2437: -- Init local table variables.
2438: l_return_status := 'S' ;
2439: l_bo_return_status := 'S' ;

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

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

Line 2483: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 3080: x_return_status := FND_API.G_RET_STS_SUCCESS;

3076:
3077: BEGIN
3078: 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_PVT.MATERIAL_REQUIREMENTS : Start ====='||p_eam_mat_req_tbl.COUNT ||' records passed'||' ========') ; END IF ;
3079:
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;
3081:
3082: -- Init local table variables.
3083: l_return_status := 'S' ;
3084: l_bo_return_status := 'S' ;

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

3150:
3151:
3152: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
3153:
3154: IF (l_eam_mat_req_rec.return_status IS NULL OR l_eam_mat_req_rec.return_status = FND_API.G_MISS_CHAR)
3155: AND
3156: (NOT l_parent_exists
3157: OR
3158: (l_parent_exists AND

Line 3170: l_return_status := FND_API.G_RET_STS_SUCCESS;

3166: THEN
3167:
3168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
3169:
3170: l_return_status := FND_API.G_RET_STS_SUCCESS;
3171: l_eam_mat_req_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3172:
3173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
3174:

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

3167:
3168: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
3169:
3170: l_return_status := FND_API.G_RET_STS_SUCCESS;
3171: l_eam_mat_req_rec.return_status := FND_API.G_RET_STS_SUCCESS;
3172:
3173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
3174:
3175: VALIDATE_TRANSACTION_TYPE

Line 3475: p_init_msg_list => fnd_api.g_false,

3471: IF(l_eam_mat_req_rec.requested_quantity IS NOT NULL) THEN
3472:
3473: EAM_MATERIAL_REQUEST_PVT.allocate
3474: (p_api_version => 1.0,
3475: p_init_msg_list => fnd_api.g_false,
3476: p_commit => fnd_api.g_false,
3477: p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id,
3478: p_organization_id => l_eam_mat_req_rec.organization_id,
3479: p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num,

Line 3476: p_commit => fnd_api.g_false,

3472:
3473: EAM_MATERIAL_REQUEST_PVT.allocate
3474: (p_api_version => 1.0,
3475: p_init_msg_list => fnd_api.g_false,
3476: p_commit => fnd_api.g_false,
3477: p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id,
3478: p_organization_id => l_eam_mat_req_rec.organization_id,
3479: p_operation_seq_num => l_eam_mat_req_rec.operation_seq_num,
3480: p_inventory_item_id => l_eam_mat_req_rec.inventory_item_id,

Line 3543: ,p_init_msg_list => FND_API.G_FALSE

3539:
3540:
3541: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3542: ( p_api_version => 1.0
3543: ,p_init_msg_list => FND_API.G_FALSE
3544: ,p_commit => FND_API.G_FALSE
3545: ,p_validate_only => FND_API.G_TRUE
3546: ,x_return_status => l_api_return_status
3547: ,x_msg_count => l_api_msg_count

Line 3544: ,p_commit => FND_API.G_FALSE

3540:
3541: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3542: ( p_api_version => 1.0
3543: ,p_init_msg_list => FND_API.G_FALSE
3544: ,p_commit => FND_API.G_FALSE
3545: ,p_validate_only => FND_API.G_TRUE
3546: ,x_return_status => l_api_return_status
3547: ,x_msg_count => l_api_msg_count
3548: ,x_msg_data => l_api_msg_data

Line 3545: ,p_validate_only => FND_API.G_TRUE

3541: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3542: ( p_api_version => 1.0
3543: ,p_init_msg_list => FND_API.G_FALSE
3544: ,p_commit => FND_API.G_FALSE
3545: ,p_validate_only => FND_API.G_TRUE
3546: ,x_return_status => l_api_return_status
3547: ,x_msg_count => l_api_msg_count
3548: ,x_msg_data => l_api_msg_data
3549: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id

Line 3728: ,p_init_msg_list => FND_API.G_FALSE

3724: END IF;
3725:
3726: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3727: ( p_api_version => 1.0
3728: ,p_init_msg_list => FND_API.G_FALSE
3729: ,p_commit => FND_API.G_FALSE
3730: ,p_validate_only => FND_API.G_TRUE
3731: ,x_return_status => l_api_return_status
3732: ,x_msg_count => l_api_msg_count

Line 3729: ,p_commit => FND_API.G_FALSE

3725:
3726: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3727: ( p_api_version => 1.0
3728: ,p_init_msg_list => FND_API.G_FALSE
3729: ,p_commit => FND_API.G_FALSE
3730: ,p_validate_only => FND_API.G_TRUE
3731: ,x_return_status => l_api_return_status
3732: ,x_msg_count => l_api_msg_count
3733: ,x_msg_data => l_api_msg_data

Line 3730: ,p_validate_only => FND_API.G_TRUE

3726: EAM_PROCESS_WO_UTIL_PVT.create_requisition
3727: ( p_api_version => 1.0
3728: ,p_init_msg_list => FND_API.G_FALSE
3729: ,p_commit => FND_API.G_FALSE
3730: ,p_validate_only => FND_API.G_TRUE
3731: ,x_return_status => l_api_return_status
3732: ,x_msg_count => l_api_msg_count
3733: ,x_msg_data => l_api_msg_data
3734: ,p_wip_entity_id => l_eam_mat_req_rec.wip_entity_id

Line 4101: x_return_status := FND_API.G_RET_STS_SUCCESS;

4097:
4098: 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_PVT.DIRECT_ITEMS : Start=== '||p_eam_direct_items_tbl.COUNT ||' records passed =======================') ; END IF ;
4099:
4100:
4101: x_return_status := FND_API.G_RET_STS_SUCCESS;
4102:
4103: -- Init local table variables.
4104: l_return_status := 'S' ;
4105: l_bo_return_status := 'S' ;

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

4169:
4170:
4171: -- Check if record has not yet been processed and that it is the child of the parent that called this procedure
4172:
4173: IF (l_eam_direct_items_rec.return_status IS NULL OR l_eam_direct_items_rec.return_status = FND_API.G_MISS_CHAR)
4174: AND
4175: (NOT l_parent_exists
4176: OR
4177: (l_parent_exists AND

Line 4189: l_return_status := FND_API.G_RET_STS_SUCCESS;

4185: THEN
4186:
4187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4188:
4189: l_return_status := FND_API.G_RET_STS_SUCCESS;
4190: l_eam_direct_items_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4191:
4192: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
4193:

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

4186:
4187: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
4188:
4189: l_return_status := FND_API.G_RET_STS_SUCCESS;
4190: l_eam_direct_items_rec.return_status := FND_API.G_RET_STS_SUCCESS;
4191:
4192: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Transaction Type') ; END IF ;
4193:
4194: VALIDATE_TRANSACTION_TYPE

Line 4466: ,p_init_msg_list => FND_API.G_FALSE

4462: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('create requisitions for description direct items'); END IF;
4463:
4464: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4465: ( p_api_version => 1.0
4466: ,p_init_msg_list => FND_API.G_FALSE
4467: ,p_commit => FND_API.G_FALSE
4468: ,p_validate_only => FND_API.G_TRUE
4469: ,x_return_status => l_api_return_status
4470: ,x_msg_count => l_api_msg_count

Line 4467: ,p_commit => FND_API.G_FALSE

4463:
4464: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4465: ( p_api_version => 1.0
4466: ,p_init_msg_list => FND_API.G_FALSE
4467: ,p_commit => FND_API.G_FALSE
4468: ,p_validate_only => FND_API.G_TRUE
4469: ,x_return_status => l_api_return_status
4470: ,x_msg_count => l_api_msg_count
4471: ,x_msg_data => l_api_msg_data

Line 4468: ,p_validate_only => FND_API.G_TRUE

4464: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4465: ( p_api_version => 1.0
4466: ,p_init_msg_list => FND_API.G_FALSE
4467: ,p_commit => FND_API.G_FALSE
4468: ,p_validate_only => FND_API.G_TRUE
4469: ,x_return_status => l_api_return_status
4470: ,x_msg_count => l_api_msg_count
4471: ,x_msg_data => l_api_msg_data
4472: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id

Line 4636: ,p_init_msg_list => FND_API.G_FALSE

4632: END IF;
4633:
4634: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4635: ( p_api_version => 1.0
4636: ,p_init_msg_list => FND_API.G_FALSE
4637: ,p_commit => FND_API.G_FALSE
4638: ,p_validate_only => FND_API.G_TRUE
4639: ,x_return_status => l_api_return_status
4640: ,x_msg_count => l_api_msg_count

Line 4637: ,p_commit => FND_API.G_FALSE

4633:
4634: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4635: ( p_api_version => 1.0
4636: ,p_init_msg_list => FND_API.G_FALSE
4637: ,p_commit => FND_API.G_FALSE
4638: ,p_validate_only => FND_API.G_TRUE
4639: ,x_return_status => l_api_return_status
4640: ,x_msg_count => l_api_msg_count
4641: ,x_msg_data => l_api_msg_data

Line 4638: ,p_validate_only => FND_API.G_TRUE

4634: EAM_PROCESS_WO_UTIL_PVT.create_requisition
4635: ( p_api_version => 1.0
4636: ,p_init_msg_list => FND_API.G_FALSE
4637: ,p_commit => FND_API.G_FALSE
4638: ,p_validate_only => FND_API.G_TRUE
4639: ,x_return_status => l_api_return_status
4640: ,x_msg_count => l_api_msg_count
4641: ,x_msg_data => l_api_msg_data
4642: ,p_wip_entity_id => l_eam_direct_items_rec.wip_entity_id

Line 5001: x_return_status := FND_API.G_RET_STS_SUCCESS;

4997:
4998: 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_PVT.OPERATION_RESOURCES : Start=== '||p_eam_res_tbl.COUNT ||' records passed =======================') ; END IF ;
4999:
5000:
5001: x_return_status := FND_API.G_RET_STS_SUCCESS;
5002:
5003: -- Init local table variables.
5004: l_return_status := 'S' ;
5005: l_bo_return_status := 'S' ;

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

5031: THEN
5032: l_parent_exists := TRUE;
5033: END IF;
5034:
5035: IF (l_eam_res_rec.return_status IS NULL OR l_eam_res_rec.return_status = FND_API.G_MISS_CHAR)
5036: AND
5037: (NOT l_parent_exists
5038: OR
5039: (l_parent_exists AND

Line 5049: l_return_status := FND_API.G_RET_STS_SUCCESS;

5045: THEN
5046:
5047: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5048:
5049: l_return_status := FND_API.G_RET_STS_SUCCESS;
5050: l_eam_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5051:
5052: VALIDATE_TRANSACTION_TYPE
5053: ( p_transaction_type => l_eam_res_rec.transaction_type

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

5046:
5047: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5048:
5049: l_return_status := FND_API.G_RET_STS_SUCCESS;
5050: l_eam_res_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5051:
5052: VALIDATE_TRANSACTION_TYPE
5053: ( p_transaction_type => l_eam_res_rec.transaction_type
5054: , p_entity_name => 'OPERATION_RESOURCE'

Line 5819: x_return_status := FND_API.G_RET_STS_SUCCESS;

5815:
5816: 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_PVT.WO_OPERATIONS : Start=== '||p_eam_op_tbl.COUNT ||' records passed =======================') ; END IF ;
5817:
5818:
5819: x_return_status := FND_API.G_RET_STS_SUCCESS;
5820:
5821: -- Init local table variables.
5822: l_return_status := 'S' ;
5823: l_bo_return_status := 'S' ;

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

5851: THEN
5852: l_parent_exists := TRUE;
5853: END IF;
5854:
5855: IF (l_eam_op_rec.return_status IS NULL OR l_eam_op_rec.return_status = FND_API.G_MISS_CHAR)
5856: AND
5857: (NOT l_parent_exists
5858: OR
5859: (l_parent_exists AND

Line 5868: l_return_status := FND_API.G_RET_STS_SUCCESS;

5864: THEN
5865:
5866: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5867:
5868: l_return_status := FND_API.G_RET_STS_SUCCESS;
5869: l_eam_op_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5870:
5871: VALIDATE_TRANSACTION_TYPE
5872: ( p_transaction_type => l_eam_op_rec.transaction_type

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

5865:
5866: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
5867:
5868: l_return_status := FND_API.G_RET_STS_SUCCESS;
5869: l_eam_op_rec.return_status := FND_API.G_RET_STS_SUCCESS;
5870:
5871: VALIDATE_TRANSACTION_TYPE
5872: ( p_transaction_type => l_eam_op_rec.transaction_type
5873: , p_entity_name => 'OPERATION'

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

7020: l_other_token_tbl EAM_ERROR_MESSAGE_PVT.Token_Tbl_Type;
7021:
7022: l_error_text VARCHAR2(2000);
7023: l_valid_transaction BOOLEAN := TRUE;
7024: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7025: l_pick_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7026: l_msg_count NUMBER := 0;
7027:
7028: l_bo_return_status VARCHAR2(1) := 'S';

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

7021:
7022: l_error_text VARCHAR2(2000);
7023: l_valid_transaction BOOLEAN := TRUE;
7024: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7025: l_pick_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7026: l_msg_count NUMBER := 0;
7027:
7028: l_bo_return_status VARCHAR2(1) := 'S';
7029: l_return_value NUMBER;

Line 7067: x_return_status := FND_API.G_RET_STS_SUCCESS;

7063: l_already_estimated varchar2(1):='N';
7064:
7065: BEGIN
7066:
7067: x_return_status := FND_API.G_RET_STS_SUCCESS;
7068: l_wip_entity_id:=p_wip_entity_id;
7069:
7070: -- baroy - Skip the header validations if header is null
7071: -- If condition #101

Line 7094: l_eam_wo_rec.return_status <> FND_API.G_MISS_CHAR

7090:
7091: l_eam_wo_rec := p_eam_wo_rec;
7092:
7093: IF l_eam_wo_rec.return_status IS NOT NULL AND
7094: l_eam_wo_rec.return_status <> FND_API.G_MISS_CHAR
7095: THEN
7096: x_return_status := l_return_status;
7097: x_eam_wo_rec := l_eam_wo_rec;
7098: x_eam_op_tbl := l_eam_op_tbl;

Line 7109: l_return_status := FND_API.G_RET_STS_SUCCESS;

7105: x_eam_direct_items_tbl := l_eam_direct_items_tbl;
7106: RETURN;
7107: END IF;
7108:
7109: l_return_status := FND_API.G_RET_STS_SUCCESS;
7110: l_eam_wo_rec.return_status := FND_API.G_RET_STS_SUCCESS;
7111:
7112:
7113: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Work Order: Transaction Type Validity . . . '); END IF;

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

7106: RETURN;
7107: END IF;
7108:
7109: l_return_status := FND_API.G_RET_STS_SUCCESS;
7110: l_eam_wo_rec.return_status := FND_API.G_RET_STS_SUCCESS;
7111:
7112:
7113: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Work Order: Transaction Type Validity . . . '); END IF;
7114:

Line 7162: 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

7158: --Changes for IB
7159: --If this is a work order on a predefined rebuild, create an instance for it NOW
7160: --If this is a automatic rebuild work order and the serial number has just been provided, update NOW
7161:
7162: 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
7163: select msn.current_status
7164: into l_current_status
7165: from mtl_serial_numbers msn
7166: where inventory_item_id = nvl(l_eam_wo_rec.rebuild_item_id, l_eam_wo_rec.asset_group_id)

Line 7173: ,P_INIT_MSG_LIST => fnd_api.g_false

7169: IF (l_current_status = 1 OR l_eam_wo_rec.maintenance_object_type = 2) THEN
7170: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Calling EAM_COMMON_UTILITIES_PVT.CREATE_ASSET procedure . . .'); END IF;
7171: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
7172: P_API_VERSION => 1.0
7173: ,P_INIT_MSG_LIST => fnd_api.g_false
7174: ,P_COMMIT => fnd_api.g_false
7175: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
7176: ,X_EAM_WO_REC => l_eam_wo_rec
7177: ,X_RETURN_STATUS => l_return_status

Line 7174: ,P_COMMIT => fnd_api.g_false

7170: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Calling EAM_COMMON_UTILITIES_PVT.CREATE_ASSET procedure . . .'); END IF;
7171: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
7172: P_API_VERSION => 1.0
7173: ,P_INIT_MSG_LIST => fnd_api.g_false
7174: ,P_COMMIT => fnd_api.g_false
7175: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
7176: ,X_EAM_WO_REC => l_eam_wo_rec
7177: ,X_RETURN_STATUS => l_return_status
7178: ,X_MSG_COUNT => l_msg_count

Line 7175: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full

7171: EAM_COMMON_UTILITIES_PVT.CREATE_ASSET(
7172: P_API_VERSION => 1.0
7173: ,P_INIT_MSG_LIST => fnd_api.g_false
7174: ,P_COMMIT => fnd_api.g_false
7175: ,P_VALIDATION_LEVEL => fnd_api.g_valid_level_full
7176: ,X_EAM_WO_REC => l_eam_wo_rec
7177: ,X_RETURN_STATUS => l_return_status
7178: ,X_MSG_COUNT => l_msg_count
7179: ,X_MSG_DATA => l_error_text

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

7178: ,X_MSG_COUNT => l_msg_count
7179: ,X_MSG_DATA => l_error_text
7180: );
7181:
7182: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
7183: l_other_message := 'EAM_IB_INST_FAILED';
7184: l_other_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
7185: l_other_token_tbl(1).token_value := l_eam_wo_rec.wip_entity_name;
7186: RAISE EXC_UNEXP_SKIP_OBJECT;

Line 7211: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;

7207: AND meaa.asset_activity_id = p_eam_wo_rec.asset_activity_id
7208: AND meaa.maintenance_object_id = p_eam_wo_rec.maintenance_object_id;
7209:
7210: if(l_count_assetActAssoc = 0) then
7211: l_eam_wo_rec.asset_activity_id := FND_API.G_MISS_NUM;
7212: end if;
7213: end if;
7214:
7215: if(l_eam_wo_rec.owning_department IS NULL) THEN

Line 7216: l_eam_wo_rec.owning_department := FND_API.G_MISS_NUM;

7212: end if;
7213: end if;
7214:
7215: if(l_eam_wo_rec.owning_department IS NULL) THEN
7216: l_eam_wo_rec.owning_department := FND_API.G_MISS_NUM;
7217: end if;
7218:
7219: select estimation_status into l_estimation_staus
7220: from wip_discrete_jobs

Line 7228: p_init_msg_list => fnd_api.g_false,

7224: if(l_estimation_staus = 7) then
7225: l_already_estimated := 'Y';
7226: CSTPECEP.Estimate_WorkOrder_Grp(
7227: p_api_version => 1.0,
7228: p_init_msg_list => fnd_api.g_false,
7229: p_commit => fnd_api.g_false,
7230: p_validation_level => fnd_api.g_valid_level_full,
7231: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
7232: p_organization_id => l_eam_wo_rec.organization_id,

Line 7229: p_commit => fnd_api.g_false,

7225: l_already_estimated := 'Y';
7226: CSTPECEP.Estimate_WorkOrder_Grp(
7227: p_api_version => 1.0,
7228: p_init_msg_list => fnd_api.g_false,
7229: p_commit => fnd_api.g_false,
7230: p_validation_level => fnd_api.g_valid_level_full,
7231: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
7232: p_organization_id => l_eam_wo_rec.organization_id,
7233: x_return_status => l_return_status,

Line 7230: p_validation_level => fnd_api.g_valid_level_full,

7226: CSTPECEP.Estimate_WorkOrder_Grp(
7227: p_api_version => 1.0,
7228: p_init_msg_list => fnd_api.g_false,
7229: p_commit => fnd_api.g_false,
7230: p_validation_level => fnd_api.g_valid_level_full,
7231: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
7232: p_organization_id => l_eam_wo_rec.organization_id,
7233: x_return_status => l_return_status,
7234: x_msg_data => l_err_text,

Line 7245: p_init_msg_list => fnd_api.g_false,

7241: -- deleting earlier failure data if exists
7242:
7243: Eam_Process_Failure_Entry_PVT.Delete_Failure_Entry
7244: ( p_api_version => 1.0,
7245: p_init_msg_list => fnd_api.g_false,
7246: p_commit => fnd_api.g_false,
7247: p_source_id => l_eam_wo_rec.wip_entity_id,
7248: x_return_status => l_return_status,
7249: x_msg_count => l_msg_count,

Line 7246: p_commit => fnd_api.g_false,

7242:
7243: Eam_Process_Failure_Entry_PVT.Delete_Failure_Entry
7244: ( p_api_version => 1.0,
7245: p_init_msg_list => fnd_api.g_false,
7246: p_commit => fnd_api.g_false,
7247: p_source_id => l_eam_wo_rec.wip_entity_id,
7248: x_return_status => l_return_status,
7249: x_msg_count => l_msg_count,
7250: x_msg_data => l_err_text

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

7778: l_eam_wo_rec.pending_flag:='Y'; --if approval required set the pending flag and system status to previous status
7779: l_new_system_status := l_eam_wo_rec.status_type;
7780: l_eam_wo_rec.status_type := NVL(l_old_eam_wo_rec.status_type,17);
7781: /* Bug # 4597756 : revert back the firm_planned_flag */
7782: IF l_firm_planned_flag IS NULL OR l_firm_planned_flag = FND_API.G_MISS_NUM THEN
7783: l_eam_wo_rec.firm_planned_flag := 2;
7784: ELSE
7785: l_eam_wo_rec.firm_planned_flag := l_firm_planned_flag;
7786: END IF;

Line 7796: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)

7792:
7793: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('EAM_PROCESS_WO_PVT.WORK_ORDER : Writing the WO Record to database...') ; END IF;
7794:
7795: if ((l_eam_wo_rec.pm_suggested_start_date is null or
7796: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)
7797: and (l_eam_wo_rec.pm_suggested_end_date is null or
7798: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
7799: and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
7800: ) then

Line 7798: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)

7794:
7795: if ((l_eam_wo_rec.pm_suggested_start_date is null or
7796: l_eam_wo_rec.pm_suggested_start_date = FND_API.G_MISS_DATE)
7797: and (l_eam_wo_rec.pm_suggested_end_date is null or
7798: l_eam_wo_rec.pm_suggested_end_date = FND_API.G_MISS_DATE)
7799: and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
7800: ) then
7801: select pm_suggested_start_date, pm_suggested_end_date into
7802: l_eam_wo_rec.pm_suggested_start_date,

Line 7867: x_return_status := FND_API.G_RET_STS_SUCCESS;

7863: l_eam_sub_res_tbl := l_out_eam_sub_res_tbl;
7864: l_eam_mat_req_tbl := l_out_eam_mat_req_tbl;
7865: l_eam_direct_items_tbl := l_out_eam_direct_items_tbl;
7866: l_eam_res_usage_tbl := l_out_eam_res_usage_tbl;
7867: x_return_status := FND_API.G_RET_STS_SUCCESS;
7868:
7869: END IF;
7870:
7871: /* Bug # 4926626 : Disable hiearchy if automatic (replaced) rebuild WO is updated

Line 8000: , p_error_status => FND_API.G_RET_STS_ERROR

7996: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
7997: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
7998: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
7999: , p_mesg_token_tbl => l_mesg_token_tbl
8000: , p_error_status => FND_API.G_RET_STS_ERROR
8001: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8002: , p_error_level => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
8003: , x_eam_wo_rec => l_out_eam_wo_rec
8004: , x_eam_op_tbl => l_out_eam_op_tbl

Line 8059: , p_error_status => FND_API.G_RET_STS_ERROR

8055: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8056: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8057: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8058: , p_mesg_token_tbl => l_mesg_token_tbl
8059: , p_error_status => FND_API.G_RET_STS_ERROR
8060: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8061: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8062: , p_other_message => l_other_message
8063: , p_other_token_tbl => l_other_token_tbl

Line 8121: , p_error_status => FND_API.G_RET_STS_ERROR

8117: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8118: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8119: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8120: , p_mesg_token_tbl => l_mesg_token_tbl
8121: , p_error_status => FND_API.G_RET_STS_ERROR
8122: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8123: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8124: , p_other_message => l_other_message
8125: , p_other_token_tbl => l_other_token_tbl

Line 8184: , p_error_status => FND_API.G_RET_STS_ERROR

8180: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8181: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8182: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8183: , p_mesg_token_tbl => l_mesg_token_tbl
8184: , p_error_status => FND_API.G_RET_STS_ERROR
8185: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8186: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8187: , p_other_message => l_other_message
8188: , p_other_token_tbl => l_other_token_tbl

Line 8247: , p_error_status => FND_API.G_RET_STS_ERROR

8243: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
8244: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
8245: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
8246: , p_mesg_token_tbl => l_mesg_token_tbl
8247: , p_error_status => FND_API.G_RET_STS_ERROR
8248: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
8249: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
8250: , p_other_message => l_other_message
8251: , p_other_token_tbl => l_other_token_tbl

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

8864: )
8865: THEN
8866:
8867: IF(l_eam_wo_rec.date_released IS NULL OR
8868: l_eam_wo_rec.date_released = FND_API.G_MISS_DATE) THEN
8869:
8870: /*Bug#4425025 - set date_released to greatest of min open period start date
8871: *and scheduled start date if scheduled start date is in past*/
8872:

Line 8922: l_return_status := FND_API.G_RET_STS_ERROR;

8918: );
8919:
8920: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Status Change WO completed with status ' || l_return_status) ; END IF ;
8921: IF NVL(l_return_status, 'S') <> 'S' THEN
8922: l_return_status := FND_API.G_RET_STS_ERROR;
8923: RAISE G_ERR_STATUS_CHANGE;
8924:
8925: END IF;
8926:

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

8977:
8978: -- if activity is deleted then also scheduler should get call
8979: if (x_schedule_wo <> G_SCHEDULE_WO and l_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_UPDATE
8980: and l_old_eam_wo_rec.asset_activity_id is not null
8981: and (l_eam_wo_rec.asset_activity_id is null or l_eam_wo_rec.asset_activity_id = FND_API.G_MISS_NUM)) then
8982: x_schedule_wo := G_SCHEDULE_WO;
8983: end if;
8984:
8985:

Line 9087: p_init_msg_list => fnd_api.g_false,

9083: BEGIN
9084: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Calling the Estimate_Workorder_Grp procedure ...') ; END IF ;
9085: CSTPECEP.Estimate_WorkOrder_Grp(
9086: p_api_version => 1.0,
9087: p_init_msg_list => fnd_api.g_false,
9088: p_commit => fnd_api.g_false,
9089: p_validation_level => fnd_api.g_valid_level_full,
9090: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9091: p_organization_id => l_eam_wo_rec.organization_id,

Line 9088: p_commit => fnd_api.g_false,

9084: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.WORK_ORDER : Calling the Estimate_Workorder_Grp procedure ...') ; END IF ;
9085: CSTPECEP.Estimate_WorkOrder_Grp(
9086: p_api_version => 1.0,
9087: p_init_msg_list => fnd_api.g_false,
9088: p_commit => fnd_api.g_false,
9089: p_validation_level => fnd_api.g_valid_level_full,
9090: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9091: p_organization_id => l_eam_wo_rec.organization_id,
9092: x_return_status => l_return_status,

Line 9089: p_validation_level => fnd_api.g_valid_level_full,

9085: CSTPECEP.Estimate_WorkOrder_Grp(
9086: p_api_version => 1.0,
9087: p_init_msg_list => fnd_api.g_false,
9088: p_commit => fnd_api.g_false,
9089: p_validation_level => fnd_api.g_valid_level_full,
9090: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9091: p_organization_id => l_eam_wo_rec.organization_id,
9092: x_return_status => l_return_status,
9093: x_msg_data => l_err_text,

Line 9102: l_bo_return_status := FND_API.G_RET_STS_ERROR;

9098: l_bo_return_status := l_return_status;
9099: END IF;
9100: EXCEPTION
9101: WHEN OTHERS THEN
9102: l_bo_return_status := FND_API.G_RET_STS_ERROR;
9103: END;
9104: END IF;--end of department check
9105: END IF;--end of check for activity present
9106:

Line 9152: l_return_status := FND_API.G_RET_STS_ERROR;

9148: , p_token_tbl => l_token_tbl
9149: );
9150: l_mesg_token_tbl := l_out_mesg_token_tbl;
9151:
9152: l_return_status := FND_API.G_RET_STS_ERROR;
9153:
9154: l_out_eam_wo_rec := l_eam_wo_rec;
9155: l_out_eam_op_tbl := l_eam_op_tbl;
9156: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9174: , p_error_status => FND_API.G_RET_STS_ERROR

9170: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9171: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9172: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9173: , p_mesg_token_tbl => l_mesg_token_tbl
9174: , p_error_status => FND_API.G_RET_STS_ERROR
9175: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9176: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9177: , p_other_message => l_other_message
9178: , p_other_token_tbl => l_other_token_tbl

Line 9228: l_return_status := FND_API.G_RET_STS_ERROR;

9224: , p_token_tbl => l_token_tbl
9225: );
9226: l_mesg_token_tbl := l_out_mesg_token_tbl;
9227:
9228: l_return_status := FND_API.G_RET_STS_ERROR;
9229:
9230: l_out_eam_wo_rec := l_eam_wo_rec;
9231: l_out_eam_op_tbl := l_eam_op_tbl;
9232: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9250: , p_error_status => FND_API.G_RET_STS_ERROR

9246: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9247: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9248: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9249: , p_mesg_token_tbl => l_mesg_token_tbl
9250: , p_error_status => FND_API.G_RET_STS_ERROR
9251: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9252: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9253: , p_other_message => l_other_message
9254: , p_other_token_tbl => l_other_token_tbl

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

9340: *********************************************************************/
9341:
9342: PROCEDURE PROCESS_WO
9343: ( p_api_version_number IN NUMBER := 1.0
9344: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
9345: , x_return_status OUT NOCOPY VARCHAR2
9346: , x_msg_count OUT NOCOPY NUMBER
9347: , p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
9348: , p_eam_op_tbl IN EAM_PROCESS_WO_PUB.eam_op_tbl_type

Line 9488: x_return_status := FND_API.G_RET_STS_SUCCESS;

9484:
9485: -- Business Object Starts with a status of Success
9486:
9487: l_eam_return_status := 'S';
9488: x_return_status := FND_API.G_RET_STS_SUCCESS;
9489:
9490:
9491: -- baroy - query the old row for use in scheduling decisions later on
9492: -- in this procedure.

Line 9821: p_init_msg_list => FND_API.G_FALSE,

9817:
9818: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates
9819: (
9820: p_api_version => 1.0,
9821: p_init_msg_list => FND_API.G_FALSE,
9822: p_commit => FND_API.G_FALSE,
9823: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9824:
9825: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,

Line 9822: p_commit => FND_API.G_FALSE,

9818: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Dates
9819: (
9820: p_api_version => 1.0,
9821: p_init_msg_list => FND_API.G_FALSE,
9822: p_commit => FND_API.G_FALSE,
9823: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9824:
9825: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9826:

Line 9823: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9819: (
9820: p_api_version => 1.0,
9821: p_init_msg_list => FND_API.G_FALSE,
9822: p_commit => FND_API.G_FALSE,
9823: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9824:
9825: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9826:
9827: x_return_status => l_return_status,

Line 9843: , p_commit => FND_API.G_FALSE

9839: --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
9840:
9841: EAM_SCHED_BOTTOM_UP_PVT.schedule_bottom_up_pvt (
9842: p_api_version_number => 1.0
9843: , p_commit => FND_API.G_FALSE
9844: , p_wip_entity_id => l_eam_wo_rec.wip_entity_id
9845: , p_org_id => l_eam_wo_rec.organization_id
9846: , p_woru_modified => l_woru_modified
9847: , x_return_status => l_return_status

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

9860: , p_token_tbl => l_token_tbl
9861: );
9862: l_mesg_token_tbl := l_out_mesg_token_tbl;
9863:
9864: -- l_return_status := FND_API.G_RET_STS_ERROR;
9865:
9866: l_out_eam_wo_rec := l_eam_wo_rec;
9867: l_out_eam_op_tbl := l_eam_op_tbl;
9868: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 9886: , p_error_status => FND_API.G_RET_STS_ERROR

9882: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
9883: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
9884: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
9885: , p_mesg_token_tbl => l_mesg_token_tbl
9886: , p_error_status => FND_API.G_RET_STS_ERROR
9887: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
9888: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
9889: , p_other_message => l_other_message
9890: , p_other_token_tbl => l_other_token_tbl

Line 9970: p_init_msg_list => FND_API.G_FALSE,

9966:
9967: EAM_OP_VALIDATE_PVT.Check_Operation_Netwrok_Dates
9968: (
9969: p_api_version => 1.0,
9970: p_init_msg_list => FND_API.G_FALSE,
9971: p_commit => FND_API.G_FALSE,
9972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9973: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9974: x_return_status => l_return_status,

Line 9971: p_commit => FND_API.G_FALSE,

9967: EAM_OP_VALIDATE_PVT.Check_Operation_Netwrok_Dates
9968: (
9969: p_api_version => 1.0,
9970: p_init_msg_list => FND_API.G_FALSE,
9971: p_commit => FND_API.G_FALSE,
9972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9973: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9974: x_return_status => l_return_status,
9975: x_pri_operation_no => l_prior_op_no,

Line 9972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

9968: (
9969: p_api_version => 1.0,
9970: p_init_msg_list => FND_API.G_FALSE,
9971: p_commit => FND_API.G_FALSE,
9972: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
9973: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
9974: x_return_status => l_return_status,
9975: x_pri_operation_no => l_prior_op_no,
9976: x_next_operation_no => l_next_op_no

Line 10002: p_init_msg_list => FND_API.G_FALSE,

9998:
9999: EAM_WO_NETWORK_DEFAULT_PVT.Check_Resource_Dates
10000: (
10001: p_api_version => 1.0,
10002: p_init_msg_list => FND_API.G_FALSE,
10003: p_commit => FND_API.G_FALSE,
10004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10005:
10006: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,

Line 10003: p_commit => FND_API.G_FALSE,

9999: EAM_WO_NETWORK_DEFAULT_PVT.Check_Resource_Dates
10000: (
10001: p_api_version => 1.0,
10002: p_init_msg_list => FND_API.G_FALSE,
10003: p_commit => FND_API.G_FALSE,
10004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10005:
10006: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10007:

Line 10004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

10000: (
10001: p_api_version => 1.0,
10002: p_init_msg_list => FND_API.G_FALSE,
10003: p_commit => FND_API.G_FALSE,
10004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10005:
10006: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10007:
10008: x_return_status => l_return_status,

Line 10027: p_init_msg_list => FND_API.G_FALSE,

10023: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Calling Check_Wo_Negative_Dates procedure ... ') ; END IF ;
10024: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Negative_Dates
10025: (
10026: p_api_version => 1.0,
10027: p_init_msg_list => FND_API.G_FALSE,
10028: p_commit => FND_API.G_FALSE,
10029: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10030: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10031: p_organization_id => l_eam_wo_rec.organization_id,

Line 10028: p_commit => FND_API.G_FALSE,

10024: EAM_WO_NETWORK_DEFAULT_PVT.Check_Wo_Negative_Dates
10025: (
10026: p_api_version => 1.0,
10027: p_init_msg_list => FND_API.G_FALSE,
10028: p_commit => FND_API.G_FALSE,
10029: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10030: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10031: p_organization_id => l_eam_wo_rec.organization_id,
10032: x_return_status => l_return_status,

Line 10029: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

10025: (
10026: p_api_version => 1.0,
10027: p_init_msg_list => FND_API.G_FALSE,
10028: p_commit => FND_API.G_FALSE,
10029: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10030: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10031: p_organization_id => l_eam_wo_rec.organization_id,
10032: x_return_status => l_return_status,
10033: x_msg_count => l_msg_count,

Line 10057: p_init_msg_list => FND_API.G_FALSE,

10053:
10054: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
10055: (
10056: p_api_version => 1.0,
10057: p_init_msg_list => FND_API.G_FALSE,
10058: p_commit => FND_API.G_FALSE,
10059: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10060:
10061: p_work_object_id => l_eam_wo_rec.wip_entity_id,

Line 10058: p_commit => FND_API.G_FALSE,

10054: EAM_WO_NETWORK_VALIDATE_PVT.Validate_Structure
10055: (
10056: p_api_version => 1.0,
10057: p_init_msg_list => FND_API.G_FALSE,
10058: p_commit => FND_API.G_FALSE,
10059: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10060:
10061: p_work_object_id => l_eam_wo_rec.wip_entity_id,
10062: p_work_object_type_id => 1,

Line 10059: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

10055: (
10056: p_api_version => 1.0,
10057: p_init_msg_list => FND_API.G_FALSE,
10058: p_commit => FND_API.G_FALSE,
10059: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
10060:
10061: p_work_object_id => l_eam_wo_rec.wip_entity_id,
10062: p_work_object_type_id => 1,
10063: p_exception_logging => 'Y',

Line 10224: p_init_msg_list => fnd_api.g_false,

10220: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('EAM_PROCESS_WO_PVT.PROCESS_WO : Calling material Allocation procedure at wo release/cancel ... ') ; END IF ;
10221:
10222: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
10223: p_api_version => 1.0,
10224: p_init_msg_list => fnd_api.g_false,
10225: p_commit => fnd_api.g_false,
10226: p_validation_level => fnd_api.g_valid_level_full,
10227: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10228: p_organization_id => l_eam_wo_rec.organization_id,

Line 10225: p_commit => fnd_api.g_false,

10221:
10222: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
10223: p_api_version => 1.0,
10224: p_init_msg_list => fnd_api.g_false,
10225: p_commit => fnd_api.g_false,
10226: p_validation_level => fnd_api.g_valid_level_full,
10227: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10228: p_organization_id => l_eam_wo_rec.organization_id,
10229: p_status_type => l_eam_wo_rec.status_type,

Line 10226: p_validation_level => fnd_api.g_valid_level_full,

10222: EAM_MATERIALISSUE_PVT.alloc_at_release_cancel (
10223: p_api_version => 1.0,
10224: p_init_msg_list => fnd_api.g_false,
10225: p_commit => fnd_api.g_false,
10226: p_validation_level => fnd_api.g_valid_level_full,
10227: p_wip_entity_id => l_eam_wo_rec.wip_entity_id,
10228: p_organization_id => l_eam_wo_rec.organization_id,
10229: p_status_type => l_eam_wo_rec.status_type,
10230: x_return_status => l_return_status,

Line 10254: p_init_msg_list => fnd_api.g_false,

10250:
10251: EAM_MATERIALISSUE_PVT.comp_alloc_chng_qty
10252: (
10253: p_api_version => 1.0,
10254: p_init_msg_list => fnd_api.g_false,
10255: p_commit => fnd_api.g_false,
10256: p_validation_level => fnd_api.g_valid_level_full,
10257: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10258: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,

Line 10255: p_commit => fnd_api.g_false,

10251: EAM_MATERIALISSUE_PVT.comp_alloc_chng_qty
10252: (
10253: p_api_version => 1.0,
10254: p_init_msg_list => fnd_api.g_false,
10255: p_commit => fnd_api.g_false,
10256: p_validation_level => fnd_api.g_valid_level_full,
10257: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10258: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,
10259: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,

Line 10256: p_validation_level => fnd_api.g_valid_level_full,

10252: (
10253: p_api_version => 1.0,
10254: p_init_msg_list => fnd_api.g_false,
10255: p_commit => fnd_api.g_false,
10256: p_validation_level => fnd_api.g_valid_level_full,
10257: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10258: p_organization_id => l_out_eam_mat_req_tbl(kk).organization_id,
10259: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
10260: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,

Line 10277: p_init_msg_list => fnd_api.g_false,

10273: THEN
10274: EAM_MATERIALISSUE_PVT.cancel_alloc_matl_del
10275: (
10276: p_api_version => 1.0,
10277: p_init_msg_list => fnd_api.g_false,
10278: p_commit => fnd_api.g_false,
10279: p_validation_level => fnd_api.g_valid_level_full,
10280: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10281: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,

Line 10278: p_commit => fnd_api.g_false,

10274: EAM_MATERIALISSUE_PVT.cancel_alloc_matl_del
10275: (
10276: p_api_version => 1.0,
10277: p_init_msg_list => fnd_api.g_false,
10278: p_commit => fnd_api.g_false,
10279: p_validation_level => fnd_api.g_valid_level_full,
10280: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10281: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
10282: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,

Line 10279: p_validation_level => fnd_api.g_valid_level_full,

10275: (
10276: p_api_version => 1.0,
10277: p_init_msg_list => fnd_api.g_false,
10278: p_commit => fnd_api.g_false,
10279: p_validation_level => fnd_api.g_valid_level_full,
10280: p_wip_entity_id => l_out_eam_mat_req_tbl(kk).wip_entity_id,
10281: p_operation_seq_num => l_out_eam_mat_req_tbl(kk).operation_seq_num,
10282: p_inventory_item_id => l_out_eam_mat_req_tbl(kk).inventory_item_id,
10283: p_wip_entity_type => WIP_CONSTANTS.EAM,

Line 10342: l_return_status := FND_API.G_RET_STS_ERROR;

10338: , p_token_tbl => l_token_tbl
10339: );
10340: l_mesg_token_tbl := l_out_mesg_token_tbl;
10341:
10342: l_return_status := FND_API.G_RET_STS_ERROR;
10343:
10344: l_out_eam_wo_rec := l_eam_wo_rec;
10345: l_out_eam_op_tbl := l_eam_op_tbl;
10346: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10364: , p_error_status => FND_API.G_RET_STS_ERROR

10360: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10361: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10362: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10363: , p_mesg_token_tbl => l_mesg_token_tbl
10364: , p_error_status => FND_API.G_RET_STS_ERROR
10365: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10366: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10367: , p_other_message => l_other_message
10368: , p_other_token_tbl => l_other_token_tbl

Line 10426: , p_error_status => FND_API.G_RET_STS_ERROR

10422: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10423: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10424: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10425: , p_mesg_token_tbl => l_mesg_token_tbl
10426: , p_error_status => FND_API.G_RET_STS_ERROR
10427: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10428: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10429: , p_other_message => l_other_message
10430: , p_other_token_tbl => l_other_token_tbl

Line 10481: l_return_status := FND_API.G_RET_STS_ERROR;

10477: , p_token_tbl => l_token_tbl
10478: );
10479: l_mesg_token_tbl := l_out_mesg_token_tbl;
10480:
10481: l_return_status := FND_API.G_RET_STS_ERROR;
10482:
10483: l_out_eam_wo_rec := l_eam_wo_rec;
10484: l_out_eam_op_tbl := l_eam_op_tbl;
10485: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10503: , p_error_status => FND_API.G_RET_STS_ERROR

10499: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10500: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10501: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10502: , p_mesg_token_tbl => l_mesg_token_tbl
10503: , p_error_status => FND_API.G_RET_STS_ERROR
10504: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10505: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10506: , p_other_message => l_other_message
10507: , p_other_token_tbl => l_other_token_tbl

Line 10557: l_return_status := FND_API.G_RET_STS_ERROR;

10553: , p_token_tbl => l_token_tbl
10554: );
10555: l_mesg_token_tbl := l_out_mesg_token_tbl;
10556:
10557: l_return_status := FND_API.G_RET_STS_ERROR;
10558:
10559: l_out_eam_wo_rec := l_eam_wo_rec;
10560: l_out_eam_op_tbl := l_eam_op_tbl;
10561: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10579: , p_error_status => FND_API.G_RET_STS_ERROR

10575: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10576: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10577: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10578: , p_mesg_token_tbl => l_mesg_token_tbl
10579: , p_error_status => FND_API.G_RET_STS_ERROR
10580: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10581: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10582: , p_other_message => l_other_message
10583: , p_other_token_tbl => l_other_token_tbl

Line 10634: l_return_status := FND_API.G_RET_STS_ERROR;

10630: , p_token_tbl => l_token_tbl
10631: );
10632: l_mesg_token_tbl := l_out_mesg_token_tbl;
10633:
10634: l_return_status := FND_API.G_RET_STS_ERROR;
10635:
10636: l_out_eam_wo_rec := l_eam_wo_rec;
10637: l_out_eam_op_tbl := l_eam_op_tbl;
10638: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10656: , p_error_status => FND_API.G_RET_STS_ERROR

10652: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10653: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10654: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10655: , p_mesg_token_tbl => l_mesg_token_tbl
10656: , p_error_status => FND_API.G_RET_STS_ERROR
10657: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10658: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10659: , p_other_message => l_other_message
10660: , p_other_token_tbl => l_other_token_tbl

Line 10711: l_return_status := FND_API.G_RET_STS_ERROR;

10707: , p_token_tbl => l_token_tbl
10708: );
10709: l_mesg_token_tbl := l_out_mesg_token_tbl;
10710:
10711: l_return_status := FND_API.G_RET_STS_ERROR;
10712:
10713: l_out_eam_wo_rec := l_eam_wo_rec;
10714: l_out_eam_op_tbl := l_eam_op_tbl;
10715: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10733: , p_error_status => FND_API.G_RET_STS_ERROR

10729: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10730: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10731: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10732: , p_mesg_token_tbl => l_mesg_token_tbl
10733: , p_error_status => FND_API.G_RET_STS_ERROR
10734: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10735: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10736: , p_other_message => l_other_message
10737: , p_other_token_tbl => l_other_token_tbl

Line 10795: l_return_status := FND_API.G_RET_STS_ERROR;

10791: , p_token_tbl => l_token_tbl
10792: );
10793: l_mesg_token_tbl := l_out_mesg_token_tbl;
10794:
10795: l_return_status := FND_API.G_RET_STS_ERROR;
10796:
10797: l_out_eam_wo_rec := l_eam_wo_rec;
10798: l_out_eam_op_tbl := l_eam_op_tbl;
10799: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10817: , p_error_status => FND_API.G_RET_STS_ERROR

10813: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10814: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10815: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10816: , p_mesg_token_tbl => l_mesg_token_tbl
10817: , p_error_status => FND_API.G_RET_STS_ERROR
10818: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10819: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10820: , p_other_message => l_other_message
10821: , p_other_token_tbl => l_other_token_tbl

Line 10878: l_return_status := FND_API.G_RET_STS_ERROR;

10874: , p_token_tbl => l_token_tbl
10875: );
10876: l_mesg_token_tbl := l_out_mesg_token_tbl;
10877:
10878: l_return_status := FND_API.G_RET_STS_ERROR;
10879:
10880: l_out_eam_wo_rec := l_eam_wo_rec;
10881: l_out_eam_op_tbl := l_eam_op_tbl;
10882: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10900: , p_error_status => FND_API.G_RET_STS_ERROR

10896: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10897: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10898: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10899: , p_mesg_token_tbl => l_mesg_token_tbl
10900: , p_error_status => FND_API.G_RET_STS_ERROR
10901: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10902: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10903: , p_other_message => l_other_message
10904: , p_other_token_tbl => l_other_token_tbl

Line 10954: l_return_status := FND_API.G_RET_STS_ERROR;

10950: , p_token_tbl => l_token_tbl
10951: );
10952: l_mesg_token_tbl := l_out_mesg_token_tbl;
10953:
10954: l_return_status := FND_API.G_RET_STS_ERROR;
10955:
10956: l_out_eam_wo_rec := l_eam_wo_rec;
10957: l_out_eam_op_tbl := l_eam_op_tbl;
10958: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 10976: , p_error_status => FND_API.G_RET_STS_ERROR

10972: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
10973: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
10974: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
10975: , p_mesg_token_tbl => l_mesg_token_tbl
10976: , p_error_status => FND_API.G_RET_STS_ERROR
10977: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
10978: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
10979: , p_other_message => l_other_message
10980: , p_other_token_tbl => l_other_token_tbl

Line 11027: l_return_status := FND_API.G_RET_STS_ERROR;

11023: , p_token_tbl => l_token_tbl
11024: );
11025: l_mesg_token_tbl := l_out_mesg_token_tbl;
11026:
11027: l_return_status := FND_API.G_RET_STS_ERROR;
11028:
11029: l_out_eam_wo_rec := l_eam_wo_rec;
11030: l_out_eam_op_tbl := l_eam_op_tbl;
11031: l_out_eam_op_network_tbl := l_eam_op_network_tbl;

Line 11049: , p_error_status => FND_API.G_RET_STS_ERROR

11045: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
11046: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
11047: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
11048: , p_mesg_token_tbl => l_mesg_token_tbl
11049: , p_error_status => FND_API.G_RET_STS_ERROR
11050: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
11051: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
11052: , p_other_message => l_other_message
11053: , p_other_token_tbl => l_other_token_tbl

Line 11143: , p_error_status => FND_API.G_RET_STS_ERROR

11139: , p_eam_res_usage_tbl => l_eam_res_usage_tbl
11140: , p_eam_mat_req_tbl => l_eam_mat_req_tbl
11141: , p_eam_direct_items_tbl => l_eam_direct_items_tbl
11142: , p_mesg_token_tbl => l_mesg_token_tbl
11143: , p_error_status => FND_API.G_RET_STS_ERROR
11144: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_SCOPE_RECORD
11145: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
11146: , p_other_message => l_other_message
11147: , p_other_token_tbl => l_other_token_tbl

Line 11217: 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)

11213: x_valid_transaction := TRUE;
11214:
11215:
11216: IF (p_entity_name IN ('WORK_ORDER')
11217: 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)
11218: )
11219: OR
11220: (p_entity_name IN ('OPERATION','OPERATION_RESOURCE','RESOURCE_INSTANCE','SUB_RESOURCE','DIRECT_ITEMS','MATERIAL_REQUIREMENTS')
11221: 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 11221: 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)

11217: 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)
11218: )
11219: OR
11220: (p_entity_name IN ('OPERATION','OPERATION_RESOURCE','RESOURCE_INSTANCE','SUB_RESOURCE','DIRECT_ITEMS','MATERIAL_REQUIREMENTS')
11221: 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)
11222: )
11223: OR
11224: (p_entity_name IN ('OPERATION_NETWORK', 'RESOURCE_USAGE')
11225: 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 11225: 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)

11221: 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)
11222: )
11223: OR
11224: (p_entity_name IN ('OPERATION_NETWORK', 'RESOURCE_USAGE')
11225: 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)
11226: )
11227: OR
11228: (p_entity_name IN ('WORK_ORDER_COMPLETEION','OPERATION_COMPLETEION')
11229: 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 11229: 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)

11225: 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)
11226: )
11227: OR
11228: (p_entity_name IN ('WORK_ORDER_COMPLETEION','OPERATION_COMPLETEION')
11229: 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)
11230: )
11231: OR
11232: (p_entity_name IN ('QUALITY_ENTRY','METER_READING')
11233: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)

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

11229: 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)
11230: )
11231: OR
11232: (p_entity_name IN ('QUALITY_ENTRY','METER_READING')
11233: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)
11234: )
11235: OR
11236: (p_entity_name IN ('WORK_ORDER_COMPL_REBUILD','W_ORDER_COMPL_METER_READING')
11237: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)

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

11233: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_CREATE)
11234: )
11235: OR
11236: (p_entity_name IN ('WORK_ORDER_COMPL_REBUILD','W_ORDER_COMPL_METER_READING')
11237: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
11238: )
11239: OR
11240: (p_entity_name IN ('WORK_SERVICE_REQUEST')
11241: 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 11241: 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)

11237: AND NVL(p_transaction_type, FND_API.G_MISS_NUM) NOT IN (EAM_PROCESS_WO_PVT.G_OPR_UPDATE)
11238: )
11239: OR
11240: (p_entity_name IN ('WORK_SERVICE_REQUEST')
11241: 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)
11242: )
11243:
11244: THEN
11245:

Line 11733: x_return_status := FND_API.G_RET_STS_SUCCESS;

11729:
11730: l_eam_failure_entry_record := p_eam_wo_comp_rec.eam_failure_entry_record;
11731: l_eam_failure_codes_tbl := p_eam_wo_comp_rec.eam_failure_codes_tbl;
11732:
11733: x_return_status := FND_API.G_RET_STS_SUCCESS;
11734: l_eam_wo_comp_rec := p_eam_wo_comp_rec;
11735:
11736: SELECT wip_entity_name INTO l_wip_entity_name
11737: FROM wip_entities

Line 12125: , p_error_status => FND_API.G_RET_STS_ERROR

12121: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12122: , x_eam_request_tbl => l_out_eam_request_tbl
12123:
12124: , p_mesg_token_tbl => l_mesg_token_tbl
12125: , p_error_status => FND_API.G_RET_STS_ERROR
12126: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12127: , p_other_message => l_other_message
12128: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12129: , p_other_token_tbl => l_other_token_tbl

Line 12189: , p_error_status => FND_API.G_RET_STS_ERROR

12185: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12186: , x_eam_request_tbl => l_out_eam_request_tbl
12187:
12188: , p_mesg_token_tbl => l_mesg_token_tbl
12189: , p_error_status => FND_API.G_RET_STS_ERROR
12190: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12191: , p_other_message => l_other_message
12192: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12193: , p_other_token_tbl => l_other_token_tbl

Line 12245: l_return_status := FND_API.G_RET_STS_ERROR;

12241: l_other_message := 'EAM_WOCMPL_MAND_PLAN';
12242: l_other_token_tbl(1).token_name := 'WIP_ENTITY_NAME';
12243: l_other_token_tbl(1).token_value := l_wip_entity_name;
12244:
12245: l_return_status := FND_API.G_RET_STS_ERROR;
12246:
12247: RAISE EXC_SEV_QUIT_RECORD;
12248:
12249: /* l_token_tbl(1).token_name := 'WIP_ENTITY_NAME';

Line 12261: x_return_status := FND_API.G_RET_STS_ERROR;

12257: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
12258: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
12259: );
12260:
12261: x_return_status := FND_API.G_RET_STS_ERROR;
12262:
12263: raise EXC_SEV_QUIT_RECORD; */
12264:
12265: END IF;

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

12374: );
12375:
12376: /* IF l_return_status <> 'S' THEN
12377: errCode := 1;
12378: errMsg := Fnd_Msg_Pub.Get(1,Fnd_Api.G_FALSE);
12379: return;
12380: END IF; */
12381: IF NVL(l_return_status, 'T') <> 'S' THEN
12382: l_return_status := 'E';

Line 12434: x_return_status := FND_API.G_RET_STS_ERROR;

12430: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
12431: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
12432: );
12433:
12434: x_return_status := FND_API.G_RET_STS_ERROR;
12435:
12436: RAISE EXC_SEV_QUIT_RECORD;
12437: END ;
12438:

Line 12462: x_return_status := FND_API.G_RET_STS_ERROR;

12458: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
12459: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
12460: );
12461:
12462: x_return_status := FND_API.G_RET_STS_ERROR;
12463:
12464: RAISE EXC_SEV_QUIT_RECORD;
12465: END IF;
12466: END IF; -- l_plan_id_tbl.count > 0 -- BUG 12914431

Line 12850: , p_error_status => FND_API.G_RET_STS_ERROR

12846: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
12847: , x_eam_request_tbl => l_out_eam_request_tbl
12848:
12849: , p_mesg_token_tbl => l_mesg_token_tbl
12850: , p_error_status => FND_API.G_RET_STS_ERROR
12851: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
12852: , p_other_message => l_other_message
12853: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
12854: , p_other_token_tbl => l_other_token_tbl

Line 12964: x_return_status := FND_API.G_RET_STS_SUCCESS;

12960: BEGIN
12961: 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_PVT.COMP_UNCOMP_OPERATION : Start==========================================================') ; END IF ;
12962:
12963:
12964: x_return_status := FND_API.G_RET_STS_SUCCESS;
12965: l_return_status := FND_API.G_RET_STS_SUCCESS;
12966:
12967: l_eam_wo_quality_tbl := p_eam_wo_quality_tbl;
12968: l_eam_op_comp_rec := p_eam_op_compl_tbl(p_eam_op_compl_tbl.FIRST);

Line 12965: l_return_status := FND_API.G_RET_STS_SUCCESS;

12961: 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_PVT.COMP_UNCOMP_OPERATION : Start==========================================================') ; END IF ;
12962:
12963:
12964: x_return_status := FND_API.G_RET_STS_SUCCESS;
12965: l_return_status := FND_API.G_RET_STS_SUCCESS;
12966:
12967: l_eam_wo_quality_tbl := p_eam_wo_quality_tbl;
12968: l_eam_op_comp_rec := p_eam_op_compl_tbl(p_eam_op_compl_tbl.FIRST);
12969: l_org_id := l_eam_op_comp_rec.organization_id;

Line 13178: x_return_status:=FND_API.G_RET_STS_ERROR;

13174: );
13175:
13176:
13177: IF l_return_status <> 'S' THEN
13178: x_return_status:=FND_API.G_RET_STS_ERROR;
13179: l_other_message := 'EAM_OP_QUAINSERT_CSEV_SKIP';
13180: l_other_token_tbl(1).token_name := 'OP_SEQ';
13181: l_other_token_tbl(1).token_value := l_eam_wo_quality_rec.operation_seq_number;
13182: RAISE EXC_SEV_QUIT_RECORD;

Line 13223: x_return_status := FND_API.G_RET_STS_ERROR;

13219: l_other_message := 'EAM_OPCMPL_MAND_PLAN';
13220: l_other_token_tbl(1).token_name := 'OP_SEQ';
13221: l_other_token_tbl(1).token_value := l_eam_op_comp_rec.operation_seq_num;
13222:
13223: x_return_status := FND_API.G_RET_STS_ERROR;
13224:
13225: raise EXC_SEV_QUIT_RECORD;
13226: END IF;
13227: END;

Line 13258: x_return_status := FND_API.G_RET_STS_ERROR;

13254: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
13255: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
13256: );
13257:
13258: x_return_status := FND_API.G_RET_STS_ERROR;
13259:
13260: raise EXC_SEV_QUIT_RECORD;
13261: END ;
13262:

Line 13286: x_return_status := FND_API.G_RET_STS_ERROR;

13282: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
13283: , x_Mesg_Token_Tbl => l_out_Mesg_Token_Tbl
13284: );
13285:
13286: x_return_status := FND_API.G_RET_STS_ERROR;
13287:
13288: raise EXC_SEV_QUIT_RECORD;
13289: END IF;
13290:

Line 13374: , p_error_status => FND_API.G_RET_STS_ERROR

13370: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
13371: , x_eam_request_tbl => l_out_eam_request_tbl
13372:
13373: , p_mesg_token_tbl => l_mesg_token_tbl
13374: , p_error_status => FND_API.G_RET_STS_ERROR
13375: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
13376: , p_other_message => l_other_message
13377: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
13378: , p_other_token_tbl => l_other_token_tbl

Line 13385: x_return_status := FND_API.G_RET_STS_ERROR;

13381: );
13382:
13383: l_msg_count := EAM_ERROR_MESSAGE_PVT.GET_MESSAGE_COUNT();
13384:
13385: x_return_status := FND_API.G_RET_STS_ERROR;
13386: x_msg_count := l_msg_count;
13387:
13388: RETURN;
13389: END ; -- End for op count > 0

Line 13444: x_return_status := FND_API.G_RET_STS_SUCCESS;

13440: BEGIN
13441:
13442: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request Service Request association procedure begin '); END IF;
13443:
13444: x_return_status := FND_API.G_RET_STS_SUCCESS;
13445: l_return_status := FND_API.G_RET_STS_SUCCESS;
13446:
13447: l_eam_request_tbl := p_eam_request_tbl;
13448:

Line 13445: l_return_status := FND_API.G_RET_STS_SUCCESS;

13441:
13442: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Work Request Service Request association procedure begin '); END IF;
13443:
13444: x_return_status := FND_API.G_RET_STS_SUCCESS;
13445: l_return_status := FND_API.G_RET_STS_SUCCESS;
13446:
13447: l_eam_request_tbl := p_eam_request_tbl;
13448:
13449: l_eam_request_rec := p_eam_request_tbl(p_eam_request_tbl.FIRST);

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

13552: l_other_token_tbl(1).token_value := l_eam_request_rec.request_id;
13553: RAISE EXC_SEV_QUIT_RECORD;
13554: END IF;
13555:
13556: x_eam_request_tbl(i).return_status := FND_API.G_RET_STS_SUCCESS;
13557: END;
13558: END LOOP;
13559:
13560: EXCEPTION

Line 13580: , p_error_status => FND_API.G_RET_STS_ERROR

13576: , x_eam_op_comp_tbl => l_out_eam_op_comp_tbl
13577: , x_eam_request_tbl => l_out_eam_request_tbl
13578:
13579: , p_mesg_token_tbl => l_mesg_token_tbl
13580: , p_error_status => FND_API.G_RET_STS_ERROR
13581: , p_error_scope => EAM_ERROR_MESSAGE_PVT.G_WO_LEVEL
13582: , p_other_message => l_other_message
13583: , p_other_status => EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR
13584: , p_other_token_tbl => l_other_token_tbl