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

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on FND_API

Line 7: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_OP_RUNTIME_PVT_APIS';
5: G_VERSION_PRINTED BOOLEAN := FALSE;
6:
7: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
8: G_MISS_CHAR CONSTANT VARCHAR2(1):= FND_API.G_MISS_CHAR;
9: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
10:
11: G_ACTION_RECEIPT CONSTANT NUMBER := inv_globals.g_action_receipt ;

Line 8: G_MISS_CHAR CONSTANT VARCHAR2(1):= FND_API.G_MISS_CHAR;

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_OP_RUNTIME_PVT_APIS';
5: G_VERSION_PRINTED BOOLEAN := FALSE;
6:
7: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
8: G_MISS_CHAR CONSTANT VARCHAR2(1):= FND_API.G_MISS_CHAR;
9: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
10:
11: G_ACTION_RECEIPT CONSTANT NUMBER := inv_globals.g_action_receipt ;
12: G_ACTION_INTRANSITRECEIPT CONSTANT NUMBER := inv_globals.G_ACTION_INTRANSITRECEIPT;

Line 9: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

5: G_VERSION_PRINTED BOOLEAN := FALSE;
6:
7: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
8: G_MISS_CHAR CONSTANT VARCHAR2(1):= FND_API.G_MISS_CHAR;
9: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
10:
11: G_ACTION_RECEIPT CONSTANT NUMBER := inv_globals.g_action_receipt ;
12: G_ACTION_INTRANSITRECEIPT CONSTANT NUMBER := inv_globals.G_ACTION_INTRANSITRECEIPT;
13: G_ACTION_SUBXFR CONSTANT NUMBER := inv_globals.g_action_subxfr;

Line 52: x_return_status:=FND_API.G_RET_STS_SUCCESS;

48: l_module_name CONSTANT VARCHAR2(30) := 'Insert_Plan_Instance';
49:
50: BEGIN
51:
52: x_return_status:=FND_API.G_RET_STS_SUCCESS;
53:
54: IF (l_debug=1) THEN
55: print_debug('Plan Instance Id:'||p_insert_rec.op_plan_instance_id,l_module_name,3);
56: END IF;

Line 135: RAISE fnd_api.g_exc_unexpected_error;

131: p_insert_rec.ATTRIBUTE14,
132: p_insert_rec.ATTRIBUTE15);
133:
134: IF SQL%NOTFOUND THEN
135: RAISE fnd_api.g_exc_unexpected_error;
136: END IF;
137:
138: EXCEPTION
139:

Line 142: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

138: EXCEPTION
139:
140: WHEN OTHERS THEN
141:
142: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
143: IF (l_debug=1) THEN
144: print_debug('Unexpected Error,Insertion failed'||SQLERRM,l_module_name,3);
145: END IF;
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 173: x_return_status:=FND_API.G_RET_STS_SUCCESS;

169: l_module_name CONSTANT VARCHAR2(30) := 'Update_Plan_Instance';
170:
171: BEGIN
172:
173: x_return_status:=FND_API.G_RET_STS_SUCCESS;
174:
175: IF (l_debug=1) THEN
176: print_debug('Plan Instance Id:'||p_update_rec.op_plan_instance_id,l_module_name,3);
177: END IF;

Line 183: RAISE fnd_api.g_exc_error;

179: IF p_update_rec.op_plan_instance_id IS NULL THEN /*Plan instance id is a must for Updation*/
180: IF (l_debug=1) THEN
181: print_debug('Plan Instance Id is null',l_module_name,1);
182: END IF;
183: RAISE fnd_api.g_exc_error;
184: END IF;
185:
186: IF (l_debug=1) THEN
187: print_debug('Updating WMS_OP_PLAN_INSTANCES',l_module_name,3);

Line 231: RAISE fnd_api.g_exc_unexpected_error;

227: IF SQL%notfound THEN
228: IF (l_debug=1) THEN
229: print_debug('Updating Plan Instance failed',l_module_name,1);
230: END IF;
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233: --
234: EXCEPTION
235: WHEN fnd_api.g_exc_error THEN

Line 235: WHEN fnd_api.g_exc_error THEN

231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233: --
234: EXCEPTION
235: WHEN fnd_api.g_exc_error THEN
236: x_return_status:=FND_API.G_RET_STS_ERROR;
237: --
238: IF (l_debug=1) THEN
239: print_debug('Expected Error:Updation failed ',l_module_name,1);

Line 236: x_return_status:=FND_API.G_RET_STS_ERROR;

232: END IF;
233: --
234: EXCEPTION
235: WHEN fnd_api.g_exc_error THEN
236: x_return_status:=FND_API.G_RET_STS_ERROR;
237: --
238: IF (l_debug=1) THEN
239: print_debug('Expected Error:Updation failed ',l_module_name,1);
240: END IF;

Line 245: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

241: /*Message or error code to be populated for Operation PLan Instance Id Null*/
242:
243: WHEN OTHERS THEN
244:
245: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF (l_debug=1) THEN
248: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
249: END IF;

Line 278: x_return_status:=fnd_api.g_RET_STS_SUCCESS;

274: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
275: l_module_name CONSTANT VARCHAR2(30):= 'Delete_Plan_Instance';
276:
277: BEGIN
278: x_return_status:=fnd_api.g_RET_STS_SUCCESS;
279: --
280: IF (l_debug=1) THEN
281: print_debug('Plan Instance Id:'||p_op_plan_instance_id,l_module_name,3);
282: END IF;

Line 288: RAISE fnd_api.g_exc_error;

284: IF p_op_plan_instance_id IS NULL THEN
285: IF (l_debug=1) THEN
286: print_debug('Plan Instance Id is null','Delete_Plan_instance',3);
287: END IF;
288: RAISE fnd_api.g_exc_error;
289: END IF;
290:
291: IF (l_debug=1) THEN
292: print_debug('Deleting Plan Instances','Delete_Plan_instance',9);

Line 302: RAISE fnd_api.g_exc_unexpected_error;

298: IF SQL%notfound THEN
299: IF (l_debug=1) THEN
300: print_debug('Record not found while deleting','Delete_Plan_Instance',1);
301: END IF;
302: RAISE fnd_api.g_exc_unexpected_error;
303: END IF;
304:
305: EXCEPTION
306:

Line 307: WHEN fnd_api.g_exc_error THEN

303: END IF;
304:
305: EXCEPTION
306:
307: WHEN fnd_api.g_exc_error THEN
308: x_return_status:=FND_API.G_RET_STS_ERROR;
309: IF (l_debug=1) THEN
310: print_debug('Error while deleting Plan Instance','Delete_Plan_Instance',1);
311: END IF;

Line 308: x_return_status:=FND_API.G_RET_STS_ERROR;

304:
305: EXCEPTION
306:
307: WHEN fnd_api.g_exc_error THEN
308: x_return_status:=FND_API.G_RET_STS_ERROR;
309: IF (l_debug=1) THEN
310: print_debug('Error while deleting Plan Instance','Delete_Plan_Instance',1);
311: END IF;
312: /*Message or error code to be populated for Operation PLan Instance Id Null*/

Line 316: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

312: /*Message or error code to be populated for Operation PLan Instance Id Null*/
313:
314:
315: WHEN OTHERS THEN
316: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
317: IF (l_debug=1) THEN
318: print_debug('Unexpected Error While Deleting'||SQLERRM,'Delete_Plan_Instance',1);
319: END IF;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 345: x_return_status:=fnd_api.g_ret_sts_success;

341: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
342: l_module_name CONSTANT VARCHAR2(30):='Insert_Operation_Instance';
343:
344: BEGIN
345: x_return_status:=fnd_api.g_ret_sts_success;
346: IF (l_debug=1) THEN
347: print_debug('Operation Instance Id:'||p_insert_rec.operation_instance_id,l_module_name,3);
348: END IF;
349:

Line 444: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

440: EXCEPTION
441:
442: WHEN OTHERS THEN
443:
444: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
445: IF (l_debug=1) THEN
446: print_debug('Unexptec Error while inserting'||SQLERRM,l_module_name,1);
447: END IF;
448:

Line 476: x_return_status:=fnd_api.G_RET_STS_SUCCESS;

472: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
473: l_module_name CONSTANT VARCHAR2(30) :='Delete_operation_instance';
474:
475: BEGIN
476: x_return_status:=fnd_api.G_RET_STS_SUCCESS;
477: IF (l_debug=1) THEN
478: print_debug('Operation Instance Id:'||p_operation_instance_id,l_module_name,3);
479: END IF;
480:

Line 487: RAISE fnd_api.G_exc_error;

483: IF (l_debug=1) THEN
484: print_debug('Operation Instance Id is null',l_module_name,1);
485: END IF;
486:
487: RAISE fnd_api.G_exc_error;
488: END IF;
489:
490: IF (l_debug=1) THEN
491: print_debug('Deleting Records from WMS_OP_OPERATION_INSTANCES',l_module_name,9);

Line 501: RAISE fnd_api.g_exc_unexpected_error;

497: IF (SQL%notfound) THEN
498: IF (l_debug=1) THEN
499: print_debug('Deleting of Record failed as no record found',l_module_name,1);
500: END IF;
501: RAISE fnd_api.g_exc_unexpected_error;
502: END IF;
503:
504: EXCEPTION
505:

Line 506: WHEN fnd_api.g_exc_error THEN

502: END IF;
503:
504: EXCEPTION
505:
506: WHEN fnd_api.g_exc_error THEN
507: x_return_status:=FND_API.G_RET_STS_ERROR;
508:
509: IF (l_debug=1) THEN
510: print_debug('Error Deleting Record',l_module_name,1);

Line 507: x_return_status:=FND_API.G_RET_STS_ERROR;

503:
504: EXCEPTION
505:
506: WHEN fnd_api.g_exc_error THEN
507: x_return_status:=FND_API.G_RET_STS_ERROR;
508:
509: IF (l_debug=1) THEN
510: print_debug('Error Deleting Record',l_module_name,1);
511: END IF;

Line 516: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

512: /*Message or error code to be populated for Operation PLan Instance Id Null*/
513:
514:
515: WHEN OTHERS THEN
516: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
517:
518: IF (l_debug=1) THEN
519: print_debug('Unexpected Error'||SQLERRM,l_module_name,1);
520: END IF;

Line 549: x_return_status:=fnd_api.g_ret_sts_success;

545: l_module_name CONSTANT VARCHAR2(30):='Update_operation_instance';
546:
547: BEGIN
548:
549: x_return_status:=fnd_api.g_ret_sts_success;
550:
551: IF (l_debug=1) THEN
552: print_debug('Operation Instance Id'||p_update_rec.operation_instance_id,l_module_name,3);
553: END IF;

Line 560: RAISE FND_API.G_EXC_ERROR;

556: IF (l_debug=1) THEN
557: print_debug('Operation Instance Id is null',l_module_name,1);
558: END IF;
559:
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:
563: IF (l_debug=1) THEN
564: print_debug('Updating Operation instance',l_module_name,9);

Line 617: RAISE fnd_api.g_exc_unexpected_error;

613: IF (l_debug=1) THEN
614: print_debug('Record not Found',l_module_name,1);
615: END IF;
616:
617: RAISE fnd_api.g_exc_unexpected_error;
618:
619: END IF;
620:
621: EXCEPTION

Line 622: WHEN fnd_api.g_exc_error THEN

618:
619: END IF;
620:
621: EXCEPTION
622: WHEN fnd_api.g_exc_error THEN
623:
624: x_return_status:=FND_API.G_RET_STS_ERROR;
625: IF (l_debug=1) THEN
626: print_debug('Error Obtained While Updating Operation instance',l_module_name,1);

Line 624: x_return_status:=FND_API.G_RET_STS_ERROR;

620:
621: EXCEPTION
622: WHEN fnd_api.g_exc_error THEN
623:
624: x_return_status:=FND_API.G_RET_STS_ERROR;
625: IF (l_debug=1) THEN
626: print_debug('Error Obtained While Updating Operation instance',l_module_name,1);
627: END IF;
628: /*Message or error code to be populated for Operation PLan Instance Id Null*/

Line 631: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

627: END IF;
628: /*Message or error code to be populated for Operation PLan Instance Id Null*/
629:
630: WHEN OTHERS THEN
631: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
632:
633: IF (l_debug=1) THEN
634: print_debug('Unexpected Error Obtained While Updating Operation instance'||SQLERRM,l_module_name,1);
635: END IF;

Line 670: x_return_status:=fnd_api.g_ret_sts_success;

666:
667:
668: BEGIN
669:
670: x_return_status:=fnd_api.g_ret_sts_success;
671: l_progress:=10;
672:
673: IF (l_debug=1) THEN
674: print_debug('Input Parameters:','Archive_plan_instance',3);

Line 682: RAISE fnd_api.g_exc_error;

678: IF p_op_plan_instance_id IS NULL THEN
679: IF (l_debug=1) THEN
680: print_debug('Operation Plan Instance Id is null',l_module_name,1);
681: END IF;
682: RAISE fnd_api.g_exc_error;
683: END IF;
684:
685: IF (l_debug=1) THEN
686: print_debug('Archiving Plan Instances',l_module_name,9);

Line 879: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN

875: IF (l_debug=1) THEN
876: print_debug('Return status from Delete_plan_instance'||x_return_status,l_module_name,6);
877: END IF;
878:
879: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
880: RAISE fnd_api.g_exc_error;
881: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;

Line 880: RAISE fnd_api.g_exc_error;

876: print_debug('Return status from Delete_plan_instance'||x_return_status,l_module_name,6);
877: END IF;
878:
879: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
880: RAISE fnd_api.g_exc_error;
881: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;
884:

Line 881: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN

877: END IF;
878:
879: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
880: RAISE fnd_api.g_exc_error;
881: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;
884:
885: EXCEPTION

Line 882: RAISE fnd_api.g_exc_unexpected_error;

878:
879: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
880: RAISE fnd_api.g_exc_error;
881: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;
884:
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN

Line 886: WHEN fnd_api.g_exc_error THEN

882: RAISE fnd_api.g_exc_unexpected_error;
883: END IF;
884:
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN
887: x_return_status:=FND_API.G_RET_STS_ERROR;
888: /*Message to be populated for Operation PLan Instance Id Null*/
889:
890: WHEN OTHERS THEN

Line 887: x_return_status:=FND_API.G_RET_STS_ERROR;

883: END IF;
884:
885: EXCEPTION
886: WHEN fnd_api.g_exc_error THEN
887: x_return_status:=FND_API.G_RET_STS_ERROR;
888: /*Message to be populated for Operation PLan Instance Id Null*/
889:
890: WHEN OTHERS THEN
891: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

Line 891: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

887: x_return_status:=FND_API.G_RET_STS_ERROR;
888: /*Message to be populated for Operation PLan Instance Id Null*/
889:
890: WHEN OTHERS THEN
891: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
892: IF (l_debug=1) THEN
893: print_debug('Unexpected Error:'||SQLERRM||l_progress,l_module_name,1);
894: END IF;
895: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 923: x_return_status:=FND_API.G_RET_STS_SUCCESS;

919: l_progress NUMBER;
920:
921: BEGIN
922:
923: x_return_status:=FND_API.G_RET_STS_SUCCESS;
924: IF (l_debug=1) THEN
925: print_debug('Plan Instance Id'||p_op_plan_instance_id,l_module_name,3);
926: END IF;
927:

Line 934: RAISE FND_API.G_EXC_ERROR;

930: IF (l_debug=1) THEN
931: print_debug('Plan Instance Id is null',l_module_name,1);
932: END IF;
933:
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936:
937: l_progress:=10;
938:

Line 953: RAISE FND_API.G_EXC_ERROR;

949: IF SQL%NOTFOUND THEN
950: IF (l_debug=1) THEN
951: print_debug('Record Not Found While Updating the status','Complete_plan_instance',1);
952: END IF;
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955: l_progress:=20;
956:
957: IF (l_debug=1) THEN

Line 973: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN

969: IF (l_debug=1) THEN
970: print_debug('Return Status from Archive_op_plan_instance'||x_return_status,'Complete_plan_instance',6);
971: END IF;
972:
973: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
974: RAISE fnd_api.g_exc_error;
975:
976: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
977: RAISE fnd_api.g_exc_unexpected_error;

Line 974: RAISE fnd_api.g_exc_error;

970: print_debug('Return Status from Archive_op_plan_instance'||x_return_status,'Complete_plan_instance',6);
971: END IF;
972:
973: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
974: RAISE fnd_api.g_exc_error;
975:
976: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
977: RAISE fnd_api.g_exc_unexpected_error;
978: END IF;

Line 976: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN

972:
973: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
974: RAISE fnd_api.g_exc_error;
975:
976: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
977: RAISE fnd_api.g_exc_unexpected_error;
978: END IF;
979:
980: EXCEPTION

Line 977: RAISE fnd_api.g_exc_unexpected_error;

973: IF x_return_status=fnd_api.G_RET_STS_ERROR THEN
974: RAISE fnd_api.g_exc_error;
975:
976: ELSIF x_return_status=fnd_api.G_RET_STS_UNEXP_ERROR THEN
977: RAISE fnd_api.g_exc_unexpected_error;
978: END IF;
979:
980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN

Line 981: WHEN fnd_api.g_exc_error THEN

977: RAISE fnd_api.g_exc_unexpected_error;
978: END IF;
979:
980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN
982: x_return_status:=FND_API.G_RET_STS_ERROR;
983:
984: IF (l_debug=1) THEN
985: print_debug('Error at '||l_progress,l_module_name,1);

Line 982: x_return_status:=FND_API.G_RET_STS_ERROR;

978: END IF;
979:
980: EXCEPTION
981: WHEN fnd_api.g_exc_error THEN
982: x_return_status:=FND_API.G_RET_STS_ERROR;
983:
984: IF (l_debug=1) THEN
985: print_debug('Error at '||l_progress,l_module_name,1);
986: END IF;

Line 990: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

986: END IF;
987: /*Message to be populated for Operation PLan Instance Id Null*/
988:
989: WHEN OTHERS THEN
990: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
991:
992: IF (l_debug=1) THEN
993: print_debug('Unexpected error '||SQLERRM||' at '||l_progress,l_module_name,1);
994: END IF;

Line 1033: x_return_status:=fnd_api.g_ret_sts_success;

1029: print_debug('p_wdt_rec.task_id'||p_wdt_rec.task_id,l_module_name,3);
1030: print_debug('p_source_task_id'||p_source_task_id,l_module_name,3);
1031: END IF;
1032:
1033: x_return_status:=fnd_api.g_ret_sts_success;
1034:
1035: INSERT INTO WMS_DISPATCHED_TASKS
1036: ( TASK_ID,
1037: TRANSACTION_TEMP_ID,

Line 1141: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1137: COMMIT;
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1142: IF (l_debug=1) THEN
1143: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1144: END IF;
1145: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1173: x_return_status:=fnd_api.g_ret_sts_success;

1169: print_debug('p_wdt_rec.task_id'||p_wdt_rec.task_id,l_module_name,3);
1170: print_debug('p_source_task_id'||p_source_task_id,l_module_name,3);
1171: END IF;
1172:
1173: x_return_status:=fnd_api.g_ret_sts_success;
1174:
1175: INSERT INTO WMS_DISPATCHED_TASKS
1176: ( TASK_ID,
1177: TRANSACTION_TEMP_ID,

Line 1281: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1277: -- COMMIT;
1278:
1279: EXCEPTION
1280: WHEN OTHERS THEN
1281: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1282: IF (l_debug=1) THEN
1283: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1284: END IF;
1285: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1325: x_return_status := fnd_api.g_ret_sts_success;

1321: print_debug('p_source_task_id = '||p_source_task_id,l_module_name,3);
1322: print_debug('p_wms_task_type = '||p_wms_task_type,l_module_name,3);
1323: END IF;
1324:
1325: x_return_status := fnd_api.g_ret_sts_success;
1326:
1327: DELETE wms_dispatched_tasks
1328: WHERE transaction_temp_id = p_source_task_id
1329: AND task_type= p_wms_task_type;

Line 1366: x_return_status:=fnd_api.g_ret_sts_success;

1362: IF (l_debug=1) THEN
1363: print_debug('p_wdt_rec.task_id'||p_wdt_rec.task_id,l_module_name,3);
1364: END IF;
1365:
1366: x_return_status:=fnd_api.g_ret_sts_success;
1367:
1368: IF p_wdt_rec.task_id IS NULL THEN
1369: IF (l_debug=1) THEN
1370: print_debug('Task Id is null',l_module_name,1);

Line 1372: RAISE FND_API.G_EXC_ERROR;

1368: IF p_wdt_rec.task_id IS NULL THEN
1369: IF (l_debug=1) THEN
1370: print_debug('Task Id is null',l_module_name,1);
1371: END IF;
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375: --Updating the WDT Record
1376: IF (l_debug=1) THEN

Line 1431: WHEN FND_API.g_EXC_ERROR THEN

1427: OP_PLAN_INSTANCE_ID =decode(p_wdt_rec.OP_PLAN_INSTANCE_ID,G_MISS_NUM,NULL,NULL,OP_PLAN_INSTANCE_ID,p_wdt_rec.OP_PLAN_INSTANCE_ID)
1428: WHERE task_id=p_wdt_rec.task_id;
1429:
1430: EXCEPTION
1431: WHEN FND_API.g_EXC_ERROR THEN
1432: x_return_status:=FND_API.G_RET_STS_ERROR;
1433: IF (l_debug=1) THEN
1434: print_debug('Error While Updating task',l_module_name,1);
1435: END IF;

Line 1432: x_return_status:=FND_API.G_RET_STS_ERROR;

1428: WHERE task_id=p_wdt_rec.task_id;
1429:
1430: EXCEPTION
1431: WHEN FND_API.g_EXC_ERROR THEN
1432: x_return_status:=FND_API.G_RET_STS_ERROR;
1433: IF (l_debug=1) THEN
1434: print_debug('Error While Updating task',l_module_name,1);
1435: END IF;
1436:

Line 1438: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1434: print_debug('Error While Updating task',l_module_name,1);
1435: END IF;
1436:
1437: WHEN OTHERS THEN
1438: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1439: IF (l_debug=1) THEN
1440: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1441: END IF;
1442: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1495: x_return_status :=FND_API.g_ret_sts_success;

1491: print_debug('p_source_task_id ==> '||p_source_task_id,l_module_name,3);
1492: print_debug('p_activity_id ==> '||p_activity_type_id,l_module_name,3);
1493: END IF;
1494:
1495: x_return_status :=FND_API.g_ret_sts_success;
1496:
1497: l_progress:=10;
1498:
1499: IF (p_task_id IS NULL AND p_source_task_id IS NULL AND p_activity_type_id IS NULL) THEN

Line 1503: RAISE FND_API.G_EXC_ERROR;

1499: IF (p_task_id IS NULL AND p_source_task_id IS NULL AND p_activity_type_id IS NULL) THEN
1500: IF (l_debug=1) THEN
1501: print_debug('Invalid Input',l_module_name,1);
1502: END IF;
1503: RAISE FND_API.G_EXC_ERROR;
1504: END IF;
1505:
1506: l_progress:=20;
1507:

Line 1857: WHEN FND_API.g_EXC_ERROR THEN

1853:
1854:
1855: END IF;
1856: EXCEPTION
1857: WHEN FND_API.g_EXC_ERROR THEN
1858: x_return_status:=FND_API.G_RET_STS_ERROR;
1859: IF (l_debug=1) THEN
1860: print_debug('Error While Updating task',l_module_name,1);
1861: END IF;

Line 1858: x_return_status:=FND_API.G_RET_STS_ERROR;

1854:
1855: END IF;
1856: EXCEPTION
1857: WHEN FND_API.g_EXC_ERROR THEN
1858: x_return_status:=FND_API.G_RET_STS_ERROR;
1859: IF (l_debug=1) THEN
1860: print_debug('Error While Updating task',l_module_name,1);
1861: END IF;
1862:

Line 1864: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1860: print_debug('Error While Updating task',l_module_name,1);
1861: END IF;
1862:
1863: WHEN OTHERS THEN
1864: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1865:
1866: IF (l_debug=1) THEN
1867: print_debug('Unexpected Error:'||SQLERRM,l_module_name,1);
1868: END IF;