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.ASO_PARTY_INT dependencies on ASO_DEBUG_PUB

Line 90: IF aso_debug_pub.g_debug_flag = 'Y' THEN

86: x_party_id => x_party_id,
87: x_party_number => l_party_number,
88: x_profile_id => l_profile_id );
89:
90: IF aso_debug_pub.g_debug_flag = 'Y' THEN
91: aso_debug_pub.add('create_party:after create_org:x_party_id '||x_party_id, 1, 'N');
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'

Line 91: aso_debug_pub.add('create_party:after create_org:x_party_id '||x_party_id, 1, 'N');

87: x_party_number => l_party_number,
88: x_profile_id => l_profile_id );
89:
90: IF aso_debug_pub.g_debug_flag = 'Y' THEN
91: aso_debug_pub.add('create_party:after create_org:x_party_id '||x_party_id, 1, 'N');
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

Line 92: aso_debug_pub.add('create_party:after create_org:x_return_status '||x_return_status, 1, 'N');

88: x_profile_id => l_profile_id );
89:
90: IF aso_debug_pub.g_debug_flag = 'Y' THEN
91: aso_debug_pub.add('create_party:after create_org:x_party_id '||x_party_id, 1, 'N');
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

Line 130: IF aso_debug_pub.g_debug_flag = 'Y' THEN

126: x_return_status => x_return_status,
127: x_msg_count => x_msg_count,
128: x_msg_data => x_msg_data);
129:
130: IF aso_debug_pub.g_debug_flag = 'Y' 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;

Line 131: aso_debug_pub.add('create_party:after create_per:x_return_status '||x_return_status, 1, 'N');

127: x_msg_count => x_msg_count,
128: x_msg_data => x_msg_data);
129:
130: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 132: aso_debug_pub.add('create_party:after create_per:x_party_id '||x_party_id, 1, 'N');

128: x_msg_data => x_msg_data);
129:
130: IF aso_debug_pub.g_debug_flag = 'Y' 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;

Line 244: IF aso_debug_pub.g_debug_flag = 'Y' THEN

240: x_return_status => x_return_status,
241: x_msg_count => x_msg_count ,
242: x_msg_data => x_msg_data );
243:
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

Line 245: aso_debug_pub.add('create_party_site:after create_loc:l_location_id '||l_location_id, 1, 'N');

241: x_msg_count => x_msg_count ,
242: x_msg_data => x_msg_data );
243:
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:

Line 246: aso_debug_pub.add('create_party_site:after create_loc:x_return_status '||x_return_status, 1, 'N');

242: x_msg_data => x_msg_data );
243:
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;

Line 268: IF aso_debug_pub.g_debug_flag = 'Y' THEN

264: x_return_status => x_return_status,
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data );
267:
268: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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

Line 269: aso_debug_pub.add('create_party_site:after create_site:x_party_site_id '||x_party_site_id, 1, 'N');

265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data );
267:
268: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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;

Line 270: aso_debug_pub.add('create_party_site:after create_site:x_return_status '||x_return_status, 1, 'N');

266: x_msg_data => x_msg_data );
267:
268: IF aso_debug_pub.g_debug_flag = 'Y' THEN
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;

Line 296: IF aso_debug_pub.g_debug_flag = 'Y' THEN

292: x_msg_count => x_msg_count,
293: x_msg_data => x_msg_data );
294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' 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;

Line 297: aso_debug_pub.add('create_party_site:after create_site_use:x_return_status '||x_return_status, 1, 'N');

