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.ARI_SERVICE_CHARGE_PKG dependencies on ARP_STANDARD

Line 98: arp_standard.debug('Result from api: Adj Nbr = ' || L_NEW_ADJUST_NUMBER);

94: IF L_MSG_DATA IS NOT NULL THEN
95: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, L_PROCEDURE_NAME, L_MSG_DATA);
96: END IF;
97: IF (PG_DEBUG = 'Y') THEN
98: arp_standard.debug('Result from api: Adj Nbr = ' || L_NEW_ADJUST_NUMBER);
99: arp_standard.debug('L_RETURN_STATUS=>'||L_RETURN_STATUS);
100: arp_standard.debug('L_MSG_COUNT=>'||to_char(L_MSG_COUNT));
101: END IF;
102: END IF; -- END RETURN NOT SUCCESS

Line 99: arp_standard.debug('L_RETURN_STATUS=>'||L_RETURN_STATUS);

95: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, L_PROCEDURE_NAME, L_MSG_DATA);
96: END IF;
97: IF (PG_DEBUG = 'Y') THEN
98: arp_standard.debug('Result from api: Adj Nbr = ' || L_NEW_ADJUST_NUMBER);
99: arp_standard.debug('L_RETURN_STATUS=>'||L_RETURN_STATUS);
100: arp_standard.debug('L_MSG_COUNT=>'||to_char(L_MSG_COUNT));
101: END IF;
102: END IF; -- END RETURN NOT SUCCESS
103:

Line 100: arp_standard.debug('L_MSG_COUNT=>'||to_char(L_MSG_COUNT));

96: END IF;
97: IF (PG_DEBUG = 'Y') THEN
98: arp_standard.debug('Result from api: Adj Nbr = ' || L_NEW_ADJUST_NUMBER);
99: arp_standard.debug('L_RETURN_STATUS=>'||L_RETURN_STATUS);
100: arp_standard.debug('L_MSG_COUNT=>'||to_char(L_MSG_COUNT));
101: END IF;
102: END IF; -- END RETURN NOT SUCCESS
103:
104: RETURN(RETURN_VALUE);

Line 109: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

105:
106: EXCEPTION
107: WHEN OTHERS THEN
108: IF (PG_DEBUG = 'Y') THEN
109: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
110: arp_standard.debug('ERROR =>'|| SQLERRM);
111: END IF;
112: --Bug 3630101
113: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 110: arp_standard.debug('ERROR =>'|| SQLERRM);

106: EXCEPTION
107: WHEN OTHERS THEN
108: IF (PG_DEBUG = 'Y') THEN
109: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
110: arp_standard.debug('ERROR =>'|| SQLERRM);
111: END IF;
112: --Bug 3630101
113: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
114: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

192: SELECT ATTRIBUTE1 INTO L_SERVICE_CHRG_PRCNT from ar_lookups where lookup_type = upper(L_LOOKUP_TYPE) AND lookup_code = upper(P_LOOKUP_CODE)
193: AND ENABLED_FLAG='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate);
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
197: arp_standard.debug('Could not find Service Charge Lookup Value in ' || G_PKG_NAME || l_procedure_name);
198: arp_standard.debug('Service Charge lookup_type : ' || P_PAYMENT_TYPE);
199: arp_standard.debug('Service Charge lookup_code : ' || p_lookup_code);
200: END;

Line 197: arp_standard.debug('Could not find Service Charge Lookup Value in ' || G_PKG_NAME || l_procedure_name);

193: AND ENABLED_FLAG='Y' and sysdate between start_date_active and nvl(end_date_active,sysdate);
194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
197: arp_standard.debug('Could not find Service Charge Lookup Value in ' || G_PKG_NAME || l_procedure_name);
198: arp_standard.debug('Service Charge lookup_type : ' || P_PAYMENT_TYPE);
199: arp_standard.debug('Service Charge lookup_code : ' || p_lookup_code);
200: END;
201: END IF;

Line 198: arp_standard.debug('Service Charge lookup_type : ' || P_PAYMENT_TYPE);

194: EXCEPTION
195: WHEN OTHERS THEN
196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
197: arp_standard.debug('Could not find Service Charge Lookup Value in ' || G_PKG_NAME || l_procedure_name);
198: arp_standard.debug('Service Charge lookup_type : ' || P_PAYMENT_TYPE);
199: arp_standard.debug('Service Charge lookup_code : ' || p_lookup_code);
200: END;
201: END IF;
202:

Line 199: arp_standard.debug('Service Charge lookup_code : ' || p_lookup_code);

195: WHEN OTHERS THEN
196: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
197: arp_standard.debug('Could not find Service Charge Lookup Value in ' || G_PKG_NAME || l_procedure_name);
198: arp_standard.debug('Service Charge lookup_type : ' || P_PAYMENT_TYPE);
199: arp_standard.debug('Service Charge lookup_code : ' || p_lookup_code);
200: END;
201: END IF;
202:
203: --if no value is defined for credit card type in lookup then setting default values 0.05

Line 222: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

218:
219: EXCEPTION
220: WHEN OTHERS THEN
221: IF (PG_DEBUG = 'Y') THEN
222: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
223: arp_standard.debug('ERROR =>'|| SQLERRM);
224: END IF;
225: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
226: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 223: arp_standard.debug('ERROR =>'|| SQLERRM);

219: EXCEPTION
220: WHEN OTHERS THEN
221: IF (PG_DEBUG = 'Y') THEN
222: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
223: arp_standard.debug('ERROR =>'|| SQLERRM);
224: END IF;
225: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
226: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 289: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

285:
286: IF L_RETURN_VALUE <> FND_API.G_RET_STS_SUCCESS THEN
287: L_RETURN_VALUE := FND_API.G_RET_STS_ERROR;
288: IF (PG_DEBUG = 'Y') THEN
289: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
290: arp_standard.debug('ERROR =>'|| SQLERRM);
291: END IF;
292: EXIT;
293: END IF;

Line 290: arp_standard.debug('ERROR =>'|| SQLERRM);

286: IF L_RETURN_VALUE <> FND_API.G_RET_STS_SUCCESS THEN
287: L_RETURN_VALUE := FND_API.G_RET_STS_ERROR;
288: IF (PG_DEBUG = 'Y') THEN
289: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
290: arp_standard.debug('ERROR =>'|| SQLERRM);
291: END IF;
292: EXIT;
293: END IF;
294:

Line 304: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);

300: EXCEPTION
301: WHEN OTHERS THEN
302: IF (SQLCODE <> -20001) THEN
303: IF (PG_DEBUG = 'Y') THEN
304: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
305: arp_standard.debug('ERROR =>'|| SQLERRM);
306: END IF;
307: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

Line 305: arp_standard.debug('ERROR =>'|| SQLERRM);

301: WHEN OTHERS THEN
302: IF (SQLCODE <> -20001) THEN
303: IF (PG_DEBUG = 'Y') THEN
304: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
305: arp_standard.debug('ERROR =>'|| SQLERRM);
306: END IF;
307: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
308: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);
309: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);