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.AR_CUST_PROF_CLASS_AMT_PKG dependencies on STANDARD

Line 74: arp_standard.debug('int_chrg_validation +');

70: p_schedule_id IN NUMBER,
71: x_return_status IN OUT NOCOPY VARCHAR2)
72: IS
73: BEGIN
74: arp_standard.debug('int_chrg_validation +');
75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);

Line 75: arp_standard.debug(' p_int_pen : '|| p_int_pen);

71: x_return_status IN OUT NOCOPY VARCHAR2)
72: IS
73: BEGIN
74: arp_standard.debug('int_chrg_validation +');
75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);

Line 76: arp_standard.debug(' p_type : '|| p_type);

72: IS
73: BEGIN
74: arp_standard.debug('int_chrg_validation +');
75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);
80: IF P_TYPE IS NOT NULL THEN

Line 77: arp_standard.debug(' p_amount : '|| p_amount);

73: BEGIN
74: arp_standard.debug('int_chrg_validation +');
75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);
80: IF P_TYPE IS NOT NULL THEN
81: IF validate_lookup('AR_INTEREST_PENALTY_TYPE' ,P_TYPE) = FALSE THEN

Line 78: arp_standard.debug(' p_rate : '|| p_rate);

74: arp_standard.debug('int_chrg_validation +');
75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);
80: IF P_TYPE IS NOT NULL THEN
81: IF validate_lookup('AR_INTEREST_PENALTY_TYPE' ,P_TYPE) = FALSE THEN
82: arp_standard.debug(P_TYPE||' should be a code in the lookup type AR_INTEREST_PENALTY_TYPE');

Line 79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);

75: arp_standard.debug(' p_int_pen : '|| p_int_pen);
76: arp_standard.debug(' p_type : '|| p_type);
77: arp_standard.debug(' p_amount : '|| p_amount);
78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);
80: IF P_TYPE IS NOT NULL THEN
81: IF validate_lookup('AR_INTEREST_PENALTY_TYPE' ,P_TYPE) = FALSE THEN
82: arp_standard.debug(P_TYPE||' should be a code in the lookup type AR_INTEREST_PENALTY_TYPE');
83: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

Line 82: arp_standard.debug(P_TYPE||' should be a code in the lookup type AR_INTEREST_PENALTY_TYPE');

78: arp_standard.debug(' p_rate : '|| p_rate);
79: arp_standard.debug(' p_schedule_id : '|| p_schedule_id);
80: IF P_TYPE IS NOT NULL THEN
81: IF validate_lookup('AR_INTEREST_PENALTY_TYPE' ,P_TYPE) = FALSE THEN
82: arp_standard.debug(P_TYPE||' should be a code in the lookup type AR_INTEREST_PENALTY_TYPE');
83: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
84: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_int_pen||'_TYPE' );
85: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'AR_INTEREST_PENALTY_TYPE' );
86: FND_MSG_PUB.ADD;

Line 91: arp_standard.debug(p_int_pen||'_FIXED_AMOUNT is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);

87: x_return_status := FND_API.G_RET_STS_ERROR;
88: ELSE
89: IF P_TYPE = 'FIXED_AMOUNT' THEN
90: IF P_AMOUNT IS NULL THEN
91: arp_standard.debug(p_int_pen||'_FIXED_AMOUNT is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);
92: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
93: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_int_pen||'_FIXED_AMOUNT' );
94: FND_MSG_PUB.ADD;
95: x_return_status := FND_API.G_RET_STS_ERROR;

Line 99: arp_standard.debug(p_int_pen||'_RATE is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);

95: x_return_status := FND_API.G_RET_STS_ERROR;
96: END IF;
97: ELSIF P_TYPE = 'FIXED_RATE' THEN
98: IF P_RATE IS NULL THEN
99: arp_standard.debug(p_int_pen||'_RATE is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);
100: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
101: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_int_pen||'_RATE' );
102: FND_MSG_PUB.ADD;
103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 107: arp_standard.debug(p_int_pen||'_SCHEDULE_ID is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);

103: x_return_status := FND_API.G_RET_STS_ERROR;
104: END IF;
105: ELSIF P_TYPE = 'CHARGES_SCHEDULE' THEN
106: IF P_SCHEDULE_ID IS NULL THEN
107: arp_standard.debug(p_int_pen||'_SCHEDULE_ID is mandatory for '||p_int_pen||'_TYPE ='||P_TYPE);
108: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
109: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_int_pen||'_RATE' );
110: FND_MSG_PUB.ADD;
111: x_return_status := FND_API.G_RET_STS_ERROR;

Line 116: arp_standard.debug('int_chrg_validation -');

112: END IF;
113: END IF;
114: END IF;
115: END IF;
116: arp_standard.debug('int_chrg_validation -');
117: END;
118:
119:
120:

Line 129: arp_standard.debug('amt_pct_validation +');

125: p_percent IN NUMBER,
126: x_return_status IN OUT NOCOPY VARCHAR2)
127: IS
128: BEGIN
129: arp_standard.debug('amt_pct_validation +');
130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);
131: arp_standard.debug(' p_type : '||p_type);
132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);

Line 130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);

126: x_return_status IN OUT NOCOPY VARCHAR2)
127: IS
128: BEGIN
129: arp_standard.debug('amt_pct_validation +');
130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);
131: arp_standard.debug(' p_type : '||p_type);
132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);
134: IF p_type IS NOT NULL THEN

Line 131: arp_standard.debug(' p_type : '||p_type);

127: IS
128: BEGIN
129: arp_standard.debug('amt_pct_validation +');
130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);
131: arp_standard.debug(' p_type : '||p_type);
132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);
134: IF p_type IS NOT NULL THEN
135: IF validate_lookup('AR_AMOUNT_PERCENT',p_type) = FALSE THEN

Line 132: arp_standard.debug(' p_amount : '||p_amount);

128: BEGIN
129: arp_standard.debug('amt_pct_validation +');
130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);
131: arp_standard.debug(' p_type : '||p_type);
132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);
134: IF p_type IS NOT NULL THEN
135: IF validate_lookup('AR_AMOUNT_PERCENT',p_type) = FALSE THEN
136: arp_standard.debug(p_type||' should be a code in the lookup type AR_AMOUNT_PERCENT');

Line 133: arp_standard.debug(' p_percent : '||p_percent);

129: arp_standard.debug('amt_pct_validation +');
130: arp_standard.debug(' p_inv_bal : '||p_inv_bal);
131: arp_standard.debug(' p_type : '||p_type);
132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);
134: IF p_type IS NOT NULL THEN
135: IF validate_lookup('AR_AMOUNT_PERCENT',p_type) = FALSE THEN
136: arp_standard.debug(p_type||' should be a code in the lookup type AR_AMOUNT_PERCENT');
137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

Line 136: arp_standard.debug(p_type||' should be a code in the lookup type AR_AMOUNT_PERCENT');

132: arp_standard.debug(' p_amount : '||p_amount);
133: arp_standard.debug(' p_percent : '||p_percent);
134: IF p_type IS NOT NULL THEN
135: IF validate_lookup('AR_AMOUNT_PERCENT',p_type) = FALSE THEN
136: arp_standard.debug(p_type||' should be a code in the lookup type AR_AMOUNT_PERCENT');
137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
138: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_'|| p_inv_bal ||'_OVERDUE_TYPE' );
139: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'AR_AMOUNT_PERCENT' );
140: FND_MSG_PUB.ADD;

Line 145: arp_standard.debug('MIN_FC_'|| p_inv_bal ||'_AMOUNT is Mandatory for this MIN_FC_'|| p_inv_bal ||'_OVERDUE_TYPE '||

141: x_return_status := FND_API.G_RET_STS_ERROR;
142: END IF;
143: IF P_TYPE = 'AMOUNT' THEN
144: IF P_AMOUNT IS NULL THEN
145: arp_standard.debug('MIN_FC_'|| p_inv_bal ||'_AMOUNT is Mandatory for this MIN_FC_'|| p_inv_bal ||'_OVERDUE_TYPE '||
146: P_TYPE);
147: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
148: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_INVOICE_AMOUNT' );
149: FND_MSG_PUB.ADD;

Line 154: arp_standard.debug('MIN_FC_'|| p_inv_bal ||'_PERCENT is Mandatory for this MIN_FC_'|| p_inv_bal ||'_OVERDUE_TYPE '||

150: x_return_status := FND_API.G_RET_STS_ERROR;
151: END IF;
152: ELSIF P_TYPE = 'PERCENT' THEN
153: IF P_PERCENT IS NULL THEN
154: arp_standard.debug('MIN_FC_'|| p_inv_bal ||'_PERCENT is Mandatory for this MIN_FC_'|| p_inv_bal ||'_OVERDUE_TYPE '||
155: P_TYPE);
156: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
157: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_'|| p_inv_bal ||'_PERCENT' );
158: FND_MSG_PUB.ADD;

Line 163: arp_standard.debug('amt_pct_validation -');

159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;
161: END IF;
162: END IF;
163: arp_standard.debug('amt_pct_validation -');
164: END;
165:
166: PROCEDURE validate_exchange_type
167: (p_exchange_rate_type IN VARCHAR2,

Line 177: arp_standard.debug('validate_exchange_type +');

173: WHERE conversion_type <> 'EMU FIXED'
174: AND conversion_type = p_exchange_rate_type;
175: l VARCHAR2(1);
176: BEGIN
177: arp_standard.debug('validate_exchange_type +');
178: arp_standard.debug(' p_exchange_rate_type : '||p_exchange_rate_type);
179: IF p_exchange_rate_type IS NOT NULL THEN
180: OPEN c;
181: FETCH c INTO l;

Line 178: arp_standard.debug(' p_exchange_rate_type : '||p_exchange_rate_type);

174: AND conversion_type = p_exchange_rate_type;
175: l VARCHAR2(1);
176: BEGIN
177: arp_standard.debug('validate_exchange_type +');
178: arp_standard.debug(' p_exchange_rate_type : '||p_exchange_rate_type);
179: IF p_exchange_rate_type IS NOT NULL THEN
180: OPEN c;
181: FETCH c INTO l;
182: IF c%NOTFOUND THEN

Line 183: arp_standard.debug(' The value p_exchange_rate_type :'||p_exchange_rate_type||' is invalid');

179: IF p_exchange_rate_type IS NOT NULL THEN
180: OPEN c;
181: FETCH c INTO l;
182: IF c%NOTFOUND THEN
183: arp_standard.debug(' The value p_exchange_rate_type :'||p_exchange_rate_type||' is invalid');
184: FND_MESSAGE.SET_NAME( 'AR', 'AR_EXC_TYPE_WRONG_VALUE' );
185: FND_MSG_PUB.ADD;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: END IF;

Line 190: arp_standard.debug('validate_exchange_type -');

186: x_return_status := FND_API.G_RET_STS_ERROR;
187: END IF;
188: CLOSE c;
189: END IF;
190: arp_standard.debug('validate_exchange_type -');
191: END;
192:
193:
194: PROCEDURE validate_prof_class_amt

Line 228: arp_standard.debug('validate_prof_class_amt +');

224: FROM fnd_currencies
225: WHERE currency_code = p_currency_code;
226: l_code VARCHAR2(30);
227: BEGIN
228: arp_standard.debug('validate_prof_class_amt +');
229:
230: IF p_currency_code IS NULL THEN
231: arp_standard.debug('Currency_code is Mandatory');
232: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line 231: arp_standard.debug('Currency_code is Mandatory');

227: BEGIN
228: arp_standard.debug('validate_prof_class_amt +');
229:
230: IF p_currency_code IS NULL THEN
231: arp_standard.debug('Currency_code is Mandatory');
232: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CURRENCY_CODE' );
234: FND_MSG_PUB.ADD;
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');

237:
238: OPEN curr;
239: FETCH curr INTO l_code;
240: IF curr%NOTFOUND THEN
241: arp_standard.debug(p_currency_code||' should be a in fnd_currencies');
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
243: FND_MESSAGE.SET_TOKEN('FK', 'hz_cust_prof_class_amts');
244: FND_MESSAGE.SET_TOKEN('COLUMN', 'CURRENCY_CODE');
245: FND_MESSAGE.SET_TOKEN('TABLE', 'fnd_currencies');

Line 254: arp_standard.debug(P_MIN_FC_INVOICE_OVERDUE_TYPE||' should be a code in the lookup type AR_AMOUNT_PERCENT');

250:
251:
252: IF P_MIN_FC_INVOICE_OVERDUE_TYPE IS NOT NULL THEN
253: IF validate_lookup('AR_AMOUNT_PERCENT',P_MIN_FC_INVOICE_OVERDUE_TYPE) = FALSE THEN
254: arp_standard.debug(P_MIN_FC_INVOICE_OVERDUE_TYPE||' should be a code in the lookup type AR_AMOUNT_PERCENT');
255: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
256: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_INVOICE_OVERDUE_TYPE' );
257: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'AR_AMOUNT_PERCENT' );
258: FND_MSG_PUB.ADD;

Line 263: arp_standard.debug('MIN_FC_INVOICE_AMOUNT is Mandatory for this MIN_FC_INVOICE_OVERDUE_TYPE '||

259: x_return_status := FND_API.G_RET_STS_ERROR;
260: END IF;
261: IF P_MIN_FC_INVOICE_OVERDUE_TYPE = 'AMOUNT' THEN
262: IF P_MIN_FC_INVOICE_AMOUNT IS NULL THEN
263: arp_standard.debug('MIN_FC_INVOICE_AMOUNT is Mandatory for this MIN_FC_INVOICE_OVERDUE_TYPE '||
264: P_MIN_FC_INVOICE_OVERDUE_TYPE);
265: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
266: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_INVOICE_AMOUNT' );
267: FND_MSG_PUB.ADD;

Line 272: arp_standard.debug('MIN_FC_INVOICE_PERCENT is Mandatory for this MIN_FC_INVOICE_OVERDUE_TYPE '||

268: x_return_status := FND_API.G_RET_STS_ERROR;
269: END IF;
270: ELSIF P_MIN_FC_INVOICE_OVERDUE_TYPE = 'PERCENT' THEN
271: IF P_MIN_FC_INVOICE_PERCENT IS NULL THEN
272: arp_standard.debug('MIN_FC_INVOICE_PERCENT is Mandatory for this MIN_FC_INVOICE_OVERDUE_TYPE '||
273: P_MIN_FC_INVOICE_OVERDUE_TYPE);
274: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
275: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'MIN_FC_INVOICE_PERCENT' );
276: FND_MSG_PUB.ADD;

Line 318: arp_standard.debug('validate_prof_class_amt -');

314: p_rate => P_PENALTY_RATE,
315: p_schedule_id => P_PENALTY_SCHEDULE_ID,
316: x_return_status => x_return_status);
317:
318: arp_standard.debug('validate_prof_class_amt -');
319: END;
320:
321:
322:

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 457: arp_standard.debug(' Inserting into hz_cust_prof_class_amts+');

453: IF x_return_status <> fnd_api.g_ret_Sts_success THEN
454: RAISE fnd_api.G_EXC_ERROR;
455: END IF;
456:
457: arp_standard.debug(' Inserting into hz_cust_prof_class_amts+');
458:
459: IF P_PROFILE_CLASS_AMOUNT_ID IS NULL THEN
460: OPEN cseq;
461: FETCH cseq INTO l_cust_prof_class_amt_id;

Line 467: arp_standard.debug('P_TRX_CREDIT_LIMIT :'||P_TRX_CREDIT_LIMIT );

463: ELSE
464: l_cust_prof_class_amt_id := P_PROFILE_CLASS_AMOUNT_ID;
465: END IF;
466:
467: arp_standard.debug('P_TRX_CREDIT_LIMIT :'||P_TRX_CREDIT_LIMIT );
468:
469: INSERT INTO hz_cust_prof_class_Amts
470: (PROFILE_CLASS_AMOUNT_ID ,
471: PROFILE_CLASS_ID ,

Line 642: arp_standard.debug(' Inserting into hz_cust_prof_class_amts-');

638: P_CREATED_BY ,
639: P_CREATION_DATE ,
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

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 763: arp_standard.debug('lock_row +');

759: FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;
760:
761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;
762: BEGIN
763: arp_standard.debug('lock_row +');
764: arp_standard.debug(' PROFILE_CLASS_AMOUNT_ID:'||p_info_rec.PROFILE_CLASS_AMOUNT_ID);
765:
766: x_return_status := fnd_api.g_ret_sts_success;
767:

Line 764: arp_standard.debug(' PROFILE_CLASS_AMOUNT_ID:'||p_info_rec.PROFILE_CLASS_AMOUNT_ID);

760:
761: l_info_rec hz_cust_prof_class_amts%ROWTYPE;
762: BEGIN
763: arp_standard.debug('lock_row +');
764: arp_standard.debug(' PROFILE_CLASS_AMOUNT_ID:'||p_info_rec.PROFILE_CLASS_AMOUNT_ID);
765:
766: x_return_status := fnd_api.g_ret_sts_success;
767:
768: fnd_msg_pub.initialize;

Line 953: arp_standard.debug('lock_row -');

949: fnd_msg_pub.add;
950: RAISE fnd_api.g_exc_error;
951: END IF;
952:
953: arp_standard.debug('lock_row -');
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: FND_MSG_PUB.Count_And_Get(

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 1066: arp_standard.debug(' P_PROFILE_CLASS_AMOUNT_ID :'||P_PROFILE_CLASS_AMOUNT_ID);

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:
1070: fnd_msg_pub.initialize;

Line 1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');

1100: IF x_return_status <> fnd_api.g_ret_Sts_success THEN
1101: RAISE fnd_api.G_EXC_ERROR;
1102: END IF;
1103:
1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');
1105: arp_standard.debug(' P_TRX_CREDIT_LIMIT:'||P_TRX_CREDIT_LIMIT);
1106:
1107: UPDATE hz_cust_prof_class_Amts
1108: SET

Line 1105: arp_standard.debug(' P_TRX_CREDIT_LIMIT:'||P_TRX_CREDIT_LIMIT);

1101: RAISE fnd_api.G_EXC_ERROR;
1102: END IF;
1103:
1104: arp_standard.debug(' Updating into hz_cust_prof_class_amts+');
1105: arp_standard.debug(' P_TRX_CREDIT_LIMIT:'||P_TRX_CREDIT_LIMIT);
1106:
1107: UPDATE hz_cust_prof_class_Amts
1108: SET
1109: CURRENCY_CODE = P_CURRENCY_CODE,

Line 1192: arp_standard.debug(' updating hz_cust_prof_class_amts -');

1188: LAST_UPDATE_DATE = SYSDATE,
1189: LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
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

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: