DBA Data[Home] [Help]

APPS.ARI_SELF_SERVICE_PKG dependencies on ARP_STANDARD

Line 182: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');

178: ----------------------------------------------------------------------------
179: l_debug_info := 'In debug mode, log we have entered this procedure';
180: ----------------------------------------------------------------------------
181: IF (PG_DEBUG = 'Y') THEN
182: arp_standard.debug(G_PKG_NAME || l_procedure_name || '+');
183: END IF;
184:
185:
186: IF (p_reg_request_id is NULL) THEN

Line 196: arp_standard.debug(l_debug_info||' '||p_reg_request_id);

192: ----------------------------------------------------------------------------
193: l_debug_info := 'Fetched the Reg Request Id value';
194: ----------------------------------------------------------------------------
195: IF (PG_DEBUG = 'Y') THEN
196: arp_standard.debug(l_debug_info||' '||p_reg_request_id);
197: END IF;
198:
199: ----------------------------------------------------------------------------
200: l_debug_info := 'Insert New UMX Reg Request Record';

Line 203: arp_standard.debug(l_debug_info);

199: ----------------------------------------------------------------------------
200: l_debug_info := 'Insert New UMX Reg Request Record';
201: ----------------------------------------------------------------------------
202: IF (PG_DEBUG = 'Y') THEN
203: arp_standard.debug(l_debug_info);
204: END IF;
205:
206: SELECT REG_SERVICE_TYPE,WF_ROLE_NAME,AME_TRANSACTION_TYPE_ID INTO l_reg_service_type,l_wf_role_name,l_ame_transaction_type_id
207: FROM umx_reg_services_vl

Line 214: arp_standard.debug(l_debug_info||' '||l_reg_service_type||', '||l_wf_role_name);

210: ----------------------------------------------------------------------------
211: l_debug_info := 'Service Type and Role Name values obtained';
212: ----------------------------------------------------------------------------
213: IF (PG_DEBUG = 'Y') THEN
214: arp_standard.debug(l_debug_info||' '||l_reg_service_type||', '||l_wf_role_name);
215: END IF;
216:
217: OPEN C3;
218: IF (C3%NOTFOUND) THEN

Line 231: arp_standard.debug(l_debug_info||' '||l_reg_request_id);

227: ----------------------------------------------------------------------------
228: l_debug_info := 'Request Id already exists against reg_service code passed for the user';
229: ----------------------------------------------------------------------------
230: IF (PG_DEBUG = 'Y') THEN
231: arp_standard.debug(l_debug_info||' '||l_reg_request_id);
232: END IF;
233:
234: --------------------------------------------------------------------
235: l_debug_info := 'Retrieve Justification Message';

Line 242: arp_standard.debug(l_debug_info||' '||l_justification);

238:
239: l_justification := FND_MESSAGE.Get;
240:
241: IF (PG_DEBUG = 'Y') THEN
242: arp_standard.debug(l_debug_info||' '||l_justification);
243: END IF;
244:
245: IF (l_reg_request_id IS NULL) THEN
246: INSERT INTO UMX_REG_REQUESTS(

Line 300: arp_standard.debug(G_PKG_NAME || l_procedure_name || '-');

296: ----------------------------------------------------------------------------
297: l_debug_info := 'In debug mode, log that we have exited this procedure';
298: ----------------------------------------------------------------------------
299: IF (PG_DEBUG = 'Y') THEN
300: arp_standard.debug(G_PKG_NAME || l_procedure_name || '-');
301: END IF;
302:
303: EXCEPTION
304: WHEN OTHERS THEN

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

303: EXCEPTION
304: WHEN OTHERS THEN
305: IF (SQLCODE <> -20001) THEN
306: IF (PG_DEBUG = 'Y') THEN
307: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
308: arp_standard.debug('Debug Info: ' || l_debug_info);
309: arp_standard.debug(SQLERRM);
310: END IF;
311: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 308: arp_standard.debug('Debug Info: ' || l_debug_info);

304: WHEN OTHERS THEN
305: IF (SQLCODE <> -20001) THEN
306: IF (PG_DEBUG = 'Y') THEN
307: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
308: arp_standard.debug('Debug Info: ' || l_debug_info);
309: arp_standard.debug(SQLERRM);
310: END IF;
311: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

Line 309: arp_standard.debug(SQLERRM);

305: IF (SQLCODE <> -20001) THEN
306: IF (PG_DEBUG = 'Y') THEN
307: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
308: arp_standard.debug('Debug Info: ' || l_debug_info);
309: arp_standard.debug(SQLERRM);
310: END IF;
311: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
313: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);

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

347: EXCEPTION
348: WHEN OTHERS THEN
349: IF (SQLCODE <> -20001) THEN
350: IF (PG_DEBUG = 'Y') THEN
351: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
352: arp_standard.debug('Debug Info: ' || l_debug_info);
353: arp_standard.debug(SQLERRM);
354: END IF;
355: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');

Line 352: arp_standard.debug('Debug Info: ' || l_debug_info);

348: WHEN OTHERS THEN
349: IF (SQLCODE <> -20001) THEN
350: IF (PG_DEBUG = 'Y') THEN
351: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
352: arp_standard.debug('Debug Info: ' || l_debug_info);
353: arp_standard.debug(SQLERRM);
354: END IF;
355: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
356: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

Line 353: arp_standard.debug(SQLERRM);

349: IF (SQLCODE <> -20001) THEN
350: IF (PG_DEBUG = 'Y') THEN
351: arp_standard.debug('Unexpected Exception in ' || G_PKG_NAME || l_procedure_name);
352: arp_standard.debug('Debug Info: ' || l_debug_info);
353: arp_standard.debug(SQLERRM);
354: END IF;
355: FND_MESSAGE.SET_NAME ('AR','ARI_REG_DISPLAY_UNEXP_ERROR');
356: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
357: FND_MESSAGE.SET_TOKEN('PROCEDURE', G_PKG_NAME || l_procedure_name);