APPS.WMS_POSTALLOC_PVT dependencies on FND_API

Line 144: x_return_status := fnd_api.g_ret_sts_success;

140: record_locked_exc EXCEPTION;
141: PRAGMA EXCEPTION_INIT (record_locked_exc, -54);
142:
143: BEGIN
144: x_return_status := fnd_api.g_ret_sts_success;
145:
146: SAVEPOINT fetch_wpr_sp;
147:
148: IF g_debug = 1 THEN

Line 215: RAISE fnd_api.g_exc_unexpected_error;

211: IF g_debug = 1 THEN
212: print_debug ('Other error: ' || SQLERRM, l_api_name);
213: END IF;
214: done := TRUE;
215: RAISE fnd_api.g_exc_unexpected_error;
216: END;
217:
218: END LOOP; --}
219:

Line 220: IF x_return_status = fnd_api.g_ret_sts_success THEN

216: END;
217:
218: END LOOP; --}
219:
220: IF x_return_status = fnd_api.g_ret_sts_success THEN
221: x_wpr_rec := l_wpr_rec;
222: END IF;
223:
224: EXCEPTION

Line 225: WHEN fnd_api.g_exc_error THEN

221: x_wpr_rec := l_wpr_rec;
222: END IF;
223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: ROLLBACK TO fetch_wpr_sp;
227: x_return_status := fnd_api.g_ret_sts_error;
228: fnd_msg_pub.count_and_get
229: ( p_count => l_msg_count

Line 227: x_return_status := fnd_api.g_ret_sts_error;

223:
224: EXCEPTION
225: WHEN fnd_api.g_exc_error THEN
226: ROLLBACK TO fetch_wpr_sp;
227: x_return_status := fnd_api.g_ret_sts_error;
228: fnd_msg_pub.count_and_get
229: ( p_count => l_msg_count
230: , p_data => l_msg_data
231: , p_encoded => fnd_api.g_false

Line 231: , p_encoded => fnd_api.g_false

227: x_return_status := fnd_api.g_ret_sts_error;
228: fnd_msg_pub.count_and_get
229: ( p_count => l_msg_count
230: , p_data => l_msg_data
231: , p_encoded => fnd_api.g_false
232: );
233: IF g_debug = 1 THEN
234: print_debug (l_msg_data, l_api_name);
235: END IF;

Line 239: x_return_status := fnd_api.g_ret_sts_unexp_error;

235: END IF;
236:
237: WHEN OTHERS THEN
238: ROLLBACK TO fetch_wpr_sp;
239: x_return_status := fnd_api.g_ret_sts_unexp_error;
240: IF g_debug = 1 THEN
241: print_debug ('Other error: ' || SQLERRM, l_api_name);
242: END IF;
243:

Line 272: x_return_status := fnd_api.g_ret_sts_success;

268: WHERE transaction_batch_id = p_txn_batch_id;
269:
270: BEGIN
271: -- Initialize API return status to success
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: IF g_debug = 1 THEN
275: print_debug( 'Entered with parameters: ' || g_newline ||
276: 'p_transaction_batch_id => ' || p_transaction_batch_id || g_newline ||

Line 335: RAISE fnd_api.g_exc_unexpected_error;

331: ELSE
332: IF g_debug = 1 THEN
333: print_debug ( 'Error setting cache for organization', l_api_name );
334: END IF;
335: RAISE fnd_api.g_exc_unexpected_error;
336: END IF;
337: END IF ;
338:
339: IF g_debug = 1 THEN

Line 366: RAISE fnd_api.g_exc_unexpected_error;

362: ELSE
363: IF g_debug = 1 THEN
364: print_debug('Error setting cache for organization', l_api_name);
365: END IF;
366: RAISE fnd_api.g_exc_unexpected_error;
367: END IF;
368:
369: IF g_debug = 1 THEN
370: print_debug ('No operation plan rules defined', l_api_name);

Line 386: WHEN fnd_api.g_exc_error THEN

382:
383: COMMIT;
384:
385: EXCEPTION
386: WHEN fnd_api.g_exc_error THEN
387: x_return_status := fnd_api.g_ret_sts_error;
388: fnd_msg_pub.count_and_get
389: ( p_count => l_msg_count
390: , p_data => l_msg_data

Line 387: x_return_status := fnd_api.g_ret_sts_error;

383: COMMIT;
384:
385: EXCEPTION
386: WHEN fnd_api.g_exc_error THEN
387: x_return_status := fnd_api.g_ret_sts_error;
388: fnd_msg_pub.count_and_get
389: ( p_count => l_msg_count
390: , p_data => l_msg_data
391: , p_encoded => fnd_api.g_false

Line 391: , p_encoded => fnd_api.g_false

387: x_return_status := fnd_api.g_ret_sts_error;
388: fnd_msg_pub.count_and_get
389: ( p_count => l_msg_count
390: , p_data => l_msg_data
391: , p_encoded => fnd_api.g_false
392: );
393: IF g_debug = 1 THEN
394: print_debug (l_msg_data, l_api_name);
395: END IF;

Line 402: x_return_status := fnd_api.g_ret_sts_unexp_error;

398: CLOSE c_mmtt_cursor;
399: END IF;
400:
401: WHEN OTHERS THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: IF g_debug = 1 THEN
404: print_debug ('Other error: ' || SQLERRM, l_api_name);
405: END IF;
406:

Line 426: x_return_status := fnd_api.g_ret_sts_success;

422: l_wpr_rec wms_pr_workers%ROWTYPE;
423: l_api_return_status VARCHAR2(1);
424:
425: BEGIN
426: x_return_status := fnd_api.g_ret_sts_success;
427:
428: IF g_debug = 1 THEN
429: print_debug( 'Entered with parameters: ' || g_newline ||
430: 'p_batch_id => ' || TO_CHAR(p_batch_id)

Line 435: l_api_return_status := fnd_api.g_ret_sts_success;

431: , l_api_name);
432: END IF;
433:
434: LOOP --{
435: l_api_return_status := fnd_api.g_ret_sts_success;
436: fetch_next_wpr_rec
437: ( p_batch_id => p_batch_id
438: , p_mode => 'OPA'
439: , x_wpr_rec => l_wpr_rec

Line 448: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN

444: IF g_debug = 1 THEN
445: print_debug ( 'No more records in WPR', l_api_name );
446: END IF;
447: EXIT;
448: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN
449: IF g_debug = 1 THEN
450: print_debug('Error status from fetch_next_wpr_rec: '
451: || l_api_return_status, l_api_name);
452: END IF;

Line 453: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

449: IF g_debug = 1 THEN
450: print_debug('Error status from fetch_next_wpr_rec: '
451: || l_api_return_status, l_api_name);
452: END IF;
453: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
454: RAISE fnd_api.g_exc_error;
455: ELSE
456: RAISE fnd_api.g_exc_unexpected_error;
457: END IF;

Line 454: RAISE fnd_api.g_exc_error;

450: print_debug('Error status from fetch_next_wpr_rec: '
451: || l_api_return_status, l_api_name);
452: END IF;
453: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
454: RAISE fnd_api.g_exc_error;
455: ELSE
456: RAISE fnd_api.g_exc_unexpected_error;
457: END IF;
458: END IF;

Line 456: RAISE fnd_api.g_exc_unexpected_error;

452: END IF;
453: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
454: RAISE fnd_api.g_exc_error;
455: ELSE
456: RAISE fnd_api.g_exc_unexpected_error;
457: END IF;
458: END IF;
459:
460: l_api_return_status := fnd_api.g_ret_sts_success;

Line 460: l_api_return_status := fnd_api.g_ret_sts_success;

456: RAISE fnd_api.g_exc_unexpected_error;
457: END IF;
458: END IF;
459:
460: l_api_return_status := fnd_api.g_ret_sts_success;
461: assign_op_plan
462: ( p_transaction_batch_id => l_wpr_rec.transaction_batch_id
463: , p_organization_id => l_wpr_rec.organization_id
464: , x_return_status => l_api_return_status

Line 467: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

463: , p_organization_id => l_wpr_rec.organization_id
464: , x_return_status => l_api_return_status
465: );
466:
467: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
468: IF g_debug = 1 THEN
469: print_debug('Error status from assign_op_plan: '
470: || l_api_return_status, l_api_name);
471: END IF;

Line 472: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

468: IF g_debug = 1 THEN
469: print_debug('Error status from assign_op_plan: '
470: || l_api_return_status, l_api_name);
471: END IF;
472: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
473: RAISE fnd_api.g_exc_error;
474: ELSE
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;

Line 473: RAISE fnd_api.g_exc_error;

469: print_debug('Error status from assign_op_plan: '
470: || l_api_return_status, l_api_name);
471: END IF;
472: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
473: RAISE fnd_api.g_exc_error;
474: ELSE
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477: END IF;

Line 475: RAISE fnd_api.g_exc_unexpected_error;

471: END IF;
472: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
473: RAISE fnd_api.g_exc_error;
474: ELSE
475: RAISE fnd_api.g_exc_unexpected_error;
476: END IF;
477: END IF;
478: END LOOP;
479:

Line 481: WHEN fnd_api.g_exc_error THEN

477: END IF;
478: END LOOP;
479:
480: EXCEPTION
481: WHEN fnd_api.g_exc_error THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get
484: ( p_count => l_msg_count
485: , p_data => l_msg_data

Line 482: x_return_status := fnd_api.g_ret_sts_error;

478: END LOOP;
479:
480: EXCEPTION
481: WHEN fnd_api.g_exc_error THEN
482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get
484: ( p_count => l_msg_count
485: , p_data => l_msg_data
486: , p_encoded => fnd_api.g_false

Line 486: , p_encoded => fnd_api.g_false

482: x_return_status := fnd_api.g_ret_sts_error;
483: fnd_msg_pub.count_and_get
484: ( p_count => l_msg_count
485: , p_data => l_msg_data
486: , p_encoded => fnd_api.g_false
487: );
488: IF g_debug = 1 THEN
489: print_debug (l_msg_data, l_api_name);
490: END IF;

Line 493: x_return_status := fnd_api.g_ret_sts_unexp_error;

489: print_debug (l_msg_data, l_api_name);
490: END IF;
491:
492: WHEN OTHERS THEN
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: IF g_debug = 1 THEN
495: print_debug ('Other error: ' || SQLERRM, l_api_name);
496: END IF;
497:

Line 514: x_return_status := fnd_api.g_ret_sts_success;

510: l_msg_count NUMBER;
511: l_msg_data VARCHAR2(2000);
512:
513: BEGIN
514: x_return_status := fnd_api.g_ret_sts_success;
515:
516: SAVEPOINT create_wct_sp;
517:
518: IF g_debug = 1 THEN

Line 1497: WHEN fnd_api.g_exc_error THEN

1493: print_debug ('Number of rows inserted into WCT: ' || SQL%ROWCOUNT, l_api_name);
1494: END IF;
1495:
1496: EXCEPTION
1497: WHEN fnd_api.g_exc_error THEN
1498: x_return_status := fnd_api.g_ret_sts_error;
1499: ROLLBACK TO create_wct_sp;
1500: fnd_msg_pub.count_and_get
1501: ( p_count => l_msg_count

Line 1498: x_return_status := fnd_api.g_ret_sts_error;

1494: END IF;
1495:
1496: EXCEPTION
1497: WHEN fnd_api.g_exc_error THEN
1498: x_return_status := fnd_api.g_ret_sts_error;
1499: ROLLBACK TO create_wct_sp;
1500: fnd_msg_pub.count_and_get
1501: ( p_count => l_msg_count
1502: , p_data => l_msg_data

Line 1503: , p_encoded => fnd_api.g_false

1499: ROLLBACK TO create_wct_sp;
1500: fnd_msg_pub.count_and_get
1501: ( p_count => l_msg_count
1502: , p_data => l_msg_data
1503: , p_encoded => fnd_api.g_false
1504: );
1505: IF g_debug = 1 THEN
1506: print_debug (l_msg_data, l_api_name);
1507: END IF;

Line 1510: x_return_status := fnd_api.g_ret_sts_unexp_error;

1506: print_debug (l_msg_data, l_api_name);
1507: END IF;
1508:
1509: WHEN OTHERS THEN
1510: x_return_status := fnd_api.g_ret_sts_unexp_error;
1511: ROLLBACK TO create_wct_sp;
1512: IF g_debug = 1 THEN
1513: print_debug ('Other error: ' || SQLERRM, l_api_name);
1514: END IF;

Line 1527: x_return_status := fnd_api.g_ret_sts_success;

1523: l_api_name VARCHAR2(30) := 'merge_wct_to_mmtt';
1524: l_msg_count NUMBER;
1525: l_msg_data VARCHAR2(2000);
1526: BEGIN
1527: x_return_status := fnd_api.g_ret_sts_success;
1528:
1529: SAVEPOINT merge_wct_sp;
1530:
1531: MERGE INTO mtl_material_transactions_temp mmtt

Line 2027: WHEN fnd_api.g_exc_error THEN

2023: print_debug(TO_CHAR(SQL%ROWCOUNT) || ' rows merged.', l_api_name);
2024: END IF;
2025:
2026: EXCEPTION
2027: WHEN fnd_api.g_exc_error THEN
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: ROLLBACK TO merge_wct_sp;
2030: fnd_msg_pub.count_and_get
2031: ( p_count => l_msg_count

Line 2028: x_return_status := fnd_api.g_ret_sts_error;

2024: END IF;
2025:
2026: EXCEPTION
2027: WHEN fnd_api.g_exc_error THEN
2028: x_return_status := fnd_api.g_ret_sts_error;
2029: ROLLBACK TO merge_wct_sp;
2030: fnd_msg_pub.count_and_get
2031: ( p_count => l_msg_count
2032: , p_data => l_msg_data

Line 2033: , p_encoded => fnd_api.g_false

2029: ROLLBACK TO merge_wct_sp;
2030: fnd_msg_pub.count_and_get
2031: ( p_count => l_msg_count
2032: , p_data => l_msg_data
2033: , p_encoded => fnd_api.g_false
2034: );
2035: IF g_debug = 1 THEN
2036: print_debug (l_msg_data, l_api_name);
2037: END IF;

Line 2040: x_return_status := fnd_api.g_ret_sts_unexp_error;

2036: print_debug (l_msg_data, l_api_name);
2037: END IF;
2038:
2039: WHEN OTHERS THEN
2040: x_return_status := fnd_api.g_ret_sts_unexp_error;
2041: ROLLBACK TO merge_wct_sp;
2042: IF g_debug = 1 THEN
2043: print_debug ('Other error: ' || SQLERRM, l_api_name);
2044: END IF;

Line 2073: x_return_status := fnd_api.g_ret_sts_success;

2069:
2070: l_count NUMBER;
2071:
2072: BEGIN
2073: x_return_status := fnd_api.g_ret_sts_success;
2074:
2075: SAVEPOINT rb_carton_sp;
2076:
2077: IF g_debug = 1 THEN

Line 2084: l_api_return_status := fnd_api.g_ret_sts_success;

2080: 'p_move_order_header_id =>' || p_move_order_header_id
2081: , l_api_name);
2082: END IF;
2083:
2084: l_api_return_status := fnd_api.g_ret_sts_success;
2085: assign_pick_slip_numbers
2086: ( p_organization_id => p_org_id
2087: , p_mo_header_id => p_move_order_header_id
2088: , p_grouping_rule_id => NULL

Line 2092: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2088: , p_grouping_rule_id => NULL
2089: , x_return_status => l_api_return_status
2090: );
2091:
2092: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2093: IF g_debug = 1 THEN
2094: print_debug('Error status from assign_pick_slip_number: '
2095: || l_api_return_status, l_api_name);
2096: END IF;

Line 2097: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2093: IF g_debug = 1 THEN
2094: print_debug('Error status from assign_pick_slip_number: '
2095: || l_api_return_status, l_api_name);
2096: END IF;
2097: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2098: RAISE fnd_api.g_exc_error;
2099: ELSE
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;

Line 2098: RAISE fnd_api.g_exc_error;

2094: print_debug('Error status from assign_pick_slip_number: '
2095: || l_api_return_status, l_api_name);
2096: END IF;
2097: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2098: RAISE fnd_api.g_exc_error;
2099: ELSE
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102: END IF;

Line 2100: RAISE fnd_api.g_exc_unexpected_error;

2096: END IF;
2097: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2098: RAISE fnd_api.g_exc_error;
2099: ELSE
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102: END IF;
2103:
2104: l_api_return_status := fnd_api.g_ret_sts_success;

Line 2104: l_api_return_status := fnd_api.g_ret_sts_success;

2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102: END IF;
2103:
2104: l_api_return_status := fnd_api.g_ret_sts_success;
2105:
2106:
2107:
2108: IF g_debug = 1 THEN

Line 2120: l_api_return_status := fnd_api.g_ret_sts_success;

2116: AND from_organization_id = p_org_id
2117: AND enabled_flag = 1
2118: ORDER BY sequence_number;
2119:
2120: l_api_return_status := fnd_api.g_ret_sts_success;
2121: FOR iii IN rules_table1.FIRST .. rules_table1.LAST LOOP --{
2122:
2123: print_debug('Rules return type id is '||rules_table1(iii).return_type_id, l_api_name);
2124:

Line 2142: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2138: );
2139:
2140:
2141:
2142: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2143: IF g_debug = 1 THEN
2144: print_debug('Error status from create_wct: '
2145: || l_api_return_status, l_api_name);
2146: END IF;

Line 2147: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2143: IF g_debug = 1 THEN
2144: print_debug('Error status from create_wct: '
2145: || l_api_return_status, l_api_name);
2146: END IF;
2147: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2148: RAISE fnd_api.g_exc_error;
2149: ELSE
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF;

Line 2148: RAISE fnd_api.g_exc_error;

2144: print_debug('Error status from create_wct: '
2145: || l_api_return_status, l_api_name);
2146: END IF;
2147: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2148: RAISE fnd_api.g_exc_error;
2149: ELSE
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF;
2152: END IF;

Line 2150: RAISE fnd_api.g_exc_unexpected_error;

2146: END IF;
2147: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2148: RAISE fnd_api.g_exc_error;
2149: ELSE
2150: RAISE fnd_api.g_exc_unexpected_error;
2151: END IF;
2152: END IF;
2153:
2154: IF g_debug = 1 THEN

Line 2166: l_api_return_status := fnd_api.g_ret_sts_success;

2162: AND from_organization_id = p_org_id
2163: AND enabled_flag = 1
2164: ORDER BY sequence_number;
2165:
2166: l_api_return_status := fnd_api.g_ret_sts_success;
2167: FOR ii IN rules_table.FIRST .. rules_table.LAST LOOP --{
2168: IF rules_table(ii).return_type_id = 1 THEN
2169: WMS_CARTNZN_PUB.cartonize_single_item
2170: ( x_return_status => l_api_return_status

Line 2209: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2205: , x_return_status => l_api_return_status
2206: );
2207: END IF;
2208:
2209: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2210: IF g_debug = 1 THEN
2211: print_debug('Error status from WMS_CARTNZN_PUB APIs: '
2212: || l_api_return_status, l_api_name);
2213: END IF;

Line 2214: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2210: IF g_debug = 1 THEN
2211: print_debug('Error status from WMS_CARTNZN_PUB APIs: '
2212: || l_api_return_status, l_api_name);
2213: END IF;
2214: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2215: RAISE fnd_api.g_exc_error;
2216: ELSE
2217: RAISE fnd_api.g_exc_unexpected_error;
2218: END IF;

Line 2215: RAISE fnd_api.g_exc_error;

2211: print_debug('Error status from WMS_CARTNZN_PUB APIs: '
2212: || l_api_return_status, l_api_name);
2213: END IF;
2214: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2215: RAISE fnd_api.g_exc_error;
2216: ELSE
2217: RAISE fnd_api.g_exc_unexpected_error;
2218: END IF;
2219: END IF;

Line 2217: RAISE fnd_api.g_exc_unexpected_error;

2213: END IF;
2214: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2215: RAISE fnd_api.g_exc_error;
2216: ELSE
2217: RAISE fnd_api.g_exc_unexpected_error;
2218: END IF;
2219: END IF;
2220:
2221: SELECT count(1) INTO l_count

Line 2235: l_api_return_status := fnd_api.g_ret_sts_success;

2231:
2232: -- If there are any more rows left for cartonization for first level,
2233: -- cartonize through default logic
2234: IF l_count > 0 THEN
2235: l_api_return_status := fnd_api.g_ret_sts_success;
2236: WMS_CARTNZN_PUB.cartonize_default_logic
2237: ( p_org_id => p_org_id
2238: , p_move_order_header_id => p_move_order_header_id
2239: , p_out_bound => 'Y'

Line 2244: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2240: , x_return_status => l_api_return_status
2241: , x_msg_count => l_msg_count
2242: , x_msg_data => l_msg_data
2243: );
2244: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2245: IF g_debug = 1 THEN
2246: print_debug('Error status from cartonize_default_logic: '
2247: || l_api_return_status, l_api_name);
2248: END IF;

Line 2249: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2245: IF g_debug = 1 THEN
2246: print_debug('Error status from cartonize_default_logic: '
2247: || l_api_return_status, l_api_name);
2248: END IF;
2249: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2250: RAISE fnd_api.g_exc_error;
2251: ELSE
2252: RAISE fnd_api.g_exc_unexpected_error;
2253: END IF;

Line 2250: RAISE fnd_api.g_exc_error;

2246: print_debug('Error status from cartonize_default_logic: '
2247: || l_api_return_status, l_api_name);
2248: END IF;
2249: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2250: RAISE fnd_api.g_exc_error;
2251: ELSE
2252: RAISE fnd_api.g_exc_unexpected_error;
2253: END IF;
2254: END IF;

Line 2252: RAISE fnd_api.g_exc_unexpected_error;

2248: END IF;
2249: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2250: RAISE fnd_api.g_exc_error;
2251: ELSE
2252: RAISE fnd_api.g_exc_unexpected_error;
2253: END IF;
2254: END IF;
2255: END IF;
2256:

Line 2264: l_api_return_status := fnd_api.g_ret_sts_success;

2260: END IF;
2261:
2262: WMS_CARTNZN_PUB.pack_level := 0;
2263:
2264: l_api_return_status := fnd_api.g_ret_sts_success;
2265: WMS_CARTNZN_PUB.insert_ph
2266: ( p_move_order_header_id => p_move_order_header_id
2267: , p_current_header_id => p_move_order_header_id
2268: , x_return_status => l_api_return_status

Line 2270: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2266: ( p_move_order_header_id => p_move_order_header_id
2267: , p_current_header_id => p_move_order_header_id
2268: , x_return_status => l_api_return_status
2269: );
2270: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2271: IF g_debug = 1 THEN
2272: print_debug('Error status from cartonize_default_logic: '
2273: || l_api_return_status, l_api_name);
2274: END IF;

Line 2275: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2271: IF g_debug = 1 THEN
2272: print_debug('Error status from cartonize_default_logic: '
2273: || l_api_return_status, l_api_name);
2274: END IF;
2275: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2276: RAISE fnd_api.g_exc_error;
2277: ELSE
2278: RAISE fnd_api.g_exc_unexpected_error;
2279: END IF;

Line 2276: RAISE fnd_api.g_exc_error;

2272: print_debug('Error status from cartonize_default_logic: '
2273: || l_api_return_status, l_api_name);
2274: END IF;
2275: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2276: RAISE fnd_api.g_exc_error;
2277: ELSE
2278: RAISE fnd_api.g_exc_unexpected_error;
2279: END IF;
2280: END IF;

Line 2278: RAISE fnd_api.g_exc_unexpected_error;

2274: END IF;
2275: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2276: RAISE fnd_api.g_exc_error;
2277: ELSE
2278: RAISE fnd_api.g_exc_unexpected_error;
2279: END IF;
2280: END IF;
2281:
2282: IF g_debug = 1 THEN

Line 2288: l_api_return_status := fnd_api.g_ret_sts_success;

2284: print_debug( 'Calling CARTONIZE_MIXED_ITEM for doing MULTI-LEVEL CARTONIZATION'
2285: , l_api_name);
2286: END IF;
2287:
2288: l_api_return_status := fnd_api.g_ret_sts_success;
2289: WMS_CARTNZN_PUB.cartonize_mixed_item
2290: ( x_return_status => l_api_return_status
2291: , x_msg_count => l_msg_count
2292: , x_msg_data => l_msg_data

Line 2299: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2295: , p_move_order_header_id => p_move_order_header_id
2296: , p_transaction_header_id => NULL
2297: , p_pack_level => 1
2298: );
2299: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2300: IF g_debug = 1 THEN
2301: print_debug('Error status from cartonize_mixed_item: '
2302: || l_api_return_status, l_api_name);
2303: END IF;

Line 2304: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2300: IF g_debug = 1 THEN
2301: print_debug('Error status from cartonize_mixed_item: '
2302: || l_api_return_status, l_api_name);
2303: END IF;
2304: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2305: RAISE fnd_api.g_exc_error;
2306: ELSE
2307: RAISE fnd_api.g_exc_unexpected_error;
2308: END IF;

Line 2305: RAISE fnd_api.g_exc_error;

2301: print_debug('Error status from cartonize_mixed_item: '
2302: || l_api_return_status, l_api_name);
2303: END IF;
2304: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2305: RAISE fnd_api.g_exc_error;
2306: ELSE
2307: RAISE fnd_api.g_exc_unexpected_error;
2308: END IF;
2309: END IF;

Line 2307: RAISE fnd_api.g_exc_unexpected_error;

2303: END IF;
2304: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2305: RAISE fnd_api.g_exc_error;
2306: ELSE
2307: RAISE fnd_api.g_exc_unexpected_error;
2308: END IF;
2309: END IF;
2310:
2311: IF g_debug = 1 THEN

Line 2326: RAISE fnd_api.g_exc_unexpected_error;

2322: IF (g_debug = 1) THEN
2323: print_debug( 'Not erroring out since the mode is Pick release'
2324: , l_api_name);
2325: END IF;
2326: RAISE fnd_api.g_exc_unexpected_error;
2327: END;
2328:
2329: DELETE wms_cartonization_temp
2330: WHERE transaction_header_id < 0;

Line 2332: l_api_return_status := fnd_api.g_ret_sts_success;

2328:
2329: DELETE wms_cartonization_temp
2330: WHERE transaction_header_id < 0;
2331:
2332: l_api_return_status := fnd_api.g_ret_sts_success;
2333: merge_wct_to_mmtt(l_api_return_status);
2334: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2335: IF g_debug = 1 THEN
2336: print_debug('Error status from merge_wct_to_mmtt: '

Line 2334: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2330: WHERE transaction_header_id < 0;
2331:
2332: l_api_return_status := fnd_api.g_ret_sts_success;
2333: merge_wct_to_mmtt(l_api_return_status);
2334: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2335: IF g_debug = 1 THEN
2336: print_debug('Error status from merge_wct_to_mmtt: '
2337: || l_api_return_status, l_api_name);
2338: END IF;

Line 2339: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2335: IF g_debug = 1 THEN
2336: print_debug('Error status from merge_wct_to_mmtt: '
2337: || l_api_return_status, l_api_name);
2338: END IF;
2339: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2340: RAISE fnd_api.g_exc_error;
2341: ELSE
2342: RAISE fnd_api.g_exc_unexpected_error;
2343: END IF;

Line 2340: RAISE fnd_api.g_exc_error;

2336: print_debug('Error status from merge_wct_to_mmtt: '
2337: || l_api_return_status, l_api_name);
2338: END IF;
2339: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2340: RAISE fnd_api.g_exc_error;
2341: ELSE
2342: RAISE fnd_api.g_exc_unexpected_error;
2343: END IF;
2344: END IF;

Line 2342: RAISE fnd_api.g_exc_unexpected_error;

2338: END IF;
2339: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2340: RAISE fnd_api.g_exc_error;
2341: ELSE
2342: RAISE fnd_api.g_exc_unexpected_error;
2343: END IF;
2344: END IF;
2345:
2346: COMMIT;

Line 2350: x_return_status := fnd_api.g_ret_sts_unexp_error;

2346: COMMIT;
2347:
2348: EXCEPTION
2349: WHEN OTHERS THEN
2350: x_return_status := fnd_api.g_ret_sts_unexp_error;
2351: ROLLBACK TO rb_carton_sp;
2352: IF g_debug = 1 THEN
2353: print_debug('Error in rulebased_cartonization: ' || SQLERRM, l_api_name);
2354: END IF;

Line 2495: x_return_status := fnd_api.g_ret_sts_success;

2491: AND mtrl.header_id = p_hdr_id
2492: ORDER BY wct.cartonization_id;
2493:
2494: BEGIN
2495: x_return_status := fnd_api.g_ret_sts_success;
2496: error_code := 'CARTONIZE 10';
2497: SAVEPOINT cartonization_sp;
2498:
2499: IF g_debug = 1 THEN

Line 2589: l_api_return_status := fnd_api.g_ret_sts_success;

2585:
2586: IF l_rulebased_setup_exists > 0 THEN
2587: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2588: IF v_cart_value = 1 or v_cart_value = 3 THEN
2589: l_api_return_status := fnd_api.g_ret_sts_success;
2590: rulebased_cartonization
2591: ( x_return_status => l_api_return_status
2592: , p_org_id => p_org_id
2593: , p_move_order_header_id => p_move_order_header_id

Line 2596: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2592: , p_org_id => p_org_id
2593: , p_move_order_header_id => p_move_order_header_id
2594: );
2595:
2596: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2597: IF g_debug = 1 THEN
2598: print_debug('Error status from rulebased_cartonization: '
2599: || l_api_return_status, l_api_name);
2600: END IF;

Line 2601: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2597: IF g_debug = 1 THEN
2598: print_debug('Error status from rulebased_cartonization: '
2599: || l_api_return_status, l_api_name);
2600: END IF;
2601: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2602: RAISE fnd_api.g_exc_error;
2603: ELSE
2604: RAISE fnd_api.g_exc_unexpected_error;
2605: END IF;

Line 2602: RAISE fnd_api.g_exc_error;

2598: print_debug('Error status from rulebased_cartonization: '
2599: || l_api_return_status, l_api_name);
2600: END IF;
2601: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2602: RAISE fnd_api.g_exc_error;
2603: ELSE
2604: RAISE fnd_api.g_exc_unexpected_error;
2605: END IF;
2606: END IF;

Line 2604: RAISE fnd_api.g_exc_unexpected_error;

2600: END IF;
2601: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2602: RAISE fnd_api.g_exc_error;
2603: ELSE
2604: RAISE fnd_api.g_exc_unexpected_error;
2605: END IF;
2606: END IF;
2607:
2608: RETURN;

Line 2635: l_api_return_status := fnd_api.g_ret_sts_success;

2631: END IF;
2632:
2633: error_code := 'CARTONIZE 50';
2634:
2635: l_api_return_status := fnd_api.g_ret_sts_success;
2636: create_wct
2637: ( p_move_order_header_id => p_move_order_header_id
2638: , x_return_status => l_api_return_status
2639: );

Line 2641: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

2637: ( p_move_order_header_id => p_move_order_header_id
2638: , x_return_status => l_api_return_status
2639: );
2640:
2641: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2642: IF g_debug = 1 THEN
2643: print_debug('Error status from create_wct: '
2644: || l_api_return_status, l_api_name);
2645: END IF;

Line 2646: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

2642: IF g_debug = 1 THEN
2643: print_debug('Error status from create_wct: '
2644: || l_api_return_status, l_api_name);
2645: END IF;
2646: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2647: RAISE fnd_api.g_exc_error;
2648: ELSE
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;

Line 2647: RAISE fnd_api.g_exc_error;

2643: print_debug('Error status from create_wct: '
2644: || l_api_return_status, l_api_name);
2645: END IF;
2646: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2647: RAISE fnd_api.g_exc_error;
2648: ELSE
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;
2651: END IF;

Line 2649: RAISE fnd_api.g_exc_unexpected_error;

2645: END IF;
2646: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2647: RAISE fnd_api.g_exc_error;
2648: ELSE
2649: RAISE fnd_api.g_exc_unexpected_error;
2650: END IF;
2651: END IF;
2652:
2653: l_stop_level := -1;

Line 2897: IF((v_return_status = fnd_api.g_ret_sts_success) AND

2893: );
2894:
2895: l_valid_container := 'Y';
2896:
2897: IF((v_return_status = fnd_api.g_ret_sts_success) AND
2898: (v_qty_per_cont > 0) AND
2899: (v_container_item_id IS NOT NULL) AND
2900: (v_container_item_id > 0) ) THEN
2901:

Line 2940: IF ((v_return_status = fnd_api.g_ret_sts_success ) AND

2936: END IF;
2937:
2938: v_prev_item_id := v1.inventory_item_id;
2939:
2940: IF ((v_return_status = fnd_api.g_ret_sts_success ) AND
2941: (v_qty IS NOT NULL) AND
2942: (v_qty > 0) AND
2943: (v_container_item_id IS NOT NULL) AND
2944: (v_container_item_id > 0) ) THEN

Line 2964: IF ((v_return_status <> fnd_api.g_ret_sts_success ) OR

2960: END IF;
2961:
2962: --#chk1
2963:
2964: IF ((v_return_status <> fnd_api.g_ret_sts_success ) OR
2965: (v_qty_per_cont IS NULL) OR
2966: (v_qty IS NULL) OR
2967: (v_container_item_id IS NULL) OR
2968: (v_qty <= 0) OR

Line 3151: IF ( v_return_status <> FND_API.g_ret_sts_success OR

3147: --}
3148: END IF;
3149:
3150: /* Condition #3 */
3151: IF ( v_return_status <> FND_API.g_ret_sts_success OR
3152: v_qty_per_cont IS NULL OR
3153: v_qty_per_cont <= 0 OR
3154: v_container_item_id IS NULL OR
3155: v_tr_qty_per_cont IS NULL OR

Line 3542: RAISE fnd_api.g_exc_unexpected_error;

3538: WHEN OTHERS THEN
3539: IF g_debug = 1 THEN
3540: print_debug('Other error (Pick release mode): ' || SQLERRM, l_api_name);
3541: END IF;
3542: RAISE fnd_api.g_exc_unexpected_error;
3543: END;
3544:
3545: DELETE wms_cartonization_temp
3546: WHERE transaction_header_id < 0;

Line 3548: l_api_return_status := fnd_api.g_ret_sts_success;

3544:
3545: DELETE wms_cartonization_temp
3546: WHERE transaction_header_id < 0;
3547:
3548: l_api_return_status := fnd_api.g_ret_sts_success;
3549: merge_wct_to_mmtt(l_api_return_status);
3550: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3551: IF g_debug = 1 THEN
3552: print_debug('Error status from merge_wct_to_mmtt: '

Line 3550: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

3546: WHERE transaction_header_id < 0;
3547:
3548: l_api_return_status := fnd_api.g_ret_sts_success;
3549: merge_wct_to_mmtt(l_api_return_status);
3550: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
3551: IF g_debug = 1 THEN
3552: print_debug('Error status from merge_wct_to_mmtt: '
3553: || l_api_return_status, l_api_name);
3554: END IF;

Line 3555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

3551: IF g_debug = 1 THEN
3552: print_debug('Error status from merge_wct_to_mmtt: '
3553: || l_api_return_status, l_api_name);
3554: END IF;
3555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
3556: RAISE fnd_api.g_exc_error;
3557: ELSE
3558: RAISE fnd_api.g_exc_unexpected_error;
3559: END IF;

Line 3556: RAISE fnd_api.g_exc_error;

3552: print_debug('Error status from merge_wct_to_mmtt: '
3553: || l_api_return_status, l_api_name);
3554: END IF;
3555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
3556: RAISE fnd_api.g_exc_error;
3557: ELSE
3558: RAISE fnd_api.g_exc_unexpected_error;
3559: END IF;
3560: END IF;

Line 3558: RAISE fnd_api.g_exc_unexpected_error;

3554: END IF;
3555: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
3556: RAISE fnd_api.g_exc_error;
3557: ELSE
3558: RAISE fnd_api.g_exc_unexpected_error;
3559: END IF;
3560: END IF;
3561: END IF; --} /* Cartonization profile = 'Y' */
3562:

Line 3570: WHEN fnd_api.g_exc_error THEN

3566:
3567: COMMIT;
3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_error THEN
3571: ROLLBACK TO cartonization_sp;
3572: x_return_status := fnd_api.g_ret_sts_error;
3573:
3574: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');

Line 3572: x_return_status := fnd_api.g_ret_sts_error;

3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_error THEN
3571: ROLLBACK TO cartonization_sp;
3572: x_return_status := fnd_api.g_ret_sts_error;
3573:
3574: FND_MESSAGE.SET_NAME('WMS', 'WMS_CARTONIZATION_ERROR');
3575: FND_MESSAGE.SET_TOKEN('ERROR_CODE', ERROR_CODE);
3576: FND_MSG_PUB.ADD;

Line 3602: x_return_status := fnd_api.g_ret_sts_unexp_error;

3598: END IF;
3599:
3600: WHEN OTHERS THEN
3601: ROLLBACK TO cartonization_sp;
3602: x_return_status := fnd_api.g_ret_sts_unexp_error;
3603:
3604: ERROR_MSG := SQLERRM;
3605:
3606: IF g_debug = 1 THEN

Line 3838: x_return_status := fnd_api.g_ret_sts_success;

3834:
3835: BEGIN
3836:
3837: -- Initialize API return status to success
3838: x_return_status := fnd_api.g_ret_sts_success;
3839:
3840: SAVEPOINT task_consolidation_sp;
3841:
3842: IF g_debug = 1 THEN

Line 3853: RAISE fnd_api.g_exc_unexpected_error;

3849: IF NOT INV_CACHE.set_mtrh_rec(p_mo_header_id) THEN
3850: IF g_debug = 1 THEN
3851: print_debug( 'Error from INV_CACHE.set_mtrh_rec', l_api_name);
3852: END IF;
3853: RAISE fnd_api.g_exc_unexpected_error;
3854: END IF;
3855:
3856: SELECT spg.bulk_pick_control
3857: INTO l_bulk_pick_control

Line 3879: RAISE fnd_api.g_exc_unexpected_error;

3875: IF l_move_order_type <> inv_globals.g_move_order_pick_wave THEN
3876: IF (g_debug = 1) THEN
3877: print_debug('Move Order is a not pick wave move order', l_api_name );
3878: END IF;
3879: RAISE fnd_api.g_exc_unexpected_error;
3880: END IF;
3881:
3882: SELECT DELIVERY_FLAG
3883: INTO l_delivery_flag

Line 4158: WHEN fnd_api.g_exc_error THEN

4154:
4155: COMMIT;
4156:
4157: EXCEPTION
4158: WHEN fnd_api.g_exc_error THEN
4159: ROLLBACK TO task_consolidation_sp;
4160: x_return_status := fnd_api.g_ret_sts_error;
4161: fnd_msg_pub.count_and_get
4162: ( p_count => l_msg_count

Line 4160: x_return_status := fnd_api.g_ret_sts_error;

4156:
4157: EXCEPTION
4158: WHEN fnd_api.g_exc_error THEN
4159: ROLLBACK TO task_consolidation_sp;
4160: x_return_status := fnd_api.g_ret_sts_error;
4161: fnd_msg_pub.count_and_get
4162: ( p_count => l_msg_count
4163: , p_data => l_msg_data
4164: , p_encoded => fnd_api.g_false

Line 4164: , p_encoded => fnd_api.g_false

4160: x_return_status := fnd_api.g_ret_sts_error;
4161: fnd_msg_pub.count_and_get
4162: ( p_count => l_msg_count
4163: , p_data => l_msg_data
4164: , p_encoded => fnd_api.g_false
4165: );
4166: IF g_debug = 1 THEN
4167: print_debug (l_msg_data, l_api_name);
4168: END IF;

Line 4178: x_return_status := fnd_api.g_ret_sts_unexp_error;

4174: END IF;
4175:
4176: WHEN OTHERS THEN
4177: ROLLBACK TO task_consolidation_sp;
4178: x_return_status := fnd_api.g_ret_sts_unexp_error;
4179: IF g_debug = 1 THEN
4180: print_debug('Other error: ' || SQLERRM, l_api_name);
4181: END IF;
4182: IF task_list%ISOPEN THEN

Line 4296: x_return_status := fnd_api.g_ret_sts_success;

4292:
4293: l_child_rec c_child_tasks%ROWTYPE;
4294:
4295: BEGIN
4296: x_return_status := fnd_api.g_ret_sts_success;
4297:
4298: IF g_debug = 1 THEN
4299: print_debug( 'Entered with parameters: ' || g_newline ||
4300: 'p_mmtt_temp_id => ' || p_mmtt_temp_id

Line 4557: RAISE fnd_api.g_exc_unexpected_error;

4553: IF g_debug = 1 THEN
4554: print_debug ('Error fetching equipment attributes'
4555: || SQLERRM, l_api_name);
4556: END IF;
4557: RAISE fnd_api.g_exc_unexpected_error;
4558: END;
4559: END IF; --}
4560:
4561: IF ((l_equip_vol IS NOT NULL AND l_item_vol IS NOT NULL)

Line 4758: RAISE fnd_api.g_exc_unexpected_error;

4754: WHEN OTHERS THEN
4755: IF g_debug = 1 THEN
4756: print_debug ('Error fetching MMTT record: ' || SQLERRM, l_api_name);
4757: END IF;
4758: RAISE fnd_api.g_exc_unexpected_error;
4759: END;
4760:
4761: SELECT mtl_material_transactions_s.NEXTVAL
4762: INTO l_new_temp_id

Line 4854: l_api_return_status := fnd_api.g_ret_sts_success;

4850: END IF; --}
4851: END LOOP; --}
4852:
4853: -- Copy the lot and serial to the parents
4854: l_api_return_status := fnd_api.g_ret_sts_success;
4855: wms_task_dispatch_engine.duplicate_lot_serial_in_parent
4856: ( p_parent_transaction_temp_id => l_new_temp_id
4857: , x_return_status => l_api_return_status
4858: , x_msg_count => l_msg_count

Line 4861: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

4857: , x_return_status => l_api_return_status
4858: , x_msg_count => l_msg_count
4859: , x_msg_data => l_msg_data
4860: );
4861: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
4862: IF g_debug = 1 THEN
4863: print_debug('Error status from duplicate_lot_serial_in_parent: '
4864: || l_api_return_status, l_api_name);
4865: END IF;

Line 4866: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

4862: IF g_debug = 1 THEN
4863: print_debug('Error status from duplicate_lot_serial_in_parent: '
4864: || l_api_return_status, l_api_name);
4865: END IF;
4866: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4867: RAISE fnd_api.g_exc_error;
4868: ELSE
4869: RAISE fnd_api.g_exc_unexpected_error;
4870: END IF;

Line 4867: RAISE fnd_api.g_exc_error;

4863: print_debug('Error status from duplicate_lot_serial_in_parent: '
4864: || l_api_return_status, l_api_name);
4865: END IF;
4866: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4867: RAISE fnd_api.g_exc_error;
4868: ELSE
4869: RAISE fnd_api.g_exc_unexpected_error;
4870: END IF;
4871: END IF;

Line 4869: RAISE fnd_api.g_exc_unexpected_error;

4865: END IF;
4866: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4867: RAISE fnd_api.g_exc_error;
4868: ELSE
4869: RAISE fnd_api.g_exc_unexpected_error;
4870: END IF;
4871: END IF;
4872: END IF; --}
4873:

Line 4905: l_api_return_status := fnd_api.g_ret_sts_success;

4901: WHERE transaction_temp_id = p_mmtt_temp_id;
4902:
4903: IF p_mmtt_temp_id = l_parent_line_id THEN --{
4904: -- Copy the lot and serial to the parents
4905: l_api_return_status := fnd_api.g_ret_sts_success;
4906: wms_task_dispatch_engine.duplicate_lot_serial_in_parent
4907: ( p_parent_transaction_temp_id => p_mmtt_temp_id
4908: , x_return_status => x_return_status
4909: , x_msg_count => l_msg_count

Line 4912: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

4908: , x_return_status => x_return_status
4909: , x_msg_count => l_msg_count
4910: , x_msg_data => l_msg_data
4911: );
4912: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
4913: IF g_debug = 1 THEN
4914: print_debug('Error status from duplicate_lot_serial_in_parent: '
4915: || l_api_return_status, l_api_name);
4916: END IF;

Line 4917: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

4913: IF g_debug = 1 THEN
4914: print_debug('Error status from duplicate_lot_serial_in_parent: '
4915: || l_api_return_status, l_api_name);
4916: END IF;
4917: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4918: RAISE fnd_api.g_exc_error;
4919: ELSE
4920: RAISE fnd_api.g_exc_unexpected_error;
4921: END IF;

Line 4918: RAISE fnd_api.g_exc_error;

4914: print_debug('Error status from duplicate_lot_serial_in_parent: '
4915: || l_api_return_status, l_api_name);
4916: END IF;
4917: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4918: RAISE fnd_api.g_exc_error;
4919: ELSE
4920: RAISE fnd_api.g_exc_unexpected_error;
4921: END IF;
4922: END IF;

Line 4920: RAISE fnd_api.g_exc_unexpected_error;

4916: END IF;
4917: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
4918: RAISE fnd_api.g_exc_error;
4919: ELSE
4920: RAISE fnd_api.g_exc_unexpected_error;
4921: END IF;
4922: END IF;
4923: END IF; --}
4924: END IF; --}

Line 4937: WHEN fnd_api.g_exc_error THEN

4933:
4934: COMMIT;
4935:
4936: EXCEPTION
4937: WHEN fnd_api.g_exc_error THEN
4938: x_return_status := fnd_api.g_ret_sts_error;
4939: IF l_savepoint_exists THEN
4940: ROLLBACK TO split_task_sp;
4941: END IF;

Line 4938: x_return_status := fnd_api.g_ret_sts_error;

4934: COMMIT;
4935:
4936: EXCEPTION
4937: WHEN fnd_api.g_exc_error THEN
4938: x_return_status := fnd_api.g_ret_sts_error;
4939: IF l_savepoint_exists THEN
4940: ROLLBACK TO split_task_sp;
4941: END IF;
4942: fnd_msg_pub.count_and_get

Line 4945: , p_encoded => fnd_api.g_false

4941: END IF;
4942: fnd_msg_pub.count_and_get
4943: ( p_count => l_msg_count
4944: , p_data => l_msg_data
4945: , p_encoded => fnd_api.g_false
4946: );
4947: IF g_debug = 1 THEN
4948: print_debug (l_msg_data, l_api_name);
4949: END IF;

Line 4959: x_return_status := fnd_api.g_ret_sts_unexp_error;

4955: CLOSE c_child_tasks;
4956: END IF;
4957:
4958: WHEN OTHERS THEN
4959: x_return_status := fnd_api.g_ret_sts_unexp_error;
4960: IF l_savepoint_exists THEN
4961: ROLLBACK TO split_task_sp;
4962: END IF;
4963: IF g_debug = 1 THEN

Line 4998: x_return_status := fnd_api.g_ret_sts_success;

4994: WHERE transaction_batch_id = p_txn_batch_id
4995: AND standard_operation_id IS NOT NULL; -- skip rows without task types
4996:
4997: BEGIN
4998: x_return_status := fnd_api.g_ret_sts_success;
4999:
5000: IF g_debug = 1 THEN
5001: print_debug( 'Entered with parameters: ' || g_newline ||
5002: 'p_batch_id => ' || p_batch_id

Line 5007: l_api_return_status := fnd_api.g_ret_sts_success;

5003: , l_api_name);
5004: END IF;
5005:
5006: LOOP --{
5007: l_api_return_status := fnd_api.g_ret_sts_success;
5008: fetch_next_wpr_rec
5009: ( p_batch_id => p_batch_id
5010: , p_mode => 'TSPLIT'
5011: , x_wpr_rec => l_wpr_rec

Line 5020: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5016: IF g_debug = 1 THEN
5017: print_debug('No more records in WPR', l_api_name);
5018: END IF;
5019: EXIT;
5020: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5021: IF g_debug = 1 THEN
5022: print_debug('Error status from fetch_next_wpr_rec: '
5023: || l_api_return_status, l_api_name);
5024: END IF;

Line 5025: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5021: IF g_debug = 1 THEN
5022: print_debug('Error status from fetch_next_wpr_rec: '
5023: || l_api_return_status, l_api_name);
5024: END IF;
5025: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5026: RAISE fnd_api.g_exc_error;
5027: ELSE
5028: RAISE fnd_api.g_exc_unexpected_error;
5029: END IF;

Line 5026: RAISE fnd_api.g_exc_error;

5022: print_debug('Error status from fetch_next_wpr_rec: '
5023: || l_api_return_status, l_api_name);
5024: END IF;
5025: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5026: RAISE fnd_api.g_exc_error;
5027: ELSE
5028: RAISE fnd_api.g_exc_unexpected_error;
5029: END IF;
5030: END IF;

Line 5028: RAISE fnd_api.g_exc_unexpected_error;

5024: END IF;
5025: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5026: RAISE fnd_api.g_exc_error;
5027: ELSE
5028: RAISE fnd_api.g_exc_unexpected_error;
5029: END IF;
5030: END IF;
5031:
5032: OPEN c_split_tasks (l_wpr_rec.transaction_batch_id);

Line 5041: l_api_return_status := fnd_api.g_ret_sts_success;

5037: EXIT WHEN l_mmtt_temp_id.COUNT = 0;
5038:
5039: FOR ii IN l_mmtt_temp_id.FIRST .. l_mmtt_temp_id.LAST
5040: LOOP --{
5041: l_api_return_status := fnd_api.g_ret_sts_success;
5042: WMS_POSTALLOC_PVT.split_one_task
5043: ( p_mmtt_temp_id => l_mmtt_temp_id(ii)
5044: , x_return_status => l_api_return_status
5045: );

Line 5047: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5043: ( p_mmtt_temp_id => l_mmtt_temp_id(ii)
5044: , x_return_status => l_api_return_status
5045: );
5046:
5047: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5048: IF g_debug = 1 THEN
5049: print_debug('Error status from split_one_task: '
5050: || l_api_return_status, l_api_name);
5051: END IF;

Line 5053: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5049: print_debug('Error status from split_one_task: '
5050: || l_api_return_status, l_api_name);
5051: END IF;
5052: -- Ignore errors, continue to next task
5053: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5054: NULL;
5055: -- RAISE fnd_api.g_exc_error;
5056: ELSE
5057: NULL;

Line 5055: -- RAISE fnd_api.g_exc_error;

5051: END IF;
5052: -- Ignore errors, continue to next task
5053: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5054: NULL;
5055: -- RAISE fnd_api.g_exc_error;
5056: ELSE
5057: NULL;
5058: -- RAISE fnd_api.g_exc_unexpected_error;
5059: END IF;

Line 5058: -- RAISE fnd_api.g_exc_unexpected_error;

5054: NULL;
5055: -- RAISE fnd_api.g_exc_error;
5056: ELSE
5057: NULL;
5058: -- RAISE fnd_api.g_exc_unexpected_error;
5059: END IF;
5060: END IF;
5061:
5062: END LOOP; --}

Line 5072: WHEN fnd_api.g_exc_error THEN

5068:
5069: END LOOP; --}
5070:
5071: EXCEPTION
5072: WHEN fnd_api.g_exc_error THEN
5073: x_return_status := fnd_api.g_ret_sts_error;
5074: fnd_msg_pub.count_and_get
5075: ( p_count => l_msg_count
5076: , p_data => l_msg_data

Line 5073: x_return_status := fnd_api.g_ret_sts_error;

5069: END LOOP; --}
5070:
5071: EXCEPTION
5072: WHEN fnd_api.g_exc_error THEN
5073: x_return_status := fnd_api.g_ret_sts_error;
5074: fnd_msg_pub.count_and_get
5075: ( p_count => l_msg_count
5076: , p_data => l_msg_data
5077: , p_encoded => fnd_api.g_false

Line 5077: , p_encoded => fnd_api.g_false

5073: x_return_status := fnd_api.g_ret_sts_error;
5074: fnd_msg_pub.count_and_get
5075: ( p_count => l_msg_count
5076: , p_data => l_msg_data
5077: , p_encoded => fnd_api.g_false
5078: );
5079: IF g_debug = 1 THEN
5080: print_debug (l_msg_data, l_api_name);
5081: END IF;

Line 5087: x_return_status := fnd_api.g_ret_sts_unexp_error;

5083: CLOSE c_split_tasks;
5084: END IF;
5085:
5086: WHEN OTHERS THEN
5087: x_return_status := fnd_api.g_ret_sts_unexp_error;
5088: IF g_debug = 1 THEN
5089: print_debug ('Other error: ' || sqlerrm, l_api_name);
5090: END IF;
5091: IF c_split_tasks%ISOPEN THEN

Line 5124: x_return_status := fnd_api.g_ret_sts_success;

5120: WHERE transaction_batch_id = p_batch_id;
5121:
5122: BEGIN
5123: -- Initialize API return status to success
5124: x_return_status := fnd_api.g_ret_sts_success;
5125:
5126: IF g_debug = 1 THEN
5127: print_debug( 'Entered with parameters: ' || g_newline ||
5128: 'p_transaction_batch_id => ' || p_transaction_batch_id || g_newline ||

Line 5187: RAISE fnd_api.g_exc_unexpected_error;

5183: ELSE
5184: IF g_debug = 1 THEN
5185: print_debug ( 'Error setting cache for organization', l_api_name );
5186: END IF;
5187: RAISE fnd_api.g_exc_unexpected_error;
5188: END IF;
5189: END IF ;
5190:
5191: IF g_debug = 1 THEN

Line 5217: RAISE fnd_api.g_exc_unexpected_error;

5213: ELSE
5214: IF g_debug = 1 THEN
5215: print_debug('Error setting cache for organization', l_api_name);
5216: END IF;
5217: RAISE fnd_api.g_exc_unexpected_error;
5218: END IF;
5219:
5220: IF g_debug = 1 THEN
5221: print_debug('l_task_type_id value: ' || l_task_type_id, l_api_name);

Line 5236: WHEN fnd_api.g_exc_error THEN

5232:
5233: COMMIT;
5234:
5235: EXCEPTION
5236: WHEN fnd_api.g_exc_error THEN
5237: x_return_status := fnd_api.g_ret_sts_error;
5238: fnd_msg_pub.count_and_get
5239: ( p_count => l_msg_count
5240: , p_data => l_msg_data

Line 5237: x_return_status := fnd_api.g_ret_sts_error;

5233: COMMIT;
5234:
5235: EXCEPTION
5236: WHEN fnd_api.g_exc_error THEN
5237: x_return_status := fnd_api.g_ret_sts_error;
5238: fnd_msg_pub.count_and_get
5239: ( p_count => l_msg_count
5240: , p_data => l_msg_data
5241: , p_encoded => fnd_api.g_false

Line 5241: , p_encoded => fnd_api.g_false

5237: x_return_status := fnd_api.g_ret_sts_error;
5238: fnd_msg_pub.count_and_get
5239: ( p_count => l_msg_count
5240: , p_data => l_msg_data
5241: , p_encoded => fnd_api.g_false
5242: );
5243: IF g_debug = 1 THEN
5244: print_debug (l_msg_data, l_api_name);
5245: END IF;

Line 5251: x_return_status := fnd_api.g_ret_sts_unexp_error;

5247: CLOSE c_mmtt_cursor;
5248: END IF;
5249:
5250: WHEN OTHERS THEN
5251: x_return_status := fnd_api.g_ret_sts_unexp_error;
5252: IF g_debug = 1 THEN
5253: print_debug ('Other error: ' || SQLERRM, l_api_name);
5254: END IF;
5255: IF c_mmtt_cursor%ISOPEN THEN

Line 5276: x_return_status := fnd_api.g_ret_sts_success;

5272: l_wpr_rec wms_pr_workers%ROWTYPE;
5273: l_tta_done BOOLEAN;
5274:
5275: BEGIN
5276: x_return_status := fnd_api.g_ret_sts_success;
5277:
5278: IF g_debug = 1 THEN
5279: print_debug( 'Entered with parameters: ' || g_newline ||
5280: 'p_batch_id => ' || p_batch_id

Line 5286: l_api_return_status := fnd_api.g_ret_sts_success;

5282: END IF;
5283:
5284: l_tta_done := FALSE;
5285: LOOP --{
5286: l_api_return_status := fnd_api.g_ret_sts_success;
5287: fetch_next_wpr_rec
5288: ( p_batch_id => p_batch_id
5289: , p_mode => 'TTA'
5290: , x_wpr_rec => l_wpr_rec

Line 5300: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5296: print_debug('No more records in WPR', l_api_name);
5297: END IF;
5298: l_tta_done := TRUE;
5299: EXIT;
5300: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5301: IF g_debug = 1 THEN
5302: print_debug('Error status from fetch_next_wpr_rec: '
5303: || l_api_return_status, l_api_name);
5304: END IF;

Line 5305: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5301: IF g_debug = 1 THEN
5302: print_debug('Error status from fetch_next_wpr_rec: '
5303: || l_api_return_status, l_api_name);
5304: END IF;
5305: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5306: RAISE fnd_api.g_exc_error;
5307: ELSE
5308: RAISE fnd_api.g_exc_unexpected_error;
5309: END IF;

Line 5306: RAISE fnd_api.g_exc_error;

5302: print_debug('Error status from fetch_next_wpr_rec: '
5303: || l_api_return_status, l_api_name);
5304: END IF;
5305: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5306: RAISE fnd_api.g_exc_error;
5307: ELSE
5308: RAISE fnd_api.g_exc_unexpected_error;
5309: END IF;
5310: END IF;

Line 5308: RAISE fnd_api.g_exc_unexpected_error;

5304: END IF;
5305: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5306: RAISE fnd_api.g_exc_error;
5307: ELSE
5308: RAISE fnd_api.g_exc_unexpected_error;
5309: END IF;
5310: END IF;
5311:
5312: l_api_return_status := fnd_api.g_ret_sts_success;

Line 5312: l_api_return_status := fnd_api.g_ret_sts_success;

5308: RAISE fnd_api.g_exc_unexpected_error;
5309: END IF;
5310: END IF;
5311:
5312: l_api_return_status := fnd_api.g_ret_sts_success;
5313: assign_ttype
5314: ( p_transaction_batch_id => l_wpr_rec.transaction_batch_id
5315: , p_organization_id => l_wpr_rec.organization_id
5316: , x_return_status => l_api_return_status

Line 5319: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5315: , p_organization_id => l_wpr_rec.organization_id
5316: , x_return_status => l_api_return_status
5317: );
5318:
5319: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5320: IF g_debug = 1 THEN
5321: print_debug('Error status from assign_ttype: '
5322: || l_api_return_status, l_api_name);
5323: END IF;

Line 5324: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5320: IF g_debug = 1 THEN
5321: print_debug('Error status from assign_ttype: '
5322: || l_api_return_status, l_api_name);
5323: END IF;
5324: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5325: RAISE fnd_api.g_exc_error;
5326: ELSE
5327: RAISE fnd_api.g_exc_unexpected_error;
5328: END IF;

Line 5325: RAISE fnd_api.g_exc_error;

5321: print_debug('Error status from assign_ttype: '
5322: || l_api_return_status, l_api_name);
5323: END IF;
5324: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5325: RAISE fnd_api.g_exc_error;
5326: ELSE
5327: RAISE fnd_api.g_exc_unexpected_error;
5328: END IF;
5329: END IF;

Line 5327: RAISE fnd_api.g_exc_unexpected_error;

5323: END IF;
5324: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5325: RAISE fnd_api.g_exc_error;
5326: ELSE
5327: RAISE fnd_api.g_exc_unexpected_error;
5328: END IF;
5329: END IF;
5330: END LOOP; --}
5331:

Line 5333: l_api_return_status := fnd_api.g_ret_sts_success;

5329: END IF;
5330: END LOOP; --}
5331:
5332: IF l_tta_done THEN --{
5333: l_api_return_status := fnd_api.g_ret_sts_success;
5334: split_tasks
5335: ( p_batch_id => p_batch_id
5336: , x_return_status => l_api_return_status
5337: );

Line 5338: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5334: split_tasks
5335: ( p_batch_id => p_batch_id
5336: , x_return_status => l_api_return_status
5337: );
5338: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5339: IF g_debug = 1 THEN
5340: print_debug('Error status from split_tasks: '
5341: || l_api_return_status, l_api_name);
5342: END IF;

Line 5343: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5339: IF g_debug = 1 THEN
5340: print_debug('Error status from split_tasks: '
5341: || l_api_return_status, l_api_name);
5342: END IF;
5343: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5344: RAISE fnd_api.g_exc_error;
5345: ELSE
5346: RAISE fnd_api.g_exc_unexpected_error;
5347: END IF;

Line 5344: RAISE fnd_api.g_exc_error;

5340: print_debug('Error status from split_tasks: '
5341: || l_api_return_status, l_api_name);
5342: END IF;
5343: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5344: RAISE fnd_api.g_exc_error;
5345: ELSE
5346: RAISE fnd_api.g_exc_unexpected_error;
5347: END IF;
5348: END IF;

Line 5346: RAISE fnd_api.g_exc_unexpected_error;

5342: END IF;
5343: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5344: RAISE fnd_api.g_exc_error;
5345: ELSE
5346: RAISE fnd_api.g_exc_unexpected_error;
5347: END IF;
5348: END IF;
5349: END IF; --}
5350:

Line 5352: WHEN fnd_api.g_exc_error THEN

5348: END IF;
5349: END IF; --}
5350:
5351: EXCEPTION
5352: WHEN fnd_api.g_exc_error THEN
5353: x_return_status := fnd_api.g_ret_sts_error;
5354: fnd_msg_pub.count_and_get
5355: ( p_count => l_msg_count
5356: , p_data => l_msg_data

Line 5353: x_return_status := fnd_api.g_ret_sts_error;

5349: END IF; --}
5350:
5351: EXCEPTION
5352: WHEN fnd_api.g_exc_error THEN
5353: x_return_status := fnd_api.g_ret_sts_error;
5354: fnd_msg_pub.count_and_get
5355: ( p_count => l_msg_count
5356: , p_data => l_msg_data
5357: , p_encoded => fnd_api.g_false

Line 5357: , p_encoded => fnd_api.g_false

5353: x_return_status := fnd_api.g_ret_sts_error;
5354: fnd_msg_pub.count_and_get
5355: ( p_count => l_msg_count
5356: , p_data => l_msg_data
5357: , p_encoded => fnd_api.g_false
5358: );
5359: IF g_debug = 1 THEN
5360: print_debug (l_msg_data, l_api_name);
5361: END IF;

Line 5364: x_return_status := fnd_api.g_ret_sts_unexp_error;

5360: print_debug (l_msg_data, l_api_name);
5361: END IF;
5362:
5363: WHEN OTHERS THEN
5364: x_return_status := fnd_api.g_ret_sts_unexp_error;
5365: IF g_debug = 1 THEN
5366: print_debug ('Other error: ' || SQLERRM, l_api_name);
5367: END IF;
5368:

Line 5653: x_return_status := fnd_api.g_ret_sts_success;

5649: wms_devices_b dev
5650: WHERE x.dev_id = dev.device_id(+);
5651:
5652: BEGIN
5653: x_return_status := fnd_api.g_ret_sts_success;
5654:
5655: IF g_debug = 1 THEN
5656: print_debug( 'Entered with parameters: ' || g_newline ||
5657: 'p_organization_id => ' || TO_CHAR(p_organization_id) || g_newline ||

Line 5662: l_api_return_status := fnd_api.g_ret_sts_success;

5658: 'p_mo_header_id => ' || TO_CHAR(p_mo_header_id)
5659: , l_api_name);
5660: END IF;
5661:
5662: l_api_return_status := fnd_api.g_ret_sts_success;
5663: wms_device_integration_pvt.is_device_set_up
5664: ( p_org_id => p_organization_id
5665: , p_bus_event_id => 11
5666: , x_return_status => l_api_return_status

Line 5668: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

5664: ( p_org_id => p_organization_id
5665: , p_bus_event_id => 11
5666: , x_return_status => l_api_return_status
5667: );
5668: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
5669: IF g_debug = 1 THEN
5670: print_debug('Error status from is_device_set_up API: '
5671: || l_api_return_status, l_api_name);
5672: END IF;

Line 5673: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

5669: IF g_debug = 1 THEN
5670: print_debug('Error status from is_device_set_up API: '
5671: || l_api_return_status, l_api_name);
5672: END IF;
5673: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5674: RAISE fnd_api.g_exc_error;
5675: ELSE
5676: RAISE fnd_api.g_exc_unexpected_error;
5677: END IF;

Line 5674: RAISE fnd_api.g_exc_error;

5670: print_debug('Error status from is_device_set_up API: '
5671: || l_api_return_status, l_api_name);
5672: END IF;
5673: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5674: RAISE fnd_api.g_exc_error;
5675: ELSE
5676: RAISE fnd_api.g_exc_unexpected_error;
5677: END IF;
5678: END IF;

Line 5676: RAISE fnd_api.g_exc_unexpected_error;

5672: END IF;
5673: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
5674: RAISE fnd_api.g_exc_error;
5675: ELSE
5676: RAISE fnd_api.g_exc_unexpected_error;
5677: END IF;
5678: END IF;
5679:
5680: IF g_debug = 1 THEN

Line 6270: l_api_return_status := fnd_api.g_ret_sts_success;

6266: END IF;
6267:
6268: COMMIT;
6269:
6270: l_api_return_status := fnd_api.g_ret_sts_success;
6271: wms_device_integration_pvt.device_request
6272: ( p_bus_event => wms_device_integration_pvt.wms_be_pick_release
6273: , p_call_ctx => wms_device_integration_pvt.dev_req_auto
6274: , p_task_trx_id => p_mo_header_id -- p_organization_id;bug 9130704

Line 6281: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

6277: , x_return_status => l_api_return_status
6278: , x_msg_count => l_msg_count
6279: , x_msg_data => l_msg_data
6280: );
6281: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
6282: IF g_debug = 1 THEN
6283: print_debug('Error status from device_request API: '
6284: || l_api_return_status, l_api_name);
6285: END IF;

Line 6286: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

6282: IF g_debug = 1 THEN
6283: print_debug('Error status from device_request API: '
6284: || l_api_return_status, l_api_name);
6285: END IF;
6286: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6287: RAISE fnd_api.g_exc_error;
6288: ELSE
6289: RAISE fnd_api.g_exc_unexpected_error;
6290: END IF;

Line 6287: RAISE fnd_api.g_exc_error;

6283: print_debug('Error status from device_request API: '
6284: || l_api_return_status, l_api_name);
6285: END IF;
6286: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6287: RAISE fnd_api.g_exc_error;
6288: ELSE
6289: RAISE fnd_api.g_exc_unexpected_error;
6290: END IF;
6291: END IF;

Line 6289: RAISE fnd_api.g_exc_unexpected_error;

6285: END IF;
6286: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6287: RAISE fnd_api.g_exc_error;
6288: ELSE
6289: RAISE fnd_api.g_exc_unexpected_error;
6290: END IF;
6291: END IF;
6292:
6293: IF g_debug = 1 THEN

Line 6300: WHEN fnd_api.g_exc_error THEN

6296:
6297: COMMIT;
6298:
6299: EXCEPTION
6300: WHEN fnd_api.g_exc_error THEN
6301: x_return_status := fnd_api.g_ret_sts_error;
6302: fnd_msg_pub.count_and_get
6303: ( p_count => l_msg_count
6304: , p_data => l_msg_data

Line 6301: x_return_status := fnd_api.g_ret_sts_error;

6297: COMMIT;
6298:
6299: EXCEPTION
6300: WHEN fnd_api.g_exc_error THEN
6301: x_return_status := fnd_api.g_ret_sts_error;
6302: fnd_msg_pub.count_and_get
6303: ( p_count => l_msg_count
6304: , p_data => l_msg_data
6305: , p_encoded => fnd_api.g_false

Line 6305: , p_encoded => fnd_api.g_false

6301: x_return_status := fnd_api.g_ret_sts_error;
6302: fnd_msg_pub.count_and_get
6303: ( p_count => l_msg_count
6304: , p_data => l_msg_data
6305: , p_encoded => fnd_api.g_false
6306: );
6307: IF g_debug = 1 THEN
6308: print_debug (l_msg_data, l_api_name);
6309: END IF;

Line 6327: x_return_status := fnd_api.g_ret_sts_unexp_error;

6323: CLOSE c_parent_tasks;
6324: END IF;
6325:
6326: WHEN OTHERS THEN
6327: x_return_status := fnd_api.g_ret_sts_unexp_error;
6328: IF g_debug = 1 THEN
6329: print_debug ('Other error: ' || SQLERRM, l_api_name);
6330: END IF;
6331:

Line 6382: x_return_status := fnd_api.g_ret_sts_success;

6378: || ' AND wdd.move_order_line_id = mtrl.line_id'
6379: || ' AND mmtt.parent_line_id IS NULL'; -- non-bulk tasks
6380:
6381: BEGIN
6382: x_return_status := fnd_api.g_ret_sts_success;
6383:
6384: IF g_debug = 1 THEN
6385: print_debug('Entered ' || l_api_name, l_api_name);
6386: END IF;

Line 6597: x_return_status := fnd_api.g_ret_sts_unexp_error;

6593:
6594: EXCEPTION
6595: WHEN OTHERS THEN
6596:
6597: x_return_status := fnd_api.g_ret_sts_unexp_error;
6598:
6599: IF g_debug = 1 THEN
6600: print_debug ('Other error: ' || SQLERRM, l_api_name);
6601: END IF;

Line 6684: x_return_status := fnd_api.g_ret_sts_success;

6680: AND wdd.move_order_line_id = mol.line_id
6681: AND mmtt.parent_line_id IS NULL; -- exclude bulk pick child tasks
6682:
6683: BEGIN
6684: x_return_status := fnd_api.g_ret_sts_success;
6685:
6686: SAVEPOINT pick_slip_sp;
6687:
6688: IF g_debug = 1 THEN

Line 6726: RAISE fnd_api.g_exc_unexpected_error;

6722: IF g_debug = 1 THEN
6723: print_debug( 'Error checking pick slip numbering status: '
6724: || SQLERRM, l_api_name);
6725: END IF;
6726: RAISE fnd_api.g_exc_unexpected_error;
6727: END;
6728:
6729: -- Setting the Grouping rule id. If PickSlip grouping rule Id is not passed,
6730: -- then fetch from mtl_txn_request_headers

Line 6745: RAISE fnd_api.g_exc_unexpected_error;

6741: IF g_debug = 1 THEN
6742: print_debug ('Error querying grouping rule from MO header: '
6743: || SQLERRM, l_api_name);
6744: END IF;
6745: RAISE fnd_api.g_exc_unexpected_error;
6746: END;
6747: END IF;
6748:
6749: -- If Grouping rule id is still null, fetch it from wsh_parameters

Line 6763: RAISE fnd_api.g_exc_unexpected_error;

6759: IF g_debug = 1 THEN
6760: print_debug ('Error querying grouping rule from Shipping parameters: '
6761: || SQLERRM, l_api_name);
6762: END IF;
6763: RAISE fnd_api.g_exc_unexpected_error;
6764: END;
6765: END IF;
6766:
6767: -- Fetch the attributes for the Pick Slip Grouping Rule

Line 6801: l_api_return_status := fnd_api.g_ret_sts_success;

6797: -- Call CreateDynSelSQL API which constructs and returns the two dynamic queries,
6798: -- l_pick_slip_sql gives the grouping criteria and l_mmtt_sql dynamically gives the
6799: -- records in MMTT to be stamped with Pick Slip Number based on each record
6800: -- returned by l_pick_slip_sql
6801: l_api_return_status := fnd_api.g_ret_sts_success;
6802: CreateDynSelSQL(
6803: x_pick_slip_sql => l_pick_slip_sql
6804: , x_mmtt_sql => l_mmtt_sql
6805: , x_num_criteria => l_num_criteria

Line 6808: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

6804: , x_mmtt_sql => l_mmtt_sql
6805: , x_num_criteria => l_num_criteria
6806: , x_return_status => l_api_return_status);
6807:
6808: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
6809: IF g_debug = 1 THEN
6810: print_debug('Error status from CreateDynSelSQL: '
6811: || l_api_return_status, l_api_name);
6812: END IF;

Line 6813: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

6809: IF g_debug = 1 THEN
6810: print_debug('Error status from CreateDynSelSQL: '
6811: || l_api_return_status, l_api_name);
6812: END IF;
6813: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6814: RAISE fnd_api.g_exc_error;
6815: ELSE
6816: RAISE fnd_api.g_exc_unexpected_error;
6817: END IF;

Line 6814: RAISE fnd_api.g_exc_error;

6810: print_debug('Error status from CreateDynSelSQL: '
6811: || l_api_return_status, l_api_name);
6812: END IF;
6813: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6814: RAISE fnd_api.g_exc_error;
6815: ELSE
6816: RAISE fnd_api.g_exc_unexpected_error;
6817: END IF;
6818: END IF;

Line 6816: RAISE fnd_api.g_exc_unexpected_error;

6812: END IF;
6813: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
6814: RAISE fnd_api.g_exc_error;
6815: ELSE
6816: RAISE fnd_api.g_exc_unexpected_error;
6817: END IF;
6818: END IF;
6819:
6820: IF g_debug = 1 THEN

Line 6831: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

6827: IF l_num_criteria < 1 THEN
6828: IF g_debug = 1 THEN
6829: print_debug( 'No Grouping criteria found', l_api_name );
6830: END IF;
6831: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
6832: END IF;
6833:
6834: -- Open grouping criteria cursor. Each row in this cursor represents a pick slip
6835: OPEN l_pick_slip_cur FOR l_pick_slip_sql USING p_mo_header_id;

Line 7194: WHEN fnd_api.g_exc_error THEN

7190:
7191: COMMIT;
7192:
7193: EXCEPTION
7194: WHEN fnd_api.g_exc_error THEN
7195: ROLLBACK TO pick_slip_sp;
7196: x_return_status := fnd_api.g_ret_sts_error;
7197: fnd_msg_pub.count_and_get
7198: ( p_count => l_msg_count

Line 7196: x_return_status := fnd_api.g_ret_sts_error;

7192:
7193: EXCEPTION
7194: WHEN fnd_api.g_exc_error THEN
7195: ROLLBACK TO pick_slip_sp;
7196: x_return_status := fnd_api.g_ret_sts_error;
7197: fnd_msg_pub.count_and_get
7198: ( p_count => l_msg_count
7199: , p_data => l_msg_data
7200: , p_encoded => fnd_api.g_false

Line 7200: , p_encoded => fnd_api.g_false

7196: x_return_status := fnd_api.g_ret_sts_error;
7197: fnd_msg_pub.count_and_get
7198: ( p_count => l_msg_count
7199: , p_data => l_msg_data
7200: , p_encoded => fnd_api.g_false
7201: );
7202: IF g_debug = 1 THEN
7203: print_debug (l_msg_data, l_api_name);
7204: END IF;

Line 7214: x_return_status := fnd_api.g_ret_sts_unexp_error;

7210: END IF;
7211:
7212: WHEN OTHERS THEN
7213: ROLLBACK TO pick_slip_sp;
7214: x_return_status := fnd_api.g_ret_sts_unexp_error;
7215: IF g_debug = 1 THEN
7216: print_debug ('Other error: ' || SQLERRM, l_api_name);
7217: END IF;
7218: IF c_ps_rule%ISOPEN THEN

Line 7254: x_return_status := fnd_api.g_ret_sts_success;

7250: FROM mtl_material_transactions_temp
7251: WHERE transaction_batch_id = p_batch_id;
7252:
7253: BEGIN
7254: x_return_status := fnd_api.g_ret_sts_success;
7255:
7256: IF g_debug = 1 THEN
7257: print_debug( 'Entered with parameters: ' || g_newline ||
7258: 'p_batch_id => ' || p_batch_id

Line 7264: l_api_return_status := fnd_api.g_ret_sts_success;

7260: END IF;
7261:
7262: l_wpr_counter := 0;
7263: LOOP --{
7264: l_api_return_status := fnd_api.g_ret_sts_success;
7265: fetch_next_wpr_rec
7266: ( p_batch_id => p_batch_id
7267: , p_mode => 'CRTN_LBL'
7268: , x_wpr_rec => l_wpr_rec

Line 7277: l_lbl_api_status := fnd_api.g_ret_sts_success;

7273: IF l_wpr_counter > 0 THEN
7274: IF g_debug = 1 THEN
7275: print_debug ('No more CRTN_LBL records in WPR, print remaining', l_api_name);
7276: END IF;
7277: l_lbl_api_status := fnd_api.g_ret_sts_success;
7278: inv_label.print_label
7279: ( x_return_status => l_lbl_api_status
7280: , x_msg_count => l_msg_count
7281: , x_msg_data => l_msg_data

Line 7293: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN

7289: FORALL ii IN t_carton_id.FIRST .. t_carton_id.LAST
7290: DELETE wms_pr_workers
7291: WHERE cartonization_id = t_carton_id(ii);
7292:
7293: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7294: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
7295: FND_MSG_PUB.ADD;
7296: RAISE fnd_api.g_exc_error;
7297: END IF;

Line 7296: RAISE fnd_api.g_exc_error;

7292:
7293: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7294: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
7295: FND_MSG_PUB.ADD;
7296: RAISE fnd_api.g_exc_error;
7297: END IF;
7298: l_wpr_counter := 0;
7299: t_carton_id.DELETE;
7300: EXIT;

Line 7308: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN

7304: END IF;
7305: EXIT;
7306: END IF;
7307: --}
7308: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN
7309: IF g_debug = 1 THEN
7310: print_debug('Error status from fetch_next_wpr_rec: '
7311: || l_api_return_status, l_api_name);
7312: END IF;

Line 7313: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

7309: IF g_debug = 1 THEN
7310: print_debug('Error status from fetch_next_wpr_rec: '
7311: || l_api_return_status, l_api_name);
7312: END IF;
7313: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7314: RAISE fnd_api.g_exc_error;
7315: ELSE
7316: RAISE fnd_api.g_exc_unexpected_error;
7317: END IF;

Line 7314: RAISE fnd_api.g_exc_error;

7310: print_debug('Error status from fetch_next_wpr_rec: '
7311: || l_api_return_status, l_api_name);
7312: END IF;
7313: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7314: RAISE fnd_api.g_exc_error;
7315: ELSE
7316: RAISE fnd_api.g_exc_unexpected_error;
7317: END IF;
7318: END IF;

Line 7316: RAISE fnd_api.g_exc_unexpected_error;

7312: END IF;
7313: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7314: RAISE fnd_api.g_exc_error;
7315: ELSE
7316: RAISE fnd_api.g_exc_unexpected_error;
7317: END IF;
7318: END IF;
7319:
7320: l_wpr_counter := l_wpr_counter + 1;

Line 7328: l_lbl_api_status := fnd_api.g_ret_sts_success;

7324: , l_api_name);
7325: END IF;
7326:
7327: IF l_wpr_counter >= 100 THEN
7328: l_lbl_api_status := fnd_api.g_ret_sts_success;
7329: inv_label.print_label
7330: ( x_return_status => l_lbl_api_status
7331: , x_msg_count => l_msg_count
7332: , x_msg_data => l_msg_data

Line 7344: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN

7340: FORALL jj IN t_carton_id.FIRST .. t_carton_id.LAST
7341: DELETE wms_pr_workers
7342: WHERE cartonization_id = t_carton_id(jj);
7343:
7344: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7345: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
7346: FND_MSG_PUB.ADD;
7347: RAISE fnd_api.g_exc_error;
7348: END IF;

Line 7347: RAISE fnd_api.g_exc_error;

7343:
7344: IF l_lbl_api_status <> fnd_api.g_ret_sts_success THEN
7345: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL');
7346: FND_MSG_PUB.ADD;
7347: RAISE fnd_api.g_exc_error;
7348: END IF;
7349: l_wpr_counter := 0;
7350: t_carton_id.DELETE;
7351: END IF;

Line 7356: l_api_return_status := fnd_api.g_ret_sts_success;

7352: END LOOP; --}
7353:
7354: l_txn_batch_ctr := 0;
7355: LOOP --{
7356: l_api_return_status := fnd_api.g_ret_sts_success;
7357: fetch_next_wpr_rec
7358: ( p_batch_id => p_batch_id
7359: , p_mode => 'CSPK_LBL'
7360: , x_wpr_rec => l_wpr_rec

Line 7369: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN

7365: IF g_debug = 1 THEN
7366: print_debug ( 'No more records in WPR', l_api_name );
7367: END IF;
7368: EXIT;
7369: ELSIF l_api_return_status <> fnd_api.g_ret_sts_success THEN
7370: IF g_debug = 1 THEN
7371: print_debug('Error status from fetch_next_wpr_rec: '
7372: || l_api_return_status, l_api_name);
7373: END IF;

Line 7374: IF l_api_return_status = fnd_api.g_ret_sts_error THEN

7370: IF g_debug = 1 THEN
7371: print_debug('Error status from fetch_next_wpr_rec: '
7372: || l_api_return_status, l_api_name);
7373: END IF;
7374: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7375: RAISE fnd_api.g_exc_error;
7376: ELSE
7377: RAISE fnd_api.g_exc_unexpected_error;
7378: END IF;

Line 7375: RAISE fnd_api.g_exc_error;

7371: print_debug('Error status from fetch_next_wpr_rec: '
7372: || l_api_return_status, l_api_name);
7373: END IF;
7374: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7375: RAISE fnd_api.g_exc_error;
7376: ELSE
7377: RAISE fnd_api.g_exc_unexpected_error;
7378: END IF;
7379: END IF;

Line 7377: RAISE fnd_api.g_exc_unexpected_error;

7373: END IF;
7374: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
7375: RAISE fnd_api.g_exc_error;
7376: ELSE
7377: RAISE fnd_api.g_exc_unexpected_error;
7378: END IF;
7379: END IF;
7380:
7381: l_txn_batch_ctr := l_txn_batch_ctr + 1;

Line 7388: l_api_return_status := fnd_api.g_ret_sts_success;

7384: OPEN c_lblprnt (l_wpr_rec.transaction_batch_id);
7385: FETCH c_lblprnt BULK COLLECT INTO t_cspk_temp_id;
7386: CLOSE c_lblprnt;
7387:
7388: l_api_return_status := fnd_api.g_ret_sts_success;
7389: inv_label.print_label
7390: ( x_return_status => l_api_return_status
7391: , x_msg_count => l_msg_count
7392: , x_msg_data => l_msg_data

Line 7400: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN

7396: , p_business_flow_code => 42
7397: , p_transaction_id => t_cspk_temp_id
7398: );
7399:
7400: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
7401: FND_MESSAGE.SET_NAME('WMS', 'WMS_PR_LABEL_FAIL'); -- TBD
7402: FND_MSG_PUB.ADD;
7403: RAISE fnd_api.g_exc_error;
7404: END IF;

Line 7403: RAISE fnd_api.g_exc_error;

7399:
7400: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
7401: FND_MESSAGE.SET_NAME('WMS', 'WMS_PR_LABEL_FAIL'); -- TBD
7402: FND_MSG_PUB.ADD;
7403: RAISE fnd_api.g_exc_error;
7404: END IF;
7405: t_cspk_temp_id.DELETE;
7406:
7407: END LOOP; --}

Line 7423: WHEN fnd_api.g_exc_error THEN

7419:
7420: COMMIT;
7421:
7422: EXCEPTION
7423: WHEN fnd_api.g_exc_error THEN
7424: x_return_status := fnd_api.g_ret_sts_error;
7425: fnd_msg_pub.count_and_get
7426: ( p_count => l_msg_count
7427: , p_data => l_msg_data

Line 7424: x_return_status := fnd_api.g_ret_sts_error;

7420: COMMIT;
7421:
7422: EXCEPTION
7423: WHEN fnd_api.g_exc_error THEN
7424: x_return_status := fnd_api.g_ret_sts_error;
7425: fnd_msg_pub.count_and_get
7426: ( p_count => l_msg_count
7427: , p_data => l_msg_data
7428: , p_encoded => fnd_api.g_false

Line 7428: , p_encoded => fnd_api.g_false

7424: x_return_status := fnd_api.g_ret_sts_error;
7425: fnd_msg_pub.count_and_get
7426: ( p_count => l_msg_count
7427: , p_data => l_msg_data
7428: , p_encoded => fnd_api.g_false
7429: );
7430: IF g_debug = 1 THEN
7431: print_debug (l_msg_data, l_api_name);
7432: END IF;

Line 7454: x_return_status := fnd_api.g_ret_sts_unexp_error;

7450: COMMIT;
7451: END IF;
7452:
7453: WHEN OTHERS THEN
7454: x_return_status := fnd_api.g_ret_sts_unexp_error;
7455: IF g_debug = 1 THEN
7456: print_debug ('Other error: ' || SQLERRM, l_api_name);
7457: END IF;
7458: IF c_lblprnt%ISOPEN THEN