DBA Data[Home] [Help]

APPS.JL_ZZ_AR_TX_SCHEDULES_PKG dependencies on FND_MESSAGE

Line 127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');

123: CLOSE C;
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||

Line 128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

124: EXCEPTION
125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||

Line 129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

125: WHEN OTHERS THEN
126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );

Line 130: FND_MESSAGE.SET_TOKEN('PARAMETERS',

126: IF (SQLCODE <> -20001) THEN
127: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
128: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
129: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

130: FND_MESSAGE.SET_TOKEN('PARAMETERS',
131: ' tax_category_id = ' || X_tax_category_id ||
132: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
133: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
134: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
135: END IF;
136: APP_EXCEPTION.RAISE_EXCEPTION;
137:
138: END Insert_Row;

Line 227: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

223: FETCH C INTO Recinfo;
224: IF (C%NOTFOUND) THEN
225: debug_info := 'Close cursor C - DATA NOTFOUND';
226: CLOSE C;
227: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
228: APP_EXCEPTION.Raise_Exception;
229: END IF;
230: debug_info := 'Close cursor C';
231: CLOSE C;

Line 312: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

308: ((Recinfo.attribute15 IS NULL) AND
309: (X_attribute15 IS NULL)))) THEN
310: return;
311: ELSE
312: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
313: APP_EXCEPTION.Raise_Exception;
314: END IF;
315:
316: EXCEPTION

Line 320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');

316: EXCEPTION
317: WHEN OTHERS THEN
318: IF (SQLCODE <> -20001) THEN
319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

Line 322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');

318: IF (SQLCODE <> -20001) THEN
319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||

Line 323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

319: IF (SQLCODE = -54) THEN
320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||

Line 324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

320: FND_MESSAGE.SET_NAME('SQLAR','AR_RESOURCE_BUSY');
321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );

Line 325: FND_MESSAGE.SET_TOKEN('PARAMETERS',

321: ELSE
322: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
323: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
324: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
329: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 329: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

325: FND_MESSAGE.SET_TOKEN('PARAMETERS',
326: ' tax_category_id = ' || X_tax_category_id ||
327: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
328: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') );
329: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
330: END IF;
331: END IF;
332: APP_EXCEPTION.RAISE_EXCEPTION;
333:

Line 458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');

454: AND end_date_active = X_end_date_active
455: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||

Line 459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

455: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));

Line 460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

456:
457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||

457: IF (l_dummy >=1) THEN
458: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
459: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
465: APP_EXCEPTION.RAISE_EXCEPTION;

Line 464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

460: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
461: FND_MESSAGE.SET_TOKEN('PARAMETERS',' tax_category_id = ' || X_tax_category_id ||
462: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
463: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
464: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
465: APP_EXCEPTION.RAISE_EXCEPTION;
466: END IF;
467:
468: END Check_Unique;

Line 502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');

498: a.end_date_active >= X_end_date_active))
499: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||

Line 503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

499: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||

Line 504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

500:
501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||

Line 505: FND_MESSAGE.SET_TOKEN('PARAMETERS',

501: IF (l_dummy >=1) THEN
502: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
503: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
504: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
505: FND_MESSAGE.SET_TOKEN('PARAMETERS',
506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
509: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );

Line 510: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

506: ' tax_category_id = ' || to_char(X_tax_category_id) ||
507: ' tax_categ_slab_id = ' || to_char(X_tax_categ_slab_id) ||
508: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
509: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
510: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
511: APP_EXCEPTION.RAISE_EXCEPTION;
512: END IF;
513: END Check_Overlapped_Dates;
514:

Line 573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');

569: AND a.tax_categ_slab_id = X_tax_categ_slab_id
570: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||

Line 574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

570: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||

Line 575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

571:
572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||

Line 576: FND_MESSAGE.SET_TOKEN('PARAMETERS',

572: IF (l_dummy2 <> 0) THEN
573: FND_MESSAGE.SET_NAME('SQLAR','AR_DEBUG');
574: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
575: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
576: FND_MESSAGE.SET_TOKEN('PARAMETERS',
577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
580: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );

Line 581: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

577: ' tax_category_id = ' || to_char(X_tax_category_id) ||
578: ' tax_categ_slab_id = ' || X_tax_categ_slab_id ||
579: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD') ||
580: ' start_date_active = ' || to_char(X_start_date_active,'YYYY/MM/DD') );
581: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
582: APP_EXCEPTION.RAISE_EXCEPTION;
583: END IF;
584: END;
585: END IF;