DBA Data[Home] [Help]

APPS.JL_AR_AR_DOC_LETTER_PKG dependencies on FND_MESSAGE

Line 133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);

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

130: EXCEPTION
131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

131: WHEN OTHERS THEN
132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;

Line 136: FND_MESSAGE.SET_TOKEN('PARAMETERS',

132: IF (SQLCODE <> -20001) THEN
133: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;

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

134: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
135: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
136: FND_MESSAGE.SET_TOKEN('PARAMETERS',
137: 'tax_category_id = ' || X_tax_category_id);
138: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
139: END IF;
140: APP_EXCEPTION.RAISE_EXCEPTION;
141:
142: END Insert_Row;

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

203: IF (C%NOTFOUND)
204: THEN
205: debug_info := 'Close cursor C - DATA NOTFOUND';
206: CLOSE C;
207: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
208: APP_EXCEPTION.Raise_Exception;
209: END IF;
210: debug_info := 'Close cursor C';
211: CLOSE C;

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

256: )
257: THEN
258: return;
259: ELSE
260: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
261: APP_EXCEPTION.Raise_Exception;
262: END IF;
263:
264: EXCEPTION

Line 268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');

264: EXCEPTION
265: WHEN OTHERS THEN
266: IF (SQLCODE <> -20001) THEN
267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

Line 270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

266: IF (SQLCODE <> -20001) THEN
267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);

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

267: IF (SQLCODE = -54) THEN
268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

268: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;

Line 273: FND_MESSAGE.SET_TOKEN('PARAMETERS',

269: ELSE
270: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;
277: END IF;

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

271: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
272: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
273: FND_MESSAGE.SET_TOKEN('PARAMETERS',
274: 'tax_category_id = ' || X_tax_category_id);
275: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
276: END IF;
277: END IF;
278: APP_EXCEPTION.RAISE_EXCEPTION;
279: END Lock_Row;

Line 396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

392: AND end_date_active = X_end_date_active
393: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||

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

393: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||

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

394: IF (l_dummy >=1)
395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||

Line 399: FND_MESSAGE.SET_TOKEN('PARAMETERS',

395: THEN
396: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
397: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
398: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
399: FND_MESSAGE.SET_TOKEN('PARAMETERS',
400: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||
403: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||

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

401: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
402: ' con_tax_attribute_name = '||X_con_tax_attribute_name||
403: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
404: ' end_date_active = ' || X_end_date_active );
405: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
406: APP_EXCEPTION.RAISE_EXCEPTION;
407: END IF;
408: END Check_Unique;
409:

Line 448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

444: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
445:
446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||

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

445:
446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||

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

446: IF (l_dummy >=1)
447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||

Line 451: FND_MESSAGE.SET_TOKEN('PARAMETERS',

447: THEN
448: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
449: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
450: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
451: FND_MESSAGE.SET_TOKEN('PARAMETERS',
452: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||
455: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||

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

453: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
454: ' con_tax_attribute_name ='||X_con_tax_attribute_name||
455: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
456: ' end_date_active = ' || X_end_date_active );
457: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: END IF;
460: END Check_Overlapped_Dates;
461:

Line 529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

525: AND a.con_tax_attribute_value = X_con_tax_attribute_value
526: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',

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

526: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||

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

527: IF (l_dummy2 <> 0)
528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||

Line 532: FND_MESSAGE.SET_TOKEN(

528: THEN
529: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
530: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
531: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
532: FND_MESSAGE.SET_TOKEN(
533: 'PARAMETERS',
534: ' org_tax_attribute_name = ' || X_org_tax_attribute_name ||
535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
536: ' con_tax_attribute_name = '||X_con_tax_attribute_name ||

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

535: ' org_tax_attribute_value = ' || X_org_tax_attribute_value ||
536: ' con_tax_attribute_name = '||X_con_tax_attribute_name ||
537: ' con_tax_attribute_value = ' || X_con_tax_attribute_value ||
538: ' end_date_active = ' || X_end_date_active );
539: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
540: APP_EXCEPTION.RAISE_EXCEPTION;
541: END IF;
542: END;
543: END IF;