[Home] [Help]
328: END IF;
329:
330: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
331: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_unexpected_error;
334: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
335: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
336: fnd_msg_pub.ADD;
332: fnd_msg_pub.ADD;
333: RAISE fnd_api.g_exc_unexpected_error;
334: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
335: fnd_message.set_name('WMS', 'WMS_TD_MOL_ERROR');
336: fnd_msg_pub.ADD;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339:
340: l_cg_line := l_trolin_tbl(1).line_id;
384: mydebug('create_mo_line: CG: ' || l_cg_id);
385: mydebug('create_mo_line: TCG: ' || l_tcg_id);
386: END IF;
387:
388: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
389:
390: IF (l_msg_count = 0) THEN
391: IF (l_debug = 1) THEN
392: mydebug('create_mo_line: Successful');
401: mydebug('create_mo_line: Not Successful2');
402: END IF;
403:
404: FOR i IN 1 .. l_msg_count LOOP
405: l_msg_data := fnd_msg_pub.get(i, 'F');
406:
407: IF (l_debug = 1) THEN
408: mydebug('create_mo_line: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
409: END IF;
411: END IF;
412:
413: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
415: fnd_msg_pub.ADD;
416: RAISE fnd_api.g_exc_unexpected_error;
417: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
418: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
419: fnd_msg_pub.ADD;
415: fnd_msg_pub.ADD;
416: RAISE fnd_api.g_exc_unexpected_error;
417: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
418: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
419: fnd_msg_pub.ADD;
420: RAISE fnd_api.g_exc_error;
421: END IF;
422: END IF;
423:
424: x_return_status := fnd_api.g_ret_sts_success;
425: EXCEPTION
426: WHEN fnd_api.g_exc_error THEN
427: x_return_status := fnd_api.g_ret_sts_error;
428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
429: WHEN OTHERS THEN
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
431: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
432: END create_mo_line;
427: x_return_status := fnd_api.g_ret_sts_error;
428: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
429: WHEN OTHERS THEN
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
431: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
432: END create_mo_line;
433:
434: PROCEDURE create_mo(
435: p_org_id IN NUMBER
552: AND NVL(project_id, -1) <> NVL(p_project_id, -1)
553: AND NVL(task_id, -1) <> NVL(p_task_id, -1));
554:
555: fnd_message.set_name('WMS', 'WMS_PROJ_LPN_COMINGLE');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: EXCEPTION
559: WHEN NO_DATA_FOUND THEN
560: NULL;
683: , x_trohdr_val_rec => l_trohdr_val_rec
684: , x_trolin_tbl => l_trolin_tbl
685: , x_trolin_val_tbl => l_trolin_val_tbl
686: );
687: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
688:
689: IF (l_msg_count = 0) THEN
690: IF (l_debug = 1) THEN
691: mydebug('create_mo: Successful');
700: mydebug('create_mo: Not Successful2');
701: END IF;
702:
703: FOR i IN 1 .. l_msg_count LOOP
704: l_msg_data := fnd_msg_pub.get(i, 'F');
705:
706: IF (l_debug = 1) THEN
707: mydebug('create_mo: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
708: END IF;
710: END IF;
711:
712: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
713: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_unexpected_error;
716: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
717: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
718: fnd_msg_pub.ADD;
714: fnd_msg_pub.ADD;
715: RAISE fnd_api.g_exc_unexpected_error;
716: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
717: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
718: fnd_msg_pub.ADD;
719: RAISE fnd_api.g_exc_error;
720: END IF;
721:
722: /* Get header and line ids */
783: mydebug('create_mo: UnexpError In CG');
784: END IF;
785:
786: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
787: fnd_msg_pub.ADD;
788: RAISE fnd_api.g_exc_unexpected_error;
789: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
790: IF (l_debug = 1) THEN
791: mydebug('create_mo: Error In CG');
791: mydebug('create_mo: Error In CG');
792: END IF;
793:
794: fnd_message.set_name('WMS', 'WMS_TD_CG_ERROR');
795: fnd_msg_pub.ADD;
796: RAISE fnd_api.g_exc_error;
797: END IF;
798: END IF;
799: ELSE
830: );
831:
832: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
833: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
834: fnd_msg_pub.ADD;
835: RAISE fnd_api.g_exc_unexpected_error;
836: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
837: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
838: fnd_msg_pub.ADD;
834: fnd_msg_pub.ADD;
835: RAISE fnd_api.g_exc_unexpected_error;
836: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
837: fnd_message.set_name('WMS', 'WMS_TD_MO_ERROR');
838: fnd_msg_pub.ADD;
839: RAISE fnd_api.g_exc_error;
840: END IF;
841: END IF;
842:
843: x_return_status := fnd_api.g_ret_sts_success;
844: EXCEPTION
845: WHEN fnd_api.g_exc_error THEN
846: x_return_status := fnd_api.g_ret_sts_error;
847: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
848: WHEN OTHERS THEN
849: x_return_status := fnd_api.g_ret_sts_unexp_error;
850:
851: IF SQLCODE IS NOT NULL THEN
851: IF SQLCODE IS NOT NULL THEN
852: inv_mobile_helper_functions.sql_error('WMS_Task_Dispatch_put_away.create_mo', '10', SQLCODE);
853: END IF;
854:
855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
856: END create_mo;
857:
858: -- added for bug 3401817
859: -- An autonomous_transaction wrapper arount wms_putaway_suggestions.cleanup_suggestions
1234: mydebug('suggestions_pub: Not an INV LPN');
1235: END IF;
1236:
1237: fnd_message.set_name('WMS', 'WMS_MO_NOT_FOUND');
1238: fnd_msg_pub.ADD;
1239: RAISE fnd_api.g_exc_error;
1240: END IF;
1241: END IF; -- (l_rcount=0) -- fixed in ATF
1242:
1473: , p_sec_uom => l_sec_uom -- Added for OPM Convergance
1474: );
1475: -- bug fix 2271470
1476: l_m_hdr := NULL;
1477: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1478:
1479: IF (l_msg_count = 0) THEN
1480: IF (l_debug = 1) THEN
1481: mydebug('suggestions_pub: Successful');
1490: mydebug('suggestions_pub: Not Successful2');
1491: END IF;
1492:
1493: FOR i IN 1 .. l_msg_count LOOP
1494: l_msg_data := fnd_msg_pub.get(i, 'F');
1495:
1496: IF (l_debug = 1) THEN
1497: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1498: END IF;
1500: END IF;
1501:
1502: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1503: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1504: fnd_msg_pub.ADD;
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1507: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1508: fnd_msg_pub.ADD;
1504: fnd_msg_pub.ADD;
1505: RAISE fnd_api.g_exc_error;
1506: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1507: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
1508: fnd_msg_pub.ADD;
1509: RAISE fnd_api.g_exc_error;
1510: END IF;
1511:
1512: IF (l_debug = 1) THEN
1921: mydebug('suggestions_pub: Finished calling crossdock API');
1922: END IF;
1923:
1924: -- See if there are any error messages returned from the API
1925: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
1926:
1927: IF (l_msg_count = 0) THEN
1928: IF (l_debug = 1) THEN
1929: mydebug('suggestions_pub: Successful');
1938: mydebug('suggestions_pub: Not Successful2');
1939: END IF;
1940:
1941: FOR i IN 1 .. l_msg_count LOOP
1942: l_msg_data := fnd_msg_pub.get(i, 'F');
1943:
1944: IF (l_debug = 1) THEN
1945: mydebug('suggestions_pub: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
1946: END IF;
2068: , p_reservations => l_mtl_reservation
2069: , p_suggest_serial => l_serial_flag
2070: , p_quick_pick_flag => l_quick_pick_flag
2071: );
2072: -- fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2073:
2074: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2075: IF (l_debug = 1) THEN
2076: mydebug('suggestions_pub: unexpected error in inv_ppengine_pvt.create_suggestions');
2076: mydebug('suggestions_pub: unexpected error in inv_ppengine_pvt.create_suggestions');
2077: END IF;
2078:
2079: fnd_message.set_name('WMS', 'WMS_ALLOCATE_FAIL');
2080: fnd_msg_pub.ADD;
2081: RAISE fnd_api.g_exc_error;
2082: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2083: IF (l_debug = 1) THEN
2084: mydebug('suggestions_pub: expected error in inv_ppengine_pvt.create_suggestions');
2084: mydebug('suggestions_pub: expected error in inv_ppengine_pvt.create_suggestions');
2085: END IF;
2086:
2087: fnd_message.set_name('WMS', 'WMS_ALLOCATE_FAIL');
2088: fnd_msg_pub.ADD;
2089: RAISE fnd_api.g_exc_error;
2090: END IF;
2091:
2092: IF (l_debug = 1) THEN
2177: -- doesn't seem to be a valid seeded message.
2178: --ROLLBACK TO mtl_stat_chk;
2179: --FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_STATUS');
2180: fnd_message.set_name('WMS', 'WMS_INVALID_LPN_ITEM_STATUS');
2181: fnd_msg_pub.ADD;
2182: RAISE fnd_api.g_exc_error;
2183: END IF;
2184:
2185: /* nsinghi - GME-WMS Integration. Added the following select stmt to determine if Process Org.
2360: -- Bug# 2744186
2361: -- Perform a rollback in the exception blocks
2362: ROLLBACK TO suggestions_pub_sp;
2363: x_return_status := fnd_api.g_ret_sts_error;
2364: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2365:
2366: IF (l_debug = 1) THEN
2367: mydebug('suggestions_pub: Excecution error - ' || SQLERRM);
2368: END IF;
2384: END IF;
2385: WHEN fnd_api.g_exc_unexpected_error THEN
2386: ROLLBACK TO suggestions_pub_sp;
2387: x_return_status := fnd_api.g_ret_sts_unexp_error;
2388: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2389:
2390: IF (l_debug = 1) THEN
2391: mydebug('suggestions_pub: Unexpected error - ' || SQLERRM);
2392: END IF;
2408: END IF;
2409: WHEN OTHERS THEN
2410: ROLLBACK TO suggestions_pub_sp;
2411: x_return_status := fnd_api.g_ret_sts_unexp_error;
2412: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2413:
2414: IF (l_debug = 1) THEN
2415: mydebug('suggestions_pub: Others exception - ' || SQLERRM);
2416: END IF;
2990: , p_secondary_quantity => p_secondary_quantity --OPM Convergence
2991: );
2992:
2993: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2994: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
2995: IF (l_debug = 1) THEN
2996: mydebug('insert_mtli_helper: Error occurred while creating interface lots: ' || l_msg_data);
2997: END IF;
2998: RETURN FALSE;
3059: , p_att_exist => l_yes
3060: , p_update_msn => l_no);
3061:
3062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3063: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
3064: IF (l_debug = 1) THEN
3065: mydebug('insert_msni_helper: Error occurred while creating interface serials: ' || l_msg_data);
3066: END IF;
3067: RETURN FALSE;
3106: err_code => l_errCode,
3107: err_msg => l_errMsg);
3108: IF(l_cst_ret <> 1) THEN
3109: fnd_message.set_name('BOM', 'CST_SNAPSHOT_FAILED');
3110: fnd_msg_pub.ADD;
3111: IF (l_debug = 1) THEN
3112: mydebug('complete_putaway: Error from CSTACOSN.op_snapshot ');
3113: END IF;
3114: raise fnd_api.g_exc_unexpected_error;
3789: IF (l_debug = 1) THEN
3790: mydebug('complete_putaway: Current release is above J. Disallow 0 quantity.');
3791: END IF;
3792: fnd_message.set_name('INV', 'INV_QTY_MUST_EXCEED_ZERO');
3793: fnd_msg_pub.ADD;
3794:
3795: RAISE fnd_api.g_exc_error;
3796: END IF; --IF l_qty <= 0 THEN
3797:
3912: , p_source => 1
3913: , p_cost_group_id => NULL
3914: , x_lpn_id => l_to_lpn_id
3915: );
3916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3917:
3918: IF (x_msg_count = 0) THEN
3919: IF (l_debug = 1) THEN
3920: mydebug('complete_putaway: Successful');
3929: mydebug('complete_putaway: Not Successful2');
3930: END IF;
3931:
3932: FOR i IN 1 .. x_msg_count LOOP
3933: x_msg_data := fnd_msg_pub.get(i, 'F');
3934:
3935: IF (l_debug = 1) THEN
3936: mydebug('complete_putaway: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
3937: END IF;
3939: END IF;
3940:
3941: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3942: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3943: fnd_msg_pub.ADD;
3944: RAISE fnd_api.g_exc_unexpected_error;
3945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
3946: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3947: fnd_msg_pub.ADD;
3943: fnd_msg_pub.ADD;
3944: RAISE fnd_api.g_exc_unexpected_error;
3945: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
3946: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
3947: fnd_msg_pub.ADD;
3948: RAISE fnd_api.g_exc_error;
3949: END IF;
3950: ELSE
3951: -- LPN exists. Get LPN ID
4786: );
4787:
4788: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4789: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4790: fnd_msg_pub.ADD;
4791: RAISE fnd_api.g_exc_unexpected_error;
4792: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4793: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4794: fnd_msg_pub.ADD;
4790: fnd_msg_pub.ADD;
4791: RAISE fnd_api.g_exc_unexpected_error;
4792: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4793: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4794: fnd_msg_pub.ADD;
4795: RAISE fnd_api.g_exc_error;
4796: END IF;
4797: END IF;
4798:
4827: );
4828:
4829: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4830: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4831: fnd_msg_pub.ADD;
4832: RAISE fnd_api.g_exc_unexpected_error;
4833: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4834: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4835: fnd_msg_pub.ADD;
4831: fnd_msg_pub.ADD;
4832: RAISE fnd_api.g_exc_unexpected_error;
4833: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4834: fnd_message.set_name('WMS', 'WMS_LOG_EXCEPTION_FAIL');
4835: fnd_msg_pub.ADD;
4836: RAISE fnd_api.g_exc_error;
4837: END IF;
4838: END IF;
4839:
4966: mydebug('complete_putaway : Error callinf WF wrapper');
4967: END IF;
4968:
4969: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
4970: fnd_msg_pub.ADD;
4971: RAISE fnd_api.g_exc_unexpected_error;
4972: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
4973: IF (l_debug = 1) THEN
4974: mydebug('complete_putaway : Error calling WF wrapper');
4974: mydebug('complete_putaway : Error calling WF wrapper');
4975: END IF;
4976:
4977: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
4978: fnd_msg_pub.ADD;
4979: RAISE fnd_api.g_exc_error;
4980: END IF;
4981: END IF;
4982: END IF;
5048: mydebug('complete_putaway : Error callinf WF wrapper');
5049: END IF;
5050:
5051: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5052: fnd_msg_pub.ADD;
5053: RAISE fnd_api.g_exc_unexpected_error;
5054: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5055: IF (l_debug = 1) THEN
5056: mydebug('complete_putaway : Error calling WF wrapper');
5056: mydebug('complete_putaway : Error calling WF wrapper');
5057: END IF;
5058:
5059: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5060: fnd_msg_pub.ADD;
5061: RAISE fnd_api.g_exc_error;
5062: END IF;
5063: END IF;--END IF l_wf > 0 THEN
5064: END IF; -- END IF IF (( l_wf_process IS NOT NULL AND l_wf_process <> 'WMS_N_STEP_PUTAWAY') OR l_operation_plan_id IS NULL)
5103: , p_subinventory_code => p_sub);
5104:
5105: IF (l_drop_sub_type < 0) THEN
5106: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5107: fnd_msg_pub.add;
5108: IF (l_debug = 1) THEN
5109: mydebug('complete_putaway: Error fetching drop subinventory type');
5110: END IF;
5111: RAISE fnd_api.g_exc_error;
5158: END IF;
5159:
5160: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5161: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5162: fnd_msg_pub.ADD;
5163: RAISE fnd_api.g_exc_unexpected_error;
5164: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5165: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5166: fnd_msg_pub.ADD;
5162: fnd_msg_pub.ADD;
5163: RAISE fnd_api.g_exc_unexpected_error;
5164: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5165: fnd_message.set_name('WMS', 'WMS_TD_DEL_ERROR');
5166: fnd_msg_pub.ADD;
5167: RAISE fnd_api.g_exc_error;
5168: END IF;
5169: --Receiving subinventory - Call Transfer API
5170: ELSE
5205: END IF;
5206:
5207: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5208: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5209: fnd_msg_pub.ADD;
5210: RAISE fnd_api.g_exc_unexpected_error;
5211: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5212: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5213: fnd_msg_pub.ADD;
5209: fnd_msg_pub.ADD;
5210: RAISE fnd_api.g_exc_unexpected_error;
5211: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5212: fnd_message.set_name('WMS', 'WMS_TASK_ERROR');
5213: fnd_msg_pub.ADD;
5214: RAISE fnd_api.g_exc_error;
5215: END IF;
5216: END IF; --END IF check sub type to call the corresponding API
5217:
5294: open_past_period => l_open_past_period);
5295:
5296: IF l_acct_period_id <= 0 THEN
5297: fnd_message.set_name('INV', 'INV_NO_OPEN_PERIOD');
5298: fnd_msg_pub.ADD;
5299: RAISE fnd_api.g_exc_unexpected_error;
5300: END IF;
5301: --End of changes for bug 5403420
5302:
5419: mydebug('complete_putaway : Error callinf WF wrapper');
5420: END IF;
5421:
5422: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5423: fnd_msg_pub.ADD;
5424: RAISE fnd_api.g_exc_unexpected_error;
5425: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5426: IF (l_debug = 1) THEN
5427: mydebug('complete_putaway : Error calling WF wrapper');
5427: mydebug('complete_putaway : Error calling WF wrapper');
5428: END IF;
5429:
5430: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5431: fnd_msg_pub.ADD;
5432: RAISE fnd_api.g_exc_error;
5433: END IF;
5434: END IF; --IF l_wf > 0 THEN
5435: END IF;--IF (p_qty_reason_id > 0) THEN
5513: mydebug('complete_putaway : Error callinf WF wrapper');
5514: END IF;
5515:
5516: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5517: fnd_msg_pub.ADD;
5518: RAISE fnd_api.g_exc_unexpected_error;
5519: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
5520: IF (l_debug = 1) THEN
5521: mydebug('complete_putaway : Error calling WF wrapper');
5521: mydebug('complete_putaway : Error calling WF wrapper');
5522: END IF;
5523:
5524: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
5525: fnd_msg_pub.ADD;
5526: RAISE fnd_api.g_exc_error;
5527: END IF;
5528: END IF;--END IF l_wf > 0 THEN
5529: END IF; --IF (( l_wf_process IS NOT NULL AND l_wf_process <> 'WMS_N_STEP_PUTAWAY') OR l_operation_plan_id IS NULL) THEN
5605: -- Bug# 2744170
5606: -- Perform a rollback in the exception blocks
5607: ROLLBACK TO complete_putaway_sp;
5608: x_return_status := fnd_api.g_ret_sts_error;
5609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5610: IF ser_csr%ISOPEN THEN
5611: CLOSE ser_csr;
5612: END IF;
5613: -- ER 7307189 changes start
5624: WHEN OTHERS THEN
5625:
5626: ROLLBACK TO complete_putaway_sp;
5627: x_return_status := fnd_api.g_ret_sts_unexp_error;
5628: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5629: IF ser_csr%ISOPEN THEN
5630: CLOSE ser_csr;
5631: END IF;
5632: -- ER 7307189 changes start
5838: IF (l_debug = 1) THEN
5839: mydebug('check_lpn_validity: LPN does not belong to ' || l_org_id || ' organization');
5840: END IF;
5841: fnd_message.set_name('INV', 'INV_NO_RESULT_FOUND');
5842: fnd_msg_pub.ADD;
5843: RAISE fnd_api.g_exc_unexpected_error;
5844: END;
5845:
5846: mydebug('check_lpn_validity: LPN Context' || l_lpn_context);
5867: mydebug('check_lpn_validity: LPN does not belong to ' || l_org_id || ' organization');
5868: END IF;
5869:
5870: fnd_message.set_name('INV', 'INV_NO_RESULT_FOUND');
5871: fnd_msg_pub.ADD;
5872: RAISE fnd_api.g_exc_unexpected_error;
5873: WHEN record_locked THEN
5874: IF (l_debug = 1) THEN
5875: mydebug('check_lpn_validity: LPN not available. locked by someone else');
5875: mydebug('check_lpn_validity: LPN not available. locked by someone else');
5876: END IF;
5877:
5878: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
5879: fnd_msg_pub.ADD;
5880: RAISE fnd_api.g_exc_unexpected_error;
5881: END;
5882: END IF;
5883:
6200: END IF;
6201:
6202: x_ret := 3;
6203: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
6204: fnd_msg_pub.ADD;
6205: RAISE fnd_api.g_exc_unexpected_error;
6206: END IF;
6207: END IF;
6208: END IF;
6214: x_return_status := fnd_api.g_ret_sts_success;
6215: EXCEPTION
6216: WHEN OTHERS THEN
6217: x_return_status := fnd_api.g_ret_sts_unexp_error;
6218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6219: END check_lpn_validity;
6220:
6221: PROCEDURE archive_task(
6222: p_temp_id IN NUMBER
6334: EXCEPTION
6335: WHEN OTHERS THEN
6336: x_return_status := fnd_api.g_ret_sts_error;
6337: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6338: fnd_msg_pub.ADD;
6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: END archive_task;
6341:
6342: PROCEDURE archive_task(
6335: WHEN OTHERS THEN
6336: x_return_status := fnd_api.g_ret_sts_error;
6337: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6338: fnd_msg_pub.ADD;
6339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6340: END archive_task;
6341:
6342: PROCEDURE archive_task(
6343: p_temp_id IN NUMBER
6468: END IF;
6469:
6470: x_return_status := fnd_api.g_ret_sts_error;
6471: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6472: fnd_msg_pub.ADD;
6473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6474: END archive_task;
6475:
6476: PROCEDURE putaway_cleanup(
6469:
6470: x_return_status := fnd_api.g_ret_sts_error;
6471: fnd_message.set_name('WMS', 'WMS_TD_AT_FAIL');
6472: fnd_msg_pub.ADD;
6473: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6474: END archive_task;
6475:
6476: PROCEDURE putaway_cleanup(
6477: p_temp_id IN NUMBER
6772: EXCEPTION
6773: WHEN OTHERS THEN
6774: x_return_status := fnd_api.g_ret_sts_error;
6775: fnd_message.set_name('WMS', 'WMS_TD_PUT_CLEAN_FAIL');
6776: fnd_msg_pub.ADD;
6777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6778: END putaway_cleanup;
6779:
6780: PROCEDURE validate_putaway_to_lpn(
6773: WHEN OTHERS THEN
6774: x_return_status := fnd_api.g_ret_sts_error;
6775: fnd_message.set_name('WMS', 'WMS_TD_PUT_CLEAN_FAIL');
6776: fnd_msg_pub.ADD;
6777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
6778: END putaway_cleanup;
6779:
6780: PROCEDURE validate_putaway_to_lpn(
6781: p_org_id IN NUMBER
6840: );
6841:
6842: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
6843: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6844: fnd_msg_pub.ADD;
6845: RAISE fnd_api.g_exc_unexpected_error;
6846: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6847: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6848: fnd_msg_pub.ADD;
6844: fnd_msg_pub.ADD;
6845: RAISE fnd_api.g_exc_unexpected_error;
6846: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
6847: fnd_message.set_name('WMS', 'WMS_TD_CREATE_LPN_ERROR');
6848: fnd_msg_pub.ADD;
6849: RAISE fnd_api.g_exc_error;
6850: END IF;
6851:
6852: x_return := 1;
7092: END IF;
7093:
7094: x_return_status := fnd_api.g_ret_sts_error;
7095: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
7096: fnd_msg_pub.ADD;
7097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7098: END validate_putaway_to_lpn;
7099:
7100: /* This API will check the status of the mmtt lines
7093:
7094: x_return_status := fnd_api.g_ret_sts_error;
7095: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_LPN');
7096: fnd_msg_pub.ADD;
7097: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7098: END validate_putaway_to_lpn;
7099:
7100: /* This API will check the status of the mmtt lines
7101: This will be called from the suggestions_api, as part of the putaway
7539: p_from_cost_group_id => l_lpn_cg_id
7540: );
7541:
7542: l_m_hdr := NULL;
7543: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
7544:
7545: IF (l_msg_count = 0) THEN
7546: IF (l_debug = 1) THEN
7547: mydebug('create_mo_lpn: Successful');
7556: mydebug('create_mo_lpn: Not Successful2');
7557: END IF;
7558:
7559: FOR i IN 1 .. l_msg_count LOOP
7560: l_msg_data := fnd_msg_pub.get(i, 'F');
7561:
7562: IF (l_debug = 1) THEN
7563: mydebug('create_mo_lpn: ' || REPLACE(l_msg_data, fnd_global.local_chr(0), ' '));
7564: END IF;
7566: END IF;
7567:
7568: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
7569: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7570: fnd_msg_pub.ADD;
7571: RAISE fnd_api.g_exc_error;
7572: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
7573: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7574: fnd_msg_pub.ADD;
7570: fnd_msg_pub.ADD;
7571: RAISE fnd_api.g_exc_error;
7572: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
7573: fnd_message.set_name('WMS', 'WMS_TD_CMO_ERROR');
7574: fnd_msg_pub.ADD;
7575: RAISE fnd_api.g_exc_error;
7576: END IF;
7577:
7578: IF (l_debug = 1) THEN
7588:
7589: EXCEPTION
7590: WHEN fnd_api.g_exc_error THEN
7591: x_return_status := fnd_api.g_ret_sts_error;
7592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7593: WHEN OTHERS THEN
7594: x_return_status := fnd_api.g_ret_sts_unexp_error;
7595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7596: END create_mo_lpn;
7591: x_return_status := fnd_api.g_ret_sts_error;
7592: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7593: WHEN OTHERS THEN
7594: x_return_status := fnd_api.g_ret_sts_unexp_error;
7595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7596: END create_mo_lpn;
7597:
7598:
7599: PROCEDURE validate_against_rules(
8004: WHEN fnd_api.g_exc_error THEN
8005: ROLLBACK TO validate_rules_sp;
8006: x_validation_passed := 'N';
8007: x_return_status := fnd_api.g_ret_sts_error;
8008: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8009:
8010: IF (l_debug = 1) THEN
8011: mydebug('Exiting validate_against_rules - Execution error: ' || l_progress || ' '
8012: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8014: WHEN fnd_api.g_exc_unexpected_error THEN
8015: ROLLBACK TO validate_rules_sp;
8016: x_validation_passed := 'N';
8017: x_return_status := fnd_api.g_ret_sts_unexp_error;
8018: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8019:
8020: IF (l_debug = 1) THEN
8021: mydebug('Exiting validate_against_rules - Unexpected error: ' || l_progress || ' '
8022: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8025: ROLLBACK TO validate_rules_sp;
8026: x_validation_passed := 'N';
8027: x_return_status := fnd_api.g_ret_sts_unexp_error;
8028:
8029: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8030: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8031: END IF;
8032:
8033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8026: x_validation_passed := 'N';
8027: x_return_status := fnd_api.g_ret_sts_unexp_error;
8028:
8029: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8030: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8031: END IF;
8032:
8033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8034:
8029: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8030: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8031: END IF;
8032:
8033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8034:
8035: IF (l_debug = 1) THEN
8036: mydebug('Exiting validate_against_rules - Others exception: ' || l_progress || ' '
8037: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8617: EXCEPTION
8618: WHEN fnd_api.g_exc_error THEN
8619: ROLLBACK TO create_suggestions_sp;
8620: x_return_status := fnd_api.g_ret_sts_error;
8621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8622:
8623: IF (l_debug = 1) THEN
8624: mydebug('Exiting create_user_suggestions - Execution error: ' || l_progress || ' '
8625: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8626: END IF;
8627: WHEN fnd_api.g_exc_unexpected_error THEN
8628: ROLLBACK TO create_suggestions_sp;
8629: x_return_status := fnd_api.g_ret_sts_unexp_error;
8630: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8631:
8632: IF (l_debug = 1) THEN
8633: mydebug('Exiting create_user_suggestions - Unexpected error: ' || l_progress || ' '
8634: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8636: WHEN OTHERS THEN
8637: ROLLBACK TO create_suggestions_sp;
8638: x_return_status := fnd_api.g_ret_sts_unexp_error;
8639:
8640: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8641: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8642: END IF;
8643:
8644: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8637: ROLLBACK TO create_suggestions_sp;
8638: x_return_status := fnd_api.g_ret_sts_unexp_error;
8639:
8640: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8641: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8642: END IF;
8643:
8644: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8645:
8640: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8641: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8642: END IF;
8643:
8644: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8645:
8646: IF (l_debug = 1) THEN
8647: mydebug('Exiting create_user_suggestions - Others exception: ' || l_progress || ' '
8648: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8848: WHEN fnd_api.g_exc_error THEN
8849: ROLLBACK TO validate_status_sp;
8850: x_validation_passed := 'N';
8851: x_return_status := fnd_api.g_ret_sts_error;
8852: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8853:
8854: IF (l_debug = 1) THEN
8855: mydebug('Exiting validate_lot_serial_status - Execution error: ' || l_progress || ' '
8856: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8858: WHEN fnd_api.g_exc_unexpected_error THEN
8859: ROLLBACK TO validate_status_sp;
8860: x_validation_passed := 'N';
8861: x_return_status := fnd_api.g_ret_sts_unexp_error;
8862: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8863:
8864: IF (l_debug = 1) THEN
8865: mydebug('Exiting validate_lot_serial_status - Unexpected error: ' || l_progress || ' '
8866: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
8869: ROLLBACK TO validate_status_sp;
8870: x_validation_passed := 'N';
8871: x_return_status := fnd_api.g_ret_sts_unexp_error;
8872:
8873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8874: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8875: END IF;
8876:
8877: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8870: x_validation_passed := 'N';
8871: x_return_status := fnd_api.g_ret_sts_unexp_error;
8872:
8873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8874: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8875: END IF;
8876:
8877: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8878:
8873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8874: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
8875: END IF;
8876:
8877: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8878:
8879: IF (l_debug = 1) THEN
8880: mydebug('Exiting validate_lot_serial_status - Others exception: ' || l_progress || ' '
8881: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
9029: EXCEPTION
9030: WHEN fnd_api.g_exc_error THEN
9031: ROLLBACK TO revert_capacity_sp;
9032: x_return_status := fnd_api.g_ret_sts_error;
9033: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9034:
9035: IF (l_debug = 1) THEN
9036: mydebug(
9037: 'Exiting revert_loc_suggested_capacity - Execution error: ' || l_progress || ' '
9040: END IF;
9041: WHEN fnd_api.g_exc_unexpected_error THEN
9042: ROLLBACK TO revert_capacity_sp;
9043: x_return_status := fnd_api.g_ret_sts_unexp_error;
9044: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9045:
9046: IF (l_debug = 1) THEN
9047: mydebug(
9048: 'Exiting revert_loc_suggested_capacity - Unexpected error: ' || l_progress || ' '
9052: WHEN OTHERS THEN
9053: ROLLBACK TO revert_capacity_sp;
9054: x_return_status := fnd_api.g_ret_sts_unexp_error;
9055:
9056: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9058: END IF;
9059:
9060: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9053: ROLLBACK TO revert_capacity_sp;
9054: x_return_status := fnd_api.g_ret_sts_unexp_error;
9055:
9056: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9058: END IF;
9059:
9060: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9061:
9056: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9057: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9058: END IF;
9059:
9060: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9061:
9062: IF (l_debug = 1) THEN
9063: mydebug(
9064: 'Exiting revert_loc_suggested_capacity - Others exception: ' || l_progress || ' '
9144: END IF;
9145:
9146: l_progress := '30';
9147: -- See if there are any error messages returned from the API
9148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9149:
9150: IF (x_msg_count = 0) THEN
9151: IF (l_debug = 1) THEN
9152: mydebug('Successful');
9161: mydebug('Not Successful2');
9162: END IF;
9163:
9164: FOR i IN 1 .. x_msg_count LOOP
9165: x_msg_data := fnd_msg_pub.get(i, 'F');
9166:
9167: IF (l_debug = 1) THEN
9168: mydebug('Error messages: ' || REPLACE(x_msg_data, fnd_global.local_chr(0), ' '));
9169: END IF;
9228: WHEN fnd_api.g_exc_error THEN
9229: ROLLBACK TO check_crossdock_sp;
9230: x_crossdock := 'N';
9231: x_return_status := fnd_api.g_ret_sts_error;
9232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9233:
9234: IF (l_debug = 1) THEN
9235: mydebug('Exiting check_for_crossdock - Execution error: ' ||
9236: l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
9238: WHEN fnd_api.g_exc_unexpected_error THEN
9239: ROLLBACK TO check_crossdock_sp;
9240: x_crossdock := 'N';
9241: x_return_status := fnd_api.g_ret_sts_unexp_error;
9242: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9243:
9244: IF (l_debug = 1) THEN
9245: mydebug('Exiting check_for_crossdock - Unexpected error: ' ||
9246: l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
9249: ROLLBACK TO check_crossdock_sp;
9250: x_crossdock := 'N';
9251: x_return_status := fnd_api.g_ret_sts_unexp_error;
9252:
9253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9254: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9255: END IF;
9256:
9257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9250: x_crossdock := 'N';
9251: x_return_status := fnd_api.g_ret_sts_unexp_error;
9252:
9253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9254: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9255: END IF;
9256:
9257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9258:
9253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
9254: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
9255: END IF;
9256:
9257: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
9258:
9259: IF (l_debug = 1) THEN
9260: mydebug('Exiting check_for_crossdock - Others exception: ' ||
9261: l_progress || ' ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));