APPS.AR_CUST_PROF_CLASS_AMT_PKG dependencies on AR_CUST_PROF_CLASS_AMT_PKG

Line 1: PACKAGE BODY ar_cust_prof_class_amt_pkg AS

1: PACKAGE BODY ar_cust_prof_class_amt_pkg AS
2: /* $Header: ARCPCMTB.pls 120.0 2006/03/02 23:42:23 hyu noship $ */
3:
4: FUNCTION validate_lookup
5: (p_type IN VARCHAR2,

Line 419: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row +');

415: SELECT hz_cust_prof_class_amts_s.nextval
416: from dual;
417: l_cust_prof_class_amt_id NUMBER;
418: BEGIN
419: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row +');
420:
421: x_return_status := fnd_api.g_ret_Sts_success;
422:
423: fnd_msg_pub.initialize;

Line 644: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row -');

640: P_LAST_UPDATE_LOGIN);
641:
642: arp_standard.debug(' Inserting into hz_cust_prof_class_amts-');
643:
644: arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row -');
645: EXCEPTION
646: WHEN fnd_api.G_EXC_ERROR THEN
647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
648: p_count => x_msg_count,

Line 650: arp_standard.debug('EXCEPTION IN ar_cust_prof_class_amt_pkg.insert_row:'||x_msg_data);

646: WHEN fnd_api.G_EXC_ERROR THEN
647: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
648: p_count => x_msg_count,
649: p_data => x_msg_data);
650: arp_standard.debug('EXCEPTION IN ar_cust_prof_class_amt_pkg.insert_row:'||x_msg_data);
651:
652: WHEN OTHERS THEN
653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 660: arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.insert_row:'||SQLERRM);

656: fnd_msg_pub.add;
657: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
658: p_count => x_msg_count,
659: p_data => x_msg_data);
660: arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.insert_row:'||SQLERRM);
661: END;
662:
663:
664:

Line 961: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.lock_row:'||x_msg_data);

957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data);
961: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.lock_row:'||x_msg_data);
962:
963: WHEN OTHERS THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

Line 972: arp_standard.debug('EXCEPTION OTHERS ar_cust_prof_class_amt_pkg.lock_row:'||x_msg_data);

968: FND_MSG_PUB.Count_And_Get(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_msg_count,
971: p_data => x_msg_data);
972: arp_standard.debug('EXCEPTION OTHERS ar_cust_prof_class_amt_pkg.lock_row:'||x_msg_data);
973: END;
974:
975:
976:

Line 1065: arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row +');

1061: x_msg_count OUT NOCOPY NUMBER,
1062: x_msg_data OUT NOCOPY VARCHAR2)
1063: IS
1064: BEGIN
1065: arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row +');
1066: arp_standard.debug(' P_PROFILE_CLASS_AMOUNT_ID :'||P_PROFILE_CLASS_AMOUNT_ID);
1067:
1068: x_return_status := fnd_api.g_ret_Sts_success;
1069:

Line 1194: arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row -');

1190: WHERE PROFILE_CLASS_AMOUNT_ID = P_PROFILE_CLASS_AMOUNT_ID;
1191:
1192: arp_standard.debug(' updating hz_cust_prof_class_amts -');
1193:
1194: arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row -');
1195: EXCEPTION
1196: WHEN FND_API.G_EXC_ERROR THEN
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.Count_And_Get(

Line 1202: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.update_row:'||x_msg_data);

1198: FND_MSG_PUB.Count_And_Get(
1199: p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.update_row:'||x_msg_data);
1203:
1204: WHEN OTHERS THEN
1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1212: arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.update_row:'||SQLERRM);

1208: fnd_msg_pub.add;
1209: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data);
1212: arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.update_row:'||SQLERRM);
1213: END;
1214:
1215:
1216: