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

Line 104: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

100: --
101: -- ARGUMENTS
102: -- IN:
103: -- p_init_msg_list Initialize message stack if it is set to
104: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
105: -- p_orig_sys_refs List of original system reference objects.
106: -- p_created_by_module Created by module.
107: -- OUT:
108: -- x_return_status Return status after the call. The status can

Line 109: -- be fnd_api.g_ret_sts_success (success),

105: -- p_orig_sys_refs List of original system reference objects.
106: -- p_created_by_module Created by module.
107: -- OUT:
108: -- x_return_status Return status after the call. The status can
109: -- be fnd_api.g_ret_sts_success (success),
110: -- fnd_api.g_ret_sts_error (error),
111: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
112: -- x_msg_count Number of messages in message stack.
113: -- x_msg_data Message text if x_msg_count is 1.

Line 110: -- fnd_api.g_ret_sts_error (error),

106: -- p_created_by_module Created by module.
107: -- OUT:
108: -- x_return_status Return status after the call. The status can
109: -- be fnd_api.g_ret_sts_success (success),
110: -- fnd_api.g_ret_sts_error (error),
111: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
112: -- x_msg_count Number of messages in message stack.
113: -- x_msg_data Message text if x_msg_count is 1.
114: --

Line 111: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

107: -- OUT:
108: -- x_return_status Return status after the call. The status can
109: -- be fnd_api.g_ret_sts_success (success),
110: -- fnd_api.g_ret_sts_error (error),
111: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
112: -- x_msg_count Number of messages in message stack.
113: -- x_msg_data Message text if x_msg_count is 1.
114: --
115: -- NOTES

Line 123: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

119: -- 14-DEC-2004 Arnold Ng Created.
120: --
121:
122: PROCEDURE create_orig_sys_refs_bo(
123: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
124: p_orig_sys_refs IN HZ_ORIG_SYS_REF_OBJ_TBL,
125: p_created_by_module IN VARCHAR2,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: -- Standard start of API savepoint
135: SAVEPOINT create_osr_bo_pub;
136:
137: -- initialize API return status to success.
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.to_Boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;

Line 141: IF FND_API.to_Boolean(p_init_msg_list) THEN

137: -- initialize API return status to success.
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE
141: IF FND_API.to_Boolean(p_init_msg_list) THEN
142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: IF(p_created_by_module IS NULL) THEN

Line 163: RAISE FND_API.G_EXC_ERROR;

159: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
160: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
161: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
162: FND_MSG_PUB.ADD();
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
167: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');

Line 170: RAISE FND_API.G_EXC_ERROR;

166: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
167: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
168: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
169: FND_MSG_PUB.ADD();
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
174: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');

Line 177: RAISE FND_API.G_EXC_ERROR;

173: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
174: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
175: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
176: FND_MSG_PUB.ADD();
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: IF(p_orig_sys_refs(i).orig_system_ref_id IS NOT NULL) THEN
181: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');

Line 183: RAISE FND_API.G_EXC_ERROR;

179:
180: IF(p_orig_sys_refs(i).orig_system_ref_id IS NOT NULL) THEN
181: FND_MESSAGE.SET_NAME('AR','HZ_API_CANNOT_PASS_PK');
182: FND_MSG_PUB.ADD();
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: assign_orig_sys_ref(
187: p_orig_sys_obj => p_orig_sys_refs(i),

Line 198: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,
196: x_msg_data => x_msg_data
197: );
198: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: END LOOP;
202: -- Debug info.

Line 199: RAISE FND_API.G_EXC_ERROR;

195: x_msg_count => x_msg_count,
196: x_msg_data => x_msg_data
197: );
198: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: END LOOP;
202: -- Debug info.
203: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 215: WHEN fnd_api.g_exc_error THEN

211: p_prefix=>l_debug_prefix,
212: p_msg_level=>fnd_log.level_procedure);
213: END IF;
214: EXCEPTION
215: WHEN fnd_api.g_exc_error THEN
216: ROLLBACK TO create_osr_bo_pub;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 217: x_return_status := fnd_api.g_ret_sts_error;

213: END IF;
214: EXCEPTION
215: WHEN fnd_api.g_exc_error THEN
216: ROLLBACK TO create_osr_bo_pub;
217: x_return_status := fnd_api.g_ret_sts_error;
218:
219: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
220: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
221: FND_MSG_PUB.ADD;

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

218:
219: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
220: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
221: FND_MSG_PUB.ADD;
222: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
223: p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: -- Debug info.

Line 239: WHEN fnd_api.g_exc_unexpected_error THEN

235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238:
239: WHEN fnd_api.g_exc_unexpected_error THEN
240: ROLLBACK TO create_osr_bo_pub;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242:
243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 241: x_return_status := fnd_api.g_ret_sts_unexp_error;

237: END IF;
238:
239: WHEN fnd_api.g_exc_unexpected_error THEN
240: ROLLBACK TO create_osr_bo_pub;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242:
243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
244: p_count => x_msg_count,
245: p_data => x_msg_data);

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

239: WHEN fnd_api.g_exc_unexpected_error THEN
240: ROLLBACK TO create_osr_bo_pub;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242:
243: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:
247: -- Debug info.

Line 261: x_return_status := fnd_api.g_ret_sts_unexp_error;

257: p_msg_level=>fnd_log.level_procedure);
258: END IF;
259: WHEN OTHERS THEN
260: ROLLBACK TO create_osr_bo_pub;
261: x_return_status := fnd_api.g_ret_sts_unexp_error;
262:
263: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
264: fnd_message.set_token('ERROR' ,SQLERRM);
265: fnd_msg_pub.add;

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

263: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
264: fnd_message.set_token('ERROR' ,SQLERRM);
265: fnd_msg_pub.add;
266:
267: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
268: p_count => x_msg_count,
269: p_data => x_msg_data);
270:
271: -- Debug info.

Line 295: p_init_msg_list => fnd_api.g_true,

291: ) IS
292: l_msg_data VARCHAR2(2000);
293: BEGIN
294: create_orig_sys_refs_bo(
295: p_init_msg_list => fnd_api.g_true,
296: p_orig_sys_refs => p_orig_sys_refs,
297: p_created_by_module => p_created_by_module,
298: x_return_status => x_return_status,
299: x_msg_count => x_msg_count,

Line 318: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

314: --
315: -- ARGUMENTS
316: -- IN:
317: -- p_init_msg_list Initialize message stack if it is set to
318: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
319: -- p_orig_sys_refs List of original system reference objects.
320: -- OUT:
321: -- x_return_status Return status after the call. The status can
322: -- be fnd_api.g_ret_sts_success (success),

Line 322: -- be fnd_api.g_ret_sts_success (success),

318: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
319: -- p_orig_sys_refs List of original system reference objects.
320: -- OUT:
321: -- x_return_status Return status after the call. The status can
322: -- be fnd_api.g_ret_sts_success (success),
323: -- fnd_api.g_ret_sts_error (error),
324: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
325: -- x_msg_count Number of messages in message stack.
326: -- x_msg_data Message text if x_msg_count is 1.

Line 323: -- fnd_api.g_ret_sts_error (error),

319: -- p_orig_sys_refs List of original system reference objects.
320: -- OUT:
321: -- x_return_status Return status after the call. The status can
322: -- be fnd_api.g_ret_sts_success (success),
323: -- fnd_api.g_ret_sts_error (error),
324: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
325: -- x_msg_count Number of messages in message stack.
326: -- x_msg_data Message text if x_msg_count is 1.
327: --

Line 324: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

320: -- OUT:
321: -- x_return_status Return status after the call. The status can
322: -- be fnd_api.g_ret_sts_success (success),
323: -- fnd_api.g_ret_sts_error (error),
324: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
325: -- x_msg_count Number of messages in message stack.
326: -- x_msg_data Message text if x_msg_count is 1.
327: --
328: -- NOTES

Line 336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

332: -- 14-DEC-2004 Arnold Ng Created.
333: --
334:
335: PROCEDURE update_orig_sys_refs_bo(
336: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
337: p_orig_sys_refs IN HZ_ORIG_SYS_REF_OBJ_TBL,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: -- Standard start of API savepoint
348: SAVEPOINT update_osr_bo_pub;
349:
350: -- initialize API return status to success.
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE
354: IF FND_API.to_Boolean(p_init_msg_list) THEN
355: FND_MSG_PUB.initialize;

Line 354: IF FND_API.to_Boolean(p_init_msg_list) THEN

350: -- initialize API return status to success.
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE
354: IF FND_API.to_Boolean(p_init_msg_list) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug info.

Line 370: RAISE FND_API.G_EXC_ERROR;

366: IF(p_orig_sys_refs(i).object_id IS NULL) THEN
367: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
368: FND_MESSAGE.SET_TOKEN('PARAMETER', 'object_id');
369: FND_MSG_PUB.ADD();
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
374: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');

Line 377: RAISE FND_API.G_EXC_ERROR;

373: IF(p_orig_sys_refs(i).orig_system IS NULL) THEN
374: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
375: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system');
376: FND_MSG_PUB.ADD();
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379:
380: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
381: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');

Line 384: RAISE FND_API.G_EXC_ERROR;

380: IF(p_orig_sys_refs(i).orig_system_reference IS NULL) THEN
381: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
382: FND_MESSAGE.SET_TOKEN('PARAMETER', 'orig_system_reference');
383: FND_MSG_PUB.ADD();
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: IF(p_orig_sys_refs(i).old_orig_system_reference IS NULL) THEN
388: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');

Line 391: RAISE FND_API.G_EXC_ERROR;

387: IF(p_orig_sys_refs(i).old_orig_system_reference IS NULL) THEN
388: FND_MESSAGE.SET_NAME('AR','HZ_API_NULL_PARAM');
389: FND_MESSAGE.SET_TOKEN('PARAMETER', 'old_orig_system_reference');
390: FND_MSG_PUB.ADD();
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:
394: assign_orig_sys_ref(
395: p_orig_sys_obj => p_orig_sys_refs(i),

Line 407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

403: x_return_status => x_return_status,
404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data
406: );
407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410: END LOOP;
411:

Line 408: RAISE FND_API.G_EXC_ERROR;

404: x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data
406: );
407: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410: END LOOP;
411:
412: -- Debug info.

Line 425: WHEN fnd_api.g_exc_error THEN

421: p_prefix=>l_debug_prefix,
422: p_msg_level=>fnd_log.level_procedure);
423: END IF;
424: EXCEPTION
425: WHEN fnd_api.g_exc_error THEN
426: ROLLBACK TO update_osr_bo_pub;
427: x_return_status := fnd_api.g_ret_sts_error;
428:
429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 427: x_return_status := fnd_api.g_ret_sts_error;

423: END IF;
424: EXCEPTION
425: WHEN fnd_api.g_exc_error THEN
426: ROLLBACK TO update_osr_bo_pub;
427: x_return_status := fnd_api.g_ret_sts_error;
428:
429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
430: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
431: FND_MSG_PUB.ADD;

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

428:
429: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
430: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
431: FND_MSG_PUB.ADD;
432: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
433: p_count => x_msg_count,
434: p_data => x_msg_data);
435:
436: -- Debug info.

Line 449: WHEN fnd_api.g_exc_unexpected_error THEN

445: p_prefix=>l_debug_prefix,
446: p_msg_level=>fnd_log.level_procedure);
447: END IF;
448:
449: WHEN fnd_api.g_exc_unexpected_error THEN
450: ROLLBACK TO update_osr_bo_pub;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452:
453: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 451: x_return_status := fnd_api.g_ret_sts_unexp_error;

447: END IF;
448:
449: WHEN fnd_api.g_exc_unexpected_error THEN
450: ROLLBACK TO update_osr_bo_pub;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452:
453: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
454: p_count => x_msg_count,
455: p_data => x_msg_data);

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

449: WHEN fnd_api.g_exc_unexpected_error THEN
450: ROLLBACK TO update_osr_bo_pub;
451: x_return_status := fnd_api.g_ret_sts_unexp_error;
452:
453: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
454: p_count => x_msg_count,
455: p_data => x_msg_data);
456:
457: -- Debug info.

Line 471: x_return_status := fnd_api.g_ret_sts_unexp_error;

467: p_msg_level=>fnd_log.level_procedure);
468: END IF;
469: WHEN OTHERS THEN
470: ROLLBACK TO update_osr_bo_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
474: fnd_message.set_token('ERROR' ,SQLERRM);
475: fnd_msg_pub.add;

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

473: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
474: fnd_message.set_token('ERROR' ,SQLERRM);
475: fnd_msg_pub.add;
476:
477: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
478: p_count => x_msg_count,
479: p_data => x_msg_data);
480:
481: -- Debug info.

Line 504: p_init_msg_list => fnd_api.g_true,

500: ) IS
501: l_msg_data VARCHAR2(2000);
502: BEGIN
503: update_orig_sys_refs_bo(
504: p_init_msg_list => fnd_api.g_true,
505: p_orig_sys_refs => p_orig_sys_refs,
506: x_return_status => x_return_status,
507: x_msg_count => x_msg_count,
508: x_msg_data => l_msg_data

Line 526: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.

522: --
523: -- ARGUMENTS
524: -- IN:
525: -- p_init_msg_list Initialize message stack if it is set to
526: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
527: -- p_orig_sys_refs List of original system reference objects.
528: -- OUT:
529: -- x_return_status Return status after the call. The status can
530: -- be fnd_api.g_ret_sts_success (success),

Line 530: -- be fnd_api.g_ret_sts_success (success),

526: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
527: -- p_orig_sys_refs List of original system reference objects.
528: -- OUT:
529: -- x_return_status Return status after the call. The status can
530: -- be fnd_api.g_ret_sts_success (success),
531: -- fnd_api.g_ret_sts_error (error),
532: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
533: -- x_msg_count Number of messages in message stack.
534: -- x_msg_data Message text if x_msg_count is 1.

Line 531: -- fnd_api.g_ret_sts_error (error),

527: -- p_orig_sys_refs List of original system reference objects.
528: -- OUT:
529: -- x_return_status Return status after the call. The status can
530: -- be fnd_api.g_ret_sts_success (success),
531: -- fnd_api.g_ret_sts_error (error),
532: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
533: -- x_msg_count Number of messages in message stack.
534: -- x_msg_data Message text if x_msg_count is 1.
535: --

Line 532: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

528: -- OUT:
529: -- x_return_status Return status after the call. The status can
530: -- be fnd_api.g_ret_sts_success (success),
531: -- fnd_api.g_ret_sts_error (error),
532: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
533: -- x_msg_count Number of messages in message stack.
534: -- x_msg_data Message text if x_msg_count is 1.
535: --
536: -- NOTES

Line 543: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

539: --
540: -- 14-DEC-2004 Arnold Ng Created.
541:
542: PROCEDURE remap_internal_identifiers_bo(
543: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
544: p_orig_sys_refs IN REMAP_ORIG_SYS_REC,
545: x_return_status OUT NOCOPY VARCHAR2,
546: x_msg_count OUT NOCOPY NUMBER,
547: x_msg_data OUT NOCOPY VARCHAR2

Line 556: x_return_status := FND_API.G_RET_STS_SUCCESS;

552: -- Standard start of API savepoint
553: SAVEPOINT remap_osr_bo_pub;
554:
555: -- initialize API return status to success.
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE
559: IF FND_API.to_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;

Line 559: IF FND_API.to_Boolean(p_init_msg_list) THEN

555: -- initialize API return status to success.
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557:
558: -- Initialize message list if p_init_msg_list is set to TRUE
559: IF FND_API.to_Boolean(p_init_msg_list) THEN
560: FND_MSG_PUB.initialize;
561: END IF;
562:
563: -- Debug info.

Line 583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data
582: );
583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586: END LOOP;
587:

Line 584: RAISE FND_API.G_EXC_ERROR;

580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data
582: );
583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586: END LOOP;
587:
588: -- Debug info.

Line 601: WHEN fnd_api.g_exc_error THEN

597: p_prefix=>l_debug_prefix,
598: p_msg_level=>fnd_log.level_procedure);
599: END IF;
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: ROLLBACK TO remap_osr_bo_pub;
603: x_return_status := fnd_api.g_ret_sts_error;
604:
605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

Line 603: x_return_status := fnd_api.g_ret_sts_error;

599: END IF;
600: EXCEPTION
601: WHEN fnd_api.g_exc_error THEN
602: ROLLBACK TO remap_osr_bo_pub;
603: x_return_status := fnd_api.g_ret_sts_error;
604:
605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
606: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
607: FND_MSG_PUB.ADD;

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

604:
605: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
606: FND_MESSAGE.SET_TOKEN('ENTITY', 'ORIG_SYSTEM');
607: FND_MSG_PUB.ADD;
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,
610: p_data => x_msg_data);
611:
612: -- Debug info.

Line 625: WHEN fnd_api.g_exc_unexpected_error THEN

621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624:
625: WHEN fnd_api.g_exc_unexpected_error THEN
626: ROLLBACK TO remap_osr_bo_pub;
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 627: x_return_status := fnd_api.g_ret_sts_unexp_error;

623: END IF;
624:
625: WHEN fnd_api.g_exc_unexpected_error THEN
626: ROLLBACK TO remap_osr_bo_pub;
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
630: p_count => x_msg_count,
631: p_data => x_msg_data);

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

625: WHEN fnd_api.g_exc_unexpected_error THEN
626: ROLLBACK TO remap_osr_bo_pub;
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
630: p_count => x_msg_count,
631: p_data => x_msg_data);
632:
633: -- Debug info.

Line 647: x_return_status := fnd_api.g_ret_sts_unexp_error;

643: p_msg_level=>fnd_log.level_procedure);
644: END IF;
645: WHEN OTHERS THEN
646: ROLLBACK TO remap_osr_bo_pub;
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648:
649: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
650: fnd_message.set_token('ERROR' ,SQLERRM);
651: fnd_msg_pub.add;

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

649: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
650: fnd_message.set_token('ERROR' ,SQLERRM);
651: fnd_msg_pub.add;
652:
653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
654: p_count => x_msg_count,
655: p_data => x_msg_data);
656:
657: -- Debug info.

Line 680: p_init_msg_list => fnd_api.g_true,

676: ) IS
677: l_msg_data VARCHAR2(2000);
678: BEGIN
679: remap_internal_identifiers_bo(
680: p_init_msg_list => fnd_api.g_true,
681: p_orig_sys_refs => p_orig_sys_refs,
682: x_return_status => x_return_status,
683: x_msg_count => x_msg_count,
684: x_msg_data => l_msg_data