DBA Data[Home] [Help]

APPS.FND_CONC_QUEUES_PKG dependencies on FND_MESSAGE

Line 42: fnd_message.set_name ('FND', 'CONC-Cannot update ICM defn');

38: exception
39: when no_data_found then
40: return (TRUE);
41: when icm_error then
42: fnd_message.set_name ('FND', 'CONC-Cannot update ICM defn');
43: return (FALSE);
44: when crm_error then
45: fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');
46: return (FALSE);

Line 45: fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');

41: when icm_error then
42: fnd_message.set_name ('FND', 'CONC-Cannot update ICM defn');
43: return (FALSE);
44: when crm_error then
45: fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');
46: return (FALSE);
47: when in_use then
48: fnd_message.set_name ('FND', 'CONC-Delete Manager');
49: fnd_message.set_token ('MANAGER', qname, FALSE);

Line 48: fnd_message.set_name ('FND', 'CONC-Delete Manager');

44: when crm_error then
45: fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');
46: return (FALSE);
47: when in_use then
48: fnd_message.set_name ('FND', 'CONC-Delete Manager');
49: fnd_message.set_token ('MANAGER', qname, FALSE);
50: return (FALSE);
51: when others then
52: fnd_message.set_name ('FND', 'CP-Generic oracle error');

Line 49: fnd_message.set_token ('MANAGER', qname, FALSE);

45: fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');
46: return (FALSE);
47: when in_use then
48: fnd_message.set_name ('FND', 'CONC-Delete Manager');
49: fnd_message.set_token ('MANAGER', qname, FALSE);
50: return (FALSE);
51: when others then
52: fnd_message.set_name ('FND', 'CP-Generic oracle error');
53: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

Line 52: fnd_message.set_name ('FND', 'CP-Generic oracle error');

48: fnd_message.set_name ('FND', 'CONC-Delete Manager');
49: fnd_message.set_token ('MANAGER', qname, FALSE);
50: return (FALSE);
51: when others then
52: fnd_message.set_name ('FND', 'CP-Generic oracle error');
53: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
54: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
55: return (FALSE);
56: end check_deletability;

Line 53: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

49: fnd_message.set_token ('MANAGER', qname, FALSE);
50: return (FALSE);
51: when others then
52: fnd_message.set_name ('FND', 'CP-Generic oracle error');
53: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
54: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
55: return (FALSE);
56: end check_deletability;
57:

Line 54: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);

50: return (FALSE);
51: when others then
52: fnd_message.set_name ('FND', 'CP-Generic oracle error');
53: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
54: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
55: return (FALSE);
56: end check_deletability;
57:
58:

Line 78: fnd_message.set_name ('FND', 'CONC-Duplicate Manager SN');

74: or ro_id is null));
75:
76: exception
77: when no_data_found then
78: fnd_message.set_name ('FND', 'CONC-Duplicate Manager SN');
79: app_exception.raise_exception;
80: when others then
81: fnd_message.set_name ('FND', 'CP-Generic oracle error');
82: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

Line 81: fnd_message.set_name ('FND', 'CP-Generic oracle error');

77: when no_data_found then
78: fnd_message.set_name ('FND', 'CONC-Duplicate Manager SN');
79: app_exception.raise_exception;
80: when others then
81: fnd_message.set_name ('FND', 'CP-Generic oracle error');
82: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
83: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
84: app_exception.raise_exception;
85: end;

Line 82: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

78: fnd_message.set_name ('FND', 'CONC-Duplicate Manager SN');
79: app_exception.raise_exception;
80: when others then
81: fnd_message.set_name ('FND', 'CP-Generic oracle error');
82: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
83: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
84: app_exception.raise_exception;
85: end;
86:

Line 83: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);

79: app_exception.raise_exception;
80: when others then
81: fnd_message.set_name ('FND', 'CP-Generic oracle error');
82: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
83: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
84: app_exception.raise_exception;
85: end;
86:
87: begin

Line 100: fnd_message.set_name ('FND', 'CONC-Duplicate Manager');

96: or ro_id is null));
97:
98: exception
99: when no_data_found then
100: fnd_message.set_name ('FND', 'CONC-Duplicate Manager');
101: app_exception.raise_exception;
102: when others then
103: fnd_message.set_name ('FND', 'CP-Generic oracle error');
104: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

Line 103: fnd_message.set_name ('FND', 'CP-Generic oracle error');

99: when no_data_found then
100: fnd_message.set_name ('FND', 'CONC-Duplicate Manager');
101: app_exception.raise_exception;
102: when others then
103: fnd_message.set_name ('FND', 'CP-Generic oracle error');
104: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
105: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
106: app_exception.raise_exception;
107: end;

Line 104: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

100: fnd_message.set_name ('FND', 'CONC-Duplicate Manager');
101: app_exception.raise_exception;
102: when others then
103: fnd_message.set_name ('FND', 'CP-Generic oracle error');
104: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
105: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
106: app_exception.raise_exception;
107: end;
108:

Line 105: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);

101: app_exception.raise_exception;
102: when others then
103: fnd_message.set_name ('FND', 'CP-Generic oracle error');
104: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
105: fnd_message.set_token ('ROUTINE', 'check_unique_queue', FALSE);
106: app_exception.raise_exception;
107: end;
108:
109: end check_unique_queue;

Line 133: fnd_message.set_name ('FND', 'CONC-Duplicate period name');

129: or ro_id is null));
130:
131: exception
132: when no_data_found then
133: fnd_message.set_name ('FND', 'CONC-Duplicate period name');
134: app_exception.raise_exception;
135: when others then
136: fnd_message.set_name ('FND', 'CP-Generic oracle error');
137: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

Line 136: fnd_message.set_name ('FND', 'CP-Generic oracle error');

132: when no_data_found then
133: fnd_message.set_name ('FND', 'CONC-Duplicate period name');
134: app_exception.raise_exception;
135: when others then
136: fnd_message.set_name ('FND', 'CP-Generic oracle error');
137: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
138: fnd_message.set_token ('ROUTINE', 'check_unique_wkshift', FALSE);
139: app_exception.raise_exception;
140: end check_unique_wkshift;

Line 137: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

133: fnd_message.set_name ('FND', 'CONC-Duplicate period name');
134: app_exception.raise_exception;
135: when others then
136: fnd_message.set_name ('FND', 'CP-Generic oracle error');
137: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
138: fnd_message.set_token ('ROUTINE', 'check_unique_wkshift', FALSE);
139: app_exception.raise_exception;
140: end check_unique_wkshift;
141:

Line 138: fnd_message.set_token ('ROUTINE', 'check_unique_wkshift', FALSE);

134: app_exception.raise_exception;
135: when others then
136: fnd_message.set_name ('FND', 'CP-Generic oracle error');
137: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
138: fnd_message.set_token ('ROUTINE', 'check_unique_wkshift', FALSE);
139: app_exception.raise_exception;
140: end check_unique_wkshift;
141:
142:

Line 181: fnd_message.set_name ('FND', 'CONC-Duplicate specialization');

177: exception
178: when no_data_found then
179: null;
180: when duplicate_error then
181: fnd_message.set_name ('FND', 'CONC-Duplicate specialization');
182: app_exception.raise_exception;
183: when conflict_error then
184: fnd_message.set_name ('FND', 'CONC-Conflicting specializatin');
185: app_exception.raise_exception;

Line 184: fnd_message.set_name ('FND', 'CONC-Conflicting specializatin');

180: when duplicate_error then
181: fnd_message.set_name ('FND', 'CONC-Duplicate specialization');
182: app_exception.raise_exception;
183: when conflict_error then
184: fnd_message.set_name ('FND', 'CONC-Conflicting specializatin');
185: app_exception.raise_exception;
186: when others then
187: fnd_message.set_name ('FND', 'CP-Generic oracle error');
188: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

Line 187: fnd_message.set_name ('FND', 'CP-Generic oracle error');

183: when conflict_error then
184: fnd_message.set_name ('FND', 'CONC-Conflicting specializatin');
185: app_exception.raise_exception;
186: when others then
187: fnd_message.set_name ('FND', 'CP-Generic oracle error');
188: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
189: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
190: app_exception.raise_exception;
191: end check_conflicts;

Line 188: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);

184: fnd_message.set_name ('FND', 'CONC-Conflicting specializatin');
185: app_exception.raise_exception;
186: when others then
187: fnd_message.set_name ('FND', 'CP-Generic oracle error');
188: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
189: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
190: app_exception.raise_exception;
191: end check_conflicts;
192:

Line 189: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);

185: app_exception.raise_exception;
186: when others then
187: fnd_message.set_name ('FND', 'CP-Generic oracle error');
188: fnd_message.set_token ('ERROR', substr (sqlerrm, 1, 30), FALSE);
189: fnd_message.set_token ('ROUTINE', 'check_deletability', FALSE);
190: app_exception.raise_exception;
191: end check_conflicts;
192:
193: end FND_CONC_QUEUES_PKG;