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_MSG_PUB

Line 86: FND_MSG_PUB.ADD;

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

Line 94: FND_MSG_PUB.ADD;

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;
96: END IF;
97: ELSIF P_TYPE = 'FIXED_RATE' THEN
98: IF P_RATE IS NULL THEN

Line 102: FND_MSG_PUB.ADD;

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;
104: END IF;
105: ELSIF P_TYPE = 'CHARGES_SCHEDULE' THEN
106: IF P_SCHEDULE_ID IS NULL THEN

Line 110: FND_MSG_PUB.ADD;

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

Line 140: FND_MSG_PUB.ADD;

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

Line 149: FND_MSG_PUB.ADD;

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

Line 158: FND_MSG_PUB.ADD;

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;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: END IF;
161: END IF;
162: END IF;

Line 185: FND_MSG_PUB.ADD;

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;
188: CLOSE c;
189: END IF;

Line 234: FND_MSG_PUB.ADD;

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

Line 246: FND_MSG_PUB.ADD;

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

Line 258: FND_MSG_PUB.ADD;

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

Line 267: FND_MSG_PUB.ADD;

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

Line 276: FND_MSG_PUB.ADD;

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

Line 423: fnd_msg_pub.initialize;

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
426: (P_CURRENCY_CODE => p_currency_code,
427: P_TRX_CREDIT_LIMIT => P_TRX_CREDIT_LIMIT,

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 656: fnd_msg_pub.add;

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

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

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;
771: FETCH c INTO
772: l_info_rec.PROFILE_CLASS_AMOUNT_ID ,

Line 949: fnd_msg_pub.add;

945: RETURN;
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 -');

Line 957: FND_MSG_PUB.Count_And_Get(

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);
961: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.lock_row:'||x_msg_data);

Line 967: FND_MSG_PUB.ADD;

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(
969: p_encoded => FND_API.G_FALSE,
970: p_count => x_msg_count,
971: p_data => x_msg_data);

Line 968: FND_MSG_PUB.Count_And_Get(

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

Line 1070: fnd_msg_pub.initialize;

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
1073: (P_CURRENCY_CODE => p_currency_code,
1074: P_TRX_CREDIT_LIMIT => P_TRX_CREDIT_LIMIT,

Line 1198: FND_MSG_PUB.Count_And_Get(

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);
1202: arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.update_row:'||x_msg_data);

Line 1208: fnd_msg_pub.add;

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

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;