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);
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);
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');
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);
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;
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:
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:
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);
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;
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:
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
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);
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;
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:
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;
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);
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;
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:
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:
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;
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);
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;
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:
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;