DBA Data[Home] [Help]

APPS.JL_ZZ_AR_TX_ATT_CLS_PKG dependencies on FND_MESSAGE

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

247: CLOSE C;
248: EXCEPTION
249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||

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

248: EXCEPTION
249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||

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

249: WHEN OTHERS THEN
250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
257: ' tax_category_id = ' || X_tax_category_id ||

Line 254: FND_MESSAGE.SET_TOKEN('PARAMETERS',

250: IF (SQLCODE <> -20001) THEN
251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
254: FND_MESSAGE.SET_TOKEN('PARAMETERS',
255: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
256: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
257: ' tax_category_id = ' || X_tax_category_id ||
258: ' tax_attribute_type = ' || X_tax_attribute_type ||

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

257: ' tax_category_id = ' || X_tax_category_id ||
258: ' tax_attribute_type = ' || X_tax_attribute_type ||
259: ' tax_attribute_name = ' || X_tax_attribute_name ||
260: ' org_id = ' || X_org_id );
261: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
262: END IF;
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: END Insert_Row;
265:

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

444: FETCH C INTO Recinfo;
445: IF (C%NOTFOUND) THEN
446: debug_info := 'Close cursor C - DATA NOTFOUND';
447: CLOSE C;
448: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
449: APP_EXCEPTION.Raise_Exception;
450: END IF;
451: debug_info := 'Close cursor C';
452: CLOSE C;

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

520: ((Recinfo.attribute15 IS NULL) AND
521: (X_attribute15 IS NULL)))) THEN
522: return;
523: ELSE
524: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
525: APP_EXCEPTION.Raise_Exception;
526: END IF;
527: EXCEPTION
528: WHEN OTHERS THEN

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

527: EXCEPTION
528: WHEN OTHERS THEN
529: IF (SQLCODE <> -20001) THEN
530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

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

529: IF (SQLCODE <> -20001) THEN
530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||

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

530: IF (SQLCODE = -54) THEN
531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||

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

531: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
539: ' tax_category_id = ' || X_tax_category_id ||

Line 536: FND_MESSAGE.SET_TOKEN('PARAMETERS',

532: ELSE
533: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
534: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
535: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
536: FND_MESSAGE.SET_TOKEN('PARAMETERS',
537: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
538: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
539: ' tax_category_id = ' || X_tax_category_id ||
540: ' tax_attribute_type = ' || X_tax_attribute_type ||

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

540: ' tax_attribute_type = ' || X_tax_attribute_type ||
541: ' tax_attribute_name = ' || X_tax_attribute_name ||
542: ' org_id = ' || X_org_id );
543:
544: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
545: END IF;
546: END IF;
547: APP_EXCEPTION.RAISE_EXCEPTION;
548: END Lock_Row;

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

578: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))
579: AND org_id = X_org_id;
580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||

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

579: AND org_id = X_org_id;
580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||

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

580:
581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
588: ' tax_category_id = ' || X_tax_category_id ||

Line 585: FND_MESSAGE.SET_TOKEN('PARAMETERS',

581: IF (l_dummy >=1) THEN
582: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
583: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
584: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
585: FND_MESSAGE.SET_TOKEN('PARAMETERS',
586: 'tax_attr_class_type = ' || X_tax_attr_class_type ||
587: ' tax_attr_class_code = ' || X_tax_attr_class_code ||
588: ' tax_category_id = ' || X_tax_category_id ||
589: ' tax_attribute_type = ' || X_tax_attribute_type ||

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

589: ' tax_attribute_type = ' || X_tax_attribute_type ||
590: ' tax_attribute_name = ' || X_tax_attribute_name||
591: ' org_id = ' || X_org_id);
592:
593: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
594: APP_EXCEPTION.RAISE_EXCEPTION;
595: END IF;
596: END Check_Unique;
597: