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 FND_API

Line 87: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 111: x_return_status := FND_API.G_RET_STS_ERROR;

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;
112: END IF;
113: END IF;
114: END IF;
115: END IF;

Line 141: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

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;
188: CLOSE c;
189: END IF;
190: arp_standard.debug('validate_exchange_type -');

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

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;
236: END IF;
237:
238: OPEN curr;
239: FETCH curr INTO l_code;

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

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');
246: FND_MSG_PUB.ADD;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: END IF;
249: CLOSE curr;
250:
251:

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

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;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: END IF;
279: END IF;
280: END IF;
281:

Line 421: x_return_status := fnd_api.g_ret_Sts_success;

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;
424:
425: validate_prof_class_amt

Line 453: IF x_return_status <> fnd_api.g_ret_Sts_success THEN

449: P_PENALTY_FIXED_AMOUNT => P_PENALTY_FIXED_AMOUNT,
450: P_PENALTY_SCHEDULE_ID => P_PENALTY_SCHEDULE_ID,
451: x_return_status => x_return_status);
452:
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+');

Line 454: RAISE fnd_api.G_EXC_ERROR;

450: P_PENALTY_SCHEDULE_ID => P_PENALTY_SCHEDULE_ID,
451: x_return_status => x_return_status);
452:
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:

Line 646: WHEN fnd_api.G_EXC_ERROR THEN

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,
649: p_data => x_msg_data);
650: arp_standard.debug('EXCEPTION IN ar_cust_prof_class_amt_pkg.insert_row:'||x_msg_data);

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

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,
649: p_data => x_msg_data);
650: arp_standard.debug('EXCEPTION IN ar_cust_prof_class_amt_pkg.insert_row:'||x_msg_data);
651:

Line 653: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
655: fnd_message.set_token('ERROR' ,SQLERRM);
656: fnd_msg_pub.add;
657: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

653: x_return_status := fnd_api.g_ret_sts_unexp_error;
654: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
655: fnd_message.set_token('ERROR' ,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;

Line 766: x_return_status := fnd_api.g_ret_sts_success;

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;
769:
770: OPEN c;

Line 950: RAISE fnd_api.g_exc_error;

946: ELSE
947: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
948: fnd_message.set_token('TABLE', 'hz_cust_prof_class_amts');
949: fnd_msg_pub.add;
950: RAISE fnd_api.g_exc_error;
951: END IF;
952:
953: arp_standard.debug('lock_row -');
954: EXCEPTION

Line 955: WHEN FND_API.G_EXC_ERROR THEN

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(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,

Line 956: x_return_status := FND_API.G_RET_STS_ERROR;

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(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data);

Line 958: p_encoded => FND_API.G_FALSE,

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(
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:

Line 964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
968: FND_MSG_PUB.Count_And_Get(

Line 969: p_encoded => FND_API.G_FALSE,

965: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
966: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
967: FND_MSG_PUB.ADD;
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;

Line 1068: x_return_status := fnd_api.g_ret_Sts_success;

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;
1071:
1072: validate_prof_class_amt

Line 1100: IF x_return_status <> fnd_api.g_ret_Sts_success THEN

1096: P_PENALTY_FIXED_AMOUNT => P_PENALTY_FIXED_AMOUNT,
1097: P_PENALTY_SCHEDULE_ID => P_PENALTY_SCHEDULE_ID,
1098: x_return_status => x_return_status);
1099:
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+');

Line 1101: RAISE fnd_api.G_EXC_ERROR;

1097: P_PENALTY_SCHEDULE_ID => P_PENALTY_SCHEDULE_ID,
1098: x_return_status => x_return_status);
1099:
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);

Line 1196: WHEN FND_API.G_EXC_ERROR THEN

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(
1199: p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR;

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(
1199: p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);

Line 1199: p_encoded => FND_API.G_FALSE,

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(
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:

Line 1205: x_return_status := fnd_api.g_ret_sts_unexp_error;

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');
1207: fnd_message.set_token('ERROR' ,SQLERRM);
1208: fnd_msg_pub.add;
1209: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1205: x_return_status := fnd_api.g_ret_sts_unexp_error;
1206: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1207: fnd_message.set_token('ERROR' ,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;