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_PERSON_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_person_id Person ID.
26: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
27: -- OUT:
28: -- x_person_cust_obj Logical person 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_person_cust_obj Logical person 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_person_cust_obj Logical person 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_person_cust_obj Logical person 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_person_cust_bo(
65: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
66: p_person_id IN NUMBER,
67: p_action_type IN VARCHAR2 := NULL,
68: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
69: x_return_status OUT NOCOPY VARCHAR2,

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 81: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 96: p_init_msg_list => fnd_api.g_false,

92:
93: x_person_cust_obj := HZ_PERSON_CUST_BO(p_action_type, NULL, NULL);
94:
95: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
96: p_init_msg_list => fnd_api.g_false,
97: p_person_id => p_person_id,
98: p_action_type => p_action_type,
99: x_person_obj => x_person_cust_obj.person_obj,
100: x_return_status => x_return_status,

Line 104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 105: RAISE FND_API.G_EXC_ERROR;

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

Line 110: p_init_msg_list => fnd_api.g_false,

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

Line 119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 120: RAISE FND_API.G_EXC_ERROR;

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

Line 142: WHEN fnd_api.g_exc_error THEN

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

Line 143: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 161: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 162: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 181: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

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

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

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

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

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

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

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

272: */
273:
274:
275: PROCEDURE get_person_custs_created(
276: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
277: p_event_id IN NUMBER,
278: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,

Line 292: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 295: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 309: p_init_msg_list => fnd_api.g_false,

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

Line 316: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 317: RAISE FND_API.G_EXC_ERROR;

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

Line 336: p_init_msg_list => fnd_api.g_false,

332: x_person_cust_objs.extend;
333:
334: x_person_cust_objs(i) := HZ_PERSON_CUST_BO('UNCHANGED', NULL, NULL);
335: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
336: p_init_msg_list => fnd_api.g_false,
337: p_person_id => l_obj_root_ids(i),
338: p_action_type => l_action_type,
339: x_person_obj => x_person_cust_objs(i).person_obj,
340: x_return_status => x_return_status,

Line 344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

340: x_return_status => x_return_status,
341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data);
343:
344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: if L_CHILD_OPERATION_FLAG = 'U'

Line 345: RAISE FND_API.G_EXC_ERROR;

341: x_msg_count => x_msg_count,
342: x_msg_data => x_msg_data);
343:
344: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;
347:
348: if L_CHILD_OPERATION_FLAG = 'U'
349: then

Line 358: p_init_msg_list => fnd_api.g_false,

354:
355: end if;
356:
357: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_bos(
358: p_init_msg_list => fnd_api.g_false,
359: p_parent_id => l_obj_root_ids(i),
360: p_cust_acct_id => NULL,
361: p_action_type => 'CREATED',
362: x_cust_acct_objs => x_person_cust_objs(i).account_objs,

Line 367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

363: x_return_status => x_return_status,
364: x_msg_count => x_msg_count,
365: x_msg_data => x_msg_data);
366:
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370: if L_CHILD_OPERATION_FLAG = 'I'
371: then

Line 368: RAISE FND_API.G_EXC_ERROR;

364: x_msg_count => x_msg_count,
365: x_msg_data => x_msg_data);
366:
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: RAISE FND_API.G_EXC_ERROR;
369: END IF;
370: if L_CHILD_OPERATION_FLAG = 'I'
371: then
372: x_person_cust_objs(i).action_type := 'CREATED';

Line 396: WHEN fnd_api.g_exc_error THEN

392:
393:
394: EXCEPTION
395:
396: WHEN fnd_api.g_exc_error THEN
397: x_return_status := fnd_api.g_ret_sts_error;
398:
399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
400: p_count => x_msg_count,

Line 397: x_return_status := fnd_api.g_ret_sts_error;

393:
394: EXCEPTION
395:
396: WHEN fnd_api.g_exc_error THEN
397: x_return_status := fnd_api.g_ret_sts_error;
398:
399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
400: p_count => x_msg_count,
401: p_data => x_msg_data);

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

395:
396: WHEN fnd_api.g_exc_error THEN
397: x_return_status := fnd_api.g_ret_sts_error;
398:
399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
400: p_count => x_msg_count,
401: p_data => x_msg_data);
402:
403: -- Debug info.

Line 415: WHEN fnd_api.g_exc_unexpected_error THEN

411: hz_utility_v2pub.debug(p_message=>'get_person_cust_created(-)',
412: p_prefix=>l_debug_prefix,
413: p_msg_level=>fnd_log.level_procedure);
414: END IF;
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_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_unexp_error;

412: p_prefix=>l_debug_prefix,
413: p_msg_level=>fnd_log.level_procedure);
414: END IF;
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_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: END IF;
415: WHEN fnd_api.g_exc_unexpected_error THEN
416: x_return_status := fnd_api.g_ret_sts_unexp_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 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 OTHERS THEN
435: x_return_status := fnd_api.g_ret_sts_unexp_error;
436:
437: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
438: fnd_message.set_token('ERROR' ,SQLERRM);
439: fnd_msg_pub.add;

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

437: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
438: fnd_message.set_token('ERROR' ,SQLERRM);
439: fnd_msg_pub.add;
440:
441: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
442: p_count => x_msg_count,
443: p_data => x_msg_data);
444:
445: -- Debug info.

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

473: -- ARGUMENTS
474: -- IN:
475: -- p_init_msg_list Initialize message stack if it is set to
476: -- p_event_id BES Event identifier.
477: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
478: -- OUT:
479: -- x_person_cust_objs One or more created logical person.
480: -- x_return_status Return status after the call. The status can
481: -- be fnd_api.g_ret_sts_success (success),

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

477: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
478: -- OUT:
479: -- x_person_cust_objs One or more created logical person.
480: -- x_return_status Return status after the call. The status can
481: -- be fnd_api.g_ret_sts_success (success),
482: -- fnd_api.g_ret_sts_error (error),
483: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
484: -- x_msg_count Number of messages in message stack.
485: -- x_msg_data Message text if x_msg_count is 1.

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

478: -- OUT:
479: -- x_person_cust_objs One or more created logical person.
480: -- x_return_status Return status after the call. The status can
481: -- be fnd_api.g_ret_sts_success (success),
482: -- fnd_api.g_ret_sts_error (error),
483: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
484: -- x_msg_count Number of messages in message stack.
485: -- x_msg_data Message text if x_msg_count is 1.
486: --

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

479: -- x_person_cust_objs One or more created logical person.
480: -- x_return_status Return status after the call. The status can
481: -- be fnd_api.g_ret_sts_success (success),
482: -- fnd_api.g_ret_sts_error (error),
483: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
484: -- x_msg_count Number of messages in message stack.
485: -- x_msg_data Message text if x_msg_count is 1.
486: --
487: -- NOTES

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

503: and returns them to the caller.
504: */
505:
506: PROCEDURE get_person_custs_updated(
507: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
508: p_event_id IN NUMBER,
509: x_person_cust_objs OUT NOCOPY HZ_PERSON_CUST_BO_TBL,
510: x_return_status OUT NOCOPY VARCHAR2,
511: x_msg_count OUT NOCOPY NUMBER,

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517:
518: begin
519:
520: -- initialize API return status to success.
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: -- Initialize message list if p_init_msg_list is set to TRUE
524: IF FND_API.to_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.initialize;

Line 524: IF FND_API.to_Boolean(p_init_msg_list) THEN

520: -- initialize API return status to success.
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: -- Initialize message list if p_init_msg_list is set to TRUE
524: IF FND_API.to_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.initialize;
526: END IF;
527:
528:

Line 538: p_init_msg_list => fnd_api.g_false,

534: END IF;
535:
536:
537: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
538: p_init_msg_list => fnd_api.g_false,
539: p_event_id => p_event_id,
540: x_obj_root_ids => l_obj_root_ids,
541: x_return_status => x_return_status,
542: x_msg_count => x_msg_count,

Line 545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

541: x_return_status => x_return_status,
542: x_msg_count => x_msg_count,
543: x_msg_data => x_msg_data);
544:
545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548:
549: -- call event API get_person_cust_updated for each id.

Line 546: RAISE FND_API.G_EXC_ERROR;

542: x_msg_count => x_msg_count,
543: x_msg_data => x_msg_data);
544:
545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
546: RAISE FND_API.G_EXC_ERROR;
547: END IF;
548:
549: -- call event API get_person_cust_updated for each id.
550:

Line 557: p_init_msg_list => fnd_api.g_false,

553: for i in 1..l_obj_root_ids.count loop
554:
555: x_person_cust_objs.extend;
556: get_person_cust_updated(
557: p_init_msg_list => fnd_api.g_false,
558: p_event_id => p_event_id,
559: p_person_cust_id => l_obj_root_ids(i),
560: x_person_cust_obj => x_person_cust_objs(i),
561: x_return_status => x_return_status,

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: end loop;

Line 591: WHEN fnd_api.g_exc_error THEN

587:
588:
589: EXCEPTION
590:
591: WHEN fnd_api.g_exc_error THEN
592: x_return_status := fnd_api.g_ret_sts_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,

Line 592: x_return_status := fnd_api.g_ret_sts_error;

588:
589: EXCEPTION
590:
591: WHEN fnd_api.g_exc_error THEN
592: x_return_status := fnd_api.g_ret_sts_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,
596: p_data => x_msg_data);

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

590:
591: WHEN fnd_api.g_exc_error THEN
592: x_return_status := fnd_api.g_ret_sts_error;
593:
594: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.

Line 610: WHEN fnd_api.g_exc_unexpected_error THEN

606: hz_utility_v2pub.debug(p_message=>'get_person_custs_updated(-)',
607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610: WHEN fnd_api.g_exc_unexpected_error THEN
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,

Line 611: x_return_status := fnd_api.g_ret_sts_unexp_error;

607: p_prefix=>l_debug_prefix,
608: p_msg_level=>fnd_log.level_procedure);
609: END IF;
610: WHEN fnd_api.g_exc_unexpected_error THEN
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data);

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

609: END IF;
610: WHEN fnd_api.g_exc_unexpected_error THEN
611: x_return_status := fnd_api.g_ret_sts_unexp_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: -- Debug info.

Line 630: x_return_status := fnd_api.g_ret_sts_unexp_error;

626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN OTHERS THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
633: fnd_message.set_token('ERROR' ,SQLERRM);
634: fnd_msg_pub.add;

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

632: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
633: fnd_message.set_token('ERROR' ,SQLERRM);
634: fnd_msg_pub.add;
635:
636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
637: p_count => x_msg_count,
638: p_data => x_msg_data);
639:
640: -- Debug info.

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: l_creation_date date;
915:
916: begin
917: -- initialize API return status to success.
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919:
920: open c2;
921: fetch c2 into l_child_event_id, l_creation_date;
922: close c2;

Line 980: WHEN fnd_api.g_exc_unexpected_error THEN

976:
977: EXCEPTION
978:
979:
980: WHEN fnd_api.g_exc_unexpected_error THEN
981: x_return_status := fnd_api.g_ret_sts_unexp_error;
982:
983:
984: WHEN OTHERS THEN

Line 981: x_return_status := fnd_api.g_ret_sts_unexp_error;

977: EXCEPTION
978:
979:
980: WHEN fnd_api.g_exc_unexpected_error THEN
981: x_return_status := fnd_api.g_ret_sts_unexp_error;
982:
983:
984: WHEN OTHERS THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 985: x_return_status := fnd_api.g_ret_sts_unexp_error;

981: x_return_status := fnd_api.g_ret_sts_unexp_error;
982:
983:
984: WHEN OTHERS THEN
985: x_return_status := fnd_api.g_ret_sts_unexp_error;
986:
987: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
988: fnd_message.set_token('ERROR' ,SQLERRM);
989: fnd_msg_pub.add;

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

1004: -- IN:
1005: -- p_init_msg_list Initialize message stack if it is set to
1006: -- p_event_id BES Event identifier.
1007: -- p_person_cust_id Person customer identifier.
1008: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1009: -- OUT:
1010: -- x_person_cust_obj One updated logical person.
1011: -- x_return_status Return status after the call. The status can
1012: -- be fnd_api.g_ret_sts_success (success),

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

1008: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1009: -- OUT:
1010: -- x_person_cust_obj One updated logical person.
1011: -- x_return_status Return status after the call. The status can
1012: -- be fnd_api.g_ret_sts_success (success),
1013: -- fnd_api.g_ret_sts_error (error),
1014: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1015: -- x_msg_count Number of messages in message stack.
1016: -- x_msg_data Message text if x_msg_count is 1.

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

1009: -- OUT:
1010: -- x_person_cust_obj One updated logical person.
1011: -- x_return_status Return status after the call. The status can
1012: -- be fnd_api.g_ret_sts_success (success),
1013: -- fnd_api.g_ret_sts_error (error),
1014: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1015: -- x_msg_count Number of messages in message stack.
1016: -- x_msg_data Message text if x_msg_count is 1.
1017: --

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

1010: -- x_person_cust_obj One updated logical person.
1011: -- x_return_status Return status after the call. The status can
1012: -- be fnd_api.g_ret_sts_success (success),
1013: -- fnd_api.g_ret_sts_error (error),
1014: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1015: -- x_msg_count Number of messages in message stack.
1016: -- x_msg_data Message text if x_msg_count is 1.
1017: --
1018: -- NOTES

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

1022: -- 06-JUN-2005 AWU Created.
1023: --
1024:
1025: PROCEDURE get_person_cust_updated(
1026: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1027: p_event_id IN NUMBER,
1028: p_person_cust_id IN NUMBER,
1029: x_person_cust_obj OUT NOCOPY HZ_PERSON_CUST_BO,
1030: x_return_status OUT NOCOPY VARCHAR2,

Line 1041: x_return_status := FND_API.G_RET_STS_SUCCESS;

1037: l_person_cust_obj HZ_PERSON_CUST_BO;
1038: begin
1039:
1040: -- initialize API return status to success.
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042:
1043: -- Initialize message list if p_init_msg_list is set to TRUE
1044: IF FND_API.to_Boolean(p_init_msg_list) THEN
1045: FND_MSG_PUB.initialize;

Line 1044: IF FND_API.to_Boolean(p_init_msg_list) THEN

1040: -- initialize API return status to success.
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1042:
1043: -- Initialize message list if p_init_msg_list is set to TRUE
1044: IF FND_API.to_Boolean(p_init_msg_list) THEN
1045: FND_MSG_PUB.initialize;
1046: END IF;
1047:
1048:

Line 1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1056: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1057: p_party_id => p_person_cust_id,
1058: x_return_status => x_return_status);
1059:
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: */
1064: -- Set action type to 'UNCHANGED' by default

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: p_party_id => p_person_cust_id,
1058: x_return_status => x_return_status);
1059:
1060: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063: */
1064: -- Set action type to 'UNCHANGED' by default
1065:

Line 1067: p_init_msg_list => fnd_api.g_false,

1063: */
1064: -- Set action type to 'UNCHANGED' by default
1065:
1066: get_person_cust_bo(
1067: p_init_msg_list => fnd_api.g_false,
1068: p_person_id => p_person_cust_id,
1069: p_action_type => 'UNCHANGED',
1070: x_person_cust_obj => x_person_cust_obj,
1071: x_return_status => x_return_status,

Line 1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1071: x_return_status => x_return_status,
1072: x_msg_count => x_msg_count,
1073: x_msg_data => x_msg_data);
1074:
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079:

Line 1076: RAISE FND_API.G_EXC_ERROR;

1072: x_msg_count => x_msg_count,
1073: x_msg_data => x_msg_data);
1074:
1075: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1076: RAISE FND_API.G_EXC_ERROR;
1077: END IF;
1078:
1079:
1080: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

Line 1090: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1086: x_return_status => x_return_status
1087: );
1088: x_person_cust_obj := l_person_cust_obj;
1089:
1090: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094:

Line 1091: RAISE FND_API.G_EXC_ERROR;

1087: );
1088: x_person_cust_obj := l_person_cust_obj;
1089:
1090: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1091: RAISE FND_API.G_EXC_ERROR;
1092: END IF;
1093:
1094:
1095:

Line 1114: WHEN fnd_api.g_exc_error THEN

1110:
1111:
1112: EXCEPTION
1113:
1114: WHEN fnd_api.g_exc_error THEN
1115: x_return_status := fnd_api.g_ret_sts_error;
1116:
1117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1118: p_count => x_msg_count,

Line 1115: x_return_status := fnd_api.g_ret_sts_error;

1111:
1112: EXCEPTION
1113:
1114: WHEN fnd_api.g_exc_error THEN
1115: x_return_status := fnd_api.g_ret_sts_error;
1116:
1117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);

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

1113:
1114: WHEN fnd_api.g_exc_error THEN
1115: x_return_status := fnd_api.g_ret_sts_error;
1116:
1117: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1118: p_count => x_msg_count,
1119: p_data => x_msg_data);
1120:
1121: -- Debug info.

Line 1133: WHEN fnd_api.g_exc_unexpected_error THEN

1129: hz_utility_v2pub.debug(p_message=>'get_person_cust_updated(-)',
1130: p_prefix=>l_debug_prefix,
1131: p_msg_level=>fnd_log.level_procedure);
1132: END IF;
1133: WHEN fnd_api.g_exc_unexpected_error THEN
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1137: p_count => x_msg_count,

Line 1134: x_return_status := fnd_api.g_ret_sts_unexp_error;

1130: p_prefix=>l_debug_prefix,
1131: p_msg_level=>fnd_log.level_procedure);
1132: END IF;
1133: WHEN fnd_api.g_exc_unexpected_error THEN
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data);

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

1132: END IF;
1133: WHEN fnd_api.g_exc_unexpected_error THEN
1134: x_return_status := fnd_api.g_ret_sts_unexp_error;
1135:
1136: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data);
1139:
1140: -- Debug info.

Line 1153: x_return_status := fnd_api.g_ret_sts_unexp_error;

1149: p_prefix=>l_debug_prefix,
1150: p_msg_level=>fnd_log.level_procedure);
1151: END IF;
1152: WHEN OTHERS THEN
1153: x_return_status := fnd_api.g_ret_sts_unexp_error;
1154:
1155: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1156: fnd_message.set_token('ERROR' ,SQLERRM);
1157: fnd_msg_pub.add;

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

1155: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1156: fnd_message.set_token('ERROR' ,SQLERRM);
1157: fnd_msg_pub.add;
1158:
1159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1160: p_count => x_msg_count,
1161: p_data => x_msg_data);
1162:
1163: -- Debug info.

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

1187: -- ARGUMENTS
1188: -- IN:
1189: -- p_init_msg_list Initialize message stack if it is set to
1190: -- p_person_id Person ID.
1191: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1192: -- OUT:
1193: -- x_person_cust_v2_obj Logical person customer record.
1194: -- x_return_status Return status after the call. The status can
1195: -- be fnd_api.g_ret_sts_success (success),

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

1191: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1192: -- OUT:
1193: -- x_person_cust_v2_obj Logical person customer record.
1194: -- x_return_status Return status after the call. The status can
1195: -- be fnd_api.g_ret_sts_success (success),
1196: -- fnd_api.g_ret_sts_error (error),
1197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1198: -- x_msg_count Number of messages in message stack.
1199: -- x_msg_data Message text if x_msg_count is 1.

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

1192: -- OUT:
1193: -- x_person_cust_v2_obj Logical person customer record.
1194: -- x_return_status Return status after the call. The status can
1195: -- be fnd_api.g_ret_sts_success (success),
1196: -- fnd_api.g_ret_sts_error (error),
1197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1198: -- x_msg_count Number of messages in message stack.
1199: -- x_msg_data Message text if x_msg_count is 1.
1200: --

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

1193: -- x_person_cust_v2_obj Logical person customer record.
1194: -- x_return_status Return status after the call. The status can
1195: -- be fnd_api.g_ret_sts_success (success),
1196: -- fnd_api.g_ret_sts_error (error),
1197: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1198: -- x_msg_count Number of messages in message stack.
1199: -- x_msg_data Message text if x_msg_count is 1.
1200: --
1201: -- NOTES

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

1226:
1227:
1228:
1229: PROCEDURE get_person_cust_v2_bo(
1230: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1231: p_person_id IN NUMBER,
1232: p_action_type IN VARCHAR2 := NULL,
1233: x_person_cust_v2_obj OUT NOCOPY HZ_PERSON_CUST_V2_BO,
1234: x_return_status OUT NOCOPY VARCHAR2,

Line 1243: x_return_status := FND_API.G_RET_STS_SUCCESS;

1239: l_debug_prefix VARCHAR2(30) := '';
1240:
1241: begin
1242: -- initialize API return status to success.
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: -- Initialize message list if p_init_msg_list is set to TRUE
1246: IF FND_API.to_Boolean(p_init_msg_list) THEN
1247: FND_MSG_PUB.initialize;

Line 1246: IF FND_API.to_Boolean(p_init_msg_list) THEN

1242: -- initialize API return status to success.
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:
1245: -- Initialize message list if p_init_msg_list is set to TRUE
1246: IF FND_API.to_Boolean(p_init_msg_list) THEN
1247: FND_MSG_PUB.initialize;
1248: END IF;
1249:
1250:

Line 1261: p_init_msg_list => fnd_api.g_false,

1257:
1258: x_person_cust_v2_obj := HZ_PERSON_CUST_V2_BO(p_action_type, NULL, NULL);
1259:
1260: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
1261: p_init_msg_list => fnd_api.g_false,
1262: p_person_id => p_person_id,
1263: p_action_type => p_action_type,
1264: x_person_obj => x_person_cust_v2_obj.person_obj,
1265: x_return_status => x_return_status,

Line 1269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1265: x_return_status => x_return_status,
1266: x_msg_count => x_msg_count,
1267: x_msg_data => x_msg_data);
1268:
1269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: END IF;
1272:
1273:

Line 1270: RAISE FND_API.G_EXC_ERROR;

1266: x_msg_count => x_msg_count,
1267: x_msg_data => x_msg_data);
1268:
1269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1270: RAISE FND_API.G_EXC_ERROR;
1271: END IF;
1272:
1273:
1274: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(

Line 1275: p_init_msg_list => fnd_api.g_false,

1271: END IF;
1272:
1273:
1274: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(
1275: p_init_msg_list => fnd_api.g_false,
1276: p_parent_id => p_person_id,
1277: p_cust_acct_id => NULL,
1278: p_action_type => p_action_type,
1279: x_cust_acct_v2_objs => x_person_cust_v2_obj.account_objs,

Line 1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1280: x_return_status => x_return_status,
1281: x_msg_count => x_msg_count,
1282: x_msg_data => x_msg_data);
1283:
1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288:

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281: x_msg_count => x_msg_count,
1282: x_msg_data => x_msg_data);
1283:
1284: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288:
1289: -- Debug info.

Line 1307: WHEN fnd_api.g_exc_error THEN

1303:
1304:
1305: EXCEPTION
1306:
1307: WHEN fnd_api.g_exc_error THEN
1308: x_return_status := fnd_api.g_ret_sts_error;
1309:
1310: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1311: p_count => x_msg_count,

Line 1308: x_return_status := fnd_api.g_ret_sts_error;

1304:
1305: EXCEPTION
1306:
1307: WHEN fnd_api.g_exc_error THEN
1308: x_return_status := fnd_api.g_ret_sts_error;
1309:
1310: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);

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

1306:
1307: WHEN fnd_api.g_exc_error THEN
1308: x_return_status := fnd_api.g_ret_sts_error;
1309:
1310: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1311: p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:
1314: -- Debug info.

Line 1326: WHEN fnd_api.g_exc_unexpected_error THEN

1322: hz_utility_v2pub.debug(p_message=>'get_person_cust_v2_bo (-)',
1323: p_prefix=>l_debug_prefix,
1324: p_msg_level=>fnd_log.level_procedure);
1325: END IF;
1326: WHEN fnd_api.g_exc_unexpected_error THEN
1327: x_return_status := fnd_api.g_ret_sts_unexp_error;
1328:
1329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1330: p_count => x_msg_count,

Line 1327: x_return_status := fnd_api.g_ret_sts_unexp_error;

1323: p_prefix=>l_debug_prefix,
1324: p_msg_level=>fnd_log.level_procedure);
1325: END IF;
1326: WHEN fnd_api.g_exc_unexpected_error THEN
1327: x_return_status := fnd_api.g_ret_sts_unexp_error;
1328:
1329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data);

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

1325: END IF;
1326: WHEN fnd_api.g_exc_unexpected_error THEN
1327: x_return_status := fnd_api.g_ret_sts_unexp_error;
1328:
1329: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data);
1332:
1333: -- Debug info.

Line 1346: x_return_status := fnd_api.g_ret_sts_unexp_error;

1342: p_prefix=>l_debug_prefix,
1343: p_msg_level=>fnd_log.level_procedure);
1344: END IF;
1345: WHEN OTHERS THEN
1346: x_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1349: fnd_message.set_token('ERROR' ,SQLERRM);
1350: fnd_msg_pub.add;

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

1348: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1349: fnd_message.set_token('ERROR' ,SQLERRM);
1350: fnd_msg_pub.add;
1351:
1352: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1353: p_count => x_msg_count,
1354: p_data => x_msg_data);
1355:
1356: -- Debug info.

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

1384: -- ARGUMENTS
1385: -- IN:
1386: -- p_init_msg_list Initialize message stack if it is set to
1387: -- p_event_id BES Event identifier.
1388: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1389: -- OUT:
1390: -- x_person_cust_v2_objs One or more created logical person customer.
1391: -- x_return_status Return status after the call. The status can
1392: -- be fnd_api.g_ret_sts_success (success),

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

1388: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1389: -- OUT:
1390: -- x_person_cust_v2_objs One or more created logical person customer.
1391: -- x_return_status Return status after the call. The status can
1392: -- be fnd_api.g_ret_sts_success (success),
1393: -- fnd_api.g_ret_sts_error (error),
1394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1395: -- x_msg_count Number of messages in message stack.
1396: -- x_msg_data Message text if x_msg_count is 1.

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

1389: -- OUT:
1390: -- x_person_cust_v2_objs One or more created logical person customer.
1391: -- x_return_status Return status after the call. The status can
1392: -- be fnd_api.g_ret_sts_success (success),
1393: -- fnd_api.g_ret_sts_error (error),
1394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1395: -- x_msg_count Number of messages in message stack.
1396: -- x_msg_data Message text if x_msg_count is 1.
1397: --

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

1390: -- x_person_cust_v2_objs One or more created logical person customer.
1391: -- x_return_status Return status after the call. The status can
1392: -- be fnd_api.g_ret_sts_success (success),
1393: -- fnd_api.g_ret_sts_error (error),
1394: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1395: -- x_msg_count Number of messages in message stack.
1396: -- x_msg_data Message text if x_msg_count is 1.
1397: --
1398: -- NOTES

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

1418: */
1419:
1420:
1421: PROCEDURE get_v2_person_custs_created(
1422: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1423: p_event_id IN NUMBER,
1424: x_person_cust_v2_objs OUT NOCOPY HZ_PERSON_CUST_V2_BO_TBL,
1425: x_return_status OUT NOCOPY VARCHAR2,
1426: x_msg_count OUT NOCOPY NUMBER,

Line 1438: x_return_status := FND_API.G_RET_STS_SUCCESS;

1434:
1435: begin
1436:
1437: -- initialize API return status to success.
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440: -- Initialize message list if p_init_msg_list is set to TRUE
1441: IF FND_API.to_Boolean(p_init_msg_list) THEN
1442: FND_MSG_PUB.initialize;

Line 1441: IF FND_API.to_Boolean(p_init_msg_list) THEN

1437: -- initialize API return status to success.
1438: x_return_status := FND_API.G_RET_STS_SUCCESS;
1439:
1440: -- Initialize message list if p_init_msg_list is set to TRUE
1441: IF FND_API.to_Boolean(p_init_msg_list) THEN
1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445:

Line 1455: p_init_msg_list => fnd_api.g_false,

1451: END IF;
1452:
1453:
1454: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1455: p_init_msg_list => fnd_api.g_false,
1456: p_event_id => p_event_id,
1457: x_obj_root_ids => l_obj_root_ids,
1458: x_return_status => x_return_status,
1459: x_msg_count => x_msg_count,

Line 1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1458: x_return_status => x_return_status,
1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461:
1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: x_person_cust_v2_objs := HZ_PERSON_CUST_V2_BO_TBL();

Line 1463: RAISE FND_API.G_EXC_ERROR;

1459: x_msg_count => x_msg_count,
1460: x_msg_data => x_msg_data);
1461:
1462: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: x_person_cust_v2_objs := HZ_PERSON_CUST_V2_BO_TBL();
1467: l_child_operation_flag:= get_person_operation_type(p_event_id);

Line 1482: p_init_msg_list => fnd_api.g_false,

1478: x_person_cust_v2_objs.extend;
1479:
1480: x_person_cust_v2_objs(i) := HZ_PERSON_CUST_V2_BO('UNCHANGED', NULL, NULL);
1481: HZ_EXTRACT_PERSON_BO_PVT.get_person_bo(
1482: p_init_msg_list => fnd_api.g_false,
1483: p_person_id => l_obj_root_ids(i),
1484: p_action_type => l_action_type,
1485: x_person_obj => x_person_cust_v2_objs(i).person_obj,
1486: x_return_status => x_return_status,

Line 1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1486: x_return_status => x_return_status,
1487: x_msg_count => x_msg_count,
1488: x_msg_data => x_msg_data);
1489:
1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: if L_CHILD_OPERATION_FLAG = 'U'

Line 1491: RAISE FND_API.G_EXC_ERROR;

1487: x_msg_count => x_msg_count,
1488: x_msg_data => x_msg_data);
1489:
1490: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: RAISE FND_API.G_EXC_ERROR;
1492: END IF;
1493:
1494: if L_CHILD_OPERATION_FLAG = 'U'
1495: then

Line 1504: p_init_msg_list => fnd_api.g_false,

1500:
1501: end if;
1502:
1503: HZ_EXTRACT_CUST_ACCT_BO_PVT.get_cust_acct_v2_bos(
1504: p_init_msg_list => fnd_api.g_false,
1505: p_parent_id => l_obj_root_ids(i),
1506: p_cust_acct_id => NULL,
1507: p_action_type => 'CREATED',
1508: x_cust_acct_v2_objs => x_person_cust_v2_objs(i).account_objs,

Line 1513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1509: x_return_status => x_return_status,
1510: x_msg_count => x_msg_count,
1511: x_msg_data => x_msg_data);
1512:
1513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516: if L_CHILD_OPERATION_FLAG = 'I'
1517: then

Line 1514: RAISE FND_API.G_EXC_ERROR;

1510: x_msg_count => x_msg_count,
1511: x_msg_data => x_msg_data);
1512:
1513: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1514: RAISE FND_API.G_EXC_ERROR;
1515: END IF;
1516: if L_CHILD_OPERATION_FLAG = 'I'
1517: then
1518: x_person_cust_v2_objs(i).action_type := 'CREATED';

Line 1542: WHEN fnd_api.g_exc_error THEN

1538:
1539:
1540: EXCEPTION
1541:
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544:
1545: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1546: p_count => x_msg_count,

Line 1543: x_return_status := fnd_api.g_ret_sts_error;

1539:
1540: EXCEPTION
1541:
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544:
1545: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1546: p_count => x_msg_count,
1547: p_data => x_msg_data);

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

1541:
1542: WHEN fnd_api.g_exc_error THEN
1543: x_return_status := fnd_api.g_ret_sts_error;
1544:
1545: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1546: p_count => x_msg_count,
1547: p_data => x_msg_data);
1548:
1549: -- Debug info.

Line 1561: WHEN fnd_api.g_exc_unexpected_error THEN

1557: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_created(-)',
1558: p_prefix=>l_debug_prefix,
1559: p_msg_level=>fnd_log.level_procedure);
1560: END IF;
1561: WHEN fnd_api.g_exc_unexpected_error THEN
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563:
1564: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1565: p_count => x_msg_count,

Line 1562: x_return_status := fnd_api.g_ret_sts_unexp_error;

1558: p_prefix=>l_debug_prefix,
1559: p_msg_level=>fnd_log.level_procedure);
1560: END IF;
1561: WHEN fnd_api.g_exc_unexpected_error THEN
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563:
1564: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data);

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

1560: END IF;
1561: WHEN fnd_api.g_exc_unexpected_error THEN
1562: x_return_status := fnd_api.g_ret_sts_unexp_error;
1563:
1564: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data);
1567:
1568: -- Debug info.

Line 1581: x_return_status := fnd_api.g_ret_sts_unexp_error;

1577: p_prefix=>l_debug_prefix,
1578: p_msg_level=>fnd_log.level_procedure);
1579: END IF;
1580: WHEN OTHERS THEN
1581: x_return_status := fnd_api.g_ret_sts_unexp_error;
1582:
1583: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1584: fnd_message.set_token('ERROR' ,SQLERRM);
1585: fnd_msg_pub.add;

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

1583: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1584: fnd_message.set_token('ERROR' ,SQLERRM);
1585: fnd_msg_pub.add;
1586:
1587: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1588: p_count => x_msg_count,
1589: p_data => x_msg_data);
1590:
1591: -- Debug info.

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

1620: -- ARGUMENTS
1621: -- IN:
1622: -- p_init_msg_list Initialize message stack if it is set to
1623: -- p_event_id BES Event identifier.
1624: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1625: -- OUT:
1626: -- x_person_cust_v2_objs One or more created logical person.
1627: -- x_return_status Return status after the call. The status can
1628: -- be fnd_api.g_ret_sts_success (success),

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

1624: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
1625: -- OUT:
1626: -- x_person_cust_v2_objs One or more created logical person.
1627: -- x_return_status Return status after the call. The status can
1628: -- be fnd_api.g_ret_sts_success (success),
1629: -- fnd_api.g_ret_sts_error (error),
1630: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1631: -- x_msg_count Number of messages in message stack.
1632: -- x_msg_data Message text if x_msg_count is 1.

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

1625: -- OUT:
1626: -- x_person_cust_v2_objs One or more created logical person.
1627: -- x_return_status Return status after the call. The status can
1628: -- be fnd_api.g_ret_sts_success (success),
1629: -- fnd_api.g_ret_sts_error (error),
1630: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1631: -- x_msg_count Number of messages in message stack.
1632: -- x_msg_data Message text if x_msg_count is 1.
1633: --

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

1626: -- x_person_cust_v2_objs One or more created logical person.
1627: -- x_return_status Return status after the call. The status can
1628: -- be fnd_api.g_ret_sts_success (success),
1629: -- fnd_api.g_ret_sts_error (error),
1630: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1631: -- x_msg_count Number of messages in message stack.
1632: -- x_msg_data Message text if x_msg_count is 1.
1633: --
1634: -- NOTES

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

1650: and returns them to the caller.
1651: */
1652:
1653: PROCEDURE get_v2_person_custs_updated(
1654: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1655: p_event_id IN NUMBER,
1656: x_person_cust_v2_objs OUT NOCOPY HZ_PERSON_CUST_V2_BO_TBL,
1657: x_return_status OUT NOCOPY VARCHAR2,
1658: x_msg_count OUT NOCOPY NUMBER,

Line 1668: x_return_status := FND_API.G_RET_STS_SUCCESS;

1664:
1665: begin
1666:
1667: -- initialize API return status to success.
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- Initialize message list if p_init_msg_list is set to TRUE
1671: IF FND_API.to_Boolean(p_init_msg_list) THEN
1672: FND_MSG_PUB.initialize;

Line 1671: IF FND_API.to_Boolean(p_init_msg_list) THEN

1667: -- initialize API return status to success.
1668: x_return_status := FND_API.G_RET_STS_SUCCESS;
1669:
1670: -- Initialize message list if p_init_msg_list is set to TRUE
1671: IF FND_API.to_Boolean(p_init_msg_list) THEN
1672: FND_MSG_PUB.initialize;
1673: END IF;
1674:
1675:

Line 1685: p_init_msg_list => fnd_api.g_false,

1681: END IF;
1682:
1683:
1684: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1685: p_init_msg_list => fnd_api.g_false,
1686: p_event_id => p_event_id,
1687: x_obj_root_ids => l_obj_root_ids,
1688: x_return_status => x_return_status,
1689: x_msg_count => x_msg_count,

Line 1692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1688: x_return_status => x_return_status,
1689: x_msg_count => x_msg_count,
1690: x_msg_data => x_msg_data);
1691:
1692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: -- call event API get_person_cust_updated for each id.

Line 1693: RAISE FND_API.G_EXC_ERROR;

1689: x_msg_count => x_msg_count,
1690: x_msg_data => x_msg_data);
1691:
1692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: -- call event API get_person_cust_updated for each id.
1697:

Line 1704: p_init_msg_list => fnd_api.g_false,

1700: for i in 1..l_obj_root_ids.count loop
1701:
1702: x_person_cust_v2_objs.extend;
1703: get_v2_person_cust_updated(
1704: p_init_msg_list => fnd_api.g_false,
1705: p_event_id => p_event_id,
1706: p_person_cust_id => l_obj_root_ids(i),
1707: x_person_cust_v2_obj => x_person_cust_v2_objs(i),
1708: x_return_status => x_return_status,

Line 1712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1708: x_return_status => x_return_status,
1709: x_msg_count => x_msg_count,
1710: x_msg_data => x_msg_data);
1711:
1712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: END IF;
1715:
1716:

Line 1713: RAISE FND_API.G_EXC_ERROR;

1709: x_msg_count => x_msg_count,
1710: x_msg_data => x_msg_data);
1711:
1712: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1713: RAISE FND_API.G_EXC_ERROR;
1714: END IF;
1715:
1716:
1717: end loop;

Line 1738: WHEN fnd_api.g_exc_error THEN

1734:
1735:
1736: EXCEPTION
1737:
1738: WHEN fnd_api.g_exc_error THEN
1739: x_return_status := fnd_api.g_ret_sts_error;
1740:
1741: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1742: p_count => x_msg_count,

Line 1739: x_return_status := fnd_api.g_ret_sts_error;

1735:
1736: EXCEPTION
1737:
1738: WHEN fnd_api.g_exc_error THEN
1739: x_return_status := fnd_api.g_ret_sts_error;
1740:
1741: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1742: p_count => x_msg_count,
1743: p_data => x_msg_data);

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

1737:
1738: WHEN fnd_api.g_exc_error THEN
1739: x_return_status := fnd_api.g_ret_sts_error;
1740:
1741: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1742: p_count => x_msg_count,
1743: p_data => x_msg_data);
1744:
1745: -- Debug info.

Line 1757: WHEN fnd_api.g_exc_unexpected_error THEN

1753: hz_utility_v2pub.debug(p_message=>'get_v2_person_custs_updated(-)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757: WHEN fnd_api.g_exc_unexpected_error THEN
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759:
1760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1761: p_count => x_msg_count,

Line 1758: x_return_status := fnd_api.g_ret_sts_unexp_error;

1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757: WHEN fnd_api.g_exc_unexpected_error THEN
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759:
1760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data);

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

1756: END IF;
1757: WHEN fnd_api.g_exc_unexpected_error THEN
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759:
1760: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data);
1763:
1764: -- Debug info.

Line 1777: x_return_status := fnd_api.g_ret_sts_unexp_error;

1773: p_prefix=>l_debug_prefix,
1774: p_msg_level=>fnd_log.level_procedure);
1775: END IF;
1776: WHEN OTHERS THEN
1777: x_return_status := fnd_api.g_ret_sts_unexp_error;
1778:
1779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1780: fnd_message.set_token('ERROR' ,SQLERRM);
1781: fnd_msg_pub.add;

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

1779: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1780: fnd_message.set_token('ERROR' ,SQLERRM);
1781: fnd_msg_pub.add;
1782:
1783: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1784: p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:
1787: -- Debug info.

Line 2070: x_return_status := FND_API.G_RET_STS_SUCCESS;

2066: l_creation_date date;
2067:
2068: begin
2069: -- initialize API return status to success.
2070: x_return_status := FND_API.G_RET_STS_SUCCESS;
2071:
2072: open c2;
2073: fetch c2 into l_child_event_id, l_creation_date;
2074: close c2;

Line 2132: WHEN fnd_api.g_exc_unexpected_error THEN

2128:
2129: EXCEPTION
2130:
2131:
2132: WHEN fnd_api.g_exc_unexpected_error THEN
2133: x_return_status := fnd_api.g_ret_sts_unexp_error;
2134:
2135:
2136: WHEN OTHERS THEN

Line 2133: x_return_status := fnd_api.g_ret_sts_unexp_error;

2129: EXCEPTION
2130:
2131:
2132: WHEN fnd_api.g_exc_unexpected_error THEN
2133: x_return_status := fnd_api.g_ret_sts_unexp_error;
2134:
2135:
2136: WHEN OTHERS THEN
2137: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2137: x_return_status := fnd_api.g_ret_sts_unexp_error;

2133: x_return_status := fnd_api.g_ret_sts_unexp_error;
2134:
2135:
2136: WHEN OTHERS THEN
2137: x_return_status := fnd_api.g_ret_sts_unexp_error;
2138:
2139: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2140: fnd_message.set_token('ERROR' ,SQLERRM);
2141: fnd_msg_pub.add;

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

2156: -- IN:
2157: -- p_init_msg_list Initialize message stack if it is set to
2158: -- p_event_id BES Event identifier.
2159: -- p_person_cust_id Person customer identifier.
2160: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2161: -- OUT:
2162: -- x_person_cust_v2_obj One updated logical person.
2163: -- x_return_status Return status after the call. The status can
2164: -- be fnd_api.g_ret_sts_success (success),

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

2160: -- FND_API.G_TRUE. Default is FND_API.G_FALSE.
2161: -- OUT:
2162: -- x_person_cust_v2_obj One updated logical person.
2163: -- x_return_status Return status after the call. The status can
2164: -- be fnd_api.g_ret_sts_success (success),
2165: -- fnd_api.g_ret_sts_error (error),
2166: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2167: -- x_msg_count Number of messages in message stack.
2168: -- x_msg_data Message text if x_msg_count is 1.

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

2161: -- OUT:
2162: -- x_person_cust_v2_obj One updated logical person.
2163: -- x_return_status Return status after the call. The status can
2164: -- be fnd_api.g_ret_sts_success (success),
2165: -- fnd_api.g_ret_sts_error (error),
2166: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2167: -- x_msg_count Number of messages in message stack.
2168: -- x_msg_data Message text if x_msg_count is 1.
2169: --

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

2162: -- x_person_cust_v2_obj One updated logical person.
2163: -- x_return_status Return status after the call. The status can
2164: -- be fnd_api.g_ret_sts_success (success),
2165: -- fnd_api.g_ret_sts_error (error),
2166: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
2167: -- x_msg_count Number of messages in message stack.
2168: -- x_msg_data Message text if x_msg_count is 1.
2169: --
2170: -- NOTES

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

2174: -- 04-FEB-2008 vsegu Created.
2175: --
2176:
2177: PROCEDURE get_v2_person_cust_updated(
2178: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2179: p_event_id IN NUMBER,
2180: p_person_cust_id IN NUMBER,
2181: x_person_cust_v2_obj OUT NOCOPY HZ_PERSON_CUST_V2_BO,
2182: x_return_status OUT NOCOPY VARCHAR2,

Line 2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

2189: l_person_cust_obj HZ_PERSON_CUST_V2_BO;
2190: begin
2191:
2192: -- initialize API return status to success.
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: -- Initialize message list if p_init_msg_list is set to TRUE
2196: IF FND_API.to_Boolean(p_init_msg_list) THEN
2197: FND_MSG_PUB.initialize;

Line 2196: IF FND_API.to_Boolean(p_init_msg_list) THEN

2192: -- initialize API return status to success.
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: -- Initialize message list if p_init_msg_list is set to TRUE
2196: IF FND_API.to_Boolean(p_init_msg_list) THEN
2197: FND_MSG_PUB.initialize;
2198: END IF;
2199:
2200:

Line 2212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2208: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2209: p_party_id => p_person_cust_id,
2210: x_return_status => x_return_status);
2211:
2212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2213: RAISE FND_API.G_EXC_ERROR;
2214: END IF;
2215: */
2216: -- Set action type to 'UNCHANGED' by default

Line 2213: RAISE FND_API.G_EXC_ERROR;

2209: p_party_id => p_person_cust_id,
2210: x_return_status => x_return_status);
2211:
2212: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2213: RAISE FND_API.G_EXC_ERROR;
2214: END IF;
2215: */
2216: -- Set action type to 'UNCHANGED' by default
2217:

Line 2219: p_init_msg_list => fnd_api.g_false,

2215: */
2216: -- Set action type to 'UNCHANGED' by default
2217:
2218: get_person_cust_v2_bo(
2219: p_init_msg_list => fnd_api.g_false,
2220: p_person_id => p_person_cust_id,
2221: p_action_type => 'UNCHANGED',
2222: x_person_cust_v2_obj => x_person_cust_v2_obj,
2223: x_return_status => x_return_status,

Line 2227: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2223: x_return_status => x_return_status,
2224: x_msg_count => x_msg_count,
2225: x_msg_data => x_msg_data);
2226:
2227: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230:
2231:

Line 2228: RAISE FND_API.G_EXC_ERROR;

2224: x_msg_count => x_msg_count,
2225: x_msg_data => x_msg_data);
2226:
2227: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230:
2231:
2232: -- Based on BOT, for updated branch, set action_type = 'UPDATED'/'CREATED'

Line 2242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2238: x_return_status => x_return_status
2239: );
2240: x_person_cust_v2_obj := l_person_cust_obj;
2241:
2242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: END IF;
2245:
2246:

Line 2243: RAISE FND_API.G_EXC_ERROR;

2239: );
2240: x_person_cust_v2_obj := l_person_cust_obj;
2241:
2242: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2243: RAISE FND_API.G_EXC_ERROR;
2244: END IF;
2245:
2246:
2247:

Line 2266: WHEN fnd_api.g_exc_error THEN

2262:
2263:
2264: EXCEPTION
2265:
2266: WHEN fnd_api.g_exc_error THEN
2267: x_return_status := fnd_api.g_ret_sts_error;
2268:
2269: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2270: p_count => x_msg_count,

Line 2267: x_return_status := fnd_api.g_ret_sts_error;

2263:
2264: EXCEPTION
2265:
2266: WHEN fnd_api.g_exc_error THEN
2267: x_return_status := fnd_api.g_ret_sts_error;
2268:
2269: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2270: p_count => x_msg_count,
2271: p_data => x_msg_data);

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

2265:
2266: WHEN fnd_api.g_exc_error THEN
2267: x_return_status := fnd_api.g_ret_sts_error;
2268:
2269: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2270: p_count => x_msg_count,
2271: p_data => x_msg_data);
2272:
2273: -- Debug info.

Line 2285: WHEN fnd_api.g_exc_unexpected_error THEN

2281: hz_utility_v2pub.debug(p_message=>'get_v2_person_cust_updated(-)',
2282: p_prefix=>l_debug_prefix,
2283: p_msg_level=>fnd_log.level_procedure);
2284: END IF;
2285: WHEN fnd_api.g_exc_unexpected_error THEN
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2289: p_count => x_msg_count,

Line 2286: x_return_status := fnd_api.g_ret_sts_unexp_error;

2282: p_prefix=>l_debug_prefix,
2283: p_msg_level=>fnd_log.level_procedure);
2284: END IF;
2285: WHEN fnd_api.g_exc_unexpected_error THEN
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2289: p_count => x_msg_count,
2290: p_data => x_msg_data);

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

2284: END IF;
2285: WHEN fnd_api.g_exc_unexpected_error THEN
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287:
2288: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2289: p_count => x_msg_count,
2290: p_data => x_msg_data);
2291:
2292: -- Debug info.

Line 2305: x_return_status := fnd_api.g_ret_sts_unexp_error;

2301: p_prefix=>l_debug_prefix,
2302: p_msg_level=>fnd_log.level_procedure);
2303: END IF;
2304: WHEN OTHERS THEN
2305: x_return_status := fnd_api.g_ret_sts_unexp_error;
2306:
2307: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2308: fnd_message.set_token('ERROR' ,SQLERRM);
2309: fnd_msg_pub.add;

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

2307: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2308: fnd_message.set_token('ERROR' ,SQLERRM);
2309: fnd_msg_pub.add;
2310:
2311: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2312: p_count => x_msg_count,
2313: p_data => x_msg_data);
2314:
2315: -- Debug info.