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.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 89: IF fnd_api.to_boolean (p_init_msg_list)

85: dump_receive_tbl ( p_receive_tbl,
86: fnd_log.level_statement,
87: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM.BEGIN'
88: );
89: IF fnd_api.to_boolean (p_init_msg_list)
90: THEN
91: -- initialize message list
92: fnd_msg_pub.initialize;
93: END IF;

Line 96: IF NOT fnd_api.compatible_api_call (l_api_version_number,

92: fnd_msg_pub.initialize;
93: END IF;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT fnd_api.compatible_api_call (l_api_version_number,
97: p_api_version,
98: l_api_name,
99: g_pkg_name
100: )

Line 102: RAISE fnd_api.g_exc_unexpected_error;

98: l_api_name,
99: g_pkg_name
100: )
101: THEN
102: RAISE fnd_api.g_exc_unexpected_error;
103: END IF;
104:
105: -- initialize return status
106: x_return_status := fnd_api.g_ret_sts_success;

Line 106: x_return_status := fnd_api.g_ret_sts_success;

102: RAISE fnd_api.g_exc_unexpected_error;
103: END IF;
104:
105: -- initialize return status
106: x_return_status := fnd_api.g_ret_sts_success;
107:
108: /**********Program logic ******************/
109:
110: --Validate all the records in the input table.

Line 122: (p_validation_level => fnd_api.g_valid_level_full,

118: -------------Validate Input data.
119: FOR l_index IN p_receive_tbl.FIRST .. p_receive_tbl.LAST
120: LOOP
121: csd_receive_util.validate_rcv_input
122: (p_validation_level => fnd_api.g_valid_level_full,
123: x_return_status => x_return_status,
124: p_receive_rec => p_receive_tbl (l_index)
125: );
126: IF (x_return_status <> fnd_api.g_ret_sts_success)

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

122: (p_validation_level => fnd_api.g_valid_level_full,
123: x_return_status => x_return_status,
124: p_receive_rec => p_receive_tbl (l_index)
125: );
126: IF (x_return_status <> fnd_api.g_ret_sts_success)
127: THEN
128: RAISE fnd_api.g_exc_error;
129: END IF;
130:

Line 128: RAISE fnd_api.g_exc_error;

124: p_receive_rec => p_receive_tbl (l_index)
125: );
126: IF (x_return_status <> fnd_api.g_ret_sts_success)
127: THEN
128: RAISE fnd_api.g_exc_error;
129: END IF;
130:
131: p_receive_tbl (l_index).routing_header_id :=
132: csd_receive_util.is_auto_rcv_available

Line 143: RAISE fnd_api.g_exc_error;

139: IF (p_receive_tbl (l_index).routing_header_id = -1)
140: THEN
141: fnd_message.set_name ('CSD', 'CSD_AUTO_RECV_NOT_POSSIBLE');
142: fnd_msg_pub.ADD;
143: RAISE fnd_api.g_exc_error;
144: END IF;
145:
146: END LOOP;
147:

Line 159: p_init_msg_list => fnd_api.g_false,

155: END IF;
156:
157: populate_rcv_intf_tbls
158: (p_api_version => 1.0,
159: p_init_msg_list => fnd_api.g_false,
160: p_validation_level => fnd_api.g_valid_level_full,
161: x_return_status => x_return_status,
162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,

Line 160: p_validation_level => fnd_api.g_valid_level_full,

156:
157: populate_rcv_intf_tbls
158: (p_api_version => 1.0,
159: p_init_msg_list => fnd_api.g_false,
160: p_validation_level => fnd_api.g_valid_level_full,
161: x_return_status => x_return_status,
162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,
164: p_receive_tbl => p_receive_tbl,

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

164: p_receive_tbl => p_receive_tbl,
165: x_request_group_id => l_request_group_id
166: );
167:
168: IF (x_return_status <> fnd_api.g_ret_sts_success)
169: THEN
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:

Line 170: RAISE fnd_api.g_exc_error;

166: );
167:
168: IF (x_return_status <> fnd_api.g_ret_sts_success)
169: THEN
170: RAISE fnd_api.g_exc_error;
171: END IF;
172:
173: -- Call request online to invoke receiving processsor in online mode.
174: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 183: p_init_msg_list => fnd_api.g_false,

179: );
180: END IF;
181:
182: rcv_req_online (p_api_version => 1.0,
183: p_init_msg_list => fnd_api.g_false,
184: p_commit => fnd_api.g_false,
185: p_validation_level => fnd_api.g_valid_level_full,
186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,

Line 184: p_commit => fnd_api.g_false,

180: END IF;
181:
182: rcv_req_online (p_api_version => 1.0,
183: p_init_msg_list => fnd_api.g_false,
184: p_commit => fnd_api.g_false,
185: p_validation_level => fnd_api.g_valid_level_full,
186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,
188: x_msg_data => x_msg_data,

Line 185: p_validation_level => fnd_api.g_valid_level_full,

181:
182: rcv_req_online (p_api_version => 1.0,
183: p_init_msg_list => fnd_api.g_false,
184: p_commit => fnd_api.g_false,
185: p_validation_level => fnd_api.g_valid_level_full,
186: x_return_status => x_return_status,
187: x_msg_count => x_msg_count,
188: x_msg_data => x_msg_data,
189: p_request_group_id => l_request_group_id

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

188: x_msg_data => x_msg_data,
189: p_request_group_id => l_request_group_id
190: );
191:
192: IF (x_return_status <> fnd_api.g_ret_sts_success)
193: THEN
194: RAISE fnd_api.g_exc_error;
195: END IF;
196:

Line 194: RAISE fnd_api.g_exc_error;

190: );
191:
192: IF (x_return_status <> fnd_api.g_ret_sts_success)
193: THEN
194: RAISE fnd_api.g_exc_error;
195: END IF;
196:
197: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
198: THEN

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

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

Line 215: RAISE fnd_api.g_exc_error;

211: );
212:
213: IF (x_return_status <> fnd_api.g_ret_sts_success)
214: THEN
215: RAISE fnd_api.g_exc_error;
216: END IF;
217:
218:
219: -- Delete the interface table records created.

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

223: x_return_status => x_return_status,
224: p_request_group_id => l_request_group_id
225: );
226: l_request_group_id := null;
227: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: *****************/
231:

Line 228: RAISE FND_API.G_EXC_ERROR;

224: p_request_group_id => l_request_group_id
225: );
226: l_request_group_id := null;
227: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
228: RAISE FND_API.G_EXC_ERROR;
229: END IF;
230: *****************/
231:
232:

Line 246: IF (p_commit = fnd_api.g_true)

242: );
243: END IF;
244:
245: --Commit the changes.
246: IF (p_commit = fnd_api.g_true)
247: THEN
248: COMMIT;
249: END IF;
250:

Line 252: WHEN fnd_api.g_exc_error

248: COMMIT;
249: END IF;
250:
251: EXCEPTION
252: WHEN fnd_api.g_exc_error
253: THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: ROLLBACK TO sp_receive_item;
256: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 254: x_return_status := fnd_api.g_ret_sts_error;

250:
251: EXCEPTION
252: WHEN fnd_api.g_exc_error
253: THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: ROLLBACK TO sp_receive_item;
256: fnd_msg_pub.count_and_get (p_count => x_msg_count,
257: p_data => x_msg_data);
258:

Line 275: WHEN fnd_api.g_exc_unexpected_error

271: 'CSD.PLSQL.CSD_RECEIVE_PVT.RECEIVE_ITEM',
272: 'EXC_ERROR in Receive_Item[' || x_msg_data || ']'
273: );
274: END IF;
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: x_return_status := fnd_api.g_ret_sts_unexp_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_unexp_error;

273: );
274: END IF;
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: x_return_status := fnd_api.g_ret_sts_unexp_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 291: x_return_status := fnd_api.g_ret_sts_unexp_error;

287: );
288: END IF;
289: WHEN OTHERS
290: THEN
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: ROLLBACK TO sp_receive_item;
293:
294: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
295: THEN

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

312: /* procedure name: POPULATE_INTF_TBLS */
313: /* description : Inserts records into open interface tables for receiving. */
314: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
315: /* Input Parm : p_api_version NUMBER Required Api Version number */
316: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
317: /* default value is fnd_api.g_false */
318: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
319: /* fnd_api.g_false */
320: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

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

313: /* description : Inserts records into open interface tables for receiving. */
314: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
315: /* Input Parm : p_api_version NUMBER Required Api Version number */
316: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
317: /* default value is fnd_api.g_false */
318: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
319: /* fnd_api.g_false */
320: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
321: /* validation steps must be done and which steps */

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

314: /* Called from : CSD_RCV_PVT.RECEIVE_ITEM api */
315: /* Input Parm : p_api_version NUMBER Required Api Version number */
316: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
317: /* default value is fnd_api.g_false */
318: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
319: /* fnd_api.g_false */
320: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
321: /* validation steps must be done and which steps */
322: /* should be skipped. */

Line 319: /* fnd_api.g_false */

315: /* Input Parm : p_api_version NUMBER Required Api Version number */
316: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
317: /* default value is fnd_api.g_false */
318: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
319: /* fnd_api.g_false */
320: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
321: /* validation steps must be done and which steps */
322: /* should be skipped. */
323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */

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

321: /* validation steps must be done and which steps */
322: /* should be skipped. */
323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
324: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
325: /* fnd_api.g_ret_sts_success (success) */
326: /* fnd_api.g_ret_sts_error (error) */
327: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
328: /* x_msg_count NUMBER Number of messages in the message stack */
329: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

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

322: /* should be skipped. */
323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
324: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
325: /* fnd_api.g_ret_sts_success (success) */
326: /* fnd_api.g_ret_sts_error (error) */
327: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
328: /* x_msg_count NUMBER Number of messages in the message stack */
329: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
330: /* x_request_group_id NUMBER Required */

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

323: /* p_receive_rec CSD_RECEIVE_UTIL.RCV_REC_TYPE Required */
324: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
325: /* fnd_api.g_ret_sts_success (success) */
326: /* fnd_api.g_ret_sts_error (error) */
327: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
328: /* x_msg_count NUMBER Number of messages in the message stack */
329: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
330: /* x_request_group_id NUMBER Required */
331: /*-----------------------------------------------------------------------------------------------------------*/

Line 388: IF fnd_api.to_boolean (p_init_msg_list)

384: END IF;
385:
386: l_source_code := 'CSD';
387:
388: IF fnd_api.to_boolean (p_init_msg_list)
389: THEN
390: -- initialize message list
391: fnd_msg_pub.initialize;
392: END IF;

Line 395: IF NOT fnd_api.compatible_api_call (l_api_version_number,

391: fnd_msg_pub.initialize;
392: END IF;
393:
394: -- Standard call to check for call compatibility.
395: IF NOT fnd_api.compatible_api_call (l_api_version_number,
396: p_api_version,
397: l_api_name,
398: g_pkg_name
399: )

Line 401: RAISE fnd_api.g_exc_unexpected_error;

397: l_api_name,
398: g_pkg_name
399: )
400: THEN
401: RAISE fnd_api.g_exc_unexpected_error;
402: END IF;
403:
404: -- initialize return status
405: x_return_status := fnd_api.g_ret_sts_success;

Line 405: x_return_status := fnd_api.g_ret_sts_success;

401: RAISE fnd_api.g_exc_unexpected_error;
402: END IF;
403:
404: -- initialize return status
405: x_return_status := fnd_api.g_ret_sts_success;
406:
407: ---Program logic.......
408: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
409: THEN

Line 848: WHEN fnd_api.g_exc_error

844: COMMIT;
845:
846:
847: EXCEPTION
848: WHEN fnd_api.g_exc_error
849: THEN
850: x_return_status := fnd_api.g_ret_sts_error;
851: ROLLBACK ;
852: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 850: x_return_status := fnd_api.g_ret_sts_error;

846:
847: EXCEPTION
848: WHEN fnd_api.g_exc_error
849: THEN
850: x_return_status := fnd_api.g_ret_sts_error;
851: ROLLBACK ;
852: fnd_msg_pub.count_and_get (p_count => x_msg_count,
853: p_data => x_msg_data);
854:

Line 863: WHEN fnd_api.g_exc_unexpected_error

859: 'CSD.PLSQL.CSD_RECEIVE_PVT.POPULATE_RCV_INTF_TBLS',
860: 'EXC_EXC_ERROR in populate rcv intf tbls [' || x_msg_data || ']'
861: );
862: END IF;
863: WHEN fnd_api.g_exc_unexpected_error
864: THEN
865: x_return_status := fnd_api.g_ret_sts_unexp_error;
866: ROLLBACK ;
867: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 865: x_return_status := fnd_api.g_ret_sts_unexp_error;

861: );
862: END IF;
863: WHEN fnd_api.g_exc_unexpected_error
864: THEN
865: x_return_status := fnd_api.g_ret_sts_unexp_error;
866: ROLLBACK ;
867: fnd_msg_pub.count_and_get (p_count => x_msg_count,
868: p_data => x_msg_data);
869:

Line 880: x_return_status := fnd_api.g_ret_sts_unexp_error;

876: );
877: END IF;
878: WHEN OTHERS
879: THEN
880: x_return_status := fnd_api.g_ret_sts_unexp_error;
881: ROLLBACK ;
882:
883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
884: THEN

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

903: /* procedure name: RCV_REQ_ONLINE */
904: /* description : This API will submit the request for receiving in the online mode. */
905: /* Called from : */
906: /* Input Parm : p_api_version NUMBER Required Api Version number */
907: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
908: /* default value is fnd_api.g_false */
909: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
910: /* fnd_api.g_false */
911: /* p_validation_level NUMBER Optional API uses this parameter to determine which */

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

904: /* description : This API will submit the request for receiving in the online mode. */
905: /* Called from : */
906: /* Input Parm : p_api_version NUMBER Required Api Version number */
907: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
908: /* default value is fnd_api.g_false */
909: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
910: /* fnd_api.g_false */
911: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
912: /* validation steps must be done and which steps */

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

905: /* Called from : */
906: /* Input Parm : p_api_version NUMBER Required Api Version number */
907: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
908: /* default value is fnd_api.g_false */
909: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
910: /* fnd_api.g_false */
911: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
912: /* validation steps must be done and which steps */
913: /* should be skipped. */

Line 910: /* fnd_api.g_false */

906: /* Input Parm : p_api_version NUMBER Required Api Version number */
907: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
908: /* default value is fnd_api.g_false */
909: /* p_commit VARCHAR2 Optional Commits in API if fnd_api.g_true, default */
910: /* fnd_api.g_false */
911: /* p_validation_level NUMBER Optional API uses this parameter to determine which */
912: /* validation steps must be done and which steps */
913: /* should be skipped. */
914: /* p_request_group_id NUMBER Required The request group for which the receiving */

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

913: /* should be skipped. */
914: /* p_request_group_id NUMBER Required The request group for which the receiving */
915: /* processor
916: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
917: /* fnd_api.g_ret_sts_success (success) */
918: /* fnd_api.g_ret_sts_error (error) */
919: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
920: /* x_msg_count NUMBER Number of messages in the message stack */
921: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

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

914: /* p_request_group_id NUMBER Required The request group for which the receiving */
915: /* processor
916: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
917: /* fnd_api.g_ret_sts_success (success) */
918: /* fnd_api.g_ret_sts_error (error) */
919: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
920: /* x_msg_count NUMBER Number of messages in the message stack */
921: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
922: /*-----------------------------------------------------------------------------------------------------------*/

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

915: /* processor
916: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
917: /* fnd_api.g_ret_sts_success (success) */
918: /* fnd_api.g_ret_sts_error (error) */
919: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
920: /* x_msg_count NUMBER Number of messages in the message stack */
921: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
922: /*-----------------------------------------------------------------------------------------------------------*/
923: PROCEDURE rcv_req_online (

Line 990: IF fnd_api.to_boolean (p_init_msg_list)

986:
987: -- Standard Start of API savepoint
988: SAVEPOINT sp_rcv_req_online;
989:
990: IF fnd_api.to_boolean (p_init_msg_list)
991: THEN
992: -- initialize message list
993: fnd_msg_pub.initialize;
994: END IF;

Line 997: IF NOT fnd_api.compatible_api_call (l_api_version_number,

993: fnd_msg_pub.initialize;
994: END IF;
995:
996: -- Standard call to check for call compatibility.
997: IF NOT fnd_api.compatible_api_call (l_api_version_number,
998: p_api_version,
999: l_api_name,
1000: g_pkg_name
1001: )

Line 1003: RAISE fnd_api.g_exc_unexpected_error;

999: l_api_name,
1000: g_pkg_name
1001: )
1002: THEN
1003: RAISE fnd_api.g_exc_unexpected_error;
1004: END IF;
1005:
1006: -- initialize return status
1007: x_return_status := fnd_api.g_ret_sts_success;

Line 1007: x_return_status := fnd_api.g_ret_sts_success;

1003: RAISE fnd_api.g_exc_unexpected_error;
1004: END IF;
1005:
1006: -- initialize return status
1007: x_return_status := fnd_api.g_ret_sts_success;
1008:
1009: /*
1010: ** Set the cursor style to working
1011: */

Line 1068: --RAISE FND_API.G_EXC_ERROR;

1064: END LOOP;
1065: END IF;
1066: --FND_MESSAGE.SET_NAME('CSD', 'CSD_RECEIVE_ERROR');
1067: --FND_MSG_PUB.ADD;
1068: --RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070:
1071: -- dbms_output.put_line('outcome=[-'||outcome||'-]');
1072: -- dbms_output.put_line('message=[-'||message||'-]');

Line 1108: x_return_status := fnd_api.g_ret_sts_error;

1104: fnd_message.set_token ('REQUEST', p_request_group_id);
1105: fnd_message.set_token ('REASON', l_str1);
1106: --fnd_message.show;
1107: fnd_msg_pub.ADD;
1108: x_return_status := fnd_api.g_ret_sts_error;
1109: END IF;
1110: ELSIF (l_Ret_code = 2)
1111: THEN
1112: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1153: x_return_status := fnd_api.g_ret_sts_error;

1149: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE');
1150: END IF;
1151:
1152: fnd_msg_pub.ADD;
1153: x_return_status := fnd_api.g_ret_sts_error;
1154: END IF;
1155: ELSIF (l_ret_code = 3 OR (l_outcome IN ('WARNING', 'ERROR')))
1156: THEN
1157: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)

Line 1305: x_return_status := fnd_api.g_ret_sts_error;

1301: 'fnd_trnasaction.synchronous:[' || l_str1 || ']'
1302: );
1303: END IF;
1304:
1305: x_return_status := fnd_api.g_ret_sts_error;
1306: --END IF;
1307: END IF;
1308:
1309: -- Standard call to get message count and IF count is get message info.

Line 1321: WHEN fnd_api.g_exc_error

1317: 'Leaving RCV_REQ_ONLINE'
1318: );
1319: END IF;
1320: EXCEPTION
1321: WHEN fnd_api.g_exc_error
1322: THEN
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: ROLLBACK TO sp_rcv_req_online;
1325: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1323: x_return_status := fnd_api.g_ret_sts_error;

1319: END IF;
1320: EXCEPTION
1321: WHEN fnd_api.g_exc_error
1322: THEN
1323: x_return_status := fnd_api.g_ret_sts_error;
1324: ROLLBACK TO sp_rcv_req_online;
1325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1326: p_data => x_msg_data);
1327:

Line 1335: WHEN fnd_api.g_exc_unexpected_error

1331: 'CSD.PLSQL.CSD_RECEIVE_PVT.RCV_REQ_ONLINE',
1332: 'EXC_ERROR[' || x_msg_data || ']'
1333: );
1334: END IF;
1335: WHEN fnd_api.g_exc_unexpected_error
1336: THEN
1337: x_return_status := fnd_api.g_ret_sts_unexp_error;
1338: ROLLBACK TO sp_rcv_req_online;
1339: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1337: x_return_status := fnd_api.g_ret_sts_unexp_error;

1333: );
1334: END IF;
1335: WHEN fnd_api.g_exc_unexpected_error
1336: THEN
1337: x_return_status := fnd_api.g_ret_sts_unexp_error;
1338: ROLLBACK TO sp_rcv_req_online;
1339: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1340: p_data => x_msg_data);
1341:

Line 1351: x_return_status := fnd_api.g_ret_sts_unexp_error;

1347: );
1348: END IF;
1349: WHEN OTHERS
1350: THEN
1351: x_return_status := fnd_api.g_ret_sts_unexp_error;
1352: ROLLBACK TO sp_rcv_req_online;
1353:
1354: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1355: THEN

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

1377: /* p_request_group_id NUMBER Required */
1378: /* p_interface_transaction_Id NUMBER Required */
1379: /* p_interface_header_Id NUMBER Required */
1380: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1381: /* fnd_api.g_ret_sts_success (success) */
1382: /* fnd_api.g_ret_sts_error (error) */
1383: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1384: /*-----------------------------------------------------------------------------------------------------------*/
1385: PROCEDURE delete_intf_tbls (

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

1378: /* p_interface_transaction_Id NUMBER Required */
1379: /* p_interface_header_Id NUMBER Required */
1380: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1381: /* fnd_api.g_ret_sts_success (success) */
1382: /* fnd_api.g_ret_sts_error (error) */
1383: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1384: /*-----------------------------------------------------------------------------------------------------------*/
1385: PROCEDURE delete_intf_tbls (
1386: x_return_status OUT NOCOPY VARCHAR2,

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

1379: /* p_interface_header_Id NUMBER Required */
1380: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
1381: /* fnd_api.g_ret_sts_success (success) */
1382: /* fnd_api.g_ret_sts_error (error) */
1383: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1384: /*-----------------------------------------------------------------------------------------------------------*/
1385: PROCEDURE delete_intf_tbls (
1386: x_return_status OUT NOCOPY VARCHAR2,
1387: p_request_group_id IN NUMBER

Line 1416: x_return_status := fnd_api.g_ret_sts_success;

1412: );
1413: END IF;
1414:
1415: -- initialize return status
1416: x_return_status := fnd_api.g_ret_sts_success;
1417:
1418:
1419: -----------------------------------------------Delete from errors table
1420: FOR l_hdr_rec in cur_headers(p_request_group_id) LOOP

Line 1431: RAISE fnd_api.g_exc_unexpected_error;

1427: THEN
1428: NULL;
1429: WHEN OTHERS
1430: THEN
1431: RAISE fnd_api.g_exc_unexpected_error;
1432: END;
1433: END LOOP;
1434:
1435: FOR l_txn_rec in cur_transactions(p_request_group_id) LOOP

Line 1446: RAISE fnd_api.g_exc_unexpected_error;

1442: THEN
1443: NULL;
1444: WHEN OTHERS
1445: THEN
1446: RAISE fnd_api.g_exc_unexpected_error;
1447: END;
1448: END LOOP;
1449:
1450: ----------------------------------------------Delete from the MTL lots/MTL serial numbers

Line 1467: RAISE fnd_api.g_exc_unexpected_error;

1463: THEN
1464: NULL;
1465: WHEN OTHERS
1466: THEN
1467: RAISE fnd_api.g_exc_unexpected_error;
1468: END;
1469: END LOOP;
1470:
1471: ----------------------------------------------Delete from headers table.

Line 1489: RAISE fnd_api.g_exc_unexpected_error;

1485: THEN
1486: NULL;
1487: WHEN OTHERS
1488: THEN
1489: RAISE fnd_api.g_exc_unexpected_error;
1490: END;
1491: ----------------------------------------------Delete from the detail txn records.
1492: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
1493: THEN

Line 1509: RAISE fnd_api.g_exc_unexpected_error;

1505: THEN
1506: NULL;
1507: WHEN OTHERS
1508: THEN
1509: RAISE fnd_api.g_exc_unexpected_error;
1510: END;
1511:
1512:
1513: COMMIT;

Line 1523: WHEN fnd_api.g_exc_unexpected_error

1519: 'Leaving DELETE_INTF_TBLS'
1520: );
1521: END IF;
1522: EXCEPTION
1523: WHEN fnd_api.g_exc_unexpected_error
1524: THEN
1525: x_return_status := fnd_api.g_ret_sts_unexp_error;
1526: ROLLBACK ;
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)

Line 1525: x_return_status := fnd_api.g_ret_sts_unexp_error;

1521: END IF;
1522: EXCEPTION
1523: WHEN fnd_api.g_exc_unexpected_error
1524: THEN
1525: x_return_status := fnd_api.g_ret_sts_unexp_error;
1526: ROLLBACK ;
1527: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)
1528: THEN
1529: fnd_log.STRING (fnd_log.level_exception,

Line 1536: x_return_status := fnd_api.g_ret_sts_unexp_error;

1532: );
1533: END IF;
1534: WHEN OTHERS
1535: THEN
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537: ROLLBACK;
1538:
1539: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1540: THEN