293: x_msg_data => x_msg_data );
294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 298: aso_debug_pub.add('create_party_site:after create_site_use:l_party_site_use_id '||l_party_site_use_id, 1, 'N

294:
295:
296: IF aso_debug_pub.g_debug_flag = 'Y' 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;

Line 436: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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');
438: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
439: END IF;
440:

Line 437: aso_debug_pub.add('update_pty:before update_per', 1, 'N');

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');
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 (

Line 438: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');

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');
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,

Line 451: IF aso_debug_pub.g_debug_flag = 'Y' THEN

447: x_msg_count => x_msg_count ,
448: x_msg_data => x_msg_data
449: );
450:
451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
452: aso_debug_pub.add('update_pty:after update_per:x_return_status '||x_return_status, 1, 'N');
453: aso_debug_pub.add('update_pty:after update_per:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
454: END IF;
455:

Line 452: aso_debug_pub.add('update_pty:after update_per:x_return_status '||x_return_status, 1, 'N');

448: x_msg_data => x_msg_data
449: );
450:
451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
452: aso_debug_pub.add('update_pty:after update_per:x_return_status '||x_return_status, 1, 'N');
453: aso_debug_pub.add('update_pty:after update_per:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
454: END IF;
455:
456: elsif p_party_rec.party_type = 'ORGANIZATION' THEN

Line 453: aso_debug_pub.add('update_pty:after update_per:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

449: );
450:
451: IF aso_debug_pub.g_debug_flag = 'Y' THEN
452: aso_debug_pub.add('update_pty:after update_per:x_return_status '||x_return_status, 1, 'N');
453: aso_debug_pub.add('update_pty:after update_per:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
454: END IF;
455:
456: elsif p_party_rec.party_type = 'ORGANIZATION' THEN
457: -- AND p_party_rec.party_name IS NOT NULL

Line 489: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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');
491: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
492: END IF;
493:

Line 490: aso_debug_pub.add('update_pty:before update_organization', 1, 'N');

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');
491: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
492: END IF;
493:
494:

Line 491: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');

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');
491: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
492: END IF;
493:
494:
495: HZ_PARTY_V2PUB.update_organization (

Line 505: IF aso_debug_pub.g_debug_flag = 'Y' THEN

501: x_msg_count => x_msg_count ,
502: x_msg_data => x_msg_data
503: );
504:
505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
506: aso_debug_pub.add('update_pty:after update_org:x_return_status '||x_return_status, 1, 'N');
507: aso_debug_pub.add('update_pty:after update_org:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
508: END IF;
509: elsif p_party_rec.party_type = 'PARTY_RELATIONSHIP' THEN

Line 506: aso_debug_pub.add('update_pty:after update_org:x_return_status '||x_return_status, 1, 'N');

502: x_msg_data => x_msg_data
503: );
504:
505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
506: aso_debug_pub.add('update_pty:after update_org:x_return_status '||x_return_status, 1, 'N');
507: aso_debug_pub.add('update_pty:after update_org:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
508: END IF;
509: elsif p_party_rec.party_type = 'PARTY_RELATIONSHIP' THEN
510: l_party_rel_rec.party_rec := l_party_rec;

Line 507: aso_debug_pub.add('update_pty:after update_org:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

503: );
504:
505: IF aso_debug_pub.g_debug_flag = 'Y' THEN
506: aso_debug_pub.add('update_pty:after update_org:x_return_status '||x_return_status, 1, 'N');
507: aso_debug_pub.add('update_pty:after update_org:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');
508: END IF;
509: elsif p_party_rec.party_type = 'PARTY_RELATIONSHIP' THEN
510: l_party_rel_rec.party_rec := l_party_rec;
511: l_party_rel_rec.party_rec.party_id := p_party_rec.party_id;

Line 554: IF aso_debug_pub.g_debug_flag = 'Y' 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');
556: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');
557: END IF;
558:

Line 555: aso_debug_pub.add('update_pty:before update_reltn', 1, 'N');

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');
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 (

Line 556: aso_debug_pub.add('update_pty:object_version_number '||l_party_object_version_number, 1, 'N');

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');
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,

Line 571: IF aso_debug_pub.g_debug_flag = 'Y' THEN

567: );
568:
569:
570:
571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
572: aso_debug_pub.add('update_pty:after update_reltn:x_return_status '||x_return_status, 1, 'N');
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

Line 572: aso_debug_pub.add('update_pty:after update_reltn:x_return_status '||x_return_status, 1, 'N');

568:
569:
570:
571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
572: aso_debug_pub.add('update_pty:after update_reltn:x_return_status '||x_return_status, 1, 'N');
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:

Line 573: aso_debug_pub.add('update_pty:after update_reltn:p_party_rec.party_id '||p_party_rec.party_id, 1, 'N');

569:
570:
571: IF aso_debug_pub.g_debug_flag = 'Y' THEN
572: aso_debug_pub.add('update_pty:after update_reltn:x_return_status '||x_return_status, 1, 'N');
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

Line 640: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
644: OPEN C_Account;

Line 641: aso_debug_pub.add('validate cust_acct:p_cust_account_id '||p_cust_account_id, 1, 'N');

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
644: OPEN C_Account;
645: FETCH C_Account INTO l_account_status, l_activation_date, l_termination_date;

Line 660: IF aso_debug_pub.g_debug_flag = 'Y' THEN

656: END IF;
657: CLOSE C_Account;
658: END IF;
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;

Line 661: aso_debug_pub.add('validate cust_acct:x_return_status '||x_return_status, 1, 'N');

657: CLOSE C_Account;
658: END IF;
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;

Line 771: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

767: ---- Initialize---------------------
768:
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;

Line 831: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
832: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
833: aso_debug_pub.add('create cust_acct:l_party_name '||l_party_name, 1, 'N');
834: END IF;
835: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 832: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');

828: END IF;
829: CLOSE C_party_info;
830:
831: IF aso_debug_pub.g_debug_flag = 'Y' THEN
832: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
833: aso_debug_pub.add('create cust_acct:l_party_name '||l_party_name, 1, 'N');
834: END IF;
835: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
836: OPEN c_party_rel_rec(p_qte_rec.party_id);

Line 833: aso_debug_pub.add('create cust_acct:l_party_name '||l_party_name, 1, 'N');

829: CLOSE C_party_info;
830:
831: IF aso_debug_pub.g_debug_flag = 'Y' THEN
832: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
833: aso_debug_pub.add('create cust_acct:l_party_name '||l_party_name, 1, 'N');
834: END IF;
835: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
836: OPEN c_party_rel_rec(p_qte_rec.party_id);
837: FETCH c_party_rel_rec INTO customer_party_id;

Line 872: IF aso_debug_pub.g_debug_flag = 'Y' THEN

868:
869: -- will test this for patch set C
870: --account_rec.payment_term_id := to_number(FND_PROFILE.VALUE('ASO_PAYMENT_TERM'));
871:
872: IF aso_debug_pub.g_debug_flag = 'Y' THEN
873: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
874: aso_debug_pub.add('create cust_acct:account_rec.account_name '||account_rec.account_name, 1, 'N');
875: END IF;
876: -- if party is a person

Line 873: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');

869: -- will test this for patch set C
870: --account_rec.payment_term_id := to_number(FND_PROFILE.VALUE('ASO_PAYMENT_TERM'));
871:
872: IF aso_debug_pub.g_debug_flag = 'Y' THEN
873: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
874: aso_debug_pub.add('create cust_acct:account_rec.account_name '||account_rec.account_name, 1, 'N');
875: END IF;
876: -- if party is a person
877: IF l_party_type = 'PERSON' THEN

Line 874: aso_debug_pub.add('create cust_acct:account_rec.account_name '||account_rec.account_name, 1, 'N');

870: --account_rec.payment_term_id := to_number(FND_PROFILE.VALUE('ASO_PAYMENT_TERM'));
871:
872: IF aso_debug_pub.g_debug_flag = 'Y' THEN
873: aso_debug_pub.add('create cust_acct:l_party_type '||l_party_type, 1, 'N');
874: aso_debug_pub.add('create cust_acct:account_rec.account_name '||account_rec.account_name, 1, 'N');
875: END IF;
876: -- if party is a person
877: IF l_party_type = 'PERSON' THEN
878:

Line 903: IF aso_debug_pub.g_debug_flag = 'Y' THEN

899: x_return_status => l_return_status,
900: x_msg_count => l_msg_count,
901: x_msg_data => l_msg_data );
902:
903: IF aso_debug_pub.g_debug_flag = 'Y' THEN
904: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');
905: END IF;
906:
907: -- if party is an organization

Line 904: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');

900: x_msg_count => l_msg_count,
901: x_msg_data => l_msg_data );
902:
903: IF aso_debug_pub.g_debug_flag = 'Y' THEN
904: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');
905: END IF;
906:
907: -- if party is an organization
908: ELSIF l_party_type = 'ORGANIZATION' THEN

Line 933: IF aso_debug_pub.g_debug_flag = 'Y' THEN

929: x_return_status => l_return_status,
930: x_msg_count => l_msg_count,
931: x_msg_data => l_msg_data );
932:
933: IF aso_debug_pub.g_debug_flag = 'Y' THEN
934: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');
935: END IF;
936: END IF;
937:

Line 934: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');

930: x_msg_count => l_msg_count,
931: x_msg_data => l_msg_data );
932:
933: IF aso_debug_pub.g_debug_flag = 'Y' THEN
934: aso_debug_pub.add('create cust_acct:after create_acct:l_acct_id '||l_acct_id, 1, 'N');
935: END IF;
936: END IF;
937:
938:

Line 1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1050: l_customer_site_id := null;
1051: END IF;
1052: Close C_acct_site;
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('create acct_site:before create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');
1056: END IF;
1057: IF l_customer_site_id is not NULL THEN
1058: x_customer_site_id := l_customer_site_id ;

Line 1055: aso_debug_pub.add('create acct_site:before create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');

1051: END IF;
1052: Close C_acct_site;
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('create acct_site:before create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');
1056: END IF;
1057: IF l_customer_site_id is not NULL THEN
1058: x_customer_site_id := l_customer_site_id ;
1059: ELSE

Line 1077: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data );
1076:
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

Line 1078: aso_debug_pub.add('create acct_site:after create_site:l_customer_site_id '||l_customer_site_id, 1, 'N');

1074: x_msg_count => x_msg_count,
1075: x_msg_data => x_msg_data );
1076:
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

Line 1079: aso_debug_pub.add('create acct_site:after create_site:x_return_status '||x_return_status, 1, 'N');

1075: x_msg_data => x_msg_data );
1076:
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');

Line 1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1217:
1218: p_acct_site_uses_Rec.created_by_module := 'ASO_CUSTOMER_DATA';
1219: p_cust_profile_rec.created_by_module := 'ASO_CUSTOMER_DATA';
1220:
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

Line 1222: aso_debug_pub.add('create acct_site_use:p_cust_acct_site_id '||p_cust_acct_site_id, 1, 'N');

1218: p_acct_site_uses_Rec.created_by_module := 'ASO_CUSTOMER_DATA';
1219: p_cust_profile_rec.created_by_module := 'ASO_CUSTOMER_DATA';
1220:
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

Line 1235: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1231: ,x_msg_count => x_msg_count
1232: ,x_msg_data => x_msg_data
1233: ,x_customer_site_id => x_cust_acct_site_id
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;

Line 1236: aso_debug_pub.add('create acct_site_use:after create_site:x_cust_acct_site_id '||x_cust_acct_site_id, 1, 'N');

1232: ,x_msg_data => x_msg_data
1233: ,x_customer_site_id => x_cust_acct_site_id
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;

Line 1264: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1260: IF l_site_use_id is not NULL then
1261: x_site_use_id := l_site_use_id ;
1262: ELSE
1263:
1264: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1265: aso_debug_pub.add('create acct_site_use:x_site_use_id '||x_site_use_id, 1, 'N');
1266: END IF;
1267: OPEN C_location(l_party_site_id);
1268: FETCH C_location into l_location;

Line 1265: aso_debug_pub.add('create acct_site_use:x_site_use_id '||x_site_use_id, 1, 'N');

1261: x_site_use_id := l_site_use_id ;
1262: ELSE
1263:
1264: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1265: aso_debug_pub.add('create acct_site_use:x_site_use_id '||x_site_use_id, 1, 'N');
1266: END IF;
1267: OPEN C_location(l_party_site_id);
1268: FETCH C_location into l_location;
1269: IF (C_location%NOTFOUND) THEN

Line 1274: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1270: l_location := 'NO_LOCATION';
1271: END IF;
1272: CLOSE C_location;
1273:
1274: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1275: aso_debug_pub.add('create acct_site_use:l_location '||l_location, 1, 'N');
1276: END IF;
1277:
1278:

Line 1275: aso_debug_pub.add('create acct_site_use:l_location '||l_location, 1, 'N');

1271: END IF;
1272: CLOSE C_location;
1273:
1274: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1275: aso_debug_pub.add('create acct_site_use:l_location '||l_location, 1, 'N');
1276: END IF;
1277:
1278:
1279: -- added for bug 2291297

Line 1308: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1304: x_return_status => x_return_status,
1305: x_msg_count => x_msg_count,
1306: x_msg_data => x_msg_data );
1307:
1308: IF aso_debug_pub.g_debug_flag = 'Y' 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:

Line 1309: aso_debug_pub.add('create acct_site_use:create_acct_site_use:x_return_status '||x_return_status, 1, 'N');

1305: x_msg_count => x_msg_count,
1306: x_msg_data => x_msg_data );
1307:
1308: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1310: aso_debug_pub.add('create acct_site_use:create_acct_site_use:l_site_use_id '||l_site_use_id, 1, 'N');

1306: x_msg_data => x_msg_data );
1307:
1308: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1331: IF aso_debug_pub.g_debug_flag = 'Y' 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;
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(

Line 1332: aso_debug_pub.add('create acct_site_use:create_party_site_use:l_party_site_use '||l_party_site_use, 1, 'N');

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;
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,

Line 1343: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1339: x_party_site_use_id => lx_party_site_use_id,
1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data);
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

Line 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');

1340: x_return_status => x_return_status,
1341: x_msg_count => x_msg_count,
1342: x_msg_data => x_msg_data);
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;

Line 1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1458: -- changes in version 2 api's.
1459:
1460: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('create con:p_party_id '||p_party_id, 1, 'N');
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;

Line 1463: aso_debug_pub.add('create con:p_party_id '||p_party_id, 1, 'N');

1459:
1460: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('create con:p_party_id '||p_party_id, 1, 'N');
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

Line 1464: aso_debug_pub.add('create con:p_org_contact_id '||p_org_contact_id, 1, 'N');

1460: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1461:
1462: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1463: aso_debug_pub.add('create con:p_party_id '||p_party_id, 1, 'N');
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

Line 1485: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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
1486: aso_debug_pub.add('create con:derive from org_contact:l_party_id '||l_party_id, 1, 'N');
1487: END IF;
1488:
1489: END IF; -- org contact id is not null

Line 1486: aso_debug_pub.add('create con:derive from org_contact:l_party_id '||l_party_id, 1, 'N');

1482: END IF;
1483: Close C_party;
1484:
1485: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1486: aso_debug_pub.add('create con:derive from org_contact:l_party_id '||l_party_id, 1, 'N');
1487: END IF;
1488:
1489: END IF; -- org contact id is not null
1490: END IF; -- party id is null

Line 1494: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
1497: -- for now role type is always 'CONTACT'
1498: l_role_type := 'CONTACT';

Line 1495: aso_debug_pub.add('create con:l_party_id '||l_party_id, 1, 'N');

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;
1497: -- for now role type is always 'CONTACT'
1498: l_role_type := 'CONTACT';
1499:

Line 1509: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1505: l_cust_account_role_id := NULL;
1506: END IF;
1507: CLOSE C_contact;
1508:
1509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1510: aso_debug_pub.add('create con:l_cust_account_role_id '||l_cust_account_role_id, 1, 'N');
1511: aso_debug_pub.add('create con:before create_acct_role:p_cust_account_id '||p_cust_account_id, 1, 'N');
1512: END IF;
1513:

Line 1510: aso_debug_pub.add('create con:l_cust_account_role_id '||l_cust_account_role_id, 1, 'N');

1506: END IF;
1507: CLOSE C_contact;
1508:
1509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1510: aso_debug_pub.add('create con:l_cust_account_role_id '||l_cust_account_role_id, 1, 'N');
1511: aso_debug_pub.add('create con:before create_acct_role:p_cust_account_id '||p_cust_account_id, 1, 'N');
1512: END IF;
1513:
1514: IF l_cust_account_role_id is not NULL THEN

Line 1511: aso_debug_pub.add('create con:before create_acct_role:p_cust_account_id '||p_cust_account_id, 1, 'N');

1507: CLOSE C_contact;
1508:
1509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1510: aso_debug_pub.add('create con:l_cust_account_role_id '||l_cust_account_role_id, 1, 'N');
1511: aso_debug_pub.add('create con:before create_acct_role:p_cust_account_id '||p_cust_account_id, 1, 'N');
1512: END IF;
1513:
1514: IF l_cust_account_role_id is not NULL THEN
1515: x_cust_account_role_id:= l_cust_account_role_id;

Line 1538: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1534: x_return_status => x_return_status,
1535: x_msg_count => x_msg_count,
1536: x_msg_data => x_msg_data );
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)

Line 1539: aso_debug_pub.add('create con:after create_acct_role:x_cust_account_role_id '||x_cust_account_role_id, 1, 'N');

1535: x_msg_count => x_msg_count,
1536: x_msg_data => x_msg_data );
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

Line 1669: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1665: x_party_id := null;
1666: x_org_contact_id := null;
1667: l_header_party_id := p_header_party_id;
1668:
1669: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1670: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');

1666: x_org_contact_id := null;
1667: l_header_party_id := p_header_party_id;
1668:
1669: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1688: raise FND_API.G_EXC_ERROR;
1689: END IF;
1690: END IF;
1691:
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1693: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');
1694: aso_debug_pub.add('create org_con_ord:l_party_type '||l_party_type, 1, 'N');
1695: END IF;
1696:

Line 1693: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');

1689: END IF;
1690: END IF;
1691:
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1693: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');
1694: aso_debug_pub.add('create org_con_ord:l_party_type '||l_party_type, 1, 'N');
1695: END IF;
1696:
1697: /*--- As per Edd Jentzsch suggestion we need not create an org contact for a

Line 1694: aso_debug_pub.add('create org_con_ord:l_party_type '||l_party_type, 1, 'N');

1690: END IF;
1691:
1692: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1693: aso_debug_pub.add('create org_con_ord:l_header_party_id '||l_header_party_id, 1, 'N');
1694: aso_debug_pub.add('create org_con_ord:l_party_type '||l_party_type, 1, 'N');
1695: END IF;
1696:
1697: /*--- As per Edd Jentzsch suggestion we need not create an org contact for a
1698: -- B2C case.

Line 1724: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1720: l_org_contact_id := NULL;
1721: END IF;
1722: Close C_org_contact;
1723:
1724: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1725: aso_debug_pub.add('create org_con_ord:l_org_contact_id '||l_org_contact_id, 1, 'N');

1721: END IF;
1722: Close C_org_contact;
1723:
1724: IF aso_debug_pub.g_debug_flag = 'Y' 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

Line 1755: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1751: x_msg_count => x_msg_count,
1752: x_msg_data => x_msg_data );
1753:
1754:
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

Line 1756: aso_debug_pub.add('create org_con_ord:after create_org_con:l_org_contact_id '||l_org_contact_id, 1, 'N');

1752: x_msg_data => x_msg_data );
1753:
1754:
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)

Line 1757: aso_debug_pub.add('create org_con_ord:after create_org_con:x_return_status '||x_return_status, 1, 'N');

1753:
1754:
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

Line 1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1872:
1873: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1874: p_role_resp_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1875:
1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');

Line 1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');

1873: p_cust_acct_roles_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1874: p_role_resp_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1875:
1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');

Line 1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');

1874: p_role_resp_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
1875:
1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
1882: aso_debug_pub.add('create_contact_role: p_begin_date: '||p_begin_date,1,'N');

Line 1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');

1875:
1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
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');

Line 1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');

1876: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
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;

Line 1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');

1877: aso_debug_pub.add('create_contact_role: p_party_id: '||p_party_id,1,'N');
1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
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:

Line 1882: aso_debug_pub.add('create_contact_role: p_begin_date: '||p_begin_date,1,'N');

1878: aso_debug_pub.add('create_contact_role: p_cust_account_id: '||p_cust_account_id,1,'N');
1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
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

Line 1883: aso_debug_pub.add('create_contact_role: p_role_id: '||p_role_id,1,'N');

1879: aso_debug_pub.add('create_contact_role: p_cust_account_site_id: '||p_cust_account_site_id,1,'N');
1880: aso_debug_pub.add('create_contact_role: p_role_type: '||p_role_type,1,'N');
1881: aso_debug_pub.add('create_contact_role: p_responsibility_type: '||p_responsibility_type,1,'N');
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;

Line 1896: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1892: -- p_cust_acct_roles_rec.begin_date := p_begin_date;
1893:
1894: p_cust_acct_roles_rec.cust_acct_site_id := p_cust_account_site_id;
1895:
1896: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1897: aso_debug_pub.add('before create cust acct roles',1,'N');
1898: END IF;
1899:
1900: /*

Line 1897: aso_debug_pub.add('before create cust acct roles',1,'N');

1893:
1894: p_cust_acct_roles_rec.cust_acct_site_id := p_cust_account_site_id;
1895:
1896: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1897: aso_debug_pub.add('before create cust acct roles',1,'N');
1898: END IF;
1899:
1900: /*
1901: The call to create_cust_acct_roles has been moved to a diff package in version 2 api.

Line 1913: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1909: x_return_status => x_return_status,
1910: x_msg_count => x_msg_count,
1911: x_msg_data => x_msg_data );
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;

Line 1914: aso_debug_pub.add('create_contact_role:after create_cust_acct_role: x_return_status: '||x_return_status,1,'N');

1910: x_msg_count => x_msg_count,
1911: x_msg_data => x_msg_data );
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

Line 1932: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1928:
1929: OPEN C_Get_Resp(x_cust_account_role_id, p_responsibility_type);
1930: FETCH C_Get_Resp INTO l_responsibility_id;
1931:
1932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1933: aso_debug_pub.add('create_contact_role:l_responsibility_id: '||l_responsibility_id,1,'N');
1934: END IF;
1935: IF C_Get_Resp%NOTFOUND THEN
1936:

Line 1933: aso_debug_pub.add('create_contact_role:l_responsibility_id: '||l_responsibility_id,1,'N');

1929: OPEN C_Get_Resp(x_cust_account_role_id, p_responsibility_type);
1930: FETCH C_Get_Resp INTO l_responsibility_id;
1931:
1932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1933: aso_debug_pub.add('create_contact_role:l_responsibility_id: '||l_responsibility_id,1,'N');
1934: END IF;
1935: IF C_Get_Resp%NOTFOUND THEN
1936:
1937: IF p_cust_account_site_id is not NULL AND

Line 1957: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1953: x_return_status => x_return_status,
1954: x_msg_count => x_msg_count,
1955: x_msg_data => x_msg_data );
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

Line 1958: aso_debug_pub.add('create_contact_role:after create_role_resp: x_return_status: '||x_return_status,1,'N');

1954: x_msg_count => x_msg_count,
1955: x_msg_data => x_msg_data );
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');

Line 2051: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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;
2054:
2055: ASO_MAP_QUOTE_ORDER_INT.get_acct_site_uses (

Line 2052: aso_debug_pub.add('ASO_PARTY_INT.get_acct_site_use:P_Acct_Site_type: '||P_Acct_Site_type,1,'N');

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;
2054:
2055: ASO_MAP_QUOTE_ORDER_INT.get_acct_site_uses (
2056: p_party_site_id => P_Party_Site_Id,

Line 2063: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2059: x_return_status => x_return_status,
2060: x_site_use_id => x_site_use_id
2061: );
2062:
2063: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2064: aso_debug_pub.add('ASO_PARTY_INT.get_acct_site_use:x_site_use_id: '||x_site_use_id,1,'N');
2065: END IF;
2066:
2067: END GET_ACCT_SITE_USES;

Line 2064: aso_debug_pub.add('ASO_PARTY_INT.get_acct_site_use:x_site_use_id: '||x_site_use_id,1,'N');

2060: x_site_use_id => x_site_use_id
2061: );
2062:
2063: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2064: aso_debug_pub.add('ASO_PARTY_INT.get_acct_site_use:x_site_use_id: '||x_site_use_id,1,'N');
2065: END IF;
2066:
2067: END GET_ACCT_SITE_USES;
2068:

Line 2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2174: CLOSE C_acct_number;
2175: account_rec.account_number := 'ASO'||account_rec.account_number;
2176: END IF;
2177: -- figure OUT NOCOPY /* file.sql.39 change */ if the party is a person or an organization
2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2179: aso_debug_pub.add('create_cust_acct:P_Party_id: '||P_Party_id,1,'N');
2180: END IF;
2181: OPEN C_party_info(P_Party_id);
2182: FETCH C_party_info INTO l_party_type, l_party_name;

Line 2179: aso_debug_pub.add('create_cust_acct:P_Party_id: '||P_Party_id,1,'N');

2175: account_rec.account_number := 'ASO'||account_rec.account_number;
2176: END IF;
2177: -- figure OUT NOCOPY /* file.sql.39 change */ if the party is a person or an organization
2178: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2179: aso_debug_pub.add('create_cust_acct:P_Party_id: '||P_Party_id,1,'N');
2180: END IF;
2181: OPEN C_party_info(P_Party_id);
2182: FETCH C_party_info INTO l_party_type, l_party_name;
2183: IF (C_party_info%NOTFOUND) THEN

Line 2192: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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');
2194: END IF;
2195: -- if party is a relationship
2196: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2193: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');

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');
2194: END IF;
2195: -- if party is a relationship
2196: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
2197: OPEN c_party_rel_rec(P_Party_id);

Line 2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2215: END IF;
2216:
2217: account_rec.account_name := substr(l_party_name,1,240);
2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');
2221: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_name,1,'N');
2222: aso_debug_pub.add('create_cust_acct:customer_party_id: '||customer_party_id,1,'N');
2223: END IF;

Line 2220: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');

2216:
2217: account_rec.account_name := substr(l_party_name,1,240);
2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');
2221: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_name,1,'N');
2222: aso_debug_pub.add('create_cust_acct:customer_party_id: '||customer_party_id,1,'N');
2223: END IF;
2224: -- if party is a person

Line 2221: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_name,1,'N');

2217: account_rec.account_name := substr(l_party_name,1,240);
2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');
2221: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_name,1,'N');
2222: aso_debug_pub.add('create_cust_acct:customer_party_id: '||customer_party_id,1,'N');
2223: END IF;
2224: -- if party is a person
2225: IF l_party_type = 'PERSON' THEN

Line 2222: aso_debug_pub.add('create_cust_acct:customer_party_id: '||customer_party_id,1,'N');

2218:
2219: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2220: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_type,1,'N');
2221: aso_debug_pub.add('create_cust_acct:l_party_type: '||l_party_name,1,'N');
2222: aso_debug_pub.add('create_cust_acct:customer_party_id: '||customer_party_id,1,'N');
2223: END IF;
2224: -- if party is a person
2225: IF l_party_type = 'PERSON' THEN
2226: person_rec.party_rec := p_party_rec;

Line 2282: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2278: x_msg_data => x_msg_data );
2279:
2280:
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

Line 2283: aso_debug_pub.add('create_cust_acct:after create_acct:l_acct_id: '||l_acct_id,1,'N');

2279:
2280:
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');

Line 2396: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2392: --Fix for Bug 5855375
2393: l_cust_acct_relate_rec.bill_to_flag := 'N';
2394: l_cust_acct_relate_rec.ship_to_flag := 'N';
2395:
2396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2397: aso_debug_pub.add('p_related_cust_account = ' || p_related_cust_account, 1,'N');
2398: aso_debug_pub.add('sold_to_cust_account = ' || p_sold_to_cust_account, 1,'N');
2399: aso_debug_pub.add('relationship_type = ' || p_relationship_type,1,'N');
2400: END IF;

Line 2397: aso_debug_pub.add('p_related_cust_account = ' || p_related_cust_account, 1,'N');

2393: l_cust_acct_relate_rec.bill_to_flag := 'N';
2394: l_cust_acct_relate_rec.ship_to_flag := 'N';
2395:
2396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2397: aso_debug_pub.add('p_related_cust_account = ' || p_related_cust_account, 1,'N');
2398: aso_debug_pub.add('sold_to_cust_account = ' || p_sold_to_cust_account, 1,'N');
2399: aso_debug_pub.add('relationship_type = ' || p_relationship_type,1,'N');
2400: END IF;
2401:

Line 2398: aso_debug_pub.add('sold_to_cust_account = ' || p_sold_to_cust_account, 1,'N');

2394: l_cust_acct_relate_rec.ship_to_flag := 'N';
2395:
2396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2397: aso_debug_pub.add('p_related_cust_account = ' || p_related_cust_account, 1,'N');
2398: aso_debug_pub.add('sold_to_cust_account = ' || p_sold_to_cust_account, 1,'N');
2399: aso_debug_pub.add('relationship_type = ' || p_relationship_type,1,'N');
2400: END IF;
2401:
2402: IF p_relationship_type = 'BILL_TO' then

Line 2399: aso_debug_pub.add('relationship_type = ' || p_relationship_type,1,'N');

2395:
2396: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2397: aso_debug_pub.add('p_related_cust_account = ' || p_related_cust_account, 1,'N');
2398: aso_debug_pub.add('sold_to_cust_account = ' || p_sold_to_cust_account, 1,'N');
2399: aso_debug_pub.add('relationship_type = ' || p_relationship_type,1,'N');
2400: END IF;
2401:
2402: IF p_relationship_type = 'BILL_TO' then
2403: l_cust_acct_relate_rec.bill_to_flag := 'Y';

Line 2410: IF aso_debug_pub.g_debug_flag = 'Y' THEN

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');
2412: END IF;
2413:
2414: /*

Line 2411: aso_debug_pub.add('enter cust1 and finish setup',1,'N');

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');
2412: END IF;
2413:
2414: /*
2415: The call to .create_cust_acct_relate has been moved to a diff package in version 2 api

Line 2426: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2422: x_return_status => x_return_status,
2423: x_msg_count => x_msg_count,
2424: x_msg_data => x_msg_data );
2425:
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

Line 2427: aso_debug_pub.add('finish call create_cust_acct_relate and ' || x_return_status, 1, 'N');

2423: x_msg_count => x_msg_count,
2424: x_msg_data => x_msg_data );
2425:
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;

Line 2519: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2515: -- changes in version 2 api's.
2516:
2517: l_party_site_use_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
2518:
2519: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2520: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_id ' || p_party_site_id, 1, 'N');
2521: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_use_type ' || p_party_site_use_type, 1, 'N');
2522: END IF;
2523: l_party_site_use_rec.party_site_id := p_party_site_id;

Line 2520: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_id ' || p_party_site_id, 1, 'N');

2516:
2517: l_party_site_use_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
2518:
2519: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2520: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_id ' || p_party_site_id, 1, 'N');
2521: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_use_type ' || p_party_site_use_type, 1, 'N');
2522: END IF;
2523: l_party_site_use_rec.party_site_id := p_party_site_id;
2524:

Line 2521: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_use_type ' || p_party_site_use_type, 1, 'N');

2517: l_party_site_use_rec.Created_by_Module := 'ASO_CUSTOMER_DATA';
2518:
2519: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2520: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_id ' || p_party_site_id, 1, 'N');
2521: aso_debug_pub.add('create_pty_site_use:before create_pty_site_use:p_party_site_use_type ' || p_party_site_use_type, 1, 'N');
2522: END IF;
2523: l_party_site_use_rec.party_site_id := p_party_site_id;
2524:
2525: -- Begin_date has been deleted in version 2 api.

Line 2543: IF aso_debug_pub.g_debug_flag = 'Y' THEN

2539: x_msg_count => x_msg_count,
2540: x_msg_data => x_msg_data );
2541:
2542:
2543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2544: 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');
2545: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2544: 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');

2540: x_msg_data => x_msg_data );
2541:
2542:
2543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2544: 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');
2545: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: RAISE FND_API.G_EXC_ERROR;

Line 2545: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');

2541:
2542:
2543: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2544: 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');
2545: aso_debug_pub.add('create_pty_site_use:after create_pty_site_use:x_return_status ' || x_return_status, 1, 'N');
2546: END IF;
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: RAISE FND_API.G_EXC_ERROR;
2549: END IF;