DBA Data[Home] [Help]

APPS.JL_ZZ_AR_TX_CATEG_PKG dependencies on FND_MESSAGE

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

172:
173: EXCEPTION
174: WHEN OTHERS THEN
175: IF (SQLCODE <> -20001) THEN
176: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
177: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
178: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
179: FND_MESSAGE.SET_TOKEN('PARAMETERS',
180: ' tax_category_id = ' || X_tax_category_id ||

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

173: EXCEPTION
174: WHEN OTHERS THEN
175: IF (SQLCODE <> -20001) THEN
176: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
177: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
178: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
179: FND_MESSAGE.SET_TOKEN('PARAMETERS',
180: ' tax_category_id = ' || X_tax_category_id ||
181: ' end_date_active = ' || X_end_date_active );

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

174: WHEN OTHERS THEN
175: IF (SQLCODE <> -20001) THEN
176: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
177: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
178: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
179: FND_MESSAGE.SET_TOKEN('PARAMETERS',
180: ' tax_category_id = ' || X_tax_category_id ||
181: ' end_date_active = ' || X_end_date_active );
182: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 179: FND_MESSAGE.SET_TOKEN('PARAMETERS',

175: IF (SQLCODE <> -20001) THEN
176: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
177: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
178: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
179: FND_MESSAGE.SET_TOKEN('PARAMETERS',
180: ' tax_category_id = ' || X_tax_category_id ||
181: ' end_date_active = ' || X_end_date_active );
182: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
183: END IF;

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

178: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
179: FND_MESSAGE.SET_TOKEN('PARAMETERS',
180: ' tax_category_id = ' || X_tax_category_id ||
181: ' end_date_active = ' || X_end_date_active );
182: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
183: END IF;
184: APP_EXCEPTION.RAISE_EXCEPTION;
185: END Insert_Row;
186:

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

300:
301: IF (C%NOTFOUND) THEN
302: debug_info := 'Close cursor C - DATA NOTFOUND';
303: CLOSE C;
304: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
305: APP_EXCEPTION.Raise_Exception;
306: END IF;
307:
308: debug_info := 'Close cursor C';

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

426: ((Recinfo.attribute15 IS NULL) AND
427: (X_attribute15 IS NULL)))) THEN
428: return;
429: ELSE
430: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
431: APP_EXCEPTION.Raise_Exception;
432: END IF;
433:
434: EXCEPTION

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

434: EXCEPTION
435: WHEN OTHERS THEN
436: IF (SQLCODE <> -20001) THEN
437: IF (SQLCODE = -54) THEN
438: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
439: ELSE
440: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

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

436: IF (SQLCODE <> -20001) THEN
437: IF (SQLCODE = -54) THEN
438: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
439: ELSE
440: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('PARAMETERS',
444: ' tax_category_id = ' || X_tax_category_id ||

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

437: IF (SQLCODE = -54) THEN
438: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
439: ELSE
440: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('PARAMETERS',
444: ' tax_category_id = ' || X_tax_category_id ||
445: ' end_date_active = ' || X_end_date_active );

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

438: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
439: ELSE
440: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('PARAMETERS',
444: ' tax_category_id = ' || X_tax_category_id ||
445: ' end_date_active = ' || X_end_date_active );
446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 443: FND_MESSAGE.SET_TOKEN('PARAMETERS',

439: ELSE
440: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
441: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('PARAMETERS',
444: ' tax_category_id = ' || X_tax_category_id ||
445: ' end_date_active = ' || X_end_date_active );
446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
447: END IF;

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

442: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
443: FND_MESSAGE.SET_TOKEN('PARAMETERS',
444: ' tax_category_id = ' || X_tax_category_id ||
445: ' end_date_active = ' || X_end_date_active );
446: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
447: END IF;
448: END IF;
449: APP_EXCEPTION.RAISE_EXCEPTION;
450:

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

564: EXCEPTION
565: WHEN OTHERS THEN
566: IF (SQLCODE <> -20001) THEN
567: IF (SQLCODE = -54) THEN
568: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
569: ELSE
570: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
571: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

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

566: IF (SQLCODE <> -20001) THEN
567: IF (SQLCODE = -54) THEN
568: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
569: ELSE
570: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
571: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
573: FND_MESSAGE.SET_TOKEN('PARAMETERS',
574: ' tax_category_id = ' || X_tax_category_id ||

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

567: IF (SQLCODE = -54) THEN
568: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
569: ELSE
570: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
571: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
573: FND_MESSAGE.SET_TOKEN('PARAMETERS',
574: ' tax_category_id = ' || X_tax_category_id ||
575: ' end_date_active = ' || X_end_date_active );

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

568: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
569: ELSE
570: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
571: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
573: FND_MESSAGE.SET_TOKEN('PARAMETERS',
574: ' tax_category_id = ' || X_tax_category_id ||
575: ' end_date_active = ' || X_end_date_active );
576: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 573: FND_MESSAGE.SET_TOKEN('PARAMETERS',

569: ELSE
570: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
571: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
573: FND_MESSAGE.SET_TOKEN('PARAMETERS',
574: ' tax_category_id = ' || X_tax_category_id ||
575: ' end_date_active = ' || X_end_date_active );
576: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
577: END IF;

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

572: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
573: FND_MESSAGE.SET_TOKEN('PARAMETERS',
574: ' tax_category_id = ' || X_tax_category_id ||
575: ' end_date_active = ' || X_end_date_active );
576: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
577: END IF;
578: END IF;
579: APP_EXCEPTION.RAISE_EXCEPTION;
580:

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

606: EXCEPTION
607: WHEN OTHERS THEN
608: IF (SQLCODE <> -20001) THEN
609: IF (SQLCODE = -54) THEN
610: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
611: ELSE
612: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

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

608: IF (SQLCODE <> -20001) THEN
609: IF (SQLCODE = -54) THEN
610: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
611: ELSE
612: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
615: FND_MESSAGE.SET_TOKEN('PARAMETERS',
616: ' tax_category_id = ' || X_tax_category_id ||

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

609: IF (SQLCODE = -54) THEN
610: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
611: ELSE
612: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
615: FND_MESSAGE.SET_TOKEN('PARAMETERS',
616: ' tax_category_id = ' || X_tax_category_id ||
617: ' end_date_active = ' || X_end_date_active );

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

610: FND_MESSAGE.SET_NAME('AR','AR_RESOURCE_BUSY');
611: ELSE
612: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
615: FND_MESSAGE.SET_TOKEN('PARAMETERS',
616: ' tax_category_id = ' || X_tax_category_id ||
617: ' end_date_active = ' || X_end_date_active );
618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 615: FND_MESSAGE.SET_TOKEN('PARAMETERS',

611: ELSE
612: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
613: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
615: FND_MESSAGE.SET_TOKEN('PARAMETERS',
616: ' tax_category_id = ' || X_tax_category_id ||
617: ' end_date_active = ' || X_end_date_active );
618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
619: END IF;

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

614: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
615: FND_MESSAGE.SET_TOKEN('PARAMETERS',
616: ' tax_category_id = ' || X_tax_category_id ||
617: ' end_date_active = ' || X_end_date_active );
618: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
619: END IF;
620: END IF;
621: APP_EXCEPTION.RAISE_EXCEPTION;
622:

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

644: AND end_date_active = X_end_date_active
645: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
646:
647: IF (l_dummy >=1) THEN
648: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
649: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
650: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
651: FND_MESSAGE.SET_TOKEN('PARAMETERS',
652: ' tax_category_id = ' || X_tax_category_id ||

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

645: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
646:
647: IF (l_dummy >=1) THEN
648: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
649: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
650: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
651: FND_MESSAGE.SET_TOKEN('PARAMETERS',
652: ' tax_category_id = ' || X_tax_category_id ||
653: ' end_date_active = ' || X_end_date_active );

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

646:
647: IF (l_dummy >=1) THEN
648: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
649: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
650: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
651: FND_MESSAGE.SET_TOKEN('PARAMETERS',
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);

Line 651: FND_MESSAGE.SET_TOKEN('PARAMETERS',

647: IF (l_dummy >=1) THEN
648: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
649: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
650: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
651: FND_MESSAGE.SET_TOKEN('PARAMETERS',
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;

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

650: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
651: FND_MESSAGE.SET_TOKEN('PARAMETERS',
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:
658: END Check_Unique;

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

683: AND org_id = X_org_id
684: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
685:
686: IF (l_dummy >=1) THEN
687: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS',
691: ' tax_category_id = ' || X_tax_category_id ||

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

684: AND ((X_rowid IS NULL) OR (rowid <> X_rowid));
685:
686: IF (l_dummy >=1) THEN
687: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS',
691: ' tax_category_id = ' || X_tax_category_id ||
692: ' end_date_active = ' || X_end_date_active );

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

685:
686: IF (l_dummy >=1) THEN
687: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS',
691: ' tax_category_id = ' || X_tax_category_id ||
692: ' end_date_active = ' || X_end_date_active );
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

Line 690: FND_MESSAGE.SET_TOKEN('PARAMETERS',

686: IF (l_dummy >=1) THEN
687: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
688: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS',
691: ' tax_category_id = ' || X_tax_category_id ||
692: ' end_date_active = ' || X_end_date_active );
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
694: APP_EXCEPTION.RAISE_EXCEPTION;

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

689: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
690: FND_MESSAGE.SET_TOKEN('PARAMETERS',
691: ' tax_category_id = ' || X_tax_category_id ||
692: ' end_date_active = ' || X_end_date_active );
693: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
694: APP_EXCEPTION.RAISE_EXCEPTION;
695: END IF;
696:
697: --

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

718: AND org_id <> X_org_id
719: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
720:
721: IF (l_dummy >=1) THEN
722: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
725: FND_MESSAGE.SET_TOKEN('PARAMETERS',
726: ' tax_category_id = ' || to_char(X_tax_category_id) ||

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

719: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
720:
721: IF (l_dummy >=1) THEN
722: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
725: FND_MESSAGE.SET_TOKEN('PARAMETERS',
726: ' tax_category_id = ' || to_char(X_tax_category_id) ||
727: ' end_date_active = ' || X_end_date_active ||

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

720:
721: IF (l_dummy >=1) THEN
722: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
725: FND_MESSAGE.SET_TOKEN('PARAMETERS',
726: ' tax_category_id = ' || to_char(X_tax_category_id) ||
727: ' end_date_active = ' || X_end_date_active ||
728: ' start_date_active = ' || X_start_date_active ||

Line 725: FND_MESSAGE.SET_TOKEN('PARAMETERS',

721: IF (l_dummy >=1) THEN
722: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
725: FND_MESSAGE.SET_TOKEN('PARAMETERS',
726: ' tax_category_id = ' || to_char(X_tax_category_id) ||
727: ' end_date_active = ' || X_end_date_active ||
728: ' start_date_active = ' || X_start_date_active ||
729: ' org_id = ' || X_org_id );

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

726: ' tax_category_id = ' || to_char(X_tax_category_id) ||
727: ' end_date_active = ' || X_end_date_active ||
728: ' start_date_active = ' || X_start_date_active ||
729: ' org_id = ' || X_org_id );
730: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
731: APP_EXCEPTION.RAISE_EXCEPTION;
732: END IF;
733: END Check_Overlapped_Dates;
734:

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

784: WHERE tax_category_id = X_tax_category_id
785: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
786:
787: IF (l_dummy2 <> 0) THEN
788: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
789: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
790: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: ' tax_category_id = ' || to_char(X_tax_category_id) ||

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

785: AND ((X_rowid IS NULL) OR (a.rowid <> X_rowid));
786:
787: IF (l_dummy2 <> 0) THEN
788: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
789: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
790: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: ' tax_category_id = ' || to_char(X_tax_category_id) ||
793: ' end_date_active = ' || X_end_date_active ||

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

786:
787: IF (l_dummy2 <> 0) THEN
788: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
789: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
790: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: ' tax_category_id = ' || to_char(X_tax_category_id) ||
793: ' end_date_active = ' || X_end_date_active ||
794: ' start_date_active = ' || X_start_date_active );

Line 791: FND_MESSAGE.SET_TOKEN('PARAMETERS',

787: IF (l_dummy2 <> 0) THEN
788: FND_MESSAGE.SET_NAME('AR','AR_DEBUG');
789: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
790: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: ' tax_category_id = ' || to_char(X_tax_category_id) ||
793: ' end_date_active = ' || X_end_date_active ||
794: ' start_date_active = ' || X_start_date_active );
795: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: ' tax_category_id = ' || to_char(X_tax_category_id) ||
793: ' end_date_active = ' || X_end_date_active ||
794: ' start_date_active = ' || X_start_date_active );
795: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
796: APP_EXCEPTION.RAISE_EXCEPTION;
797: END IF;
798: END;
799: END IF;