DBA Data[Home] [Help]

APPS.OTA_TAV_SHD dependencies on FND_MESSAGE

Line 37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;

Line 38: fnd_message.raise_error;

34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then

Line 40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');

36: If (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK1') Then
37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;

Line 41: fnd_message.raise_error;

37: fnd_message.set_name('OTA', 'OTA_13292_TAV_NO_TAD');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then

Line 43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');

39: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK2') Then
40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;

Line 44: fnd_message.raise_error;

40: fnd_message.set_name('OTA', 'OTA_13293_TAV_NO_SUP');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then

Line 46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');

42: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_FK3') Then
43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;

Line 47: fnd_message.raise_error;

43: fnd_message.set_name('OTA', 'OTA_13294_TAV_NO_DEV');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then

Line 49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');

45: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INTERNAL_MAX_ORDER') Then
46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;

Line 50: fnd_message.raise_error;

46: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then

Line 52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');

48: ElsIf (p_constraint_name = 'OTA_TAV_MAX_INT_ATTS_POSITIVE') Then
49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;

Line 53: fnd_message.raise_error;

49: fnd_message.set_name('OTA', 'OTA_13385_TAV_MAX_INT_ATTS');
50: fnd_message.raise_error;
51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then

Line 55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');

51: ElsIf (p_constraint_name = 'OTA_TAV_MAX_ATTENDEES_POSITIVE') Then
52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;

Line 56: fnd_message.raise_error;

52: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
53: fnd_message.raise_error;
54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then

Line 58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');

54: ElsIf (p_constraint_name = 'OTA_TAV_MAX_OCCUR_POSITIVE') Then
55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;

Line 59: fnd_message.raise_error;

55: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then

Line 61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');

57: ElsIf (p_constraint_name = 'OTA_TAV_MIN_ATTENDEES_POSITIVE') Then
58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');

Line 62: fnd_message.raise_error;

58: fnd_message.set_name('OTA', 'OTA_13296_GEN_MINMAX_POS');
59: fnd_message.raise_error;
60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

Line 64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');

60: ElsIf (p_constraint_name = 'OTA_TAV_MIN_MAX_ORDER') Then
61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then

Line 65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');

61: fnd_message.set_name('OTA', 'OTA_13298_GEN_MINMAX_ORDER');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');

Line 66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');

62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;

Line 67: fnd_message.raise_error;

63: ElsIf (p_constraint_name = 'OTA_TAV_EXPENSES_ALLOWED_CHK') Then
64: fnd_message.set_name('OTA', 'OTA_13204_GEN_INVALID_LOOKUP');
65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then

Line 69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');

65: fnd_message.set_token('FIELD','EXPENSES_ALLOWED');
66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then
72: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 70: fnd_message.raise_error;

66: fnd_message.set_token('LOOKUP_TYPE','YES_NO');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'OTA_TAV_VERS_START_END_ORDER') Then
69: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
70: fnd_message.raise_error;
71: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_PK') Then
72: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
73: hr_utility.set_message_token('PROCEDURE', l_proc);
74: hr_utility.set_message_token('STEP','5');

Line 77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');

73: hr_utility.set_message_token('PROCEDURE', l_proc);
74: hr_utility.set_message_token('STEP','5');
75: hr_utility.raise_error;
76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;

Line 78: fnd_message.raise_error;

74: hr_utility.set_message_token('STEP','5');
75: hr_utility.raise_error;
76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then

Line 80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');

76: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK2') Then
77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;

Line 81: fnd_message.raise_error;

77: fnd_message.set_name('OTA', 'OTA_13301_TAV_DUPLICATE');
78: fnd_message.raise_error;
79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else

Line 83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');

79: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK4') Then
80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);

Line 84: fnd_message.raise_error;

80: fnd_message.set_name('OTA', 'OTA_13694_TAV_DUPLICATE');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;

Line 86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');

82: ElsIf (p_constraint_name = 'OTA_ACTIVITY_VERSIONS_UK5') Then
83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --

Line 87: fnd_message.set_token('CONSTRAINT',p_constraint_name);

83: fnd_message.set_name('OTA', 'OTA_TAV_DUPLICATE_RCO');
84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 88: fnd_message.raise_error;

84: fnd_message.raise_error;
85: Else
86: fnd_message.set_name('OTA','OTA_GEN_UNKN_CONSTRAINT');
87: fnd_message.set_token('CONSTRAINT',p_constraint_name);
88: fnd_message.raise_error;
89: End If;
90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: End constraint_error;