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

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

22: -- ARGUMENTS
23: -- IN:
24: -- p_init_msg_list Initialize message stack if it is set to
25: -- p_organization_id Organization ID.
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_org_cust_obj Logical organization customer record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),

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

26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_org_cust_obj Logical organization customer record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.

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

27: -- OUT:
28: -- x_org_cust_obj Logical organization customer record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --

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

28: -- x_org_cust_obj Logical organization customer record.
29: -- x_return_status Return status after the call. The status can
30: -- be fnd_api.g_ret_sts_success (success),
31: -- fnd_api.g_ret_sts_error (error),
32: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
33: -- x_msg_count Number of messages in message stack.
34: -- x_msg_data Message text if x_msg_count is 1.
35: --
36: -- NOTES

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

61:
62:
63:
64: PROCEDURE get_org_cust_bo(
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66: p_organization_id IN NUMBER,
67: p_action_type IN VARCHAR2 := NULL,
68: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
69: x_return_status OUT NOCOPY VARCHAR2,

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: l_debug_prefix VARCHAR2(30) := '';
74:
75: begin
76: -- initialize API return status to success.
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE
80: IF FND_API.to_Boolean(p_init_msg_list) THEN
81: FND_MSG_PUB.initialize;

Line 80: IF FND_API.to_Boolean(p_init_msg_list) THEN

76: -- initialize API return status to success.
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE
80: IF FND_API.to_Boolean(p_init_msg_list) THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84:

Line 95: p_init_msg_list => fnd_api.g_false,

91:
92: x_org_cust_obj := HZ_ORG_CUST_BO(p_action_type, NULL, NULL);
93:
94: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
95: p_init_msg_list => fnd_api.g_false,
96: p_organization_id => p_organization_id,
97: p_action_type => p_action_type,
98: x_organization_obj => x_org_cust_obj.organization_obj,
99: x_return_status => x_return_status,

Line 103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data);
102:
103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107:

Line 104: RAISE FND_API.G_EXC_ERROR;

100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data);
102:
103: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
104: RAISE FND_API.G_EXC_ERROR;
105: END IF;
106:
107:
108: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(

Line 109: p_init_msg_list => fnd_api.g_false,

105: END IF;
106:
107:
108: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
109: p_init_msg_list => fnd_api.g_false,
110: p_parent_id => p_organization_id,
111: p_cust_acct_id => NULL,
112: p_action_type => p_action_type,
113: x_cust_acct_objs => x_org_cust_obj.account_objs,

Line 118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

114: x_return_status => x_return_status,
115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122:

Line 119: RAISE FND_API.G_EXC_ERROR;

115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: RAISE FND_API.G_EXC_ERROR;
120: END IF;
121:
122:
123: -- Debug info.

Line 141: WHEN fnd_api.g_exc_error THEN

137:
138:
139: EXCEPTION
140:
141: WHEN fnd_api.g_exc_error THEN
142: x_return_status := fnd_api.g_ret_sts_error;
143:
144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
145: p_count => x_msg_count,

Line 142: x_return_status := fnd_api.g_ret_sts_error;

138:
139: EXCEPTION
140:
141: WHEN fnd_api.g_exc_error THEN
142: x_return_status := fnd_api.g_ret_sts_error;
143:
144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
145: p_count => x_msg_count,
146: p_data => x_msg_data);

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

140:
141: WHEN fnd_api.g_exc_error THEN
142: x_return_status := fnd_api.g_ret_sts_error;
143:
144: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147:
148: -- Debug info.

Line 160: WHEN fnd_api.g_exc_unexpected_error THEN

156: hz_utility_v2pub.debug(p_message=>'get_org_cust_bo (-)',
157: p_prefix=>l_debug_prefix,
158: p_msg_level=>fnd_log.level_procedure);
159: END IF;
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162:
163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
164: p_count => x_msg_count,

Line 161: x_return_status := fnd_api.g_ret_sts_unexp_error;

157: p_prefix=>l_debug_prefix,
158: p_msg_level=>fnd_log.level_procedure);
159: END IF;
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162:
163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data);

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

159: END IF;
160: WHEN fnd_api.g_exc_unexpected_error THEN
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162:
163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data);
166:
167: -- Debug info.

Line 180: x_return_status := fnd_api.g_ret_sts_unexp_error;

176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178: END IF;
179: WHEN OTHERS THEN
180: x_return_status := fnd_api.g_ret_sts_unexp_error;
181:
182: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
183: fnd_message.set_token('ERROR' ,SQLERRM);
184: fnd_msg_pub.add;

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

182: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
183: fnd_message.set_token('ERROR' ,SQLERRM);
184: fnd_msg_pub.add;
185:
186: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
187: p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: -- Debug info.

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

237: -- ARGUMENTS
238: -- IN:
239: -- p_init_msg_list Initialize message stack if it is set to
240: -- p_event_id BES Event identifier.
241: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
242: -- OUT:
243: -- x_org_cust_objs One or more created logical organization customer.
244: -- x_return_status Return status after the call. The status can
245: -- be fnd_api.g_ret_sts_success (success),

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

241: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
242: -- OUT:
243: -- x_org_cust_objs One or more created logical organization customer.
244: -- x_return_status Return status after the call. The status can
245: -- be fnd_api.g_ret_sts_success (success),
246: -- fnd_api.g_ret_sts_error (error),
247: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
248: -- x_msg_count Number of messages in message stack.
249: -- x_msg_data Message text if x_msg_count is 1.

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

242: -- OUT:
243: -- x_org_cust_objs One or more created logical organization customer.
244: -- x_return_status Return status after the call. The status can
245: -- be fnd_api.g_ret_sts_success (success),
246: -- fnd_api.g_ret_sts_error (error),
247: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
248: -- x_msg_count Number of messages in message stack.
249: -- x_msg_data Message text if x_msg_count is 1.
250: --

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

243: -- x_org_cust_objs One or more created logical organization customer.
244: -- x_return_status Return status after the call. The status can
245: -- be fnd_api.g_ret_sts_success (success),
246: -- fnd_api.g_ret_sts_error (error),
247: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
248: -- x_msg_count Number of messages in message stack.
249: -- x_msg_data Message text if x_msg_count is 1.
250: --
251: -- NOTES

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

271: */
272:
273:
274: PROCEDURE get_org_custs_created(
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_event_id IN NUMBER,
277: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,

Line 291: x_return_status := FND_API.G_RET_STS_SUCCESS;

287:
288: begin
289:
290: -- initialize API return status to success.
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE
294: IF FND_API.to_Boolean(p_init_msg_list) THEN
295: FND_MSG_PUB.initialize;

Line 294: IF FND_API.to_Boolean(p_init_msg_list) THEN

290: -- initialize API return status to success.
291: x_return_status := FND_API.G_RET_STS_SUCCESS;
292:
293: -- Initialize message list if p_init_msg_list is set to TRUE
294: IF FND_API.to_Boolean(p_init_msg_list) THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298:

Line 308: p_init_msg_list => fnd_api.g_false,

304: END IF;
305:
306:
307: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
308: p_init_msg_list => fnd_api.g_false,
309: p_event_id => p_event_id,
310: x_obj_root_ids => l_obj_root_ids,
311: x_return_status => x_return_status,
312: x_msg_count => x_msg_count,

Line 315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

311: x_return_status => x_return_status,
312: x_msg_count => x_msg_count,
313: x_msg_data => x_msg_data);
314:
315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: l_child_operation_flag:= get_org_operation_type(p_event_id);

Line 316: RAISE FND_API.G_EXC_ERROR;

312: x_msg_count => x_msg_count,
313: x_msg_data => x_msg_data);
314:
315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: l_child_operation_flag:= get_org_operation_type(p_event_id);
320:

Line 338: p_init_msg_list => fnd_api.g_false,

334: for i in 1..l_obj_root_ids.count loop
335:
336: x_org_cust_objs.extend;
337: /* get_org_cust_bo(
338: p_init_msg_list => fnd_api.g_false,
339: p_organization_id => l_obj_root_ids(i),
340: p_action_type => 'CREATED',
341: x_org_cust_obj => x_org_cust_objs(i),
342: x_return_status => x_return_status,

Line 346: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

342: x_return_status => x_return_status,
343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data);
345:
346: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349: */
350:

Line 347: RAISE FND_API.G_EXC_ERROR;

343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data);
345:
346: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349: */
350:
351: x_org_cust_objs(i) := HZ_ORG_CUST_BO('UNCHANGED', NULL, NULL);

Line 354: p_init_msg_list => fnd_api.g_false,

350:
351: x_org_cust_objs(i) := HZ_ORG_CUST_BO('UNCHANGED', NULL, NULL);
352:
353: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
354: p_init_msg_list => fnd_api.g_false,
355: p_organization_id => l_obj_root_ids(i),
356: p_action_type => l_action_type,
357: x_organization_obj => x_org_cust_objs(i).organization_obj,
358: x_return_status => x_return_status,

Line 362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

358: x_return_status => x_return_status,
359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data);
361:
362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: if L_CHILD_OPERATION_FLAG = 'U'

Line 363: RAISE FND_API.G_EXC_ERROR;

359: x_msg_count => x_msg_count,
360: x_msg_data => x_msg_data);
361:
362: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: if L_CHILD_OPERATION_FLAG = 'U'
367: then

Line 376: p_init_msg_list => fnd_api.g_false,

372:
373: end if;
374:
375: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
376: p_init_msg_list => fnd_api.g_false,
377: p_parent_id => l_obj_root_ids(i),
378: p_cust_acct_id => NULL,
379: p_action_type => 'CREATED',
380: x_cust_acct_objs => x_org_cust_objs(i).account_objs,

Line 385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

381: x_return_status => x_return_status,
382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data);
384:
385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388: if L_CHILD_OPERATION_FLAG = 'I'
389: then

Line 386: RAISE FND_API.G_EXC_ERROR;

382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data);
384:
385: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388: if L_CHILD_OPERATION_FLAG = 'I'
389: then
390: x_org_cust_objs(i).action_type := 'CREATED';

Line 415: WHEN fnd_api.g_exc_error THEN

411:
412:
413: EXCEPTION
414:
415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417:
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
419: p_count => x_msg_count,

Line 416: x_return_status := fnd_api.g_ret_sts_error;

412:
413: EXCEPTION
414:
415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417:
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
419: p_count => x_msg_count,
420: p_data => x_msg_data);

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

414:
415: WHEN fnd_api.g_exc_error THEN
416: x_return_status := fnd_api.g_ret_sts_error;
417:
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: -- Debug info.

Line 434: WHEN fnd_api.g_exc_unexpected_error THEN

430: hz_utility_v2pub.debug(p_message=>'get_org_cust_created(-)',
431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434: WHEN fnd_api.g_exc_unexpected_error THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
438: p_count => x_msg_count,

Line 435: x_return_status := fnd_api.g_ret_sts_unexp_error;

431: p_prefix=>l_debug_prefix,
432: p_msg_level=>fnd_log.level_procedure);
433: END IF;
434: WHEN fnd_api.g_exc_unexpected_error THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
438: p_count => x_msg_count,
439: p_data => x_msg_data);

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

433: END IF;
434: WHEN fnd_api.g_exc_unexpected_error THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
438: p_count => x_msg_count,
439: p_data => x_msg_data);
440:
441: -- Debug info.

Line 454: x_return_status := fnd_api.g_ret_sts_unexp_error;

450: p_prefix=>l_debug_prefix,
451: p_msg_level=>fnd_log.level_procedure);
452: END IF;
453: WHEN OTHERS THEN
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455:
456: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
457: fnd_message.set_token('ERROR' ,SQLERRM);
458: fnd_msg_pub.add;

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

456: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
457: fnd_message.set_token('ERROR' ,SQLERRM);
458: fnd_msg_pub.add;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.

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

493: -- ARGUMENTS
494: -- IN:
495: -- p_init_msg_list Initialize message stack if it is set to
496: -- p_event_id BES Event identifier.
497: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
498: -- OUT:
499: -- x_org_cust_objs One or more updated logical org customer.
500: -- x_return_status Return status after the call. The status can
501: -- be fnd_api.g_ret_sts_success (success),

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

497: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
498: -- OUT:
499: -- x_org_cust_objs One or more updated logical org customer.
500: -- x_return_status Return status after the call. The status can
501: -- be fnd_api.g_ret_sts_success (success),
502: -- fnd_api.g_ret_sts_error (error),
503: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
504: -- x_msg_count Number of messages in message stack.
505: -- x_msg_data Message text if x_msg_count is 1.

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

498: -- OUT:
499: -- x_org_cust_objs One or more updated logical org customer.
500: -- x_return_status Return status after the call. The status can
501: -- be fnd_api.g_ret_sts_success (success),
502: -- fnd_api.g_ret_sts_error (error),
503: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
504: -- x_msg_count Number of messages in message stack.
505: -- x_msg_data Message text if x_msg_count is 1.
506: --

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

499: -- x_org_cust_objs One or more updated logical org customer.
500: -- x_return_status Return status after the call. The status can
501: -- be fnd_api.g_ret_sts_success (success),
502: -- fnd_api.g_ret_sts_error (error),
503: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
504: -- x_msg_count Number of messages in message stack.
505: -- x_msg_data Message text if x_msg_count is 1.
506: --
507: -- NOTES

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

523: and returns them to the caller.
524: */
525:
526: PROCEDURE get_org_custs_updated(
527: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
528: p_event_id IN NUMBER,
529: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
530: x_return_status OUT NOCOPY VARCHAR2,
531: x_msg_count OUT NOCOPY NUMBER,

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537:
538: begin
539:
540: -- initialize API return status to success.
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE
544: IF FND_API.to_Boolean(p_init_msg_list) THEN
545: FND_MSG_PUB.initialize;

Line 544: IF FND_API.to_Boolean(p_init_msg_list) THEN

540: -- initialize API return status to success.
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543: -- Initialize message list if p_init_msg_list is set to TRUE
544: IF FND_API.to_Boolean(p_init_msg_list) THEN
545: FND_MSG_PUB.initialize;
546: END IF;
547:
548:

Line 558: p_init_msg_list => fnd_api.g_false,

554: END IF;
555:
556:
557: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
558: p_init_msg_list => fnd_api.g_false,
559: p_event_id => p_event_id,
560: x_obj_root_ids => l_obj_root_ids,
561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,

Line 565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

561: x_return_status => x_return_status,
562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data);
564:
565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569:

Line 566: RAISE FND_API.G_EXC_ERROR;

562: x_msg_count => x_msg_count,
563: x_msg_data => x_msg_data);
564:
565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568:
569:
570:

Line 576: p_init_msg_list => fnd_api.g_false,

572:
573: for i in 1..l_obj_root_ids.count loop
574: x_org_cust_objs.extend;
575: get_org_cust_updated(
576: p_init_msg_list => fnd_api.g_false,
577: p_event_id => p_event_id,
578: p_org_cust_id => l_obj_root_ids(i),
579: x_org_cust_obj => x_org_cust_objs(i),
580: x_return_status => x_return_status,

Line 605: WHEN fnd_api.g_exc_error THEN

601:
602:
603: EXCEPTION
604:
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607:
608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
609: p_count => x_msg_count,

Line 606: x_return_status := fnd_api.g_ret_sts_error;

602:
603: EXCEPTION
604:
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607:
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);

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

604:
605: WHEN fnd_api.g_exc_error THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607:
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 624: WHEN fnd_api.g_exc_unexpected_error THEN

620: hz_utility_v2pub.debug(p_message=>'get_org_custs_updated(-)',
621: p_prefix=>l_debug_prefix,
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624: WHEN fnd_api.g_exc_unexpected_error THEN
625: x_return_status := fnd_api.g_ret_sts_unexp_error;
626:
627: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
628: p_count => x_msg_count,

Line 625: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 644: x_return_status := fnd_api.g_ret_sts_unexp_error;

640: p_prefix=>l_debug_prefix,
641: p_msg_level=>fnd_log.level_procedure);
642: END IF;
643: WHEN OTHERS THEN
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645:
646: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
647: fnd_message.set_token('ERROR' ,SQLERRM);
648: fnd_msg_pub.add;

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

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

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: l_creation_date date;
969:
970: begin
971: -- initialize API return status to success.
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: open c2;
975: fetch c2 into l_child_event_id, l_creation_date;
976: close c2;

Line 1035: WHEN fnd_api.g_exc_unexpected_error THEN

1031:
1032: EXCEPTION
1033:
1034:
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: x_return_status := fnd_api.g_ret_sts_unexp_error;
1037:
1038:
1039: WHEN OTHERS THEN

Line 1036: x_return_status := fnd_api.g_ret_sts_unexp_error;

1032: EXCEPTION
1033:
1034:
1035: WHEN fnd_api.g_exc_unexpected_error THEN
1036: x_return_status := fnd_api.g_ret_sts_unexp_error;
1037:
1038:
1039: WHEN OTHERS THEN
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1040: x_return_status := fnd_api.g_ret_sts_unexp_error;

1036: x_return_status := fnd_api.g_ret_sts_unexp_error;
1037:
1038:
1039: WHEN OTHERS THEN
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041:
1042: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1043: fnd_message.set_token('ERROR' ,SQLERRM);
1044: fnd_msg_pub.add;

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

1059: -- IN:
1060: -- p_init_msg_list Initialize message stack if it is set to
1061: -- p_event_id BES Event identifier.
1062: -- p_org_cust_id Organization customer identifier.
1063: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1064: -- OUT:
1065: -- x_org_cust_obj One updated logical organization.
1066: -- x_return_status Return status after the call. The status can
1067: -- be fnd_api.g_ret_sts_success (success),

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

1063: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1064: -- OUT:
1065: -- x_org_cust_obj One updated logical organization.
1066: -- x_return_status Return status after the call. The status can
1067: -- be fnd_api.g_ret_sts_success (success),
1068: -- fnd_api.g_ret_sts_error (error),
1069: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1070: -- x_msg_count Number of messages in message stack.
1071: -- x_msg_data Message text if x_msg_count is 1.

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

1064: -- OUT:
1065: -- x_org_cust_obj One updated logical organization.
1066: -- x_return_status Return status after the call. The status can
1067: -- be fnd_api.g_ret_sts_success (success),
1068: -- fnd_api.g_ret_sts_error (error),
1069: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1070: -- x_msg_count Number of messages in message stack.
1071: -- x_msg_data Message text if x_msg_count is 1.
1072: --

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

1065: -- x_org_cust_obj One updated logical organization.
1066: -- x_return_status Return status after the call. The status can
1067: -- be fnd_api.g_ret_sts_success (success),
1068: -- fnd_api.g_ret_sts_error (error),
1069: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1070: -- x_msg_count Number of messages in message stack.
1071: -- x_msg_data Message text if x_msg_count is 1.
1072: --
1073: -- NOTES

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

1078: --
1079:
1080:
1081: PROCEDURE get_org_cust_updated(
1082: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1083: p_event_id IN NUMBER,
1084: p_org_cust_id IN NUMBER,
1085: x_org_cust_obj OUT NOCOPY HZ_ORG_CUST_BO,
1086: x_return_status OUT NOCOPY VARCHAR2,

Line 1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

1092: l_org_cust_obj HZ_ORG_CUST_BO;
1093: begin
1094:
1095: -- initialize API return status to success.
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- Initialize message list if p_init_msg_list is set to TRUE
1099: IF FND_API.to_Boolean(p_init_msg_list) THEN
1100: FND_MSG_PUB.initialize;

Line 1099: IF FND_API.to_Boolean(p_init_msg_list) THEN

1095: -- initialize API return status to success.
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097:
1098: -- Initialize message list if p_init_msg_list is set to TRUE
1099: IF FND_API.to_Boolean(p_init_msg_list) THEN
1100: FND_MSG_PUB.initialize;
1101: END IF;
1102:
1103:

Line 1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1112: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1113: p_party_id => p_org_cust_id,
1114: x_return_status => x_return_status);
1115:
1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: */
1120: -- Set action type to 'UNCHANGED' by default

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: p_party_id => p_org_cust_id,
1114: x_return_status => x_return_status);
1115:
1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: */
1120: -- Set action type to 'UNCHANGED' by default
1121:

Line 1123: p_init_msg_list => fnd_api.g_false,

1119: */
1120: -- Set action type to 'UNCHANGED' by default
1121:
1122: get_org_cust_bo(
1123: p_init_msg_list => fnd_api.g_false,
1124: p_organization_id => p_org_cust_id,
1125: p_action_type => 'UNCHANGED',
1126: x_org_cust_obj => x_org_cust_obj,
1127: x_return_status => x_return_status,

Line 1162: WHEN fnd_api.g_exc_error THEN

1158:
1159:
1160: EXCEPTION
1161:
1162: WHEN fnd_api.g_exc_error THEN
1163: x_return_status := fnd_api.g_ret_sts_error;
1164:
1165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1166: p_count => x_msg_count,

Line 1163: x_return_status := fnd_api.g_ret_sts_error;

1159:
1160: EXCEPTION
1161:
1162: WHEN fnd_api.g_exc_error THEN
1163: x_return_status := fnd_api.g_ret_sts_error;
1164:
1165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1166: p_count => x_msg_count,
1167: p_data => x_msg_data);

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

1161:
1162: WHEN fnd_api.g_exc_error THEN
1163: x_return_status := fnd_api.g_ret_sts_error;
1164:
1165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1166: p_count => x_msg_count,
1167: p_data => x_msg_data);
1168:
1169: -- Debug info.

Line 1181: WHEN fnd_api.g_exc_unexpected_error THEN

1177: hz_utility_v2pub.debug(p_message=>'get_org_cust_updated(-)',
1178: p_prefix=>l_debug_prefix,
1179: p_msg_level=>fnd_log.level_procedure);
1180: END IF;
1181: WHEN fnd_api.g_exc_unexpected_error THEN
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183:
1184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1185: p_count => x_msg_count,

Line 1182: x_return_status := fnd_api.g_ret_sts_unexp_error;

1178: p_prefix=>l_debug_prefix,
1179: p_msg_level=>fnd_log.level_procedure);
1180: END IF;
1181: WHEN fnd_api.g_exc_unexpected_error THEN
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183:
1184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data);

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

1180: END IF;
1181: WHEN fnd_api.g_exc_unexpected_error THEN
1182: x_return_status := fnd_api.g_ret_sts_unexp_error;
1183:
1184: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data);
1187:
1188: -- Debug info.

Line 1201: x_return_status := fnd_api.g_ret_sts_unexp_error;

1197: p_prefix=>l_debug_prefix,
1198: p_msg_level=>fnd_log.level_procedure);
1199: END IF;
1200: WHEN OTHERS THEN
1201: x_return_status := fnd_api.g_ret_sts_unexp_error;
1202:
1203: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1204: fnd_message.set_token('ERROR' ,SQLERRM);
1205: fnd_msg_pub.add;

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

1203: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1204: fnd_message.set_token('ERROR' ,SQLERRM);
1205: fnd_msg_pub.add;
1206:
1207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data);
1210:
1211: -- Debug info.

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

1235: -- ARGUMENTS
1236: -- IN:
1237: -- p_init_msg_list Initialize message stack if it is set to
1238: -- p_organization_id Organization ID.
1239: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1240: -- OUT:
1241: -- x_org_cust_v2_obj Logical organization customer record.
1242: -- x_return_status Return status after the call. The status can
1243: -- be fnd_api.g_ret_sts_success (success),

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

1239: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1240: -- OUT:
1241: -- x_org_cust_v2_obj Logical organization customer record.
1242: -- x_return_status Return status after the call. The status can
1243: -- be fnd_api.g_ret_sts_success (success),
1244: -- fnd_api.g_ret_sts_error (error),
1245: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1246: -- x_msg_count Number of messages in message stack.
1247: -- x_msg_data Message text if x_msg_count is 1.

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

1240: -- OUT:
1241: -- x_org_cust_v2_obj Logical organization customer record.
1242: -- x_return_status Return status after the call. The status can
1243: -- be fnd_api.g_ret_sts_success (success),
1244: -- fnd_api.g_ret_sts_error (error),
1245: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1246: -- x_msg_count Number of messages in message stack.
1247: -- x_msg_data Message text if x_msg_count is 1.
1248: --

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

1241: -- x_org_cust_v2_obj Logical organization customer record.
1242: -- x_return_status Return status after the call. The status can
1243: -- be fnd_api.g_ret_sts_success (success),
1244: -- fnd_api.g_ret_sts_error (error),
1245: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1246: -- x_msg_count Number of messages in message stack.
1247: -- x_msg_data Message text if x_msg_count is 1.
1248: --
1249: -- NOTES

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

1274:
1275:
1276:
1277: PROCEDURE get_org_cust_v2_bo(
1278: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1279: p_organization_id IN NUMBER,
1280: p_action_type IN VARCHAR2 := NULL,
1281: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
1282: x_return_status OUT NOCOPY VARCHAR2,

Line 1290: x_return_status := FND_API.G_RET_STS_SUCCESS;

1286: l_debug_prefix VARCHAR2(30) := '';
1287:
1288: begin
1289: -- initialize API return status to success.
1290: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;

Line 1293: IF FND_API.to_Boolean(p_init_msg_list) THEN

1289: -- initialize API return status to success.
1290: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE
1293: IF FND_API.to_Boolean(p_init_msg_list) THEN
1294: FND_MSG_PUB.initialize;
1295: END IF;
1296:
1297:

Line 1308: p_init_msg_list => fnd_api.g_false,

1304:
1305: x_org_cust_v2_obj := HZ_ORG_CUST_V2_BO(p_action_type, NULL, NULL);
1306:
1307: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1308: p_init_msg_list => fnd_api.g_false,
1309: p_organization_id => p_organization_id,
1310: p_action_type => p_action_type,
1311: x_organization_obj => x_org_cust_v2_obj.organization_obj,
1312: x_return_status => x_return_status,

Line 1316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1312: x_return_status => x_return_status,
1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315:
1316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320:

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data);
1315:
1316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320:
1321: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(

Line 1322: p_init_msg_list => fnd_api.g_false,

1318: END IF;
1319:
1320:
1321: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(
1322: p_init_msg_list => fnd_api.g_false,
1323: p_parent_id => p_organization_id,
1324: p_cust_acct_id => NULL,
1325: p_action_type => p_action_type,
1326: x_cust_acct_v2_objs => x_org_cust_v2_obj.account_objs,

Line 1331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1327: x_return_status => x_return_status,
1328: x_msg_count => x_msg_count,
1329: x_msg_data => x_msg_data);
1330:
1331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335:

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328: x_msg_count => x_msg_count,
1329: x_msg_data => x_msg_data);
1330:
1331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: END IF;
1334:
1335:
1336: -- Debug info.

Line 1354: WHEN fnd_api.g_exc_error THEN

1350:
1351:
1352: EXCEPTION
1353:
1354: WHEN fnd_api.g_exc_error THEN
1355: x_return_status := fnd_api.g_ret_sts_error;
1356:
1357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1358: p_count => x_msg_count,

Line 1355: x_return_status := fnd_api.g_ret_sts_error;

1351:
1352: EXCEPTION
1353:
1354: WHEN fnd_api.g_exc_error THEN
1355: x_return_status := fnd_api.g_ret_sts_error;
1356:
1357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data);

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

1353:
1354: WHEN fnd_api.g_exc_error THEN
1355: x_return_status := fnd_api.g_ret_sts_error;
1356:
1357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1358: p_count => x_msg_count,
1359: p_data => x_msg_data);
1360:
1361: -- Debug info.

Line 1373: WHEN fnd_api.g_exc_unexpected_error THEN

1369: hz_utility_v2pub.debug(p_message=>'get_org_cust_v2_bo (-)',
1370: p_prefix=>l_debug_prefix,
1371: p_msg_level=>fnd_log.level_procedure);
1372: END IF;
1373: WHEN fnd_api.g_exc_unexpected_error THEN
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375:
1376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1377: p_count => x_msg_count,

Line 1374: x_return_status := fnd_api.g_ret_sts_unexp_error;

1370: p_prefix=>l_debug_prefix,
1371: p_msg_level=>fnd_log.level_procedure);
1372: END IF;
1373: WHEN fnd_api.g_exc_unexpected_error THEN
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375:
1376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);

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

1372: END IF;
1373: WHEN fnd_api.g_exc_unexpected_error THEN
1374: x_return_status := fnd_api.g_ret_sts_unexp_error;
1375:
1376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: -- Debug info.

Line 1393: x_return_status := fnd_api.g_ret_sts_unexp_error;

1389: p_prefix=>l_debug_prefix,
1390: p_msg_level=>fnd_log.level_procedure);
1391: END IF;
1392: WHEN OTHERS THEN
1393: x_return_status := fnd_api.g_ret_sts_unexp_error;
1394:
1395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1396: fnd_message.set_token('ERROR' ,SQLERRM);
1397: fnd_msg_pub.add;

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

1395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1396: fnd_message.set_token('ERROR' ,SQLERRM);
1397: fnd_msg_pub.add;
1398:
1399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1400: p_count => x_msg_count,
1401: p_data => x_msg_data);
1402:
1403: -- Debug info.

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

1430: -- ARGUMENTS
1431: -- IN:
1432: -- p_init_msg_list Initialize message stack if it is set to
1433: -- p_event_id BES Event identifier.
1434: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1435: -- OUT:
1436: -- x_org_cust_v2_objs One or more created logical organization customer.
1437: -- x_return_status Return status after the call. The status can
1438: -- be fnd_api.g_ret_sts_success (success),

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

1434: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1435: -- OUT:
1436: -- x_org_cust_v2_objs One or more created logical organization customer.
1437: -- x_return_status Return status after the call. The status can
1438: -- be fnd_api.g_ret_sts_success (success),
1439: -- fnd_api.g_ret_sts_error (error),
1440: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1441: -- x_msg_count Number of messages in message stack.
1442: -- x_msg_data Message text if x_msg_count is 1.

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

1435: -- OUT:
1436: -- x_org_cust_v2_objs One or more created logical organization customer.
1437: -- x_return_status Return status after the call. The status can
1438: -- be fnd_api.g_ret_sts_success (success),
1439: -- fnd_api.g_ret_sts_error (error),
1440: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1441: -- x_msg_count Number of messages in message stack.
1442: -- x_msg_data Message text if x_msg_count is 1.
1443: --

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

1436: -- x_org_cust_v2_objs One or more created logical organization customer.
1437: -- x_return_status Return status after the call. The status can
1438: -- be fnd_api.g_ret_sts_success (success),
1439: -- fnd_api.g_ret_sts_error (error),
1440: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1441: -- x_msg_count Number of messages in message stack.
1442: -- x_msg_data Message text if x_msg_count is 1.
1443: --
1444: -- NOTES

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

1464: */
1465:
1466:
1467: PROCEDURE get_v2_org_custs_created(
1468: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1469: p_event_id IN NUMBER,
1470: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1471: x_return_status OUT NOCOPY VARCHAR2,
1472: x_msg_count OUT NOCOPY NUMBER,

Line 1484: x_return_status := FND_API.G_RET_STS_SUCCESS;

1480:
1481: begin
1482:
1483: -- initialize API return status to success.
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: IF FND_API.to_Boolean(p_init_msg_list) THEN
1488: FND_MSG_PUB.initialize;

Line 1487: IF FND_API.to_Boolean(p_init_msg_list) THEN

1483: -- initialize API return status to success.
1484: x_return_status := FND_API.G_RET_STS_SUCCESS;
1485:
1486: -- Initialize message list if p_init_msg_list is set to TRUE
1487: IF FND_API.to_Boolean(p_init_msg_list) THEN
1488: FND_MSG_PUB.initialize;
1489: END IF;
1490:
1491:

Line 1501: p_init_msg_list => fnd_api.g_false,

1497: END IF;
1498:
1499:
1500: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1501: p_init_msg_list => fnd_api.g_false,
1502: p_event_id => p_event_id,
1503: x_obj_root_ids => l_obj_root_ids,
1504: x_return_status => x_return_status,
1505: x_msg_count => x_msg_count,

Line 1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1504: x_return_status => x_return_status,
1505: x_msg_count => x_msg_count,
1506: x_msg_data => x_msg_data);
1507:
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512: l_child_operation_flag:= get_org_operation_type(p_event_id);

Line 1509: RAISE FND_API.G_EXC_ERROR;

1505: x_msg_count => x_msg_count,
1506: x_msg_data => x_msg_data);
1507:
1508: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1509: RAISE FND_API.G_EXC_ERROR;
1510: END IF;
1511:
1512: l_child_operation_flag:= get_org_operation_type(p_event_id);
1513:

Line 1534: p_init_msg_list => fnd_api.g_false,

1530:
1531: x_org_cust_v2_objs(i) := HZ_ORG_CUST_V2_BO('UNCHANGED', NULL, NULL);
1532:
1533: HZ_EXTRACT_ORGANIZATION_BO_PVT.get_organization_bo(
1534: p_init_msg_list => fnd_api.g_false,
1535: p_organization_id => l_obj_root_ids(i),
1536: p_action_type => l_action_type,
1537: x_organization_obj => x_org_cust_v2_objs(i).organization_obj,
1538: x_return_status => x_return_status,

Line 1542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1538: x_return_status => x_return_status,
1539: x_msg_count => x_msg_count,
1540: x_msg_data => x_msg_data);
1541:
1542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: if L_CHILD_OPERATION_FLAG = 'U'

Line 1543: RAISE FND_API.G_EXC_ERROR;

1539: x_msg_count => x_msg_count,
1540: x_msg_data => x_msg_data);
1541:
1542: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545:
1546: if L_CHILD_OPERATION_FLAG = 'U'
1547: then

Line 1556: p_init_msg_list => fnd_api.g_false,

1552:
1553: end if;
1554:
1555: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(
1556: p_init_msg_list => fnd_api.g_false,
1557: p_parent_id => l_obj_root_ids(i),
1558: p_cust_acct_id => NULL,
1559: p_action_type => 'CREATED',
1560: x_cust_acct_v2_objs => x_org_cust_v2_objs(i).account_objs,

Line 1565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1561: x_return_status => x_return_status,
1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data);
1564:
1565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568: if L_CHILD_OPERATION_FLAG = 'I'
1569: then

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562: x_msg_count => x_msg_count,
1563: x_msg_data => x_msg_data);
1564:
1565: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568: if L_CHILD_OPERATION_FLAG = 'I'
1569: then
1570: x_org_cust_v2_objs(i).action_type := 'CREATED';

Line 1595: WHEN fnd_api.g_exc_error THEN

1591:
1592:
1593: EXCEPTION
1594:
1595: WHEN fnd_api.g_exc_error THEN
1596: x_return_status := fnd_api.g_ret_sts_error;
1597:
1598: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1599: p_count => x_msg_count,

Line 1596: x_return_status := fnd_api.g_ret_sts_error;

1592:
1593: EXCEPTION
1594:
1595: WHEN fnd_api.g_exc_error THEN
1596: x_return_status := fnd_api.g_ret_sts_error;
1597:
1598: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data);

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

1594:
1595: WHEN fnd_api.g_exc_error THEN
1596: x_return_status := fnd_api.g_ret_sts_error;
1597:
1598: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data);
1601:
1602: -- Debug info.

Line 1614: WHEN fnd_api.g_exc_unexpected_error THEN

1610: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_created(-)',
1611: p_prefix=>l_debug_prefix,
1612: p_msg_level=>fnd_log.level_procedure);
1613: END IF;
1614: WHEN fnd_api.g_exc_unexpected_error THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616:
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1618: p_count => x_msg_count,

Line 1615: x_return_status := fnd_api.g_ret_sts_unexp_error;

1611: p_prefix=>l_debug_prefix,
1612: p_msg_level=>fnd_log.level_procedure);
1613: END IF;
1614: WHEN fnd_api.g_exc_unexpected_error THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616:
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);

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

1613: END IF;
1614: WHEN fnd_api.g_exc_unexpected_error THEN
1615: x_return_status := fnd_api.g_ret_sts_unexp_error;
1616:
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: -- Debug info.

Line 1634: x_return_status := fnd_api.g_ret_sts_unexp_error;

1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633: WHEN OTHERS THEN
1634: x_return_status := fnd_api.g_ret_sts_unexp_error;
1635:
1636: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1637: fnd_message.set_token('ERROR' ,SQLERRM);
1638: fnd_msg_pub.add;

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

1636: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1637: fnd_message.set_token('ERROR' ,SQLERRM);
1638: fnd_msg_pub.add;
1639:
1640: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1641: p_count => x_msg_count,
1642: p_data => x_msg_data);
1643:
1644: -- Debug info.

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

1673: -- ARGUMENTS
1674: -- IN:
1675: -- p_init_msg_list Initialize message stack if it is set to
1676: -- p_event_id BES Event identifier.
1677: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1678: -- OUT:
1679: -- x_org_cust_v2_objs One or more updated logical org customer.
1680: -- x_return_status Return status after the call. The status can
1681: -- be fnd_api.g_ret_sts_success (success),

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

1677: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1678: -- OUT:
1679: -- x_org_cust_v2_objs One or more updated logical org customer.
1680: -- x_return_status Return status after the call. The status can
1681: -- be fnd_api.g_ret_sts_success (success),
1682: -- fnd_api.g_ret_sts_error (error),
1683: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1684: -- x_msg_count Number of messages in message stack.
1685: -- x_msg_data Message text if x_msg_count is 1.

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

1678: -- OUT:
1679: -- x_org_cust_v2_objs One or more updated logical org customer.
1680: -- x_return_status Return status after the call. The status can
1681: -- be fnd_api.g_ret_sts_success (success),
1682: -- fnd_api.g_ret_sts_error (error),
1683: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1684: -- x_msg_count Number of messages in message stack.
1685: -- x_msg_data Message text if x_msg_count is 1.
1686: --

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

1679: -- x_org_cust_v2_objs One or more updated logical org customer.
1680: -- x_return_status Return status after the call. The status can
1681: -- be fnd_api.g_ret_sts_success (success),
1682: -- fnd_api.g_ret_sts_error (error),
1683: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1684: -- x_msg_count Number of messages in message stack.
1685: -- x_msg_data Message text if x_msg_count is 1.
1686: --
1687: -- NOTES

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

1703: and returns them to the caller.
1704: */
1705:
1706: PROCEDURE get_v2_org_custs_updated(
1707: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1708: p_event_id IN NUMBER,
1709: x_org_cust_v2_objs OUT NOCOPY HZ_ORG_CUST_V2_BO_TBL,
1710: x_return_status OUT NOCOPY VARCHAR2,
1711: x_msg_count OUT NOCOPY NUMBER,

Line 1721: x_return_status := FND_API.G_RET_STS_SUCCESS;

1717:
1718: begin
1719:
1720: -- initialize API return status to success.
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722:
1723: -- Initialize message list if p_init_msg_list is set to TRUE
1724: IF FND_API.to_Boolean(p_init_msg_list) THEN
1725: FND_MSG_PUB.initialize;

Line 1724: IF FND_API.to_Boolean(p_init_msg_list) THEN

1720: -- initialize API return status to success.
1721: x_return_status := FND_API.G_RET_STS_SUCCESS;
1722:
1723: -- Initialize message list if p_init_msg_list is set to TRUE
1724: IF FND_API.to_Boolean(p_init_msg_list) THEN
1725: FND_MSG_PUB.initialize;
1726: END IF;
1727:
1728:

Line 1738: p_init_msg_list => fnd_api.g_false,

1734: END IF;
1735:
1736:
1737: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1738: p_init_msg_list => fnd_api.g_false,
1739: p_event_id => p_event_id,
1740: x_obj_root_ids => l_obj_root_ids,
1741: x_return_status => x_return_status,
1742: x_msg_count => x_msg_count,

Line 1745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1741: x_return_status => x_return_status,
1742: x_msg_count => x_msg_count,
1743: x_msg_data => x_msg_data);
1744:
1745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1746: RAISE FND_API.G_EXC_ERROR;
1747: END IF;
1748:
1749:

Line 1746: RAISE FND_API.G_EXC_ERROR;

1742: x_msg_count => x_msg_count,
1743: x_msg_data => x_msg_data);
1744:
1745: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1746: RAISE FND_API.G_EXC_ERROR;
1747: END IF;
1748:
1749:
1750:

Line 1756: p_init_msg_list => fnd_api.g_false,

1752:
1753: for i in 1..l_obj_root_ids.count loop
1754: x_org_cust_v2_objs.extend;
1755: get_v2_org_cust_updated(
1756: p_init_msg_list => fnd_api.g_false,
1757: p_event_id => p_event_id,
1758: p_org_cust_id => l_obj_root_ids(i),
1759: x_org_cust_v2_obj => x_org_cust_v2_objs(i),
1760: x_return_status => x_return_status,

Line 1785: WHEN fnd_api.g_exc_error THEN

1781:
1782:
1783: EXCEPTION
1784:
1785: WHEN fnd_api.g_exc_error THEN
1786: x_return_status := fnd_api.g_ret_sts_error;
1787:
1788: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1789: p_count => x_msg_count,

Line 1786: x_return_status := fnd_api.g_ret_sts_error;

1782:
1783: EXCEPTION
1784:
1785: WHEN fnd_api.g_exc_error THEN
1786: x_return_status := fnd_api.g_ret_sts_error;
1787:
1788: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1789: p_count => x_msg_count,
1790: p_data => x_msg_data);

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

1784:
1785: WHEN fnd_api.g_exc_error THEN
1786: x_return_status := fnd_api.g_ret_sts_error;
1787:
1788: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1789: p_count => x_msg_count,
1790: p_data => x_msg_data);
1791:
1792: -- Debug info.

Line 1804: WHEN fnd_api.g_exc_unexpected_error THEN

1800: hz_utility_v2pub.debug(p_message=>'get_v2_org_custs_updated(-)',
1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806:
1807: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1808: p_count => x_msg_count,

Line 1805: x_return_status := fnd_api.g_ret_sts_unexp_error;

1801: p_prefix=>l_debug_prefix,
1802: p_msg_level=>fnd_log.level_procedure);
1803: END IF;
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806:
1807: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);

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

1803: END IF;
1804: WHEN fnd_api.g_exc_unexpected_error THEN
1805: x_return_status := fnd_api.g_ret_sts_unexp_error;
1806:
1807: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810:
1811: -- Debug info.

Line 1824: x_return_status := fnd_api.g_ret_sts_unexp_error;

1820: p_prefix=>l_debug_prefix,
1821: p_msg_level=>fnd_log.level_procedure);
1822: END IF;
1823: WHEN OTHERS THEN
1824: x_return_status := fnd_api.g_ret_sts_unexp_error;
1825:
1826: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1827: fnd_message.set_token('ERROR' ,SQLERRM);
1828: fnd_msg_pub.add;

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

1826: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1827: fnd_message.set_token('ERROR' ,SQLERRM);
1828: fnd_msg_pub.add;
1829:
1830: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1831: p_count => x_msg_count,
1832: p_data => x_msg_data);
1833:
1834: -- Debug info.

Line 2118: x_return_status := FND_API.G_RET_STS_SUCCESS;

2114: l_creation_date date;
2115:
2116: begin
2117: -- initialize API return status to success.
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: open c2;
2121: fetch c2 into l_child_event_id, l_creation_date;
2122: close c2;

Line 2181: WHEN fnd_api.g_exc_unexpected_error THEN

2177:
2178: EXCEPTION
2179:
2180:
2181: WHEN fnd_api.g_exc_unexpected_error THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2184:
2185: WHEN OTHERS THEN

Line 2182: x_return_status := fnd_api.g_ret_sts_unexp_error;

2178: EXCEPTION
2179:
2180:
2181: WHEN fnd_api.g_exc_unexpected_error THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2184:
2185: WHEN OTHERS THEN
2186: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2186: x_return_status := fnd_api.g_ret_sts_unexp_error;

2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2184:
2185: WHEN OTHERS THEN
2186: x_return_status := fnd_api.g_ret_sts_unexp_error;
2187:
2188: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2189: fnd_message.set_token('ERROR' ,SQLERRM);
2190: fnd_msg_pub.add;

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

2205: -- IN:
2206: -- p_init_msg_list Initialize message stack if it is set to
2207: -- p_event_id BES Event identifier.
2208: -- p_org_cust_id Organization customer identifier.
2209: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2210: -- OUT:
2211: -- x_org_cust_v2_obj One updated logical organization.
2212: -- x_return_status Return status after the call. The status can
2213: -- be fnd_api.g_ret_sts_success (success),

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

2209: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2210: -- OUT:
2211: -- x_org_cust_v2_obj One updated logical organization.
2212: -- x_return_status Return status after the call. The status can
2213: -- be fnd_api.g_ret_sts_success (success),
2214: -- fnd_api.g_ret_sts_error (error),
2215: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2216: -- x_msg_count Number of messages in message stack.
2217: -- x_msg_data Message text if x_msg_count is 1.

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

2210: -- OUT:
2211: -- x_org_cust_v2_obj One updated logical organization.
2212: -- x_return_status Return status after the call. The status can
2213: -- be fnd_api.g_ret_sts_success (success),
2214: -- fnd_api.g_ret_sts_error (error),
2215: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2216: -- x_msg_count Number of messages in message stack.
2217: -- x_msg_data Message text if x_msg_count is 1.
2218: --

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

2211: -- x_org_cust_v2_obj One updated logical organization.
2212: -- x_return_status Return status after the call. The status can
2213: -- be fnd_api.g_ret_sts_success (success),
2214: -- fnd_api.g_ret_sts_error (error),
2215: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2216: -- x_msg_count Number of messages in message stack.
2217: -- x_msg_data Message text if x_msg_count is 1.
2218: --
2219: -- NOTES

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

2224: --
2225:
2226:
2227: PROCEDURE get_v2_org_cust_updated(
2228: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2229: p_event_id IN NUMBER,
2230: p_org_cust_id IN NUMBER,
2231: x_org_cust_v2_obj OUT NOCOPY HZ_ORG_CUST_V2_BO,
2232: x_return_status OUT NOCOPY VARCHAR2,

Line 2242: x_return_status := FND_API.G_RET_STS_SUCCESS;

2238: l_org_cust_obj HZ_ORG_CUST_V2_BO;
2239: begin
2240:
2241: -- initialize API return status to success.
2242: x_return_status := FND_API.G_RET_STS_SUCCESS;
2243:
2244: -- Initialize message list if p_init_msg_list is set to TRUE
2245: IF FND_API.to_Boolean(p_init_msg_list) THEN
2246: FND_MSG_PUB.initialize;

Line 2245: IF FND_API.to_Boolean(p_init_msg_list) THEN

2241: -- initialize API return status to success.
2242: x_return_status := FND_API.G_RET_STS_SUCCESS;
2243:
2244: -- Initialize message list if p_init_msg_list is set to TRUE
2245: IF FND_API.to_Boolean(p_init_msg_list) THEN
2246: FND_MSG_PUB.initialize;
2247: END IF;
2248:
2249:

Line 2260: p_init_msg_list => fnd_api.g_false,

2256:
2257: -- Set action type to 'UNCHANGED' by default
2258:
2259: get_org_cust_v2_bo(
2260: p_init_msg_list => fnd_api.g_false,
2261: p_organization_id => p_org_cust_id,
2262: p_action_type => 'UNCHANGED',
2263: x_org_cust_v2_obj => x_org_cust_v2_obj,
2264: x_return_status => x_return_status,

Line 2299: WHEN fnd_api.g_exc_error THEN

2295:
2296:
2297: EXCEPTION
2298:
2299: WHEN fnd_api.g_exc_error THEN
2300: x_return_status := fnd_api.g_ret_sts_error;
2301:
2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2303: p_count => x_msg_count,

Line 2300: x_return_status := fnd_api.g_ret_sts_error;

2296:
2297: EXCEPTION
2298:
2299: WHEN fnd_api.g_exc_error THEN
2300: x_return_status := fnd_api.g_ret_sts_error;
2301:
2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2303: p_count => x_msg_count,
2304: p_data => x_msg_data);

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

2298:
2299: WHEN fnd_api.g_exc_error THEN
2300: x_return_status := fnd_api.g_ret_sts_error;
2301:
2302: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2303: p_count => x_msg_count,
2304: p_data => x_msg_data);
2305:
2306: -- Debug info.

Line 2318: WHEN fnd_api.g_exc_unexpected_error THEN

2314: hz_utility_v2pub.debug(p_message=>'get_v2_org_cust_updated(-)',
2315: p_prefix=>l_debug_prefix,
2316: p_msg_level=>fnd_log.level_procedure);
2317: END IF;
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320:
2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2322: p_count => x_msg_count,

Line 2319: x_return_status := fnd_api.g_ret_sts_unexp_error;

2315: p_prefix=>l_debug_prefix,
2316: p_msg_level=>fnd_log.level_procedure);
2317: END IF;
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320:
2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2322: p_count => x_msg_count,
2323: p_data => x_msg_data);

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

2317: END IF;
2318: WHEN fnd_api.g_exc_unexpected_error THEN
2319: x_return_status := fnd_api.g_ret_sts_unexp_error;
2320:
2321: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2322: p_count => x_msg_count,
2323: p_data => x_msg_data);
2324:
2325: -- Debug info.

Line 2338: x_return_status := fnd_api.g_ret_sts_unexp_error;

2334: p_prefix=>l_debug_prefix,
2335: p_msg_level=>fnd_log.level_procedure);
2336: END IF;
2337: WHEN OTHERS THEN
2338: x_return_status := fnd_api.g_ret_sts_unexp_error;
2339:
2340: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2341: fnd_message.set_token('ERROR' ,SQLERRM);
2342: fnd_msg_pub.add;

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

2340: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2341: fnd_message.set_token('ERROR' ,SQLERRM);
2342: fnd_msg_pub.add;
2343:
2344: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2345: p_count => x_msg_count,
2346: p_data => x_msg_data);
2347:
2348: -- Debug info.