APPS.ASO_PARTY_INT dependencies on FND_API

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: l_msg_data VARCHAR2(2000);
54: BEGIN
55: SAVEPOINT CREATE_PARTY_PVT;
56: -- Initialize API return status to SUCCESS
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: -- Initializing the created_by_module column for all the records as per
60: -- changes in version 2 api's.
61:

Line 70: AND p_party_rec.party_name <> FND_API.G_MISS_CHAR THEN

66: --l_party_rec.TOTAL_NUM_OF_ORDERS := 0;
67:
68: IF p_party_rec.party_type = 'ORGANIZATION'
69: AND p_party_rec.party_name IS NOT NULL
70: AND p_party_rec.party_name <> FND_API.G_MISS_CHAR THEN
71: l_organization_rec.organization_name := p_party_rec.party_name;
72: l_organization_rec.curr_fy_potential_revenue := p_party_rec.curr_fy_potential_revenue;
73: l_organization_rec.employees_total := p_party_rec.num_of_employees;
74: l_organization_rec.party_rec := l_party_rec;

Line 81: p_init_msg_list => FND_API.G_FALSE,

77: Original Call: HZ_PARTY_PUB.Create_Organization
78: */
79:
80: HZ_PARTY_V2PUB.create_organization (
81: p_init_msg_list => FND_API.G_FALSE,
82: p_organization_rec => l_organization_rec,
83: x_return_status => x_return_status,
84: x_msg_count => x_msg_count,
85: x_msg_data => x_msg_data,

Line 96: AND p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN

92: aso_debug_pub.add('create_party:after create_org:x_return_status '||x_return_status, 1, 'N');
93: END IF;
94: ELSIF p_party_rec.party_type = 'PERSON'
95: AND p_party_rec.person_first_name IS NOT NULL
96: AND p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN
97: /*
98: Column Names have been changed in version 2 api's
99:
100: l_person_rec.pre_name_adjunct := p_party_rec.person_title;

Line 121: p_init_msg_list => FND_API.G_FALSE,

117: Original Call: HZ_PARTY_PUB.Create_Person
118: */
119:
120: HZ_PARTY_V2PUB.create_person (
121: p_init_msg_list => FND_API.G_FALSE,
122: p_person_rec => l_person_rec,
123: x_party_id => x_party_id,
124: x_party_number => l_party_number,
125: x_profile_id => l_profile_id,

Line 135: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

131: aso_debug_pub.add('create_party:after create_per:x_return_status '||x_return_status, 1, 'N');
132: aso_debug_pub.add('create_party:after create_per:x_party_id '||x_party_id, 1, 'N');
133: END IF;
134: END IF;
135: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: EXCEPTION

Line 136: RAISE FND_API.G_EXC_ERROR;

132: aso_debug_pub.add('create_party:after create_per:x_party_id '||x_party_id, 1, 'N');
133: END IF;
134: END IF;
135: if x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: EXCEPTION
140: WHEN FND_API.G_EXC_ERROR THEN

Line 140: WHEN FND_API.G_EXC_ERROR THEN

136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: EXCEPTION
140: WHEN FND_API.G_EXC_ERROR THEN
141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
152: P_API_NAME => L_API_NAME
153: ,P_PKG_NAME => G_PKG_NAME
154: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS;

200:
201: BEGIN
202: SAVEPOINT CREATE_PARTY_SITE_PVT;
203: -- Initialize API return status to SUCCESS
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205:
206:
207: -- Initializing the created_by_module column for all the records as per
208: -- changes in version 2 api's.

Line 237: p_init_msg_list => FND_API.G_FALSE,

233:
234: */
235:
236: HZ_LOCATION_V2PUB.create_location (
237: p_init_msg_list => FND_API.G_FALSE,
238: p_location_rec => l_location_rec,
239: x_location_id => l_location_id,
240: x_return_status => x_return_status,
241: x_msg_count => x_msg_count ,

Line 248: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

244: IF aso_debug_pub.g_debug_flag = 'Y' THEN
245: aso_debug_pub.add('create_party_site:after create_loc:l_location_id '||l_location_id, 1, 'N');
246: aso_debug_pub.add('create_party_site:after create_loc:x_return_status '||x_return_status, 1, 'N');
247: END IF;
248: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
249:
250: l_party_site_rec.party_id := p_party_site_rec.party_id;
251: l_party_site_rec.location_id := l_location_id;
252: l_party_site_rec.identifying_address_flag := p_party_site_rec.primary_flag;

Line 260: p_init_msg_list => FND_API.G_FALSE,

256: Original Call: HZ_PARTY_PUB.Create_Party_Site
257: */
258:
259: HZ_PARTY_SITE_V2PUB.create_party_site (
260: p_init_msg_list => FND_API.G_FALSE,
261: p_party_site_rec => l_party_site_rec,
262: x_party_site_id => x_party_site_id,
263: x_party_site_number => l_party_site_number,
264: x_return_status => x_return_status,

Line 273: RAISE FND_API.G_EXC_ERROR;

269: aso_debug_pub.add('create_party_site:after create_site:x_party_site_id '||x_party_site_id, 1, 'N');
270: aso_debug_pub.add('create_party_site:after create_site:x_return_status '||x_return_status, 1, 'N');
271: END IF;
272: else
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
276:
277: l_party_site_use_rec.party_site_id := x_party_site_id;

Line 275: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

271: END IF;
272: else
273: RAISE FND_API.G_EXC_ERROR;
274: END IF;
275: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
276:
277: l_party_site_use_rec.party_site_id := x_party_site_id;
278: -- l_party_site_use_rec.begin_date := sysdate;
279: l_party_site_use_rec.site_use_type := p_party_site_rec.party_site_use_type;

Line 288: p_init_msg_list => FND_API.G_FALSE,

284: Original Call: HZ_PARTY_PUB.Create_Party_Site_Use
285: */
286:
287: HZ_PARTY_SITE_V2PUB.create_party_site_use (
288: p_init_msg_list => FND_API.G_FALSE,
289: p_party_site_use_rec => l_party_site_use_rec,
290: x_party_site_use_id => l_party_site_use_id,
291: x_return_status => x_return_status,
292: x_msg_count => x_msg_count,

Line 301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

297: aso_debug_pub.add('create_party_site:after create_site_use:x_return_status '||x_return_status, 1, 'N');
298: aso_debug_pub.add('create_party_site:after create_site_use:l_party_site_use_id '||l_party_site_use_id, 1, 'N
299: ');
300: END IF;
301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: else

Line 302: RAISE FND_API.G_EXC_ERROR;

298: aso_debug_pub.add('create_party_site:after create_site_use:l_party_site_use_id '||l_party_site_use_id, 1, 'N
299: ');
300: END IF;
301: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: else
306: RAISE FND_API.G_EXC_ERROR;

Line 306: RAISE FND_API.G_EXC_ERROR;

302: RAISE FND_API.G_EXC_ERROR;
303: END IF;
304:
305: else
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN

Line 310: WHEN FND_API.G_EXC_ERROR THEN

306: RAISE FND_API.G_EXC_ERROR;
307: END IF;
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
312: P_API_NAME => L_API_NAME
313: ,P_PKG_NAME => G_PKG_NAME
314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
316: ,X_MSG_COUNT => X_MSG_COUNT
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
321: P_API_NAME => L_API_NAME
322: ,P_PKG_NAME => G_PKG_NAME
323: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 377: x_return_status := FND_API.G_RET_STS_SUCCESS;

373: l_party_rel_last_update_date DATE;
374: begin
375: SAVEPOINT UPDATE_PARTY_PVT;
376: -- Initialize API return status to SUCCESS
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: -- Initializing the created_by_module column for all the records as per
380: -- changes in version 2 api's.
381:

Line 388: IF p_party_rec.party_id <> FND_API.G_MISS_NUM THEN

384:
385: --l_party_rec.TOTAL_NUM_OF_ORDERS := p_party_rec.TOTAL_NUM_OF_ORDERS;
386: if p_party_rec.PARTY_TYPE = 'PERSON' then
387: l_person_rec.party_rec := l_party_rec;
388: IF p_party_rec.party_id <> FND_API.G_MISS_NUM THEN
389: l_person_rec.party_rec.party_id := p_party_rec.party_id;
390: END IF;
391: IF p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN
392: l_person_rec.person_FIRST_NAME := p_party_rec.person_first_name;

Line 391: IF p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN

387: l_person_rec.party_rec := l_party_rec;
388: IF p_party_rec.party_id <> FND_API.G_MISS_NUM THEN
389: l_person_rec.party_rec.party_id := p_party_rec.party_id;
390: END IF;
391: IF p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN
392: l_person_rec.person_FIRST_NAME := p_party_rec.person_first_name;
393: END IF;
394: IF p_party_rec.person_middle_name <> FND_API.G_MISS_CHAR THEN
395: l_person_rec.person_MIDDLE_NAME := p_party_rec.person_middle_name;

Line 394: IF p_party_rec.person_middle_name <> FND_API.G_MISS_CHAR THEN

390: END IF;
391: IF p_party_rec.person_first_name <> FND_API.G_MISS_CHAR THEN
392: l_person_rec.person_FIRST_NAME := p_party_rec.person_first_name;
393: END IF;
394: IF p_party_rec.person_middle_name <> FND_API.G_MISS_CHAR THEN
395: l_person_rec.person_MIDDLE_NAME := p_party_rec.person_middle_name;
396: END IF;
397: IF p_party_rec.person_last_name <> FND_API.G_MISS_CHAR THEN
398: l_person_rec.person_LAST_NAME := p_party_rec.person_last_name;

Line 397: IF p_party_rec.person_last_name <> FND_API.G_MISS_CHAR THEN

393: END IF;
394: IF p_party_rec.person_middle_name <> FND_API.G_MISS_CHAR THEN
395: l_person_rec.person_MIDDLE_NAME := p_party_rec.person_middle_name;
396: END IF;
397: IF p_party_rec.person_last_name <> FND_API.G_MISS_CHAR THEN
398: l_person_rec.person_LAST_NAME := p_party_rec.person_last_name;
399: END IF;
400: IF p_party_rec.person_title <> FND_API.G_MISS_CHAR THEN
401: l_person_rec.person_TITLE := p_party_rec.person_title;

Line 400: IF p_party_rec.person_title <> FND_API.G_MISS_CHAR THEN

396: END IF;
397: IF p_party_rec.person_last_name <> FND_API.G_MISS_CHAR THEN
398: l_person_rec.person_LAST_NAME := p_party_rec.person_last_name;
399: END IF;
400: IF p_party_rec.person_title <> FND_API.G_MISS_CHAR THEN
401: l_person_rec.person_TITLE := p_party_rec.person_title;
402: END IF;
403: IF p_party_rec.DATE_OF_BIRTH <> FND_API.G_MISS_DATE THEN
404: l_person_rec.DATE_OF_BIRTH := p_party_rec.DATE_OF_BIRTH;

Line 403: IF p_party_rec.DATE_OF_BIRTH <> FND_API.G_MISS_DATE THEN

399: END IF;
400: IF p_party_rec.person_title <> FND_API.G_MISS_CHAR THEN
401: l_person_rec.person_TITLE := p_party_rec.person_title;
402: END IF;
403: IF p_party_rec.DATE_OF_BIRTH <> FND_API.G_MISS_DATE THEN
404: l_person_rec.DATE_OF_BIRTH := p_party_rec.DATE_OF_BIRTH;
405: END IF;
406: IF p_party_rec.person_known_as <> FND_API.G_MISS_CHAR THEN
407: l_person_rec.KNOWN_AS := p_party_rec.person_known_as;

Line 406: IF p_party_rec.person_known_as <> FND_API.G_MISS_CHAR THEN

402: END IF;
403: IF p_party_rec.DATE_OF_BIRTH <> FND_API.G_MISS_DATE THEN
404: l_person_rec.DATE_OF_BIRTH := p_party_rec.DATE_OF_BIRTH;
405: END IF;
406: IF p_party_rec.person_known_as <> FND_API.G_MISS_CHAR THEN
407: l_person_rec.KNOWN_AS := p_party_rec.person_known_as;
408: END IF;
409: IF p_party_rec.PERSONAL_INCOME <> FND_API.G_MISS_NUM THEN
410: l_person_rec.PERSONAL_INCOME := p_party_rec.PERSONAL_INCOME;

Line 409: IF p_party_rec.PERSONAL_INCOME <> FND_API.G_MISS_NUM THEN

405: END IF;
406: IF p_party_rec.person_known_as <> FND_API.G_MISS_CHAR THEN
407: l_person_rec.KNOWN_AS := p_party_rec.person_known_as;
408: END IF;
409: IF p_party_rec.PERSONAL_INCOME <> FND_API.G_MISS_NUM THEN
410: l_person_rec.PERSONAL_INCOME := p_party_rec.PERSONAL_INCOME;
411: END IF;
412: l_last_update_date := p_party_rec.LAST_UPDATE_DATE;
413:

Line 424: l_party_object_version_number := FND_API.G_MISS_NUM;

420: -- This is used by API to lock the object being updated
421:
422: BEGIN
423: -- Intialize the variable as it used multiple times in this procedure
424: l_party_object_version_number := FND_API.G_MISS_NUM;
425:
426: SELECT OBJECT_VERSION_NUMBER
427: INTO l_party_object_version_number
428: FROM HZ_PARTIES

Line 433: l_party_object_version_number := FND_API.G_MISS_NUM;

429: WHERE PARTY_ID = p_party_rec.party_id;
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: l_party_object_version_number := FND_API.G_MISS_NUM;
434: END;
435:
436: IF aso_debug_pub.g_debug_flag = 'Y' THEN
437: aso_debug_pub.add('update_pty:before update_per', 1, 'N');

Line 442: p_init_msg_list => FND_API.G_FALSE,

438: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
439: END IF;
440:
441: HZ_PARTY_V2PUB.update_person (
442: p_init_msg_list => FND_API.G_FALSE,
443: p_person_rec => l_PERSON_REC,
444: p_party_object_version_number => l_party_object_version_number,
445: x_profile_id => l_profile_id,
446: x_return_status => x_return_status,

Line 458: -- AND p_party_rec.party_name <> FND_API.G_MISS_CHAR THEN

454: END IF;
455:
456: elsif p_party_rec.party_type = 'ORGANIZATION' THEN
457: -- AND p_party_rec.party_name IS NOT NULL
458: -- AND p_party_rec.party_name <> FND_API.G_MISS_CHAR THEN
459: l_organization_rec.party_rec := l_party_rec;
460: l_organization_rec.party_rec.party_id := p_party_rec.party_id;
461: -- l_organization_rec.ORGANIZATION_NAME := p_party_rec.party_name;
462: l_organization_rec.CURR_FY_POTENTIAL_REVENUE := p_party_rec.CURR_FY_POTENTIAL_REVENUE;

Line 477: l_party_object_version_number := FND_API.G_MISS_NUM;

473: -- This is used by API to lock the object being updated
474:
475: BEGIN
476: -- Intialize the variable as it used multiple times in this procedure
477: l_party_object_version_number := FND_API.G_MISS_NUM;
478:
479: SELECT OBJECT_VERSION_NUMBER
480: INTO l_party_object_version_number
481: FROM HZ_PARTIES

Line 486: l_party_object_version_number := FND_API.G_MISS_NUM;

482: WHERE PARTY_ID = p_party_rec.party_id;
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: l_party_object_version_number := FND_API.G_MISS_NUM;
487: END;
488:
489: IF aso_debug_pub.g_debug_flag = 'Y' THEN
490: aso_debug_pub.add('update_pty:before update_organization', 1, 'N');

Line 496: p_init_msg_list => FND_API.G_FALSE,

492: END IF;
493:
494:
495: HZ_PARTY_V2PUB.update_organization (
496: p_init_msg_list => FND_API.G_FALSE,
497: p_organization_rec => l_organization_rec ,
498: p_party_object_version_number => l_party_object_version_number,
499: x_profile_id => l_profile_id ,
500: x_return_status => x_return_status ,

Line 535: l_party_object_version_number := FND_API.G_MISS_NUM;

531: -- This is used by API to lock the object being updated
532:
533: BEGIN
534: -- Intialize the variable as it used multiple times in this procedure
535: l_party_object_version_number := FND_API.G_MISS_NUM;
536:
537: SELECT OBJECT_VERSION_NUMBER
538: INTO l_party_object_version_number
539: FROM HZ_PARTIES

Line 550: l_party_object_version_number := FND_API.G_MISS_NUM;

546: AND DIRECTIONAL_FLAG = 'F';
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: l_party_object_version_number := FND_API.G_MISS_NUM;
551: l_object_version_number := FND_API.G_MISS_NUM;
552: END;
553:
554: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 551: l_object_version_number := FND_API.G_MISS_NUM;

547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: l_party_object_version_number := FND_API.G_MISS_NUM;
551: l_object_version_number := FND_API.G_MISS_NUM;
552: END;
553:
554: IF aso_debug_pub.g_debug_flag = 'Y' THEN
555: aso_debug_pub.add('update_pty:before update_reltn', 1, 'N');

Line 560: p_init_msg_list => FND_API.G_FALSE,

556: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
557: END IF;
558:
559: HZ_RELATIONSHIP_V2PUB.update_relationship (
560: p_init_msg_list => FND_API.G_FALSE,
561: p_relationship_rec => l_party_rel_rec ,
562: p_object_version_number => l_object_version_number,
563: p_party_object_version_number => l_party_object_version_number,
564: x_return_status => x_return_status,

Line 577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

573: aso_debug_pub.add('update_pty:after update_reltn:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
574: END IF;
575: end if; -- end party type
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: EXCEPTION

Line 578: RAISE FND_API.G_EXC_ERROR;

574: END IF;
575: end if; -- end party type
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: EXCEPTION
582: WHEN FND_API.G_EXC_ERROR THEN

Line 582: WHEN FND_API.G_EXC_ERROR THEN

578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: EXCEPTION
582: WHEN FND_API.G_EXC_ERROR THEN
583: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
584: P_API_NAME => L_API_NAME
585: ,P_PKG_NAME => G_PKG_NAME
586: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

588: ,X_MSG_COUNT => X_MSG_COUNT
589: ,X_MSG_DATA => X_MSG_DATA
590: ,X_RETURN_STATUS => X_RETURN_STATUS);
591:
592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
593: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
594: P_API_NAME => L_API_NAME
595: ,P_PKG_NAME => G_PKG_NAME
596: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 634: IF FND_API.to_Boolean( p_init_msg_list ) THEN

630: l_termination_date DATE;
631: BEGIN
632: SAVEPOINT VALIDATE_CUSTACCOUNT_PVT;
633: -- Initialize message list if p_init_msg_list is set to TRUE.
634: IF FND_API.to_Boolean( p_init_msg_list ) THEN
635: FND_MSG_PUB.initialize;
636: END IF;
637:
638: -- Initialize API return status to success

Line 639: x_return_status := FND_API.G_RET_STS_SUCCESS;

635: FND_MSG_PUB.initialize;
636: END IF;
637:
638: -- Initialize API return status to success
639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640: IF aso_debug_pub.g_debug_flag = 'Y' THEN
641: aso_debug_pub.add('validate cust_acct:p_cust_account_id '||p_cust_account_id, 1, 'N');
642: END IF;
643: IF (p_cust_account_id IS NOT NULL AND p_cust_account_id <> FND_API.G_MISS_NUM) THEN

Line 643: IF (p_cust_account_id IS NOT NULL AND p_cust_account_id <> FND_API.G_MISS_NUM) THEN

639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640: IF aso_debug_pub.g_debug_flag = 'Y' THEN
641: aso_debug_pub.add('validate cust_acct:p_cust_account_id '||p_cust_account_id, 1, 'N');
642: END IF;
643: IF (p_cust_account_id IS NOT NULL AND p_cust_account_id <> FND_API.G_MISS_NUM) THEN
644: OPEN C_Account;
645: FETCH C_Account INTO l_account_status, l_activation_date, l_termination_date;
646: IF (C_Account%NOTFOUND OR
647: (sysdate NOT BETWEEN NVL(l_activation_date, sysdate) AND

Line 650: x_return_status := FND_API.G_RET_STS_ERROR;

646: IF (C_Account%NOTFOUND OR
647: (sysdate NOT BETWEEN NVL(l_activation_date, sysdate) AND
648: NVL(l_termination_date, sysdate))OR
649: l_account_status <> 'A') THEN
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
652: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
653: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT', FALSE);
654: FND_MSG_PUB.ADD;

Line 663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

659:
660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
661: aso_debug_pub.add('validate cust_acct:x_return_status '||x_return_status, 1, 'N');
662: END IF;
663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: EXCEPTION

Line 664: RAISE FND_API.G_EXC_ERROR;

660: IF aso_debug_pub.g_debug_flag = 'Y' THEN
661: aso_debug_pub.add('validate cust_acct:x_return_status '||x_return_status, 1, 'N');
662: END IF;
663: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN

Line 668: WHEN FND_API.G_EXC_ERROR THEN

664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: EXCEPTION
668: WHEN FND_API.G_EXC_ERROR THEN
669: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
670: P_API_NAME => L_API_NAME
671: ,P_PKG_NAME => G_PKG_NAME
672: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

674: ,X_MSG_COUNT => X_MSG_COUNT
675: ,X_MSG_DATA => X_MSG_DATA
676: ,X_RETURN_STATUS => X_RETURN_STATUS);
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
680: P_API_NAME => L_API_NAME
681: ,P_PKG_NAME => G_PKG_NAME
682: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 702: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

698:
699:
700: PROCEDURE Create_Customer_Account(
701: p_api_version IN NUMBER
702: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
703: ,p_commit IN VARCHAR2 := FND_API.g_false
704: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
705: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
706: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM

Line 703: ,p_commit IN VARCHAR2 := FND_API.g_false

699:
700: PROCEDURE Create_Customer_Account(
701: p_api_version IN NUMBER
702: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
703: ,p_commit IN VARCHAR2 := FND_API.g_false
704: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
705: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
706: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
707: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 704: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

700: PROCEDURE Create_Customer_Account(
701: p_api_version IN NUMBER
702: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
703: ,p_commit IN VARCHAR2 := FND_API.g_false
704: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
705: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
706: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
707: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
708: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 706: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM

702: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
703: ,p_commit IN VARCHAR2 := FND_API.g_false
704: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
705: ,P_Qte_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
706: ,P_Account_number IN NUMBER := FND_API.G_MISS_NUM
707: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
708: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
709: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
710: ,x_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 773: IF FND_API.to_boolean(p_init_msg_list) THEN

769: SAVEPOINT CREATE_CUSTOMER_ACCOUNT_PVT;
770:
771: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
772:
773: IF FND_API.to_boolean(p_init_msg_list) THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776: IF NOT FND_API.compatible_api_call(
777: l_api_version,

Line 776: IF NOT FND_API.compatible_api_call(

772:
773: IF FND_API.to_boolean(p_init_msg_list) THEN
774: FND_MSG_PUB.initialize;
775: END IF;
776: IF NOT FND_API.compatible_api_call(
777: l_api_version,
778: p_api_version,
779: l_api_name,
780: g_pkg_name

Line 782: RAISE FND_API.g_exc_unexpected_error;

778: p_api_version,
779: l_api_name,
780: g_pkg_name
781: ) THEN
782: RAISE FND_API.g_exc_unexpected_error;
783: END IF;
784: x_return_status := FND_API.g_ret_sts_success;
785:
786: -- Initializing the created_by_module column for all the records as per

Line 784: x_return_status := FND_API.g_ret_sts_success;

780: g_pkg_name
781: ) THEN
782: RAISE FND_API.g_exc_unexpected_error;
783: END IF;
784: x_return_status := FND_API.g_ret_sts_success;
785:
786: -- Initializing the created_by_module column for all the records as per
787: -- changes in version 2 api's.
788:

Line 801: IF l_gen_cust_num = 'N' and p_account_number <> FND_API.G_MISS_NUM THEN

797:
798: -- typically should be set to 'Y' if no we will try to create a new one.
799: -- however, this could error out
800:
801: IF l_gen_cust_num = 'N' and p_account_number <> FND_API.G_MISS_NUM THEN
802:
803: account_rec.account_number := p_account_number;
804:
805: ELSIF l_gen_cust_num = 'N'

Line 806: and ( p_account_number = FND_API.G_MISS_NUM

802:
803: account_rec.account_number := p_account_number;
804:
805: ELSIF l_gen_cust_num = 'N'
806: and ( p_account_number = FND_API.G_MISS_NUM
807: or p_account_number is null) THEN
808:
809: OPEN C_acct_number;
810: FETCH C_acct_number into account_rec.account_number;

Line 827: raise FND_API.G_EXC_ERROR;

823: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
824: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
825: FND_MSG_PUB.ADD;
826: END IF;
827: raise FND_API.G_EXC_ERROR;
828: END IF;
829: CLOSE C_party_info;
830:
831: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 854: AND p_qte_rec.marketing_source_code_id <> FND_API.G_MISS_NUM THEN

850: account_rec.account_name := substr(l_party_name,1,240);
851:
852: -- if marketing source code is valid then pass the source code
853: IF p_qte_rec.marketing_source_code is not NULL
854: AND p_qte_rec.marketing_source_code_id <> FND_API.G_MISS_NUM THEN
855:
856: OPEN C_source_codes( p_qte_rec.marketing_source_code_id);
857: FETCH C_source_codes INTO account_rec.source_code;
858: IF (C_source_codes%NOTFOUND) THEN

Line 889: p_init_msg_list => FND_API.G_FALSE,

885: Original Call: hz_customer_accounts_pub.create_account
886: */
887:
888: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
889: p_init_msg_list => FND_API.G_FALSE,
890: p_cust_account_rec => account_rec,
891: p_person_rec => person_rec,
892: p_customer_profile_rec => cust_profile_rec,
893: p_create_profile_amt => 'Y',

Line 919: p_init_msg_list => FND_API.G_FALSE,

915:
916: Original Call: hz_customer_accounts_pub.create_account
917: */
918: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
919: p_init_msg_list => FND_API.G_FALSE,
920: p_cust_account_rec => account_rec,
921: p_organization_rec => organization_rec,
922: p_customer_profile_rec => cust_profile_rec,
923: p_create_profile_amt => 'Y',

Line 939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

935: END IF;
936: END IF;
937:
938:
939: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
940: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;

Line 945: raise FND_API.G_EXC_ERROR;

941: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
942: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
943: FND_MSG_PUB.ADD;
944: END IF;
945: raise FND_API.G_EXC_ERROR;
946: ELSE
947: x_acct_id := l_acct_id;
948: END IF;
949: FND_MSG_PUB.Count_And_Get

Line 955: WHEN FND_API.G_EXC_ERROR THEN

951: p_data => x_msg_data
952: );
953:
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
957: P_API_NAME => L_API_NAME
958: ,P_PKG_NAME => G_PKG_NAME
959: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

963: ,X_MSG_COUNT => X_MSG_COUNT
964: ,X_MSG_DATA => X_MSG_DATA
965: ,X_RETURN_STATUS => X_RETURN_STATUS);
966:
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
969: P_API_NAME => L_API_NAME
970: ,P_PKG_NAME => G_PKG_NAME
971: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 995: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

991: END Create_Customer_Account;
992:
993:
994: PROCEDURE Create_ACCT_SITE ( p_api_version IN NUMBER
995: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
996: ,p_commit IN VARCHAR2 := FND_API.g_false
997: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
998: ,p_Cust_Account_Id NUMBER
999: ,p_Party_Site_Id NUMBER

Line 996: ,p_commit IN VARCHAR2 := FND_API.g_false

992:
993:
994: PROCEDURE Create_ACCT_SITE ( p_api_version IN NUMBER
995: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
996: ,p_commit IN VARCHAR2 := FND_API.g_false
997: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
998: ,p_Cust_Account_Id NUMBER
999: ,p_Party_Site_Id NUMBER
1000: ,p_Acct_site VARCHAR2 := 'NONE'

Line 997: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

993:
994: PROCEDURE Create_ACCT_SITE ( p_api_version IN NUMBER
995: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
996: ,p_commit IN VARCHAR2 := FND_API.g_false
997: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
998: ,p_Cust_Account_Id NUMBER
999: ,p_Party_Site_Id NUMBER
1000: ,p_Acct_site VARCHAR2 := 'NONE'
1001: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1029: IF FND_API.to_boolean(p_init_msg_list) THEN

1025:
1026: SAVEPOINT CREATE_ACCT_SITE_PVT;
1027:
1028:
1029: IF FND_API.to_boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize;
1031: END IF;
1032: IF NOT FND_API.compatible_api_call(
1033: l_api_version,

Line 1032: IF NOT FND_API.compatible_api_call(

1028:
1029: IF FND_API.to_boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize;
1031: END IF;
1032: IF NOT FND_API.compatible_api_call(
1033: l_api_version,
1034: p_api_version,
1035: l_api_name,
1036: g_pkg_name

Line 1038: RAISE FND_API.g_exc_unexpected_error;

1034: p_api_version,
1035: l_api_name,
1036: g_pkg_name
1037: ) THEN
1038: RAISE FND_API.g_exc_unexpected_error;
1039: END IF;
1040: x_return_status := FND_API.g_ret_sts_success;
1041:
1042: -- Intializing created_by_module as required in version 2 api for the record structure

Line 1040: x_return_status := FND_API.g_ret_sts_success;

1036: g_pkg_name
1037: ) THEN
1038: RAISE FND_API.g_exc_unexpected_error;
1039: END IF;
1040: x_return_status := FND_API.g_ret_sts_success;
1041:
1042: -- Intializing created_by_module as required in version 2 api for the record structure
1043:
1044: p_acct_site_Rec.created_by_module := 'ASO_CUSTOMER_DATA';

Line 1070: p_init_msg_list => FND_API.G_FALSE,

1066: Original Call: hz_customer_accounts_pub.create_account_site
1067: */
1068:
1069: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_acct_site (
1070: p_init_msg_list => FND_API.G_FALSE,
1071: p_cust_acct_site_rec => p_acct_site_rec,
1072: x_cust_acct_site_id => l_customer_site_id,
1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,

Line 1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1077: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1078: aso_debug_pub.add('create acct_site:after create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');
1079: aso_debug_pub.add('create acct_site:after create_site:x_return_status '||x_return_status, 1, 'N');
1080: END IF;
1081: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;

Line 1087: raise FND_API.G_EXC_ERROR;

1083: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1084: FND_MESSAGE.Set_Token('COLUMN', 'ACCT SITE', FALSE);
1085: FND_MSG_PUB.ADD;
1086: END IF;
1087: raise FND_API.G_EXC_ERROR;
1088: ELSE
1089: x_customer_site_id := l_customer_site_id ;
1090: END IF;
1091:

Line 1099: WHEN FND_API.G_EXC_ERROR THEN

1095: p_data => x_msg_data
1096: );
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1101: P_API_NAME => L_API_NAME
1102: ,P_PKG_NAME => G_PKG_NAME
1103: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1107: ,X_MSG_COUNT => X_MSG_COUNT
1108: ,X_MSG_DATA => X_MSG_DATA
1109: ,X_RETURN_STATUS => X_RETURN_STATUS);
1110:
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1113: P_API_NAME => L_API_NAME
1114: ,P_PKG_NAME => G_PKG_NAME
1115: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1139: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1135:
1136:
1137: PROCEDURE Create_ACCT_SITE_USES (
1138: p_api_version IN NUMBER
1139: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1140: ,p_commit IN VARCHAR2 := FND_API.g_false
1141: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1142: ,P_Cust_Account_Id IN NUMBER
1143: ,P_Party_Site_Id IN NUMBER

Line 1140: ,p_commit IN VARCHAR2 := FND_API.g_false

1136:
1137: PROCEDURE Create_ACCT_SITE_USES (
1138: p_api_version IN NUMBER
1139: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1140: ,p_commit IN VARCHAR2 := FND_API.g_false
1141: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1142: ,P_Cust_Account_Id IN NUMBER
1143: ,P_Party_Site_Id IN NUMBER
1144: ,P_cust_acct_site_id IN NUMBER := NULL

Line 1141: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1137: PROCEDURE Create_ACCT_SITE_USES (
1138: p_api_version IN NUMBER
1139: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1140: ,p_commit IN VARCHAR2 := FND_API.g_false
1141: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1142: ,P_Cust_Account_Id IN NUMBER
1143: ,P_Party_Site_Id IN NUMBER
1144: ,P_cust_acct_site_id IN NUMBER := NULL
1145: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'

Line 1202: IF FND_API.to_boolean(p_init_msg_list) THEN

1198: ---- Initialize---------------------
1199:
1200: SAVEPOINT CREATE_ACCT_SITE_USES_PVT;
1201:
1202: IF FND_API.to_boolean(p_init_msg_list) THEN
1203: FND_MSG_PUB.initialize;
1204: END IF;
1205:
1206: IF NOT FND_API.compatible_api_call(

Line 1206: IF NOT FND_API.compatible_api_call(

1202: IF FND_API.to_boolean(p_init_msg_list) THEN
1203: FND_MSG_PUB.initialize;
1204: END IF;
1205:
1206: IF NOT FND_API.compatible_api_call(
1207: l_api_version,
1208: p_api_version,
1209: l_api_name,
1210: g_pkg_name

Line 1212: RAISE FND_API.g_exc_unexpected_error;

1208: p_api_version,
1209: l_api_name,
1210: g_pkg_name
1211: ) THEN
1212: RAISE FND_API.g_exc_unexpected_error;
1213: END IF;
1214: x_return_status := FND_API.g_ret_sts_success;
1215:
1216: -- Intializing created_by_module as required in version 2 api for the record structure

Line 1214: x_return_status := FND_API.g_ret_sts_success;

1210: g_pkg_name
1211: ) THEN
1212: RAISE FND_API.g_exc_unexpected_error;
1213: END IF;
1214: x_return_status := FND_API.g_ret_sts_success;
1215:
1216: -- Intializing created_by_module as required in version 2 api for the record structure
1217:
1218: p_acct_site_uses_Rec.created_by_module := 'ASO_CUSTOMER_DATA';

Line 1225: (p_cust_acct_site_id = FND_API.G_MISS_NUM) THEN

1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('create acct_site_use:p_cust_acct_site_id '||p_cust_acct_site_id, 1, 'N');
1223: END IF;
1224: IF (p_cust_acct_site_id IS NULL) OR
1225: (p_cust_acct_site_id = FND_API.G_MISS_NUM) THEN
1226: Create_ACCT_SITE(p_api_version => 1.0
1227: ,p_Cust_Account_Id => l_cust_account_id
1228: ,p_Party_Site_Id => l_party_site_id
1229: ,p_Acct_site => l_Acct_Site_type

Line 1238: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1234: ) ;
1235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1236: aso_debug_pub.add('create acct_site_use:after create_site:x_cust_acct_site_id '||x_cust_acct_site_id, 1, 'N');
1237: END IF;
1238: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1239: raise FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242:

Line 1239: raise FND_API.G_EXC_ERROR;

1235: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1236: aso_debug_pub.add('create acct_site_use:after create_site:x_cust_acct_site_id '||x_cust_acct_site_id, 1, 'N');
1237: END IF;
1238: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1239: raise FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242:
1243: IF x_cust_acct_site_id is not null and x_cust_acct_site_id <> FND_API.G_MISS_NUM then

Line 1243: IF x_cust_acct_site_id is not null and x_cust_acct_site_id <> FND_API.G_MISS_NUM then

1239: raise FND_API.G_EXC_ERROR;
1240: END IF;
1241: END IF;
1242:
1243: IF x_cust_acct_site_id is not null and x_cust_acct_site_id <> FND_API.G_MISS_NUM then
1244: p_acct_site_uses_Rec.cust_acct_site_id := x_cust_acct_site_id;
1245: ELSE
1246: p_acct_site_uses_Rec.cust_acct_site_id := p_cust_acct_site_id;
1247: x_cust_acct_site_id := p_cust_acct_site_id;

Line 1298: p_init_msg_list => FND_API.G_FALSE,

1294: Original Call: hz_customer_accounts_pub.create_acct_site_uses
1295: */
1296:
1297: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
1298: p_init_msg_list => FND_API.G_FALSE,
1299: p_cust_site_use_rec => p_acct_site_uses_rec,
1300: p_customer_profile_rec => p_cust_profile_rec,
1301: p_create_profile => FND_API.G_FALSE,
1302: p_create_profile_amt => FND_API.G_FALSE,

Line 1301: p_create_profile => FND_API.G_FALSE,

1297: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
1298: p_init_msg_list => FND_API.G_FALSE,
1299: p_cust_site_use_rec => p_acct_site_uses_rec,
1300: p_customer_profile_rec => p_cust_profile_rec,
1301: p_create_profile => FND_API.G_FALSE,
1302: p_create_profile_amt => FND_API.G_FALSE,
1303: x_site_use_id => l_site_use_id,
1304: x_return_status => x_return_status,
1305: x_msg_count => x_msg_count,

Line 1302: p_create_profile_amt => FND_API.G_FALSE,

1298: p_init_msg_list => FND_API.G_FALSE,
1299: p_cust_site_use_rec => p_acct_site_uses_rec,
1300: p_customer_profile_rec => p_cust_profile_rec,
1301: p_create_profile => FND_API.G_FALSE,
1302: p_create_profile_amt => FND_API.G_FALSE,
1303: x_site_use_id => l_site_use_id,
1304: x_return_status => x_return_status,
1305: x_msg_count => x_msg_count,
1306: x_msg_data => x_msg_data );

Line 1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1309: aso_debug_pub.add('create acct_site_use:create_acct_site_use:x_return_status '||x_return_status, 1, 'N');
1310: aso_debug_pub.add('create acct_site_use:create_acct_site_use:l_site_use_id '||l_site_use_id, 1, 'N');
1311: END IF;
1312:
1313: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1314: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;

Line 1319: raise FND_API.G_EXC_ERROR;

1315: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1316: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_SITE_USES', FALSE);
1317: FND_MSG_PUB.ADD;
1318: END IF;
1319: raise FND_API.G_EXC_ERROR;
1320: ELSE
1321: x_site_use_id := l_site_use_id;
1322: END IF;
1323: END IF; -- x_site_use not null

Line 1325: IF (l_party_site_id IS NOT NULL AND l_party_site_id <> FND_API.G_MISS_NUM) AND

1321: x_site_use_id := l_site_use_id;
1322: END IF;
1323: END IF; -- x_site_use not null
1324:
1325: IF (l_party_site_id IS NOT NULL AND l_party_site_id <> FND_API.G_MISS_NUM) AND
1326: (l_acct_site_type IS NOT NULL AND l_acct_site_type <> FND_API.G_MISS_CHAR) THEN
1327:
1328: OPEN party_site_use(l_party_site_id,l_acct_site_type);
1329: FETCH party_site_use into l_party_site_use;

Line 1326: (l_acct_site_type IS NOT NULL AND l_acct_site_type <> FND_API.G_MISS_CHAR) THEN

1322: END IF;
1323: END IF; -- x_site_use not null
1324:
1325: IF (l_party_site_id IS NOT NULL AND l_party_site_id <> FND_API.G_MISS_NUM) AND
1326: (l_acct_site_type IS NOT NULL AND l_acct_site_type <> FND_API.G_MISS_CHAR) THEN
1327:
1328: OPEN party_site_use(l_party_site_id,l_acct_site_type);
1329: FETCH party_site_use into l_party_site_use;
1330: CLOSE party_site_use;

Line 1334: IF l_party_site_use = NULL OR l_party_site_use = FND_API.G_MISS_NUM then

1330: CLOSE party_site_use;
1331: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1332: aso_debug_pub.add('create acct_site_use:create_party_site_use:l_party_site_use '||l_party_site_use, 1, 'N');
1333: END IF;
1334: IF l_party_site_use = NULL OR l_party_site_use = FND_API.G_MISS_NUM then
1335: Create_Party_Site_Use(
1336: p_api_version => 1.0,
1337: p_party_site_id => l_party_site_id,
1338: p_party_site_use_type => l_acct_site_type,

Line 1347: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1343: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1344: aso_debug_pub.add('create acct_site_use:create_party_site_use:lx_party_site_use_id '||lx_party_site_use_id, 1, 'N');
1345: END IF;
1346: end if;
1347: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get

Line 1348: raise FND_API.G_EXC_ERROR;

1344: aso_debug_pub.add('create acct_site_use:create_party_site_use:lx_party_site_use_id '||lx_party_site_use_id, 1, 'N');
1345: END IF;
1346: end if;
1347: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1348: raise FND_API.G_EXC_ERROR;
1349: END IF;
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get
1352: ( p_count => x_msg_count,

Line 1357: WHEN FND_API.G_EXC_ERROR THEN

1353: p_data => x_msg_data
1354: );
1355:
1356: EXCEPTION
1357: WHEN FND_API.G_EXC_ERROR THEN
1358: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1359: P_API_NAME => L_API_NAME
1360: ,P_PKG_NAME => G_PKG_NAME
1361: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1365: ,X_MSG_COUNT => X_MSG_COUNT
1366: ,X_MSG_DATA => X_MSG_DATA
1367: ,X_RETURN_STATUS => X_RETURN_STATUS);
1368:
1369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1370: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1371: P_API_NAME => L_API_NAME
1372: ,P_PKG_NAME => G_PKG_NAME
1373: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1396: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1392: END Create_acct_site_uses;
1393:
1394:
1395: PROCEDURE Create_Contact ( p_api_version IN NUMBER
1396: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1397: ,p_commit IN VARCHAR2 := FND_API.g_false
1398: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1399: ,p_party_id IN NUMBER := NULL
1400: ,p_Org_Contact_Id IN NUMBER

Line 1397: ,p_commit IN VARCHAR2 := FND_API.g_false

1393:
1394:
1395: PROCEDURE Create_Contact ( p_api_version IN NUMBER
1396: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1397: ,p_commit IN VARCHAR2 := FND_API.g_false
1398: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1399: ,p_party_id IN NUMBER := NULL
1400: ,p_Org_Contact_Id IN NUMBER
1401: ,p_Cust_account_id IN NUMBER

Line 1398: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1394:
1395: PROCEDURE Create_Contact ( p_api_version IN NUMBER
1396: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1397: ,p_commit IN VARCHAR2 := FND_API.g_false
1398: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1399: ,p_party_id IN NUMBER := NULL
1400: ,p_Org_Contact_Id IN NUMBER
1401: ,p_Cust_account_id IN NUMBER
1402: ,p_Role_type IN VARCHAR2 := 'CONTACT'

Line 1444: IF FND_API.to_boolean(p_init_msg_list) THEN

1440: BEGIN
1441:
1442: SAVEPOINT CREATE_CONTACT_PVT;
1443:
1444: IF FND_API.to_boolean(p_init_msg_list) THEN
1445: FND_MSG_PUB.initialize;
1446: END IF;
1447: IF NOT FND_API.compatible_api_call(
1448: l_api_version,

Line 1447: IF NOT FND_API.compatible_api_call(

1443:
1444: IF FND_API.to_boolean(p_init_msg_list) THEN
1445: FND_MSG_PUB.initialize;
1446: END IF;
1447: IF NOT FND_API.compatible_api_call(
1448: l_api_version,
1449: p_api_version,
1450: l_api_name,
1451: g_pkg_name

Line 1453: RAISE FND_API.g_exc_unexpected_error;

1449: p_api_version,
1450: l_api_name,
1451: g_pkg_name
1452: ) THEN
1453: RAISE FND_API.g_exc_unexpected_error;
1454: END IF;
1455: x_return_status := FND_API.g_ret_sts_success;
1456:
1457: -- Initializing the created_by_module column for all the records as per

Line 1455: x_return_status := FND_API.g_ret_sts_success;

1451: g_pkg_name
1452: ) THEN
1453: RAISE FND_API.g_exc_unexpected_error;
1454: END IF;
1455: x_return_status := FND_API.g_ret_sts_success;
1456:
1457: -- Initializing the created_by_module column for all the records as per
1458: -- changes in version 2 api's.
1459:

Line 1468: OR l_party_id = FND_API.G_MISS_NUM THEN

1464: aso_debug_pub.add('create con:p_org_contact_id '||p_org_contact_id, 1, 'N');
1465: END IF;
1466: l_party_id := p_party_id;
1467: IF l_party_id is NULL
1468: OR l_party_id = FND_API.G_MISS_NUM THEN
1469:
1470: IF p_org_contact_id is not NULL
1471: AND p_org_contact_id <> FND_API.G_MISS_NUM THEN
1472:

Line 1471: AND p_org_contact_id <> FND_API.G_MISS_NUM THEN

1467: IF l_party_id is NULL
1468: OR l_party_id = FND_API.G_MISS_NUM THEN
1469:
1470: IF p_org_contact_id is not NULL
1471: AND p_org_contact_id <> FND_API.G_MISS_NUM THEN
1472:
1473: OPEN C_party(p_org_contact_id);
1474: FETCH C_party INTO l_party_id;
1475: IF (C_party%NOTFOUND) THEN

Line 1481: raise FND_API.G_EXC_ERROR;

1477: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1478: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID FOR GIVEN ORG CONTACT', FALSE);
1479: FND_MSG_PUB.ADD;
1480: END IF;
1481: raise FND_API.G_EXC_ERROR;
1482: END IF;
1483: Close C_party;
1484:
1485: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1492: IF (l_party_id is not NULL AND l_party_id <> FND_API.G_MISS_NUM) THEN

1488:
1489: END IF; -- org contact id is not null
1490: END IF; -- party id is null
1491:
1492: IF (l_party_id is not NULL AND l_party_id <> FND_API.G_MISS_NUM) THEN
1493:
1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1495: aso_debug_pub.add('create con:l_party_id '||l_party_id, 1, 'N');
1496: END IF;

Line 1531: p_init_msg_list => FND_API.G_FALSE,

1527: Original Call: hz_customer_accounts_pub.create_cust_acct_roles
1528: */
1529:
1530: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role (
1531: p_init_msg_list => FND_API.G_FALSE,
1532: p_cust_account_role_rec => p_cust_acct_roles_rec,
1533: x_cust_account_role_id => x_cust_account_role_id,
1534: x_return_status => x_return_status,
1535: x_msg_count => x_msg_count,

Line 1541: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1537:
1538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1539: aso_debug_pub.add('create con:after create_acct_role:x_cust_account_role_id '||x_cust_account_role_id, 1, 'N');
1540: END IF;
1541: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1542: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1543: THEN
1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);

Line 1548: raise FND_API.G_EXC_ERROR;

1544: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1545: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1546: FND_MSG_PUB.ADD;
1547: END IF;
1548: raise FND_API.G_EXC_ERROR;
1549: ELSE
1550: x_cust_account_role_id:= l_cust_account_role_id;
1551: END IF;
1552: END IF;

Line 1563: WHEN FND_API.G_EXC_ERROR THEN

1559: p_data => x_msg_data
1560: );
1561:
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1565: P_API_NAME => L_API_NAME
1566: ,P_PKG_NAME => G_PKG_NAME
1567: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1571: ,X_MSG_COUNT => X_MSG_COUNT
1572: ,X_MSG_DATA => X_MSG_DATA
1573: ,X_RETURN_STATUS => X_RETURN_STATUS);
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1577: P_API_NAME => L_API_NAME
1578: ,P_PKG_NAME => G_PKG_NAME
1579: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1609: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1605:
1606:
1607: PROCEDURE Create_ORG_CONTACT_ord (
1608: p_api_version IN NUMBER
1609: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1610: ,p_commit IN VARCHAR2 := FND_API.g_false
1611: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1612: ,p_party_id NUMBER
1613: ,p_header_Party_Id NUMBER := NULL

Line 1610: ,p_commit IN VARCHAR2 := FND_API.g_false

1606:
1607: PROCEDURE Create_ORG_CONTACT_ord (
1608: p_api_version IN NUMBER
1609: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1610: ,p_commit IN VARCHAR2 := FND_API.g_false
1611: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1612: ,p_party_id NUMBER
1613: ,p_header_Party_Id NUMBER := NULL
1614: ,p_acct_id NUMBER := NULL

Line 1611: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

1607: PROCEDURE Create_ORG_CONTACT_ord (
1608: p_api_version IN NUMBER
1609: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1610: ,p_commit IN VARCHAR2 := FND_API.g_false
1611: -- ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
1612: ,p_party_id NUMBER
1613: ,p_header_Party_Id NUMBER := NULL
1614: ,p_acct_id NUMBER := NULL
1615: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1646: IF FND_API.to_boolean(p_init_msg_list) THEN

1642:
1643: BEGIN
1644: SAVEPOINT CREATE_ORG_CONTACT_ORD_PVT;
1645:
1646: IF FND_API.to_boolean(p_init_msg_list) THEN
1647: FND_MSG_PUB.initialize;
1648: END IF;
1649: IF NOT FND_API.compatible_api_call(
1650: l_api_version,

Line 1649: IF NOT FND_API.compatible_api_call(

1645:
1646: IF FND_API.to_boolean(p_init_msg_list) THEN
1647: FND_MSG_PUB.initialize;
1648: END IF;
1649: IF NOT FND_API.compatible_api_call(
1650: l_api_version,
1651: p_api_version,
1652: l_api_name,
1653: g_pkg_name

Line 1655: RAISE FND_API.g_exc_unexpected_error;

1651: p_api_version,
1652: l_api_name,
1653: g_pkg_name
1654: ) THEN
1655: RAISE FND_API.g_exc_unexpected_error;
1656: END IF;
1657: x_return_status := FND_API.g_ret_sts_success;
1658:
1659: --Initializing the created_by_module column for all the records as per

Line 1657: x_return_status := FND_API.g_ret_sts_success;

1653: g_pkg_name
1654: ) THEN
1655: RAISE FND_API.g_exc_unexpected_error;
1656: END IF;
1657: x_return_status := FND_API.g_ret_sts_success;
1658:
1659: --Initializing the created_by_module column for all the records as per
1660: -- changes in version 2 api's.
1661:

Line 1674: or l_header_party_id = FND_API.G_MISS_NUM THEN

1670: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');
1671: END IF;
1672: -- this is called if only account is passed and not the party
1673: IF l_header_party_id is NULL
1674: or l_header_party_id = FND_API.G_MISS_NUM THEN
1675: -- get the party id from acct id
1676: SELECT acct.party_id, par.party_type
1677: INTO l_header_party_id, l_party_type
1678: FROM aso_i_cust_accounts_v acct,

Line 1688: raise FND_API.G_EXC_ERROR;

1684: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1685: FND_MESSAGE.Set_Token('COLUMN', 'PARTY_ID', FALSE);
1686: FND_MSG_PUB.ADD;
1687: END IF;
1688: raise FND_API.G_EXC_ERROR;
1689: END IF;
1690: END IF;
1691:
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 1719: -- RAISE FND_API.G_EXC_ERROR;

1715: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1716: fnd_message.set_name('ASO', 'ORG_CONTACT_ID');
1717: FND_MSG_PUB.Add;
1718: END IF;
1719: -- RAISE FND_API.G_EXC_ERROR;
1720: l_org_contact_id := NULL;
1721: END IF;
1722: Close C_org_contact;
1723:

Line 1729: OR l_org_contact_id = FND_API.G_MISS_NUM THEN

1725: aso_debug_pub.add('create org_con_ord:l_org_contact_id '||l_org_contact_id, 1, 'N');
1726: END IF;
1727:
1728: IF l_org_contact_id is NULL
1729: OR l_org_contact_id = FND_API.G_MISS_NUM THEN
1730:
1731: p_org_contact_rec.party_rel_rec.subject_id := p_party_id;
1732: p_org_contact_rec.party_rel_rec.object_id := l_header_party_id;
1733: -- p_org_contact_rec.party_rel_rec.party_relationship_type := 'CONTACT_OF';

Line 1744: p_init_msg_list => FND_API.G_FALSE,

1740: Original Call: HZ_PARTY_PUB.create_org_contact
1741: */
1742:
1743: HZ_PARTY_CONTACT_V2PUB.create_org_contact (
1744: p_init_msg_list => FND_API.G_FALSE,
1745: p_org_contact_rec => p_org_contact_rec,
1746: x_org_contact_id => l_org_contact_id,
1747: x_party_rel_id => x_party_rel_id,
1748: x_party_id => x_party_id,

Line 1759: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

1755: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1756: aso_debug_pub.add('create org_con_ord:after create_org_con:l_org_contact_id '||l_org_contact_id, 1, 'N');
1757: aso_debug_pub.add('create org_con_ord:after create_org_con:x_return_status '||x_return_status, 1, 'N');
1758: END IF;
1759: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
1760: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1761: THEN
1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);

Line 1766: raise FND_API.G_EXC_ERROR;

1762: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1763: FND_MESSAGE.Set_Token('COLUMN', 'ORG_CONTACT', FALSE);
1764: FND_MSG_PUB.ADD;
1765: END IF;
1766: raise FND_API.G_EXC_ERROR;
1767: END IF;
1768: END IF; -- org contact is null
1769:
1770: x_org_contact_id := l_org_contact_id;

Line 1783: WHEN FND_API.G_EXC_ERROR THEN

1779: p_data => x_msg_data
1780: );
1781:
1782: EXCEPTION
1783: WHEN FND_API.G_EXC_ERROR THEN
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1791: ,X_MSG_COUNT => X_MSG_COUNT
1792: ,X_MSG_DATA => X_MSG_DATA
1793: ,X_RETURN_STATUS => X_RETURN_STATUS);
1794:
1795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1797: P_API_NAME => L_API_NAME
1798: ,P_PKG_NAME => G_PKG_NAME
1799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1823: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

1819: END Create_ORG_CONTACT_ord ;
1820:
1821:
1822: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
1823: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1824: ,p_commit IN VARCHAR2 := FND_API.g_false
1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
1826: ,p_Cust_account_id IN NUMBER
1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

Line 1824: ,p_commit IN VARCHAR2 := FND_API.g_false

1820:
1821:
1822: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
1823: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1824: ,p_commit IN VARCHAR2 := FND_API.g_false
1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
1826: ,p_Cust_account_id IN NUMBER
1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
1828: ,p_Role_type IN VARCHAR2 := 'CONTACT'

Line 1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

1821:
1822: PROCEDURE Create_Contact_Role ( p_api_version IN NUMBER
1823: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1824: ,p_commit IN VARCHAR2 := FND_API.g_false
1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
1826: ,p_Cust_account_id IN NUMBER
1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
1828: ,p_Role_type IN VARCHAR2 := 'CONTACT'
1829: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM

1823: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
1824: ,p_commit IN VARCHAR2 := FND_API.g_false
1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
1826: ,p_Cust_account_id IN NUMBER
1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
1828: ,p_Role_type IN VARCHAR2 := 'CONTACT'
1829: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
1830: ,p_Begin_date IN DATE := sysdate
1831: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM

Line 1829: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR

1825: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
1826: ,p_Cust_account_id IN NUMBER
1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
1828: ,p_Role_type IN VARCHAR2 := 'CONTACT'
1829: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
1830: ,p_Begin_date IN DATE := sysdate
1831: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM
1832: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1833: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1831: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM

1827: ,p_cust_account_site_id IN NUMBER := FND_API.G_MISS_NUM
1828: ,p_Role_type IN VARCHAR2 := 'CONTACT'
1829: ,p_responsibility_type IN VARCHAR2 := FND_API.G_MISS_CHAR
1830: ,p_Begin_date IN DATE := sysdate
1831: ,p_role_id IN NUMBER := FND_API.G_MISS_NUM
1832: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1833: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
1834: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1835: ,x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1858: IF FND_API.to_boolean(p_init_msg_list) THEN

1854:
1855: BEGIN
1856: SAVEPOINT CREATE_CONTACT_ROLE_PVT;
1857:
1858: IF FND_API.to_boolean(p_init_msg_list) THEN
1859: FND_MSG_PUB.initialize;
1860: END IF;
1861: IF NOT FND_API.compatible_api_call(
1862: l_api_version,

Line 1861: IF NOT FND_API.compatible_api_call(

1857:
1858: IF FND_API.to_boolean(p_init_msg_list) THEN
1859: FND_MSG_PUB.initialize;
1860: END IF;
1861: IF NOT FND_API.compatible_api_call(
1862: l_api_version,
1863: p_api_version,
1864: l_api_name,
1865: g_pkg_name

Line 1867: RAISE FND_API.g_exc_unexpected_error;

1863: p_api_version,
1864: l_api_name,
1865: g_pkg_name
1866: ) THEN
1867: RAISE FND_API.g_exc_unexpected_error;
1868: END IF;
1869: x_return_status := FND_API.g_ret_sts_success;
1870: -- Initializing the created_by_module column for all the records as per
1871: -- changes in version 2 api's.

Line 1869: x_return_status := FND_API.g_ret_sts_success;

1865: g_pkg_name
1866: ) THEN
1867: RAISE FND_API.g_exc_unexpected_error;
1868: END IF;
1869: x_return_status := FND_API.g_ret_sts_success;
1870: -- Initializing the created_by_module column for all the records as per
1871: -- changes in version 2 api's.
1872:
1873: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';

Line 1886: IF p_role_id IS NULL OR p_role_id = FND_API.G_MISS_NUM THEN

1882: aso_debug_pub.add('create_contact_role: p_begin_date: '||p_begin_date,1,'N');
1883: aso_debug_pub.add('create_contact_role: p_role_id: '||p_role_id,1,'N');
1884: END IF;
1885:
1886: IF p_role_id IS NULL OR p_role_id = FND_API.G_MISS_NUM THEN
1887: p_cust_acct_roles_rec.party_id := p_party_id;
1888: p_cust_acct_roles_rec.cust_account_id := p_cust_account_id;
1889: p_cust_acct_roles_rec.role_type := p_role_type;
1890:

Line 1906: p_init_msg_list => FND_API.G_FALSE,

1902: Original Call: hz_customer_accounts_pub.create_cust_acct_roles
1903: */
1904:
1905: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_cust_account_role (
1906: p_init_msg_list => FND_API.G_FALSE,
1907: p_cust_account_role_rec => p_cust_acct_roles_rec,
1908: x_cust_account_role_id => x_cust_account_role_id,
1909: x_return_status => x_return_status,
1910: x_msg_count => x_msg_count,

Line 1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1912:
1913: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1914: aso_debug_pub.add('create_contact_role:after create_cust_acct_role: x_return_status: '||x_return_status,1,'N');
1915: END IF;
1916: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1917: x_cust_account_role_id := NULL;
1918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);

Line 1923: raise FND_API.G_EXC_ERROR;

1919: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1920: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1921: FND_MSG_PUB.ADD;
1922: END IF;
1923: raise FND_API.G_EXC_ERROR;
1924: END IF;
1925: ELSE
1926: x_cust_account_role_id := p_role_id;
1927: END IF;

Line 1938: p_cust_account_site_id <> FND_API.G_MISS_NUM THEN

1934: END IF;
1935: IF C_Get_Resp%NOTFOUND THEN
1936:
1937: IF p_cust_account_site_id is not NULL AND
1938: p_cust_account_site_id <> FND_API.G_MISS_NUM THEN
1939: p_role_resp_rec.cust_account_role_id := x_cust_account_role_id;
1940: p_role_resp_rec.responsibility_type := p_responsibility_type;
1941:
1942: /*

Line 1950: p_init_msg_list => FND_API.G_FALSE,

1946: */
1947:
1948:
1949: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility (
1950: p_init_msg_list => FND_API.G_FALSE,
1951: p_role_responsibility_rec => p_role_resp_rec,
1952: x_responsibility_id => l_responsibility_id,
1953: x_return_status => x_return_status,
1954: x_msg_count => x_msg_count,

Line 1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1956:
1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1958: aso_debug_pub.add('create_contact_role:after create_role_resp: x_return_status: '||x_return_status,1,'N');
1959: END IF;
1960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1961: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;

Line 1966: raise FND_API.G_EXC_ERROR;

1962: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
1963: FND_MESSAGE.Set_Token('COLUMN', 'ACCT_ROLE', FALSE);
1964: FND_MSG_PUB.ADD;
1965: END IF;
1966: raise FND_API.G_EXC_ERROR;
1967: END IF;
1968: END IF;
1969: END IF;
1970:

Line 1979: WHEN FND_API.G_EXC_ERROR THEN

1975: p_data => x_msg_data
1976: );
1977:
1978: EXCEPTION
1979: WHEN FND_API.G_EXC_ERROR THEN
1980: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1981: P_API_NAME => L_API_NAME
1982: ,P_PKG_NAME => G_PKG_NAME
1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1987: ,X_MSG_COUNT => X_MSG_COUNT
1988: ,X_MSG_DATA => X_MSG_DATA
1989: ,X_RETURN_STATUS => X_RETURN_STATUS);
1990:
1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1993: P_API_NAME => L_API_NAME
1994: ,P_PKG_NAME => G_PKG_NAME
1995: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2018: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

2014: END Create_Contact_Role;
2015:
2016: Procedure GET_ACCT_SITE_USES(
2017: p_api_version IN NUMBER
2018: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2019: ,p_commit IN VARCHAR2 := FND_API.g_false
2020: ,P_Cust_Account_Id IN NUMBER
2021: ,P_Party_Site_Id IN NUMBER
2022: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'

Line 2019: ,p_commit IN VARCHAR2 := FND_API.g_false

2015:
2016: Procedure GET_ACCT_SITE_USES(
2017: p_api_version IN NUMBER
2018: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
2019: ,p_commit IN VARCHAR2 := FND_API.g_false
2020: ,P_Cust_Account_Id IN NUMBER
2021: ,P_Party_Site_Id IN NUMBER
2022: ,P_Acct_Site_type IN VARCHAR2 := 'NONE'
2023: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2036: IF FND_API.to_boolean(p_init_msg_list) THEN

2032:
2033: BEGIN
2034: ---- Initialize---------------------
2035:
2036: IF FND_API.to_boolean(p_init_msg_list) THEN
2037: FND_MSG_PUB.initialize;
2038: END IF;
2039:
2040: IF NOT FND_API.compatible_api_call(

Line 2040: IF NOT FND_API.compatible_api_call(

2036: IF FND_API.to_boolean(p_init_msg_list) THEN
2037: FND_MSG_PUB.initialize;
2038: END IF;
2039:
2040: IF NOT FND_API.compatible_api_call(
2041: l_api_version,
2042: p_api_version,
2043: l_api_name,
2044: g_pkg_name

Line 2046: RAISE FND_API.g_exc_unexpected_error;

2042: p_api_version,
2043: l_api_name,
2044: g_pkg_name
2045: ) THEN
2046: RAISE FND_API.g_exc_unexpected_error;
2047: END IF;
2048:
2049: x_return_status := FND_API.g_ret_sts_success;
2050:

Line 2049: x_return_status := FND_API.g_ret_sts_success;

2045: ) THEN
2046: RAISE FND_API.g_exc_unexpected_error;
2047: END IF;
2048:
2049: x_return_status := FND_API.g_ret_sts_success;
2050:
2051: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2052: aso_debug_pub.add('ASO_PARTY_INT.get_acct_site_use:P_Acct_Site_type: '||P_Acct_Site_type,1,'N');
2053: END IF;

Line 2072: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2068:
2069:
2070: PROCEDURE Create_Customer_Account(
2071: p_api_version IN NUMBER,
2072: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2073: p_commit IN VARCHAR2 := FND_API.g_false,
2074: P_Party_id IN NUMBER,
2075: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
2076: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2073: p_commit IN VARCHAR2 := FND_API.g_false,

2069:
2070: PROCEDURE Create_Customer_Account(
2071: p_api_version IN NUMBER,
2072: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2073: p_commit IN VARCHAR2 := FND_API.g_false,
2074: P_Party_id IN NUMBER,
2075: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
2076: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2077: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2075: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,

2071: p_api_version IN NUMBER,
2072: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2073: p_commit IN VARCHAR2 := FND_API.g_false,
2074: P_Party_id IN NUMBER,
2075: P_Account_number IN NUMBER := FND_API.G_MISS_NUM,
2076: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2077: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2078: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2079: x_cust_acct_id OUT NOCOPY /* file.sql.39 change */ NUMBER)

Line 2139: IF FND_API.to_boolean(p_init_msg_list) THEN

2135:
2136: ---- Initialize---------------------
2137: SAVEPOINT CREATE_CUSTOMER_ACCOUNT_PVT;
2138:
2139: IF FND_API.to_boolean(p_init_msg_list) THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142:
2143: IF NOT FND_API.compatible_api_call(

Line 2143: IF NOT FND_API.compatible_api_call(

2139: IF FND_API.to_boolean(p_init_msg_list) THEN
2140: FND_MSG_PUB.initialize;
2141: END IF;
2142:
2143: IF NOT FND_API.compatible_api_call(
2144: l_api_version,
2145: p_api_version,
2146: l_api_name,
2147: g_pkg_name

Line 2149: RAISE FND_API.g_exc_unexpected_error;

2145: p_api_version,
2146: l_api_name,
2147: g_pkg_name
2148: ) THEN
2149: RAISE FND_API.g_exc_unexpected_error;
2150: END IF;
2151:
2152: x_return_status := FND_API.g_ret_sts_success;
2153:

Line 2152: x_return_status := FND_API.g_ret_sts_success;

2148: ) THEN
2149: RAISE FND_API.g_exc_unexpected_error;
2150: END IF;
2151:
2152: x_return_status := FND_API.g_ret_sts_success;
2153:
2154: -- Initializing the created_by_module column for all the records as per
2155: -- changes in version 2 api's.
2156:

Line 2168: IF l_gen_cust_num = 'Y' and p_account_number <> FND_API.G_MISS_NUM THEN

2164: SELECT generate_customer_number INTO l_gen_cust_num
2165: FROM ar_system_parameters;
2166: -- typically should be set to 'Y' if no we will try to create a new one.
2167: -- however, this could error out
2168: IF l_gen_cust_num = 'Y' and p_account_number <> FND_API.G_MISS_NUM THEN
2169: account_rec.account_number := p_account_number;
2170: ELSIF l_gen_cust_num = 'N'
2171: and (p_account_number = FND_API.G_MISS_NUM or p_account_number is null) THEN
2172: OPEN C_acct_number;

Line 2171: and (p_account_number = FND_API.G_MISS_NUM or p_account_number is null) THEN

2167: -- however, this could error out
2168: IF l_gen_cust_num = 'Y' and p_account_number <> FND_API.G_MISS_NUM THEN
2169: account_rec.account_number := p_account_number;
2170: ELSIF l_gen_cust_num = 'N'
2171: and (p_account_number = FND_API.G_MISS_NUM or p_account_number is null) THEN
2172: OPEN C_acct_number;
2173: FETCH C_acct_number into account_rec.account_number;
2174: CLOSE C_acct_number;
2175: account_rec.account_number := 'ASO'||account_rec.account_number;

Line 2189: raise FND_API.G_EXC_ERROR;

2185: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2186: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2187: FND_MSG_PUB.ADD;
2188: END IF;
2189: raise FND_API.G_EXC_ERROR;
2190: END IF;
2191: CLOSE C_party_info;
2192: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2193: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');

Line 2209: raise FND_API.G_EXC_ERROR;

2205: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
2206: FND_MESSAGE.Set_Token('COLUMN', 'PARTY ID', FALSE);
2207: FND_MSG_PUB.ADD;
2208: END IF;
2209: raise FND_API.G_EXC_ERROR;
2210: END IF;
2211: CLOSE C_party_info;
2212:
2213: ELSE

Line 2239: p_init_msg_list => FND_API.G_FALSE,

2235: */
2236:
2237:
2238: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
2239: p_init_msg_list => FND_API.G_FALSE,
2240: p_cust_account_rec => account_rec,
2241: p_person_rec => person_rec,
2242: p_customer_profile_rec => cust_profile_rec,
2243: p_create_profile_amt => 'Y',

Line 2266: p_init_msg_list => FND_API.G_FALSE,

2262: Original Call: hz_customer_accounts_pub.create_account
2263: */
2264:
2265: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
2266: p_init_msg_list => FND_API.G_FALSE,
2267: p_cust_account_rec => account_rec,
2268: p_organization_rec => organization_rec,
2269: p_customer_profile_rec => cust_profile_rec,
2270: p_create_profile_amt => 'Y',

Line 2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN

2281: END IF;
2282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2283: aso_debug_pub.add('create_cust_acct:after create_acct:l_acct_id: '||l_acct_id,1,'N');
2284: END IF;
2285: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;

Line 2291: raise FND_API.G_EXC_ERROR;

2287: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
2288: FND_MESSAGE.Set_Token('COLUMN', 'ACCT ID', FALSE);
2289: FND_MSG_PUB.ADD;
2290: END IF;
2291: raise FND_API.G_EXC_ERROR;
2292: ELSE
2293: x_cust_acct_id := l_acct_id;
2294: END IF;
2295:

Line 2301: WHEN FND_API.G_EXC_ERROR THEN

2297: p_count => x_msg_count,
2298: p_data => x_msg_data);
2299:
2300: EXCEPTION
2301: WHEN FND_API.G_EXC_ERROR THEN
2302: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2303: P_API_NAME => L_API_NAME,
2304: P_PKG_NAME => G_PKG_NAME,
2305: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2309: X_MSG_COUNT => X_MSG_COUNT,
2310: X_MSG_DATA => X_MSG_DATA,
2311: X_RETURN_STATUS => X_RETURN_STATUS);
2312:
2313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2314: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2315: P_API_NAME => L_API_NAME,
2316: P_PKG_NAME => G_PKG_NAME,
2317: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 2341: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2337: END Create_Customer_Account;
2338:
2339: PROCEDURE Create_Cust_Acct_Relationship(
2340: p_api_version IN NUMBER,
2341: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2342: p_commit IN VARCHAR2 := FND_API.g_false,
2343: p_sold_to_cust_account IN NUMBER,
2344: p_related_cust_account IN NUMBER,
2345: p_relationship_type IN VARCHAR2,

Line 2342: p_commit IN VARCHAR2 := FND_API.g_false,

2338:
2339: PROCEDURE Create_Cust_Acct_Relationship(
2340: p_api_version IN NUMBER,
2341: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2342: p_commit IN VARCHAR2 := FND_API.g_false,
2343: p_sold_to_cust_account IN NUMBER,
2344: p_related_cust_account IN NUMBER,
2345: p_relationship_type IN VARCHAR2,
2346: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2366: IF FND_API.to_boolean(p_init_msg_list) THEN

2362: BEGIN
2363:
2364: SAVEPOINT Create_Cust_Acct_Relationship;
2365:
2366: IF FND_API.to_boolean(p_init_msg_list) THEN
2367: FND_MSG_PUB.initialize;
2368: END IF;
2369:
2370: IF NOT FND_API.compatible_api_call(

Line 2370: IF NOT FND_API.compatible_api_call(

2366: IF FND_API.to_boolean(p_init_msg_list) THEN
2367: FND_MSG_PUB.initialize;
2368: END IF;
2369:
2370: IF NOT FND_API.compatible_api_call(
2371: l_api_version,
2372: p_api_version,
2373: l_api_name,
2374: g_pkg_name

Line 2376: RAISE FND_API.g_exc_unexpected_error;

2372: p_api_version,
2373: l_api_name,
2374: g_pkg_name
2375: ) THEN
2376: RAISE FND_API.g_exc_unexpected_error;
2377: END IF;
2378:
2379: x_return_status := FND_API.g_ret_sts_success;
2380:

Line 2379: x_return_status := FND_API.g_ret_sts_success;

2375: ) THEN
2376: RAISE FND_API.g_exc_unexpected_error;
2377: END IF;
2378:
2379: x_return_status := FND_API.g_ret_sts_success;
2380:
2381: --Initializing the created_by_module column for all the records as per
2382: -- changes in version 2 api's.
2383:

Line 2407: RAISE FND_API.G_EXC_ERROR;

2403: l_cust_acct_relate_rec.bill_to_flag := 'Y';
2404: elsif p_relationship_type = 'SHIP_TO' then
2405: l_cust_acct_relate_rec.ship_to_flag := 'Y';
2406: else
2407: RAISE FND_API.G_EXC_ERROR;
2408: end if;
2409:
2410: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2411: aso_debug_pub.add('enter cust1 and finish setup',1,'N');

Line 2420: p_init_msg_list => FND_API.G_FALSE,

2416: Original Call: HZ_CUST_ACCT_INFO_PUB.create_cust_acct_relate
2417: */
2418:
2419: HZ_CUST_ACCOUNT_V2PUB.create_cust_acct_relate (
2420: p_init_msg_list => FND_API.G_FALSE,
2421: p_cust_acct_relate_rec => l_cust_acct_relate_rec,
2422: x_return_status => x_return_status,
2423: x_msg_count => x_msg_count,
2424: x_msg_data => x_msg_data );

Line 2430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2426: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2427: aso_debug_pub.add('finish call create_cust_acct_relate and ' || x_return_status, 1, 'N');
2428: END IF;
2429:
2430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434: FND_MSG_PUB.Count_And_Get(

Line 2431: RAISE FND_API.G_EXC_ERROR;

2427: aso_debug_pub.add('finish call create_cust_acct_relate and ' || x_return_status, 1, 'N');
2428: END IF;
2429:
2430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2431: RAISE FND_API.G_EXC_ERROR;
2432: END IF;
2433:
2434: FND_MSG_PUB.Count_And_Get(
2435: p_count => x_msg_count,

Line 2439: WHEN FND_API.G_EXC_ERROR THEN

2435: p_count => x_msg_count,
2436: p_data => x_msg_data);
2437:
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2441: P_API_NAME => L_API_NAME,
2442: P_PKG_NAME => G_PKG_NAME,
2443: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2447: X_MSG_COUNT => X_MSG_COUNT,
2448: X_MSG_DATA => X_MSG_DATA,
2449: X_RETURN_STATUS => X_RETURN_STATUS);
2450:
2451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2452: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2453: P_API_NAME => L_API_NAME,
2454: P_PKG_NAME => G_PKG_NAME,
2455: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 2479: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2475: END Create_Cust_Acct_Relationship;
2476:
2477: PROCEDURE update_Cust_Acct_Relationship(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2480: p_commit IN VARCHAR2 := FND_API.g_false,
2481: p_sold_to_cust_account IN NUMBER,
2482: p_related_cust_account IN NUMBER,
2483: p_relationship_type IN VARCHAR2,

Line 2480: p_commit IN VARCHAR2 := FND_API.g_false,

2476:
2477: PROCEDURE update_Cust_Acct_Relationship(
2478: p_api_version IN NUMBER,
2479: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2480: p_commit IN VARCHAR2 := FND_API.g_false,
2481: p_sold_to_cust_account IN NUMBER,
2482: p_related_cust_account IN NUMBER,
2483: p_relationship_type IN VARCHAR2,
2484: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2504: IF FND_API.to_boolean(p_init_msg_list) THEN

2500: BEGIN
2501:
2502: SAVEPOINT update_Cust_Acct_Relationship;
2503:
2504: IF FND_API.to_boolean(p_init_msg_list) THEN
2505: FND_MSG_PUB.initialize;
2506: END IF;
2507:
2508: IF NOT FND_API.compatible_api_call(

Line 2508: IF NOT FND_API.compatible_api_call(

2504: IF FND_API.to_boolean(p_init_msg_list) THEN
2505: FND_MSG_PUB.initialize;
2506: END IF;
2507:
2508: IF NOT FND_API.compatible_api_call(
2509: l_api_version,
2510: p_api_version,
2511: l_api_name,
2512: g_pkg_name

Line 2514: RAISE FND_API.g_exc_unexpected_error;

2510: p_api_version,
2511: l_api_name,
2512: g_pkg_name
2513: ) THEN
2514: RAISE FND_API.g_exc_unexpected_error;
2515: END IF;
2516:
2517: x_return_status := FND_API.g_ret_sts_success;
2518:

Line 2517: x_return_status := FND_API.g_ret_sts_success;

2513: ) THEN
2514: RAISE FND_API.g_exc_unexpected_error;
2515: END IF;
2516:
2517: x_return_status := FND_API.g_ret_sts_success;
2518:
2519: --Initializing the created_by_module column for all the records as per
2520: -- changes in version 2 api's.
2521:

Line 2542: RAISE FND_API.G_EXC_ERROR;

2538: l_cust_acct_relate_rec.bill_to_flag := 'Y';
2539: elsif p_relationship_type = 'SHIP_TO' then
2540: l_cust_acct_relate_rec.ship_to_flag := 'Y';
2541: else
2542: RAISE FND_API.G_EXC_ERROR;
2543: end if;
2544:
2545: begin
2546: -- l_cust_object_version_number := FND_API.G_MISS_NUM;

Line 2546: -- l_cust_object_version_number := FND_API.G_MISS_NUM;

2542: RAISE FND_API.G_EXC_ERROR;
2543: end if;
2544:
2545: begin
2546: -- l_cust_object_version_number := FND_API.G_MISS_NUM;
2547:
2548:
2549: SELECT OBJECT_VERSION_NUMBER
2550: INTO l_cust_object_version_number

Line 2558: l_cust_object_version_number := FND_API.G_MISS_NUM;

2554: AND status = 'A';
2555:
2556: EXCEPTION
2557: WHEN NO_DATA_FOUND THEN
2558: l_cust_object_version_number := FND_API.G_MISS_NUM;
2559: end;
2560: /*
2561: The call to .create_cust_acct_relate has been moved to a diff package in version 2 api
2562: Original Call: HZ_CUST_ACCT_INFO_PUB.create_cust_acct_relate

Line 2566: p_init_msg_list => FND_API.G_FALSE,

2562: Original Call: HZ_CUST_ACCT_INFO_PUB.create_cust_acct_relate
2563: */
2564:
2565: HZ_CUST_ACCOUNT_V2PUB.update_cust_acct_relate (
2566: p_init_msg_list => FND_API.G_FALSE,
2567: p_cust_acct_relate_rec => l_cust_acct_relate_rec,
2568: p_object_version_number => l_cust_object_version_number,
2569: x_return_status => x_return_status,
2570: x_msg_count => x_msg_count,

Line 2577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2574: aso_debug_pub.add('finish call update_cust_acct_relate and ' || x_return_status, 1, 'N');
2575: END IF;
2576:
2577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: END IF;
2580:
2581: FND_MSG_PUB.Count_And_Get(

Line 2578: RAISE FND_API.G_EXC_ERROR;

2574: aso_debug_pub.add('finish call update_cust_acct_relate and ' || x_return_status, 1, 'N');
2575: END IF;
2576:
2577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2578: RAISE FND_API.G_EXC_ERROR;
2579: END IF;
2580:
2581: FND_MSG_PUB.Count_And_Get(
2582: p_count => x_msg_count,

Line 2586: WHEN FND_API.G_EXC_ERROR THEN

2582: p_count => x_msg_count,
2583: p_data => x_msg_data);
2584:
2585: EXCEPTION
2586: WHEN FND_API.G_EXC_ERROR THEN
2587: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2588: P_API_NAME => L_API_NAME,
2589: P_PKG_NAME => G_PKG_NAME,
2590: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 2598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2594: X_MSG_COUNT => X_MSG_COUNT,
2595: X_MSG_DATA => X_MSG_DATA,
2596: X_RETURN_STATUS => X_RETURN_STATUS);
2597:
2598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2599: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2600: P_API_NAME => L_API_NAME,
2601: P_PKG_NAME => G_PKG_NAME,
2602: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

Line 2626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2622: END update_Cust_Acct_Relationship;
2623:
2624: PROCEDURE Create_Party_Site_Use(
2625: p_api_version IN NUMBER,
2626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2627: p_commit IN VARCHAR2 := FND_API.g_false,
2628: p_party_site_id IN NUMBER,
2629: p_party_site_use_type IN VARCHAR2,
2630: x_party_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 2627: p_commit IN VARCHAR2 := FND_API.g_false,

2623:
2624: PROCEDURE Create_Party_Site_Use(
2625: p_api_version IN NUMBER,
2626: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2627: p_commit IN VARCHAR2 := FND_API.g_false,
2628: p_party_site_id IN NUMBER,
2629: p_party_site_use_type IN VARCHAR2,
2630: x_party_site_use_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
2631: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2643: IF FND_API.to_boolean(p_init_msg_list) THEN

2639:
2640: BEGIN
2641: SAVEPOINT CREATE_PARTY_SITE_USE_PVT;
2642:
2643: IF FND_API.to_boolean(p_init_msg_list) THEN
2644: FND_MSG_PUB.initialize;
2645: END IF;
2646:
2647: IF NOT FND_API.compatible_api_call(

Line 2647: IF NOT FND_API.compatible_api_call(

2643: IF FND_API.to_boolean(p_init_msg_list) THEN
2644: FND_MSG_PUB.initialize;
2645: END IF;
2646:
2647: IF NOT FND_API.compatible_api_call(
2648: l_api_version,
2649: p_api_version,
2650: l_api_name,
2651: g_pkg_name

Line 2653: RAISE FND_API.g_exc_unexpected_error;

2649: p_api_version,
2650: l_api_name,
2651: g_pkg_name
2652: ) THEN
2653: RAISE FND_API.g_exc_unexpected_error;
2654: END IF;
2655:
2656: -- Initialize API return status to SUCCESS
2657: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2657: x_return_status := FND_API.G_RET_STS_SUCCESS;

2653: RAISE FND_API.g_exc_unexpected_error;
2654: END IF;
2655:
2656: -- Initialize API return status to SUCCESS
2657: x_return_status := FND_API.G_RET_STS_SUCCESS;
2658:
2659: --Initializing the created_by_module column for all the records as per
2660: -- changes in version 2 api's.
2661:

Line 2680: p_init_msg_list => FND_API.G_FALSE,

2676: Original Call: HZ_PARTY_PUB.Create_Party_Site_Use
2677: */
2678:
2679: HZ_PARTY_SITE_V2PUB.create_party_site_use (
2680: p_init_msg_list => FND_API.G_FALSE,
2681: p_party_site_use_rec => l_party_site_use_rec,
2682: x_party_site_use_id => x_party_site_use_id,
2683: x_return_status => x_return_status,
2684: x_msg_count => x_msg_count,

Line 2692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2688: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2689: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_party_site_use_id ' || x_party_site_use_id, 1, 'N');
2690: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');
2691: END IF;
2692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: EXCEPTION

Line 2693: RAISE FND_API.G_EXC_ERROR;

2689: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_party_site_use_id ' || x_party_site_use_id, 1, 'N');
2690: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');
2691: END IF;
2692: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN

Line 2697: WHEN FND_API.G_EXC_ERROR THEN

2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: EXCEPTION
2697: WHEN FND_API.G_EXC_ERROR THEN
2698: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2699: P_API_NAME => L_API_NAME
2700: ,P_PKG_NAME => G_PKG_NAME
2701: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2703: ,X_MSG_COUNT => X_MSG_COUNT
2704: ,X_MSG_DATA => X_MSG_DATA
2705: ,X_RETURN_STATUS => X_RETURN_STATUS);
2706:
2707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2708: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2709: P_API_NAME => L_API_NAME
2710: ,P_PKG_NAME => G_PKG_NAME
2711: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR