DBA Data[Home] [Help]

APPS.JL_ZZ_AR_TX_ATT_VAL_PKG dependencies on FND_MESSAGE

Line 125: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');

121: CLOSE C;
122: EXCEPTION
123: WHEN OTHERS THEN
124: IF (SQLCODE <> -20001) THEN
125: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
128: FND_MESSAGE.SET_TOKEN('PARAMETERS',
129: 'tax_categ_attr_val_id = ' || X_tax_categ_attr_val_id);

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

122: EXCEPTION
123: WHEN OTHERS THEN
124: IF (SQLCODE <> -20001) THEN
125: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
128: FND_MESSAGE.SET_TOKEN('PARAMETERS',
129: 'tax_categ_attr_val_id = ' || X_tax_categ_attr_val_id);
130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

123: WHEN OTHERS THEN
124: IF (SQLCODE <> -20001) THEN
125: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
128: FND_MESSAGE.SET_TOKEN('PARAMETERS',
129: 'tax_categ_attr_val_id = ' || X_tax_categ_attr_val_id);
130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
131: END IF;

Line 128: FND_MESSAGE.SET_TOKEN('PARAMETERS',

124: IF (SQLCODE <> -20001) THEN
125: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
128: FND_MESSAGE.SET_TOKEN('PARAMETERS',
129: 'tax_categ_attr_val_id = ' || X_tax_categ_attr_val_id);
130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
131: END IF;
132: APP_EXCEPTION.RAISE_EXCEPTION;

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

126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
128: FND_MESSAGE.SET_TOKEN('PARAMETERS',
129: 'tax_categ_attr_val_id = ' || X_tax_categ_attr_val_id);
130: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
131: END IF;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133: END Insert_Row;
134:

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

216: FETCH C INTO Recinfo;
217: IF (C%NOTFOUND) THEN
218: debug_info := 'Close cursor C - DATA NOTFOUND';
219: CLOSE C;
220: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
221: APP_EXCEPTION.Raise_Exception;
222: END IF;
223:
224: debug_info := 'Close cursor C';

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

295: ((Recinfo.attribute15 IS NULL) AND
296: (X_attribute15 IS NULL)))) THEN
297: return;
298: ELSE
299: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
300: APP_EXCEPTION.Raise_Exception;
301: END IF;
302:
303: EXCEPTION

Line 307: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');

303: EXCEPTION
304: WHEN OTHERS THEN
305: IF (SQLCODE <> -20001) THEN
306: IF (SQLCODE = -54) THEN
307: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
308: ELSE
309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

Line 309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');

305: IF (SQLCODE <> -20001) THEN
306: IF (SQLCODE = -54) THEN
307: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
308: ELSE
309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
312: FND_MESSAGE.SET_TOKEN('PARAMETERS',
313: 'tax_categ_attr_val_id = ' ||X_tax_categ_attr_val_id);

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

306: IF (SQLCODE = -54) THEN
307: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
308: ELSE
309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
312: FND_MESSAGE.SET_TOKEN('PARAMETERS',
313: 'tax_categ_attr_val_id = ' ||X_tax_categ_attr_val_id);
314: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

307: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
308: ELSE
309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
312: FND_MESSAGE.SET_TOKEN('PARAMETERS',
313: 'tax_categ_attr_val_id = ' ||X_tax_categ_attr_val_id);
314: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
315: END IF;

Line 312: FND_MESSAGE.SET_TOKEN('PARAMETERS',

308: ELSE
309: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
312: FND_MESSAGE.SET_TOKEN('PARAMETERS',
313: 'tax_categ_attr_val_id = ' ||X_tax_categ_attr_val_id);
314: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
315: END IF;
316: END IF;

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

310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
312: FND_MESSAGE.SET_TOKEN('PARAMETERS',
313: 'tax_categ_attr_val_id = ' ||X_tax_categ_attr_val_id);
314: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
315: END IF;
316: END IF;
317: APP_EXCEPTION.RAISE_EXCEPTION;
318: END Lock_Row;

Line 431: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');

427: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))
428: AND org_id = X_org_id;
429:
430: IF (l_dummy >=1) THEN
431: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
432: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
433: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS',
435: ' tax_category_id = ' || X_tax_category_id ||

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

428: AND org_id = X_org_id;
429:
430: IF (l_dummy >=1) THEN
431: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
432: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
433: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS',
435: ' tax_category_id = ' || X_tax_category_id ||
436: ' tax_attribute_type = ' || X_tax_attribute_type ||

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

429:
430: IF (l_dummy >=1) THEN
431: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
432: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
433: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS',
435: ' tax_category_id = ' || X_tax_category_id ||
436: ' tax_attribute_type = ' || X_tax_attribute_type ||
437: ' tax_attribute_name = ' || X_tax_attribute_name ||

Line 434: FND_MESSAGE.SET_TOKEN('PARAMETERS',

430: IF (l_dummy >=1) THEN
431: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
432: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
433: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
434: FND_MESSAGE.SET_TOKEN('PARAMETERS',
435: ' tax_category_id = ' || X_tax_category_id ||
436: ' tax_attribute_type = ' || X_tax_attribute_type ||
437: ' tax_attribute_name = ' || X_tax_attribute_name ||
438: ' tax_attribute_value = ' || X_tax_attribute_value||

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

436: ' tax_attribute_type = ' || X_tax_attribute_type ||
437: ' tax_attribute_name = ' || X_tax_attribute_name ||
438: ' tax_attribute_value = ' || X_tax_attribute_value||
439: ' org_id = ' || X_org_id);
440: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
441: APP_EXCEPTION.RAISE_EXCEPTION;
442: END IF;
443: END Check_Unique;
444:

Line 475: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');

471: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))
472: AND org_id = X_org_id;
473:
474: IF (l_dummy >=1) THEN
475: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
479: ' tax_category_id = ' || X_tax_category_id ||

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

472: AND org_id = X_org_id;
473:
474: IF (l_dummy >=1) THEN
475: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
479: ' tax_category_id = ' || X_tax_category_id ||
480: ' tax_attribute_type = ' || X_tax_attribute_type ||

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

473:
474: IF (l_dummy >=1) THEN
475: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
479: ' tax_category_id = ' || X_tax_category_id ||
480: ' tax_attribute_type = ' || X_tax_attribute_type ||
481: ' tax_attribute_name = ' || X_tax_attribute_name ||

Line 478: FND_MESSAGE.SET_TOKEN('PARAMETERS',

474: IF (l_dummy >=1) THEN
475: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
476: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
477: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
479: ' tax_category_id = ' || X_tax_category_id ||
480: ' tax_attribute_type = ' || X_tax_attribute_type ||
481: ' tax_attribute_name = ' || X_tax_attribute_name ||
482: ' defautl_to_class = ' || X_default_to_class||

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

480: ' tax_attribute_type = ' || X_tax_attribute_type ||
481: ' tax_attribute_name = ' || X_tax_attribute_name ||
482: ' defautl_to_class = ' || X_default_to_class||
483: ' org_id = ' || X_org_id);
484: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487: END Check_Default_To_Class;
488: