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

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: IF (g_debug IS NOT NULL) THEN
90: gme_debug.log_initialize ('RelieveRsrvPndLots');
91: END IF;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94: x_error_msg := ' ';
95:
96: IF p_rsrv_pndlot_id IS NULL THEN
97: RAISE no_rsrv_pndlot_id;

Line 106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

102: gme_reservations_pvt.relieve_reservation(p_reservation_id => p_rsrv_pndlot_id,
103: p_prim_relieve_qty => p_relieve_qty,
104: x_return_status => x_return_status);
105:
106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
107: gme_common_pvt.count_and_get (x_count => l_count
108: ,p_encoded => fnd_api.g_false
109: ,x_data => x_error_msg);
110:

Line 108: ,p_encoded => fnd_api.g_false

104: x_return_status => x_return_status);
105:
106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
107: gme_common_pvt.count_and_get (x_count => l_count
108: ,p_encoded => fnd_api.g_false
109: ,x_data => x_error_msg);
110:
111: END IF;
112: ELSE

Line 118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

114: ,p_quantity => p_relieve_qty
115: ,p_secondary_quantity=> p_sec_qty
116: ,x_return_status => x_return_status);
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: gme_common_pvt.count_and_get (x_count => l_count
120: ,p_encoded => fnd_api.g_false
121: ,x_data => x_error_msg);
122:

Line 120: ,p_encoded => fnd_api.g_false

116: ,x_return_status => x_return_status);
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: gme_common_pvt.count_and_get (x_count => l_count
120: ,p_encoded => fnd_api.g_false
121: ,x_data => x_error_msg);
122:
123: END IF;
124: END IF;

Line 127: x_return_status := fnd_api.g_ret_sts_error;

123: END IF;
124: END IF;
125: EXCEPTION
126: WHEN NO_RSRV_PNDLOT_ID THEN
127: x_return_status := fnd_api.g_ret_sts_error;
128: fnd_message.set_name('GME','INVALID_VALUE');
129: x_error_msg := fnd_message.get;
130: WHEN OTHERS THEN
131: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: IF g_debug <= gme_debug.g_log_unexpected THEN
132: gme_debug.put_line('When others exception in relieve_resvns_pend_lots');
133: END IF;
134: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','relieve_resvns_pend_lots');
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: x_error_msg := fnd_message.get;
137:
138: END relieve_resvns_pend_lots;
139:

Line 163: (p_encoded => FND_API.g_false,

159: l_msg_count NUMBER;
160: BEGIN
161:
162: fnd_msg_pub.Count_And_Get
163: (p_encoded => FND_API.g_false,
164: p_count => l_msg_count,
165: p_data => l_message
166: );
167:

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: gme_common_pvt.g_user_ident := p_user_id;
255: gme_common_pvt.g_login_id := p_login_id;
256: gme_common_pvt.set_timestamp;
257:
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: x_error_msg := ' ';
260:
261: l_mmti_rec_in.transaction_type_id := Get_Txn_Type(p_txn_type_id);
262:

Line 296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

292: x_mmti_rec => l_mmti_rec_out,
293: x_return_status => x_return_status);
294:
295:
296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Bug 5255933 Use GME_COMMON_PVT to get error message
298: --x_error_msg := fnd_message.get;
299: GME_COMMON_PVT.count_and_get (x_count => l_count
300: ,p_encoded => fnd_api.g_false

Line 300: ,p_encoded => fnd_api.g_false

296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Bug 5255933 Use GME_COMMON_PVT to get error message
298: --x_error_msg := fnd_message.get;
299: GME_COMMON_PVT.count_and_get (x_count => l_count
300: ,p_encoded => fnd_api.g_false
301: ,x_data => x_error_msg);
302:
303: x_txn_id := -1;
304: x_txn_type_id := -1;

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

314: IF g_debug <= gme_debug.g_log_unexpected THEN
315: gme_debug.put_line('When others exception in Create MAterial Txn');
316: END IF;
317: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_material_txn');
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
319: x_error_msg := fnd_message.get;
320:
321: END Create_Material_Txn;
322:

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: IF (g_debug IS NOT NULL) THEN
358: gme_debug.log_initialize ('MobileCreLotTxn');
359: END IF;
360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: x_error_msg := ' ';
363:
364: gme_common_pvt.g_user_ident := p_user_id;
365: gme_common_pvt.g_login_id := p_login_id;

Line 386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

382: x_mmli_rec => l_mmli_rec_out,
383: x_return_status => x_return_status
384: );
385:
386: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
387: x_error_msg := fnd_message.get;
388: END IF;
389:
390: EXCEPTION

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: IF g_debug <= gme_debug.g_log_unexpected THEN
393: gme_debug.put_line('When others exception in Create Lot Txn');
394: END IF;
395: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_lot_txn');
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: x_error_msg := fnd_message.get;
398:
399: END Create_Lot_Txn;
400:

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434:
435: IF (g_debug IS NOT NULL) THEN
436: gme_debug.log_initialize ('MobileValLotTxn');
437: END IF;
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: x_error_msg := ' ';
440:
441: l_transaction_type_id := Get_Txn_Type(p_transaction_type_id);
442:

Line 445: ,p_init_msg_list =>FND_API.G_FALSE

441: l_transaction_type_id := Get_Txn_Type(p_transaction_type_id);
442:
443: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
444: p_api_version =>1.0
445: ,p_init_msg_list =>FND_API.G_FALSE
446: ,p_commit =>FND_API.G_FALSE
447: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
448: ,p_transaction_type_id =>l_transaction_type_id
449: ,p_organization_id =>p_organization_id

Line 446: ,p_commit =>FND_API.G_FALSE

442:
443: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
444: p_api_version =>1.0
445: ,p_init_msg_list =>FND_API.G_FALSE
446: ,p_commit =>FND_API.G_FALSE
447: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
448: ,p_transaction_type_id =>l_transaction_type_id
449: ,p_organization_id =>p_organization_id
450: ,p_inventory_item_id =>p_item_id

Line 447: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL

443: IF NOT (INV_LOT_API_PUB.validate_lot_indivisible(
444: p_api_version =>1.0
445: ,p_init_msg_list =>FND_API.G_FALSE
446: ,p_commit =>FND_API.G_FALSE
447: ,p_validation_level =>FND_API.G_VALID_LEVEL_FULL
448: ,p_transaction_type_id =>l_transaction_type_id
449: ,p_organization_id =>p_organization_id
450: ,p_inventory_item_id =>p_item_id
451: ,p_revision =>p_revision

Line 464: ,p_encoded => fnd_api.g_false

460: ,x_msg_data =>l_msg_data))
461:
462: THEN
463: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count
464: ,p_encoded => fnd_api.g_false
465: ,x_data => x_error_msg);
466:
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: END IF;

Line 467: x_return_status := FND_API.G_RET_STS_ERROR;

463: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count
464: ,p_encoded => fnd_api.g_false
465: ,x_data => x_error_msg);
466:
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: END IF;
469:
470: EXCEPTION
471: WHEN OTHERS THEN

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: IF g_debug <= gme_debug.g_log_unexpected THEN
473: gme_debug.put_line('When others exception in Validate Indiv Lot Txn');
474: END IF;
475: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Indiv_Lot_Txn');
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: x_error_msg := fnd_message.get;
478:
479: END Validate_Indiv_Lot_Txn;
480:

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: IF (g_debug IS NOT NULL) THEN
518: gme_debug.log_initialize ('MobileValMtlSts');
519: END IF;
520:
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: x_error_msg := ' ';
523:
524: l_transaction_type_id := Get_Txn_Type(p_transaction_type_id);
525:

Line 598: x_return_status := FND_API.G_RET_STS_ERROR;

594: FND_MESSAGE.SET_TOKEN('ITEM', l_item); --Bug#5658050
595: FND_MESSAGE.SET_TOKEN('LOCN',l_locator);
596: END IF;
597:
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_error_msg := fnd_message.get;
600:
601: END IF;
602:

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

605: IF g_debug <= gme_debug.g_log_unexpected THEN
606: gme_debug.put_line('When others exception in Is_Material_Status_Applicable');
607: END IF;
608: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Is_Material_Status_Applicable');
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: x_error_msg := fnd_message.get;
611:
612: END Is_Material_Status_Applicable;
613:

Line 652: x_return_status := FND_API.G_RET_STS_SUCCESS;

648: gme_debug.log_initialize ('MobileFetchAgrTxns');
649: END IF;
650:
651:
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
653: x_error_msg := ' ';
654:
655: OPEN Get_Agg_Txn;
656: FETCH Get_Agg_Txn INTO x_aggr_txn_qty, x_aggr_txn_sec_qty;

Line 665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

661: IF g_debug <= gme_debug.g_log_unexpected THEN
662: gme_debug.put_line('When others exception in fetch aggrageted txns');
663: END IF;
664: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_txns');
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666: x_error_msg := fnd_message.get;
667:
668: END Fetch_Aggregated_Txns;
669:

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: gme_debug.log_initialize ('MobileFetchAgrLotTxns');
696: END IF;
697:
698:
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: x_error_msg := ' ';
701:
702: OPEN x_txn_cursor FOR
703: SELECT m.revision,lot_number,

Line 722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

718: IF g_debug <= gme_debug.g_log_unexpected THEN
719: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
720: END IF;
721: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_lot_txns');
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: x_error_msg := fnd_message.get;
724:
725: END Fetch_Aggregated_Lot_Txns;
726:

Line 768: x_return_status := FND_API.G_RET_STS_SUCCESS;

764: gme_debug.log_initialize ('MobileFetchAgrRevTxns');
765: END IF;
766:
767:
768: x_return_status := FND_API.G_RET_STS_SUCCESS;
769: x_error_msg := ' ';
770:
771: OPEN Get_Agg_Txn;
772: FETCH Get_Agg_Txn INTO x_aggr_txn_qty, x_aggr_txn_sec_qty;

Line 782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

778: IF g_debug <= gme_debug.g_log_unexpected THEN
779: gme_debug.put_line('When others exception in fetch aggrageted lot txns');
780: END IF;
781: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_aggregated_rev_txns');
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: x_error_msg := fnd_message.get;
784:
785: END Fetch_Aggregated_Rev_Txns;
786:

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: END IF;
816:
817: l_txn_type_id := Get_Txn_Type(p_txn_type_id);
818:
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: x_error_msg := ' ';
821:
822: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
823:

Line 854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

850: IF g_debug <= gme_debug.g_log_unexpected THEN
851: gme_debug.put_line('When others exception in fetch Mtl Transactions');
852: END IF;
853: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_transactions');
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_error_msg := fnd_message.get;
856:
857: END Fetch_Material_Transactions;
858:

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882: IF (g_debug IS NOT NULL) THEN
883: gme_debug.log_initialize ('MobileFetchLotTxn');
884: END IF;
885:
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887: x_error_msg := ' ';
888:
889: OPEN x_txn_cursor FOR
890: SELECT

Line 905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

901: IF g_debug <= gme_debug.g_log_unexpected THEN
902: gme_debug.put_line('When others exception in fetch Mtl Lot Transactions');
903: END IF;
904: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_material_lot_transactions');
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: x_error_msg := fnd_message.get;
907:
908: END Fetch_Lot_Transactions;
909:

Line 946: p_init_msg_list => fnd_api.g_false,

942: gme_common_pvt.set_timestamp;
943:
944: GME_TRANSACTIONS_PVT.Process_Transactions
945: (p_api_version => 2.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_true,
948: p_validation_level => fnd_api.g_valid_level_full,
949: p_table => 1, -- Source table is Interface
950: p_header_id => p_txn_header_id,

Line 947: p_commit => fnd_api.g_true,

943:
944: GME_TRANSACTIONS_PVT.Process_Transactions
945: (p_api_version => 2.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_true,
948: p_validation_level => fnd_api.g_valid_level_full,
949: p_table => 1, -- Source table is Interface
950: p_header_id => p_txn_header_id,
951: x_return_status => x_return_status,

Line 948: p_validation_level => fnd_api.g_valid_level_full,

944: GME_TRANSACTIONS_PVT.Process_Transactions
945: (p_api_version => 2.0,
946: p_init_msg_list => fnd_api.g_false,
947: p_commit => fnd_api.g_true,
948: p_validation_level => fnd_api.g_valid_level_full,
949: p_table => 1, -- Source table is Interface
950: p_header_id => p_txn_header_id,
951: x_return_status => x_return_status,
952: x_msg_count => l_msg_count,

Line 956: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

952: x_msg_count => l_msg_count,
953: x_msg_data => l_msg_data,
954: x_trans_count => l_trans_count);
955:
956: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
957: --x_error_msg := fnd_message.get;
958: x_error_msg := l_msg_data;
959: /* Bug 5438355: Added success message. */
960: ELSE

Line 962: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,

958: x_error_msg := l_msg_data;
959: /* Bug 5438355: Added success message. */
960: ELSE
961: gme_common_pvt.log_message('PM_SAVED_CHANGES');
962: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
963: x_count => l_msg_count,
964: x_data => x_error_msg);
965: END IF;
966:

Line 977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

973: IF g_debug <= gme_debug.g_log_unexpected THEN
974: gme_debug.put_line('When others exception in Process_Transactions');
975: END IF;
976: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','process_transactions');
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: x_error_msg := fnd_message.get;
979:
980: END Process_Interface_Txn;
981:

Line 1013: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1009: l_msg_count NUMBER ;
1010: l_msg_data VARCHAR2(3000) ;
1011: BEGIN
1012:
1013: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1014: l_api_version := 1.0;
1015: l_init_msg_list := fnd_api.g_false;
1016: l_commit := fnd_api.g_false;
1017:

Line 1015: l_init_msg_list := fnd_api.g_false;

1011: BEGIN
1012:
1013: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1014: l_api_version := 1.0;
1015: l_init_msg_list := fnd_api.g_false;
1016: l_commit := fnd_api.g_false;
1017:
1018: INV_LOT_API_PUB.validate_child_lot (
1019: x_return_status => l_return_status

Line 1016: l_commit := fnd_api.g_false;

1012:
1013: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1014: l_api_version := 1.0;
1015: l_init_msg_list := fnd_api.g_false;
1016: l_commit := fnd_api.g_false;
1017:
1018: INV_LOT_API_PUB.validate_child_lot (
1019: x_return_status => l_return_status
1020: , x_msg_count => l_msg_count

Line 1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1027: , p_parent_lot_number => p_parent_lot_number
1028: , p_child_lot_number => p_lot_number
1029: ) ;
1030:
1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;

Line 1035: RAISE fnd_api.g_exc_unexpected_error;

1031: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1032: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
1033: FND_MESSAGE.SET_TOKEN('PGM_NAME','INV_LOT_API_PUB.VALIDATE_CHILD_LOT');
1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037:
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE fnd_api.g_exc_error;

Line 1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1034: fnd_msg_pub.ADD;
1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037:
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE fnd_api.g_exc_error;
1040: END IF;
1041:
1042:

Line 1039: RAISE fnd_api.g_exc_error;

1035: RAISE fnd_api.g_exc_unexpected_error;
1036: END IF;
1037:
1038: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1039: RAISE fnd_api.g_exc_error;
1040: END IF;
1041:
1042:
1043:

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR;

1042:
1043:
1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047:
1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_error_msg);

Line 1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1044: EXCEPTION
1045: WHEN NO_DATA_FOUND THEN
1046: x_return_status := FND_API.G_RET_STS_ERROR;
1047:
1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_error_msg);
1051: if( l_msg_count > 1 ) then
1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1048: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1049: p_count => l_msg_count,
1050: p_data => x_error_msg);
1051: if( l_msg_count > 1 ) then
1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1053: end if;
1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1055: WHEN FND_API.G_EXC_ERROR THEN

1051: if( l_msg_count > 1 ) then
1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1053: end if;
1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,

Line 1056: x_return_status := FND_API.G_RET_STS_ERROR;

1052: x_error_msg:= fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1053: end if;
1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,
1060: p_data => l_msg_data);

Line 1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1054:
1055: WHEN FND_API.G_EXC_ERROR THEN
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057:
1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,
1060: p_data => l_msg_data);
1061: if( l_msg_count > 1 ) then
1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1058: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1059: p_count => l_msg_count,
1060: p_data => l_msg_data);
1061: if( l_msg_count > 1 ) then
1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1063: end if;
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1061: if( l_msg_count > 1 ) then
1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1063: end if;
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,

Line 1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1062: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1063: end if;
1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,
1070: p_data => l_msg_data);

Line 1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1064:
1065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067:
1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,
1070: p_data => l_msg_data);
1071: if( l_msg_count > 1 ) then
1072: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1072: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1068: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1069: p_count => l_msg_count,
1070: p_data => l_msg_data);
1071: if( l_msg_count > 1 ) then
1072: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1073: end if;
1074:
1075:
1076: WHEN OTHERS THEN

Line 1077: x_return_status := fnd_api.g_ret_sts_error;

1073: end if;
1074:
1075:
1076: WHEN OTHERS THEN
1077: x_return_status := fnd_api.g_ret_sts_error;
1078:
1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => l_msg_count,
1081: p_data => l_msg_data);

Line 1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1075:
1076: WHEN OTHERS THEN
1077: x_return_status := fnd_api.g_ret_sts_error;
1078:
1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => l_msg_count,
1081: p_data => l_msg_data);
1082: if( l_msg_count > 1 ) then
1083: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

Line 1083: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);

1079: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1080: p_count => l_msg_count,
1081: p_data => l_msg_data);
1082: if( l_msg_count > 1 ) then
1083: x_error_msg := fnd_msg_pub.get(l_msg_count, FND_API.G_FALSE);
1084: end if;
1085:
1086: END Validate_Child_Lot;
1087:

Line 1119: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1115: IF (g_debug IS NOT NULL) THEN
1116: gme_debug.log_initialize ('MobileGenLotNumber');
1117: END IF;
1118:
1119: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1120: x_error_msg := '';
1121:
1122: x_lot_number := INV_LOT_API_PUB.auto_gen_lot
1123: (p_org_id => p_org_id,

Line 1139: p_init_msg_list => FND_API.G_FALSE,

1135: p_transaction_action_id => NULL,
1136: p_transaction_source_type_id => NULL,
1137: p_lot_number => NULL,
1138: p_api_version => 1.0,
1139: p_init_msg_list => FND_API.G_FALSE,
1140: p_commit => FND_API.G_FALSE,
1141: p_validation_level => NULL,
1142: p_parent_lot_number => p_parent_lot_number,
1143: x_return_status => x_return_status,

Line 1140: p_commit => FND_API.G_FALSE,

1136: p_transaction_source_type_id => NULL,
1137: p_lot_number => NULL,
1138: p_api_version => 1.0,
1139: p_init_msg_list => FND_API.G_FALSE,
1140: p_commit => FND_API.G_FALSE,
1141: p_validation_level => NULL,
1142: p_parent_lot_number => p_parent_lot_number,
1143: x_return_status => x_return_status,
1144: x_msg_count => l_msg_count,

Line 1147: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1143: x_return_status => x_return_status,
1144: x_msg_count => l_msg_count,
1145: x_msg_data => x_error_msg);
1146:
1147: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1148: RAISE fnd_api.g_exc_error;
1149: END IF;
1150:
1151: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 1148: RAISE fnd_api.g_exc_error;

1144: x_msg_count => l_msg_count,
1145: x_msg_data => x_error_msg);
1146:
1147: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1148: RAISE fnd_api.g_exc_error;
1149: END IF;
1150:
1151: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1152: gme_debug.put_line ( 'lot_gen'

Line 1159: WHEN fnd_api.g_exc_error THEN

1155: || x_return_status);
1156: END IF;
1157:
1158: EXCEPTION
1159: WHEN fnd_api.g_exc_error THEN
1160: IF g_debug <= gme_debug.g_log_unexpected THEN
1161: gme_debug.put_line ( 'GME_MOBILE_TXNS'
1162: || '.'
1163: || 'Generate_Lot_Number'

Line 1169: x_return_status := fnd_api.g_ret_sts_error;

1165: || 'When others exception:'
1166: || SQLERRM);
1167: END IF;
1168:
1169: x_return_status := fnd_api.g_ret_sts_error;
1170:
1171: WHEN OTHERS THEN
1172: IF g_debug <= gme_debug.g_log_unexpected THEN
1173: gme_debug.put_line ( 'GME_MOBILE_TXNS'

Line 1182: p_encoded => fnd_api.g_false,

1178: || SQLERRM);
1179: END IF;
1180:
1181: gme_common_pvt.count_and_get (x_count => l_msg_count,
1182: p_encoded => fnd_api.g_false,
1183: x_data => x_error_msg);
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185:
1186: END Generate_Lot_Number;

Line 1184: x_return_status := fnd_api.g_ret_sts_unexp_error;

1180:
1181: gme_common_pvt.count_and_get (x_count => l_msg_count,
1182: p_encoded => fnd_api.g_false,
1183: x_data => x_error_msg);
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185:
1186: END Generate_Lot_Number;
1187:
1188: /*+========================================================================+

Line 1488: x_return_status := FND_API.G_RET_STS_SUCCESS;

1484: IF (g_debug IS NOT NULL) THEN
1485: gme_debug.log_initialize ('MobileValTxnDate');
1486: END IF;
1487:
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: x_error_msg := ' ';
1490:
1491: --- Check that transaction date is not in the future
1492: IF p_txn_date > SYSDATE THEN

Line 1513: x_return_status := FND_API.G_RET_STS_ERROR;

1509: EXCEPTION
1510: WHEN DATE_ERROR THEN
1511: x_period_id := -1;
1512: x_error_msg := fnd_message.get;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514:
1515: WHEN OTHERS THEN
1516: IF g_debug <= gme_debug.g_log_unexpected THEN
1517: gme_debug.put_line('When others exception in Validate Txn Date');

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1516: IF g_debug <= gme_debug.g_log_unexpected THEN
1517: gme_debug.put_line('When others exception in Validate Txn Date');
1518: END IF;
1519: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Txn_Date');
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: x_error_msg := fnd_message.get;
1522:
1523: END Validate_Txn_Date;
1524:

Line 1574: x_return_status := FND_API.G_RET_STS_SUCCESS;

1570: IF (g_debug IS NOT NULL) THEN
1571: gme_debug.log_initialize ('MobileValBatchForIB');
1572: END IF;
1573:
1574: x_return_status := FND_API.G_RET_STS_SUCCESS;
1575: x_error_msg := ' ';
1576:
1577: OPEN Cur_batch_no;
1578: FETCH Cur_batch_no INTO l_parent_line_id;

Line 1609: x_return_status := FND_API.G_RET_STS_ERROR;

1605:
1606:
1607: EXCEPTION
1608: WHEN BATCH_NOT_VALID THEN
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: x_error_msg := fnd_message.get;
1611:
1612: WHEN OTHERS THEN
1613: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1613: IF g_debug <= gme_debug.g_log_unexpected THEN
1614: gme_debug.put_line('When others exception in Validate Batch For IB');
1615: END IF;
1616: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Batch_For_IB');
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: x_error_msg := fnd_message.get;
1619:
1620: END Validate_Batch_For_IB;
1621:

Line 1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

1660: IF (g_debug IS NOT NULL) THEN
1661: gme_debug.log_initialize ('MobileValItemForIB');
1662: END IF;
1663:
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665: x_error_msg := ' ';
1666:
1667: OPEN Cur_batch_det;
1668: FETCH Cur_batch_det INTO l_mat_rec;

Line 1695: x_return_status := FND_API.G_RET_STS_ERROR;

1691:
1692:
1693: EXCEPTION
1694: WHEN ITEM_NOT_VALID THEN
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: x_error_msg := fnd_message.get;
1697:
1698: WHEN OTHERS THEN
1699: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1699: IF g_debug <= gme_debug.g_log_unexpected THEN
1700: gme_debug.put_line('When others exception in Validate Item For IB');
1701: END IF;
1702: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_For_IB');
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: x_error_msg := fnd_message.get;
1705:
1706: END Validate_Item_For_IB;
1707:

Line 1760: x_return_status := FND_API.G_RET_STS_SUCCESS;

1756:
1757: fnd_profile.put('USER_ID',to_char(p_user_id));
1758: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
1759:
1760: x_return_status := FND_API.G_RET_STS_SUCCESS;
1761: x_error_msg := ' ';
1762:
1763: l_material_details.material_detail_id := p_material_detail_id;
1764: l_batch_header.batch_id := p_batch_id;

Line 1769: ,p_init_msg_list => fnd_api.g_false

1765:
1766: GME_API_PUB.Incremental_Backflush
1767: (p_api_version => 2.0
1768: ,p_validation_level => gme_common_pvt.g_max_errors
1769: ,p_init_msg_list => fnd_api.g_false
1770: ,p_commit => fnd_api.g_true
1771: ,x_message_count => l_msg_count
1772: ,x_message_list => l_msg_list
1773: ,x_return_status => x_return_status

Line 1770: ,p_commit => fnd_api.g_true

1766: GME_API_PUB.Incremental_Backflush
1767: (p_api_version => 2.0
1768: ,p_validation_level => gme_common_pvt.g_max_errors
1769: ,p_init_msg_list => fnd_api.g_false
1770: ,p_commit => fnd_api.g_true
1771: ,x_message_count => l_msg_count
1772: ,x_message_list => l_msg_list
1773: ,x_return_status => x_return_status
1774: ,p_batch_header_rec => l_batch_header

Line 1780: ,p_ignore_exception => fnd_api.g_false --- Do not proceed if exceptios

1776: ,p_material_detail_rec => l_material_details
1777: ,p_qty => p_qty
1778: ,p_qty_type => p_qty_type
1779: ,p_trans_date => p_trans_date
1780: ,p_ignore_exception => fnd_api.g_false --- Do not proceed if exceptios
1781: ,p_adjust_cmplt => fnd_api.g_false --- Completed batches not supported
1782: ,x_exception_material_tbl => l_exception_material_tab);
1783:
1784: IF (g_debug IS NOT NULL) THEN

Line 1781: ,p_adjust_cmplt => fnd_api.g_false --- Completed batches not supported

1777: ,p_qty => p_qty
1778: ,p_qty_type => p_qty_type
1779: ,p_trans_date => p_trans_date
1780: ,p_ignore_exception => fnd_api.g_false --- Do not proceed if exceptios
1781: ,p_adjust_cmplt => fnd_api.g_false --- Completed batches not supported
1782: ,x_exception_material_tbl => l_exception_material_tab);
1783:
1784: IF (g_debug IS NOT NULL) THEN
1785: gme_debug.put_line('Return Status = '||x_return_status);

Line 1806: x_return_status := FND_API.G_RET_STS_ERROR;

1802: END IF;
1803:
1804: EXCEPTION
1805: WHEN BACKFLUSH_ERROR THEN
1806: x_return_status := FND_API.G_RET_STS_ERROR;
1807: ROLLBACK;
1808:
1809: WHEN OTHERS THEN
1810: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1810: IF g_debug <= gme_debug.g_log_unexpected THEN
1811: gme_debug.put_line('When others exception in Backflush Material');
1812: END IF;
1813: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Backflush_Material');
1814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1815: x_error_msg := fnd_message.get;
1816: ROLLBACK;
1817:
1818: END Backflush_Material;

Line 1872: , p_init_msg_list => FND_API.G_TRUE

1868:
1869:
1870: GME_API_PUB.Update_Batchstep_Resource
1871: ( p_api_version => 2.0
1872: , p_init_msg_list => FND_API.G_TRUE
1873: , p_commit => FND_API.G_TRUE
1874: , p_batchstep_resource_rec => l_input_rec
1875: , x_batchstep_resource_rec => l_output_rec
1876: , x_message_count => l_msg_count

Line 1873: , p_commit => FND_API.G_TRUE

1869:
1870: GME_API_PUB.Update_Batchstep_Resource
1871: ( p_api_version => 2.0
1872: , p_init_msg_list => FND_API.G_TRUE
1873: , p_commit => FND_API.G_TRUE
1874: , p_batchstep_resource_rec => l_input_rec
1875: , x_batchstep_resource_rec => l_output_rec
1876: , x_message_count => l_msg_count
1877: , x_message_list => l_msg_list

Line 1888: , p_encoded => fnd_api.g_false

1884: LOOP
1885: FND_MSG_PUB.get
1886: ( p_msg_index => i
1887: , p_data => message
1888: , p_encoded => fnd_api.g_false
1889: , p_msg_index_out => dummy
1890: );
1891:
1892: IF i = 1

Line 1951: x_return_status := FND_API.G_RET_STS_SUCCESS;

1947: IF (g_debug IS NOT NULL) THEN
1948: gme_debug.log_initialize ('MobileFetchPendingLot');
1949: END IF;
1950:
1951: x_return_status := FND_API.G_RET_STS_SUCCESS;
1952: x_error_msg := ' ';
1953:
1954: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
1955:

Line 1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line('When others exception in fetch Pending Lots');
1991: END IF;
1992: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_pending_product_lots');
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994: x_error_msg := fnd_message.get;
1995:
1996: END Fetch_Product_Pending_Lots;
1997:

Line 2014: x_return_status := FND_API.G_RET_STS_SUCCESS;

2010: IF (g_debug IS NOT NULL) THEN
2011: gme_debug.log_initialize ('MobileFetchRevPendingLot');
2012: END IF;
2013:
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: x_error_msg := ' ';
2016:
2017: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
2018:

Line 2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2053: IF g_debug <= gme_debug.g_log_unexpected THEN
2054: gme_debug.put_line('When others exception in fetch Rev Pending Lots');
2055: END IF;
2056: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_rev_pending_product_lots');
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: x_error_msg := fnd_message.get;
2059:
2060: END Fetch_Rev_Product_Pending_Lots;
2061:

Line 2112: l_create_lot := fnd_api.g_true;

2108:
2109: BEGIN
2110:
2111: IF p_create_lot = 'TRUE' THEN
2112: l_create_lot := fnd_api.g_true;
2113: ELSE
2114: l_create_lot := fnd_api.g_false;
2115: END IF;
2116:

Line 2114: l_create_lot := fnd_api.g_false;

2110:
2111: IF p_create_lot = 'TRUE' THEN
2112: l_create_lot := fnd_api.g_true;
2113: ELSE
2114: l_create_lot := fnd_api.g_false;
2115: END IF;
2116:
2117: IF (g_debug IS NOT NULL) THEN
2118: gme_debug.log_initialize ('MobileCrePendingLot');

Line 2131: x_return_status := FND_API.G_RET_STS_SUCCESS;

2127: gme_debug.put_line('User Id = ' || p_user_id);
2128: gme_debug.put_line('Login Id = ' || p_login_id);
2129: END IF;
2130:
2131: x_return_status := FND_API.G_RET_STS_SUCCESS;
2132: x_error_msg := ' ';
2133:
2134: fnd_profile.put('USER_ID',to_char(p_user_id));
2135: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

Line 2161: ,p_init_msg_list => fnd_api.g_true

2157:
2158: GME_API_PUB.create_pending_product_lot
2159: (p_api_version => 2.0
2160: ,p_validation_level => gme_common_pvt.g_max_errors
2161: ,p_init_msg_list => fnd_api.g_true
2162: ,p_commit => fnd_api.g_true
2163: ,x_message_count => l_message_count
2164: ,x_message_list => x_error_msg
2165: ,x_return_status => x_return_status

Line 2162: ,p_commit => fnd_api.g_true

2158: GME_API_PUB.create_pending_product_lot
2159: (p_api_version => 2.0
2160: ,p_validation_level => gme_common_pvt.g_max_errors
2161: ,p_init_msg_list => fnd_api.g_true
2162: ,p_commit => fnd_api.g_true
2163: ,x_message_count => l_message_count
2164: ,x_message_list => x_error_msg
2165: ,x_return_status => x_return_status
2166: ,p_batch_header_rec => l_batch_header_rec

Line 2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2180: IF g_debug <= gme_debug.g_log_unexpected THEN
2181: gme_debug.put_line('When others exception in Create Pending Lots');
2182: END IF;
2183: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','create_pending_product_lots');
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: x_error_msg := fnd_message.get;
2186:
2187: END Create_Product_Pending_Lot;
2188:

Line 2243: x_return_status := FND_API.G_RET_STS_SUCCESS;

2239: IF (g_debug IS NOT NULL) THEN
2240: gme_debug.log_initialize ('MobileUpdatePendingLot');
2241: END IF;
2242:
2243: x_return_status := FND_API.G_RET_STS_SUCCESS;
2244: x_error_msg := ' ';
2245:
2246: fnd_profile.put('USER_ID',to_char(p_user_id));
2247: fnd_profile.put('LOGIN_ID',to_char(p_login_id));

Line 2251: l_pending_product_lots_rec.sequence := FND_API.G_MISS_NUM;

2247: fnd_profile.put('LOGIN_ID',to_char(p_login_id));
2248:
2249: IF p_sequence IS NULL THEN
2250: --- Set sequence to the last value
2251: l_pending_product_lots_rec.sequence := FND_API.G_MISS_NUM;
2252: ELSE
2253: IF p_is_seq_changed = 'Y' THEN
2254: l_pending_product_lots_rec.sequence := p_sequence;
2255: ELSE

Line 2278: l_pending_product_lots_rec.reason_id := FND_API.G_MISS_NUM;

2274: l_pending_product_lots_rec.secondary_quantity := NULL;
2275: END IF;
2276:
2277: IF p_reason_id IS NULL THEN
2278: l_pending_product_lots_rec.reason_id := FND_API.G_MISS_NUM;
2279: ELSE
2280: l_pending_product_lots_rec.reason_id := p_reason_id;
2281: END IF;
2282:

Line 2298: ,p_init_msg_list => fnd_api.g_true

2294:
2295: GME_API_PUB.update_pending_product_lot
2296: (p_api_version => 2.0
2297: ,p_validation_level => gme_common_pvt.g_max_errors
2298: ,p_init_msg_list => fnd_api.g_true
2299: ,p_commit => fnd_api.g_true
2300: ,x_message_count => l_message_count
2301: ,x_message_list => l_message_list
2302: ,x_return_status => x_return_status

Line 2299: ,p_commit => fnd_api.g_true

2295: GME_API_PUB.update_pending_product_lot
2296: (p_api_version => 2.0
2297: ,p_validation_level => gme_common_pvt.g_max_errors
2298: ,p_init_msg_list => fnd_api.g_true
2299: ,p_commit => fnd_api.g_true
2300: ,x_message_count => l_message_count
2301: ,x_message_list => l_message_list
2302: ,x_return_status => x_return_status
2303: ,p_batch_header_rec => l_batch_header_rec

Line 2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2326: );
2327: gme_debug.put_line('Error = '||x_error_msg);
2328: END IF;
2329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','update_pending_product_lots');
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331:
2332: END Update_Product_Pending_Lot;
2333:
2334: /*+========================================================================+

Line 2371: x_return_status := FND_API.G_RET_STS_SUCCESS;

2367: IF (g_debug IS NOT NULL) THEN
2368: gme_debug.log_initialize ('MobilePopulateDispTbl');
2369: END IF;
2370:
2371: x_return_status := FND_API.G_RET_STS_SUCCESS;
2372: x_error_msg := ' ';
2373:
2374: -- clear out temp table
2375: DELETE FROM GME_MATERIAL_DISPENSING_GTMP;

Line 2381: p_init_msg_list => FND_API.G_FALSE,

2377: -- Fetch dispensing data for the given material line
2378:
2379: GMO_DISPENSE_GRP.GET_MATERIAL_DISPENSE_DATA (
2380: p_api_version => 1.0,
2381: p_init_msg_list => FND_API.G_FALSE,
2382: x_return_status => l_return_status,
2383: x_msg_count => l_msg_count,
2384: x_msg_data => l_msg_data,
2385: p_material_detail_id => p_material_detail_id,

Line 2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2448: 255));
2449:
2450: END IF;
2451: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Populate_Dispensing_Table');
2452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2453: x_error_msg := fnd_message.get;
2454:
2455: END Populate_Dispensing_Table;
2456:

Line 2483: x_return_status := FND_API.G_RET_STS_SUCCESS;

2479: IF (g_debug IS NOT NULL) THEN
2480: gme_debug.log_initialize ('MobileDelDispRec');
2481: END IF;
2482:
2483: x_return_status := FND_API.G_RET_STS_SUCCESS;
2484: x_error_msg := ' ';
2485:
2486: DELETE FROM GME_MATERIAL_DISPENSING_GTMP
2487: WHERE dispense_id = p_dispense_id;

Line 2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2491: IF g_debug <= gme_debug.g_log_unexpected THEN
2492: gme_debug.put_line('When others exception in Delete_Dispensing_Record');
2493: END IF;
2494: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Delete_Dispensing_Record');
2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2496: x_error_msg := fnd_message.get;
2497:
2498: END Delete_Dispensing_Record;
2499:

Line 2533: x_return_status := FND_API.G_RET_STS_SUCCESS;

2529: IF (g_debug IS NOT NULL) THEN
2530: gme_debug.log_initialize ('MobileCountDispLot');
2531: END IF;
2532:
2533: x_return_status := FND_API.G_RET_STS_SUCCESS;
2534: x_error_msg := ' ';
2535:
2536: OPEN lot_count;
2537: FETCH lot_count INTO x_lot_count;

Line 2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2542: IF g_debug <= gme_debug.g_log_unexpected THEN
2543: gme_debug.put_line('When others exception in Get_Dispensed_Lot_Count');
2544: END IF;
2545: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Get_Dispensed_Lot_Count');
2546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2547: x_error_msg := fnd_message.get;
2548:
2549: END Get_Dispensed_Lot_Count;
2550:

Line 2601: x_return_status := FND_API.G_RET_STS_SUCCESS;

2597: l_cost_group_id number;
2598:
2599: BEGIN
2600:
2601: x_return_status := FND_API.G_RET_STS_SUCCESS;
2602: x_error_msg := ' ';
2603:
2604: IF (g_debug IS NOT NULL) THEN
2605: gme_debug.log_initialize ('MobileQueryQtyTree');

Line 2626: p_init_msg_lst => fnd_api.g_false,

2622: end if;
2623:
2624: Inv_Quantity_Tree_Pub.Query_Quantities (
2625: p_api_version_number => 1.0,
2626: p_init_msg_lst => fnd_api.g_false,
2627: x_return_status => x_return_status,
2628: x_msg_count => l_msg_count,
2629: x_msg_data => x_error_msg,
2630: p_organization_id => p_organization_id,

Line 2705: x_return_status := FND_API.G_RET_STS_SUCCESS;

2701: IF (g_debug IS NOT NULL) THEN
2702: gme_debug.log_initialize ('MobileCreQtyTree');
2703: END IF;
2704:
2705: x_return_status := FND_API.G_RET_STS_SUCCESS;
2706: x_error_msg := ' ';
2707:
2708: IF upper(p_revision_control) = 'TRUE' THEN
2709: l_is_revision_control := TRUE;

Line 2746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2742: , p_onhand_source => 3
2743: , x_tree_id => x_tree_id
2744: );
2745:
2746: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2747: RAISE CREATE_TREE_ERROR;
2748: END IF;
2749:
2750: EXCEPTION

Line 2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2757: IF g_debug <= gme_debug.g_log_unexpected THEN
2758: gme_debug.put_line('When others exception in Create Qty Tree');
2759: END IF;
2760: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Create_Qty_Tree');
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2762: x_error_msg := fnd_message.get;
2763:
2764: END Create_Qty_Tree;
2765:

Line 2809: x_return_status := FND_API.G_RET_STS_SUCCESS;

2805: IF (g_debug IS NOT NULL) THEN
2806: gme_debug.log_initialize ('MobileQtyTree');
2807: END IF;
2808:
2809: x_return_status := FND_API.G_RET_STS_SUCCESS;
2810: x_error_msg := ' ';
2811:
2812: INV_Quantity_Tree_Grp.Query_Tree(
2813: p_api_version_number => 1

Line 2838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2834: , x_satt => x_satt
2835: , x_satr => x_satr
2836: );
2837:
2838: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2839: RAISE QUERY_TREE_ERROR;
2840: END IF;
2841:
2842: EXCEPTION

Line 2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2849: IF g_debug <= gme_debug.g_log_unexpected THEN
2850: gme_debug.put_line('When others exception in Query_Tree');
2851: END IF;
2852: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Query_Tree');
2853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2854: x_error_msg := fnd_message.get;
2855:
2856: END Query_Qty_Tree;
2857:

Line 2906: x_return_status := FND_API.G_RET_STS_SUCCESS;

2902: IF (g_debug IS NOT NULL) THEN
2903: gme_debug.log_initialize ('MobileUpdateQtyTree');
2904: END IF;
2905:
2906: x_return_status := FND_API.G_RET_STS_SUCCESS;
2907: x_error_msg := ' ';
2908:
2909: IF p_locator_id <= 0 THEN
2910: l_locator_id := null;

Line 2955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2951: p_containerized => 0,
2952: p_lpn_id => NULL);
2953:
2954: gme_debug.put_line('New ATT = '||l_att);
2955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2956: RAISE UPDATE_TREE_ERROR;
2957: END IF;
2958:
2959: END IF;

Line 2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2969: IF g_debug <= gme_debug.g_log_unexpected THEN
2970: gme_debug.put_line('When others exception in Update Qty Tree');
2971: END IF;
2972: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Update_Qty_Tree');
2973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2974: x_error_msg := fnd_message.get;
2975:
2976: END Update_Qty_Tree;
2977:

Line 3075: x_return_status := FND_API.G_RET_STS_SUCCESS;

3071: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3072: gme_debug.put_line('Item Id = ' || p_item_id);
3073: END IF;
3074:
3075: x_return_status := FND_API.G_RET_STS_SUCCESS;
3076: x_error_msg := ' ';
3077:
3078: OPEN Get_Mtl_dtl;
3079: FETCH Get_Mtl_Dtl INTO l_release_type, l_phantom_type, l_phantom_line_id;

Line 3122: x_return_status := FND_API.G_RET_STS_ERROR;

3118: END IF; */
3119:
3120: EXCEPTION
3121: WHEN ITEM_NOT_VALID THEN
3122: x_return_status := FND_API.G_RET_STS_ERROR;
3123: x_error_msg := fnd_message.get;
3124:
3125: WHEN OTHERS THEN
3126: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3126: IF g_debug <= gme_debug.g_log_unexpected THEN
3127: gme_debug.put_line('When others exception in Validate Item To Issue');
3128: END IF;
3129: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Issue');
3130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3131: x_error_msg := fnd_message.get;
3132:
3133: END Validate_Item_To_Issue;
3134:

Line 3173: x_return_status := FND_API.G_RET_STS_SUCCESS;

3169: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3170: gme_debug.put_line('Item Id = ' || p_item_id);
3171: END IF;
3172:
3173: x_return_status := FND_API.G_RET_STS_SUCCESS;
3174: x_error_msg := ' ';
3175:
3176: OPEN Get_Mtl_dtl;
3177: FETCH Get_Mtl_Dtl INTO l_dispense_ind;

Line 3189: x_return_status := FND_API.G_RET_STS_ERROR;

3185: END IF;
3186:
3187: EXCEPTION
3188: WHEN ITEM_NOT_VALID THEN
3189: x_return_status := FND_API.G_RET_STS_ERROR;
3190: x_error_msg := fnd_message.get;
3191:
3192: WHEN OTHERS THEN
3193: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3193: IF g_debug <= gme_debug.g_log_unexpected THEN
3194: gme_debug.put_line('When others exception in Validate Item To Return');
3195: END IF;
3196: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Item_To_Return');
3197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3198: x_error_msg := fnd_message.get;
3199:
3200: END Validate_Item_To_Return;
3201:

Line 3250: x_return_status := FND_API.G_RET_STS_SUCCESS;

3246: gme_debug.put_line('Line Id = ' || p_material_detail_id);
3247: gme_debug.put_line('Item Id = ' || p_item_id);
3248: END IF;
3249:
3250: x_return_status := FND_API.G_RET_STS_SUCCESS;
3251: x_error_msg := ' ';
3252:
3253: OPEN Get_Batch_Status;
3254: FETCH Get_Batch_Status INTO l_batch_status;

Line 3292: x_return_status := FND_API.G_RET_STS_ERROR;

3288:
3289:
3290: EXCEPTION
3291: WHEN ITEM_NOT_VALID THEN
3292: x_return_status := FND_API.G_RET_STS_ERROR;
3293: x_error_msg := fnd_message.get;
3294:
3295: WHEN OTHERS THEN
3296: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3296: IF g_debug <= gme_debug.g_log_unexpected THEN
3297: gme_debug.put_line('When others exception in Validate Prod To Yield');
3298: END IF;
3299: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Validate_Prod_To_Yield');
3300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3301: x_error_msg := fnd_message.get;
3302:
3303: END Validate_Prod_To_Yield;
3304:

Line 3335: x_return_status := FND_API.G_RET_STS_SUCCESS;

3331: IF (g_debug IS NOT NULL) THEN
3332: gme_debug.log_initialize ('MobileFetchIssueTxn');
3333: END IF;
3334:
3335: x_return_status := FND_API.G_RET_STS_SUCCESS;
3336: x_error_msg := ' ';
3337:
3338: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3339:

Line 3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3371: IF g_debug <= gme_debug.g_log_unexpected THEN
3372: gme_debug.put_line('When others exception in fetch Issue Transactions');
3373: END IF;
3374: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_issue_transactions');
3375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3376: x_error_msg := fnd_message.get;
3377:
3378: END Fetch_Issue_Transactions;
3379:

Line 3412: x_return_status := FND_API.G_RET_STS_SUCCESS;

3408: IF (g_debug IS NOT NULL) THEN
3409: gme_debug.log_initialize ('MobileFetchYieldTxn');
3410: END IF;
3411:
3412: x_return_status := FND_API.G_RET_STS_SUCCESS;
3413: x_error_msg := ' ';
3414:
3415: FND_PROFILE.GET('MWA_DATE_FORMAT_MASK',l_date_format);
3416:

Line 3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3450: IF g_debug <= gme_debug.g_log_unexpected THEN
3451: gme_debug.put_line('When others exception in fetch yield Transactions');
3452: END IF;
3453: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_yield_transactions');
3454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3455: x_error_msg := fnd_message.get;
3456:
3457: END Fetch_Yield_Transactions;
3458:

Line 3505: x_return_status := fnd_api.g_ret_sts_success;

3501: gme_debug.log_initialize ('MobileCreatePhantomTxn');
3502: END IF;
3503:
3504: --Initially let us assign the return status to success
3505: x_return_status := fnd_api.g_ret_sts_success;
3506:
3507: IF (g_debug <= gme_debug.g_log_statement) THEN
3508: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3509: || 'Entering');

Line 3517: RAISE fnd_api.g_exc_error;

3513: FETCH cur_get_transaction INTO l_mmti_rec;
3514: IF cur_get_transaction%NOTFOUND THEN
3515: CLOSE cur_get_transaction;
3516: gme_common_pvt.log_message('GME_NO_TRANS_FOUND');
3517: RAISE fnd_api.g_exc_error;
3518: END IF;
3519: CLOSE cur_get_transaction;
3520:
3521: OPEN cur_get_lot_transaction(p_mmti_trans_id);

Line 3547: GME_COMMON_PVT.G_MOVE_TO_TEMP := FND_API.G_FALSE;

3543: (-1) * l_mmti_rec.secondary_transaction_quantity;
3544:
3545: END IF;
3546:
3547: GME_COMMON_PVT.G_MOVE_TO_TEMP := FND_API.G_FALSE;
3548:
3549: GME_TRANSACTIONS_PVT.Create_Material_Txn
3550:
3551: (p_mmti_rec => l_mmti_rec

Line 3556: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3552: ,p_mmli_tbl => l_mmli_tbl
3553: ,p_phantom_trans => 2
3554: ,x_return_status => x_return_status);
3555:
3556: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3557: RAISE fnd_api.g_exc_error;
3558: END IF;
3559:
3560: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 3557: RAISE fnd_api.g_exc_error;

3553: ,p_phantom_trans => 2
3554: ,x_return_status => x_return_status);
3555:
3556: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3557: RAISE fnd_api.g_exc_error;
3558: END IF;
3559:
3560: IF (g_debug <= gme_debug.g_log_statement) THEN
3561: gme_debug.put_line ( g_pkg_name

Line 3570: WHEN fnd_api.g_exc_error THEN

3566: || x_return_status);
3567: END IF;
3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_error THEN
3571: x_return_status := fnd_api.g_ret_sts_error;
3572: x_error_msg := fnd_message.get;
3573:
3574: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3571: x_return_status := fnd_api.g_ret_sts_error;

3567: END IF;
3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_error THEN
3571: x_return_status := fnd_api.g_ret_sts_error;
3572: x_error_msg := fnd_message.get;
3573:
3574: WHEN fnd_api.g_exc_unexpected_error THEN
3575: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3574: WHEN fnd_api.g_exc_unexpected_error THEN

3570: WHEN fnd_api.g_exc_error THEN
3571: x_return_status := fnd_api.g_ret_sts_error;
3572: x_error_msg := fnd_message.get;
3573:
3574: WHEN fnd_api.g_exc_unexpected_error THEN
3575: x_return_status := fnd_api.g_ret_sts_unexp_error;
3576:
3577: WHEN OTHERS THEN
3578: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3575: x_return_status := fnd_api.g_ret_sts_unexp_error;

3571: x_return_status := fnd_api.g_ret_sts_error;
3572: x_error_msg := fnd_message.get;
3573:
3574: WHEN fnd_api.g_exc_unexpected_error THEN
3575: x_return_status := fnd_api.g_ret_sts_unexp_error;
3576:
3577: WHEN OTHERS THEN
3578: x_return_status := fnd_api.g_ret_sts_unexp_error;
3579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 3578: x_return_status := fnd_api.g_ret_sts_unexp_error;

3574: WHEN fnd_api.g_exc_unexpected_error THEN
3575: x_return_status := fnd_api.g_ret_sts_unexp_error;
3576:
3577: WHEN OTHERS THEN
3578: x_return_status := fnd_api.g_ret_sts_unexp_error;
3579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3580: x_error_msg := fnd_message.get;
3581: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3582: gme_debug.put_line ( g_pkg_name

Line 3624: x_return_status := FND_API.G_RET_STS_SUCCESS;

3620: validate_step_status_error EXCEPTION;
3621: BEGIN
3622: SAVEPOINT complete_step_mobile ;
3623:
3624: x_return_status := FND_API.G_RET_STS_SUCCESS;
3625:
3626: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3627: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3628:

Line 3662: ,p_override_quality => FND_API.G_FALSE

3658: -- Added call to validate step for complete.
3659: gme_complete_batch_step_pvt.validate_step_for_complete
3660: (p_batch_header_rec => l_batch_header
3661: ,p_batch_step_rec => l_batch_step
3662: ,p_override_quality => FND_API.G_FALSE
3663: ,x_batch_step_rec => l_batch_step_out
3664: ,x_return_status => x_return_status);
3665:
3666: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 3666: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3662: ,p_override_quality => FND_API.G_FALSE
3663: ,x_batch_step_rec => l_batch_step_out
3664: ,x_return_status => x_return_status);
3665:
3666: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3667: RAISE validate_step_error;
3668: END IF;
3669:
3670: gme_api_main.complete_step (

Line 3672: p_init_msg_list => FND_API.G_TRUE,

3668: END IF;
3669:
3670: gme_api_main.complete_step (
3671: p_validation_level => gme_common_pvt.g_max_errors,
3672: p_init_msg_list => FND_API.G_TRUE,
3673: x_message_count => x_message_count,
3674: x_message_list => x_message_list,
3675: x_return_status => x_return_status,
3676: p_batch_step_rec => l_batch_step,

Line 3680: p_ignore_exception => FND_API.G_FALSE);

3676: p_batch_step_rec => l_batch_step,
3677: p_batch_header_rec => l_batch_header,
3678: x_batch_step_rec => x_batch_step,
3679: x_exception_material_tbl => x_exception_material,
3680: p_ignore_exception => FND_API.G_FALSE);
3681: IF x_return_status = 'X' THEN
3682: RAISE step_alloc_error;
3683: END IF;
3684: IF x_return_status = 'S' THEN

Line 3700: x_return_status := FND_API.G_RET_STS_ERROR;

3696: END IF;
3697: END IF;
3698: EXCEPTION
3699: WHEN expected_error THEN
3700: x_return_status := FND_API.G_RET_STS_ERROR;
3701: WHEN step_alloc_error THEN
3702: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3703: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3704: x_message_list := FND_MESSAGE.GET;

Line 3707: ,p_encoded => fnd_api.g_false

3703: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3704: x_message_list := FND_MESSAGE.GET;
3705: WHEN validate_step_error THEN
3706: gme_common_pvt.count_and_get (x_count => x_message_count
3707: ,p_encoded => fnd_api.g_false
3708: ,x_data => x_message_list);
3709: WHEN validate_step_status_error THEN
3710: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3711: x_message_list := FND_MESSAGE.GET;

Line 3713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3709: WHEN validate_step_status_error THEN
3710: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');
3711: x_message_list := FND_MESSAGE.GET;
3712: WHEN OTHERS THEN
3713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3714: END complete_step;
3715:
3716: /*###############################################################
3717: # DESCRIPTION

Line 3738: x_return_status := FND_API.G_RET_STS_SUCCESS;

3734: l_in_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3735: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3736: l_api_name VARCHAR2(30) := 'End_Cmplt_Actual_Rsrc_Txn';
3737: BEGIN
3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;

Line 3755: ,p_init_msg_list => FND_API.G_TRUE

3751: l_in_rsrc_txn_rec.reason_id := p_reason_id;
3752:
3753: GME_API_PUB.end_cmplt_actual_rsrc_txn (
3754: p_api_version => 2.0
3755: ,p_init_msg_list => FND_API.G_TRUE
3756: ,p_commit => FND_API.G_TRUE
3757: ,p_instance_no => NULL
3758: ,p_reason_name => NULL
3759: ,p_rsrc_txn_rec => l_in_rsrc_txn_rec

Line 3756: ,p_commit => FND_API.G_TRUE

3752:
3753: GME_API_PUB.end_cmplt_actual_rsrc_txn (
3754: p_api_version => 2.0
3755: ,p_init_msg_list => FND_API.G_TRUE
3756: ,p_commit => FND_API.G_TRUE
3757: ,p_instance_no => NULL
3758: ,p_reason_name => NULL
3759: ,p_rsrc_txn_rec => l_in_rsrc_txn_rec
3760: ,x_rsrc_txn_rec => l_rsrc_txn_rec

Line 3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3763: ,x_return_status => x_return_status);
3764: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
3765: EXCEPTION
3766: WHEN OTHERS THEN
3767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3768: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3769: END End_Cmplt_Actual_Rsrc_Txn;
3770:
3771: /*###############################################################

Line 3827: x_return_status := FND_API.G_RET_STS_SUCCESS;

3823: validate_step_error EXCEPTION;
3824: validate_step_status_error EXCEPTION;
3825: BEGIN
3826: SAVEPOINT release_step_mobile;
3827: x_return_status := FND_API.G_RET_STS_SUCCESS;
3828:
3829: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));

Line 3866: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3862: ,p_batch_step_rec => l_batch_step
3863: ,x_batch_step_rec => l_batch_step_out
3864: ,x_return_status => x_return_status);
3865:
3866: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3867: RAISE validate_step_error;
3868: END IF;
3869:
3870: gme_api_main.release_step (

Line 3872: p_init_msg_list => FND_API.G_TRUE,

3868: END IF;
3869:
3870: gme_api_main.release_step (
3871: p_validation_level => gme_common_pvt.g_max_errors,
3872: p_init_msg_list => FND_API.G_TRUE,
3873: x_message_count => x_message_count,
3874: x_message_list => x_message_list,
3875: x_return_status => x_return_status,
3876: p_batch_step_rec => l_batch_step,

Line 3880: p_ignore_exception => FND_API.G_FALSE);

3876: p_batch_step_rec => l_batch_step,
3877: p_batch_header_rec => l_batch_hdr_rec,
3878: x_batch_step_rec => x_batch_step,
3879: x_exception_material_tbl => x_exception_material,
3880: p_ignore_exception => FND_API.G_FALSE);
3881: IF x_return_status = 'X' THEN
3882: RAISE step_alloc_error;
3883: END IF;
3884: EXCEPTION

Line 3886: x_return_status := FND_API.G_RET_STS_ERROR;

3882: RAISE step_alloc_error;
3883: END IF;
3884: EXCEPTION
3885: WHEN expected_error THEN
3886: x_return_status := FND_API.G_RET_STS_ERROR;
3887: WHEN step_alloc_error THEN
3888: ROLLBACK TO SAVEPOINT release_step_mobile ;
3889: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3890: x_message_list := FND_MESSAGE.GET;

Line 3893: ,p_encoded => fnd_api.g_false

3889: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3890: x_message_list := FND_MESSAGE.GET;
3891: WHEN validate_step_error THEN
3892: GME_COMMON_PVT.count_and_get (x_count => l_count
3893: ,p_encoded => fnd_api.g_false
3894: ,x_data => x_message_list);
3895:
3896: WHEN validate_step_status_error THEN
3897: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');

Line 3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3896: WHEN validate_step_status_error THEN
3897: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_REL_STEP');
3898: x_message_list := FND_MESSAGE.GET;
3899: WHEN OTHERS THEN
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3901: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3902: END release_step;
3903:
3904: /*###############################################################

Line 3925: x_return_status := FND_API.G_RET_STS_SUCCESS;

3921: l_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3922: l_in_rsrc_txn_rec gme_resource_txns%ROWTYPE;
3923: l_api_name VARCHAR2(30) := 'Start_Cmplt_Actual_Rsrc_Txn';
3924: BEGIN
3925: x_return_status := FND_API.G_RET_STS_SUCCESS;
3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;

Line 3942: ,p_init_msg_list => FND_API.G_TRUE

3938: l_in_rsrc_txn_rec.reason_id := p_reason_id;
3939:
3940: GME_API_PUB.start_cmplt_actual_rsrc_txn (
3941: p_api_version => 2.0
3942: ,p_init_msg_list => FND_API.G_TRUE
3943: ,p_commit => FND_API.G_TRUE
3944: ,p_org_code => NULL
3945: ,p_instance_no => NULL
3946: ,p_rsrc_txn_rec => l_in_rsrc_txn_rec

Line 3943: ,p_commit => FND_API.G_TRUE

3939:
3940: GME_API_PUB.start_cmplt_actual_rsrc_txn (
3941: p_api_version => 2.0
3942: ,p_init_msg_list => FND_API.G_TRUE
3943: ,p_commit => FND_API.G_TRUE
3944: ,p_org_code => NULL
3945: ,p_instance_no => NULL
3946: ,p_rsrc_txn_rec => l_in_rsrc_txn_rec
3947: ,x_rsrc_txn_rec => l_rsrc_txn_rec

Line 3954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3950: ,x_return_status => x_return_status);
3951: x_trans_id := l_rsrc_txn_rec.poc_trans_id;
3952: EXCEPTION
3953: WHEN OTHERS THEN
3954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3955: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3956: END Start_Cmplt_Actual_Rsrc_Txn;
3957:
3958: /*###############################################################

Line 3979: x_return_status := FND_API.G_RET_STS_SUCCESS;

3975: FUTURE_DATE_EX EXCEPTION;
3976: INVALID_STEP_COMPLT_DATE EXCEPTION;
3977: l_api_name VARCHAR2(30) := 'Validate_Step_Completion_Date';
3978: BEGIN
3979: x_return_status := FND_API.G_RET_STS_SUCCESS;
3980: l_sysdate := SYSDATE;
3981: l_complt_date := TO_DATE(p_complt_date, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3982: IF l_complt_date > SYSDATE THEN
3983: RAISE FUTURE_DATE_EX;

Line 3990: x_return_status := FND_API.G_RET_STS_ERROR;

3986: RAISE INVALID_STEP_COMPLT_DATE;
3987: END IF;
3988: EXCEPTION
3989: WHEN FUTURE_DATE_EX THEN
3990: x_return_status := FND_API.G_RET_STS_ERROR;
3991: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3994: x_return_status := FND_API.G_RET_STS_ERROR;

3990: x_return_status := FND_API.G_RET_STS_ERROR;
3991: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
3992: x_error_msg := FND_MESSAGE.GET;
3993: WHEN INVALID_STEP_COMPLT_DATE THEN
3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3994: x_return_status := FND_API.G_RET_STS_ERROR;
3995: FND_MESSAGE.SET_NAME('GME', 'GME_CMPLT_DATE_OUTSIDE');
3996: x_error_msg := FND_MESSAGE.GET;
3997: WHEN OTHERS THEN
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3999: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4000: x_error_msg := FND_MESSAGE.GET;
4001: END Validate_Step_Completion_Date;
4002:

Line 4014: x_return_status := FND_API.G_RET_STS_SUCCESS;

4010: x_error_msg OUT NOCOPY VARCHAR2) IS
4011: l_step_qty NUMBER;
4012: l_api_name VARCHAR2(30) := 'Validate_Step_Qty';
4013: BEGIN
4014: x_return_status := FND_API.G_RET_STS_SUCCESS;
4015: l_step_qty := TO_NUMBER(p_step_qty);
4016: EXCEPTION
4017: WHEN VALUE_ERROR THEN
4018: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4018: x_return_status := FND_API.G_RET_STS_ERROR;

4014: x_return_status := FND_API.G_RET_STS_SUCCESS;
4015: l_step_qty := TO_NUMBER(p_step_qty);
4016: EXCEPTION
4017: WHEN VALUE_ERROR THEN
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: FND_MESSAGE.SET_NAME('GME', 'GME_VALUE_ERROR');
4020: x_error_msg := FND_MESSAGE.GET;
4021: WHEN OTHERS THEN
4022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4023: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4024: x_error_msg := FND_MESSAGE.GET;
4025: END Validate_Step_Qty;
4026:

Line 4055: x_return_status := FND_API.G_RET_STS_SUCCESS;

4051: WHERE batch_id = p_batch_id;
4052: FUTURE_DATE_EX EXCEPTION;
4053: INVALID_STEP_START_DATE EXCEPTION;
4054: BEGIN
4055: x_return_status := FND_API.G_RET_STS_SUCCESS;
4056: l_sysdate := SYSDATE;
4057: l_start_date := TO_DATE(p_start_date, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
4058: IF l_start_date > SYSDATE THEN
4059: RAISE FUTURE_DATE_EX;

Line 4074: x_return_status := FND_API.G_RET_STS_ERROR;

4070: END IF;
4071: END IF;
4072: EXCEPTION
4073: WHEN FUTURE_DATE_EX THEN
4074: x_return_status := FND_API.G_RET_STS_ERROR;
4075: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4078: x_return_status := FND_API.G_RET_STS_ERROR;

4074: x_return_status := FND_API.G_RET_STS_ERROR;
4075: FND_MESSAGE.SET_NAME('GMA', 'SY_NOFUTUREDATE');
4076: x_error_msg := FND_MESSAGE.GET;
4077: WHEN INVALID_STEP_START_DATE THEN
4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4078: x_return_status := FND_API.G_RET_STS_ERROR;
4079: FND_MESSAGE.SET_NAME('GME', 'GME_STEP_START_BATCH_START_ERR');
4080: x_error_msg := FND_MESSAGE.GET;
4081: WHEN OTHERS THEN
4082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4083: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4084: x_error_msg := FND_MESSAGE.GET;
4085: END Validate_Step_Start_Date;
4086:

Line 4093: x_return_status := FND_API.G_RET_STS_SUCCESS;

4089: x_return_status OUT NOCOPY VARCHAR2,
4090: x_message OUT NOCOPY VARCHAR2) IS
4091: l_count NUMBER;
4092: BEGIN
4093: x_return_status := FND_API.G_RET_STS_SUCCESS;
4094: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4096: x_count => l_count,
4097: x_data => x_message);

Line 4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,

4091: l_count NUMBER;
4092: BEGIN
4093: x_return_status := FND_API.G_RET_STS_SUCCESS;
4094: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4096: x_count => l_count,
4097: x_data => x_message);
4098: END IF;
4099: END check_close_period;

Line 4121: x_return_status := FND_API.G_RET_STS_ERROR;

4117: ,x_rsc_row_count => x_row_count
4118: ,x_return_status => x_return_status);
4119: EXCEPTION
4120: WHEN expected_error THEN
4121: x_return_status := FND_API.G_RET_STS_ERROR;
4122: WHEN OTHERS THEN
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: END Load_resource_Txns;
4125:

Line 4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4119: EXCEPTION
4120: WHEN expected_error THEN
4121: x_return_status := FND_API.G_RET_STS_ERROR;
4122: WHEN OTHERS THEN
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: END Load_resource_Txns;
4125:
4126: /* Bug#5663458 Begin
4127: * Created the following procedure. This procedure is to get transaction date of

Line 4143: x_return_status := fnd_api.g_ret_sts_success;

4139: IF (g_debug IS NOT NULL) THEN
4140: gme_debug.log_initialize ('RelieveRsrvPndLots');
4141: END IF;
4142:
4143: x_return_status := fnd_api.g_ret_sts_success;
4144: x_error_msg := ' ';
4145:
4146: --calling gme_common_pvt routine
4147: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,

Line 4152: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4148: p_invoke_mode => 'T',
4149: x_trans_date => l_trans_date,
4150: x_return_status => x_return_status);
4151:
4152: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4153: gme_common_pvt.count_and_get (x_count => l_count
4154: ,p_encoded => fnd_api.g_false
4155: ,x_data => x_error_msg);
4156:

Line 4154: ,p_encoded => fnd_api.g_false

4150: x_return_status => x_return_status);
4151:
4152: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4153: gme_common_pvt.count_and_get (x_count => l_count
4154: ,p_encoded => fnd_api.g_false
4155: ,x_data => x_error_msg);
4156:
4157: END IF;
4158:

Line 4174: x_return_status := fnd_api.g_ret_sts_unexp_error;

4170: IF g_debug <= gme_debug.g_log_unexpected THEN
4171: gme_debug.put_line('When others exception in fetch_txn_date');
4172: END IF;
4173: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','fetch_txn_date');
4174: x_return_status := fnd_api.g_ret_sts_unexp_error;
4175: x_error_msg := fnd_message.get;
4176: END;
4177:
4178: --Bug#5867209 added restricted subinv code

Line 4210: x_return_status := fnd_api.g_ret_sts_success;

4206:
4207: l_exists NUMBER;
4208: ERROR_INV_SUBINV EXCEPTION;
4209: BEGIN
4210: x_return_status := fnd_api.g_ret_sts_success;
4211: x_error_message := ' ';
4212:
4213: IF p_restrict_code = 1 THEN
4214: OPEN x_sub_lov1;

Line 4231: x_return_status := fnd_api.g_ret_sts_error;

4227: END IF;
4228:
4229: EXCEPTION
4230: WHEN ERROR_INV_SUBINV THEN
4231: x_return_status := fnd_api.g_ret_sts_error;
4232: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_SUBINV');
4233: x_error_message := FND_MESSAGE.GET;
4234: END Validate_Subinv_Master;
4235:

Line 4268: x_return_status := fnd_api.g_ret_sts_success;

4264:
4265: l_exists NUMBER;
4266: ERROR_INVALID_LOCATOR EXCEPTION;
4267: BEGIN
4268: x_return_status := fnd_api.g_ret_sts_success;
4269: x_error_message := ' ';
4270:
4271: IF p_restrict_code = 1 THEN
4272: OPEN x_loc_lov1;

Line 4288: x_return_status := fnd_api.g_ret_sts_error;

4284: CLOSE x_loc_lov ;
4285: END IF;
4286: EXCEPTION
4287: WHEN ERROR_INVALID_LOCATOR THEN
4288: x_return_status := fnd_api.g_ret_sts_error;
4289: FND_MESSAGE.SET_NAME('GME','GME_NOT_VALID_LOC');
4290: x_error_message := FND_MESSAGE.GET;
4291: END Validate_Locator_Master;
4292: /* Bug#5663458 End*/

Line 4317: x_return_status := FND_API.G_RET_STS_SUCCESS;

4313: gme_debug.log_initialize ('MobileFetchSubinvLoc');
4314: END IF;
4315:
4316:
4317: x_return_status := FND_API.G_RET_STS_SUCCESS;
4318: x_error_msg := ' ';
4319:
4320: OPEN c_subinv_loc;
4321: FETCH c_subinv_loc INTO x_subinventory_code,x_locator,x_locator_id ;

Line 4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4326: IF g_debug <= gme_debug.g_log_unexpected THEN
4327: gme_debug.put_line('When others exception in Fetch_subinv_locator');
4328: END IF;
4329: fnd_msg_pub.add_exc_msg('GME_MOBILE_TXN','Fetch_subinv_locator');
4330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4331: x_error_msg := fnd_message.get;
4332: END Fetch_subinv_locator;
4333:
4334: -- nsinghi bug#5209065 START. Added following Procs.

Line 4348: x_return_status := FND_API.G_RET_STS_SUCCESS;

4344: l_mtlt_txn_rec MTL_TRANSACTION_LOTS_TEMP%ROWTYPE;
4345: l_lot_expiration_date DATE;
4346:
4347: BEGIN
4348: x_return_status := FND_API.G_RET_STS_SUCCESS;
4349: IF (g_debug IS NOT NULL) THEN
4350: gme_debug.log_initialize ('MobileGetExpDate');
4351: END IF;
4352:

Line 4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4362: ,x_lot_expiration_date => l_lot_expiration_date
4363: ,x_return_status => x_return_status);
4364:
4365: inv_calculate_exp_date.purge_mti_tab;
4366: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4367: IF g_debug <= gme_debug.g_log_statement THEN
4368: gme_debug.put_line('Program inv_calculate_exp_date.get_lot_expiration_date has failed with a Unexpected exception');
4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');

Line 4373: RAISE fnd_api.g_exc_unexpected_error;

4369: END IF;
4370: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
4371: FND_MESSAGE.SET_TOKEN('PROG_NAME','inv_calculate_exp_date.get_lot_expiration_date');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_unexpected_error;
4374: END IF;
4375: IF g_debug = 1 THEN
4376: gme_debug.put_line('l_lot_expiration_date '||l_lot_expiration_date);
4377: END IF;

Line 4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4380: -- x_expiration_date := x_origination_date + l_get_dft_attr_rec.shelf_life_days;
4381: END IF;
4382: EXCEPTION
4383: WHEN OTHERS THEN
4384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4385: IF g_debug <= gme_debug.g_log_unexpected THEN
4386: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4387: END IF;
4388: END get_expiration_date;

Line 4397: x_return_status := FND_API.G_RET_STS_SUCCESS;

4393: , x_exp_act_date OUT NOCOPY DATE
4394: , x_return_status OUT NOCOPY VARCHAR2
4395: ) IS
4396: BEGIN
4397: x_return_status := FND_API.G_RET_STS_SUCCESS;
4398: x_exp_act_date := p_expiration_date;
4399:
4400: IF p_expiration_date IS NOT NULL AND p_exp_act_interval IS NOT NULL THEN
4401: x_exp_act_date := p_expiration_date + p_exp_act_interval;

Line 4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4402: END IF;
4403:
4404: EXCEPTION
4405: WHEN OTHERS THEN
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: IF g_debug <= gme_debug.g_log_unexpected THEN
4408: gme_debug.put_line('WHEN OTHERS exception : '||SQLERRM);
4409: END IF;
4410: END get_exp_action_date;