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.WSM_RESERVATIONS_PVT dependencies on FND_API

Line 27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

23: g_msg_lvl_debug_high NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH ;
24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:
31:

Line 28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

24: g_msg_lvl_debug_medium NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM ;
25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:
31:
32: Procedure modify_reservations_wlt ( p_txn_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,

Line 29: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

25: g_msg_lvl_debug_low NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ;
26:
27: g_ret_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
28: g_ret_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
29: g_ret_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
30:
31:
32: Procedure modify_reservations_wlt ( p_txn_header IN WSM_WIP_LOT_TXN_PVT.WLTX_TRANSACTIONS_REC_TYPE,
33: p_starting_jobs_tbl IN WSM_WIP_LOT_TXN_PVT.WLTX_STARTING_JOBS_TBL_TYPE,

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: savepoint start_modify_rsv_wlt;
74:
75: l_stmt_num := 10;
76: /* Initialize API return status to success */
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_txn_header.organization_id);
80:
81: --First query to check if any reservations asscoiated with the starting job from the calling procedure itself--

Line 96: l_return_status := FND_API.G_RET_STS_SUCCESS;

92: fnd_message.set_name('WSM','WSM_RSV_UPD_ASSY');
93: l_msg_data := fnd_message.get;
94: fnd_file.put_line(fnd_file.log,l_msg_data);
95:
96: l_return_status := FND_API.G_RET_STS_SUCCESS;
97: l_msg_count := 0;
98: l_msg_data := null;
99:
100: l_msg_index := fnd_msg_pub.count_msg;

Line 120: , p_init_msg_lst => fnd_api.g_true

116: --log proc entry
117: inv_reservation_pub.delete_reservation
118: (
119: p_api_version_number => 1.0
120: , p_init_msg_lst => fnd_api.g_true
121: , x_return_status => l_return_status
122: , x_msg_count => l_msg_count
123: , x_msg_data => l_msg_data
124: , p_rsv_rec => l_rsv_old

Line 129: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

125: , p_serial_number => l_dummy_sn
126: );
127:
128: --proc exit
129: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
130: /*API failed*/
131: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
132: --log that rsv api failed
133: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 144: IF l_return_status = fnd_api.g_ret_sts_error THEN

140: p_run_log_level => l_log_level
141: );
142: END IF;
143:
144: IF l_return_status = fnd_api.g_ret_sts_error THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSE
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;

Line 145: RAISE FND_API.G_EXC_ERROR;

141: );
142: END IF;
143:
144: IF l_return_status = fnd_api.g_ret_sts_error THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSE
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149: end if;

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143:
144: IF l_return_status = fnd_api.g_ret_sts_error THEN
145: RAISE FND_API.G_EXC_ERROR;
146: ELSE
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149: end if;
150: end loop; --MP Delete Changes
151: end if; --MP Delete Changes :End of check on l_wsm_rsv_v_tbl.count > 0

Line 172: l_return_status := FND_API.G_RET_STS_SUCCESS;

168: fnd_message.set_name('WSM','WSM_RSV_UPD_ASSY');
169: l_msg_data := fnd_message.get;
170: fnd_file.put_line(fnd_file.log,l_msg_data);
171:
172: l_return_status := FND_API.G_RET_STS_SUCCESS;
173: l_msg_count := 0;
174: l_msg_data := null;
175:
176: l_msg_index := fnd_msg_pub.count_msg;

Line 197: , p_init_msg_lst => fnd_api.g_true

193: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
194: inv_reservation_pub.delete_reservation
195: (
196: p_api_version_number => 1.0
197: , p_init_msg_lst => fnd_api.g_true
198: , x_return_status => l_return_status
199: , x_msg_count => l_msg_count
200: , x_msg_data => l_msg_data
201: , p_rsv_rec => l_rsv_old

Line 205: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

201: , p_rsv_rec => l_rsv_old
202: , p_serial_number => l_dummy_sn
203: );
204:
205: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
206: --API failed--
207: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
208: --log that rsv api failed
209: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 220: IF l_return_status = fnd_api.g_ret_sts_error THEN

216: p_run_log_level => l_log_level
217: );
218: END IF;
219:
220: IF l_return_status = fnd_api.g_ret_sts_error THEN
221: RAISE fnd_api.g_exc_error;
222: ELSE
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;

Line 221: RAISE fnd_api.g_exc_error;

217: );
218: END IF;
219:
220: IF l_return_status = fnd_api.g_ret_sts_error THEN
221: RAISE fnd_api.g_exc_error;
222: ELSE
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225: end if;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219:
220: IF l_return_status = fnd_api.g_ret_sts_error THEN
221: RAISE fnd_api.g_exc_error;
222: ELSE
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: END IF;
225: end if;
226: end loop; --MP delete reservations loop
227: end if; --MP Delete Changes :End of check on l_wsm_rsv_v_tbl.count > 0

Line 258: l_return_status := FND_API.G_RET_STS_SUCCESS;

254:
255:
256: l_mtl_rsv_rec.expected_quantity_uom := l_expected_quantity_uom;
257:
258: l_return_status := FND_API.G_RET_STS_SUCCESS;
259: l_msg_count := 0;
260: l_msg_data := null;
261:
262: l_msg_index := fnd_msg_pub.count_msg;

Line 271: , p_init_msg_lst => fnd_api.g_false

267: , x_msg_count => l_msg_count
268: , x_msg_data => l_msg_data
269: , x_quantity_modified => l_quantity_modified
270: , p_api_version_number => 1.0
271: , p_init_msg_lst => fnd_api.g_false
272: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
273: , p_delete_flag => 'N'
274: , p_sort_by_criteria => null
275: );

Line 277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

273: , p_delete_flag => 'N'
274: , p_sort_by_criteria => null
275: );
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
278: --API failed--
279: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
280: --log that rsv api failed
281: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 291: IF l_return_status = fnd_api.g_ret_sts_error THEN

287: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
288: p_run_log_level => l_log_level
289: );
290: END IF;
291: IF l_return_status = fnd_api.g_ret_sts_error THEN
292: RAISE fnd_api.g_exc_error;
293: ELSE
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;

Line 292: RAISE fnd_api.g_exc_error;

288: p_run_log_level => l_log_level
289: );
290: END IF;
291: IF l_return_status = fnd_api.g_ret_sts_error THEN
292: RAISE fnd_api.g_exc_error;
293: ELSE
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: END IF;

Line 294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

290: END IF;
291: IF l_return_status = fnd_api.g_ret_sts_error THEN
292: RAISE fnd_api.g_exc_error;
293: ELSE
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: END IF;
297: END IF;
298: End if;

Line 305: l_return_status := FND_API.G_RET_STS_SUCCESS;

301: fnd_message.set_name('WSM','WSM_RSV_SPLIT');
302: l_msg_data := fnd_message.get;
303: fnd_file.put_line(fnd_file.log,l_msg_data);
304:
305: l_return_status := FND_API.G_RET_STS_SUCCESS;
306: l_msg_count := 0;
307: l_msg_data := null;
308:
309: l_msg_index := fnd_msg_pub.count_msg;

Line 330: , p_init_msg_lst => fnd_api.g_true

326: --log proc entry
327: inv_reservation_pub.delete_reservation
328: (
329: p_api_version_number => 1.0
330: , p_init_msg_lst => fnd_api.g_true
331: , x_return_status => l_return_status
332: , x_msg_count => l_msg_count
333: , x_msg_data => l_msg_data
334: , p_rsv_rec => l_rsv_old

Line 339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

335: , p_serial_number => l_dummy_sn
336: );
337: --log return
338:
339: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
340: --API failed--
341: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
342: --log that rsv api failed
343: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 353: IF l_return_status = fnd_api.g_ret_sts_error THEN

349: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
350: p_run_log_level => l_log_level
351: );
352: END IF;
353: IF l_return_status = fnd_api.g_ret_sts_error THEN
354: RAISE fnd_api.g_exc_error;
355: ELSE
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;

Line 354: RAISE fnd_api.g_exc_error;

350: p_run_log_level => l_log_level
351: );
352: END IF;
353: IF l_return_status = fnd_api.g_ret_sts_error THEN
354: RAISE fnd_api.g_exc_error;
355: ELSE
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: END IF;

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: END IF;
353: IF l_return_status = fnd_api.g_ret_sts_error THEN
354: RAISE fnd_api.g_exc_error;
355: ELSE
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END IF;
358: END IF;
359: end loop; --MP delete reservations loop
360: end if; --MP Delete Changes :End of check on l_wsm_rsv_v_tbl.count > 0

Line 419: l_return_status := FND_API.G_RET_STS_SUCCESS;

415: --l_rj_index := p_resulting_jobs_tbl.first;
416: l_rsv_new.supply_source_header_id := p_resulting_jobs_tbl(l_rj_index).wip_entity_id;
417: l_rsv_new.supply_source_type_id := inv_reservation_global.g_source_type_wip;
418:
419: l_return_status := FND_API.G_RET_STS_SUCCESS;
420: l_msg_count := 0;
421: l_msg_data := null;
422:
423: l_msg_index := fnd_msg_pub.count_msg;

Line 427: , p_init_msg_lst => fnd_api.g_true

423: l_msg_index := fnd_msg_pub.count_msg;
424:
425: inv_reservation_pub.transfer_reservation(
426: p_api_version_number => 1.0
427: , p_init_msg_lst => fnd_api.g_true
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count
430: , x_msg_data => l_msg_data
431: , p_is_transfer_supply => fnd_api.g_true

Line 431: , p_is_transfer_supply => fnd_api.g_true

427: , p_init_msg_lst => fnd_api.g_true
428: , x_return_status => l_return_status
429: , x_msg_count => l_msg_count
430: , x_msg_data => l_msg_data
431: , p_is_transfer_supply => fnd_api.g_true
432: , p_original_rsv_rec => l_rsv_old --SJ details
433: , p_to_rsv_rec => l_rsv_new --RJ details
434: , p_original_serial_number => l_dummy_sn -- no serial contorl
435: , p_to_serial_number => l_dummy_sn -- no serial control

Line 436: , p_validation_flag => fnd_api.g_true

432: , p_original_rsv_rec => l_rsv_old --SJ details
433: , p_to_rsv_rec => l_rsv_new --RJ details
434: , p_original_serial_number => l_dummy_sn -- no serial contorl
435: , p_to_serial_number => l_dummy_sn -- no serial control
436: , p_validation_flag => fnd_api.g_true
437: , x_to_reservation_id => l_new_rsv_id
438: );
439:
440: --proc exit

Line 441: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

437: , x_to_reservation_id => l_new_rsv_id
438: );
439:
440: --proc exit
441: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
442: --API failed--
443: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
444: --log that rsv api failed
445: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 455: IF l_return_status = fnd_api.g_ret_sts_error THEN

451: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
452: p_run_log_level => l_log_level
453: );
454: END IF;
455: IF l_return_status = fnd_api.g_ret_sts_error THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSE
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;

Line 456: RAISE FND_API.G_EXC_ERROR;

452: p_run_log_level => l_log_level
453: );
454: END IF;
455: IF l_return_status = fnd_api.g_ret_sts_error THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSE
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: end if;

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

454: END IF;
455: IF l_return_status = fnd_api.g_ret_sts_error THEN
456: RAISE FND_API.G_EXC_ERROR;
457: ELSE
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: end if;
461:
462: End loop;

Line 475: l_return_status := FND_API.G_RET_STS_SUCCESS;

471: l_rsv_old.inventory_item_id := p_starting_jobs_tbl(l_counter).primary_item_id;
472: l_rsv_old.organization_id := p_starting_jobs_tbl(l_counter).organization_id;
473: l_rsv_old.supply_source_type_id := 5;
474:
475: l_return_status := FND_API.G_RET_STS_SUCCESS;
476: l_msg_count := 0;
477: l_msg_data := null;
478:
479: l_msg_index := fnd_msg_pub.count_msg;

Line 498: , p_init_msg_lst => fnd_api.g_true

494: For i in l_wsm_rsv_v_tbl.first .. l_wsm_rsv_v_tbl.last loop
495: l_rsv_old.reservation_id := l_wsm_rsv_v_tbl(i).reservation_id;
496: inv_reservation_pub.Delete_reservation (
497: p_api_version_number => 1.0
498: , p_init_msg_lst => fnd_api.g_true
499: , x_return_status => l_return_status
500: , x_msg_count => l_msg_count
501: , x_msg_data => l_msg_data
502: , p_rsv_rec => l_rsv_old

Line 507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

503: , p_serial_number => l_dummy_sn
504: );
505:
506: --proc exit
507: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
508: --API failed--
509: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
510: --log that rsv api failed
511: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 521: IF l_return_status = fnd_api.g_ret_sts_error THEN

517: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
518: p_run_log_level => l_log_level
519: );
520: END IF;
521: IF l_return_status = fnd_api.g_ret_sts_error THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSE
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;

Line 522: RAISE FND_API.G_EXC_ERROR;

518: p_run_log_level => l_log_level
519: );
520: END IF;
521: IF l_return_status = fnd_api.g_ret_sts_error THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSE
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: end if;

Line 524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

520: END IF;
521: IF l_return_status = fnd_api.g_ret_sts_error THEN
522: RAISE FND_API.G_EXC_ERROR;
523: ELSE
524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
525: END IF;
526: end if;
527: end loop; --MP delete reservations loop
528: end if; --MP Delete Changes :End of check on l_wsm_rsv_v_tbl.count > 0

Line 545: l_return_status := FND_API.G_RET_STS_SUCCESS;

541: p_org_id => p_resulting_jobs_tbl(l_rj_index).organization_id ,
542: p_inventory_item_id => p_resulting_jobs_tbl(l_rj_index).primary_item_id
543: );
544: if l_rsvd_qty > p_resulting_jobs_tbl(l_rj_index).net_quantity THEN
545: l_return_status := FND_API.G_RET_STS_SUCCESS;
546: l_msg_count := 0;
547: l_msg_data := null;
548: WSM_RESERVATIONS_PVT.Modify_reservations_jobupdate(
549: p_wip_entity_id => p_resulting_jobs_tbl(l_rj_index).wip_entity_id,

Line 559: if l_return_status <> fnd_api.g_ret_sts_success then

555: x_return_status => l_return_status,
556: x_msg_count => l_msg_count,
557: x_msg_data => l_msg_data
558: ); --this is to handle the change in net qty if any.
559: if l_return_status <> fnd_api.g_ret_sts_success then
560: -- error out...
561:
562: if( g_log_level_statement >= l_log_level ) then
563:

Line 574: RAISE FND_API.G_EXC_ERROR;

570: p_fnd_log_level => G_LOG_LEVEL_ERROR ,
571: p_run_log_level => l_log_level
572: );
573: END IF;
574: RAISE FND_API.G_EXC_ERROR;
575: end if;
576: END IF; --Check on reserved quantity > net_quantity
577: end if;
578:

Line 586: x_return_status:= FND_API.G_RET_STS_SUCCESS;

582: p_count => x_msg_count ,
583: p_data => x_msg_data
584: );
585:
586: x_return_status:= FND_API.G_RET_STS_SUCCESS;
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589:
590: ROLLBACK TO start_modify_rsv_wlt;

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: );
585:
586: x_return_status:= FND_API.G_RET_STS_SUCCESS;
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589:
590: ROLLBACK TO start_modify_rsv_wlt;
591: x_return_status := G_RET_ERROR;
592: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

593: p_count => x_msg_count ,
594: p_data => x_msg_data
595: );
596:
597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
598:
599: ROLLBACK TO start_modify_rsv_wlt;
600: x_return_status := G_RET_UNEXPECTED;
601:

Line 677: x_return_status := FND_API.G_RET_STS_SUCCESS;

673: savepoint start_modify_rsv_move;
674:
675: l_stmt_num := 10;
676: /* Initialize API return status to success */
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678:
679: /*have this call wherever wsm_reservations_v is used*/
680: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
681:

Line 713: l_return_status := FND_API.G_RET_STS_SUCCESS;

709: from mtl_system_items
710: where inventory_item_id =l_mtl_rsv_rec.inventory_item_id
711: and organization_id = l_mtl_rsv_rec.organization_id;
712:
713: l_return_status := FND_API.G_RET_STS_SUCCESS;
714: l_msg_count := 0;
715: l_msg_data := null;
716:
717: l_msg_index := fnd_msg_pub.count_msg;

Line 725: -- , p_init_msg_lst =>fnd_api.g_false

721: -- , x_msg_count =>l_msg_count
722: -- , x_msg_data =>l_msg_data
723: -- , x_quantity_modified => l_quantity_modified
724: -- , p_api_version_number =>1.0
725: -- , p_init_msg_lst =>fnd_api.g_false
726: -- , p_mtl_rsv_rec =>l_mtl_rsv_rec
727: -- , delete_flag =>'N'
728: -- );
729: --

Line 738: , p_init_msg_lst => fnd_api.g_false

734: , x_msg_count => l_msg_count
735: , x_msg_data => l_msg_data
736: , x_quantity_modified => l_quantity_modified
737: , p_api_version_number => 1.0
738: , p_init_msg_lst => fnd_api.g_false
739: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
740: , p_delete_flag => 'N'
741: , p_sort_by_criteria => null
742: );

Line 743: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

739: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
740: , p_delete_flag => 'N'
741: , p_sort_by_criteria => null
742: );
743: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
744: /*API failed*/
745: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
746: --log that rsv api failed
747: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 757: IF l_return_status = fnd_api.g_ret_sts_error THEN

753: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
754: p_run_log_level => l_log_level
755: );
756: END IF;
757: IF l_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE FND_API.G_EXC_ERROR;
759: ELSE
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;

Line 758: RAISE FND_API.G_EXC_ERROR;

754: p_run_log_level => l_log_level
755: );
756: END IF;
757: IF l_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE FND_API.G_EXC_ERROR;
759: ELSE
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762: end if;

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

756: END IF;
757: IF l_return_status = fnd_api.g_ret_sts_error THEN
758: RAISE FND_API.G_EXC_ERROR;
759: ELSE
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762: end if;
763:
764: End if;

Line 851: l_return_status := FND_API.G_RET_STS_SUCCESS;

847: IF l_reservation_quantity < l_rsv_new.primary_reservation_quantity THEN
848: l_rsv_new.primary_reservation_quantity := l_reservation_quantity;
849: END IF;
850:
851: l_return_status := FND_API.G_RET_STS_SUCCESS;
852: l_msg_count := 0;
853: l_msg_data := null;
854:
855: l_msg_index := fnd_msg_pub.count_msg;

Line 858: , p_init_msg_lst => fnd_api.g_true

854:
855: l_msg_index := fnd_msg_pub.count_msg;
856:
857: inv_reservation_pub.transfer_reservation( p_api_version_number => 1.0
858: , p_init_msg_lst => fnd_api.g_true
859: , x_return_status => l_return_status
860: , x_msg_count => l_msg_count
861: , x_msg_data => l_msg_data
862: , p_is_transfer_supply => fnd_api.g_true

Line 862: , p_is_transfer_supply => fnd_api.g_true

858: , p_init_msg_lst => fnd_api.g_true
859: , x_return_status => l_return_status
860: , x_msg_count => l_msg_count
861: , x_msg_data => l_msg_data
862: , p_is_transfer_supply => fnd_api.g_true
863: , p_original_rsv_rec => l_rsv_old
864: , p_to_rsv_rec => l_rsv_new
865: , p_original_serial_number => l_dummy_sn -- no serial contorl
866: , p_to_serial_number => l_dummy_sn -- no serial control

Line 867: , p_validation_flag => fnd_api.g_true

863: , p_original_rsv_rec => l_rsv_old
864: , p_to_rsv_rec => l_rsv_new
865: , p_original_serial_number => l_dummy_sn -- no serial contorl
866: , p_to_serial_number => l_dummy_sn -- no serial control
867: , p_validation_flag => fnd_api.g_true
868: , x_to_reservation_id => l_new_rsv_id
869: );
870:
871: --proc exit

Line 872: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

868: , x_to_reservation_id => l_new_rsv_id
869: );
870:
871: --proc exit
872: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
873: /*API failed*/
874: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
875: --log that rsv api failed
876: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 886: IF l_return_status = fnd_api.g_ret_sts_error THEN

882: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
883: p_run_log_level => l_log_level
884: );
885: END IF;
886: IF l_return_status = fnd_api.g_ret_sts_error THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSE
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;

Line 887: RAISE FND_API.G_EXC_ERROR;

883: p_run_log_level => l_log_level
884: );
885: END IF;
886: IF l_return_status = fnd_api.g_ret_sts_error THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSE
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891: END IF;

Line 889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

885: END IF;
886: IF l_return_status = fnd_api.g_ret_sts_error THEN
887: RAISE FND_API.G_EXC_ERROR;
888: ELSE
889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
890: END IF;
891: END IF;
892:
893: END IF;

Line 917: x_return_status:= FND_API.G_RET_STS_SUCCESS;

913: p_count => x_msg_count ,
914: p_data => x_msg_data
915: );
916:
917: x_return_status:= FND_API.G_RET_STS_SUCCESS;
918: EXCEPTION
919: WHEN FND_API.G_EXC_ERROR THEN
920:
921: ROLLBACK TO start_modify_rsv_move;

Line 919: WHEN FND_API.G_EXC_ERROR THEN

915: );
916:
917: x_return_status:= FND_API.G_RET_STS_SUCCESS;
918: EXCEPTION
919: WHEN FND_API.G_EXC_ERROR THEN
920:
921: ROLLBACK TO start_modify_rsv_move;
922: x_return_status := G_RET_ERROR;
923: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

924: p_count => x_msg_count ,
925: p_data => x_msg_data
926: );
927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929:
930: ROLLBACK TO start_modify_rsv_move;
931: x_return_status := G_RET_UNEXPECTED;
932:

Line 1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

998: savepoint start_modify_rsv_jobupdate;
999:
1000: l_stmt_num := 10;
1001: /* Initialize API return status to success */
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: /*have this call wherever wsm_reservations_v is used*/
1005: --MO_GLOBAL.SET_POLICY_CONTEXT ('S', p_org_id);
1006:

Line 1026: l_return_status := FND_API.G_RET_STS_SUCCESS;

1022: --l_mtl_rsv_rec.supply_source_header_id := p_wip_entity_id;
1023: --l_mtl_rsv_rec.supply_source_line_id := null;
1024: --l_mtl_rsv_rec.expected_quantity := p_new_net_qty;
1025:
1026: l_return_status := FND_API.G_RET_STS_SUCCESS;
1027: l_msg_count := 0;
1028: l_msg_data := null;
1029:
1030: l_msg_index := fnd_msg_pub.count_msg;

Line 1038: -- , p_init_msg_lst =>fnd_api.g_false

1034: -- , x_msg_count =>l_msg_count
1035: -- , x_msg_data =>l_msg_data
1036: -- , x_quantity_modified => l_quantity_modified
1037: -- , p_api_version_number =>1.0
1038: -- , p_init_msg_lst =>fnd_api.g_false
1039: -- , p_mtl_rsv_rec =>l_mtl_rsv_rec
1040: -- , delete_flag => 'N'
1041: -- );
1042: --proc exit

Line 1061: l_return_status := FND_API.G_RET_STS_SUCCESS;

1057:
1058:
1059: l_mtl_rsv_rec.expected_quantity_uom := l_expected_quantity_uom;
1060:
1061: l_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_msg_count := 0;
1063: l_msg_data := null;
1064:
1065: l_msg_index := fnd_msg_pub.count_msg;

Line 1073: , p_init_msg_lst => fnd_api.g_false

1069: , x_msg_count => l_msg_count
1070: , x_msg_data => l_msg_data
1071: , x_quantity_modified => l_quantity_modified
1072: , p_api_version_number => 1.0
1073: , p_init_msg_lst => fnd_api.g_false
1074: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
1075: , p_delete_flag => 'N'
1076: , p_sort_by_criteria => null
1077: );

Line 1078: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1074: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
1075: , p_delete_flag => 'N'
1076: , p_sort_by_criteria => null
1077: );
1078: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1079: /*API failed*/
1080: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1081: --log that rsv api failed
1082: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 1092: IF l_return_status = fnd_api.g_ret_sts_error THEN

1088: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1089: p_run_log_level => l_log_level
1090: );
1091: END IF;
1092: IF l_return_status = fnd_api.g_ret_sts_error THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: ELSE
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: END IF;

Line 1093: RAISE FND_API.G_EXC_ERROR;

1089: p_run_log_level => l_log_level
1090: );
1091: END IF;
1092: IF l_return_status = fnd_api.g_ret_sts_error THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: ELSE
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: END IF;
1097: end if;

Line 1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1091: END IF;
1092: IF l_return_status = fnd_api.g_ret_sts_error THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: ELSE
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: END IF;
1097: end if;
1098: Elsif p_status_type = 7 then
1099: --In case of interface, Write to WIE 'Note: Job is reserved against sales order(s). Cancelling the job will result in deletion of Job's reservations.'

Line 1104: l_return_status := FND_API.G_RET_STS_SUCCESS;

1100: fnd_message.set_name('WSM','WSM_RSV_JOB_CANCEL');
1101: l_msg_data := fnd_message.get;
1102: fnd_file.put_line(fnd_file.log,l_msg_data);
1103:
1104: l_return_status := FND_API.G_RET_STS_SUCCESS;
1105: l_msg_count := 0;
1106: l_msg_data := null;
1107:
1108: l_msg_index := fnd_msg_pub.count_msg;

Line 1130: , p_init_msg_lst => fnd_api.g_false

1126: , x_msg_count => l_msg_count
1127: , x_msg_data => l_msg_data
1128: , x_quantity_modified => l_quantity_modified
1129: , p_api_version_number => 1.0
1130: , p_init_msg_lst => fnd_api.g_false
1131: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
1132: , p_delete_flag => 'Y'
1133: , p_sort_by_criteria => null
1134: );

Line 1140: , p_init_msg_lst => fnd_api.g_true

1136: -- Commenting call to delete_reservation API for bug 5347562.
1137: /* inv_reservation_pub.delete_reservation
1138: (
1139: p_api_version_number => 1.0
1140: , p_init_msg_lst => fnd_api.g_true
1141: , x_return_status => l_return_status
1142: , x_msg_count => l_msg_count
1143: , x_msg_data => l_msg_data
1144: , p_rsv_rec => l_rsv

Line 1149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1145: , p_serial_number => l_dummy_sn
1146: ); */
1147:
1148: --proc exit
1149: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1150: /*API failed*/
1151: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1152: --log that rsv api failed
1153: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 1163: IF l_return_status = fnd_api.g_ret_sts_error THEN

1159: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1160: p_run_log_level => l_log_level
1161: );
1162: END IF;
1163: IF l_return_status = fnd_api.g_ret_sts_error THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: ELSE
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: p_run_log_level => l_log_level
1161: );
1162: END IF;
1163: IF l_return_status = fnd_api.g_ret_sts_error THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: ELSE
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168: end if;

Line 1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1162: END IF;
1163: IF l_return_status = fnd_api.g_ret_sts_error THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: ELSE
1166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1167: END IF;
1168: end if;
1169: elsif p_new_net_qty =0 and p_status_type <> 7 then -- Added for bug 5290496: START
1170: -- In case of interface,Write to WIE 'Note: Available quantity of the job is below the net quantity.'

Line 1174: l_return_status := FND_API.G_RET_STS_SUCCESS;

1170: -- In case of interface,Write to WIE 'Note: Available quantity of the job is below the net quantity.'
1171: fnd_message.set_name('WSM','WSM_NET_QTY_LOW');
1172: l_msg_data := fnd_message.get;
1173: fnd_file.put_line(fnd_file.log,l_msg_data);
1174: l_return_status := FND_API.G_RET_STS_SUCCESS;
1175: l_msg_count := 0;
1176: l_msg_data := null;
1177:
1178: l_msg_index := fnd_msg_pub.count_msg;

Line 1184: , p_init_msg_lst => fnd_api.g_true

1180: /*
1181: inv_reservation_pub.delete_reservation
1182: (
1183: p_api_version_number => 1.0
1184: , p_init_msg_lst => fnd_api.g_true
1185: , x_return_status => l_return_status
1186: , x_msg_count => l_msg_count
1187: , x_msg_data => l_msg_data
1188: , p_rsv_rec => l_rsv

Line 1210: , p_init_msg_lst => fnd_api.g_false

1206: , x_msg_count => l_msg_count
1207: , x_msg_data => l_msg_data
1208: , x_quantity_modified => l_quantity_modified
1209: , p_api_version_number => 1.0
1210: , p_init_msg_lst => fnd_api.g_false
1211: , p_mtl_maintain_rsv_rec => l_mtl_rsv_rec
1212: , p_delete_flag => 'Y'
1213: , p_sort_by_criteria => null
1214: );

Line 1216: if l_return_status <> FND_API.G_RET_STS_SUCCESS then /API failed/

1212: , p_delete_flag => 'Y'
1213: , p_sort_by_criteria => null
1214: );
1215: -- END: Adding for bug fix 5347562.
1216: if l_return_status <> FND_API.G_RET_STS_SUCCESS then /*API failed*/
1217: WSM_log_PVT.update_errtbl(l_msg_index,l_msg_count);
1218: --log that rsv api failed
1219: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1220: l_msg_tokens.delete;

Line 1229: IF l_return_status = fnd_api.g_ret_sts_error THEN

1225: p_fnd_log_level => G_LOG_LEVEL_STATEMENT ,
1226: p_run_log_level => l_log_level
1227: );
1228: END IF;
1229: IF l_return_status = fnd_api.g_ret_sts_error THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSE
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;

Line 1230: RAISE FND_API.G_EXC_ERROR;

1226: p_run_log_level => l_log_level
1227: );
1228: END IF;
1229: IF l_return_status = fnd_api.g_ret_sts_error THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSE
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: end if; -- Added for bug 5290496: END

Line 1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1228: END IF;
1229: IF l_return_status = fnd_api.g_ret_sts_error THEN
1230: RAISE FND_API.G_EXC_ERROR;
1231: ELSE
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234: end if; -- Added for bug 5290496: END
1235: end if;
1236:

Line 1238: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1234: end if; -- Added for bug 5290496: END
1235: end if;
1236:
1237:
1238: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1239: -- Standard call to get message count and if count is 1, get message info.
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_encoded => 'F' ,
1242: p_count => x_msg_count ,

Line 1246: x_return_status:= FND_API.G_RET_STS_SUCCESS;

1242: p_count => x_msg_count ,
1243: p_data => x_msg_data
1244: );
1245:
1246: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249:
1250: ROLLBACK TO start_modify_rsv_jobupdate;

Line 1248: WHEN FND_API.G_EXC_ERROR THEN

1244: );
1245:
1246: x_return_status:= FND_API.G_RET_STS_SUCCESS;
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249:
1250: ROLLBACK TO start_modify_rsv_jobupdate;
1251: x_return_status := G_RET_ERROR;
1252: FND_MSG_PUB.Count_And_Get ( p_encoded => 'F' ,

Line 1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1253: p_count => x_msg_count ,
1254: p_data => x_msg_data
1255: );
1256:
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258:
1259: ROLLBACK TO start_modify_rsv_jobupdate;
1260: x_return_status := G_RET_UNEXPECTED;
1261: