eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on FND_API

Line 120: P_Init_Msg_List In Varchar2:= Fnd_API.G_False,

116:
117:
118: Procedure process_part (
119: P_API_Version In Number:= 1.0,
120: P_Init_Msg_List In Varchar2:= Fnd_API.G_False,
121: P_Commit In Varchar2:= Fnd_API.G_False,
122: P_Validation_Level In Number:= Fnd_API.G_Valid_Level_Full,
123: p_module_type In VarChar2 := NULL,
124: p_default In Varchar2 := FND_API.G_TRUE,

Line 121: P_Commit In Varchar2:= Fnd_API.G_False,

117:
118: Procedure process_part (
119: P_API_Version In Number:= 1.0,
120: P_Init_Msg_List In Varchar2:= Fnd_API.G_False,
121: P_Commit In Varchar2:= Fnd_API.G_False,
122: P_Validation_Level In Number:= Fnd_API.G_Valid_Level_Full,
123: p_module_type In VarChar2 := NULL,
124: p_default In Varchar2 := FND_API.G_TRUE,
125: p_x_parts_rec_tbl In Out NOCOPY Ahl_Parts_tbl_type,

Line 122: P_Validation_Level In Number:= Fnd_API.G_Valid_Level_Full,

118: Procedure process_part (
119: P_API_Version In Number:= 1.0,
120: P_Init_Msg_List In Varchar2:= Fnd_API.G_False,
121: P_Commit In Varchar2:= Fnd_API.G_False,
122: P_Validation_Level In Number:= Fnd_API.G_Valid_Level_Full,
123: p_module_type In VarChar2 := NULL,
124: p_default In Varchar2 := FND_API.G_TRUE,
125: p_x_parts_rec_tbl In Out NOCOPY Ahl_Parts_tbl_type,
126: X_Error_Code Out NOCOPY Varchar2,

Line 124: p_default In Varchar2 := FND_API.G_TRUE,

120: P_Init_Msg_List In Varchar2:= Fnd_API.G_False,
121: P_Commit In Varchar2:= Fnd_API.G_False,
122: P_Validation_Level In Number:= Fnd_API.G_Valid_Level_Full,
123: p_module_type In VarChar2 := NULL,
124: p_default In Varchar2 := FND_API.G_TRUE,
125: p_x_parts_rec_tbl In Out NOCOPY Ahl_Parts_tbl_type,
126: X_Error_Code Out NOCOPY Varchar2,
127: X_Return_Status Out NOCOPY Varchar2,
128: X_Msg_Count Out NOCOPY Number,

Line 155: IF NOT FND_API.Compatible_API_Call(l_api_version,

151: -- Standard start of API savepoint
152: Savepoint perform_part_changes_pvt;
153:
154: -- Standard call to check for call compatibility
155: IF NOT FND_API.Compatible_API_Call(l_api_version,
156: p_api_version,
157: l_api_name,
158: G_PKG_NAME) THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155: IF NOT FND_API.Compatible_API_Call(l_api_version,
156: p_api_version,
157: l_api_name,
158: G_PKG_NAME) THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: -- Initialize message list if p_init_msg_list is set to TRUE
163: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 163: IF FND_API.To_Boolean(p_init_msg_list) THEN

159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: -- Initialize message list if p_init_msg_list is set to TRUE
163: IF FND_API.To_Boolean(p_init_msg_list) THEN
164: FND_MSG_PUB.Initialize;
165: END IF;
166:
167: -- Initialize API return status to success

Line 168: x_return_status := FND_API.G_RET_STS_SUCCESS;

164: FND_MSG_PUB.Initialize;
165: END IF;
166:
167: -- Initialize API return status to success
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: -- Enable Debug.
171: IF G_DEBUG = 'Y' THEN
172: AHL_DEBUG_PUB.enable_debug;

Line 245: RAISE FND_API.G_EXC_ERROR;

241:
242: -- Check Error Message stack.
243: l_msg_count := FND_MSG_PUB.count_msg;
244: IF l_msg_count > 0 THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: -- dbms_output.put_line('After convert_value_to_id');
249: IF G_DEBUG = 'Y' THEN

Line 264: RAISE FND_API.G_EXC_ERROR;

260: -- Check Error Message stack.
261: l_msg_count := FND_MSG_PUB.count_msg;
262:
263: IF l_msg_count > 0 THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: ------**************Get csi_transaction_rec.
268: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);

Line 269: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

265: END IF;
266:
267: ------**************Get csi_transaction_rec.
268: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);
269: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272:
273: -- Check if config_header_id was provided. If not check if unit_config_name exists.

Line 270: RAISE FND_API.G_EXC_ERROR;

266:
267: ------**************Get csi_transaction_rec.
268: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);
269: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272:
273: -- Check if config_header_id was provided. If not check if unit_config_name exists.
274: -- If yes then perform UC processing else do IB processing

Line 311: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

307:
308: END IF; -- if l_uc_processing
309:
310: -- error checking after UC or IB processing
311: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;

Line 312: RAISE FND_API.G_EXC_ERROR;

308: END IF; -- if l_uc_processing
309:
310: -- error checking after UC or IB processing
311: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:

Line 313: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

309:
310: -- error checking after UC or IB processing
311: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317:

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: -- error checking after UC or IB processing
311: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317:
318: ---*********** Update item location to WIP if operation is remove or swap***********---

Line 326: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

322: update_item_location(
323: p_x_parts_rec => p_x_parts_rec_tbl(i),
324: p_x_csi_transaction_rec => l_csi_transaction_rec,
325: x_return_status => x_return_status);
326: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
327: RAISE FND_API.G_EXC_ERROR;
328:
329:
330:

Line 327: RAISE FND_API.G_EXC_ERROR;

323: p_x_parts_rec => p_x_parts_rec_tbl(i),
324: p_x_csi_transaction_rec => l_csi_transaction_rec,
325: x_return_status => x_return_status);
326: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
327: RAISE FND_API.G_EXC_ERROR;
328:
329:
330:
331: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 331: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

327: RAISE FND_API.G_EXC_ERROR;
328:
329:
330:
331: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334:
335: END IF;*/

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328:
329:
330:
331: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: END IF;
334:
335: END IF;*/
336:

Line 353: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

349: p_x_parts_rec => p_x_parts_rec_tbl(i),
350: p_module_type => p_module_type,
351: x_return_status => x_return_status);
352:
353: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
354: RAISE FND_API.G_EXC_ERROR;
355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;

Line 354: RAISE FND_API.G_EXC_ERROR;

350: p_module_type => p_module_type,
351: x_return_status => x_return_status);
352:
353: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
354: RAISE FND_API.G_EXC_ERROR;
355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: END IF;

Line 355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

351: x_return_status => x_return_status);
352:
353: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
354: RAISE FND_API.G_EXC_ERROR;
355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: END IF;
359: */

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352:
353: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
354: RAISE FND_API.G_EXC_ERROR;
355: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: END IF;
359: */
360:

Line 459: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

455: p_x_parts_rec_tbl => p_x_parts_rec_tbl,
456: p_module_type => p_module_type,
457: x_return_status => x_return_status);
458:
459: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
460: RAISE FND_API.G_EXC_ERROR;
461: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;

Line 460: RAISE FND_API.G_EXC_ERROR;

456: p_module_type => p_module_type,
457: x_return_status => x_return_status);
458:
459: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
460: RAISE FND_API.G_EXC_ERROR;
461: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:

Line 461: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

457: x_return_status => x_return_status);
458:
459: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
460: RAISE FND_API.G_EXC_ERROR;
461: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: */

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458:
459: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
460: RAISE FND_API.G_EXC_ERROR;
461: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464:
465: */
466:

Line 468: IF FND_API.To_Boolean(p_commit) THEN

464:
465: */
466:
467: -- Standard check of p_commit
468: IF FND_API.To_Boolean(p_commit) THEN
469: COMMIT WORK;
470: END IF;
471:
472: -- Initialize API return status to success

Line 473: x_return_status := FND_API.G_RET_STS_SUCCESS;

469: COMMIT WORK;
470: END IF;
471:
472: -- Initialize API return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS;
474:
475: IF G_DEBUG = 'Y' THEN
476: AHL_DEBUG_PUB.debug('Completed Processing. Checking for errors', '');
477: END IF;

Line 483: p_encoded => fnd_api.g_false);

479: -- Standard call to get message count and if count is 1, get message
480: FND_MSG_PUB.Count_And_Get
481: ( p_count => x_msg_count,
482: p_data => x_msg_data,
483: p_encoded => fnd_api.g_false);
484:
485: -- Disable debug (if enabled)
486: IF G_DEBUG = 'Y' THEN
487: AHL_DEBUG_PUB.disable_debug;

Line 491: WHEN FND_API.G_EXC_ERROR THEN

487: AHL_DEBUG_PUB.disable_debug;
488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: Rollback to perform_part_changes_pvt;
494: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
495: p_data => x_msg_data,

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: Rollback to perform_part_changes_pvt;
494: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
495: p_data => x_msg_data,
496: p_encoded => fnd_api.g_false);

Line 496: p_encoded => fnd_api.g_false);

492: x_return_status := FND_API.G_RET_STS_ERROR;
493: Rollback to perform_part_changes_pvt;
494: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
495: p_data => x_msg_data,
496: p_encoded => fnd_api.g_false);
497: -- Disable debug
498: IF G_DEBUG = 'Y' THEN
499: AHL_DEBUG_PUB.disable_debug;
500: END IF;

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: AHL_DEBUG_PUB.disable_debug;
500: END IF;
501:
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: Rollback to perform_part_changes_pvt;
506: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
507: p_data => x_msg_data,

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

500: END IF;
501:
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: Rollback to perform_part_changes_pvt;
506: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
507: p_data => x_msg_data,
508: p_encoded => fnd_api.g_false);

Line 508: p_encoded => fnd_api.g_false);

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: Rollback to perform_part_changes_pvt;
506: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
507: p_data => x_msg_data,
508: p_encoded => fnd_api.g_false);
509: -- Disable debug
510: IF G_DEBUG = 'Y' THEN
511: AHL_DEBUG_PUB.disable_debug;
512: END IF;

Line 514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

510: IF G_DEBUG = 'Y' THEN
511: AHL_DEBUG_PUB.disable_debug;
512: END IF;
513: WHEN OTHERS THEN
514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
515: Rollback to perform_part_changes_pvt;
516: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
517: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_PARTS_CHANGE_PVT',
518: p_procedure_name => 'process_parts',

Line 523: p_encoded => fnd_api.g_false);

519: p_error_text => SQLERRM);
520: --END IF;
521: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
522: p_data => x_msg_data,
523: p_encoded => fnd_api.g_false);
524:
525: -- Disable debug
526: IF G_DEBUG = 'Y' THEN
527: AHL_DEBUG_PUB.disable_debug;

Line 645: x_return_status := FND_API.G_RET_STS_SUCCESS;

641:
642: BEGIN
643:
644: -- Initialize API return status to success
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647:
648:
649: --********Test that the workorder_id is not null -----

Line 650: IF ( p_x_parts_rec.workorder_id is null or p_x_parts_rec.workorder_id =FND_API.G_MISS_NUM) then

646:
647:
648:
649: --********Test that the workorder_id is not null -----
650: IF ( p_x_parts_rec.workorder_id is null or p_x_parts_rec.workorder_id =FND_API.G_MISS_NUM) then
651:
652: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_WO_ID_MISSIN');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;

Line 654: RAISE FND_API.G_EXC_ERROR;

650: IF ( p_x_parts_rec.workorder_id is null or p_x_parts_rec.workorder_id =FND_API.G_MISS_NUM) then
651:
652: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_WO_ID_MISSIN');
653: FND_MSG_PUB.ADD;
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656:
657: --rroy
658: -- ACL Changes

Line 663: IF l_return_status = FND_API.G_TRUE THEN

659: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => p_x_parts_rec.workorder_id,
660: p_ue_id => NULL,
661: p_visit_id => NULL,
662: p_item_instance_id => NULL);
663: IF l_return_status = FND_API.G_TRUE THEN
664: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_PRTCHG_UNTLCKD');
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;

Line 666: RAISE FND_API.G_EXC_ERROR;

662: p_item_instance_id => NULL);
663: IF l_return_status = FND_API.G_TRUE THEN
664: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_PRTCHG_UNTLCKD');
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: --rroy
670: -- ACL Changes

Line 676: RAISE FND_API.G_EXC_ERROR;

672: --******** Test that operation type is not null -----
673: IF ( p_x_parts_rec.operation_type is null ) then
674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_OP_TYPE_MISSIN');
675: FND_MSG_PUB.ADD;
676: RAISE FND_API.G_EXC_ERROR;
677: END IF;
678:
679: --*********** Operation Seq ********** -----
680: IF (p_x_parts_rec.operation_sequence_num is null ) then

Line 685: RAISE FND_API.G_EXC_ERROR;

681: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_INVALID_OPERATION');
682: FND_MESSAGE.Set_Token('OPSEQ', p_x_parts_rec.operation_sequence_num);
683: --FND_MESSAGE.Set_Token('WOID', p_x_parts_rec.workorder_id);
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: --*********** Check that the operation sequence exists for the work order. ---
689: OPEN ahl_wo_oper_csr(p_x_parts_rec.workorder_id,p_x_parts_rec.operation_sequence_num );

Line 699: RAISE FND_API.G_EXC_ERROR;

695:
696: --FND_MESSAGE.Set_Token('WOID', p_x_parts_rec.workorder_id);
697: FND_MSG_PUB.ADD;
698: CLOSE ahl_wo_oper_csr;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: CLOSE ahl_wo_oper_csr;
702:
703: -- Validate that the job is not closed.

Line 711: RAISE FND_API.G_EXC_ERROR;

707: CLOSE ahl_job_csr;
708: FND_MESSAGE.set_name('AHL', 'AHL_PRD_WO_INVALID');
709: FND_MESSAGE.set_token('WOID', p_x_parts_rec.workorder_id);
710: FND_MSG_PUB.ADD;
711: RAISE FND_API.G_EXC_ERROR;
712: END IF;
713: CLOSE ahl_job_csr;
714:
715: IF (l_junk <> '3' and l_junk <> '19') THEN

Line 718: RAISE FND_API.G_EXC_ERROR;

714:
715: IF (l_junk <> '3' and l_junk <> '19') THEN
716: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_JOB_CLOSED');
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_ERROR;
719: END IF;
720:
721: -- To test pending transactions in WIP interface.
722: /*IF (AHL_WIP_JOB_PVT.wip_massload_pending(l_wip_entity_id)) THEN

Line 723: RAISE FND_API.G_EXC_ERROR;

719: END IF;
720:
721: -- To test pending transactions in WIP interface.
722: /*IF (AHL_WIP_JOB_PVT.wip_massload_pending(l_wip_entity_id)) THEN
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;*/
725:
726: --Check if the UC header id is valid.
727: IF (p_x_parts_rec.Unit_Config_Header_Id is not null) then

Line 736: RAISE FND_API.G_EXC_ERROR;

732: CLOSE ahl_uc_header_csr;
733: FND_MESSAGE.set_name('AHL', 'AHL_PRD_UC_HEADER_INVALID');
734: FND_MESSAGE.set_token('UCID', p_x_parts_rec.unit_config_header_id);
735: FND_MSG_PUB.ADD;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: END IF;
739:
740: --********* Position *************--

Line 791: --RAISE FND_API.G_EXC_ERROR;

787: CLOSE ahl_location_type_csr;
788: IF l_junk is null then
789: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_STATUS_INVALID');
790: FND_MSG_PUB.ADD;
791: --RAISE FND_API.G_EXC_ERROR;
792: END IF;
793: */
794: FETCH ahl_location_type_csr into l_inst_job_id, l_wip_job_name;
795: IF (ahl_location_type_csr%NOTFOUND) THEN

Line 851: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

847: AHL_PRD_UTIL_PKG.validate_reason(
848: p_reason_id => p_x_parts_rec.removal_reason_id,
849: x_return_status => x_return_status,
850: x_msg_data => l_msg_data);
851: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: END IF;

Line 852: RAISE FND_API.G_EXC_ERROR;

848: p_reason_id => p_x_parts_rec.removal_reason_id,
849: x_return_status => x_return_status,
850: x_msg_data => l_msg_data);
851: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: END IF;
856:

Line 875: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

871: AHL_PRD_UTIL_PKG.validate_condition(
872: p_condition_id => p_x_parts_rec.condition_id ,
873: x_return_status => x_return_status,
874: x_msg_data => l_msg_data );
875: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879:

Line 876: RAISE FND_API.G_EXC_ERROR;

872: p_condition_id => p_x_parts_rec.condition_id ,
873: x_return_status => x_return_status,
874: x_msg_data => l_msg_data );
875: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879:
880: */

Line 928: RAISE FND_API.G_EXC_ERROR;

924: CLOSE ahl_visit_csr;
925: IF l_junk = 'CLOSED' THEN
926: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_VISIT_INVALID');
927: FND_MSG_PUB.ADD;
928: RAISE FND_API.G_EXC_ERROR;
929: END IF;
930: END IF;
931: -- dbms_output.put_line('target viist id is valid');
932: END IF;--end sr validation

Line 952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

948: p_Subinventory_Code => p_x_parts_rec.subinventory_code,
949: p_Condition_id => p_x_parts_rec.condition_id,
950: x_return_status => x_return_status);
951:
952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:
956: -- The following procedure call will decide if a qa plan is atatched.

Line 953: RAISE FND_API.G_EXC_ERROR;

949: p_Condition_id => p_x_parts_rec.condition_id,
950: x_return_status => x_return_status);
951:
952: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:
956: -- The following procedure call will decide if a qa plan is atatched.
957: AHL_QA_RESULTS_PVT.get_qa_plan(

Line 959: p_init_msg_list => FND_API.G_False,

955:
956: -- The following procedure call will decide if a qa plan is atatched.
957: AHL_QA_RESULTS_PVT.get_qa_plan(
958: p_api_version => '1.0',
959: p_init_msg_list => FND_API.G_False,
960: p_commit => FND_API.G_FALSE,
961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
962: p_default => FND_API.G_FALSE,
963: --p_module_type => p_module_type,

Line 960: p_commit => FND_API.G_FALSE,

956: -- The following procedure call will decide if a qa plan is atatched.
957: AHL_QA_RESULTS_PVT.get_qa_plan(
958: p_api_version => '1.0',
959: p_init_msg_list => FND_API.G_False,
960: p_commit => FND_API.G_FALSE,
961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
962: p_default => FND_API.G_FALSE,
963: --p_module_type => p_module_type,
964: p_organization_id => l_org_id,

Line 961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

957: AHL_QA_RESULTS_PVT.get_qa_plan(
958: p_api_version => '1.0',
959: p_init_msg_list => FND_API.G_False,
960: p_commit => FND_API.G_FALSE,
961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
962: p_default => FND_API.G_FALSE,
963: --p_module_type => p_module_type,
964: p_organization_id => l_org_id,
965: p_transaction_number => 2004,

Line 962: p_default => FND_API.G_FALSE,

958: p_api_version => '1.0',
959: p_init_msg_list => FND_API.G_False,
960: p_commit => FND_API.G_FALSE,
961: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
962: p_default => FND_API.G_FALSE,
963: --p_module_type => p_module_type,
964: p_organization_id => l_org_id,
965: p_transaction_number => 2004,
966: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),

Line 979: RAISE FND_API.G_EXC_ERROR;

975: and p_x_parts_rec.collection_id is null)
976: THEN
977: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_COLLECT_ID_MISSIN');
978: FND_MSG_PUB.ADD;
979: RAISE FND_API.G_EXC_ERROR;
980: END IF;
981:
982: END IF; -- operation type.
983: END IF; -- sub-inventory null.

Line 1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1006: p_org_id => l_org_id,
1007: p_subinventory_code => p_x_parts_rec.subinventory_code,
1008: X_Return_Status => x_return_status,
1009: x_msg_data => l_msg_data);
1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: END IF;
1014:

Line 1011: RAISE FND_API.G_EXC_ERROR;

1007: p_subinventory_code => p_x_parts_rec.subinventory_code,
1008: X_Return_Status => x_return_status,
1009: x_msg_data => l_msg_data);
1010: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1011: RAISE FND_API.G_EXC_ERROR;
1012: END IF;
1013: END IF;
1014:
1015: */

Line 1018: IF (p_x_parts_rec.Removal_date is null or p_x_parts_rec.Removal_date = FND_API.G_MISS_DATE) THEN

1014:
1015: */
1016:
1017: --***********Removal Date *************--
1018: IF (p_x_parts_rec.Removal_date is null or p_x_parts_rec.Removal_date = FND_API.G_MISS_DATE) THEN
1019:
1020: p_x_parts_rec.Removal_date := sysdate;
1021: ELSIF (trunc(p_x_parts_rec.Removal_date) > trunc(sysdate)) THEN
1022: FND_MESSAGE.Set_Name('AHL','AHL_PRD_REMOVAL_DATE_INVALID');

Line 1030: IF (p_x_parts_rec.Installation_Date is null OR p_x_parts_rec.Installation_Date = FND_API.G_MISS_DATE) THEN

1026:
1027:
1028:
1029: --***********Default Installation Date is null *************--
1030: IF (p_x_parts_rec.Installation_Date is null OR p_x_parts_rec.Installation_Date = FND_API.G_MISS_DATE) THEN
1031:
1032: p_x_parts_rec.Installation_Date := sysdate;
1033: END IF;
1034:

Line 1078: WHEN FND_API.G_EXC_ERROR THEN

1074:
1075: END IF;
1076:
1077: EXCEPTION
1078: WHEN FND_API.G_EXC_ERROR THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: WHEN NO_DATA_FOUND THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: -- dbms_output.put_line('No data found');

Line 1079: x_return_status := FND_API.G_RET_STS_ERROR;

1075: END IF;
1076:
1077: EXCEPTION
1078: WHEN FND_API.G_EXC_ERROR THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: WHEN NO_DATA_FOUND THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: -- dbms_output.put_line('No data found');
1083:

Line 1081: x_return_status := FND_API.G_RET_STS_ERROR;

1077: EXCEPTION
1078: WHEN FND_API.G_EXC_ERROR THEN
1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: WHEN NO_DATA_FOUND THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: -- dbms_output.put_line('No data found');
1083:
1084:
1085: END Validate_Part_Record; -- validate_part_record

Line 1345: x_return_status := FND_API.G_RET_STS_SUCCESS;

1341: BEGIN
1342:
1343: -- Initialize API return status to success
1344: FND_MSG_PUB.Initialize;
1345: x_return_status := FND_API.G_RET_STS_SUCCESS;
1346:
1347: l_item_instance_id := p_item_instance_id;
1348:
1349: IF p_workorder_id IS NOT NULL

Line 1371: RAISE FND_API.G_EXC_ERROR;

1367: IF (l_unit_config_status_code = 'DRAFT') THEN
1368: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UC_DRAFT');
1369: FND_MSG_PUB.ADD;
1370: CLOSE ahl_uc_name_csr;
1371: RAISE FND_API.G_EXC_ERROR;
1372: ELSIF ((p_validation_mode = 'PARTS_CHG') AND (l_active_uc_status_code <> 'APPROVED')) THEN
1373: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UC_UNAPPROVED');
1374: FND_MSG_PUB.ADD;
1375: CLOSE ahl_uc_name_csr;

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372: ELSIF ((p_validation_mode = 'PARTS_CHG') AND (l_active_uc_status_code <> 'APPROVED')) THEN
1373: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_UC_UNAPPROVED');
1374: FND_MSG_PUB.ADD;
1375: CLOSE ahl_uc_name_csr;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378: END IF;
1379: CLOSE ahl_uc_name_csr;
1380: END IF;

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385: IF (ahl_location_type_csr%NOTFOUND) THEN
1386: CLOSE ahl_location_type_csr;
1387: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_PC_INST_EXPIRED');
1388: FND_MSG_PUB.ADD;
1389: RAISE FND_API.G_EXC_ERROR;
1390: ELSE
1391: IF (l_location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')) THEN
1392: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_STATUS_INVALID');
1393: FND_MESSAGE.Set_Token('STATUS',l_location_meaning);

Line 1395: RAISE FND_API.G_EXC_ERROR;

1391: IF (l_location_type_code IN ('PO','IN-TRANSIT','PROJECT','INVENTORY')) THEN
1392: FND_MESSAGE.Set_Name('AHL','AHL_PRD_INST_STATUS_INVALID');
1393: FND_MESSAGE.Set_Token('STATUS',l_location_meaning);
1394: FND_MSG_PUB.ADD;
1395: RAISE FND_API.G_EXC_ERROR;
1396: END IF;
1397: END IF;
1398:
1399:

Line 1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1398:
1399:
1400: EXCEPTION
1401: WHEN NO_DATA_FOUND THEN
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403:
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:

Line 1404: WHEN FND_API.G_EXC_ERROR THEN

1400: EXCEPTION
1401: WHEN NO_DATA_FOUND THEN
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403:
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: WHEN OTHERS THEN
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1405: x_return_status := FND_API.G_RET_STS_ERROR;

1401: WHEN NO_DATA_FOUND THEN
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403:
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: WHEN OTHERS THEN
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409:

Line 1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1404: WHEN FND_API.G_EXC_ERROR THEN
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406:
1407: WHEN OTHERS THEN
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409:
1410: END; -- procedure get_unit_config_information
1411: ------------------------------------------
1412:

Line 1423: x_return_status := FND_API.G_RET_STS_SUCCESS;

1419: l_transaction_type_id number;
1420: l_return_val boolean;
1421:
1422: BEGIN
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:
1425: -- csi transaction record.
1426: p_x_csi_transaction_rec.source_transaction_date := sysdate;
1427:

Line 1432: x_return_status := FND_API.G_RET_STS_ERROR;

1428: -- get transaction_type_id .
1429: AHL_Util_UC_Pkg.GetCSI_Transaction_ID('UC_UPDATE',l_transaction_type_id, l_return_val);
1430:
1431: IF NOT(l_return_val) THEN
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433: END IF;
1434:
1435: -- use the transaction id from the header record.
1436: p_x_csi_transaction_rec.transaction_type_id := l_transaction_type_id;

Line 1525: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1521: p_csi_item_instance_id => p_x_parts_rec.removed_instance_id,
1522: x_path_position_id => x_path_position_id);
1523:
1524:
1525: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1526: RAISE FND_API.G_EXC_ERROR;
1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;

Line 1526: RAISE FND_API.G_EXC_ERROR;

1522: x_path_position_id => x_path_position_id);
1523:
1524:
1525: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1526: RAISE FND_API.G_EXC_ERROR;
1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530: l_serialized := FND_API.G_FALSE;

Line 1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1523:
1524:
1525: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1526: RAISE FND_API.G_EXC_ERROR;
1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530: l_serialized := FND_API.G_FALSE;
1531: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);

Line 1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1524:
1525: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1526: RAISE FND_API.G_EXC_ERROR;
1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530: l_serialized := FND_API.G_FALSE;
1531: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);
1532: FETCH check_inst_nonserial INTO l_junk;

Line 1530: l_serialized := FND_API.G_FALSE;

1526: RAISE FND_API.G_EXC_ERROR;
1527: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: END IF;
1530: l_serialized := FND_API.G_FALSE;
1531: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);
1532: FETCH check_inst_nonserial INTO l_junk;
1533: IF(check_inst_nonserial%NOTFOUND)THEN
1534: l_serialized := FND_API.G_TRUE;

Line 1534: l_serialized := FND_API.G_TRUE;

1530: l_serialized := FND_API.G_FALSE;
1531: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);
1532: FETCH check_inst_nonserial INTO l_junk;
1533: IF(check_inst_nonserial%NOTFOUND)THEN
1534: l_serialized := FND_API.G_TRUE;
1535: END IF;
1536: CLOSE check_inst_nonserial;
1537:
1538: IF( l_serialized = FND_API.G_FALSE) THEN

Line 1538: IF( l_serialized = FND_API.G_FALSE) THEN

1534: l_serialized := FND_API.G_TRUE;
1535: END IF;
1536: CLOSE check_inst_nonserial;
1537:
1538: IF( l_serialized = FND_API.G_FALSE) THEN
1539: OPEN get_curr_quantity_csr(p_x_parts_rec.Removed_Instance_Id);
1540: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
1541: CLOSE get_curr_quantity_csr;
1542: END IF;

Line 1544: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN

1540: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
1541: CLOSE get_curr_quantity_csr;
1542: END IF;
1543: --Call remove_instance
1544: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
1545: AHL_UC_INSTANCE_PVT.remove_instance(
1546: p_api_version => 1.0,
1547: p_init_msg_list => FND_API.G_TRUE,
1548: p_commit => FND_API.G_FALSE,

Line 1547: p_init_msg_list => FND_API.G_TRUE,

1543: --Call remove_instance
1544: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
1545: AHL_UC_INSTANCE_PVT.remove_instance(
1546: p_api_version => 1.0,
1547: p_init_msg_list => FND_API.G_TRUE,
1548: p_commit => FND_API.G_FALSE,
1549: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1550: x_return_status => x_return_status,
1551: x_msg_count => l_msg_count,

Line 1548: p_commit => FND_API.G_FALSE,

1544: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
1545: AHL_UC_INSTANCE_PVT.remove_instance(
1546: p_api_version => 1.0,
1547: p_init_msg_list => FND_API.G_TRUE,
1548: p_commit => FND_API.G_FALSE,
1549: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1550: x_return_status => x_return_status,
1551: x_msg_count => l_msg_count,
1552: x_msg_data => l_msg_data,

Line 1549: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1545: AHL_UC_INSTANCE_PVT.remove_instance(
1546: p_api_version => 1.0,
1547: p_init_msg_list => FND_API.G_TRUE,
1548: p_commit => FND_API.G_FALSE,
1549: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1550: x_return_status => x_return_status,
1551: x_msg_count => l_msg_count,
1552: x_msg_data => l_msg_data,
1553: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1559: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1555: p_csi_ii_ovn => p_x_parts_rec.CSI_II_OBJECT_VERSION_NUM,
1556: p_prod_user_flag => 'Y');
1557:
1558:
1559: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1560: RAISE FND_API.G_EXC_ERROR;
1561: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;

Line 1560: RAISE FND_API.G_EXC_ERROR;

1556: p_prod_user_flag => 'Y');
1557:
1558:
1559: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1560: RAISE FND_API.G_EXC_ERROR;
1561: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;
1564:

Line 1561: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1557:
1558:
1559: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1560: RAISE FND_API.G_EXC_ERROR;
1561: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;
1564:
1565: update_item_location(

Line 1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1558:
1559: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1560: RAISE FND_API.G_EXC_ERROR;
1561: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END IF;
1564:
1565: update_item_location(
1566: p_x_parts_rec => p_x_parts_rec,

Line 1569: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1565: update_item_location(
1566: p_x_parts_rec => p_x_parts_rec,
1567: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1568: x_return_status => x_return_status);
1569: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1573: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566: p_x_parts_rec => p_x_parts_rec,
1567: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1568: x_return_status => x_return_status);
1569: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1573: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
1574: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;

Line 1578: P_Init_Msg_List => Fnd_API.G_False,

1574: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
1575:
1576: move_instance_location(
1577: P_API_Version => 1.0,
1578: P_Init_Msg_List => Fnd_API.G_False,
1579: P_Commit => Fnd_API.G_False,
1580: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1581: p_module_type => 'API',
1582: p_default => FND_API.G_TRUE,

Line 1579: P_Commit => Fnd_API.G_False,

1575:
1576: move_instance_location(
1577: P_API_Version => 1.0,
1578: P_Init_Msg_List => Fnd_API.G_False,
1579: P_Commit => Fnd_API.G_False,
1580: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1581: p_module_type => 'API',
1582: p_default => FND_API.G_TRUE,
1583: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 1580: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

1576: move_instance_location(
1577: P_API_Version => 1.0,
1578: P_Init_Msg_List => Fnd_API.G_False,
1579: P_Commit => Fnd_API.G_False,
1580: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1581: p_module_type => 'API',
1582: p_default => FND_API.G_TRUE,
1583: p_move_item_instance_tbl => l_move_item_instance_tbl,
1584: x_return_status => x_return_status,

Line 1582: p_default => FND_API.G_TRUE,

1578: P_Init_Msg_List => Fnd_API.G_False,
1579: P_Commit => Fnd_API.G_False,
1580: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1581: p_module_type => 'API',
1582: p_default => FND_API.G_TRUE,
1583: p_move_item_instance_tbl => l_move_item_instance_tbl,
1584: x_return_status => x_return_status,
1585: x_msg_count => l_msg_count,
1586: x_msg_data => l_msg_data);

Line 1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1583: p_move_item_instance_tbl => l_move_item_instance_tbl,
1584: x_return_status => x_return_status,
1585: x_msg_count => l_msg_count,
1586: x_msg_data => l_msg_data);
1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1588: RAISE FND_API.G_EXC_ERROR;
1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;

Line 1588: RAISE FND_API.G_EXC_ERROR;

1584: x_return_status => x_return_status,
1585: x_msg_count => l_msg_count,
1586: x_msg_data => l_msg_data);
1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1588: RAISE FND_API.G_EXC_ERROR;
1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592: IF( l_serialized = FND_API.G_FALSE)THEN

Line 1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1585: x_msg_count => l_msg_count,
1586: x_msg_data => l_msg_data);
1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1588: RAISE FND_API.G_EXC_ERROR;
1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592: IF( l_serialized = FND_API.G_FALSE)THEN
1593: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);

Line 1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1586: x_msg_data => l_msg_data);
1587: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1588: RAISE FND_API.G_EXC_ERROR;
1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592: IF( l_serialized = FND_API.G_FALSE)THEN
1593: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
1594: FETCH removal_instance_id INTO l_final_removed_inst_id;

Line 1592: IF( l_serialized = FND_API.G_FALSE)THEN

1588: RAISE FND_API.G_EXC_ERROR;
1589: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592: IF( l_serialized = FND_API.G_FALSE)THEN
1593: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
1594: FETCH removal_instance_id INTO l_final_removed_inst_id;
1595: IF(removal_instance_id%FOUND)THEN
1596: p_x_parts_rec.Removed_Instance_Id := l_final_removed_inst_id;

Line 1609: p_init_msg_list => FND_API.G_TRUE,

1605: ELSE -- non-serialized incomplete removal
1606:
1607: AHL_UC_INSTANCE_PVT.remove_instance(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: x_return_status => x_return_status,
1613: x_msg_count => l_msg_count,

Line 1610: p_commit => FND_API.G_FALSE,

1606:
1607: AHL_UC_INSTANCE_PVT.remove_instance(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: x_return_status => x_return_status,
1613: x_msg_count => l_msg_count,
1614: x_msg_data => l_msg_data,

Line 1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1607: AHL_UC_INSTANCE_PVT.remove_instance(
1608: p_api_version => 1.0,
1609: p_init_msg_list => FND_API.G_TRUE,
1610: p_commit => FND_API.G_FALSE,
1611: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1612: x_return_status => x_return_status,
1613: x_msg_count => l_msg_count,
1614: x_msg_data => l_msg_data,
1615: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1621: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1617: p_csi_ii_ovn => p_x_parts_rec.CSI_II_OBJECT_VERSION_NUM,
1618: p_prod_user_flag => 'Y');
1619:
1620:
1621: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1622: RAISE FND_API.G_EXC_ERROR;
1623: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;

Line 1622: RAISE FND_API.G_EXC_ERROR;

1618: p_prod_user_flag => 'Y');
1619:
1620:
1621: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1622: RAISE FND_API.G_EXC_ERROR;
1623: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:

Line 1623: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1619:
1620:
1621: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1622: RAISE FND_API.G_EXC_ERROR;
1623: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: update_item_location(

Line 1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1620:
1621: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1622: RAISE FND_API.G_EXC_ERROR;
1623: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: update_item_location(
1628: p_x_parts_rec => p_x_parts_rec,

Line 1647: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1643: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1644: x_return_status => x_return_status
1645: );
1646:
1647: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1648: RAISE FND_API.G_EXC_ERROR;
1649: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651: END IF;

Line 1648: RAISE FND_API.G_EXC_ERROR;

1644: x_return_status => x_return_status
1645: );
1646:
1647: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1648: RAISE FND_API.G_EXC_ERROR;
1649: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651: END IF;
1652: --create same instance with removed qty

Line 1649: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1645: );
1646:
1647: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1648: RAISE FND_API.G_EXC_ERROR;
1649: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651: END IF;
1652: --create same instance with removed qty
1653: create_similar_instance(

Line 1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1646:
1647: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1648: RAISE FND_API.G_EXC_ERROR;
1649: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1651: END IF;
1652: --create same instance with removed qty
1653: create_similar_instance(
1654: p_source_instance_id => p_x_parts_rec.Removed_Instance_Id,

Line 1661: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1657: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1658: x_dest_instance_id => l_dest_instance_id,
1659: x_return_status => x_return_status
1660: );
1661: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1662: RAISE FND_API.G_EXC_ERROR;
1663: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;

Line 1662: RAISE FND_API.G_EXC_ERROR;

1658: x_dest_instance_id => l_dest_instance_id,
1659: x_return_status => x_return_status
1660: );
1661: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1662: RAISE FND_API.G_EXC_ERROR;
1663: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:

Line 1663: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1659: x_return_status => x_return_status
1660: );
1661: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1662: RAISE FND_API.G_EXC_ERROR;
1663: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:
1667: --Call install_existing_instance

Line 1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1660: );
1661: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1662: RAISE FND_API.G_EXC_ERROR;
1663: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1665: END IF;
1666:
1667: --Call install_existing_instance
1668: AHL_UC_INSTANCE_PVT.install_existing_instance(

Line 1670: p_init_msg_list => FND_API.G_TRUE,

1666:
1667: --Call install_existing_instance
1668: AHL_UC_INSTANCE_PVT.install_existing_instance(
1669: p_api_version => 1.0,
1670: p_init_msg_list => FND_API.G_TRUE,
1671: p_commit => FND_API.G_FALSE,
1672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1673: x_return_status => x_return_status,
1674: x_msg_count => l_msg_count,

Line 1671: p_commit => FND_API.G_FALSE,

1667: --Call install_existing_instance
1668: AHL_UC_INSTANCE_PVT.install_existing_instance(
1669: p_api_version => 1.0,
1670: p_init_msg_list => FND_API.G_TRUE,
1671: p_commit => FND_API.G_FALSE,
1672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1673: x_return_status => x_return_status,
1674: x_msg_count => l_msg_count,
1675: x_msg_data => l_msg_data,

Line 1672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1668: AHL_UC_INSTANCE_PVT.install_existing_instance(
1669: p_api_version => 1.0,
1670: p_init_msg_list => FND_API.G_TRUE,
1671: p_commit => FND_API.G_FALSE,
1672: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1673: x_return_status => x_return_status,
1674: x_msg_count => l_msg_count,
1675: x_msg_data => l_msg_data,
1676: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1685: IF G_DEBUG = 'Y' THEN
1686: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1687: END IF;
1688:
1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;

Line 1690: RAISE FND_API.G_EXC_ERROR;

1686: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1687: END IF;
1688:
1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:

Line 1691: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1687: END IF;
1688:
1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;

Line 1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1688:
1689: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1690: RAISE FND_API.G_EXC_ERROR;
1691: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
1696: IF G_DEBUG = 'Y' THEN

Line 1703: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1699: /*update_item_location(
1700: p_x_parts_rec => p_x_parts_rec,
1701: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1702: x_return_status => x_return_status);
1703: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;*/
1706:
1707: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;

Line 1704: RAISE FND_API.G_EXC_ERROR;

1700: p_x_parts_rec => p_x_parts_rec,
1701: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1702: x_return_status => x_return_status);
1703: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;*/
1706:
1707: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
1708: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;

Line 1715: P_Init_Msg_List => Fnd_API.G_False,

1711: AHL_DEBUG_PUB.debug('moving it');
1712: END IF;
1713: move_instance_location(
1714: P_API_Version => 1.0,
1715: P_Init_Msg_List => Fnd_API.G_False,
1716: P_Commit => Fnd_API.G_False,
1717: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1718: p_module_type => 'API',
1719: p_default => FND_API.G_TRUE,

Line 1716: P_Commit => Fnd_API.G_False,

1712: END IF;
1713: move_instance_location(
1714: P_API_Version => 1.0,
1715: P_Init_Msg_List => Fnd_API.G_False,
1716: P_Commit => Fnd_API.G_False,
1717: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1718: p_module_type => 'API',
1719: p_default => FND_API.G_TRUE,
1720: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 1717: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

1713: move_instance_location(
1714: P_API_Version => 1.0,
1715: P_Init_Msg_List => Fnd_API.G_False,
1716: P_Commit => Fnd_API.G_False,
1717: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1718: p_module_type => 'API',
1719: p_default => FND_API.G_TRUE,
1720: p_move_item_instance_tbl => l_move_item_instance_tbl,
1721: x_return_status => x_return_status,

Line 1719: p_default => FND_API.G_TRUE,

1715: P_Init_Msg_List => Fnd_API.G_False,
1716: P_Commit => Fnd_API.G_False,
1717: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1718: p_module_type => 'API',
1719: p_default => FND_API.G_TRUE,
1720: p_move_item_instance_tbl => l_move_item_instance_tbl,
1721: x_return_status => x_return_status,
1722: x_msg_count => l_msg_count,
1723: x_msg_data => l_msg_data);

Line 1724: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1720: p_move_item_instance_tbl => l_move_item_instance_tbl,
1721: x_return_status => x_return_status,
1722: x_msg_count => l_msg_count,
1723: x_msg_data => l_msg_data);
1724: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: END IF;

Line 1725: RAISE FND_API.G_EXC_ERROR;

1721: x_return_status => x_return_status,
1722: x_msg_count => l_msg_count,
1723: x_msg_data => l_msg_data);
1724: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: END IF;
1729:

Line 1726: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1722: x_msg_count => l_msg_count,
1723: x_msg_data => l_msg_data);
1724: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: END IF;
1729:
1730: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);

Line 1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1723: x_msg_data => l_msg_data);
1724: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1725: RAISE FND_API.G_EXC_ERROR;
1726: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: END IF;
1729:
1730: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
1731: FETCH removal_instance_id INTO l_final_removed_inst_id;

Line 1750: l_serialized := FND_API.G_FALSE;

1746: IF G_DEBUG = 'Y' THEN
1747: AHL_DEBUG_PUB.debug('Before making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1748: END IF;
1749:
1750: l_serialized := FND_API.G_FALSE;
1751: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);
1752: FETCH check_inst_nonserial INTO l_junk;
1753: IF(check_inst_nonserial%NOTFOUND)THEN
1754: l_serialized := FND_API.G_TRUE;

Line 1754: l_serialized := FND_API.G_TRUE;

1750: l_serialized := FND_API.G_FALSE;
1751: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);
1752: FETCH check_inst_nonserial INTO l_junk;
1753: IF(check_inst_nonserial%NOTFOUND)THEN
1754: l_serialized := FND_API.G_TRUE;
1755: END IF;
1756: CLOSE check_inst_nonserial;
1757:
1758: l_curr_config_qty := 0;

Line 1759: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Removed_Instance_Id IS NOT NULL) THEN

1755: END IF;
1756: CLOSE check_inst_nonserial;
1757:
1758: l_curr_config_qty := 0;
1759: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Removed_Instance_Id IS NOT NULL) THEN
1760: OPEN get_curr_quantity_csr(p_x_parts_rec.Removed_Instance_Id);
1761: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
1762: CLOSE get_curr_quantity_csr;
1763: END IF;

Line 1765: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Installed_Instance_Id IS NOT NULL) THEN

1761: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
1762: CLOSE get_curr_quantity_csr;
1763: END IF;
1764:
1765: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Installed_Instance_Id IS NOT NULL) THEN
1766: OPEN get_curr_quantity_csr(p_x_parts_rec.Installed_Instance_Id);
1767: FETCH get_curr_quantity_csr INTO l_curr_job_qty;
1768: CLOSE get_curr_quantity_csr;
1769: END IF;

Line 1771: IF( l_serialized = FND_API.G_FALSE

1767: FETCH get_curr_quantity_csr INTO l_curr_job_qty;
1768: CLOSE get_curr_quantity_csr;
1769: END IF;
1770:
1771: IF( l_serialized = FND_API.G_FALSE
1772: AND l_curr_job_qty <> p_x_parts_rec.Installed_Quantity AND l_curr_config_qty = 0)THEN
1773: -- create new instance with remaining qty
1774: l_remaining_qty := l_curr_job_qty - p_x_parts_rec.Installed_Quantity;
1775: create_similar_instance(

Line 1783: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1779: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1780: x_dest_instance_id => l_dest_instance_id,
1781: x_return_status => x_return_status
1782: );
1783: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1784: RAISE FND_API.G_EXC_ERROR;
1785: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;

Line 1784: RAISE FND_API.G_EXC_ERROR;

1780: x_dest_instance_id => l_dest_instance_id,
1781: x_return_status => x_return_status
1782: );
1783: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1784: RAISE FND_API.G_EXC_ERROR;
1785: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: -- update installed instance qty to equal to installed qty

Line 1785: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1781: x_return_status => x_return_status
1782: );
1783: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1784: RAISE FND_API.G_EXC_ERROR;
1785: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: -- update installed instance qty to equal to installed qty
1789: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;

Line 1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1782: );
1783: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1784: RAISE FND_API.G_EXC_ERROR;
1785: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1787: END IF;
1788: -- update installed instance qty to equal to installed qty
1789: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;
1790: l_instance_rec.quantity := p_x_parts_rec.Installed_Quantity;

Line 1801: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1797: p_instance_rec => l_instance_rec,
1798: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1799: x_return_status => x_return_status
1800: );
1801: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1802: RAISE FND_API.G_EXC_ERROR;
1803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1805: END IF;

Line 1802: RAISE FND_API.G_EXC_ERROR;

1798: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1799: x_return_status => x_return_status
1800: );
1801: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1802: RAISE FND_API.G_EXC_ERROR;
1803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1805: END IF;
1806: END IF;

Line 1803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1799: x_return_status => x_return_status
1800: );
1801: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1802: RAISE FND_API.G_EXC_ERROR;
1803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1805: END IF;
1806: END IF;
1807:

Line 1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1800: );
1801: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1802: RAISE FND_API.G_EXC_ERROR;
1803: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1805: END IF;
1806: END IF;
1807:
1808:

Line 1809: IF( l_serialized = FND_API.G_TRUE OR l_curr_config_qty = 0) THEN

1805: END IF;
1806: END IF;
1807:
1808:
1809: IF( l_serialized = FND_API.G_TRUE OR l_curr_config_qty = 0) THEN
1810: --Call install_existing_instance
1811: AHL_UC_INSTANCE_PVT.install_existing_instance(
1812: p_api_version => 1.0,
1813: p_init_msg_list => FND_API.G_TRUE,

Line 1813: p_init_msg_list => FND_API.G_TRUE,

1809: IF( l_serialized = FND_API.G_TRUE OR l_curr_config_qty = 0) THEN
1810: --Call install_existing_instance
1811: AHL_UC_INSTANCE_PVT.install_existing_instance(
1812: p_api_version => 1.0,
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_commit => FND_API.G_FALSE,
1815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1816: x_return_status => x_return_status,
1817: x_msg_count => l_msg_count,

Line 1814: p_commit => FND_API.G_FALSE,

1810: --Call install_existing_instance
1811: AHL_UC_INSTANCE_PVT.install_existing_instance(
1812: p_api_version => 1.0,
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_commit => FND_API.G_FALSE,
1815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1816: x_return_status => x_return_status,
1817: x_msg_count => l_msg_count,
1818: x_msg_data => l_msg_data,

Line 1815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1811: AHL_UC_INSTANCE_PVT.install_existing_instance(
1812: p_api_version => 1.0,
1813: p_init_msg_list => FND_API.G_TRUE,
1814: p_commit => FND_API.G_FALSE,
1815: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1816: x_return_status => x_return_status,
1817: x_msg_count => l_msg_count,
1818: x_msg_data => l_msg_data,
1819: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1828: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1824: p_csi_ii_ovn => p_x_parts_rec.CSI_II_OBJECT_VERSION_NUM,
1825: p_prod_user_flag => 'Y',
1826: x_warning_msg_tbl => x_warning_msg_tbl);
1827:
1828: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;

Line 1829: RAISE FND_API.G_EXC_ERROR;

1825: p_prod_user_flag => 'Y',
1826: x_warning_msg_tbl => x_warning_msg_tbl);
1827:
1828: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:

Line 1830: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1826: x_warning_msg_tbl => x_warning_msg_tbl);
1827:
1828: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: IF G_DEBUG = 'Y' THEN

Line 1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1827:
1828: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1829: RAISE FND_API.G_EXC_ERROR;
1830: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: IF G_DEBUG = 'Y' THEN
1835: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

Line 1837: ELSIF( l_serialized = FND_API.G_FALSE AND l_curr_config_qty <> 0) THEN

1833:
1834: IF G_DEBUG = 'Y' THEN
1835: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');
1836: END IF;
1837: ELSIF( l_serialized = FND_API.G_FALSE AND l_curr_config_qty <> 0) THEN
1838: AHL_UC_INSTANCE_PVT.remove_instance(
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_TRUE,
1841: p_commit => FND_API.G_FALSE,

Line 1840: p_init_msg_list => FND_API.G_TRUE,

1836: END IF;
1837: ELSIF( l_serialized = FND_API.G_FALSE AND l_curr_config_qty <> 0) THEN
1838: AHL_UC_INSTANCE_PVT.remove_instance(
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_TRUE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => x_return_status,
1844: x_msg_count => l_msg_count,

Line 1841: p_commit => FND_API.G_FALSE,

1837: ELSIF( l_serialized = FND_API.G_FALSE AND l_curr_config_qty <> 0) THEN
1838: AHL_UC_INSTANCE_PVT.remove_instance(
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_TRUE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => x_return_status,
1844: x_msg_count => l_msg_count,
1845: x_msg_data => l_msg_data,

Line 1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1838: AHL_UC_INSTANCE_PVT.remove_instance(
1839: p_api_version => 1.0,
1840: p_init_msg_list => FND_API.G_TRUE,
1841: p_commit => FND_API.G_FALSE,
1842: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1843: x_return_status => x_return_status,
1844: x_msg_count => l_msg_count,
1845: x_msg_data => l_msg_data,
1846: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1852: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1848: p_csi_ii_ovn => p_x_parts_rec.CSI_II_OBJECT_VERSION_NUM,
1849: p_prod_user_flag => 'Y');
1850:
1851:
1852: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;

Line 1853: RAISE FND_API.G_EXC_ERROR;

1849: p_prod_user_flag => 'Y');
1850:
1851:
1852: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:

Line 1854: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1850:
1851:
1852: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:
1858: update_item_location(

Line 1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1851:
1852: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857:
1858: update_item_location(
1859: p_x_parts_rec => p_x_parts_rec,

Line 1871: P_Init_Msg_List => Fnd_API.G_False,

1867: AHL_DEBUG_PUB.debug('moving it');
1868: END IF;
1869: move_instance_location(
1870: P_API_Version => 1.0,
1871: P_Init_Msg_List => Fnd_API.G_False,
1872: P_Commit => Fnd_API.G_False,
1873: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1874: p_module_type => 'API',
1875: p_default => FND_API.G_TRUE,

Line 1872: P_Commit => Fnd_API.G_False,

1868: END IF;
1869: move_instance_location(
1870: P_API_Version => 1.0,
1871: P_Init_Msg_List => Fnd_API.G_False,
1872: P_Commit => Fnd_API.G_False,
1873: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1874: p_module_type => 'API',
1875: p_default => FND_API.G_TRUE,
1876: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 1873: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

1869: move_instance_location(
1870: P_API_Version => 1.0,
1871: P_Init_Msg_List => Fnd_API.G_False,
1872: P_Commit => Fnd_API.G_False,
1873: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1874: p_module_type => 'API',
1875: p_default => FND_API.G_TRUE,
1876: p_move_item_instance_tbl => l_move_item_instance_tbl,
1877: x_return_status => x_return_status,

Line 1875: p_default => FND_API.G_TRUE,

1871: P_Init_Msg_List => Fnd_API.G_False,
1872: P_Commit => Fnd_API.G_False,
1873: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
1874: p_module_type => 'API',
1875: p_default => FND_API.G_TRUE,
1876: p_move_item_instance_tbl => l_move_item_instance_tbl,
1877: x_return_status => x_return_status,
1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data);

Line 1880: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1876: p_move_item_instance_tbl => l_move_item_instance_tbl,
1877: x_return_status => x_return_status,
1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data);
1880: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;

Line 1881: RAISE FND_API.G_EXC_ERROR;

1877: x_return_status => x_return_status,
1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data);
1880: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: -- create new instance with net qty on job

Line 1882: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1878: x_msg_count => l_msg_count,
1879: x_msg_data => l_msg_data);
1880: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: -- create new instance with net qty on job
1886: l_remaining_qty := l_curr_job_qty - p_x_parts_rec.Installed_Quantity;

Line 1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1879: x_msg_data => l_msg_data);
1880: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: -- create new instance with net qty on job
1886: l_remaining_qty := l_curr_job_qty - p_x_parts_rec.Installed_Quantity;
1887:

Line 1905: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1901: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1902: x_dest_instance_id => l_dest_instance_id,
1903: x_return_status => x_return_status
1904: );
1905: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;

Line 1906: RAISE FND_API.G_EXC_ERROR;

1902: x_dest_instance_id => l_dest_instance_id,
1903: x_return_status => x_return_status
1904: );
1905: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910: END IF;

Line 1907: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1903: x_return_status => x_return_status
1904: );
1905: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910: END IF;
1911: -- now install the previously removed instance back

Line 1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1904: );
1905: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1906: RAISE FND_API.G_EXC_ERROR;
1907: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1909: END IF;
1910: END IF;
1911: -- now install the previously removed instance back
1912: p_x_parts_rec.Installed_Instance_Id := p_x_parts_rec.Removed_Instance_Id;

Line 1926: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1922: p_instance_rec => l_instance_rec,
1923: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1924: x_return_status => x_return_status
1925: );
1926: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1927: RAISE FND_API.G_EXC_ERROR;
1928: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: END IF;

Line 1927: RAISE FND_API.G_EXC_ERROR;

1923: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1924: x_return_status => x_return_status
1925: );
1926: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1927: RAISE FND_API.G_EXC_ERROR;
1928: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: END IF;
1931: -- install the instance back

Line 1928: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1924: x_return_status => x_return_status
1925: );
1926: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1927: RAISE FND_API.G_EXC_ERROR;
1928: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: END IF;
1931: -- install the instance back
1932: AHL_UC_INSTANCE_PVT.install_existing_instance(

Line 1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1925: );
1926: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1927: RAISE FND_API.G_EXC_ERROR;
1928: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: END IF;
1931: -- install the instance back
1932: AHL_UC_INSTANCE_PVT.install_existing_instance(
1933: p_api_version => 1.0,

Line 1934: p_init_msg_list => FND_API.G_TRUE,

1930: END IF;
1931: -- install the instance back
1932: AHL_UC_INSTANCE_PVT.install_existing_instance(
1933: p_api_version => 1.0,
1934: p_init_msg_list => FND_API.G_TRUE,
1935: p_commit => FND_API.G_FALSE,
1936: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1937: x_return_status => x_return_status,
1938: x_msg_count => l_msg_count,

Line 1935: p_commit => FND_API.G_FALSE,

1931: -- install the instance back
1932: AHL_UC_INSTANCE_PVT.install_existing_instance(
1933: p_api_version => 1.0,
1934: p_init_msg_list => FND_API.G_TRUE,
1935: p_commit => FND_API.G_FALSE,
1936: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1937: x_return_status => x_return_status,
1938: x_msg_count => l_msg_count,
1939: x_msg_data => l_msg_data,

Line 1936: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1932: AHL_UC_INSTANCE_PVT.install_existing_instance(
1933: p_api_version => 1.0,
1934: p_init_msg_list => FND_API.G_TRUE,
1935: p_commit => FND_API.G_FALSE,
1936: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1937: x_return_status => x_return_status,
1938: x_msg_count => l_msg_count,
1939: x_msg_data => l_msg_data,
1940: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1949: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1945: p_csi_ii_ovn => p_x_parts_rec.CSI_II_OBJECT_VERSION_NUM,
1946: p_prod_user_flag => 'Y',
1947: x_warning_msg_tbl => x_warning_msg_tbl);
1948:
1949: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1950: RAISE FND_API.G_EXC_ERROR;
1951: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;

Line 1950: RAISE FND_API.G_EXC_ERROR;

1946: p_prod_user_flag => 'Y',
1947: x_warning_msg_tbl => x_warning_msg_tbl);
1948:
1949: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1950: RAISE FND_API.G_EXC_ERROR;
1951: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:

Line 1951: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1947: x_warning_msg_tbl => x_warning_msg_tbl);
1948:
1949: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1950: RAISE FND_API.G_EXC_ERROR;
1951: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:
1955: IF G_DEBUG = 'Y' THEN

Line 1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1948:
1949: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1950: RAISE FND_API.G_EXC_ERROR;
1951: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953: END IF;
1954:
1955: IF G_DEBUG = 'Y' THEN
1956: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.install_existing_instance.');

Line 1968: p_init_msg_list => FND_API.G_TRUE,

1964: END IF;
1965: --Call swap_instance
1966: AHL_UC_INSTANCE_PVT.swap_instance(
1967: p_api_version => 1.0,
1968: p_init_msg_list => FND_API.G_TRUE,
1969: p_commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: x_return_status => x_return_status,
1972: x_msg_count => l_msg_count,

Line 1969: p_commit => FND_API.G_FALSE,

1965: --Call swap_instance
1966: AHL_UC_INSTANCE_PVT.swap_instance(
1967: p_api_version => 1.0,
1968: p_init_msg_list => FND_API.G_TRUE,
1969: p_commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: x_return_status => x_return_status,
1972: x_msg_count => l_msg_count,
1973: x_msg_data => l_msg_data,

Line 1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1966: AHL_UC_INSTANCE_PVT.swap_instance(
1967: p_api_version => 1.0,
1968: p_init_msg_list => FND_API.G_TRUE,
1969: p_commit => FND_API.G_FALSE,
1970: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1971: x_return_status => x_return_status,
1972: x_msg_count => l_msg_count,
1973: x_msg_data => l_msg_data,
1974: p_uc_header_id => p_x_parts_rec.unit_config_header_id,

Line 1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1984: IF G_DEBUG = 'Y' THEN
1985: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
1986: END IF;
1987:
1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;

Line 1989: RAISE FND_API.G_EXC_ERROR;

1985: AHL_DEBUG_PUB.debug('After making a call to AHL_UC_INSTANCE_PVT.swap_instance.');
1986: END IF;
1987:
1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:

Line 1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1986: END IF;
1987:
1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: update_item_location(

Line 1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1987:
1988: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: END IF;
1993:
1994: update_item_location(
1995: p_x_parts_rec => p_x_parts_rec,

Line 1999: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

1995: p_x_parts_rec => p_x_parts_rec,
1996: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1997: x_return_status => x_return_status);
1998:
1999: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2000: RAISE FND_API.G_EXC_ERROR;
2001: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;

Line 2000: RAISE FND_API.G_EXC_ERROR;

1996: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
1997: x_return_status => x_return_status);
1998:
1999: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2000: RAISE FND_API.G_EXC_ERROR;
2001: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:

Line 2001: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1997: x_return_status => x_return_status);
1998:
1999: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2000: RAISE FND_API.G_EXC_ERROR;
2001: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;

Line 2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1998:
1999: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2000: RAISE FND_API.G_EXC_ERROR;
2001: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2006: l_move_item_instance_tbl(1).quantity := 1;

Line 2011: P_Init_Msg_List => Fnd_API.G_False,

2007: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2008: -- move removed item to work order's locator
2009: move_instance_location(
2010: P_API_Version => 1.0,
2011: P_Init_Msg_List => Fnd_API.G_False,
2012: P_Commit => Fnd_API.G_False,
2013: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2014: p_module_type => 'API',
2015: p_default => FND_API.G_TRUE,

Line 2012: P_Commit => Fnd_API.G_False,

2008: -- move removed item to work order's locator
2009: move_instance_location(
2010: P_API_Version => 1.0,
2011: P_Init_Msg_List => Fnd_API.G_False,
2012: P_Commit => Fnd_API.G_False,
2013: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2014: p_module_type => 'API',
2015: p_default => FND_API.G_TRUE,
2016: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 2013: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

2009: move_instance_location(
2010: P_API_Version => 1.0,
2011: P_Init_Msg_List => Fnd_API.G_False,
2012: P_Commit => Fnd_API.G_False,
2013: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2014: p_module_type => 'API',
2015: p_default => FND_API.G_TRUE,
2016: p_move_item_instance_tbl => l_move_item_instance_tbl,
2017: x_return_status => x_return_status,

Line 2015: p_default => FND_API.G_TRUE,

2011: P_Init_Msg_List => Fnd_API.G_False,
2012: P_Commit => Fnd_API.G_False,
2013: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2014: p_module_type => 'API',
2015: p_default => FND_API.G_TRUE,
2016: p_move_item_instance_tbl => l_move_item_instance_tbl,
2017: x_return_status => x_return_status,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data);

Line 2020: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2016: p_move_item_instance_tbl => l_move_item_instance_tbl,
2017: x_return_status => x_return_status,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data);
2020: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;

Line 2021: RAISE FND_API.G_EXC_ERROR;

2017: x_return_status => x_return_status,
2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data);
2020: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:

Line 2022: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2018: x_msg_count => l_msg_count,
2019: x_msg_data => l_msg_data);
2020: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: END IF;

Line 2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2019: x_msg_data => l_msg_data);
2020: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2021: RAISE FND_API.G_EXC_ERROR;
2022: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024: END IF;
2025:
2026: END IF;
2027:

Line 2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2041: AHL_DEBUG_PUB.debug('p_x_parts_rec.Installed_Instance_Id ' ||p_x_parts_rec.Installed_Instance_Id);
2042: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2043: END IF;
2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;

Line 2046: RAISE FND_API.G_EXC_ERROR;

2042: AHL_DEBUG_PUB.debug('After Install/swap AHL_UC_INSTANCE_PVT' || x_path_position_id);
2043: END IF;
2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:

Line 2047: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2043: END IF;
2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:
2051: END IF;

Line 2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2044:
2045: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2046: RAISE FND_API.G_EXC_ERROR;
2047: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:
2051: END IF;
2052:

Line 2148: ,p_commit => fnd_api.g_false

2144: l_instance_rec.OBJECT_VERSION_NUMBER := p_x_parts_rec.Installed_instance_obj_ver_num;
2145:
2146: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2147: p_api_version =>1.0
2148: ,p_commit => fnd_api.g_false
2149: ,p_init_msg_list => fnd_api.g_false
2150: ,p_validation_level => fnd_api.g_valid_level_full
2151: ,p_instance_rec => l_instance_rec
2152: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl

Line 2149: ,p_init_msg_list => fnd_api.g_false

2145:
2146: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2147: p_api_version =>1.0
2148: ,p_commit => fnd_api.g_false
2149: ,p_init_msg_list => fnd_api.g_false
2150: ,p_validation_level => fnd_api.g_valid_level_full
2151: ,p_instance_rec => l_instance_rec
2152: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
2153: ,p_party_tbl =>l_party_tbl

Line 2150: ,p_validation_level => fnd_api.g_valid_level_full

2146: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2147: p_api_version =>1.0
2148: ,p_commit => fnd_api.g_false
2149: ,p_init_msg_list => fnd_api.g_false
2150: ,p_validation_level => fnd_api.g_valid_level_full
2151: ,p_instance_rec => l_instance_rec
2152: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
2153: ,p_party_tbl =>l_party_tbl
2154: ,p_account_tbl => l_account_tbl

Line 2181: l_serialized := FND_API.G_FALSE;

2177: IF G_DEBUG = 'Y' THEN
2178: AHL_DEBUG_PUB.debug('IB Processing- Create');
2179: END IF;
2180:
2181: l_serialized := FND_API.G_FALSE;
2182: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);
2183: FETCH check_inst_nonserial INTO l_junk;
2184: IF(check_inst_nonserial%NOTFOUND)THEN
2185: l_serialized := FND_API.G_TRUE;

Line 2185: l_serialized := FND_API.G_TRUE;

2181: l_serialized := FND_API.G_FALSE;
2182: OPEN check_inst_nonserial(p_x_parts_rec.Installed_Instance_Id);
2183: FETCH check_inst_nonserial INTO l_junk;
2184: IF(check_inst_nonserial%NOTFOUND)THEN
2185: l_serialized := FND_API.G_TRUE;
2186: END IF;
2187: CLOSE check_inst_nonserial;
2188:
2189: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Installed_Instance_Id IS NOT NULL) THEN

Line 2189: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Installed_Instance_Id IS NOT NULL) THEN

2185: l_serialized := FND_API.G_TRUE;
2186: END IF;
2187: CLOSE check_inst_nonserial;
2188:
2189: IF( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Installed_Instance_Id IS NOT NULL) THEN
2190: OPEN get_curr_quantity_csr(p_x_parts_rec.Installed_Instance_Id);
2191: FETCH get_curr_quantity_csr INTO l_curr_job_qty;
2192: CLOSE get_curr_quantity_csr;
2193: END IF;

Line 2195: IF( l_serialized = FND_API.G_FALSE

2191: FETCH get_curr_quantity_csr INTO l_curr_job_qty;
2192: CLOSE get_curr_quantity_csr;
2193: END IF;
2194:
2195: IF( l_serialized = FND_API.G_FALSE
2196: AND l_curr_job_qty <> p_x_parts_rec.Installed_Quantity)THEN
2197: -- create new instance with remaining qty
2198: l_remaining_qty := l_curr_job_qty - p_x_parts_rec.Installed_Quantity;
2199: create_similar_instance(

Line 2207: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2203: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2204: x_dest_instance_id => l_dest_instance_id,
2205: x_return_status => x_return_status
2206: );
2207: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2208: RAISE FND_API.G_EXC_ERROR;
2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;

Line 2208: RAISE FND_API.G_EXC_ERROR;

2204: x_dest_instance_id => l_dest_instance_id,
2205: x_return_status => x_return_status
2206: );
2207: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2208: RAISE FND_API.G_EXC_ERROR;
2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;
2212: IF G_DEBUG = 'Y' THEN

Line 2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2205: x_return_status => x_return_status
2206: );
2207: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2208: RAISE FND_API.G_EXC_ERROR;
2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;
2212: IF G_DEBUG = 'Y' THEN
2213: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);

Line 2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2206: );
2207: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2208: RAISE FND_API.G_EXC_ERROR;
2209: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2211: END IF;
2212: IF G_DEBUG = 'Y' THEN
2213: AHL_DEBUG_PUB.debug('Sunil 1 p_x_parts_rec.Installed_Instance_Id : ' || p_x_parts_rec.Installed_Instance_Id);
2214: AHL_DEBUG_PUB.debug('Sunil p_x_parts_rec.Installed_Quantity ' || p_x_parts_rec.Installed_Quantity);

Line 2230: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2226: p_instance_rec => l_instance_rec,
2227: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2228: x_return_status => x_return_status
2229: );
2230: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2231: RAISE FND_API.G_EXC_ERROR;
2232: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END IF;

Line 2231: RAISE FND_API.G_EXC_ERROR;

2227: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2228: x_return_status => x_return_status
2229: );
2230: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2231: RAISE FND_API.G_EXC_ERROR;
2232: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END IF;
2235:

Line 2232: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2228: x_return_status => x_return_status
2229: );
2230: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2231: RAISE FND_API.G_EXC_ERROR;
2232: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END IF;
2235:
2236: l_instance_rec.instance_id := NULL;

Line 2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2229: );
2230: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2231: RAISE FND_API.G_EXC_ERROR;
2232: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END IF;
2235:
2236: l_instance_rec.instance_id := NULL;
2237: l_instance_rec.quantity := NULL;

Line 2247: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Instance_Id IS NULL)THEN

2243:
2244: END IF;
2245: END IF;
2246:
2247: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Instance_Id IS NULL)THEN
2248: csi_ii_relationships_pub.create_relationship(
2249: p_api_version => 1.0
2250: ,p_relationship_tbl => l_csi_relationship_tbl
2251: ,p_txn_rec => p_x_csi_transaction_rec

Line 2255: ELSIF ( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Removed_Instance_Id IS NOT NULL)THEN

2251: ,p_txn_rec => p_x_csi_transaction_rec
2252: ,x_return_status => x_return_status
2253: ,x_msg_count => l_msg_count
2254: ,x_msg_data => l_msg_data);
2255: ELSIF ( l_serialized = FND_API.G_FALSE AND p_x_parts_rec.Removed_Instance_Id IS NOT NULL)THEN
2256:
2257: -- update qty for wo to 0
2258: l_instance_rec.instance_id := p_x_parts_rec.Installed_Instance_Id;
2259: l_instance_rec.quantity := 0 ;

Line 2273: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2269: x_return_status => x_return_status
2270: );
2271:
2272:
2273: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;

Line 2274: RAISE FND_API.G_EXC_ERROR;

2270: );
2271:
2272:
2273: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:

Line 2275: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2271:
2272:
2273: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: l_instance_rec.instance_id := NULL;

Line 2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2272:
2273: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: l_instance_rec.instance_id := NULL;
2280: l_instance_rec.quantity := NULL;

Line 2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2314: IF G_DEBUG = 'Y' THEN
2315: AHL_DEBUG_PUB.debug('Sunil : Updated qty on config to : ' || l_instance_rec.quantity);
2316: END IF;
2317:
2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2319: RAISE FND_API.G_EXC_ERROR;
2320: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;

Line 2319: RAISE FND_API.G_EXC_ERROR;

2315: AHL_DEBUG_PUB.debug('Sunil : Updated qty on config to : ' || l_instance_rec.quantity);
2316: END IF;
2317:
2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2319: RAISE FND_API.G_EXC_ERROR;
2320: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323:

Line 2320: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2316: END IF;
2317:
2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2319: RAISE FND_API.G_EXC_ERROR;
2320: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323:
2324: l_instance_rec.instance_id := NULL;

Line 2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2317:
2318: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2319: RAISE FND_API.G_EXC_ERROR;
2320: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2322: END IF;
2323:
2324: l_instance_rec.instance_id := NULL;
2325: l_instance_rec.quantity := NULL;

Line 2349: RAISE FND_API.G_EXC_ERROR;

2345:
2346: IF (l_unit_config_header_name is not null ) then
2347: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_RMV_PRT_INVALID');
2348: FND_MSG_PUB.ADD;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2351:
2352: l_serialized := FND_API.G_FALSE;
2353: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);

Line 2352: l_serialized := FND_API.G_FALSE;

2348: FND_MSG_PUB.ADD;
2349: RAISE FND_API.G_EXC_ERROR;
2350: END IF;
2351:
2352: l_serialized := FND_API.G_FALSE;
2353: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);
2354: FETCH check_inst_nonserial INTO l_junk;
2355: IF(check_inst_nonserial%NOTFOUND)THEN
2356: l_serialized := FND_API.G_TRUE;

Line 2356: l_serialized := FND_API.G_TRUE;

2352: l_serialized := FND_API.G_FALSE;
2353: OPEN check_inst_nonserial(p_x_parts_rec.Removed_Instance_Id);
2354: FETCH check_inst_nonserial INTO l_junk;
2355: IF(check_inst_nonserial%NOTFOUND)THEN
2356: l_serialized := FND_API.G_TRUE;
2357: END IF;
2358: CLOSE check_inst_nonserial;
2359:
2360: IF( l_serialized = FND_API.G_FALSE) THEN

Line 2360: IF( l_serialized = FND_API.G_FALSE) THEN

2356: l_serialized := FND_API.G_TRUE;
2357: END IF;
2358: CLOSE check_inst_nonserial;
2359:
2360: IF( l_serialized = FND_API.G_FALSE) THEN
2361: OPEN get_curr_quantity_csr(p_x_parts_rec.Removed_Instance_Id);
2362: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
2363: CLOSE get_curr_quantity_csr;
2364: END IF;

Line 2366: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN

2362: FETCH get_curr_quantity_csr INTO l_curr_config_qty;
2363: CLOSE get_curr_quantity_csr;
2364: END IF;
2365:
2366: IF( l_serialized = FND_API.G_TRUE OR p_x_parts_rec.Removed_Quantity = l_curr_config_qty)THEN
2367:
2368: csi_ii_relationships_pub.expire_relationship(
2369: p_api_version => 1.0
2370: ,p_relationship_rec => l_csi_relationship_rec

Line 2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2372: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,
2373: ,x_return_status => x_return_status
2374: ,x_msg_count => l_msg_count
2375: ,x_msg_data => l_msg_data );
2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2377: RAISE FND_API.G_EXC_ERROR;
2378: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;

Line 2377: RAISE FND_API.G_EXC_ERROR;

2373: ,x_return_status => x_return_status
2374: ,x_msg_count => l_msg_count
2375: ,x_msg_data => l_msg_data );
2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2377: RAISE FND_API.G_EXC_ERROR;
2378: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;
2381:

Line 2378: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2374: ,x_msg_count => l_msg_count
2375: ,x_msg_data => l_msg_data );
2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2377: RAISE FND_API.G_EXC_ERROR;
2378: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;
2381:
2382: update_item_location(

Line 2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2375: ,x_msg_data => l_msg_data );
2376: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2377: RAISE FND_API.G_EXC_ERROR;
2378: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: END IF;
2381:
2382: update_item_location(
2383: p_x_parts_rec => p_x_parts_rec,

Line 2386: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2382: update_item_location(
2383: p_x_parts_rec => p_x_parts_rec,
2384: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2385: x_return_status => x_return_status);
2386: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2390: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383: p_x_parts_rec => p_x_parts_rec,
2384: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2385: x_return_status => x_return_status);
2386: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2390: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;
2391: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;

Line 2395: P_Init_Msg_List => Fnd_API.G_False,

2391: l_move_item_instance_tbl(1).to_workorder_id := p_x_parts_rec.workorder_id;
2392:
2393: move_instance_location(
2394: P_API_Version => 1.0,
2395: P_Init_Msg_List => Fnd_API.G_False,
2396: P_Commit => Fnd_API.G_False,
2397: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2398: p_module_type => 'API',
2399: p_default => FND_API.G_TRUE,

Line 2396: P_Commit => Fnd_API.G_False,

2392:
2393: move_instance_location(
2394: P_API_Version => 1.0,
2395: P_Init_Msg_List => Fnd_API.G_False,
2396: P_Commit => Fnd_API.G_False,
2397: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2398: p_module_type => 'API',
2399: p_default => FND_API.G_TRUE,
2400: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 2397: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

2393: move_instance_location(
2394: P_API_Version => 1.0,
2395: P_Init_Msg_List => Fnd_API.G_False,
2396: P_Commit => Fnd_API.G_False,
2397: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2398: p_module_type => 'API',
2399: p_default => FND_API.G_TRUE,
2400: p_move_item_instance_tbl => l_move_item_instance_tbl,
2401: x_return_status => x_return_status,

Line 2399: p_default => FND_API.G_TRUE,

2395: P_Init_Msg_List => Fnd_API.G_False,
2396: P_Commit => Fnd_API.G_False,
2397: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2398: p_module_type => 'API',
2399: p_default => FND_API.G_TRUE,
2400: p_move_item_instance_tbl => l_move_item_instance_tbl,
2401: x_return_status => x_return_status,
2402: x_msg_count => l_msg_count,
2403: x_msg_data => l_msg_data);

Line 2404: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2400: p_move_item_instance_tbl => l_move_item_instance_tbl,
2401: x_return_status => x_return_status,
2402: x_msg_count => l_msg_count,
2403: x_msg_data => l_msg_data);
2404: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2405: RAISE FND_API.G_EXC_ERROR;
2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;

Line 2405: RAISE FND_API.G_EXC_ERROR;

2401: x_return_status => x_return_status,
2402: x_msg_count => l_msg_count,
2403: x_msg_data => l_msg_data);
2404: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2405: RAISE FND_API.G_EXC_ERROR;
2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;
2409: IF( l_serialized = FND_API.G_FALSE)THEN

Line 2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2402: x_msg_count => l_msg_count,
2403: x_msg_data => l_msg_data);
2404: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2405: RAISE FND_API.G_EXC_ERROR;
2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;
2409: IF( l_serialized = FND_API.G_FALSE)THEN
2410: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);

Line 2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2403: x_msg_data => l_msg_data);
2404: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2405: RAISE FND_API.G_EXC_ERROR;
2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;
2409: IF( l_serialized = FND_API.G_FALSE)THEN
2410: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
2411: FETCH removal_instance_id INTO l_final_removed_inst_id;

Line 2409: IF( l_serialized = FND_API.G_FALSE)THEN

2405: RAISE FND_API.G_EXC_ERROR;
2406: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;
2409: IF( l_serialized = FND_API.G_FALSE)THEN
2410: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
2411: FETCH removal_instance_id INTO l_final_removed_inst_id;
2412: IF(removal_instance_id%FOUND)THEN
2413: p_x_parts_rec.Removed_Instance_Id := l_final_removed_inst_id;

Line 2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2427: ,x_instance_id_lst=> l_instance_id_lst-- csi_datastructures_pub.id_tbl,
2428: ,x_return_status => x_return_status
2429: ,x_msg_count => l_msg_count
2430: ,x_msg_data => l_msg_data );
2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: END IF;

Line 2432: RAISE FND_API.G_EXC_ERROR;

2428: ,x_return_status => x_return_status
2429: ,x_msg_count => l_msg_count
2430: ,x_msg_data => l_msg_data );
2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: END IF;
2436:

Line 2433: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2429: ,x_msg_count => l_msg_count
2430: ,x_msg_data => l_msg_data );
2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: END IF;
2436:
2437: update_item_location(

Line 2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2430: ,x_msg_data => l_msg_data );
2431: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2432: RAISE FND_API.G_EXC_ERROR;
2433: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: END IF;
2436:
2437: update_item_location(
2438: p_x_parts_rec => p_x_parts_rec,

Line 2457: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2453: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2454: x_return_status => x_return_status
2455: );
2456:
2457: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2458: RAISE FND_API.G_EXC_ERROR;
2459: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;

Line 2458: RAISE FND_API.G_EXC_ERROR;

2454: x_return_status => x_return_status
2455: );
2456:
2457: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2458: RAISE FND_API.G_EXC_ERROR;
2459: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462: l_instance_rec.instance_id := NULL;

Line 2459: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2455: );
2456:
2457: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2458: RAISE FND_API.G_EXC_ERROR;
2459: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462: l_instance_rec.instance_id := NULL;
2463: l_instance_rec.quantity := NULL;

Line 2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2456:
2457: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2458: RAISE FND_API.G_EXC_ERROR;
2459: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462: l_instance_rec.instance_id := NULL;
2463: l_instance_rec.quantity := NULL;
2464: l_instance_rec.object_version_number := NULL;

Line 2474: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2470: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2471: x_dest_instance_id => l_dest_instance_id,
2472: x_return_status => x_return_status
2473: );
2474: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;

Line 2475: RAISE FND_API.G_EXC_ERROR;

2471: x_dest_instance_id => l_dest_instance_id,
2472: x_return_status => x_return_status
2473: );
2474: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:

Line 2476: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2472: x_return_status => x_return_status
2473: );
2474: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:
2480:

Line 2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2473: );
2474: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2475: RAISE FND_API.G_EXC_ERROR;
2476: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2478: END IF;
2479:
2480:
2481: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';

Line 2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2497: IF G_DEBUG = 'Y' THEN
2498: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2499: END IF;
2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;
2503: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: END IF;

Line 2502: RAISE FND_API.G_EXC_ERROR;

2498: AHL_DEBUG_PUB.debug('After making a call to csi_ii_relationships_pub.create_relationship.');
2499: END IF;
2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;
2503: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: END IF;
2506:

Line 2503: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2499: END IF;
2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;
2503: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: END IF;
2506:
2507: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;

Line 2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2500:
2501: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2502: RAISE FND_API.G_EXC_ERROR;
2503: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2505: END IF;
2506:
2507: p_x_parts_rec.Removed_Instance_Id := l_dest_instance_id;
2508: IF G_DEBUG = 'Y' THEN

Line 2515: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2511: /*update_item_location(
2512: p_x_parts_rec => p_x_parts_rec,
2513: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2514: x_return_status => x_return_status);
2515: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;*/
2518:
2519: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;

Line 2516: RAISE FND_API.G_EXC_ERROR;

2512: p_x_parts_rec => p_x_parts_rec,
2513: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2514: x_return_status => x_return_status);
2515: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2516: RAISE FND_API.G_EXC_ERROR;
2517: END IF;*/
2518:
2519: l_move_item_instance_tbl(1).instance_id := p_x_parts_rec.Removed_Instance_Id;
2520: l_move_item_instance_tbl(1).quantity := p_x_parts_rec.Removed_Quantity;

Line 2527: P_Init_Msg_List => Fnd_API.G_False,

2523: AHL_DEBUG_PUB.debug('moving it');
2524: END IF;
2525: move_instance_location(
2526: P_API_Version => 1.0,
2527: P_Init_Msg_List => Fnd_API.G_False,
2528: P_Commit => Fnd_API.G_False,
2529: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2530: p_module_type => 'API',
2531: p_default => FND_API.G_TRUE,

Line 2528: P_Commit => Fnd_API.G_False,

2524: END IF;
2525: move_instance_location(
2526: P_API_Version => 1.0,
2527: P_Init_Msg_List => Fnd_API.G_False,
2528: P_Commit => Fnd_API.G_False,
2529: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2530: p_module_type => 'API',
2531: p_default => FND_API.G_TRUE,
2532: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 2529: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

2525: move_instance_location(
2526: P_API_Version => 1.0,
2527: P_Init_Msg_List => Fnd_API.G_False,
2528: P_Commit => Fnd_API.G_False,
2529: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2530: p_module_type => 'API',
2531: p_default => FND_API.G_TRUE,
2532: p_move_item_instance_tbl => l_move_item_instance_tbl,
2533: x_return_status => x_return_status,

Line 2531: p_default => FND_API.G_TRUE,

2527: P_Init_Msg_List => Fnd_API.G_False,
2528: P_Commit => Fnd_API.G_False,
2529: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2530: p_module_type => 'API',
2531: p_default => FND_API.G_TRUE,
2532: p_move_item_instance_tbl => l_move_item_instance_tbl,
2533: x_return_status => x_return_status,
2534: x_msg_count => l_msg_count,
2535: x_msg_data => l_msg_data);

Line 2536: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2532: p_move_item_instance_tbl => l_move_item_instance_tbl,
2533: x_return_status => x_return_status,
2534: x_msg_count => l_msg_count,
2535: x_msg_data => l_msg_data);
2536: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: END IF;

Line 2537: RAISE FND_API.G_EXC_ERROR;

2533: x_return_status => x_return_status,
2534: x_msg_count => l_msg_count,
2535: x_msg_data => l_msg_data);
2536: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: END IF;
2541:

Line 2538: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2534: x_msg_count => l_msg_count,
2535: x_msg_data => l_msg_data);
2536: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: END IF;
2541:
2542: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);

Line 2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2535: x_msg_data => l_msg_data);
2536: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2537: RAISE FND_API.G_EXC_ERROR;
2538: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2540: END IF;
2541:
2542: OPEN removal_instance_id(p_x_parts_rec.Removed_Instance_Id, l_wip_job_id);
2543: FETCH removal_instance_id INTO l_final_removed_inst_id;

Line 2564: --RAISE FND_API.G_EXC_ERROR;

2560:
2561: IF (l_unit_config_header_name is not null ) then
2562: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_RMV_PRT_INVALID');
2563: FND_MSG_PUB.ADD;
2564: --RAISE FND_API.G_EXC_ERROR;
2565: end if;
2566: IF G_DEBUG = 'Y' THEN
2567: AHL_DEBUG_PUB.debug('IB Processing- Swap');
2568: END IF;

Line 2591: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2587: p_x_parts_rec => p_x_parts_rec,
2588: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2589: x_return_status => x_return_status);
2590:
2591: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2592: RAISE FND_API.G_EXC_ERROR;
2593: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: END IF;

Line 2592: RAISE FND_API.G_EXC_ERROR;

2588: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
2589: x_return_status => x_return_status);
2590:
2591: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2592: RAISE FND_API.G_EXC_ERROR;
2593: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: END IF;
2596:

Line 2593: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2589: x_return_status => x_return_status);
2590:
2591: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2592: RAISE FND_API.G_EXC_ERROR;
2593: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: END IF;
2596:
2597: move_instance_location(

Line 2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2590:
2591: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2592: RAISE FND_API.G_EXC_ERROR;
2593: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: END IF;
2596:
2597: move_instance_location(
2598: P_API_Version => 1.0,

Line 2599: P_Init_Msg_List => Fnd_API.G_False,

2595: END IF;
2596:
2597: move_instance_location(
2598: P_API_Version => 1.0,
2599: P_Init_Msg_List => Fnd_API.G_False,
2600: P_Commit => Fnd_API.G_False,
2601: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2602: p_module_type => 'API',
2603: p_default => FND_API.G_TRUE,

Line 2600: P_Commit => Fnd_API.G_False,

2596:
2597: move_instance_location(
2598: P_API_Version => 1.0,
2599: P_Init_Msg_List => Fnd_API.G_False,
2600: P_Commit => Fnd_API.G_False,
2601: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2602: p_module_type => 'API',
2603: p_default => FND_API.G_TRUE,
2604: p_move_item_instance_tbl => l_move_item_instance_tbl,

Line 2601: P_Validation_Level => Fnd_API.G_Valid_Level_Full,

2597: move_instance_location(
2598: P_API_Version => 1.0,
2599: P_Init_Msg_List => Fnd_API.G_False,
2600: P_Commit => Fnd_API.G_False,
2601: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2602: p_module_type => 'API',
2603: p_default => FND_API.G_TRUE,
2604: p_move_item_instance_tbl => l_move_item_instance_tbl,
2605: x_return_status => x_return_status,

Line 2603: p_default => FND_API.G_TRUE,

2599: P_Init_Msg_List => Fnd_API.G_False,
2600: P_Commit => Fnd_API.G_False,
2601: P_Validation_Level => Fnd_API.G_Valid_Level_Full,
2602: p_module_type => 'API',
2603: p_default => FND_API.G_TRUE,
2604: p_move_item_instance_tbl => l_move_item_instance_tbl,
2605: x_return_status => x_return_status,
2606: x_msg_count => l_msg_count,
2607: x_msg_data => l_msg_data);

Line 2608: IF (x_return_status = FND_API.G_RET_STS_ERROR) then

2604: p_move_item_instance_tbl => l_move_item_instance_tbl,
2605: x_return_status => x_return_status,
2606: x_msg_count => l_msg_count,
2607: x_msg_data => l_msg_data);
2608: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;

Line 2609: RAISE FND_API.G_EXC_ERROR;

2605: x_return_status => x_return_status,
2606: x_msg_count => l_msg_count,
2607: x_msg_data => l_msg_data);
2608: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:

Line 2610: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2606: x_msg_count => l_msg_count,
2607: x_msg_data => l_msg_data);
2608: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:
2614: end if;

Line 2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2607: x_msg_data => l_msg_data);
2608: IF (x_return_status = FND_API.G_RET_STS_ERROR) then
2609: RAISE FND_API.G_EXC_ERROR;
2610: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2612: END IF;
2613:
2614: end if;
2615:

Line 2699: ,p_commit => fnd_api.g_false

2695: CLOSE ahl_wip_location_csr;
2696:
2697: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2698: p_api_version =>1.0
2699: ,p_commit => fnd_api.g_false
2700: ,p_init_msg_list => fnd_api.g_false
2701: ,p_validation_level => fnd_api.g_valid_level_full
2702: ,p_instance_rec => l_instance_rec
2703: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl

Line 2700: ,p_init_msg_list => fnd_api.g_false

2696:
2697: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2698: p_api_version =>1.0
2699: ,p_commit => fnd_api.g_false
2700: ,p_init_msg_list => fnd_api.g_false
2701: ,p_validation_level => fnd_api.g_valid_level_full
2702: ,p_instance_rec => l_instance_rec
2703: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
2704: ,p_party_tbl =>l_party_tbl

Line 2701: ,p_validation_level => fnd_api.g_valid_level_full

2697: CSI_ITEM_INSTANCE_PUB. update_item_instance (
2698: p_api_version =>1.0
2699: ,p_commit => fnd_api.g_false
2700: ,p_init_msg_list => fnd_api.g_false
2701: ,p_validation_level => fnd_api.g_valid_level_full
2702: ,p_instance_rec => l_instance_rec
2703: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
2704: ,p_party_tbl =>l_party_tbl
2705: ,p_account_tbl => l_account_tbl

Line 2830: --IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

2826: x_return_status => x_return_status,
2827: x_msg_count=> l_msg_count,
2828: x_msg_data => l_msg_data );
2829:
2830: --IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
2831: -- p_x_parts_rec.Material_txn_id := l_mtl_txn_tbl(1). Ahl_mtltxn_Id;
2832: --END IF;
2833: END Process_material_txn;
2834:

Line 2914: p_commit => Fnd_Api.g_false,

2910:
2911: --Calling Service Request API--
2912: AHL_PRD_NONROUTINE_PVT.process_nonroutine_job (
2913: p_api_version => 1.0,
2914: p_commit => Fnd_Api.g_false,
2915: p_module_type => p_module_type,
2916: x_return_status => x_return_status,
2917: x_msg_count => l_msg_count,
2918: x_msg_data => l_msg_data,

Line 2930: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then

2926: AHL_DEBUG_PUB.debug('Sangita-x_return_status after SR'|| x_return_status);
2927: END IF;
2928:
2929:
2930: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) then
2931:
2932: IF ( l_sr_task_tbl.COUNT > 0) THEN
2933: FOR i IN l_sr_task_tbl.FIRST..l_sr_task_tbl.LAST LOOP
2934:

Line 3043: x_return_status := FND_API.G_RET_STS_SUCCESS;

3039:
3040: BEGIN
3041:
3042: l_found := FALSE;
3043: x_return_status := FND_API.G_RET_STS_SUCCESS;
3044:
3045: -- get the latest material issue record.
3046: OPEN ahl_part_chg_csr(p_Item_Instance_Id, p_workorder_id);
3047: FETCH ahl_part_chg_csr INTO l_part_change_id, l_object_version_number;

Line 3065: PROCEDURE ReturnTo_Workorder_Locator( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3061: END Update_Material_Return;
3062:
3063: -- Added for ER 5854712 - locator for servicable parts.
3064: -- Procedure will return removed instance to Visit-Workorder locator.
3065: PROCEDURE ReturnTo_Workorder_Locator( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3067: p_part_change_id IN NUMBER,
3068: p_disposition_id IN NUMBER,
3069: x_return_status OUT NOCOPY VARCHAR2,

Line 3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,

3062:
3063: -- Added for ER 5854712 - locator for servicable parts.
3064: -- Procedure will return removed instance to Visit-Workorder locator.
3065: PROCEDURE ReturnTo_Workorder_Locator( p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
3066: p_commit IN VARCHAR2 := FND_API.G_FALSE,
3067: p_part_change_id IN NUMBER,
3068: p_disposition_id IN NUMBER,
3069: x_return_status OUT NOCOPY VARCHAR2,
3070: x_msg_data OUT NOCOPY VARCHAR2,

Line 3127: IF FND_API.To_Boolean(p_init_msg_list) THEN

3123: -- Standard start of API savepoint
3124: Savepoint ReturnTo_Workorder_Locator_pvt;
3125:
3126: -- Initialize message list if p_init_msg_list is set to TRUE
3127: IF FND_API.To_Boolean(p_init_msg_list) THEN
3128: FND_MSG_PUB.Initialize;
3129: END IF;
3130:
3131: -- Initialize API return status to success

Line 3132: x_return_status := FND_API.G_RET_STS_SUCCESS;

3128: FND_MSG_PUB.Initialize;
3129: END IF;
3130:
3131: -- Initialize API return status to success
3132: x_return_status := FND_API.G_RET_STS_SUCCESS;
3133:
3134: -- log debug message.
3135: IF (l_debug_stmt >= l_debug_level) THEN
3136: fnd_log.string(l_debug_stmt,l_debug_module,

Line 3152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3148: IF (ahl_disp_csr%NOTFOUND) THEN
3149: FND_MESSAGE.Set_Name('AHL','AHL_PRD_PC_DISP_INVALID');
3150: FND_MESSAGE.Set_Token('DISP_ID',p_disposition_id);
3151: FND_MSG_PUB.ADD;
3152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3153: END IF;
3154: CLOSE ahl_disp_csr;
3155:
3156: -- If visit header does not have locator information then return.

Line 3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3236: 'After call to AHL_PRD_MTLTXN_PVT.PERFORM_MTL_TXN. Error count:' || x_msg_count
3237: );
3238: END IF;
3239:
3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: END IF;

Line 3241: RAISE FND_API.G_EXC_ERROR;

3237: );
3238: END IF;
3239:
3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: END IF;
3245:

Line 3242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3238: END IF;
3239:
3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: END IF;
3245:
3246: -- get count of message after calling Material txn api.

Line 3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3239:
3240: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3241: RAISE FND_API.G_EXC_ERROR;
3242: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3244: END IF;
3245:
3246: -- get count of message after calling Material txn api.
3247: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 3262: p_encoded => fnd_api.g_false);

3258: END IF;
3259:
3260: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3261: p_data => x_msg_data,
3262: p_encoded => fnd_api.g_false);
3263:
3264: -- Call disposition api to associate material txn.
3265: l_disp_Mtl_Txn_Tbl(1).wo_mtl_txn_id := l_mtl_txn_tbl(1).Ahl_MtlTxn_Id;
3266: l_disp_Mtl_Txn_Tbl(1).disposition_id := l_mtl_txn_tbl(1).disposition_id;

Line 3272: p_init_msg_list => FND_API.G_FALSE,

3268: l_disp_Mtl_Txn_Tbl(1).uom := l_mtl_txn_tbl(1).uom;
3269:
3270: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
3271: p_api_version => 1.0,
3272: p_init_msg_list => FND_API.G_FALSE,
3273: p_commit => FND_API.G_FALSE,
3274: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3275: x_return_status => x_return_status,
3276: x_msg_count => x_msg_count,

Line 3273: p_commit => FND_API.G_FALSE,

3269:
3270: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
3271: p_api_version => 1.0,
3272: p_init_msg_list => FND_API.G_FALSE,
3273: p_commit => FND_API.G_FALSE,
3274: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3275: x_return_status => x_return_status,
3276: x_msg_count => x_msg_count,
3277: x_msg_data => x_msg_data,

Line 3274: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3270: AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn (
3271: p_api_version => 1.0,
3272: p_init_msg_list => FND_API.G_FALSE,
3273: p_commit => FND_API.G_FALSE,
3274: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3275: x_return_status => x_return_status,
3276: x_msg_count => x_msg_count,
3277: x_msg_data => x_msg_data,
3278: p_module => 'JSP',

Line 3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

3293: 'After call to AHL_PRD_DISP_MTL_TXN_PVT.Process_Disp_Mtl_Txn. Error count:' || x_msg_count
3294: );
3295: END IF;
3296:
3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3298: RAISE FND_API.G_EXC_ERROR;
3299: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;

Line 3298: RAISE FND_API.G_EXC_ERROR;

3294: );
3295: END IF;
3296:
3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3298: RAISE FND_API.G_EXC_ERROR;
3299: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302:

Line 3299: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

3295: END IF;
3296:
3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3298: RAISE FND_API.G_EXC_ERROR;
3299: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302:
3303: -- log debug message.

Line 3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3296:
3297: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3298: RAISE FND_API.G_EXC_ERROR;
3299: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302:
3303: -- log debug message.
3304: IF (l_debug_proc >= l_debug_level) THEN

Line 3310: WHEN FND_API.G_EXC_ERROR THEN

3306: 'At End of procedure AHL_PRD_PARTS_CHANGE_PVT.ReturnTo_Workorder_Locator');
3307: END IF;
3308:
3309: EXCEPTION
3310: WHEN FND_API.G_EXC_ERROR THEN
3311: x_return_status := FND_API.G_RET_STS_ERROR;
3312: Rollback to ReturnTo_Workorder_Locator_pvt;
3313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3314: p_data => x_msg_data,

Line 3311: x_return_status := FND_API.G_RET_STS_ERROR;

3307: END IF;
3308:
3309: EXCEPTION
3310: WHEN FND_API.G_EXC_ERROR THEN
3311: x_return_status := FND_API.G_RET_STS_ERROR;
3312: Rollback to ReturnTo_Workorder_Locator_pvt;
3313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3314: p_data => x_msg_data,
3315: p_encoded => fnd_api.g_false);

Line 3315: p_encoded => fnd_api.g_false);

3311: x_return_status := FND_API.G_RET_STS_ERROR;
3312: Rollback to ReturnTo_Workorder_Locator_pvt;
3313: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3314: p_data => x_msg_data,
3315: p_encoded => fnd_api.g_false);
3316: -- Disable debug
3317: IF G_DEBUG = 'Y' THEN
3318: AHL_DEBUG_PUB.disable_debug;
3319: END IF;

Line 3322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3318: AHL_DEBUG_PUB.disable_debug;
3319: END IF;
3320:
3321:
3322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3324: Rollback to ReturnTo_Workorder_Locator_pvt;
3325: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3326: p_data => x_msg_data,

Line 3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3319: END IF;
3320:
3321:
3322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3324: Rollback to ReturnTo_Workorder_Locator_pvt;
3325: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3326: p_data => x_msg_data,
3327: p_encoded => fnd_api.g_false);

Line 3327: p_encoded => fnd_api.g_false);

3323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3324: Rollback to ReturnTo_Workorder_Locator_pvt;
3325: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3326: p_data => x_msg_data,
3327: p_encoded => fnd_api.g_false);
3328: -- Disable debug
3329: IF G_DEBUG = 'Y' THEN
3330: AHL_DEBUG_PUB.disable_debug;
3331: END IF;

Line 3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3330: AHL_DEBUG_PUB.disable_debug;
3331: END IF;
3332:
3333: WHEN OTHERS THEN
3334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3335: Rollback to ReturnTo_Workorder_Locator_pvt;
3336: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_PARTS_CHANGE_PVT',
3338: p_procedure_name => 'process_parts',

Line 3343: p_encoded => fnd_api.g_false);

3339: p_error_text => SQLERRM);
3340: --END IF;
3341: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3342: p_data => x_msg_data,
3343: p_encoded => fnd_api.g_false);
3344:
3345: -- Disable debug
3346: IF G_DEBUG = 'Y' THEN
3347: AHL_DEBUG_PUB.disable_debug;

Line 3355: P_Init_Msg_List In Varchar2 Default Fnd_API.G_False,

3351:
3352:
3353: PROCEDURE move_instance_location(
3354: P_API_Version In Number Default 1.0,
3355: P_Init_Msg_List In Varchar2 Default Fnd_API.G_False,
3356: P_Commit In Varchar2 Default Fnd_API.G_False,
3357: P_Validation_Level In Number Default Fnd_API.G_Valid_Level_Full,
3358: p_module_type In Varchar2 Default NULL,
3359: p_default In Varchar2 Default FND_API.G_TRUE,

Line 3356: P_Commit In Varchar2 Default Fnd_API.G_False,

3352:
3353: PROCEDURE move_instance_location(
3354: P_API_Version In Number Default 1.0,
3355: P_Init_Msg_List In Varchar2 Default Fnd_API.G_False,
3356: P_Commit In Varchar2 Default Fnd_API.G_False,
3357: P_Validation_Level In Number Default Fnd_API.G_Valid_Level_Full,
3358: p_module_type In Varchar2 Default NULL,
3359: p_default In Varchar2 Default FND_API.G_TRUE,
3360: p_move_item_instance_tbl In AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type,

Line 3357: P_Validation_Level In Number Default Fnd_API.G_Valid_Level_Full,

3353: PROCEDURE move_instance_location(
3354: P_API_Version In Number Default 1.0,
3355: P_Init_Msg_List In Varchar2 Default Fnd_API.G_False,
3356: P_Commit In Varchar2 Default Fnd_API.G_False,
3357: P_Validation_Level In Number Default Fnd_API.G_Valid_Level_Full,
3358: p_module_type In Varchar2 Default NULL,
3359: p_default In Varchar2 Default FND_API.G_TRUE,
3360: p_move_item_instance_tbl In AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type,
3361: X_Return_Status Out NOCOPY Varchar2,

Line 3359: p_default In Varchar2 Default FND_API.G_TRUE,

3355: P_Init_Msg_List In Varchar2 Default Fnd_API.G_False,
3356: P_Commit In Varchar2 Default Fnd_API.G_False,
3357: P_Validation_Level In Number Default Fnd_API.G_Valid_Level_Full,
3358: p_module_type In Varchar2 Default NULL,
3359: p_default In Varchar2 Default FND_API.G_TRUE,
3360: p_move_item_instance_tbl In AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type,
3361: X_Return_Status Out NOCOPY Varchar2,
3362: X_Msg_Count Out NOCOPY Number,
3363: X_Msg_Data Out NOCOPY Varchar2) IS

Line 3390: IF NOT FND_API.Compatible_API_Call(l_api_version,

3386: );
3387: END IF;
3388:
3389: -- Standard call to check for call compatibility
3390: IF NOT FND_API.Compatible_API_Call(l_api_version,
3391: p_api_version,
3392: l_api_name,
3393: G_PKG_NAME) THEN
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3390: IF NOT FND_API.Compatible_API_Call(l_api_version,
3391: p_api_version,
3392: l_api_name,
3393: G_PKG_NAME) THEN
3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3395: END IF;
3396:
3397: -- Initialize message list if p_init_msg_list is set to TRUE
3398: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 3398: IF FND_API.To_Boolean(p_init_msg_list) THEN

3394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3395: END IF;
3396:
3397: -- Initialize message list if p_init_msg_list is set to TRUE
3398: IF FND_API.To_Boolean(p_init_msg_list) THEN
3399: FND_MSG_PUB.Initialize;
3400: END IF;
3401:
3402: -- Initialize API return status to success

Line 3403: x_return_status := FND_API.G_RET_STS_SUCCESS;

3399: FND_MSG_PUB.Initialize;
3400: END IF;
3401:
3402: -- Initialize API return status to success
3403: x_return_status := FND_API.G_RET_STS_SUCCESS;
3404:
3405: ------**************Get csi_transaction_rec.
3406: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);
3407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3403: x_return_status := FND_API.G_RET_STS_SUCCESS;
3404:
3405: ------**************Get csi_transaction_rec.
3406: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);
3407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3408: RAISE FND_API.G_EXC_ERROR;
3409: END IF;
3410:
3411: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 3408: RAISE FND_API.G_EXC_ERROR;

3404:
3405: ------**************Get csi_transaction_rec.
3406: Create_csi_transaction_rec(l_csi_transaction_rec,x_return_status);
3407: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3408: RAISE FND_API.G_EXC_ERROR;
3409: END IF;
3410:
3411: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3412: fnd_log.string

Line 3449: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3445: x_instance_rec => l_instance_rec,
3446: x_serialized => l_serialized,
3447: x_Return_Status => X_Return_Status
3448: );
3449: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3450: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3451: fnd_log.string
3452: (
3453: fnd_log.level_error,

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3455: 'get_dest_instance_rec returned error'
3456: );
3457: END IF;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460:
3461: /*l_instance_rec.location_id := l_location_id;
3462: l_instance_rec.LOCATION_TYPE_CODE := 'WIP';

Line 3465: IF FND_API.To_Boolean(l_serialized) THEN

3461: /*l_instance_rec.location_id := l_location_id;
3462: l_instance_rec.LOCATION_TYPE_CODE := 'WIP';
3463: l_instance_rec.instance_usage_code := 'IN_WIP';*/
3464:
3465: IF FND_API.To_Boolean(l_serialized) THEN
3466: update_csi_item_instance(
3467: p_instance_rec => l_instance_rec,
3468: p_x_csi_transaction_rec => l_csi_transaction_rec,
3469: x_Return_Status => X_Return_Status

Line 3471: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3467: p_instance_rec => l_instance_rec,
3468: p_x_csi_transaction_rec => l_csi_transaction_rec,
3469: x_Return_Status => X_Return_Status
3470: );
3471: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3472: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3473: fnd_log.string
3474: (
3475: fnd_log.level_error,

Line 3480: RAISE FND_API.G_EXC_ERROR;

3476: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3477: 'serialized move: update_csi_item_instance returned error'
3478: );
3479: END IF;
3480: RAISE FND_API.G_EXC_ERROR;
3481: END IF;
3482: ELSE
3483:
3484:

Line 3492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3488: p_dest_wip_job_id => l_instance_rec.wip_job_id,
3489: p_x_csi_transaction_rec => l_csi_transaction_rec,
3490: x_Return_Status => X_Return_Status
3491: );
3492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3493: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3494: fnd_log.string
3495: (
3496: fnd_log.level_error,

Line 3501: RAISE FND_API.G_EXC_ERROR;

3497: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
3498: 'non serialized move: move_nonser_instance returned error'
3499: );
3500: END IF;
3501: RAISE FND_API.G_EXC_ERROR;
3502: END IF;
3503: END IF;
3504: END LOOP;
3505:

Line 3507: IF FND_API.To_Boolean(p_commit) THEN

3503: END IF;
3504: END LOOP;
3505:
3506: -- Standard check of p_commit
3507: IF FND_API.To_Boolean(p_commit) THEN
3508: COMMIT WORK;
3509: END IF;
3510:
3511:

Line 3517: p_encoded => fnd_api.g_false);

3513: -- Standard call to get message count and if count is 1, get message
3514: FND_MSG_PUB.Count_And_Get
3515: ( p_count => x_msg_count,
3516: p_data => x_msg_data,
3517: p_encoded => fnd_api.g_false);
3518:
3519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3520: fnd_log.string
3521: (

Line 3529: WHEN FND_API.G_EXC_ERROR THEN

3525: );
3526: END IF;
3527:
3528: EXCEPTION
3529: WHEN FND_API.G_EXC_ERROR THEN
3530: x_return_status := FND_API.G_RET_STS_ERROR;
3531: Rollback to MOVE_INSTANCE_LOCATION;
3532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3533: p_data => x_msg_data,

Line 3530: x_return_status := FND_API.G_RET_STS_ERROR;

3526: END IF;
3527:
3528: EXCEPTION
3529: WHEN FND_API.G_EXC_ERROR THEN
3530: x_return_status := FND_API.G_RET_STS_ERROR;
3531: Rollback to MOVE_INSTANCE_LOCATION;
3532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3533: p_data => x_msg_data,
3534: p_encoded => fnd_api.g_false);

Line 3534: p_encoded => fnd_api.g_false);

3530: x_return_status := FND_API.G_RET_STS_ERROR;
3531: Rollback to MOVE_INSTANCE_LOCATION;
3532: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3533: p_data => x_msg_data,
3534: p_encoded => fnd_api.g_false);
3535:
3536:
3537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3533: p_data => x_msg_data,
3534: p_encoded => fnd_api.g_false);
3535:
3536:
3537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: Rollback to MOVE_INSTANCE_LOCATION;
3540: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3541: p_data => x_msg_data,

Line 3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3534: p_encoded => fnd_api.g_false);
3535:
3536:
3537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: Rollback to MOVE_INSTANCE_LOCATION;
3540: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3541: p_data => x_msg_data,
3542: p_encoded => fnd_api.g_false);

Line 3542: p_encoded => fnd_api.g_false);

3538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3539: Rollback to MOVE_INSTANCE_LOCATION;
3540: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3541: p_data => x_msg_data,
3542: p_encoded => fnd_api.g_false);
3543:
3544: WHEN OTHERS THEN
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: Rollback to MOVE_INSTANCE_LOCATION;

Line 3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3541: p_data => x_msg_data,
3542: p_encoded => fnd_api.g_false);
3543:
3544: WHEN OTHERS THEN
3545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3546: Rollback to MOVE_INSTANCE_LOCATION;
3547: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3548: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_PRD_PARTS_CHANGE_PVT',
3549: p_procedure_name => 'move_instance_location',

Line 3554: p_encoded => fnd_api.g_false);

3550: p_error_text => SQLERRM);
3551: --END IF;
3552: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
3553: p_data => x_msg_data,
3554: p_encoded => fnd_api.g_false);
3555:
3556: END move_instance_location;
3557:
3558: PROCEDURE get_dest_instance_rec(

Line 3638: x_return_status := FND_API.G_RET_STS_SUCCESS;

3634: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name ||'.begin',
3635: 'At the start of PLSQL procedure'
3636: );
3637: END IF;
3638: x_return_status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: IF(p_module_type = 'JSP' AND p_move_item_instance_rec.from_workorder_number IS NOT NULL) THEN
3641: OPEN wip_entity_wonum_csr(p_move_item_instance_rec.from_workorder_number);
3642: FETCH wip_entity_wonum_csr INTO l_from_wip_entity_id,l_status_code;

Line 3797: x_serialized := FND_API.G_FALSE;

3793: );
3794: END IF;
3795:
3796: --Validate quantity / serial item only if valid instance exists.
3797: x_serialized := FND_API.G_FALSE;
3798: IF (l_check_qnt_flag) THEN
3799: OPEN check_inst_nonserial(l_instance_rec.instance_id);
3800: FETCH check_inst_nonserial INTO l_junk;
3801: IF(check_inst_nonserial%NOTFOUND)THEN

Line 3802: x_serialized := FND_API.G_TRUE;

3798: IF (l_check_qnt_flag) THEN
3799: OPEN check_inst_nonserial(l_instance_rec.instance_id);
3800: FETCH check_inst_nonserial INTO l_junk;
3801: IF(check_inst_nonserial%NOTFOUND)THEN
3802: x_serialized := FND_API.G_TRUE;
3803: END IF;
3804: CLOSE check_inst_nonserial;
3805:
3806: IF FND_API.To_Boolean(x_serialized) THEN

Line 3806: IF FND_API.To_Boolean(x_serialized) THEN

3802: x_serialized := FND_API.G_TRUE;
3803: END IF;
3804: CLOSE check_inst_nonserial;
3805:
3806: IF FND_API.To_Boolean(x_serialized) THEN
3807: IF(NVL(p_move_item_instance_rec.quantity,1) <> 1)THEN
3808: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
3809: fnd_log.string
3810: (

Line 3853: x_return_status := Fnd_Api.G_RET_STS_ERROR;

3849: FND_MSG_PUB.ADD;
3850: END IF;
3851: --Standard check to count messages
3852: IF Fnd_Msg_Pub.count_msg > 0 THEN
3853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3854: RAISE Fnd_Api.G_EXC_ERROR;
3855: END IF;
3856:
3857: l_instance_rec.wip_job_id := l_to_wip_entity_id;

Line 3854: RAISE Fnd_Api.G_EXC_ERROR;

3850: END IF;
3851: --Standard check to count messages
3852: IF Fnd_Msg_Pub.count_msg > 0 THEN
3853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3854: RAISE Fnd_Api.G_EXC_ERROR;
3855: END IF;
3856:
3857: l_instance_rec.wip_job_id := l_to_wip_entity_id;
3858: l_instance_rec.quantity := NVL(p_move_item_instance_rec.quantity,1);

Line 3999: ,p_commit => fnd_api.g_false

3995:
3996:
3997: CSI_ITEM_INSTANCE_PUB. update_item_instance (
3998: p_api_version =>1.0
3999: ,p_commit => fnd_api.g_false
4000: ,p_init_msg_list => fnd_api.g_false
4001: ,p_validation_level => fnd_api.g_valid_level_full
4002: ,p_instance_rec => l_instance_rec
4003: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl

Line 4000: ,p_init_msg_list => fnd_api.g_false

3996:
3997: CSI_ITEM_INSTANCE_PUB. update_item_instance (
3998: p_api_version =>1.0
3999: ,p_commit => fnd_api.g_false
4000: ,p_init_msg_list => fnd_api.g_false
4001: ,p_validation_level => fnd_api.g_valid_level_full
4002: ,p_instance_rec => l_instance_rec
4003: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
4004: ,p_party_tbl =>l_party_tbl

Line 4001: ,p_validation_level => fnd_api.g_valid_level_full

3997: CSI_ITEM_INSTANCE_PUB. update_item_instance (
3998: p_api_version =>1.0
3999: ,p_commit => fnd_api.g_false
4000: ,p_init_msg_list => fnd_api.g_false
4001: ,p_validation_level => fnd_api.g_valid_level_full
4002: ,p_instance_rec => l_instance_rec
4003: ,p_ext_attrib_values_tbl=>l_extend_attrib_values_tbl
4004: ,p_party_tbl =>l_party_tbl
4005: ,p_account_tbl => l_account_tbl

Line 4214: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4210: p_instance_rec => l_instance_rec,
4211: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4212: x_Return_Status => X_Return_Status
4213: );
4214: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4215: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4216: fnd_log.string
4217: (
4218: fnd_log.level_error,

Line 4223: RAISE FND_API.G_EXC_ERROR;

4219: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4220: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '
4221: );
4222: END IF;
4223: RAISE FND_API.G_EXC_ERROR;
4224: END IF;
4225: -- reduce quantity and/or expire source insance
4226: l_instance_rec.instance_id := l_source_inst_rec.instance_id;
4227: l_instance_rec.quantity := l_source_inst_rec.quantity - p_move_quantity;

Line 4235: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4231: p_instance_rec => l_instance_rec,
4232: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4233: x_Return_Status => X_Return_Status
4234: );
4235: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4236: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4237: fnd_log.string
4238: (
4239: fnd_log.level_error,

Line 4244: RAISE FND_API.G_EXC_ERROR;

4240: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4241: 'Item in destination: source Non Serialized update_csi_item_instance returned error '
4242: );
4243: END IF;
4244: RAISE FND_API.G_EXC_ERROR;
4245: END IF;
4246: ELSIF(l_item_found_in_dest_wo AND l_source_inst_rec.quantity = p_move_quantity) THEN
4247: -- item in destination and is a full move. Make sure that item with open job do not get expired
4248: -- add to dest instance quantity

Line 4280: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4276: p_instance_rec => l_instance_rec,
4277: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4278: x_Return_Status => X_Return_Status
4279: );
4280: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4281: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4282: fnd_log.string
4283: (
4284: fnd_log.level_error,

Line 4289: RAISE FND_API.G_EXC_ERROR;

4285: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4286: 'Item in destination: dest Non Serialized update_csi_item_instance returned error '
4287: );
4288: END IF;
4289: RAISE FND_API.G_EXC_ERROR;
4290: END IF;
4291: -- reduce quantity and/or expire source insance
4292: l_instance_rec.instance_id := l_source_inst_rec.instance_id;
4293: IF( NOT l_open_wip_job_source) THEN

Line 4308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4304: p_instance_rec => l_instance_rec,
4305: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4306: x_Return_Status => X_Return_Status
4307: );
4308: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4309: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4310: fnd_log.string
4311: (
4312: fnd_log.level_error,

Line 4317: RAISE FND_API.G_EXC_ERROR;

4313: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4314: 'Item in destination: source Non Serialized update_csi_item_instance returned error '
4315: );
4316: END IF;
4317: RAISE FND_API.G_EXC_ERROR;
4318: END IF;
4319: ELSE -- no item in destination
4320: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4321: fnd_log.string

Line 4377: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4373: p_instance_rec => l_instance_rec,
4374: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4375: x_Return_Status => X_Return_Status
4376: );
4377: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4378: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4379: fnd_log.string
4380: (
4381: fnd_log.level_error,

Line 4386: RAISE FND_API.G_EXC_ERROR;

4382: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4383: 'Item NOT in destination: Full Move update_csi_item_instance returned error '
4384: );
4385: END IF;
4386: RAISE FND_API.G_EXC_ERROR;
4387: END IF;
4388: ELSE -- else create instance at dest with move qty and reduce source qty
4389: -- or reuse an expired instance create_similar_instance API does that
4390: create_similar_instance(

Line 4398: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

4394: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4395: x_dest_instance_id => l_dest_instance_id,
4396: x_return_status => X_Return_Status
4397: );
4398: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
4399: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4400: fnd_log.string
4401: (
4402: fnd_log.level_error,

Line 4407: RAISE FND_API.G_EXC_ERROR;

4403: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4404: 'Item NOT in destination: Partial Move create_similar_instance returned error '
4405: );
4406: END IF;
4407: RAISE FND_API.G_EXC_ERROR;
4408: END IF;
4409: -- reduce quantity and/or expire source insance
4410: l_instance_rec.instance_id := l_source_inst_rec.instance_id;
4411: l_instance_rec.quantity := l_source_inst_rec.quantity - p_move_quantity;

Line 4418: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4414: p_instance_rec => l_instance_rec,
4415: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4416: x_Return_Status => X_Return_Status
4417: );
4418: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4419: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4420: fnd_log.string
4421: (
4422: fnd_log.level_error,

Line 4427: RAISE FND_API.G_EXC_ERROR;

4423: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4424: 'Item NOT in destination: Partial Move/Update Source qty update_csi_item_instance returned error '
4425: );
4426: END IF;
4427: RAISE FND_API.G_EXC_ERROR;
4428: END IF;
4429: END IF;
4430: END IF;
4431:

Line 4608: ,p_commit => fnd_api.g_false

4604:
4605: CSI_ITEM_INSTANCE_PUB.copy_item_instance
4606: (
4607: p_api_version => 1.0
4608: ,p_commit => fnd_api.g_false
4609: ,p_init_msg_list => fnd_api.g_true
4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true

Line 4609: ,p_init_msg_list => fnd_api.g_true

4605: CSI_ITEM_INSTANCE_PUB.copy_item_instance
4606: (
4607: p_api_version => 1.0
4608: ,p_commit => fnd_api.g_false
4609: ,p_init_msg_list => fnd_api.g_true
4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true

Line 4610: ,p_validation_level => fnd_api.g_valid_level_full

4606: (
4607: p_api_version => 1.0
4608: ,p_commit => fnd_api.g_false
4609: ,p_init_msg_list => fnd_api.g_true
4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true

Line 4612: ,p_copy_ext_attribs => fnd_api.g_true

4608: ,p_commit => fnd_api.g_false
4609: ,p_init_msg_list => fnd_api.g_true
4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true

Line 4613: ,p_copy_org_assignments => fnd_api.g_true

4609: ,p_init_msg_list => fnd_api.g_true
4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true

Line 4614: ,p_copy_parties => fnd_api.g_true

4610: ,p_validation_level => fnd_api.g_valid_level_full
4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true

Line 4615: ,p_copy_party_contacts => fnd_api.g_true

4611: ,p_source_instance_rec => l_source_instance_rec
4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true
4619: ,p_copy_inst_children => fnd_api.g_true

Line 4616: ,p_copy_accounts => fnd_api.g_true

4612: ,p_copy_ext_attribs => fnd_api.g_true
4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true
4619: ,p_copy_inst_children => fnd_api.g_true
4620: ,p_txn_rec => p_x_csi_transaction_rec

Line 4617: ,p_copy_asset_assignments => fnd_api.g_true

4613: ,p_copy_org_assignments => fnd_api.g_true
4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true
4619: ,p_copy_inst_children => fnd_api.g_true
4620: ,p_txn_rec => p_x_csi_transaction_rec
4621: ,x_new_instance_tbl => l_new_instance_tbl

Line 4618: ,p_copy_pricing_attribs => fnd_api.g_true

4614: ,p_copy_parties => fnd_api.g_true
4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true
4619: ,p_copy_inst_children => fnd_api.g_true
4620: ,p_txn_rec => p_x_csi_transaction_rec
4621: ,x_new_instance_tbl => l_new_instance_tbl
4622: ,x_return_status => x_return_status

Line 4619: ,p_copy_inst_children => fnd_api.g_true

4615: ,p_copy_party_contacts => fnd_api.g_true
4616: ,p_copy_accounts => fnd_api.g_true
4617: ,p_copy_asset_assignments => fnd_api.g_true
4618: ,p_copy_pricing_attribs => fnd_api.g_true
4619: ,p_copy_inst_children => fnd_api.g_true
4620: ,p_txn_rec => p_x_csi_transaction_rec
4621: ,x_new_instance_tbl => l_new_instance_tbl
4622: ,x_return_status => x_return_status
4623: ,x_msg_count => l_msg_count

Line 4627: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4623: ,x_msg_count => l_msg_count
4624: ,x_msg_data => l_msg_data
4625: );
4626:
4627: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4628: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4629: fnd_log.string
4630: (
4631: fnd_log.level_error,

Line 4636: RAISE FND_API.G_EXC_ERROR;

4632: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4633: 'CSI_ITEM_INSTANCE_PUB.copy_item_instance returned error '
4634: );
4635: END IF;
4636: RAISE FND_API.G_EXC_ERROR;
4637: END IF;
4638:
4639: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4640: fnd_log.string

Line 4685: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4681: p_instance_rec => l_dest_instance_rec,
4682: p_x_csi_transaction_rec => p_x_csi_transaction_rec,
4683: x_Return_Status => X_Return_Status
4684: );
4685: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4686: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
4687: fnd_log.string
4688: (
4689: fnd_log.level_error,

Line 4694: RAISE FND_API.G_EXC_ERROR;

4690: 'ahl.plsql.' || G_PKG_NAME || '.' || l_api_name,
4691: 'Updating copied instance loc: update_csi_item_instance returned error '
4692: );
4693: END IF;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: x_dest_instance_id := l_dest_instance_rec.instance_id;
4697:
4698: