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.

[Home] [Help]

APPS.CSD_RECEIVE_PVT dependencies on FND_API

Line 38: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

34: /* description : Populates the Receive open interface tables and calls the Receive processor. This handles */
35: /* all types of receives a) Direct b) Standard */
36: /* Called from : CSDREPLN.pld. logistics tab.*/
37: /* Input Parm : p_api_version NUMBER Required Api Version number */
38: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
39: /* default value is fnd_api.g_false */
40: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 39: /* default value is fnd_api.g_false */

35: /* all types of receives a) Direct b) Standard */
36: /* Called from : CSDREPLN.pld. logistics tab.*/
37: /* Input Parm : p_api_version NUMBER Required Api Version number */
38: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
39: /* default value is fnd_api.g_false */
40: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
43: /* validation steps must be done and which steps */

Line 40: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

36: /* Called from : CSDREPLN.pld. logistics tab.*/
37: /* Input Parm : p_api_version NUMBER Required Api Version number */
38: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
39: /* default value is fnd_api.g_false */
40: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
43: /* validation steps must be done and which steps */
44: /* should be skipped. */

Line 41: /* fnd_api.g_false */

37: /* Input Parm : p_api_version NUMBER Required Api Version number */
38: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
39: /* default value is fnd_api.g_false */
40: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
41: /* fnd_api.g_false */
42: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
43: /* validation steps must be done and which steps */
44: /* should be skipped. */
45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

Line 47: /* fnd_api.g_ret_sts_success (success) */

43: /* validation steps must be done and which steps */
44: /* should be skipped. */
45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
46: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
47: /* fnd_api.g_ret_sts_success (success) */
48: /* fnd_api.g_ret_sts_error (error) */
49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
50: /* x_msg_count NUMBER Number of messages in the message stack */
51: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 48: /* fnd_api.g_ret_sts_error (error) */

44: /* should be skipped. */
45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
46: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
47: /* fnd_api.g_ret_sts_success (success) */
48: /* fnd_api.g_ret_sts_error (error) */
49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
50: /* x_msg_count NUMBER Number of messages in the message stack */
51: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
52: /* x_rcv_error_msg_tbl Returns table of error messages */

Line 49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

45: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
46: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
47: /* fnd_api.g_ret_sts_success (success) */
48: /* fnd_api.g_ret_sts_error (error) */
49: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
50: /* x_msg_count NUMBER Number of messages in the message stack */
51: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
52: /* x_rcv_error_msg_tbl Returns table of error messages */
53: /*-----------------------------------------------------------------------------------------------------------*/

Line 94: IF fnd_api.to_boolean (p_init_msg_list)

90: dump_receive_tbl ( p_receive_tbl,
91: fnd_log.level_statement,
92: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.BEGIN'
93: );
94: IF fnd_api.to_boolean (p_init_msg_list)
95: THEN
96: -- initialize message list
97: fnd_msg_pub.initialize;
98: END IF;

Line 101: IF NOT fnd_api.compatible_api_call (l_api_version_number,

97: fnd_msg_pub.initialize;
98: END IF;
99:
100: -- Standard call to check for call compatibility.
101: IF NOT fnd_api.compatible_api_call (l_api_version_number,
102: p_api_version,
103: l_api_name,
104: g_pkg_name
105: )

Line 107: RAISE fnd_api.g_exc_unexpected_error;

103: l_api_name,
104: g_pkg_name
105: )
106: THEN
107: RAISE fnd_api.g_exc_unexpected_error;
108: END IF;
109:
110: -- initialize return status
111: x_return_status := fnd_api.g_ret_sts_success;

Line 111: x_return_status := fnd_api.g_ret_sts_success;

107: RAISE fnd_api.g_exc_unexpected_error;
108: END IF;
109:
110: -- initialize return status
111: x_return_status := fnd_api.g_ret_sts_success;
112:
113: /**********Program logic ******************/
114:
115: --Validate all the records in the input table.

Line 130: (p_validation_level => fnd_api.g_valid_level_full,

126: -- subhat, bug#9058678.
127: -- Dont error out entire transaction if one record errors out.
128: BEGIN
129: csd_receive_util.validate_rcv_input
130: (p_validation_level => fnd_api.g_valid_level_full,
131: x_return_status => x_return_status,
132: p_receive_rec => p_receive_tbl (l_index)
133: );
134: IF (x_return_status <> fnd_api.g_ret_sts_success)

Line 134: IF (x_return_status <> fnd_api.g_ret_sts_success)

130: (p_validation_level => fnd_api.g_valid_level_full,
131: x_return_status => x_return_status,
132: p_receive_rec => p_receive_tbl (l_index)
133: );
134: IF (x_return_status <> fnd_api.g_ret_sts_success)
135: THEN
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:

Line 136: RAISE fnd_api.g_exc_error;

132: p_receive_rec => p_receive_tbl (l_index)
133: );
134: IF (x_return_status <> fnd_api.g_ret_sts_success)
135: THEN
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: p_receive_tbl (l_index).routing_header_id :=
140: csd_receive_util.is_auto_rcv_available

Line 151: RAISE fnd_api.g_exc_error;

147: IF (p_receive_tbl (l_index).routing_header_id = -1)
148: THEN
149: fnd_message.set_name ('CSD', 'CSD_AUTO_RECV_NOT_POSSIBLE');
150: fnd_msg_pub.ADD;
151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: EXCEPTION
155: WHEN fnd_api.g_exc_error

Line 155: WHEN fnd_api.g_exc_error

151: RAISE fnd_api.g_exc_error;
152: END IF;
153:
154: EXCEPTION
155: WHEN fnd_api.g_exc_error
156: THEN
157: p_receive_tbl.delete(l_index);
158: IF p_receive_tbl.COUNT = 0
159: THEN

Line 160: RAISE fnd_api.g_exc_error;

156: THEN
157: p_receive_tbl.delete(l_index);
158: IF p_receive_tbl.COUNT = 0
159: THEN
160: RAISE fnd_api.g_exc_error;
161: END IF;
162: END;
163: IF p_receive_tbl.EXISTS(l_index)
164: THEN

Line 182: p_init_msg_list => fnd_api.g_false,

178: END IF;
179:
180: populate_rcv_intf_tbls
181: (p_api_version => 1.0,
182: p_init_msg_list => fnd_api.g_false,
183: p_validation_level => fnd_api.g_valid_level_full,
184: x_return_status => x_return_status,
185: x_msg_count => x_msg_count,
186: x_msg_data => x_msg_data,

Line 183: p_validation_level => fnd_api.g_valid_level_full,

179:
180: populate_rcv_intf_tbls
181: (p_api_version => 1.0,
182: p_init_msg_list => fnd_api.g_false,
183: p_validation_level => fnd_api.g_valid_level_full,
184: x_return_status => x_return_status,
185: x_msg_count => x_msg_count,
186: x_msg_data => x_msg_data,
187: p_receive_tbl => l_receive_tbl, -- changed to l_receive_tbl, bug#9058678, subhat

Line 191: IF (x_return_status <> fnd_api.g_ret_sts_success)

187: p_receive_tbl => l_receive_tbl, -- changed to l_receive_tbl, bug#9058678, subhat
188: x_request_group_id => l_request_group_id
189: );
190:
191: IF (x_return_status <> fnd_api.g_ret_sts_success)
192: THEN
193: RAISE fnd_api.g_exc_error;
194: END IF;
195:

Line 193: RAISE fnd_api.g_exc_error;

189: );
190:
191: IF (x_return_status <> fnd_api.g_ret_sts_success)
192: THEN
193: RAISE fnd_api.g_exc_error;
194: END IF;
195:
196: -- Call request online to invoke receiving processsor in online mode.
197: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 206: p_init_msg_list => fnd_api.g_false,

202: );
203: END IF;
204:
205: rcv_req_online (p_api_version => 1.0,
206: p_init_msg_list => fnd_api.g_false,
207: p_commit => fnd_api.g_false,
208: p_validation_level => fnd_api.g_valid_level_full,
209: x_return_status => x_return_status,
210: x_msg_count => x_msg_count,

Line 207: p_commit => fnd_api.g_false,

203: END IF;
204:
205: rcv_req_online (p_api_version => 1.0,
206: p_init_msg_list => fnd_api.g_false,
207: p_commit => fnd_api.g_false,
208: p_validation_level => fnd_api.g_valid_level_full,
209: x_return_status => x_return_status,
210: x_msg_count => x_msg_count,
211: x_msg_data => x_msg_data,

Line 208: p_validation_level => fnd_api.g_valid_level_full,

204:
205: rcv_req_online (p_api_version => 1.0,
206: p_init_msg_list => fnd_api.g_false,
207: p_commit => fnd_api.g_false,
208: p_validation_level => fnd_api.g_valid_level_full,
209: x_return_status => x_return_status,
210: x_msg_count => x_msg_count,
211: x_msg_data => x_msg_data,
212: p_request_group_id => l_request_group_id

Line 215: IF (x_return_status <> fnd_api.g_ret_sts_success)

211: x_msg_data => x_msg_data,
212: p_request_group_id => l_request_group_id
213: );
214:
215: IF (x_return_status <> fnd_api.g_ret_sts_success)
216: THEN
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:

Line 217: RAISE fnd_api.g_exc_error;

213: );
214:
215: IF (x_return_status <> fnd_api.g_ret_sts_success)
216: THEN
217: RAISE fnd_api.g_exc_error;
218: END IF;
219:
220: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
221: THEN

Line 236: IF (x_return_status <> fnd_api.g_ret_sts_success)

232: x_rcv_error_msg_tbl => x_rcv_error_msg_tbl,
233: p_request_group_id => l_request_group_id
234: );
235:
236: IF (x_return_status <> fnd_api.g_ret_sts_success)
237: THEN
238: RAISE fnd_api.g_exc_error;
239: END IF;
240:

Line 238: RAISE fnd_api.g_exc_error;

234: );
235:
236: IF (x_return_status <> fnd_api.g_ret_sts_success)
237: THEN
238: RAISE fnd_api.g_exc_error;
239: END IF;
240:
241:
242: -- Delete the interface table records created.

Line 250: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

246: x_return_status => x_return_status,
247: p_request_group_id => l_request_group_id
248: );
249: l_request_group_id := null;
250: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: *****************/
254:

Line 251: RAISE FND_API.G_EXC_ERROR;

247: p_request_group_id => l_request_group_id
248: );
249: l_request_group_id := null;
250: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: *****************/
254:
255:

Line 269: IF (p_commit = fnd_api.g_true)

265: );
266: END IF;
267:
268: --Commit the changes.
269: IF (p_commit = fnd_api.g_true)
270: THEN
271: COMMIT;
272: END IF;
273:

Line 275: WHEN fnd_api.g_exc_error

271: COMMIT;
272: END IF;
273:
274: EXCEPTION
275: WHEN fnd_api.g_exc_error
276: THEN
277: x_return_status := fnd_api.g_ret_sts_error;
278: ROLLBACK TO sp_receive_item;
279: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 277: x_return_status := fnd_api.g_ret_sts_error;

273:
274: EXCEPTION
275: WHEN fnd_api.g_exc_error
276: THEN
277: x_return_status := fnd_api.g_ret_sts_error;
278: ROLLBACK TO sp_receive_item;
279: fnd_msg_pub.count_and_get (p_count => x_msg_count,
280: p_data => x_msg_data);
281:

Line 298: WHEN fnd_api.g_exc_unexpected_error

294: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
295: 'EXC_ERROR in Receive_Item[' || x_msg_data || ']'
296: );
297: END IF;
298: WHEN fnd_api.g_exc_unexpected_error
299: THEN
300: x_return_status := fnd_api.g_ret_sts_unexp_error;
301: ROLLBACK TO sp_receive_item;
302: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 300: x_return_status := fnd_api.g_ret_sts_unexp_error;

296: );
297: END IF;
298: WHEN fnd_api.g_exc_unexpected_error
299: THEN
300: x_return_status := fnd_api.g_ret_sts_unexp_error;
301: ROLLBACK TO sp_receive_item;
302: fnd_msg_pub.count_and_get (p_count => x_msg_count,
303: p_data => x_msg_data);
304:

Line 314: x_return_status := fnd_api.g_ret_sts_unexp_error;

310: );
311: END IF;
312: WHEN OTHERS
313: THEN
314: x_return_status := fnd_api.g_ret_sts_unexp_error;
315: ROLLBACK TO sp_receive_item;
316:
317: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
318: THEN

Line 339: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

335: /* procedure name: POPULATE_INTF_TBLS */
336: /* description : Inserts records into open interface tables for receiving. */
337: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
338: /* Input Parm : p_api_version NUMBER Required Api Version number */
339: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
340: /* default value is fnd_api.g_false */
341: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
342: /* fnd_api.g_false */
343: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 340: /* default value is fnd_api.g_false */

336: /* description : Inserts records into open interface tables for receiving. */
337: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
338: /* Input Parm : p_api_version NUMBER Required Api Version number */
339: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
340: /* default value is fnd_api.g_false */
341: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
342: /* fnd_api.g_false */
343: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
344: /* validation steps must be done and which steps */

Line 341: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

337: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
338: /* Input Parm : p_api_version NUMBER Required Api Version number */
339: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
340: /* default value is fnd_api.g_false */
341: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
342: /* fnd_api.g_false */
343: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
344: /* validation steps must be done and which steps */
345: /* should be skipped. */

Line 342: /* fnd_api.g_false */

338: /* Input Parm : p_api_version NUMBER Required Api Version number */
339: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
340: /* default value is fnd_api.g_false */
341: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
342: /* fnd_api.g_false */
343: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
344: /* validation steps must be done and which steps */
345: /* should be skipped. */
346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

Line 348: /* fnd_api.g_ret_sts_success (success) */

344: /* validation steps must be done and which steps */
345: /* should be skipped. */
346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
347: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
348: /* fnd_api.g_ret_sts_success (success) */
349: /* fnd_api.g_ret_sts_error (error) */
350: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
351: /* x_msg_count NUMBER Number of messages in the message stack */
352: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 349: /* fnd_api.g_ret_sts_error (error) */

345: /* should be skipped. */
346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
347: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
348: /* fnd_api.g_ret_sts_success (success) */
349: /* fnd_api.g_ret_sts_error (error) */
350: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
351: /* x_msg_count NUMBER Number of messages in the message stack */
352: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
353: /* x_request_group_id NUMBER Required */

Line 350: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

346: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
347: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
348: /* fnd_api.g_ret_sts_success (success) */
349: /* fnd_api.g_ret_sts_error (error) */
350: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
351: /* x_msg_count NUMBER Number of messages in the message stack */
352: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
353: /* x_request_group_id NUMBER Required */
354: /*-----------------------------------------------------------------------------------------------------------*/

Line 411: IF fnd_api.to_boolean (p_init_msg_list)

407: END IF;
408:
409: l_source_code := 'CSD';
410:
411: IF fnd_api.to_boolean (p_init_msg_list)
412: THEN
413: -- initialize message list
414: fnd_msg_pub.initialize;
415: END IF;

Line 418: IF NOT fnd_api.compatible_api_call (l_api_version_number,

414: fnd_msg_pub.initialize;
415: END IF;
416:
417: -- Standard call to check for call compatibility.
418: IF NOT fnd_api.compatible_api_call (l_api_version_number,
419: p_api_version,
420: l_api_name,
421: g_pkg_name
422: )

Line 424: RAISE fnd_api.g_exc_unexpected_error;

420: l_api_name,
421: g_pkg_name
422: )
423: THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: -- initialize return status
428: x_return_status := fnd_api.g_ret_sts_success;

Line 428: x_return_status := fnd_api.g_ret_sts_success;

424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: -- initialize return status
428: x_return_status := fnd_api.g_ret_sts_success;
429:
430: ---Program logic.......
431: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
432: THEN

Line 905: WHEN fnd_api.g_exc_error

901: COMMIT;
902:
903:
904: EXCEPTION
905: WHEN fnd_api.g_exc_error
906: THEN
907: x_return_status := fnd_api.g_ret_sts_error;
908: ROLLBACK ;
909: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 907: x_return_status := fnd_api.g_ret_sts_error;

903:
904: EXCEPTION
905: WHEN fnd_api.g_exc_error
906: THEN
907: x_return_status := fnd_api.g_ret_sts_error;
908: ROLLBACK ;
909: fnd_msg_pub.count_and_get (p_count => x_msg_count,
910: p_data => x_msg_data);
911:

Line 920: WHEN fnd_api.g_exc_unexpected_error

916: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
917: 'EXC_EXC_ERROR in populate rcv intf tbls [' || x_msg_data || ']'
918: );
919: END IF;
920: WHEN fnd_api.g_exc_unexpected_error
921: THEN
922: x_return_status := fnd_api.g_ret_sts_unexp_error;
923: ROLLBACK ;
924: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 922: x_return_status := fnd_api.g_ret_sts_unexp_error;

918: );
919: END IF;
920: WHEN fnd_api.g_exc_unexpected_error
921: THEN
922: x_return_status := fnd_api.g_ret_sts_unexp_error;
923: ROLLBACK ;
924: fnd_msg_pub.count_and_get (p_count => x_msg_count,
925: p_data => x_msg_data);
926:

Line 937: x_return_status := fnd_api.g_ret_sts_unexp_error;

933: );
934: END IF;
935: WHEN OTHERS
936: THEN
937: x_return_status := fnd_api.g_ret_sts_unexp_error;
938: ROLLBACK ;
939:
940: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
941: THEN

Line 964: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

960: /* procedure name: RCV_REQ_ONLINE */
961: /* description : This API will submit the request for receiving in the online mode. */
962: /* Called from : */
963: /* Input Parm : p_api_version NUMBER Required Api Version number */
964: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
965: /* default value is fnd_api.g_false */
966: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
967: /* fnd_api.g_false */
968: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

Line 965: /* default value is fnd_api.g_false */

961: /* description : This API will submit the request for receiving in the online mode. */
962: /* Called from : */
963: /* Input Parm : p_api_version NUMBER Required Api Version number */
964: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
965: /* default value is fnd_api.g_false */
966: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
967: /* fnd_api.g_false */
968: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
969: /* validation steps must be done and which steps */

Line 966: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */

962: /* Called from : */
963: /* Input Parm : p_api_version NUMBER Required Api Version number */
964: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
965: /* default value is fnd_api.g_false */
966: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
967: /* fnd_api.g_false */
968: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
969: /* validation steps must be done and which steps */
970: /* should be skipped. */

Line 967: /* fnd_api.g_false */

963: /* Input Parm : p_api_version NUMBER Required Api Version number */
964: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
965: /* default value is fnd_api.g_false */
966: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
967: /* fnd_api.g_false */
968: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
969: /* validation steps must be done and which steps */
970: /* should be skipped. */
971: /* p_request_group_id NUMBER Required The request group for which the receiving */

Line 974: /* fnd_api.g_ret_sts_success (success) */

970: /* should be skipped. */
971: /* p_request_group_id NUMBER Required The request group for which the receiving */
972: /* processor
973: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
974: /* fnd_api.g_ret_sts_success (success) */
975: /* fnd_api.g_ret_sts_error (error) */
976: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
977: /* x_msg_count NUMBER Number of messages in the message stack */
978: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 975: /* fnd_api.g_ret_sts_error (error) */

971: /* p_request_group_id NUMBER Required The request group for which the receiving */
972: /* processor
973: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
974: /* fnd_api.g_ret_sts_success (success) */
975: /* fnd_api.g_ret_sts_error (error) */
976: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
977: /* x_msg_count NUMBER Number of messages in the message stack */
978: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
979: /*-----------------------------------------------------------------------------------------------------------*/

Line 976: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

972: /* processor
973: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
974: /* fnd_api.g_ret_sts_success (success) */
975: /* fnd_api.g_ret_sts_error (error) */
976: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
977: /* x_msg_count NUMBER Number of messages in the message stack */
978: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
979: /*-----------------------------------------------------------------------------------------------------------*/
980: PROCEDURE rcv_req_online (

Line 1049: IF fnd_api.to_boolean (p_init_msg_list)

1045:
1046: -- Standard Start of API savepoint
1047: SAVEPOINT sp_rcv_req_online;
1048:
1049: IF fnd_api.to_boolean (p_init_msg_list)
1050: THEN
1051: -- initialize message list
1052: fnd_msg_pub.initialize;
1053: END IF;

Line 1056: IF NOT fnd_api.compatible_api_call (l_api_version_number,

1052: fnd_msg_pub.initialize;
1053: END IF;
1054:
1055: -- Standard call to check for call compatibility.
1056: IF NOT fnd_api.compatible_api_call (l_api_version_number,
1057: p_api_version,
1058: l_api_name,
1059: g_pkg_name
1060: )

Line 1062: RAISE fnd_api.g_exc_unexpected_error;

1058: l_api_name,
1059: g_pkg_name
1060: )
1061: THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064:
1065: -- initialize return status
1066: x_return_status := fnd_api.g_ret_sts_success;

Line 1066: x_return_status := fnd_api.g_ret_sts_success;

1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064:
1065: -- initialize return status
1066: x_return_status := fnd_api.g_ret_sts_success;
1067:
1068: /*
1069: ** Set the cursor style to working
1070: */

Line 1132: --RAISE FND_API.G_EXC_ERROR;

1128: END LOOP;
1129: END IF;
1130: --FND_MESSAGE.SET_NAME('CSD', 'CSD_RECEIVE_ERROR');
1131: --FND_MSG_PUB.ADD;
1132: --RAISE FND_API.G_EXC_ERROR;
1133: END IF;
1134:
1135: -- dbms_output.put_line('outcome=[-'||outcome||'-]');
1136: -- dbms_output.put_line('message=[-'||message||'-]');

Line 1172: x_return_status := fnd_api.g_ret_sts_error;

1168: fnd_message.set_token ('REQUEST', p_request_group_id);
1169: fnd_message.set_token ('REASON', l_str1);
1170: --fnd_message.show;
1171: fnd_msg_pub.ADD;
1172: x_return_status := fnd_api.g_ret_sts_error;
1173: END IF;
1174: ELSIF (l_Ret_code = 2)
1175: THEN
1176: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1217: x_return_status := fnd_api.g_ret_sts_error;

1213: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE');
1214: END IF;
1215:
1216: fnd_msg_pub.ADD;
1217: x_return_status := fnd_api.g_ret_sts_error;
1218: END IF;
1219: ELSIF (l_ret_code = 3 OR (l_outcome IN ('WARNING', 'ERROR')))
1220: THEN
1221: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1369: x_return_status := fnd_api.g_ret_sts_error;

1365: 'fnd_trnasaction.synchronous:[' || l_str1 || ']'
1366: );
1367: END IF;
1368:
1369: x_return_status := fnd_api.g_ret_sts_error;
1370: --END IF;
1371: END IF;
1372: -- 12.1.2 Bulk Receive ER FP, subhat.
1373: -- when the request is submitted from Bulk Receive Page,

Line 1408: WHEN fnd_api.g_exc_error

1404: 'Leaving RCV_REQ_ONLINE'
1405: );
1406: END IF;
1407: EXCEPTION
1408: WHEN fnd_api.g_exc_error
1409: THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: ROLLBACK TO sp_rcv_req_online;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1410: x_return_status := fnd_api.g_ret_sts_error;

1406: END IF;
1407: EXCEPTION
1408: WHEN fnd_api.g_exc_error
1409: THEN
1410: x_return_status := fnd_api.g_ret_sts_error;
1411: ROLLBACK TO sp_rcv_req_online;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1413: p_data => x_msg_data);
1414:

Line 1422: WHEN fnd_api.g_exc_unexpected_error

1418: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1419: 'EXC_ERROR[' || x_msg_data || ']'
1420: );
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error
1423: THEN
1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425: ROLLBACK TO sp_rcv_req_online;
1426: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1424: x_return_status := fnd_api.g_ret_sts_unexp_error;

1420: );
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error
1423: THEN
1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425: ROLLBACK TO sp_rcv_req_online;
1426: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:

Line 1438: x_return_status := fnd_api.g_ret_sts_unexp_error;

1434: );
1435: END IF;
1436: WHEN OTHERS
1437: THEN
1438: x_return_status := fnd_api.g_ret_sts_unexp_error;
1439: ROLLBACK TO sp_rcv_req_online;
1440:
1441: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1442: THEN

Line 1468: /* fnd_api.g_ret_sts_success (success) */

1464: /* p_request_group_id NUMBER Required */
1465: /* p_interface_transaction_Id NUMBER Required */
1466: /* p_interface_header_Id NUMBER Required */
1467: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1468: /* fnd_api.g_ret_sts_success (success) */
1469: /* fnd_api.g_ret_sts_error (error) */
1470: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1471: /*-----------------------------------------------------------------------------------------------------------*/
1472: PROCEDURE delete_intf_tbls (

Line 1469: /* fnd_api.g_ret_sts_error (error) */

1465: /* p_interface_transaction_Id NUMBER Required */
1466: /* p_interface_header_Id NUMBER Required */
1467: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1468: /* fnd_api.g_ret_sts_success (success) */
1469: /* fnd_api.g_ret_sts_error (error) */
1470: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1471: /*-----------------------------------------------------------------------------------------------------------*/
1472: PROCEDURE delete_intf_tbls (
1473: x_return_status OUT NOCOPY VARCHAR2,

Line 1470: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

1466: /* p_interface_header_Id NUMBER Required */
1467: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1468: /* fnd_api.g_ret_sts_success (success) */
1469: /* fnd_api.g_ret_sts_error (error) */
1470: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1471: /*-----------------------------------------------------------------------------------------------------------*/
1472: PROCEDURE delete_intf_tbls (
1473: x_return_status OUT NOCOPY VARCHAR2,
1474: p_request_group_id IN NUMBER

Line 1503: x_return_status := fnd_api.g_ret_sts_success;

1499: );
1500: END IF;
1501:
1502: -- initialize return status
1503: x_return_status := fnd_api.g_ret_sts_success;
1504:
1505:
1506: -----------------------------------------------Delete from errors table
1507: FOR l_hdr_rec in cur_headers(p_request_group_id) LOOP

Line 1518: RAISE fnd_api.g_exc_unexpected_error;

1514: THEN
1515: NULL;
1516: WHEN OTHERS
1517: THEN
1518: RAISE fnd_api.g_exc_unexpected_error;
1519: END;
1520: END LOOP;
1521:
1522: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP

Line 1533: RAISE fnd_api.g_exc_unexpected_error;

1529: THEN
1530: NULL;
1531: WHEN OTHERS
1532: THEN
1533: RAISE fnd_api.g_exc_unexpected_error;
1534: END;
1535: END LOOP;
1536:
1537: ----------------------------------------------Delete from the MTL lots/MTL serial numbers

Line 1554: RAISE fnd_api.g_exc_unexpected_error;

1550: THEN
1551: NULL;
1552: WHEN OTHERS
1553: THEN
1554: RAISE fnd_api.g_exc_unexpected_error;
1555: END;
1556: END LOOP;
1557:
1558: ----------------------------------------------Delete from headers table.

Line 1576: RAISE fnd_api.g_exc_unexpected_error;

1572: THEN
1573: NULL;
1574: WHEN OTHERS
1575: THEN
1576: RAISE fnd_api.g_exc_unexpected_error;
1577: END;
1578: ----------------------------------------------Delete from the detail txn records.
1579: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1580: THEN

Line 1596: RAISE fnd_api.g_exc_unexpected_error;

1592: THEN
1593: NULL;
1594: WHEN OTHERS
1595: THEN
1596: RAISE fnd_api.g_exc_unexpected_error;
1597: END;
1598:
1599:
1600: COMMIT;

Line 1610: WHEN fnd_api.g_exc_unexpected_error

1606: 'Leaving DELETE_INTF_TBLS'
1607: );
1608: END IF;
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_unexpected_error
1611: THEN
1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613: ROLLBACK ;
1614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1612: x_return_status := fnd_api.g_ret_sts_unexp_error;

1608: END IF;
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_unexpected_error
1611: THEN
1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613: ROLLBACK ;
1614: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1615: THEN
1616: fnd_log.STRING (fnd_log.level_exception,

Line 1623: x_return_status := fnd_api.g_ret_sts_unexp_error;

1619: );
1620: END IF;
1621: WHEN OTHERS
1622: THEN
1623: x_return_status := fnd_api.g_ret_sts_unexp_error;
1624: ROLLBACK;
1625:
1626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1627: THEN