APPS.CSP_SCH_INT_PVT dependencies on FND_API

Line 217: l_return_status VARCHAR2(128) := FND_API.G_RET_STS_SUCCESS;

213: l_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
214: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
215: l_eligible_resources_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
216: l_final_unavailable_list CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE ;
217: l_return_status VARCHAR2(128) := FND_API.G_RET_STS_SUCCESS;
218: l_del_date VARCHAR2(50);
219: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.GET_AVAILABILITY_OPTIONS';
220: l_temp_line_id NUMBER;
221:

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

232: l_available_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ();
233: l_eligible_resources_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE() ;
234: l_final_unavailable_list := CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();
235: x_options := CSP_SCH_INT_PVT.csp_sch_options_tbl_typ();
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: g_interval := p_interval;
238: CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV(p_resources, l_resource_org_subinv , x_return_status,x_msg_data,x_msg_count);
239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
240: RETURN;

Line 239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

235: x_options := CSP_SCH_INT_PVT.csp_sch_options_tbl_typ();
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: g_interval := p_interval;
238: CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV(p_resources, l_resource_org_subinv , x_return_status,x_msg_data,x_msg_count);
239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
240: RETURN;
241: END IF;
242: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

239: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
240: RETURN;
241: END IF;
242: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: RETURN;
245: END IF;
246: IF l_parts_list.count = 0 THEN
247: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
244: RETURN;
245: END IF;
246: IF l_parts_list.count = 0 THEN
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: FOR I IN 1..p_resources.count LOOP
249: x_options.extend;
250: x_options(x_options.count).resource_id := p_resources(I).resource_id;
251: x_options(x_options.count).resource_type := p_resources(I).resource_type;

Line 259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

255: RETURN;
256: END IF;
257: IF l_parts_list.count > 0 THEN
258: CSP_SCH_INT_PVT.CHECK_LOCAl_INVENTORY(l_resource_org_subinv,l_parts_list,l_unavailable_list,l_final_available_list,x_return_status,x_msg_data,x_msg_count);
259: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
260: RETURN;
261: END IF ;
262: IF l_unavailable_list.count > 0 AND (NOT p_subinv_only) AND
263: (fnd_profile.value(name => 'CSP_CHECK_ATP')= 'ALWAYS' or

Line 269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

265: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,p_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
266: ELSE
267: l_final_unavailable_list := l_unavailable_list;
268: END IF;
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: RETURN;
271: END IF;
272: If l_available_list.count > 0 THEN
273: FOR gli in get_line_id LOOP

Line 288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

284: END LOOP;
285: END LOOP;
286: END IF;
287: CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES(p_resources,l_final_available_list,l_final_unavailable_list,l_eligible_resources_list,x_return_status,x_msg_data,x_msg_count);
288: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
289: RETURN;
290: END IF;
291: IF l_eligible_resources_list.count > 0 THEN
292: CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,x_options,x_return_status,x_msg_data,x_msg_count);

Line 293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

289: RETURN;
290: END IF;
291: IF l_eligible_resources_list.count > 0 THEN
292: CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,x_options,x_return_status,x_msg_data,x_msg_count);
293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
294: RETURN;
295: /*ELSE
296: IF x_options.count = 0 THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
294: RETURN;
295: /*ELSE
296: IF x_options.count = 0 THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;
298: l_del_date := to_char(g_earliest_delivery_date,'MM-DD-YYYY HH24:MI:SS');
299: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_DEL');
300: FND_MESSAGE.SET_TOKEN('DDATE', l_del_date, TRUE);
301: FND_MSG_PUB.ADD;

Line 308: x_return_status := FND_API.G_RET_STS_ERROR;

304: , p_data => x_msg_data);
305: END IF;*/
306: END IF;
307: ELSE
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NO_PARTS');
310: FND_MSG_PUB.ADD;
311: fnd_msg_pub.count_and_get
312: ( p_count => x_msg_count

Line 333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

329: FND_MSG_PUB.ADD;
330: fnd_msg_pub.count_and_get
331: ( p_count => x_msg_count
332: , p_data => x_msg_data);
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: return;
335: END GET_AVAILABILITY_OPTIONS;
336:
337: PROCEDURE CHOOSE_OPTION(p_api_version_number IN NUMBER

Line 409: x_return_status := FND_API.G_RET_STS_SUCCESS ;

405: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;
406: l_address_type varchar2(3);
407: BEGIN
408: savepoint choose_options;
409: x_return_status := FND_API.G_RET_STS_SUCCESS ;
410: l_resources := CSP_SCH_INT_PVT.csp_sch_resource_tbl_typ();
411: l_resource_org_subinv := CSP_SCH_INT_PVT.CSP_RESOURCE_ORG_tbl_TYP();
412: --l_parts_list := CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYPE();
413: l_unavailable_list := CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();

Line 433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

429: l_resources(1).resource_type := p_options.resource_type ;
430: -- l_interval.earliest_time :=
431: l_interval.latest_time := p_options.start_time;
432: CSP_SCH_INT_PVT.GET_ORGANIZATION_SUBINV(l_resources, l_resource_org_subinv , x_return_status,x_msg_data,x_msg_count);
433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
434: RETURN;
435: END IF;
436: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

433: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
434: RETURN;
435: END IF;
436: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
438: RETURN;
439: END IF;
440: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
441: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY(l_resource_org_subinv,l_parts_list,l_unavailable_list,l_final_available_list,x_return_status,x_msg_data,x_msg_count);

Line 440: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

436: CSP_SCH_INT_PVT.GET_PARTS_LIST(p_task_id,p_likelihood,l_parts_list,x_return_status,x_msg_data,x_msg_count);
437: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
438: RETURN;
439: END IF;
440: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
441: CSP_SCH_INT_PVT.CHECK_LOCAL_INVENTORY(l_resource_org_subinv,l_parts_list,l_unavailable_list,l_final_available_list,x_return_status,x_msg_data,x_msg_count);
442: ELSE
443: return;
444: END IF;

Line 448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

444: END IF;
445: IF l_unavailable_list.count >= 1 THEN
446: CSP_SCH_INT_PVT.DO_ATP_CHECK(l_unavailable_list,l_interval,l_available_list,l_final_unavailable_list,x_return_status,x_msg_data,x_msg_count);
447: END IF;
448: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
449: RETURN;
450: END IF;
451: IF l_available_list.count > 0 THEN
452: l_temp_line_id := l_available_list(1).line_id;

Line 464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

460: l_temp_line_id := l_available_list(I).line_id;
461: END IF;
462: END LOOP;
463: CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES(l_resources,l_final_available_list,l_final_unavailable_list,l_eligible_resources_list,x_return_status,x_msg_data,x_msg_count);
464: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
465: RETURN;
466: END IF;
467: IF l_eligible_resources_list.count > 0 THEN
468: --CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,l_options,x_return_status);

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

467: IF l_eligible_resources_list.count > 0 THEN
468: --CSP_SCH_INT_PVT.GET_TIME_COST(l_eligible_resources_list,l_options,x_return_status);
469: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_eligible_resources_list,l_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
470: ELSE
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
473: FND_MSG_PUB.ADD;
474: fnd_msg_pub.count_and_get
475: ( p_count => x_msg_count

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489: l_temp_options(l_temp_options.count).arrival_date := l_options(I).arrival_date ;
490: END IF;
491: END LOOP;
492: IF l_temp_options.count = 0 then
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_OPTION_NOT_VALIED');
495: FND_MSG_PUB.ADD;
496: fnd_msg_pub.count_and_get
497: ( p_count => x_msg_count

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: l_reservation_parts.revision := l_eligible_resources_list(I).revision;
614: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
615: IF l_reservation_id <= 0 THEN
616: ROLLBACK TO choose_options;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count

Line 660: ,p_Init_Msg_List => FND_API.G_FALSE

656: l_parts_header.OPERATION := 'CREATE';
657: l_parts_header.need_by_date :=g_arrival_date;
658: CSP_PARTS_ORDER.process_order(
659: p_api_version => 1.0
660: ,p_Init_Msg_List => FND_API.G_FALSE
661: ,p_commit => FND_API.G_FALSE
662: ,px_header_rec => l_parts_header
663: ,px_line_table => l_parts_lines
664: ,x_return_status => x_return_status

Line 661: ,p_commit => FND_API.G_FALSE

657: l_parts_header.need_by_date :=g_arrival_date;
658: CSP_PARTS_ORDER.process_order(
659: p_api_version => 1.0
660: ,p_Init_Msg_List => FND_API.G_FALSE
661: ,p_commit => FND_API.G_FALSE
662: ,px_header_rec => l_parts_header
663: ,px_line_table => l_parts_lines
664: ,x_return_status => x_return_status
665: ,x_msg_count => x_msg_count

Line 669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

665: ,x_msg_count => x_msg_count
666: ,x_msg_data => x_msg_data
667: );
668: END IF;
669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: ROLLBACK TO CHOOSE_OPTIONS;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
673: FND_MSG_PUB.ADD;

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: );
668: END IF;
669: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: ROLLBACK TO CHOOSE_OPTIONS;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
673: FND_MSG_PUB.ADD;
674: fnd_msg_pub.count_and_get
675: ( p_count => x_msg_count

Line 689: P_Init_Msg_List => FND_API.G_FALSE,

685: END LOOP;
686: END LOOP;
687: /* CSP_Requirement_Lines_PVT.Update_requirement_lines(
688: P_Api_Version_Number => 1.0,
689: P_Init_Msg_List => FND_API.G_FALSE,
690: P_Commit => FND_API.G_FALSE,
691: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
692: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
693: X_Return_Status => x_return_status,

Line 690: P_Commit => FND_API.G_FALSE,

686: END LOOP;
687: /* CSP_Requirement_Lines_PVT.Update_requirement_lines(
688: P_Api_Version_Number => 1.0,
689: P_Init_Msg_List => FND_API.G_FALSE,
690: P_Commit => FND_API.G_FALSE,
691: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
692: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
693: X_Return_Status => x_return_status,
694: X_Msg_Count => x_msg_count,

Line 691: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

687: /* CSP_Requirement_Lines_PVT.Update_requirement_lines(
688: P_Api_Version_Number => 1.0,
689: P_Init_Msg_List => FND_API.G_FALSE,
690: P_Commit => FND_API.G_FALSE,
691: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
692: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
693: X_Return_Status => x_return_status,
694: X_Msg_Count => x_msg_count,
695: X_Msg_Data => x_msg_data

Line 697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

693: X_Return_Status => x_return_status,
694: X_Msg_Count => x_msg_count,
695: X_Msg_Data => x_msg_data
696: );*/
697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: ROLLBACK TO choose_options;
699: return;
700: END IF;
701: FOR K IN 1..l_req_line_details_tbl.count LOOP

Line 726: P_Init_Msg_List => FND_API.G_FALSE,

722: END IF;
723: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
724: CSP_Requirement_Headers_PVT.Update_requirement_headers(
725: P_Api_Version_Number => 1.0,
726: P_Init_Msg_List => FND_API.G_FALSE,
727: P_Commit => FND_API.G_FALSE,
728: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
729: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
730: X_Return_Status => x_return_status,

Line 727: P_Commit => FND_API.G_FALSE,

723: l_requirement_header.ORDER_TYPE_ID := FND_PROFILE.value(name => 'CSP_ORDER_TYPE');
724: CSP_Requirement_Headers_PVT.Update_requirement_headers(
725: P_Api_Version_Number => 1.0,
726: P_Init_Msg_List => FND_API.G_FALSE,
727: P_Commit => FND_API.G_FALSE,
728: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
729: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
730: X_Return_Status => x_return_status,
731: X_Msg_Count => x_msg_count,

Line 728: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

724: CSP_Requirement_Headers_PVT.Update_requirement_headers(
725: P_Api_Version_Number => 1.0,
726: P_Init_Msg_List => FND_API.G_FALSE,
727: P_Commit => FND_API.G_FALSE,
728: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
729: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
730: X_Return_Status => x_return_status,
731: X_Msg_Count => x_msg_count,
732: X_Msg_Data => x_msg_data

Line 734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

730: X_Return_Status => x_return_status,
731: X_Msg_Count => x_msg_count,
732: X_Msg_Data => x_msg_data
733: );
734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
735: ROLLBACK TO choose_options;
736: return;
737: END IF;
738: END IF;

Line 749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

745: FND_MSG_PUB.ADD;
746: fnd_msg_pub.count_and_get
747: ( p_count => x_msg_count
748: , p_data => x_msg_data);
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: END CHOOSE_OPTION;
751:
752: /* PROCEDURE CLEAN_MATERIAL_TRANSACTION(p_api_version_number IN NUMBER
753: ,p_task_assignment_id IN NUMBER

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: req_loop NUMBER := 0 ;
787: reservation_present BOOLEAN := FALSE;
788: order_present BOOLEAN := FALSE;
789: BEGIN
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791: SAVEPOINT CLEAN_MATERIAL_TRANSACTION;
792: OPEN cancel_reserv ;
793: LOOP
794: FETCH cancel_reserv INTO l_reserv_id,l_local_reserv_id,l_requirement_line_id;

Line 802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

798: END IF;
799: IF l_local_reserv_id IS NOT NULL THEN
800: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_local_reserv_id,x_return_status,x_msg_data,x_msg_count);
801: END IF;
802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');
806: FND_MSG_PUB.ADD;

Line 804: x_return_status := FND_API.G_RET_STS_ERROR;

800: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_local_reserv_id,x_return_status,x_msg_data,x_msg_count);
801: END IF;
802: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
803: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_RESERV');
806: FND_MSG_PUB.ADD;
807: fnd_msg_pub.count_and_get
808: ( p_count => x_msg_count

Line 824: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

820: END IF;
821: l_reserv_id := NULL ;
822: END LOOP;
823: CLOSE cancel_reserv;
824: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
825: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
826: return;
827: ELSE
828: IF reservation_present THEN

Line 831: P_Init_Msg_List => FND_API.G_FALSE,

827: ELSE
828: IF reservation_present THEN
829: CSP_Requirement_Lines_PVT.Update_requirement_lines(
830: P_Api_Version_Number => 1.0,
831: P_Init_Msg_List => FND_API.G_FALSE,
832: P_Commit => FND_API.G_FALSE,
833: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
834: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
835: X_Return_Status => x_return_status,

Line 832: P_Commit => FND_API.G_FALSE,

828: IF reservation_present THEN
829: CSP_Requirement_Lines_PVT.Update_requirement_lines(
830: P_Api_Version_Number => 1.0,
831: P_Init_Msg_List => FND_API.G_FALSE,
832: P_Commit => FND_API.G_FALSE,
833: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
834: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
835: X_Return_Status => x_return_status,
836: X_Msg_Count => x_msg_count,

Line 833: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

829: CSP_Requirement_Lines_PVT.Update_requirement_lines(
830: P_Api_Version_Number => 1.0,
831: P_Init_Msg_List => FND_API.G_FALSE,
832: P_Commit => FND_API.G_FALSE,
833: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
834: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
835: X_Return_Status => x_return_status,
836: X_Msg_Count => x_msg_count,
837: X_Msg_Data => x_msg_data

Line 839: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

835: X_Return_Status => x_return_status,
836: X_Msg_Count => x_msg_count,
837: X_Msg_Data => x_msg_data
838: );
839: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
840: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
841: return;
842: END IF;
843: END IF;

Line 854: x_return_status := FND_API.G_RET_STS_SUCCESS;

850: IF l_order_id <> l_previous_order_id THEN
851: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);
852: l_previous_order_id := l_order_id;
853: ELSE
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: END IF;
856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');

Line 856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

852: l_previous_order_id := l_order_id;
853: ELSE
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: END IF;
856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
859: FND_MSG_PUB.ADD;
860: fnd_msg_pub.count_and_get

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853: ELSE
854: x_return_status := FND_API.G_RET_STS_SUCCESS;
855: END IF;
856: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_NOT_CANCEL_ORDER');
859: FND_MSG_PUB.ADD;
860: fnd_msg_pub.count_and_get
861: ( p_count => x_msg_count

Line 880: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

876: l_requirement_line_id := null;
877: END IF;
878: END LOOP;
879: CLOSE cancel_order;
880: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
881: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
882: return;
883: ELSE
884: IF order_present then

Line 887: P_Init_Msg_List => FND_API.G_FALSE,

883: ELSE
884: IF order_present then
885: CSP_Requirement_Lines_PVT.Update_requirement_lines(
886: P_Api_Version_Number => 1.0,
887: P_Init_Msg_List => FND_API.G_FALSE,
888: P_Commit => FND_API.G_FALSE,
889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
890: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
891: X_Return_Status => x_return_status,

Line 888: P_Commit => FND_API.G_FALSE,

884: IF order_present then
885: CSP_Requirement_Lines_PVT.Update_requirement_lines(
886: P_Api_Version_Number => 1.0,
887: P_Init_Msg_List => FND_API.G_FALSE,
888: P_Commit => FND_API.G_FALSE,
889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
890: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
891: X_Return_Status => x_return_status,
892: X_Msg_Count => x_msg_count,

Line 889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

885: CSP_Requirement_Lines_PVT.Update_requirement_lines(
886: P_Api_Version_Number => 1.0,
887: P_Init_Msg_List => FND_API.G_FALSE,
888: P_Commit => FND_API.G_FALSE,
889: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
890: P_Requirement_Line_Tbl => l_Requirement_Line_Tbl,
891: X_Return_Status => x_return_status,
892: X_Msg_Count => x_msg_count,
893: X_Msg_Data => x_msg_data

Line 895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

891: X_Return_Status => x_return_status,
892: X_Msg_Count => x_msg_count,
893: X_Msg_Data => x_msg_data
894: );
895: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: ROLLBACK TO CLEAN_MATERIAL_TRANSACTION;
897: return;
898: END IF;
899: END IF;

Line 901: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

897: return;
898: END IF;
899: END IF;
900: END IF;
901: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
902: COMMIT WORK;
903: END IF;
904: EXCEPTION
905: WHEN OTHERS THEN

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

910: FND_MSG_PUB.ADD;
911: fnd_msg_pub.count_and_get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data);
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
915:
916: END CLEAN_MATERIAL_TRANSACTION;*/
917: PROCEDURE CLEAN_MATERIAL_TRANSACTION(p_api_version_number IN NUMBER
918: ,p_task_assignment_id IN NUMBER

Line 975: x_return_status := FND_API.G_RET_STS_SUCCESS;

971: l_requirement_header_id NUMBER;
972: l_address_type varchar2(3);
973: BEGIN
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976: SAVEPOINT CLEAN_MATERIAL_TRANSACTION;
977: OPEN get_reservations ;
978: LOOP
979: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;

Line 982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

978: LOOP
979: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
980: EXIT WHEN get_reservations%NOTFOUND;
981: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,x_return_status,x_msg_data,x_msg_count);
982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984: exit;
985: ELSE
986: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

Line 983: x_return_status := FND_API.G_RET_STS_SUCCESS;

979: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
980: EXIT WHEN get_reservations%NOTFOUND;
981: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,x_return_status,x_msg_data,x_msg_count);
982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984: exit;
985: ELSE
986: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
987: END IF;

Line 990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

986: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
987: END IF;
988: END LOOP;
989: close get_reservations;
990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992: rollback to CLEAN_MATERIAL_TRANSACTION;
993: return;
994: ELSE

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: END IF;
988: END LOOP;
989: close get_reservations;
990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992: rollback to CLEAN_MATERIAL_TRANSACTION;
993: return;
994: ELSE
995: OPEN get_orders;

Line 1004: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1000: FETCH get_order_status INTO l_status;
1001: CLOSE get_order_status;
1002: IF l_status <> 'CANCELLED' THEN
1003: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);
1004: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: EXIT;
1007: ELSE
1008: open get_line_details(l_order_id);

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: CLOSE get_order_status;
1002: IF l_status <> 'CANCELLED' THEN
1003: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,x_return_status,x_msg_data,x_msg_count);
1004: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: EXIT;
1007: ELSE
1008: open get_line_details(l_order_id);
1009: LOOP

Line 1035: P_Init_Msg_List => FND_API.G_FALSE,

1031: l_requirement_header.destination_organization_id := null;
1032: l_requirement_header.destination_subinventory := null;
1033: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1034: P_Api_Version_Number => 1.0,
1035: P_Init_Msg_List => FND_API.G_FALSE,
1036: P_Commit => FND_API.G_FALSE,
1037: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1038: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
1039: X_Return_Status => x_return_status,

Line 1036: P_Commit => FND_API.G_FALSE,

1032: l_requirement_header.destination_subinventory := null;
1033: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1034: P_Api_Version_Number => 1.0,
1035: P_Init_Msg_List => FND_API.G_FALSE,
1036: P_Commit => FND_API.G_FALSE,
1037: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1038: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
1039: X_Return_Status => x_return_status,
1040: X_Msg_Count => x_msg_count,

Line 1037: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1033: CSP_Requirement_Headers_PVT.Update_requirement_headers(
1034: P_Api_Version_Number => 1.0,
1035: P_Init_Msg_List => FND_API.G_FALSE,
1036: P_Commit => FND_API.G_FALSE,
1037: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1038: P_REQUIREMENT_HEADER_Rec => l_requirement_header,
1039: X_Return_Status => x_return_status,
1040: X_Msg_Count => x_msg_count,
1041: X_Msg_Data => x_msg_data

Line 1044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1040: X_Msg_Count => x_msg_count,
1041: X_Msg_Data => x_msg_data
1042: );
1043: END IF;
1044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: rollback to CLEAN_MATERIAL_TRANSACTION;
1047: return;
1048: END IF;

Line 1045: x_return_status := FND_API.G_RET_STS_SUCCESS;

1041: X_Msg_Data => x_msg_data
1042: );
1043: END IF;
1044: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1045: x_return_status := FND_API.G_RET_STS_SUCCESS;
1046: rollback to CLEAN_MATERIAL_TRANSACTION;
1047: return;
1048: END IF;
1049: END IF;

Line 1059: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;

1055: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_RESERVATION';
1056: l_api_version_number NUMBER := 1.0;
1057: l_return_status VARCHAR2(3);
1058: l_msg_count NUMBER;
1059: l_init_msg_lst VARCHAR2(1) := fnd_api.g_true;
1060: l_msg_data VARCHAR2(2000);
1061: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1062: l_serial_number inv_reservation_global.serial_number_tbl_type;
1063: BEGIN

Line 1064: x_return_status := FND_API.G_RET_STS_SUCCESS;

1060: l_msg_data VARCHAR2(2000);
1061: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1062: l_serial_number inv_reservation_global.serial_number_tbl_type;
1063: BEGIN
1064: x_return_status := FND_API.G_RET_STS_SUCCESS;
1065: l_rsv_rec.reservation_id := p_reserv_id ;
1066: INV_RESERVATION_PUB.delete_reservation(l_api_version_number
1067: ,l_init_msg_lst
1068: ,x_return_status

Line 1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1079: FND_MSG_PUB.ADD;
1080: fnd_msg_pub.count_and_get
1081: ( p_count => x_msg_count
1082: , p_data => x_msg_data);
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084:
1085: END CANCEL_RESERVATION;
1086:
1087: PROCEDURE CANCEL_ORDER(p_order_id IN NUMBER

Line 1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

1092: l_parts_lines csp_parts_requirement.Line_Tbl_type;
1093: l_api_version NUMBER := 1.0;
1094: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.CANCEL_ORDER';
1095: BEGIN
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097: l_parts_header.order_header_id := p_order_id;
1098: l_parts_header.operation := 'CANCEL';
1099: l_parts_header.change_Reason := 'Late';
1100: CSP_PARTS_ORDER.process_order(p_api_version => l_api_version

Line 1101: ,p_Init_Msg_List => FND_API.G_FALSE

1097: l_parts_header.order_header_id := p_order_id;
1098: l_parts_header.operation := 'CANCEL';
1099: l_parts_header.change_Reason := 'Late';
1100: CSP_PARTS_ORDER.process_order(p_api_version => l_api_version
1101: ,p_Init_Msg_List => FND_API.G_FALSE
1102: ,p_commit => FND_API.G_FALSE
1103: ,px_header_rec => l_parts_header
1104: ,px_line_table => l_parts_lines
1105: ,x_return_status => x_return_status

Line 1102: ,p_commit => FND_API.G_FALSE

1098: l_parts_header.operation := 'CANCEL';
1099: l_parts_header.change_Reason := 'Late';
1100: CSP_PARTS_ORDER.process_order(p_api_version => l_api_version
1101: ,p_Init_Msg_List => FND_API.G_FALSE
1102: ,p_commit => FND_API.G_FALSE
1103: ,px_header_rec => l_parts_header
1104: ,px_line_table => l_parts_lines
1105: ,x_return_status => x_return_status
1106: ,x_msg_count => x_msg_count

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: FND_MSG_PUB.ADD;
1115: fnd_msg_pub.count_and_get
1116: ( p_count => x_msg_count
1117: , p_data => x_msg_data);
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: END CANCEL_ORDER;
1120: PROCEDURE CREATE_ORDERS(p_api_version_number IN NUMBER
1121: ,p_task_assignment_id IN NUMBER
1122: ,x_return_status OUT NOCOPY VARCHAR2

Line 1164: ,p_Init_Msg_List => FND_API.G_FALSE

1160: l_parts_header.OPERATION := 'UPDATE';
1161: l_parts_header.order_header_id := l_previous_header_id;
1162: CSP_PARTS_ORDER.process_order(
1163: p_api_version => 1.0
1164: ,p_Init_Msg_List => FND_API.G_FALSE
1165: ,p_commit => FND_API.G_FALSE
1166: ,px_header_rec => l_parts_header
1167: ,px_line_table => l_parts_lines
1168: ,p_process_type => 'ORDER'

Line 1165: ,p_commit => FND_API.G_FALSE

1161: l_parts_header.order_header_id := l_previous_header_id;
1162: CSP_PARTS_ORDER.process_order(
1163: p_api_version => 1.0
1164: ,p_Init_Msg_List => FND_API.G_FALSE
1165: ,p_commit => FND_API.G_FALSE
1166: ,px_header_rec => l_parts_header
1167: ,px_line_table => l_parts_lines
1168: ,p_process_type => 'ORDER'
1169: ,x_return_status => x_return_status

Line 1173: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1169: ,x_return_status => x_return_status
1170: ,x_msg_count => x_msg_count
1171: ,x_msg_data => x_msg_data
1172: );
1173: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1174: ROLLBACK TO CREATE_ORDERS;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1177: FND_MSG_PUB.ADD;

Line 1175: x_return_status := FND_API.G_RET_STS_ERROR;

1171: ,x_msg_data => x_msg_data
1172: );
1173: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1174: ROLLBACK TO CREATE_ORDERS;
1175: x_return_status := FND_API.G_RET_STS_ERROR;
1176: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1177: FND_MSG_PUB.ADD;
1178: fnd_msg_pub.count_and_get
1179: ( p_count => x_msg_count

Line 1190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1186: l_parts_lines(rec_count).booked_flag := 'Y';
1187: rec_count := rec_count + 1;
1188: END LOOP;
1189: CLOSE get_orders;
1190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1191: RETURN;
1192: END IF;
1193: END CREATE_ORDERS;
1194:

Line 1269: x_return_status := FND_API.G_RET_STS_SUCCESS;

1265: l_reservation_id NUMBER;
1266: x_reservation_id NUMBER;
1267: l_header_id NUMBER;
1268: BEGIN
1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270: SAVEPOINT CREATE_ORDERS;
1271: OPEN get_resource(p_task_assignment_id);
1272: LOOP
1273: FETCH get_resource INTO l_resource_id,l_resource_type;

Line 1358: ,p_Init_Msg_List => FND_API.G_FALSE

1354: l_parts_header.DEST_ORGANIZATION_ID := l_destination_org_id;
1355: l_parts_header.OPERATION := 'CREATE';
1356: CSP_PARTS_ORDER.process_order(
1357: p_api_version => 1.0
1358: ,p_Init_Msg_List => FND_API.G_FALSE
1359: ,p_commit => FND_API.G_FALSE
1360: ,px_header_rec => l_parts_header
1361: ,px_line_table => l_parts_lines
1362: ,x_return_status => l_return_status

Line 1359: ,p_commit => FND_API.G_FALSE

1355: l_parts_header.OPERATION := 'CREATE';
1356: CSP_PARTS_ORDER.process_order(
1357: p_api_version => 1.0
1358: ,p_Init_Msg_List => FND_API.G_FALSE
1359: ,p_commit => FND_API.G_FALSE
1360: ,px_header_rec => l_parts_header
1361: ,px_line_table => l_parts_lines
1362: ,x_return_status => l_return_status
1363: ,x_msg_count => l_msg_count

Line 1366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1362: ,x_return_status => l_return_status
1363: ,x_msg_count => l_msg_count
1364: ,x_msg_data => l_msg_data
1365: );
1366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1367: ROLLBACK TO CREATE_ORDERS;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1370: FND_MSG_PUB.ADD;

Line 1368: x_return_status := FND_API.G_RET_STS_ERROR;

1364: ,x_msg_data => l_msg_data
1365: );
1366: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1367: ROLLBACK TO CREATE_ORDERS;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_UNABLE_TO_ORDER');
1370: FND_MSG_PUB.ADD;
1371: fnd_msg_pub.count_and_get
1372: ( p_count => x_msg_count

Line 1386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1382: ,x_return_status => x_return_status
1383: ,x_reservation_id => x_reservation_id
1384: ,x_msg_data => x_msg_data
1385: ,x_msg_count => x_msg_count);
1386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1387: Rollback to CREATE_ORDERS;
1388: x_msg_data := ' Unable to Transfer Reservations';
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: return;

Line 1389: x_return_status := FND_API.G_RET_STS_ERROR;

1385: ,x_msg_count => x_msg_count);
1386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1387: Rollback to CREATE_ORDERS;
1388: x_msg_data := ' Unable to Transfer Reservations';
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: return;
1391: ELSE
1392: l_requrements_lines(I).reservation_id := x_reservation_id;
1393: END IF;

Line 1397: P_Init_Msg_List => FND_API.G_FALSE,

1393: END IF;
1394: END LOOP;
1395: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1396: P_Api_Version_Number => 1.0,
1397: P_Init_Msg_List => FND_API.G_FALSE,
1398: P_Commit => FND_API.G_FALSE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: P_Requirement_Line_Tbl => l_requrements_lines,
1401: X_Return_Status => l_return_status,

Line 1398: P_Commit => FND_API.G_FALSE,

1394: END LOOP;
1395: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1396: P_Api_Version_Number => 1.0,
1397: P_Init_Msg_List => FND_API.G_FALSE,
1398: P_Commit => FND_API.G_FALSE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: P_Requirement_Line_Tbl => l_requrements_lines,
1401: X_Return_Status => l_return_status,
1402: X_Msg_Count => l_msg_count,

Line 1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1395: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1396: P_Api_Version_Number => 1.0,
1397: P_Init_Msg_List => FND_API.G_FALSE,
1398: P_Commit => FND_API.G_FALSE,
1399: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1400: P_Requirement_Line_Tbl => l_requrements_lines,
1401: X_Return_Status => l_return_status,
1402: X_Msg_Count => l_msg_count,
1403: X_Msg_Data => l_msg_data

Line 1405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1401: X_Return_Status => l_return_status,
1402: X_Msg_Count => l_msg_count,
1403: X_Msg_Data => l_msg_data
1404: ) ;
1405: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1406: ROLLBACK TO CREATE_ORDERS;
1407: return;
1408: END IF;
1409: END IF;

Line 1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1415: FND_MSG_PUB.ADD;
1416: fnd_msg_pub.count_and_get
1417: ( p_count => x_msg_count
1418: , p_data => x_msg_data);
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1420: END CREATE_ORDERS;*/
1421:
1422: PROCEDURE GET_ORGANIZATION_SUBINV( p_resources IN CSP_SCH_INT_PVT.csp_sch_resource_tbl_typ
1423: ,x_resource_org_subinv OUT NOCOPY CSP_SCH_INT_PVT.csp_resource_org_tbl_typ

Line 1447: x_return_status := FND_API.G_RET_STS_SUCCESS;

1443: l_msg_data number;
1444: l_resource_name varchar2(1000);
1445: l_resource_type_name varchar2(1000);
1446: BEGIN
1447: x_return_status := FND_API.G_RET_STS_SUCCESS;
1448: x_resource_org_subinv := CSP_SCH_INT_PVT.csp_resource_org_tbl_typ();
1449: FOR I IN 1..p_resources.count LOOP
1450: OPEN csp_resource_org(p_resources(I).resource_id, p_resources(I).resource_type);
1451: LOOP

Line 1473: x_return_status := FND_API.G_RET_STS_ERROR;

1469: FND_MSG_PUB.ADD;
1470: fnd_msg_pub.count_and_get( p_count => x_msg_count
1471: , p_data => x_msg_data);
1472: -- x_msg_data := 'Default organization and subinventory not defined for ' || l_resource_type_name || ' ' || l_resource_name ;
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: return;
1475: END IF;
1476: CLOSE csp_resource_org;
1477: x_resource_org_subinv.extend;

Line 1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1488: FND_MSG_PUB.ADD;
1489: fnd_msg_pub.count_and_get
1490: ( p_count => x_msg_count
1491: , p_data => x_msg_data);
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493: END GET_ORGANIZATION_SUBINV;
1494:
1495: PROCEDURE GET_PARTS_LIST(p_task_id IN NUMBER
1496: ,p_likelihood IN NUMBER

Line 1524: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1520: l_line_id NUMBER;
1521:
1522: BEGIN
1523: -- savepoint GET_PARTS_LIST;
1524: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1525: --x_parts_list := CSP_SCH_INT_PVT.csp_parts_tbl_typ1();
1526: OPEN parts_list(p_task_id, p_likelihood);
1527: LOOP
1528: FETCH parts_list INTO part_number, part_quantity , part_uom , l_ship_complet,l_revision , l_line_id;

Line 1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1545: FND_MSG_PUB.ADD;
1546: fnd_msg_pub.count_and_get
1547: ( p_count => x_msg_count
1548: , p_data => x_msg_data);
1549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1550: return;
1551: END GET_PARTS_LIST;
1552: PROCEDURE CHECK_LOCAl_INVENTORY(p_resource_org_subinv IN CSP_SCH_INT_PVT.CSP_RESOURCE_ORG_tbl_TYP
1553: ,p_parts_list IN CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYP1

Line 1602: x_return_status := FND_API.G_RET_STS_SUCCESS;

1598: l_reservation_id NUMBER;
1599: l_res_ids CSP_SUPERSESSIONS_PVT.NUMBER_ARR;
1600: BEGIN
1601: savepoint csp_check_local_inv;
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1603: x_unavailable_list:= CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();
1604: x_available_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE();
1605: if l_res_ids.count > 0 THEN
1606: l_res_ids.delete;

Line 1656: , p_init_msg_lst => fnd_api.g_false

1652: , p_inventory_item_id => p_parts_list(J).item_id
1653: , p_subinventory_code => p_resource_org_subinv(I).sub_inv_code
1654: , x_qoh => l_onhand
1655: , x_atr => l_available
1656: , p_init_msg_lst => fnd_api.g_false
1657: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
1658: , p_is_revision_control => l_revision_controlled
1659: , p_is_lot_control => NULL
1660: , p_is_serial_control => NULL

Line 1672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1668: , x_return_status => l_return_status
1669: , x_msg_count => l_msg_count
1670: , x_msg_data => l_msg_data
1671: );
1672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1673: l_att := 0;
1674: END IF;
1675: /*OPEN reservation_check(p_resource_org_subinv(I).organization_id, p_resource_org_subinv(I).sub_inv_code,p_parts_list(J).item_id);
1676: LOOP

Line 1773: , p_init_msg_lst => fnd_api.g_false

1769: , p_inventory_item_id => l_alternate_parts(k)
1770: , p_subinventory_code => p_resource_org_subinv(I).sub_inv_code
1771: , x_qoh => l_onhand
1772: , x_atr => l_available
1773: , p_init_msg_lst => fnd_api.g_false
1774: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
1775: , p_is_revision_control => NULL
1776: , p_is_lot_control => NULL
1777: , p_is_serial_control => NULL

Line 1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1909: FND_MSG_PUB.ADD;
1910: fnd_msg_pub.count_and_get
1911: ( p_count => x_msg_count
1912: , p_data => x_msg_data);
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: return;
1915: END CHECK_LOCAl_INVENTORY;
1916: PROCEDURE DO_ATP_CHECK(p_unavailable_list IN CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE
1917: ,p_interval IN CSP_SCH_INT_PVT.csp_sch_interval_rec_typ

Line 1983: x_return_status := FND_API.G_RET_STS_SUCCESS;

1979: l_buy_from varchar2(1);
1980: l_assignment_set_id NUMBER;
1981: l_unavailable varchar2(1);
1982: BEGIN
1983: x_return_status := FND_API.G_RET_STS_SUCCESS;
1984: x_final_unavailable_list := CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE();
1985: OPEN instance;
1986: FETCH instance INTO l_instance_id;
1987: CLOSE instance;

Line 2038: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;

2034: l_atp_details,
2035: x_return_status,
2036: x_msg_data,
2037: x_msg_count);
2038: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;
2039:
2040: rollback to csp_msc_atp_check;
2041: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2042: l_unavailable := 'Y';

Line 2041: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2037: x_msg_count);
2038: l_msg := FND_MSG_PUB.Get(1,FND_API.G_FALSE) ;
2039:
2040: rollback to csp_msc_atp_check;
2041: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2042: l_unavailable := 'Y';
2043: FOR I IN 1..l_atp_rec_out.Inventory_Item_Id.count LOOP
2044: IF (l_atp_rec_out.Error_Code(I) <> 0 and l_atp_rec_out.Error_Code(I) <> 150 ) THEN
2045: l_assignment_set_id := FND_PROFILE.value(name => 'MRP_ATP_ASSIGN_SET');

Line 2064: x_return_status := FND_API.G_RET_STS_ERROR;

2060: ( p_count => x_msg_count
2061: , p_data => x_msg_data);
2062:
2063: END IF;
2064: x_return_status := FND_API.G_RET_STS_ERROR;
2065: OPEN error_message(l_atp_rec_out.Error_Code(I));
2066: FETCH error_message INTO l_message;
2067: CLOSE error_message;
2068: l_item_segments := null;

Line 2096: x_return_status := FND_API.G_RET_STS_ERROR;

2092: ( p_count => x_msg_count
2093: , p_data => x_msg_data);
2094:
2095: END IF;
2096: x_return_status := FND_API.G_RET_STS_ERROR;
2097: OPEN error_message(l_atp_rec_out.Error_Code(I));
2098: FETCH error_message INTO l_message;
2099: CLOSE error_message;
2100: l_item_segments := null;

Line 2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2198: FND_MSG_PUB.ADD;
2199: fnd_msg_pub.count_and_get
2200: ( p_count => x_msg_count
2201: , p_data => x_msg_data);
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2203: return;
2204:
2205: END DO_ATP_CHECK;
2206:

Line 2220: x_return_status := FND_API.G_RET_STS_SUCCESS;

2216:
2217: resource_eligible BOOLEAN := TRUE;
2218: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.ELIGIBLE_RESOURCES';
2219: BEGIN
2220: x_return_status := FND_API.G_RET_STS_SUCCESS;
2221: x_eligible_resources_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE();
2222: FOR I IN 1..p_resource_list.count LOOP
2223: FOR J IN 1..p_final_unavailable_list.count LOOP
2224: IF p_final_unavailable_list(J).resource_id = p_resource_list(I).resource_id THEN

Line 2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2255: FND_MSG_PUB.ADD;
2256: fnd_msg_pub.count_and_get
2257: ( p_count => x_msg_count
2258: , p_data => x_msg_data);
2259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2260: return;
2261: END ELIGIBLE_RESOURCES;
2262:
2263: PROCEDURE GET_TIME_COST(p_eligible_resources_list IN CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE

Line 2277: x_return_status := FND_API.G_RET_STS_SUCCESS;

2273: l_ship_count CSP_SCH_INT_PVT.CSP_SHIP_METHOD_COUNT_TBL_TYP;
2274: l_res_ship_parameters CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE ;
2275: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.GET_TIME_COST' ;
2276: BEGIN
2277: x_return_status := FND_API.G_RET_STS_SUCCESS;
2278: l_temp_options := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE();
2279: l_temp_resources_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE();
2280: l_options := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE();
2281: l_resources := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE();

Line 2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2300: l_temp_resources_list(l_temp_resources_list.count).sub_inventory := p_eligible_resources_list(loop_count).sub_inventory;
2301: l_temp_resources_list(l_temp_resources_list.count).available_date := p_eligible_resources_list(loop_count).available_date;
2302: IF loop_count = p_eligible_resources_list.count THEN
2303: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: RETURN;
2306: END IF;
2307: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2304: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: RETURN;
2306: END IF;
2307: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2308: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2309: RETURN;
2310: END IF;
2311: l_temp_options.trim(l_temp_options.count);
2312: l_temp_resources_list.trim(l_temp_resources_list.count);

Line 2316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2312: l_temp_resources_list.trim(l_temp_resources_list.count);
2313: END IF;
2314: ELSE
2315: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
2316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2317: RETURN;
2318: END IF;
2319: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2317: RETURN;
2318: END IF;
2319: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2320: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2321: RETURN;
2322: END IF;
2323: l_temp_options.trim(l_temp_options.count);
2324: l_temp_resources_list.trim(l_temp_resources_list.count);

Line 2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2332: l_temp_resources_list(l_temp_resources_list.count).available_date := p_eligible_resources_list(loop_count).available_date;
2333: END IF;
2334: IF loop_count = p_eligible_resources_list.count THEN
2335: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2337: RETURN;
2338: END IF;
2339: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2337: RETURN;
2338: END IF;
2339: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2341: RETURN;
2342: END IF;
2343: l_temp_options.trim(l_temp_options.count);
2344: l_temp_resources_list.trim(l_temp_resources_list.count);

Line 2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2353: l_temp_resources_list(l_temp_resources_list.count).sub_inventory := p_eligible_resources_list(loop_count).sub_inventory ;
2354: l_temp_resources_list(l_temp_resources_list.count).available_date := p_eligible_resources_list(loop_count).available_date;
2355: IF p_eligible_resources_list.count =1 THEN
2356: CSP_SCH_INT_PVT.OPTIMIZE_OPTIONS(l_temp_resources_list,l_temp_options,l_ship_count,l_res_ship_parameters,x_return_status,x_msg_data,x_msg_count);
2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RETURN;
2359: END IF;
2360: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RETURN;
2359: END IF;
2360: CSP_SCH_INT_PVT.BUILD_FINAL_LIST(l_temp_options,x_options,x_return_status,x_msg_data,x_msg_count);
2361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2362: RETURN;
2363: END IF;
2364: l_temp_options.trim(l_temp_options.count);
2365: l_temp_resources_list.trim(l_temp_resources_list.count);

Line 2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2375: FND_MSG_PUB.ADD;
2376: fnd_msg_pub.count_and_get
2377: ( p_count => x_msg_count
2378: , p_data => x_msg_data);
2379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2380: return;
2381: END GET_TIME_COST;
2382: PROCEDURE BUILD_FINAL_LIST(p_temp_options IN CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE
2383: ,px_options IN OUT NOCOPY CSP_SCH_INT_PVT.csp_sch_options_tbl_typ

Line 2396: x_return_status := FND_API.G_RET_STS_SUCCESS;

2392: l_need_by_date := g_interval.latest_time;
2393: ELSE
2394: l_need_by_date := g_interval.earliest_time;
2395: END IF;
2396: x_return_status := FND_API.G_RET_STS_SUCCESS;
2397: FOR I IN 1..p_temp_options.count LOOP
2398: -- IF round(p_temp_options(I).arrival_date,'MI') <= round(l_need_by_date,'MI') THEN
2399: px_options.extend;
2400: px_options(px_options.count).resource_type := p_temp_options(I).resource_type;

Line 2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2415: FND_MSG_PUB.ADD;
2416: fnd_msg_pub.count_and_get
2417: ( p_count => x_msg_count
2418: , p_data => x_msg_data);
2419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2420: return;
2421: END BUILD_FINAL_LIST;
2422:
2423: PROCEDURE OPTIMIZE_OPTIONS(p_eligible_resources IN CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE

Line 2469: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2465: l_shipping_methods varchar2(2000);
2466: l_to_org_id NUMBER;
2467: l_loc_ship_method_count NUMBER := 0;
2468: BEGIN
2469: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2470: l_resource_shipping_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE() ;
2471: l_temp_rec := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE() ;
2472: x_ship_count := CSP_SCH_INT_PVT.CSP_SHIP_METHOD_COUNT_TBL_TYP() ;
2473: l_ship_quantity := CSP_SCH_INT_PVT.CSP_SHIP_QUANTITY_TBL_TYPE() ;

Line 2493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2489: END LOOP;
2490:
2491: IF do_optimize THEN
2492: CSP_SCH_INT_PVT.CONSOLIDATE_QUANTITIES(p_eligible_resources, l_ship_quantity,x_return_status,x_msg_data,x_msg_count);
2493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2494: return;
2495: END IF;
2496: CSP_SCH_INT_PVT.GET_SHIPPING_PARAMETERS(l_ship_quantity,l_resource_shipping_parameters,x_ship_count,x_return_status,x_msg_data,x_msg_count);
2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2493: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2494: return;
2495: END IF;
2496: CSP_SCH_INT_PVT.GET_SHIPPING_PARAMETERS(l_ship_quantity,l_resource_shipping_parameters,x_ship_count,x_return_status,x_msg_data,x_msg_count);
2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2498: return;
2499: END IF;
2500: x_ship_parameters := l_resource_shipping_parameters;
2501: loop_start := 1 ;

Line 2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2799: FND_MSG_PUB.ADD;
2800: fnd_msg_pub.count_and_get
2801: ( p_count => x_msg_count
2802: , p_data => x_msg_data);
2803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2804: return;
2805: END OPTIMIZE_OPTIONS;
2806:
2807: PROCEDURE CONSOLIDATE_QUANTITIES(p_eligible_resources_list IN CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE

Line 2817: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2813: J NUMBER;
2814: available BOOLEAN;
2815: l_api_name VARCHAR2(60) := 'CSP_SCH_INT_PVT.CONSOLIDATE_QUANTITIES';
2816: BEGIN
2817: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2818: x_ship_quantity := CSP_SCH_INT_PVT.CSP_SHIP_QUANTITY_TBL_TYPE();
2819: x_ship_quantity.trim(x_ship_quantity.count);
2820: FOR I IN 1..p_eligible_resources_list.count LOOP
2821: IF p_eligible_resources_list(I).sub_inventory IS NULL THEN

Line 2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2861: FND_MSG_PUB.ADD;
2862: fnd_msg_pub.count_and_get
2863: ( p_count => x_msg_count
2864: , p_data => x_msg_data);
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: return;
2867: END CONSOLIDATE_QUANTITIES;
2868:
2869: PROCEDURE GET_SHIPPING_PARAMETERS(p_ship_quantity IN CSP_SCH_INT_PVT.CSP_SHIP_QUANTITY_TBL_TYPE,

Line 2988: x_return_status := FND_API.G_RET_STS_SUCCESS;

2984: l_ship_method_present_for_loc boolean := false;
2985: l_ship_method_present_for_reg boolean :=false;
2986: BEGIN
2987: l_server_sys_date := sysdate;
2988: x_return_status := FND_API.G_RET_STS_SUCCESS;
2989: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
2990: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
2991:
2992: IF g_interval.latest_time IS NOT NULL

Line 3015: p_init_msg_list => FND_API.G_FALSE,

3011: CLOSE C2;
3012: END IF;
3013: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3014: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3015: p_init_msg_list => FND_API.G_FALSE,
3016: p_source_tz_id => l_server_time_zone_id,
3017: p_dest_tz_id => l_shipto_timezone_id,
3018: p_source_day_time => sysdate,
3019: x_dest_day_time => l_sysdate,

Line 3056: p_init_msg_list => FND_API.G_FALSE,

3052: END IF;
3053: l_delivery_date := trunc(l_sysdate + l_lead_time);
3054: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3055: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3056: p_init_msg_list => FND_API.G_FALSE,
3057: p_source_tz_id => l_shipto_timezone_id,
3058: p_dest_tz_id => l_server_time_zone_id,
3059: p_source_day_time => l_delivery_date,
3060: x_dest_day_time => l_server_delivery_date,

Line 3141: p_init_msg_list => FND_API.G_FALSE,

3137: END IF;
3138:
3139: IF l_shipto_timezone_id <> l_server_time_zone_id THEN
3140: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3141: p_init_msg_list => FND_API.G_FALSE,
3142: p_source_tz_id => l_shipto_timezone_id,
3143: p_dest_tz_id => l_server_time_zone_id,
3144: p_source_day_time => l_delivery_date,
3145: x_dest_day_time => l_server_delivery_date,

Line 3155: p_init_msg_list => FND_API.G_FALSE,

3151: END IF;
3152:
3153: IF l_cutoff_time is not null then
3154: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3155: p_init_msg_list => FND_API.G_FALSE,
3156: p_source_tz_id => l_timezone_id,
3157: p_dest_tz_id => l_server_time_zone_id,
3158: p_source_day_time => l_cutoff_time,
3159: x_dest_day_time => l_server_cutoff_time,

Line 3226: x_return_status := FND_API.G_RET_STS_ERROR;

3222: FND_MSG_PUB.ADD;
3223: fnd_msg_pub.count_and_get
3224: ( p_count => x_msg_count
3225: , p_data => x_msg_data);
3226: x_return_status := FND_API.G_RET_STS_ERROR;
3227: return;
3228: END IF;
3229: IF csp_ship_methodes%ISOPEN THEN
3230: CLOSE csp_ship_methodes;

Line 3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3249: FND_MSG_PUB.ADD;
3250: fnd_msg_pub.count_and_get
3251: ( p_count => x_msg_count
3252: , p_data => x_msg_data);
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3254: return;
3255: END GET_SHIPPING_PARAMETERS;
3256: PROCEDURE GET_DELIVERY_DATE(p_relation_ship_id IN NUMBER,
3257: x_delivery_date OUT NOCOPY DATE,

Line 3280: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3276: l_delivery_date DATE;
3277: l_default_unit_for_hour varchar2(3);
3278: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_DELIVERY_DATE' ;
3279: BEGIN
3280: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3281: l_default_unit_for_hour := FND_PROFILE.VALUE(NAME => 'CSF_UOM_HOURS');
3282: OPEN C1(p_relation_ship_id);
3283: LOOP
3284: FETCH C1 INTO l_lead_time,l_lead_time_uom,l_delivery_time,l_cutoff_time, l_timezone_id, l_saftey_zone;

Line 3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get
3327: ( p_count => x_msg_count
3328: , p_data => x_msg_data);
3329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3330: return;
3331: END GET_DELIVERY_DATE;
3332:
3333: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY mrp_atp_pub.atp_rec_typ

Line 3337: x_return_status := FND_API.G_RET_STS_SUCCESS;

3333: PROCEDURE EXTEND_ATP_REC(p_atp_rec IN OUT NOCOPY mrp_atp_pub.atp_rec_typ
3334: ,x_return_status OUT NOCOPY VARCHAR2) IS
3335:
3336: BEGIN
3337: x_return_status := FND_API.G_RET_STS_SUCCESS;
3338: p_atp_rec.Row_Id.Extend;
3339: p_atp_rec.Instance_Id.Extend;
3340: p_atp_rec.Inventory_Item_Id.Extend;
3341: p_atp_rec.Inventory_Item_Name.Extend;

Line 3388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3384: p_atp_rec.Old_Source_Organization_Id.EXTEND;
3385: p_atp_rec.Old_Demand_Class.EXTEND;
3386: EXCEPTION
3387: WHEN OTHERS THEN
3388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3389: return;
3390: END EXTEND_ATP_REC;
3391:
3392: FUNCTION CREATE_RESERVATION(p_reservation_parts IN CSP_SCH_INT_PVT.RESERVATION_REC_TYP

Line 3403: l_init_msg_lst varchar2(1) := fnd_api.g_true;

3399: FROM MTL_TXN_SOURCE_TYPES
3400: WHERE transaction_source_type_id = 13;
3401: I NUMBER;
3402: l_api_version_number number :=1;
3403: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3404: x_msg_count number;
3405: -- x_msg_data varchar2(128);
3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;

3405: -- x_msg_data varchar2(128);
3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
3411: l_validation_flag varchar2(1) := fnd_api.g_true;
3412: l_source_type_id NUMBER;
3413: l_source_name varchar2(30);

Line 3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

3406: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
3411: l_validation_flag varchar2(1) := fnd_api.g_true;
3412: l_source_type_id NUMBER;
3413: l_source_name varchar2(30);
3414: x_quantity_reserved number;

Line 3411: l_validation_flag varchar2(1) := fnd_api.g_true;

3407: l_serial_number inv_reservation_global.serial_number_tbl_type;
3408: x_serial_number inv_reservation_global.serial_number_tbl_type;
3409: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3410: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
3411: l_validation_flag varchar2(1) := fnd_api.g_true;
3412: l_source_type_id NUMBER;
3413: l_source_name varchar2(30);
3414: x_quantity_reserved number;
3415: x_reservation_id number;

Line 3419: x_return_status := FND_API.G_RET_STS_SUCCESS;

3415: x_reservation_id number;
3416: l_msg varchar2(2000);
3417: --x_return_status varchar(128);
3418: BEGIN
3419: x_return_status := FND_API.G_RET_STS_SUCCESS;
3420: OPEN csp_transactions;
3421: LOOP
3422: FETCH csp_transactions INTO l_source_type_id, l_source_name;
3423: EXIT WHEN csp_transactions%NOTFOUND;

Line 3516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_reservation_id <= 0 THEN

3512: , p_validation_flag => l_validation_flag
3513: , x_quantity_reserved => x_quantity_reserved
3514: , x_reservation_id => x_reservation_id
3515: );
3516: IF x_return_status <> FND_API.G_RET_STS_SUCCESS and x_reservation_id <= 0 THEN
3517: return 0;
3518: ELSE
3519: return x_reservation_id;
3520: END IF;

Line 3528: x_return_status := FND_API.G_RET_STS_ERROR;

3524: FND_MSG_PUB.ADD;
3525: fnd_msg_pub.count_and_get
3526: ( p_count => x_msg_count
3527: , p_data => x_msg_data);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return 0;
3530: WHEN OTHERS THEN
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3532: return 0;

Line 3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3527: , p_data => x_msg_data);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return 0;
3530: WHEN OTHERS THEN
3531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3532: return 0;
3533: END CREATE_RESERVATION;
3534: PROCEDURE TRANSFER_RESERVATION(p_reservation_id IN NUMBER
3535: ,p_order_header_id IN NUMBER

Line 3544: l_init_msg_lst varchar2(1) := fnd_api.g_true;

3540: ,x_msg_count OUT NOCOPY NUMBER) IS
3541:
3542: I NUMBER;
3543: l_api_version_number number :=1;
3544: l_init_msg_lst varchar2(1) := fnd_api.g_true;
3545: -- x_msg_data varchar2(128);
3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;

Line 3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;

3546: l_old_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
3552: l_validation_flag varchar2(1) := fnd_api.g_true;
3553: l_source_type_id NUMBER;
3554: l_source_name varchar2(30);

Line 3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;

3547: l_new_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
3552: l_validation_flag varchar2(1) := fnd_api.g_true;
3553: l_source_type_id NUMBER;
3554: l_source_name varchar2(30);
3555: x_quantity_reserved number;

Line 3552: l_validation_flag varchar2(1) := fnd_api.g_true;

3548: l_old_serial_number inv_reservation_global.serial_number_tbl_type;
3549: l_new_serial_number inv_reservation_global.serial_number_tbl_type;
3550: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
3551: l_is_transfer_supply varchar2(1) := fnd_api.g_true;
3552: l_validation_flag varchar2(1) := fnd_api.g_true;
3553: l_source_type_id NUMBER;
3554: l_source_name varchar2(30);
3555: x_quantity_reserved number;
3556: l_msg varchar2(2000);

Line 3559: x_return_status := FND_API.G_RET_STS_SUCCESS;

3555: x_quantity_reserved number;
3556: l_msg varchar2(2000);
3557: --x_return_status varchar(128);
3558: BEGIN
3559: x_return_status := FND_API.G_RET_STS_SUCCESS;
3560:
3561: l_old_rsv_rec.reservation_id := p_reservation_id;
3562:
3563: l_new_rsv_rec.reservation_id := NULL;

Line 3582: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3578: , p_to_serial_number => l_new_serial_number
3579: , p_validation_flag => l_validation_flag
3580: , x_to_reservation_id => x_reservation_id
3581: );
3582: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3583: X_return_status := FND_API.G_RET_STS_ERROR;
3584: return;
3585: END IF;
3586: EXCEPTION

Line 3583: X_return_status := FND_API.G_RET_STS_ERROR;

3579: , p_validation_flag => l_validation_flag
3580: , x_to_reservation_id => x_reservation_id
3581: );
3582: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3583: X_return_status := FND_API.G_RET_STS_ERROR;
3584: return;
3585: END IF;
3586: EXCEPTION
3587: WHEN NO_DATA_FOUND THEN

Line 3588: X_return_status := FND_API.G_RET_STS_ERROR;

3584: return;
3585: END IF;
3586: EXCEPTION
3587: WHEN NO_DATA_FOUND THEN
3588: X_return_status := FND_API.G_RET_STS_ERROR;
3589: return;
3590: WHEN OTHERS THEN
3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3592: return;

Line 3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3587: WHEN NO_DATA_FOUND THEN
3588: X_return_status := FND_API.G_RET_STS_ERROR;
3589: return;
3590: WHEN OTHERS THEN
3591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3592: return;
3593: END TRANSFER_RESERVATION;
3594: PROCEDURE GET_SHIPPING_METHODE(p_from_org_id IN NUMBER,
3595: p_to_org_id IN NUMBER,

Line 3631: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3627: l_min_leadtime NUMBER := 100000000;
3628: l_shipping_methode varchar2(30);
3629: l_api_name varchar2(60) := 'CSP_SCH_INT_PVT.GET_SHIPPING_METHODE' ;
3630: BEGIN
3631: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3632: l_server_time_zone_id := FND_PROFILE.VALUE(NAME => 'SERVER_TIMEZONE_ID');
3633: OPEN C3(p_from_org_id,p_to_org_id);
3634: LOOP
3635: FETCH C3 INTO l_cost,l_relation_ship_id ,l_cutoff_time,l_timezone_id,l_shipping_methode ;

Line 3640: p_init_msg_list => FND_API.G_FALSE,

3636: EXIT WHEN C3%NOTFOUND;
3637: CSP_SCH_INT_PVT.GET_DELIVERY_DATE(l_relation_ship_id, x_delivery_date,x_shipping_option,x_return_status,x_msg_data,x_msg_count);
3638: IF p_timezone_id <> l_server_time_zone_id THEN
3639: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3640: p_init_msg_list => FND_API.G_FALSE,
3641: p_source_tz_id => p_timezone_id,
3642: p_dest_tz_id => l_server_time_zone_id,
3643: p_source_day_time => x_delivery_date,
3644: x_dest_day_time => l_server_delivery_date,

Line 3653: p_init_msg_list => FND_API.G_FALSE,

3649: l_server_delivery_date := x_delivery_date;
3650: END IF;
3651: IF l_cutoff_time is not null then
3652: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
3653: p_init_msg_list => FND_API.G_FALSE,
3654: p_source_tz_id => l_timezone_id,
3655: p_dest_tz_id => l_server_time_zone_id,
3656: p_source_day_time => l_cutoff_time,
3657: x_dest_day_time => l_server_cutoff_time,

Line 3687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3683: FND_MSG_PUB.ADD;
3684: fnd_msg_pub.count_and_get
3685: ( p_count => x_msg_count
3686: , p_data => x_msg_data);
3687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3688: return;
3689: END GET_SHIPPING_METHODE;
3690: PROCEDURE CHECK_PARTS_AVAILABILITY(p_resource IN CSP_SCH_INT_PVT.csp_sch_resources_rec_typ
3691: ,p_organization_id IN NUMBER

Line 3863: x_return_status := FND_API.G_RET_STS_SUCCESS;

3859: /* l_subinv_unavailable_list := CSP_SCH_INT_PVT.CSP_UNAVAILABILITY_TBL_TYPE() ;
3860: l_subinv_available_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE();*/
3861: -- x_availability := CSP_SCH_INT_PVT.AVAILABLE_PARTS_TBL_TYP1();
3862: l_interval.latest_time := p_need_by_date;
3863: x_return_status := FND_API.G_RET_STS_SUCCESS;
3864: l_alternate_items_list := alternate_items_table_type();
3865: l_final_available_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE() ;
3866: l_temp_avail_list := CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE() ;
3867: l_timezone_id := p_timezone_id ;

Line 3914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3910: END IF;
3911: IF p_parts_list.count > 1 THEN
3912: csp_supersessions_pvt.check_for_duplicate_parts(p_parts_list,l_temp_org_id,x_return_status,x_msg_data,x_msg_count);
3913: END IF;
3914: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3915: RETURN;
3916: END IF;
3917:
3918: FOR I IN 1..p_parts_list.count LOOP

Line 3985: x_return_status := FND_API.G_RET_STS_ERROR;

3981: l_reservation_parts.revision := l_final_available_list(l_final_available_list.count).revision;
3982: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
3983:
3984: IF l_reservation_id <= 0 THEN
3985: x_return_status := FND_API.G_RET_STS_ERROR;
3986: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
3987: FND_MSG_PUB.ADD;
3988: fnd_msg_pub.count_and_get
3989: ( p_count => x_msg_count

Line 4116: x_return_status := FND_API.G_RET_STS_ERROR;

4112: l_reservation_parts.revision := l_final_available_list(l_final_available_list.count).revision;
4113: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
4114:
4115: IF l_reservation_id <= 0 THEN
4116: x_return_status := FND_API.G_RET_STS_ERROR;
4117: FND_MESSAGE.SET_NAME('CSP', 'CSP_SCH_COULD_NOT_RESERVE');
4118: FND_MSG_PUB.ADD;
4119: fnd_msg_pub.count_and_get
4120: ( p_count => x_msg_count

Line 4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4439: FND_MSG_PUB.ADD;
4440: fnd_msg_pub.count_and_get
4441: ( p_count => x_msg_count
4442: , p_data => x_msg_data);
4443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4444: return;
4445: END CHECK_PARTS_AVAILABILITY;
4446: PROCEDURE CHECK_LOCAL_INVENTORY( p_org_id IN NUMBER
4447: ,p_revision IN varchar2

Line 4482: x_return_status := FND_API.G_RET_STS_SUCCESS ;

4478: BEGIN
4479: IF p_revision IS NOT NULL THEN
4480: l_is_revision_control := TRUE;
4481: END IF;
4482: x_return_status := FND_API.G_RET_STS_SUCCESS ;
4483: x_att := 0;
4484: inv_quantity_tree_pub.clear_quantity_cache;
4485: inv_quantity_tree_pub.query_quantities(p_api_version_number => 1.0
4486: , p_organization_id => p_org_id

Line 4491: , p_init_msg_lst => fnd_api.g_false

4487: , p_inventory_item_id => p_item_id
4488: , p_subinventory_code => p_subinv_code
4489: , x_qoh => x_onhand
4490: , x_atr => l_available
4491: , p_init_msg_lst => fnd_api.g_false
4492: , p_tree_mode => inv_quantity_tree_pvt.g_transaction_mode
4493: , p_is_revision_control => l_is_revision_control
4494: , p_is_lot_control => NULL
4495: , p_is_serial_control => NULL

Line 4524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4520: FND_MSG_PUB.ADD;
4521: fnd_msg_pub.count_and_get
4522: ( p_count => x_msg_count
4523: , p_data => x_msg_data);
4524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4525: return;
4526: END CHECK_LOCAL_INVENTORY;
4527: PROCEDURE TASKS_POST_INSERT( x_return_status out nocopy varchar2) IS
4528: p_task_id NUMBER;

Line 4537: ,p_Init_Msg_List => FND_API.G_FALSE

4533: BEGIN
4534: p_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
4535: CSP_REQUIREMENT_POPULATE_PVT.POPULATE_REQUIREMENTS(p_task_id => p_task_id
4536: ,p_api_version => 1.0
4537: ,p_Init_Msg_List => FND_API.G_FALSE
4538: ,p_commit => FND_API.G_FALSE
4539: ,x_return_status => x_return_status
4540: ,x_msg_data => l_msg_data
4541: ,x_msg_count => l_msg_count

Line 4538: ,p_commit => FND_API.G_FALSE

4534: p_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
4535: CSP_REQUIREMENT_POPULATE_PVT.POPULATE_REQUIREMENTS(p_task_id => p_task_id
4536: ,p_api_version => 1.0
4537: ,p_Init_Msg_List => FND_API.G_FALSE
4538: ,p_commit => FND_API.G_FALSE
4539: ,x_return_status => x_return_status
4540: ,x_msg_data => l_msg_data
4541: ,x_msg_count => l_msg_count
4542: ,px_header_id => l_header_id

Line 5457: p_init_msg_list => FND_API.G_FALSE,

5453: FETCH get_cutoff_time INTO l_cutoff_time , l_timezone_id;
5454: CLOSE get_cutoff_time;
5455: IF l_cutoff_time IS NOT NULL and l_server_time_zone_id IS NOT NULL THEN
5456: HZ_TIMEZONE_PUB.Get_Time( p_api_version => 1.0,
5457: p_init_msg_list => FND_API.G_FALSE,
5458: p_source_tz_id => l_timezone_id,
5459: p_dest_tz_id => l_server_time_zone_id,
5460: p_source_day_time => l_cutoff_time,
5461: x_dest_day_time => l_server_cutoff_time,

Line 5551: x_return_status := FND_API.G_RET_STS_SUCCESS;

5547: and crld.source_type = 'IO'
5548: and oel.header_id = c_order_header_id;
5549:
5550: BEGIN
5551: x_return_status := FND_API.G_RET_STS_SUCCESS;
5552: l_return_status := FND_API.G_RET_STS_SUCCESS;
5553: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
5554: l_task_status_id := jtf_tasks_pub.p_task_user_hooks.task_status_id;
5555: OPEN cleanup_needed;

Line 5552: l_return_status := FND_API.G_RET_STS_SUCCESS;

5548: and oel.header_id = c_order_header_id;
5549:
5550: BEGIN
5551: x_return_status := FND_API.G_RET_STS_SUCCESS;
5552: l_return_status := FND_API.G_RET_STS_SUCCESS;
5553: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
5554: l_task_status_id := jtf_tasks_pub.p_task_user_hooks.task_status_id;
5555: OPEN cleanup_needed;
5556: FETCH cleanup_needed INTO l_cleanup_needed;

Line 5564: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5560: LOOP
5561: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
5562: EXIT WHEN get_reservations%NOTFOUND;
5563: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,l_return_status,x_msg_data,x_msg_count);
5564: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5565: x_return_status := FND_API.G_RET_STS_SUCCESS;
5566: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5567: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
5568: END IF;

Line 5565: x_return_status := FND_API.G_RET_STS_SUCCESS;

5561: FETCH get_reservations INTO l_reserv_id,l_req_details_line_id;
5562: EXIT WHEN get_reservations%NOTFOUND;
5563: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,l_return_status,x_msg_data,x_msg_count);
5564: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5565: x_return_status := FND_API.G_RET_STS_SUCCESS;
5566: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5567: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
5568: END IF;
5569: END LOOP;

Line 5566: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5562: EXIT WHEN get_reservations%NOTFOUND;
5563: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,l_return_status,x_msg_data,x_msg_count);
5564: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5565: x_return_status := FND_API.G_RET_STS_SUCCESS;
5566: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5567: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
5568: END IF;
5569: END LOOP;
5570: close get_reservations;

Line 5580: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5576: FETCH get_order_status INTO l_status;
5577: CLOSE get_order_status;
5578: IF l_status <> 'CANCELLED' THEN
5579: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,l_return_status,x_msg_data,x_msg_count);
5580: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5581: x_return_status := FND_API.G_RET_STS_SUCCESS;
5582: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5583: open get_line_details(l_order_id);
5584: LOOP

Line 5581: x_return_status := FND_API.G_RET_STS_SUCCESS;

5577: CLOSE get_order_status;
5578: IF l_status <> 'CANCELLED' THEN
5579: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,l_return_status,x_msg_data,x_msg_count);
5580: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5581: x_return_status := FND_API.G_RET_STS_SUCCESS;
5582: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5583: open get_line_details(l_order_id);
5584: LOOP
5585: FETCH get_line_details INTO l_req_details_line_id;

Line 5582: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5578: IF l_status <> 'CANCELLED' THEN
5579: CSP_SCH_INT_PVT.CANCEL_ORDER(l_order_id,l_return_status,x_msg_data,x_msg_count);
5580: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5581: x_return_status := FND_API.G_RET_STS_SUCCESS;
5582: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5583: open get_line_details(l_order_id);
5584: LOOP
5585: FETCH get_line_details INTO l_req_details_line_id;
5586: EXIT WHEN get_line_details% NOTFOUND;

Line 5699: l_init_msg_lst varchar2(1) := fnd_api.g_true;

5695: FROM MTL_TXN_SOURCE_TYPES
5696: WHERE transaction_source_type_id = 13;
5697: I NUMBER;
5698: l_api_version_number number :=1;
5699: l_init_msg_lst varchar2(1) := fnd_api.g_true;
5700: x_msg_count number;
5701: -- x_msg_data varchar2(128);
5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;

Line 5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;

5701: -- x_msg_data varchar2(128);
5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5707: l_validation_flag varchar2(1) := fnd_api.g_true;
5708: l_source_type_id NUMBER;
5709: l_source_name varchar2(30);

Line 5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;

5702: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5707: l_validation_flag varchar2(1) := fnd_api.g_true;
5708: l_source_type_id NUMBER;
5709: l_source_name varchar2(30);
5710: x_quantity_reserved number;

Line 5707: l_validation_flag varchar2(1) := fnd_api.g_true;

5703: l_serial_number inv_reservation_global.serial_number_tbl_type;
5704: x_serial_number inv_reservation_global.serial_number_tbl_type;
5705: l_partial_reservation_flag varchar2(1):= fnd_api.g_false;
5706: l_force_reservation_flag varchar2(1) := fnd_api.g_true;
5707: l_validation_flag varchar2(1) := fnd_api.g_true;
5708: l_source_type_id NUMBER;
5709: l_source_name varchar2(30);
5710: x_quantity_reserved number;
5711: x_reservation_id number;

Line 5715: x_return_status := FND_API.G_RET_STS_SUCCESS;

5711: x_reservation_id number;
5712: l_msg varchar2(2000);
5713: --x_return_status varchar(128);
5714: BEGIN
5715: x_return_status := FND_API.G_RET_STS_SUCCESS;
5716: OPEN csp_transactions;
5717: LOOP
5718: FETCH csp_transactions INTO l_source_type_id, l_source_name;
5719: EXIT WHEN csp_transactions%NOTFOUND;

Line 5788: x_return_status := FND_API.G_RET_STS_ERROR;

5784: FND_MSG_PUB.ADD;
5785: fnd_msg_pub.count_and_get
5786: ( p_count => x_msg_count
5787: , p_data => x_msg_data);
5788: x_return_status := FND_API.G_RET_STS_ERROR;
5789: WHEN OTHERS THEN
5790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5791:
5792: END DELETE_RESERVATION;

Line 5790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5786: ( p_count => x_msg_count
5787: , p_data => x_msg_data);
5788: x_return_status := FND_API.G_RET_STS_ERROR;
5789: WHEN OTHERS THEN
5790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5791:
5792: END DELETE_RESERVATION;
5793: END CSP_SCH_INT_PVT;