DBA Data[Home] [Help]

APPS.JL_ZZ_AR_TX_EXC_ITM_PKG dependencies on FND_MESSAGE

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

136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: IF (SQLCODE <> -20001) THEN
140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
144: 'org_id = ' || X_org_id ||

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

137: EXCEPTION
138: WHEN OTHERS THEN
139: IF (SQLCODE <> -20001) THEN
140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
144: 'org_id = ' || X_org_id ||
145: 'ship_from_code = ' || X_ship_from_code ||

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

138: WHEN OTHERS THEN
139: IF (SQLCODE <> -20001) THEN
140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
144: 'org_id = ' || X_org_id ||
145: 'ship_from_code = ' || X_ship_from_code ||
146: ' ship_to_segment_id = ' || to_char(X_ship_to_segment_id)||

Line 143: FND_MESSAGE.SET_TOKEN('PARAMETERS',

139: IF (SQLCODE <> -20001) THEN
140: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
141: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
142: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
143: FND_MESSAGE.SET_TOKEN('PARAMETERS',
144: 'org_id = ' || X_org_id ||
145: 'ship_from_code = ' || X_ship_from_code ||
146: ' ship_to_segment_id = ' || to_char(X_ship_to_segment_id)||
147: ' inventory_item_id = '|| X_inventory_item_id||

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

147: ' inventory_item_id = '|| X_inventory_item_id||
148: ' organization_id = '|| to_char(X_organization_id)||
149: ' tax_category_id = ' || to_char(X_tax_category_id) ||
150: ' end_date_active = ' || to_char(X_end_date_active,'YYYY/MM/DD'));
151: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
152: END IF;
153: APP_EXCEPTION.RAISE_EXCEPTION;
154: END Insert_Row;
155:

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

257:
258: IF (C%NOTFOUND) THEN
259: debug_info := 'Close cursor C - DATA NOTFOUND';
260: CLOSE C;
261: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
262: APP_EXCEPTION.Raise_Exception;
263: END IF;
264:
265: debug_info := 'Close cursor C';

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

344: ((Recinfo.attribute15 IS NULL) AND
345: (X_attribute15 IS NULL)))) THEN
346: return;
347: ELSE
348: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
349: APP_EXCEPTION.Raise_Exception;
350: END IF;
351:
352: EXCEPTION

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

352: EXCEPTION
353: WHEN OTHERS THEN
354: IF (SQLCODE <> -20001) THEN
355: IF (SQLCODE = -54) THEN
356: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
357: ELSE
358: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

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

354: IF (SQLCODE <> -20001) THEN
355: IF (SQLCODE = -54) THEN
356: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
357: ELSE
358: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
361: FND_MESSAGE.SET_TOKEN('PARAMETERS',
362: 'org_id = ' || X_org_id ||

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

355: IF (SQLCODE = -54) THEN
356: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
357: ELSE
358: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
361: FND_MESSAGE.SET_TOKEN('PARAMETERS',
362: 'org_id = ' || X_org_id ||
363: 'ship_from_code = ' || X_ship_from_code ||

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

356: FND_MESSAGE.SET_NAME('SQLAP','AP_RESOURCE_BUSY');
357: ELSE
358: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
361: FND_MESSAGE.SET_TOKEN('PARAMETERS',
362: 'org_id = ' || X_org_id ||
363: 'ship_from_code = ' || X_ship_from_code ||
364: 'ship_to_segment_id = ' || X_ship_to_segment_id ||

Line 361: FND_MESSAGE.SET_TOKEN('PARAMETERS',

357: ELSE
358: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
359: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
360: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
361: FND_MESSAGE.SET_TOKEN('PARAMETERS',
362: 'org_id = ' || X_org_id ||
363: 'ship_from_code = ' || X_ship_from_code ||
364: 'ship_to_segment_id = ' || X_ship_to_segment_id ||
365: 'inventory_item_id =' ||X_inventory_item_id||

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

365: 'inventory_item_id =' ||X_inventory_item_id||
366: 'organization_id =' ||to_char(X_organization_id)||
367: 'tax_category_id = ' || X_tax_category_id ||
368: 'end_date_active = ' || X_end_date_active );
369: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
370: END IF;
371: END IF;
372: APP_EXCEPTION.RAISE_EXCEPTION;
373: END Lock_Row;

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

493: AND ((X_rowid IS NULL) OR (rowid <> X_rowid))
494: AND org_id = X_org_id;
495:
496: IF (l_dummy >=1) THEN
497: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
498: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
499: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
500: FND_MESSAGE.SET_TOKEN('PARAMETERS',
501: ' org_id = ' || X_org_id ||

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

494: AND org_id = X_org_id;
495:
496: IF (l_dummy >=1) THEN
497: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
498: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
499: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
500: FND_MESSAGE.SET_TOKEN('PARAMETERS',
501: ' org_id = ' || X_org_id ||
502: ' ship_from_code = ' || X_ship_from_code ||

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

495:
496: IF (l_dummy >=1) THEN
497: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
498: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
499: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
500: FND_MESSAGE.SET_TOKEN('PARAMETERS',
501: ' org_id = ' || X_org_id ||
502: ' ship_from_code = ' || X_ship_from_code ||
503: ' ship_to_segment_id = ' || X_ship_to_segment_id ||

Line 500: FND_MESSAGE.SET_TOKEN('PARAMETERS',

496: IF (l_dummy >=1) THEN
497: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
498: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
499: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
500: FND_MESSAGE.SET_TOKEN('PARAMETERS',
501: ' org_id = ' || X_org_id ||
502: ' ship_from_code = ' || X_ship_from_code ||
503: ' ship_to_segment_id = ' || X_ship_to_segment_id ||
504: ' inventory_item_id = '||X_inventory_item_id||

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

504: ' inventory_item_id = '||X_inventory_item_id||
505: ' organization_id ='||to_char(X_organization_id)||
506: ' tax_category_id = ' || X_tax_category_id ||
507: ' end_date_active = ' || X_end_date_active );
508: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
509: APP_EXCEPTION.RAISE_EXCEPTION;
510: END IF;
511: END Check_Unique;
512:

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

549: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid))
550: AND a.org_id = X_org_id;
551:
552: IF (l_dummy >=1) THEN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
556: FND_MESSAGE.SET_TOKEN('PARAMETERS',
557: ' org_id = ' || X_org_id ||

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

550: AND a.org_id = X_org_id;
551:
552: IF (l_dummy >=1) THEN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
556: FND_MESSAGE.SET_TOKEN('PARAMETERS',
557: ' org_id = ' || X_org_id ||
558: ' ship_from_code = ' || X_ship_from_code ||

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

551:
552: IF (l_dummy >=1) THEN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
556: FND_MESSAGE.SET_TOKEN('PARAMETERS',
557: ' org_id = ' || X_org_id ||
558: ' ship_from_code = ' || X_ship_from_code ||
559: ' ship_to_segment_id = ' || X_ship_to_segment_id ||

Line 556: FND_MESSAGE.SET_TOKEN('PARAMETERS',

552: IF (l_dummy >=1) THEN
553: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
554: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
555: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
556: FND_MESSAGE.SET_TOKEN('PARAMETERS',
557: ' org_id = ' || X_org_id ||
558: ' ship_from_code = ' || X_ship_from_code ||
559: ' ship_to_segment_id = ' || X_ship_to_segment_id ||
560: ' inventory_item_id ='||X_inventory_item_id||

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

560: ' inventory_item_id ='||X_inventory_item_id||
561: ' organization_id ='||X_organization_id||
562: ' tax_category_id = ' || X_tax_category_id ||
563: ' end_date_active = ' || X_end_date_active );
564: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
565: APP_EXCEPTION.RAISE_EXCEPTION;
566: END IF;
567: END Check_Overlapped_Dates;
568:

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

639: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid))
640: AND a.org_id = X_org_id;
641:
642: IF (l_dummy2 <> 0) THEN
643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
646: FND_MESSAGE.SET_TOKEN('PARAMETERS',
647: ' org_id = ' || X_org_id ||

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

640: AND a.org_id = X_org_id;
641:
642: IF (l_dummy2 <> 0) THEN
643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
646: FND_MESSAGE.SET_TOKEN('PARAMETERS',
647: ' org_id = ' || X_org_id ||
648: ' ship_from_code = ' || X_ship_from_code ||

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

641:
642: IF (l_dummy2 <> 0) THEN
643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
646: FND_MESSAGE.SET_TOKEN('PARAMETERS',
647: ' org_id = ' || X_org_id ||
648: ' ship_from_code = ' || X_ship_from_code ||
649: ' ship_to_segment_id = ' || X_ship_to_segment_id ||

Line 646: FND_MESSAGE.SET_TOKEN('PARAMETERS',

642: IF (l_dummy2 <> 0) THEN
643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
646: FND_MESSAGE.SET_TOKEN('PARAMETERS',
647: ' org_id = ' || X_org_id ||
648: ' ship_from_code = ' || X_ship_from_code ||
649: ' ship_to_segment_id = ' || X_ship_to_segment_id ||
650: ' inventory_item_id = '||X_inventory_item_id ||

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

650: ' inventory_item_id = '||X_inventory_item_id ||
651: ' organization_id = '||X_organization_id||
652: ' tax_category_id = ' || X_tax_category_id ||
653: ' end_date_active = ' || X_end_date_active );
654: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
655: APP_EXCEPTION.RAISE_EXCEPTION;
656: END IF;
657: END;
658: END IF;