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_PUTAWAY_SUGGESTIONS dependencies on FND_API

Line 94: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

90: p_is_srs_call => Nvl(p_is_srs_call, 'Y')
91: );
92:
93:
94: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
95: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
96: RAISE fnd_api.g_exc_error;
97: ELSE
98: RAISE fnd_api.g_exc_unexpected_error;

Line 95: IF (l_return_status = fnd_api.g_ret_sts_error) THEN

91: );
92:
93:
94: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
95: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
96: RAISE fnd_api.g_exc_error;
97: ELSE
98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;

Line 96: RAISE fnd_api.g_exc_error;

92:
93:
94: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
95: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
96: RAISE fnd_api.g_exc_error;
97: ELSE
98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;
100: ELSE

Line 98: RAISE fnd_api.g_exc_unexpected_error;

94: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
95: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
96: RAISE fnd_api.g_exc_error;
97: ELSE
98: RAISE fnd_api.g_exc_unexpected_error;
99: END IF;
100: ELSE
101: IF (l_partial_success = 'Y') THEN
102: fnd_message.set_name('WMS', 'WMS_LPN_PROC_WARN');

Line 105: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

101: IF (l_partial_success = 'Y') THEN
102: fnd_message.set_name('WMS', 'WMS_LPN_PROC_WARN');
103: fnd_msg_pub.add;
104: print_message();
105: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
106: l_conc_status := fnd_concurrent.set_completion_status('WARNING',l_msg);
107: x_retcode := RETCODE_WARNING;
108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
109: ELSE

Line 108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

104: print_message();
105: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
106: l_conc_status := fnd_concurrent.set_completion_status('WARNING',l_msg);
107: x_retcode := RETCODE_WARNING;
108: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
109: ELSE
110: print_message();
111: l_conc_status := fnd_concurrent.set_completion_status('NORMAL','NORMAL');
112: x_retcode := RETCODE_SUCCESS;

Line 119: WHEN fnd_api.g_exc_error THEN

115: END IF;
116:
117:
118: EXCEPTION
119: WHEN fnd_api.g_exc_error THEN
120:
121: print_message();
122: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
123: x_retcode := RETCODE_ERROR;

Line 124: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

120:
121: print_message();
122: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
123: x_retcode := RETCODE_ERROR;
124: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
125:
126: WHEN fnd_api.g_exc_unexpected_error THEN
127:
128: print_message();

Line 126: WHEN fnd_api.g_exc_unexpected_error THEN

122: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
123: x_retcode := RETCODE_ERROR;
124: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
125:
126: WHEN fnd_api.g_exc_unexpected_error THEN
127:
128: print_message();
129: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
130: x_retcode := RETCODE_ERROR;

Line 131: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

127:
128: print_message();
129: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
130: x_retcode := RETCODE_ERROR;
131: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
132:
133: WHEN OTHERS THEN
134:
135: print_message();

Line 138: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

134:
135: print_message();
136: l_conc_status := fnd_concurrent.set_completion_status('ERROR','ERROR');
137: x_retcode := RETCODE_ERROR;
138: x_errorbuf := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
139:
140: END conc_pre_generate;
141:
142:

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156:
157: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
158: BEGIN
159:
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: IF (l_debug = 1) THEN
162: print_debug('Entered start_pregenerate_program');
163: print_debug('Org:'||p_org_id);
164: print_debug('LPN:'||p_lpn_id);

Line 178: RAISE fnd_api.g_exc_error;

174:
175: IF (NOT l_wms_install) THEN
176: fnd_message.set_name('WMS', 'WMS_NOT_INSTALLED');
177: fnd_msg_pub.add;
178: RAISE fnd_api.g_exc_error;
179: END IF;
180: */
181:
182: IF (p_org_id is null) THEN

Line 185: RAISE fnd_api.g_exc_error;

181:
182: IF (p_org_id is null) THEN
183: fnd_message.set_name('INV', 'INV_ORG_REQUIRED');
184: fnd_msg_pub.add;
185: RAISE fnd_api.g_exc_error;
186: END IF;
187:
188:
189: l_req_id := fnd_request.submit_request

Line 204: RAISE fnd_api.g_exc_error;

200: IF l_req_id = 0 THEN
201: IF (l_debug = 1) THEN
202: print_debug('error calling the conc. request');
203: END IF;
204: RAISE fnd_api.g_exc_error;
205: END IF;
206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203: END IF;
204: RAISE fnd_api.g_exc_error;
205: END IF;
206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206:
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 211: x_return_status := FND_API.G_RET_STS_ERROR;

207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: EXCEPTION
210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: WHEN FND_API.G_EXC_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
217:
218: WHEN OTHERS THEN

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
217:
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
221:
222: END start_pregenerate_program;
223:

Line 402: x_return_status := fnd_api.g_ret_sts_success;

398:
399:
400: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
401: BEGIN
402: x_return_status := fnd_api.g_ret_sts_success;
403:
404: IF (l_debug = 1) THEN
405: print_debug('pre_generate: Starting pre_generate API');
406: print_debug('p_from_conc_pgm => ' || p_from_conc_pgm);

Line 422: RAISE fnd_api.g_exc_error;

418: IF (l_debug = 1) THEN
419: print_debug('pre_generate: p_organization_ID is null');
420: END IF;
421:
422: RAISE fnd_api.g_exc_error;
423: END IF;
424:
425: --This savepoint is used to rollback if p_commit = 'N' and an error
426: --ocurrs.

Line 455: RAISE fnd_api.g_exc_error;

451: IF (l_debug = 1) THEN
452: print_debug('pre_generate: p_lpn_id '||p_lpn_id||' does not exist. ' );
453: END IF;
454:
455: RAISE fnd_api.g_exc_error;
456:
457: WHEN record_locked THEN
458: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
459: fnd_msg_pub.ADD;

Line 465: RAISE fnd_api.g_exc_error;

461: IF (l_debug = 1) THEN
462: print_debug('pre_generate: LPN not available. It is locked by someone else, either by different pre-generate process, or putaway load page');
463: END IF;
464:
465: RAISE fnd_api.g_exc_error;
466:
467: END;
468:
469: IF (l_debug = 1) THEN

Line 481: RAISE fnd_api.g_exc_error;

477: IF (l_debug = 1) THEN
478: print_debug('pre_generate: l_lpn_context is not WIP or Receiving, do not pre-generate.' );
479: END IF;
480:
481: RAISE fnd_api.g_exc_error;
482: END IF;
483:
484: -- Do not pre-generate if any move order line in this LPN with wms_process_flag = 2
485:

Line 510: RAISE fnd_api.g_exc_error;

506: IF (l_debug = 1) THEN
507: print_debug('pre_generate: move order wms_process_flag indicates allocation is not yet allowed.');
508: END IF;
509:
510: RAISE fnd_api.g_exc_error;
511: END IF;
512:
513: -- End of validation added in ATF_J
514: END IF; --BUG3497572 p_lpn_id is an optional when pre_generate called from concurrent request

Line 550: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

546: print_debug('l_msg_count = '||l_msg_count);
547: print_debug('l_msg_data = '||l_msg_data);
548: END IF;
549:
550: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
551: IF (l_debug = 1) THEN
552: print_debug('pre_generate: Success returned from WMS_Cross_Dock_Pvt.crossdock API');
553: END IF;
554: ELSE

Line 558: RAISE fnd_api.g_exc_error;

554: ELSE
555: IF (l_debug = 1) THEN
556: print_debug('pre_generate: Failure returned from WMS_Cross_Dock_Pvt.crossdock API');
557: END IF;
558: RAISE fnd_api.g_exc_error;
559:
560: END IF; -- (l_return_status = fnd_api.g_ret_sts_success)
561:
562: IF l_ret_crossdock <> 0 THEN

Line 560: END IF; -- (l_return_status = fnd_api.g_ret_sts_success)

556: print_debug('pre_generate: Failure returned from WMS_Cross_Dock_Pvt.crossdock API');
557: END IF;
558: RAISE fnd_api.g_exc_error;
559:
560: END IF; -- (l_return_status = fnd_api.g_ret_sts_success)
561:
562: IF l_ret_crossdock <> 0 THEN
563: IF (l_debug = 1) THEN
564: print_debug('pre_generate:Crossdock did not happen, get org level flag');

Line 618: p_init_msg_list => FND_API.G_TRUE,

614:
615: --Calling Rules Engine.
616: INV_PPEngine_PVT.create_suggestions
617: (p_api_version => 1.0,
618: p_init_msg_list => FND_API.G_TRUE,
619: p_commit => FND_API.G_FALSE,
620: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
621: x_return_status => l_return_status,
622: x_msg_count => l_msg_count,

Line 619: p_commit => FND_API.G_FALSE,

615: --Calling Rules Engine.
616: INV_PPEngine_PVT.create_suggestions
617: (p_api_version => 1.0,
618: p_init_msg_list => FND_API.G_TRUE,
619: p_commit => FND_API.G_FALSE,
620: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
621: x_return_status => l_return_status,
622: x_msg_count => l_msg_count,
623: x_msg_data => l_msg_data,

Line 620: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

616: INV_PPEngine_PVT.create_suggestions
617: (p_api_version => 1.0,
618: p_init_msg_list => FND_API.G_TRUE,
619: p_commit => FND_API.G_FALSE,
620: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
621: x_return_status => l_return_status,
622: x_msg_count => l_msg_count,
623: x_msg_data => l_msg_data,
624: p_transaction_temp_id => l_mol_line_id,

Line 638: -- we raise the fnd_api.g_exc_error

634: -- the MOL that might have been set by crossdock. However,
635: -- l_return_status is always success even though the rules engine cannot create suggestion
636: -- thus, this if statement will never be true until the rules engine is fixed
637: -- for now, a work around is to check the mmtt cursor record count. if it is 0, then
638: -- we raise the fnd_api.g_exc_error
639: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
640: l_error := TRUE;
641: l_partial_success := 'Y';
642:

Line 639: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

635: -- l_return_status is always success even though the rules engine cannot create suggestion
636: -- thus, this if statement will never be true until the rules engine is fixed
637: -- for now, a work around is to check the mmtt cursor record count. if it is 0, then
638: -- we raise the fnd_api.g_exc_error
639: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
640: l_error := TRUE;
641: l_partial_success := 'Y';
642:
643: --Log Errored lpn_id and line_id with the error msg in msg file.

Line 657: RAISE fnd_api.g_exc_error;

653:
654: IF (l_from_conc_pgm = 'Y') THEN
655: print_message();
656: END IF;
657: RAISE fnd_api.g_exc_error;
658:
659: ELSE
660:
661: -- Log Success in msg file.

Line 734: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

730: /* End of fix for bug # 4964866*/
731:
732: END IF;
733:
734: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
735:
736: IF (l_debug = 1) THEN
737: print_debug('pre_generate: Label printing failed. Continue');
738: END IF;

Line 785: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

781: print_debug('pre_generate: After calling wms_rule_pvt.assign_operation_plan');
782: print_debug('l_return_status = ' || l_return_status);
783: END IF;
784:
785: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
786:
787: IF (l_debug = 1) THEN
788: print_debug('pre_generate: wms_rule_pvt.assign_operation_plan failed.');
789: END IF;

Line 791: RAISE fnd_api.g_exc_error;

787: IF (l_debug = 1) THEN
788: print_debug('pre_generate: wms_rule_pvt.assign_operation_plan failed.');
789: END IF;
790:
791: RAISE fnd_api.g_exc_error;
792:
793: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
794:
795: IF (l_debug = 1) THEN

Line 793: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)

789: END IF;
790:
791: RAISE fnd_api.g_exc_error;
792:
793: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
794:
795: IF (l_debug = 1) THEN
796: --Following API initializes the operation plan instance
797: print_debug('pre_generate: Before calling wms_op_runtime_pub_apis.init_op_plan_instance with following parameters: ');

Line 818: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

814: print_debug('pre_generate: After calling wms_op_runtime_pub_apis.init_plan_instance');
815: print_debug('l_return_status = ' || l_return_status);
816: END IF;
817:
818: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
819:
820: IF (l_debug = 1) THEN
821: print_debug('pre_generate: wms_op_runtime_pub_apis.init_plan_instance failed.');
822: END IF;

Line 824: RAISE fnd_api.g_exc_error;

820: IF (l_debug = 1) THEN
821: print_debug('pre_generate: wms_op_runtime_pub_apis.init_plan_instance failed.');
822: END IF;
823:
824: RAISE fnd_api.g_exc_error;
825:
826: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
827:
828: END IF; -- (l_operation_plan_id IS NULL)

Line 826: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)

822: END IF;
823:
824: RAISE fnd_api.g_exc_error;
825:
826: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
827:
828: END IF; -- (l_operation_plan_id IS NULL)
829:
830: -- End new API calls added for ATF_J

Line 904: RAISE fnd_api.g_exc_error;

900: );
901: print_debug(' After calling the revert_loc_suggested_capacity');
902: ROLLBACK;
903:
904: RAISE fnd_api.g_exc_error;
905: else
906: if (p_commit = 'Y') then
907: print_debug(' Before LPN Commit');
908: commit;

Line 929: RAISE fnd_api.g_exc_error;

925: fnd_msg_pub.add;
926:
927: --If all the lpns have failed then we raise ERROR.
928: IF (l_cnt_success = 0) AND (l_cnt_failed > 0) THEN
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:
932: IF (l_from_conc_pgm = 'Y') THEN
933: print_message();

Line 942: WHEN fnd_api.g_exc_error THEN

938: print_debug('pre_generate: End of pre_generate API');
939: END IF;
940:
941: EXCEPTION
942: WHEN fnd_api.g_exc_error THEN
943: x_return_status := fnd_api.g_ret_sts_error;
944:
945: IF (l_from_conc_pgm = 'Y') THEN
946: print_message();

Line 943: x_return_status := fnd_api.g_ret_sts_error;

939: END IF;
940:
941: EXCEPTION
942: WHEN fnd_api.g_exc_error THEN
943: x_return_status := fnd_api.g_ret_sts_error;
944:
945: IF (l_from_conc_pgm = 'Y') THEN
946: print_message();
947: END IF;

Line 950: print_debug('pre_generate: fnd_api.g_exc_error');

946: print_message();
947: END IF;
948:
949: IF (l_debug = 1) THEN
950: print_debug('pre_generate: fnd_api.g_exc_error');
951: END IF;
952:
953: IF ((p_commit = 'N') OR (NOT(l_entry_loop))) THEN
954: ROLLBACK TO SAVEPOINT suggestions_start_sp;

Line 967: WHEN fnd_api.g_exc_unexpected_error THEN

963: IF mmtt_cursor%isopen THEN
964: CLOSE mmtt_cursor;
965: END IF;
966:
967: WHEN fnd_api.g_exc_unexpected_error THEN
968: x_return_status := fnd_api.g_ret_sts_unexp_error ;
969:
970: IF (l_from_conc_pgm = 'Y') THEN
971: print_message();

Line 968: x_return_status := fnd_api.g_ret_sts_unexp_error ;

964: CLOSE mmtt_cursor;
965: END IF;
966:
967: WHEN fnd_api.g_exc_unexpected_error THEN
968: x_return_status := fnd_api.g_ret_sts_unexp_error ;
969:
970: IF (l_from_conc_pgm = 'Y') THEN
971: print_message();
972: END IF;

Line 975: print_debug('pre_generate: fnd_api.g_exc_unexpected_error');

971: print_message();
972: END IF;
973:
974: IF (l_debug = 1) THEN
975: print_debug('pre_generate: fnd_api.g_exc_unexpected_error');
976: END IF;
977:
978: IF ((p_commit = 'N') OR (NOT(l_entry_loop))) THEN
979: ROLLBACK TO SAVEPOINT suggestions_start_sp;

Line 993: x_return_status := fnd_api.g_ret_sts_unexp_error ;

989: CLOSE mmtt_cursor;
990: END IF;
991:
992: WHEN OTHERS THEN
993: x_return_status := fnd_api.g_ret_sts_unexp_error ;
994:
995: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) THEN
996: fnd_msg_pub.add_exc_msg(g_pkg_name, 'PRE_GENERATE');
997: END IF;

Line 1122: IF x_return_status = fnd_api.g_ret_sts_error THEN

1118: print_debug('cleanup_suggestions: After calling inv_loc_wms_utils.revert_loc_suggested_capacity');
1119: print_debug(' x_return_status = ' || x_return_status);
1120: END IF;
1121:
1122: IF x_return_status = fnd_api.g_ret_sts_error THEN
1123: -- Bug 5393727: do not raise an exception if locator API returns an error
1124: -- RAISE fnd_api.g_exc_error;
1125: NULL;
1126: END IF ;

Line 1124: -- RAISE fnd_api.g_exc_error;

1120: END IF;
1121:
1122: IF x_return_status = fnd_api.g_ret_sts_error THEN
1123: -- Bug 5393727: do not raise an exception if locator API returns an error
1124: -- RAISE fnd_api.g_exc_error;
1125: NULL;
1126: END IF ;
1127:
1128: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1128: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1124: -- RAISE fnd_api.g_exc_error;
1125: NULL;
1126: END IF ;
1127:
1128: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1129: -- Bug 5393727: do not raise an exception if locator API returns an error
1130: -- RAISE fnd_api.g_exc_unexpected_error;
1131: NULL;
1132: END IF;

Line 1130: -- RAISE fnd_api.g_exc_unexpected_error;

1126: END IF ;
1127:
1128: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1129: -- Bug 5393727: do not raise an exception if locator API returns an error
1130: -- RAISE fnd_api.g_exc_unexpected_error;
1131: NULL;
1132: END IF;
1133:
1134: END IF;

Line 1173: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1169: print_debug('cleanup_suggestions: After calling wms_op_runtime_pub_apis.Abort_Operation_Plan');
1170: print_debug(' l_return_status = ' || l_return_status);
1171: END IF;
1172:
1173: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1174:
1175: IF (l_debug = 1) THEN
1176: print_debug('cleanup_suggestions: wms_op_runtime_pub_apis.Abort_Operation_Plan failed.');
1177: END IF;

Line 1179: RAISE fnd_api.g_exc_error;

1175: IF (l_debug = 1) THEN
1176: print_debug('cleanup_suggestions: wms_op_runtime_pub_apis.Abort_Operation_Plan failed.');
1177: END IF;
1178:
1179: RAISE fnd_api.g_exc_error;
1180:
1181: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
1182:
1183:

Line 1181: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)

1177: END IF;
1178:
1179: RAISE fnd_api.g_exc_error;
1180:
1181: END IF; -- (l_return_status <> fnd_api.g_ret_sts_success)
1182:
1183:
1184: END IF; -- current_suggestion.operation_plan_id IS NOT
1185: -- End ATF_J

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: EXCEPTION
1210: WHEN NO_DATA_FOUND THEN NULL;
1211: END;
1212:
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214: IF (l_debug = 1) THEN
1215: print_debug('clean_up suggestions: End of cleanup_suggestions API');
1216: END IF;
1217:

Line 1220: WHEN FND_API.G_EXC_ERROR THEN

1216: END IF;
1217:
1218:
1219: EXCEPTION
1220: WHEN FND_API.G_EXC_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO sp_cleanup_suggs;
1224:

Line 1221: x_return_status := FND_API.G_RET_STS_ERROR;

1217:
1218:
1219: EXCEPTION
1220: WHEN FND_API.G_EXC_ERROR THEN
1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO sp_cleanup_suggs;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1221: x_return_status := FND_API.G_RET_STS_ERROR;
1222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO sp_cleanup_suggs;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1228: ROLLBACK TO sp_cleanup_suggs;
1229:

Line 1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO sp_cleanup_suggs;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1228: ROLLBACK TO sp_cleanup_suggs;
1229:
1230: WHEN OTHERS THEN

Line 1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1228: ROLLBACK TO sp_cleanup_suggs;
1229:
1230: WHEN OTHERS THEN
1231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1233: ROLLBACK TO sp_cleanup_suggs;
1234:
1235: END cleanup_suggestions;