36: EXCEPTION
37: WHEN NO_DATA_FOUND THEN
38: x_error_code := SQLCODE;
39:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
37: WHEN NO_DATA_FOUND THEN
38: x_error_code := SQLCODE;
39:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
38: x_error_code := SQLCODE;
39:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
39:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
40: fnd_message.set_name('XNP','STD_GET_FAILED');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
48: fnd_message.set_name('XNP','GET_ASSIGNED_SP_ID_ERR');
41: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ASSIGNED_SP_ID');
42: fnd_message.set_token('ATTRNAME','ASSIGNED_SP_ID');
43: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
48: fnd_message.set_name('XNP','GET_ASSIGNED_SP_ID_ERR');
49: fnd_message.set_token('ERROR_TEXT',x_error_message);
44: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
48: fnd_message.set_name('XNP','GET_ASSIGNED_SP_ID_ERR');
49: fnd_message.set_token('ERROR_TEXT',x_error_message);
50: x_error_message := fnd_message.get;
51:
52: IF c_ASSIGNED_SP_ID%ISOPEN THEN
45: x_error_message := fnd_message.get;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
48: fnd_message.set_name('XNP','GET_ASSIGNED_SP_ID_ERR');
49: fnd_message.set_token('ERROR_TEXT',x_error_message);
50: x_error_message := fnd_message.get;
51:
52: IF c_ASSIGNED_SP_ID%ISOPEN THEN
53: CLOSE c_assigned_sp_id;
46: x_error_message := x_error_message||':'||SQLERRM;
47:
48: fnd_message.set_name('XNP','GET_ASSIGNED_SP_ID_ERR');
49: fnd_message.set_token('ERROR_TEXT',x_error_message);
50: x_error_message := fnd_message.get;
51:
52: IF c_ASSIGNED_SP_ID%ISOPEN THEN
53: CLOSE c_assigned_sp_id;
54: END IF;
55:
56: WHEN OTHERS THEN
57: x_error_code := SQLCODE;
58:
59: fnd_message.set_name('XNP','STD_ERROR');
60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');
61: fnd_message.set_token('ERROR_TEXT',SQLERRM);
62: x_error_message := fnd_message.get;
63:
56: WHEN OTHERS THEN
57: x_error_code := SQLCODE;
58:
59: fnd_message.set_name('XNP','STD_ERROR');
60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');
61: fnd_message.set_token('ERROR_TEXT',SQLERRM);
62: x_error_message := fnd_message.get;
63:
64: IF c_assigned_sp_id%ISOPEN THEN
57: x_error_code := SQLCODE;
58:
59: fnd_message.set_name('XNP','STD_ERROR');
60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');
61: fnd_message.set_token('ERROR_TEXT',SQLERRM);
62: x_error_message := fnd_message.get;
63:
64: IF c_assigned_sp_id%ISOPEN THEN
65: CLOSE c_assigned_sp_id;
58:
59: fnd_message.set_name('XNP','STD_ERROR');
60: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ASSIGNED_SP_ID');
61: fnd_message.set_token('ERROR_TEXT',SQLERRM);
62: x_error_message := fnd_message.get;
63:
64: IF c_assigned_sp_id%ISOPEN THEN
65: CLOSE c_assigned_sp_id;
66: END IF;
100: EXCEPTION
101: WHEN NO_DATA_FOUND THEN
102: x_error_code := SQLCODE;
103:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
101: WHEN NO_DATA_FOUND THEN
102: x_error_code := SQLCODE;
103:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
102: x_error_code := SQLCODE;
103:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
103:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
104: fnd_message.set_name('XNP','STD_GET_FAILED');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
112: fnd_message.set_name('XNP','GET_SP_ID_ERR');
105: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_ID');
106: fnd_message.set_token('ATTRNAME','SP_ID');
107: fnd_message.set_token('KEY','CODE');
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
112: fnd_message.set_name('XNP','GET_SP_ID_ERR');
113: fnd_message.set_token('ERROR_TEXT',x_error_message);
108: fnd_message.set_token('VALUE',p_SP_NAME);
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
112: fnd_message.set_name('XNP','GET_SP_ID_ERR');
113: fnd_message.set_token('ERROR_TEXT',x_error_message);
114: x_error_message := fnd_message.get;
115:
116: IF c_sp_id%ISOPEN THEN
109: x_error_message := fnd_message.get;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
112: fnd_message.set_name('XNP','GET_SP_ID_ERR');
113: fnd_message.set_token('ERROR_TEXT',x_error_message);
114: x_error_message := fnd_message.get;
115:
116: IF c_sp_id%ISOPEN THEN
117: CLOSE c_sp_id;
110: x_error_message := x_error_message||':'||SQLERRM;
111:
112: fnd_message.set_name('XNP','GET_SP_ID_ERR');
113: fnd_message.set_token('ERROR_TEXT',x_error_message);
114: x_error_message := fnd_message.get;
115:
116: IF c_sp_id%ISOPEN THEN
117: CLOSE c_sp_id;
118: END IF;
119:
120: WHEN OTHERS THEN
121: x_error_code := SQLCODE;
122:
123: fnd_message.set_name('XNP','STD_ERROR');
124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');
125: fnd_message.set_token('ERROR_TEXT',SQLERRM);
126: x_error_message := fnd_message.get;
127:
120: WHEN OTHERS THEN
121: x_error_code := SQLCODE;
122:
123: fnd_message.set_name('XNP','STD_ERROR');
124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');
125: fnd_message.set_token('ERROR_TEXT',SQLERRM);
126: x_error_message := fnd_message.get;
127:
128: IF c_SP_ID%ISOPEN THEN
121: x_error_code := SQLCODE;
122:
123: fnd_message.set_name('XNP','STD_ERROR');
124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');
125: fnd_message.set_token('ERROR_TEXT',SQLERRM);
126: x_error_message := fnd_message.get;
127:
128: IF c_SP_ID%ISOPEN THEN
129: CLOSE c_sp_id;
122:
123: fnd_message.set_name('XNP','STD_ERROR');
124: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_ID');
125: fnd_message.set_token('ERROR_TEXT',SQLERRM);
126: x_error_message := fnd_message.get;
127:
128: IF c_SP_ID%ISOPEN THEN
129: CLOSE c_sp_id;
130: END IF;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: x_error_code := SQLCODE;
165:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
163: WHEN NO_DATA_FOUND THEN
164: x_error_code := SQLCODE;
165:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;
164: x_error_code := SQLCODE;
165:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;
172: x_error_message := x_error_message||':'||SQLERRM;
165:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;
172: x_error_message := x_error_message||':'||SQLERRM;
173:
166: fnd_message.set_name('XNP','STD_GET_FAILED');
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;
172: x_error_message := x_error_message||':'||SQLERRM;
173:
174:
167: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SP_NAME_ID');
168: fnd_message.set_token('ATTRNAME','CODE');
169: fnd_message.set_token('KEY','SP_ID');
170: fnd_message.set_token('VALUE',to_char(p_SP_ID));
171: x_error_message := fnd_message.get;
172: x_error_message := x_error_message||':'||SQLERRM;
173:
174:
175: fnd_message.set_name('XNP','GET_SP_NAME_ERR');
171: x_error_message := fnd_message.get;
172: x_error_message := x_error_message||':'||SQLERRM;
173:
174:
175: fnd_message.set_name('XNP','GET_SP_NAME_ERR');
176: fnd_message.set_token('ERROR_TEXT',x_error_message);
177: x_error_message := fnd_message.get;
178:
179: IF c_sp_name%ISOPEN THEN
172: x_error_message := x_error_message||':'||SQLERRM;
173:
174:
175: fnd_message.set_name('XNP','GET_SP_NAME_ERR');
176: fnd_message.set_token('ERROR_TEXT',x_error_message);
177: x_error_message := fnd_message.get;
178:
179: IF c_sp_name%ISOPEN THEN
180: CLOSE c_sp_name;
173:
174:
175: fnd_message.set_name('XNP','GET_SP_NAME_ERR');
176: fnd_message.set_token('ERROR_TEXT',x_error_message);
177: x_error_message := fnd_message.get;
178:
179: IF c_sp_name%ISOPEN THEN
180: CLOSE c_sp_name;
181: END IF;
182:
183: WHEN OTHERS THEN
184: x_error_code := SQLCODE;
185:
186: fnd_message.set_name('XNP','STD_ERROR');
187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');
188: fnd_message.set_token('ERROR_TEXT',SQLERRM);
189: x_error_message := fnd_message.get;
190:
183: WHEN OTHERS THEN
184: x_error_code := SQLCODE;
185:
186: fnd_message.set_name('XNP','STD_ERROR');
187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');
188: fnd_message.set_token('ERROR_TEXT',SQLERRM);
189: x_error_message := fnd_message.get;
190:
191: IF c_sp_name%ISOPEN THEN
184: x_error_code := SQLCODE;
185:
186: fnd_message.set_name('XNP','STD_ERROR');
187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');
188: fnd_message.set_token('ERROR_TEXT',SQLERRM);
189: x_error_message := fnd_message.get;
190:
191: IF c_sp_name%ISOPEN THEN
192: CLOSE c_sp_name;
185:
186: fnd_message.set_name('XNP','STD_ERROR');
187: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SP_NAME');
188: fnd_message.set_token('ERROR_TEXT',SQLERRM);
189: x_error_message := fnd_message.get;
190:
191: IF c_sp_name%ISOPEN THEN
192: CLOSE c_sp_name;
193: END IF;
224: EXCEPTION
225: WHEN NO_DATA_FOUND THEN
226: x_error_code := SQLCODE;
227:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
225: WHEN NO_DATA_FOUND THEN
226: x_error_code := SQLCODE;
227:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;
226: x_error_code := SQLCODE;
227:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;
234: x_error_message := x_error_message||':'||SQLERRM;
227:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;
234: x_error_message := x_error_message||':'||SQLERRM;
235:
228: fnd_message.set_name('XNP','STD_GET_FAILED');
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;
234: x_error_message := x_error_message||':'||SQLERRM;
235:
236:
229: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_ROUTING_NUMBER_ID');
230: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
231: fnd_message.set_token('KEY','ROUTING_NUMBER');
232: fnd_message.set_token('VALUE',p_ROUTING_NUMBER);
233: x_error_message := fnd_message.get;
234: x_error_message := x_error_message||':'||SQLERRM;
235:
236:
237: fnd_message.set_name('XNP','GET_ROUTING_NUMBER_ID_ERR');
233: x_error_message := fnd_message.get;
234: x_error_message := x_error_message||':'||SQLERRM;
235:
236:
237: fnd_message.set_name('XNP','GET_ROUTING_NUMBER_ID_ERR');
238: fnd_message.set_token('ERROR_TEXT',x_error_message);
239: x_error_message := fnd_message.get;
240:
241: IF c_routing_number_id%ISOPEN THEN
234: x_error_message := x_error_message||':'||SQLERRM;
235:
236:
237: fnd_message.set_name('XNP','GET_ROUTING_NUMBER_ID_ERR');
238: fnd_message.set_token('ERROR_TEXT',x_error_message);
239: x_error_message := fnd_message.get;
240:
241: IF c_routing_number_id%ISOPEN THEN
242: CLOSE c_routing_number_id;
235:
236:
237: fnd_message.set_name('XNP','GET_ROUTING_NUMBER_ID_ERR');
238: fnd_message.set_token('ERROR_TEXT',x_error_message);
239: x_error_message := fnd_message.get;
240:
241: IF c_routing_number_id%ISOPEN THEN
242: CLOSE c_routing_number_id;
243: END IF;
244:
245: WHEN OTHERS THEN
246: x_error_code := SQLCODE;
247:
248: fnd_message.set_name('XNP','STD_ERROR');
249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');
250: fnd_message.set_token('ERROR_TEXT',SQLERRM);
251: x_error_message := fnd_message.get;
252:
245: WHEN OTHERS THEN
246: x_error_code := SQLCODE;
247:
248: fnd_message.set_name('XNP','STD_ERROR');
249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');
250: fnd_message.set_token('ERROR_TEXT',SQLERRM);
251: x_error_message := fnd_message.get;
252:
253: IF c_routing_number_id%ISOPEN THEN
246: x_error_code := SQLCODE;
247:
248: fnd_message.set_name('XNP','STD_ERROR');
249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');
250: fnd_message.set_token('ERROR_TEXT',SQLERRM);
251: x_error_message := fnd_message.get;
252:
253: IF c_routing_number_id%ISOPEN THEN
254: CLOSE c_routing_number_id;
247:
248: fnd_message.set_name('XNP','STD_ERROR');
249: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_ROUTING_NUMBER_ID');
250: fnd_message.set_token('ERROR_TEXT',SQLERRM);
251: x_error_message := fnd_message.get;
252:
253: IF c_routing_number_id%ISOPEN THEN
254: CLOSE c_routing_number_id;
255: END IF;
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: x_error_code := SQLCODE;
375:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
373: WHEN NO_DATA_FOUND THEN
374: x_error_code := SQLCODE;
375:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
374: x_error_code := SQLCODE;
375:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
375:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
376: fnd_message.set_name('XNP','STD_GET_FAILED');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
384: fnd_message.set_name('XNP','GET_NRC_ID_ERR');
377: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NRC_ID');
378: fnd_message.set_token('ATTRNAME','NRC_ID');
379: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
384: fnd_message.set_name('XNP','GET_NRC_ID_ERR');
385: fnd_message.set_token('ERROR_TEXT',x_error_message);
380: fnd_message.set_token('VALUE',p_STARTING_NUMBER||':'||p_ENDING_NUMBER);
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
384: fnd_message.set_name('XNP','GET_NRC_ID_ERR');
385: fnd_message.set_token('ERROR_TEXT',x_error_message);
386: x_error_message := fnd_message.get;
387:
388: IF c_geo_id%ISOPEN THEN
381: x_error_message := fnd_message.get;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
384: fnd_message.set_name('XNP','GET_NRC_ID_ERR');
385: fnd_message.set_token('ERROR_TEXT',x_error_message);
386: x_error_message := fnd_message.get;
387:
388: IF c_geo_id%ISOPEN THEN
389: CLOSE c_geo_id;
382: x_error_message := x_error_message||':'||SQLERRM;
383:
384: fnd_message.set_name('XNP','GET_NRC_ID_ERR');
385: fnd_message.set_token('ERROR_TEXT',x_error_message);
386: x_error_message := fnd_message.get;
387:
388: IF c_geo_id%ISOPEN THEN
389: CLOSE c_geo_id;
390: END IF;
399:
400: WHEN OTHERS THEN
401: x_error_code := SQLCODE;
402:
403: fnd_message.set_name('XNP','STD_ERROR');
404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');
405: fnd_message.set_token('ERROR_TEXT',SQLERRM);
406: x_error_message := fnd_message.get;
407:
400: WHEN OTHERS THEN
401: x_error_code := SQLCODE;
402:
403: fnd_message.set_name('XNP','STD_ERROR');
404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');
405: fnd_message.set_token('ERROR_TEXT',SQLERRM);
406: x_error_message := fnd_message.get;
407:
408: IF c_geo_id%ISOPEN THEN
401: x_error_code := SQLCODE;
402:
403: fnd_message.set_name('XNP','STD_ERROR');
404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');
405: fnd_message.set_token('ERROR_TEXT',SQLERRM);
406: x_error_message := fnd_message.get;
407:
408: IF c_geo_id%ISOPEN THEN
409: CLOSE c_geo_id;
402:
403: fnd_message.set_name('XNP','STD_ERROR');
404: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NRC_ID');
405: fnd_message.set_token('ERROR_TEXT',SQLERRM);
406: x_error_message := fnd_message.get;
407:
408: IF c_geo_id%ISOPEN THEN
409: CLOSE c_geo_id;
410: END IF;
453:
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: x_error_code := SQLCODE;
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: x_error_code := SQLCODE;
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
462: ('VALUE'
455: WHEN NO_DATA_FOUND THEN
456: x_error_code := SQLCODE;
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
462: ('VALUE'
463: ,p_subscription_tn
456: x_error_code := SQLCODE;
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
462: ('VALUE'
463: ,p_subscription_tn
464: ||':'||to_char(p_local_sp_id)
457: fnd_message.set_name('XNP','STD_GET_FAILED');
458: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SOA_SV_ID');
459: fnd_message.set_token('ATTRNAME','SV');
460: fnd_message.set_token('KEY','TN:SPID:PHASE');
461: fnd_message.set_token
462: ('VALUE'
463: ,p_subscription_tn
464: ||':'||to_char(p_local_sp_id)
465: ||':'||p_phase_indicator
463: ,p_subscription_tn
464: ||':'||to_char(p_local_sp_id)
465: ||':'||p_phase_indicator
466: );
467: x_error_message := fnd_message.get;
468: x_error_message := x_error_message||':'||SQLERRM;
469:
470:
471: fnd_message.set_name('XNP','GET_SOA_SV_ID_ERR');
467: x_error_message := fnd_message.get;
468: x_error_message := x_error_message||':'||SQLERRM;
469:
470:
471: fnd_message.set_name('XNP','GET_SOA_SV_ID_ERR');
472: fnd_message.set_token('ERROR_TEXT',x_error_message);
473: x_error_message := fnd_message.get;
474:
475: IF c_SV_ID%ISOPEN THEN
468: x_error_message := x_error_message||':'||SQLERRM;
469:
470:
471: fnd_message.set_name('XNP','GET_SOA_SV_ID_ERR');
472: fnd_message.set_token('ERROR_TEXT',x_error_message);
473: x_error_message := fnd_message.get;
474:
475: IF c_SV_ID%ISOPEN THEN
476: CLOSE c_sv_id;
469:
470:
471: fnd_message.set_name('XNP','GET_SOA_SV_ID_ERR');
472: fnd_message.set_token('ERROR_TEXT',x_error_message);
473: x_error_message := fnd_message.get;
474:
475: IF c_SV_ID%ISOPEN THEN
476: CLOSE c_sv_id;
477: END IF;
477: END IF;
478:
479: WHEN OTHERS THEN
480: x_error_code := SQLCODE;
481: fnd_message.set_name('XNP','STD_ERROR');
482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');
483: fnd_message.set_token('ERROR_TEXT',SQLERRM);
484: x_error_message := fnd_message.get;
485:
478:
479: WHEN OTHERS THEN
480: x_error_code := SQLCODE;
481: fnd_message.set_name('XNP','STD_ERROR');
482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');
483: fnd_message.set_token('ERROR_TEXT',SQLERRM);
484: x_error_message := fnd_message.get;
485:
486: IF c_sv_id%ISOPEN THEN
479: WHEN OTHERS THEN
480: x_error_code := SQLCODE;
481: fnd_message.set_name('XNP','STD_ERROR');
482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');
483: fnd_message.set_token('ERROR_TEXT',SQLERRM);
484: x_error_message := fnd_message.get;
485:
486: IF c_sv_id%ISOPEN THEN
487: CLOSE c_sv_id;
480: x_error_code := SQLCODE;
481: fnd_message.set_name('XNP','STD_ERROR');
482: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SOA_SV_ID');
483: fnd_message.set_token('ERROR_TEXT',SQLERRM);
484: x_error_message := fnd_message.get;
485:
486: IF c_sv_id%ISOPEN THEN
487: CLOSE c_sv_id;
488: END IF;
520: EXCEPTION
521: WHEN NO_DATA_FOUND THEN
522: x_error_code := SQLCODE;
523:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
521: WHEN NO_DATA_FOUND THEN
522: x_error_code := SQLCODE;
523:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;
522: x_error_code := SQLCODE;
523:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;
530: x_error_message := x_error_message||':'||SQLERRM;
523:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;
530: x_error_message := x_error_message||':'||SQLERRM;
531:
524: fnd_message.set_name('XNP','STD_GET_FAILED');
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;
530: x_error_message := x_error_message||':'||SQLERRM;
531:
532:
525: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_PHASE_FOR_STATUS');
526: fnd_message.set_token('ATTRNAME','PHASE_INDICATOR');
527: fnd_message.set_token('KEY','STATUS_TYPE_CODE');
528: fnd_message.set_token('VALUE',p_CUR_STATUS_TYPE_CODE);
529: x_error_message := fnd_message.get;
530: x_error_message := x_error_message||':'||SQLERRM;
531:
532:
533: fnd_message.set_name('XNP','GET_PHASE_FOR_STATUS_ERR');
529: x_error_message := fnd_message.get;
530: x_error_message := x_error_message||':'||SQLERRM;
531:
532:
533: fnd_message.set_name('XNP','GET_PHASE_FOR_STATUS_ERR');
534: fnd_message.set_token('ERROR_TEXT',x_error_message);
535: x_error_message := fnd_message.get;
536:
537: IF c_phase_indicator%ISOPEN THEN
530: x_error_message := x_error_message||':'||SQLERRM;
531:
532:
533: fnd_message.set_name('XNP','GET_PHASE_FOR_STATUS_ERR');
534: fnd_message.set_token('ERROR_TEXT',x_error_message);
535: x_error_message := fnd_message.get;
536:
537: IF c_phase_indicator%ISOPEN THEN
538: CLOSE c_phase_indicator;
531:
532:
533: fnd_message.set_name('XNP','GET_PHASE_FOR_STATUS_ERR');
534: fnd_message.set_token('ERROR_TEXT',x_error_message);
535: x_error_message := fnd_message.get;
536:
537: IF c_phase_indicator%ISOPEN THEN
538: CLOSE c_phase_indicator;
539: END IF;
540:
541: WHEN OTHERS THEN
542: x_error_code := SQLCODE;
543:
544: fnd_message.set_name('XNP','STD_ERROR');
545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');
546: fnd_message.set_token('ERROR_TEXT',SQLERRM);
547: x_error_message := fnd_message.get;
548:
541: WHEN OTHERS THEN
542: x_error_code := SQLCODE;
543:
544: fnd_message.set_name('XNP','STD_ERROR');
545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');
546: fnd_message.set_token('ERROR_TEXT',SQLERRM);
547: x_error_message := fnd_message.get;
548:
549: IF c_phase_indicator%ISOPEN THEN
542: x_error_code := SQLCODE;
543:
544: fnd_message.set_name('XNP','STD_ERROR');
545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');
546: fnd_message.set_token('ERROR_TEXT',SQLERRM);
547: x_error_message := fnd_message.get;
548:
549: IF c_phase_indicator%ISOPEN THEN
550: CLOSE c_phase_indicator;
543:
544: fnd_message.set_name('XNP','STD_ERROR');
545: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_PHASE_FOR_STATUS');
546: fnd_message.set_token('ERROR_TEXT',SQLERRM);
547: x_error_message := fnd_message.get;
548:
549: IF c_phase_indicator%ISOPEN THEN
550: CLOSE c_phase_indicator;
551: END IF;
582:
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: x_error_code := SQLCODE;
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
583: EXCEPTION
584: WHEN NO_DATA_FOUND THEN
585: x_error_code := SQLCODE;
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
591: ('VALUE'
584: WHEN NO_DATA_FOUND THEN
585: x_error_code := SQLCODE;
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
591: ('VALUE'
592: ,p_starting_number||':'||p_ending_number
585: x_error_code := SQLCODE;
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
591: ('VALUE'
592: ,p_starting_number||':'||p_ending_number
593: );
586: fnd_message.set_name('XNP','STD_GET_FAILED');
587: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_NUMBER_RANGE_ID');
588: fnd_message.set_token('ATTRNAME','NUMBER_RANGE_ID');
589: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
590: fnd_message.set_token
591: ('VALUE'
592: ,p_starting_number||':'||p_ending_number
593: );
594: x_error_message := fnd_message.get;
590: fnd_message.set_token
591: ('VALUE'
592: ,p_starting_number||':'||p_ending_number
593: );
594: x_error_message := fnd_message.get;
595: x_error_message := x_error_message||':'||SQLERRM;
596:
597: fnd_message.set_name('XNP','GET_NUMBER_RANGE_ID_ERR');
598: fnd_message.set_token('ERROR_TEXT',x_error_message);
593: );
594: x_error_message := fnd_message.get;
595: x_error_message := x_error_message||':'||SQLERRM;
596:
597: fnd_message.set_name('XNP','GET_NUMBER_RANGE_ID_ERR');
598: fnd_message.set_token('ERROR_TEXT',x_error_message);
599: x_error_message := fnd_message.get;
600:
601: IF c_number_range_id%ISOPEN THEN
594: x_error_message := fnd_message.get;
595: x_error_message := x_error_message||':'||SQLERRM;
596:
597: fnd_message.set_name('XNP','GET_NUMBER_RANGE_ID_ERR');
598: fnd_message.set_token('ERROR_TEXT',x_error_message);
599: x_error_message := fnd_message.get;
600:
601: IF c_number_range_id%ISOPEN THEN
602: CLOSE c_number_range_id;
595: x_error_message := x_error_message||':'||SQLERRM;
596:
597: fnd_message.set_name('XNP','GET_NUMBER_RANGE_ID_ERR');
598: fnd_message.set_token('ERROR_TEXT',x_error_message);
599: x_error_message := fnd_message.get;
600:
601: IF c_number_range_id%ISOPEN THEN
602: CLOSE c_number_range_id;
603: END IF;
602: CLOSE c_number_range_id;
603: END IF;
604: WHEN OTHERS THEN
605: x_error_code := SQLCODE;
606: fnd_message.set_name('XNP','STD_ERROR');
607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');
608: fnd_message.set_token('ERROR_TEXT',SQLERRM);
609: x_error_message := fnd_message.get;
610: IF c_number_range_id%ISOPEN THEN
603: END IF;
604: WHEN OTHERS THEN
605: x_error_code := SQLCODE;
606: fnd_message.set_name('XNP','STD_ERROR');
607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');
608: fnd_message.set_token('ERROR_TEXT',SQLERRM);
609: x_error_message := fnd_message.get;
610: IF c_number_range_id%ISOPEN THEN
611: CLOSE c_number_range_id;
604: WHEN OTHERS THEN
605: x_error_code := SQLCODE;
606: fnd_message.set_name('XNP','STD_ERROR');
607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');
608: fnd_message.set_token('ERROR_TEXT',SQLERRM);
609: x_error_message := fnd_message.get;
610: IF c_number_range_id%ISOPEN THEN
611: CLOSE c_number_range_id;
612: END IF;
605: x_error_code := SQLCODE;
606: fnd_message.set_name('XNP','STD_ERROR');
607: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_NUMBER_RANGE_ID');
608: fnd_message.set_token('ERROR_TEXT',SQLERRM);
609: x_error_message := fnd_message.get;
610: IF c_number_range_id%ISOPEN THEN
611: CLOSE c_number_range_id;
612: END IF;
613:
643:
644: EXCEPTION
645: WHEN NO_DATA_FOUND THEN
646: x_error_code := SQLCODE;
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
644: EXCEPTION
645: WHEN NO_DATA_FOUND THEN
646: x_error_code := SQLCODE;
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;
645: WHEN NO_DATA_FOUND THEN
646: x_error_code := SQLCODE;
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;
653: x_error_message := x_error_message||':'||SQLERRM;
646: x_error_code := SQLCODE;
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;
653: x_error_message := x_error_message||':'||SQLERRM;
654:
647: fnd_message.set_name('XNP','STD_GET_FAILED');
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;
653: x_error_message := x_error_message||':'||SQLERRM;
654:
655:
648: fnd_message.set_token('FAILED_PROC','XNP_CORE.GET_SMS_SV_ID');
649: fnd_message.set_token('ATTRNAME','SMS SV');
650: fnd_message.set_token('KEY','SUBSCRIPTION_TN');
651: fnd_message.set_token('VALUE',p_SUBSCRIPTION_TN);
652: x_error_message := fnd_message.get;
653: x_error_message := x_error_message||':'||SQLERRM;
654:
655:
656: fnd_message.set_name('XNP','GET_SMS_SV_ID_ERR');
652: x_error_message := fnd_message.get;
653: x_error_message := x_error_message||':'||SQLERRM;
654:
655:
656: fnd_message.set_name('XNP','GET_SMS_SV_ID_ERR');
657: fnd_message.set_token('ERROR_TEXT',x_error_message);
658: x_error_message := fnd_message.get;
659:
660: IF c_sms_id%ISOPEN THEN
653: x_error_message := x_error_message||':'||SQLERRM;
654:
655:
656: fnd_message.set_name('XNP','GET_SMS_SV_ID_ERR');
657: fnd_message.set_token('ERROR_TEXT',x_error_message);
658: x_error_message := fnd_message.get;
659:
660: IF c_sms_id%ISOPEN THEN
661: CLOSE c_sms_id;
654:
655:
656: fnd_message.set_name('XNP','GET_SMS_SV_ID_ERR');
657: fnd_message.set_token('ERROR_TEXT',x_error_message);
658: x_error_message := fnd_message.get;
659:
660: IF c_sms_id%ISOPEN THEN
661: CLOSE c_sms_id;
662: END IF;
663:
664: WHEN OTHERS THEN
665: x_error_code := SQLCODE;
666:
667: fnd_message.set_name('XNP','STD_ERROR');
668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');
669: fnd_message.set_token('ERROR_TEXT',SQLERRM);
670: x_error_message := fnd_message.get;
671:
664: WHEN OTHERS THEN
665: x_error_code := SQLCODE;
666:
667: fnd_message.set_name('XNP','STD_ERROR');
668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');
669: fnd_message.set_token('ERROR_TEXT',SQLERRM);
670: x_error_message := fnd_message.get;
671:
672: IF c_sms_id%ISOPEN THEN
665: x_error_code := SQLCODE;
666:
667: fnd_message.set_name('XNP','STD_ERROR');
668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');
669: fnd_message.set_token('ERROR_TEXT',SQLERRM);
670: x_error_message := fnd_message.get;
671:
672: IF c_sms_id%ISOPEN THEN
673: CLOSE c_sms_id;
666:
667: fnd_message.set_name('XNP','STD_ERROR');
668: fnd_message.set_token('ERROR_LOCN','XNP_CORE.GET_SMS_SV_ID');
669: fnd_message.set_token('ERROR_TEXT',SQLERRM);
670: x_error_message := fnd_message.get;
671:
672: IF c_sms_id%ISOPEN THEN
673: CLOSE c_sms_id;
674: END IF;
844:
845: EXCEPTION
846: WHEN OTHERS THEN
847: x_error_code := SQLCODE;
848: fnd_message.set_name('XNP','STD_ERROR');
849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');
850: fnd_message.set_token('ERROR_TEXT',SQLERRM);
851: x_error_message := fnd_message.get;
852:
845: EXCEPTION
846: WHEN OTHERS THEN
847: x_error_code := SQLCODE;
848: fnd_message.set_name('XNP','STD_ERROR');
849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');
850: fnd_message.set_token('ERROR_TEXT',SQLERRM);
851: x_error_message := fnd_message.get;
852:
853: IF c_check_sms_sv_exists%ISOPEN THEN
846: WHEN OTHERS THEN
847: x_error_code := SQLCODE;
848: fnd_message.set_name('XNP','STD_ERROR');
849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');
850: fnd_message.set_token('ERROR_TEXT',SQLERRM);
851: x_error_message := fnd_message.get;
852:
853: IF c_check_sms_sv_exists%ISOPEN THEN
854: CLOSE c_check_sms_sv_exists;
847: x_error_code := SQLCODE;
848: fnd_message.set_name('XNP','STD_ERROR');
849: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SMS_CREATE_PORTED_NUMBER');
850: fnd_message.set_token('ERROR_TEXT',SQLERRM);
851: x_error_message := fnd_message.get;
852:
853: IF c_check_sms_sv_exists%ISOPEN THEN
854: CLOSE c_check_sms_sv_exists;
855: END IF;
952: EXCEPTION
953:
954: WHEN OTHERS THEN
955: x_error_code := SQLCODE;
956: fnd_message.set_name('XNP','STD_ERROR');
957: fnd_message.set_token('ERROR_LOCN'
958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
959: fnd_message.set_token('ERROR_TEXT',SQLERRM);
960: x_error_message := fnd_message.get;
953:
954: WHEN OTHERS THEN
955: x_error_code := SQLCODE;
956: fnd_message.set_name('XNP','STD_ERROR');
957: fnd_message.set_token('ERROR_LOCN'
958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
959: fnd_message.set_token('ERROR_TEXT',SQLERRM);
960: x_error_message := fnd_message.get;
961:
955: x_error_code := SQLCODE;
956: fnd_message.set_name('XNP','STD_ERROR');
957: fnd_message.set_token('ERROR_LOCN'
958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
959: fnd_message.set_token('ERROR_TEXT',SQLERRM);
960: x_error_message := fnd_message.get;
961:
962: END SOA_UPDATE_CUTOFF_DATE;
963:
956: fnd_message.set_name('XNP','STD_ERROR');
957: fnd_message.set_token('ERROR_LOCN'
958: ,'XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
959: fnd_message.set_token('ERROR_TEXT',SQLERRM);
960: x_error_message := fnd_message.get;
961:
962: END SOA_UPDATE_CUTOFF_DATE;
963:
964: PROCEDURE SOA_UPDATE_SV_STATUS
1093: WHEN dup_val_on_index THEN
1094: null;
1095: WHEN OTHERS THEN
1096: x_error_code := SQLCODE;
1097: fnd_message.set_name('XNP','STD_ERROR');
1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
1099: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1100: x_error_message := fnd_message.get;
1101:
1094: null;
1095: WHEN OTHERS THEN
1096: x_error_code := SQLCODE;
1097: fnd_message.set_name('XNP','STD_ERROR');
1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
1099: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1100: x_error_message := fnd_message.get;
1101:
1102: END SOA_UPDATE_SV_STATUS;
1095: WHEN OTHERS THEN
1096: x_error_code := SQLCODE;
1097: fnd_message.set_name('XNP','STD_ERROR');
1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
1099: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1100: x_error_message := fnd_message.get;
1101:
1102: END SOA_UPDATE_SV_STATUS;
1103:
1096: x_error_code := SQLCODE;
1097: fnd_message.set_name('XNP','STD_ERROR');
1098: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
1099: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1100: x_error_message := fnd_message.get;
1101:
1102: END SOA_UPDATE_SV_STATUS;
1103:
1104: PROCEDURE SOA_CREATE_REC_PORT_ORDER
1245:
1246: IF (p_subsequent_port_flag = 'N') AND (l_pto_flag = 'N') THEN
1247: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1248: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1246: IF (p_subsequent_port_flag = 'N') AND (l_pto_flag = 'N') THEN
1247: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1248: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;
1247: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1248: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;
1255: RETURN;
1248: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;
1255: RETURN;
1256: END IF;
1249: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;
1255: RETURN;
1256: END IF;
1257: END IF;
1250: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1251: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1252: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1253: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1254: x_error_message := fnd_message.get;
1255: RETURN;
1256: END IF;
1257: END IF;
1258:
1265: -- ,val => l_new_status_type_code) ;
1266:
1267: IF (l_new_status_type_code IS null) THEN
1268: x_error_code := xnp_errors.g_invalid_sv_status;
1269: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1270: x_error_message := fnd_message.get;
1271: END IF;
1272:
1273: FOR l_counter IN 0..l_diff
1266:
1267: IF (l_new_status_type_code IS null) THEN
1268: x_error_code := xnp_errors.g_invalid_sv_status;
1269: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1270: x_error_message := fnd_message.get;
1271: END IF;
1272:
1273: FOR l_counter IN 0..l_diff
1274:
1414:
1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: x_error_code := SQLCODE;
1418: fnd_message.set_name('XNP','STD_ERROR');
1419: fnd_message.set_token('ERROR_LOCN'
1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1421: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1422: x_error_message := fnd_message.get;
1415: EXCEPTION
1416: WHEN OTHERS THEN
1417: x_error_code := SQLCODE;
1418: fnd_message.set_name('XNP','STD_ERROR');
1419: fnd_message.set_token('ERROR_LOCN'
1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1421: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1422: x_error_message := fnd_message.get;
1423:
1417: x_error_code := SQLCODE;
1418: fnd_message.set_name('XNP','STD_ERROR');
1419: fnd_message.set_token('ERROR_LOCN'
1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1421: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1422: x_error_message := fnd_message.get;
1423:
1424: END SOA_CREATE_REC_PORT_ORDER;
1425:
1418: fnd_message.set_name('XNP','STD_ERROR');
1419: fnd_message.set_token('ERROR_LOCN'
1420: ,'XNP_CORE.SOA_CREATE_REC_PORT_ORDER');
1421: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1422: x_error_message := fnd_message.get;
1423:
1424: END SOA_CREATE_REC_PORT_ORDER;
1425:
1426: PROCEDURE SOA_CREATE_NRC_PORT_ORDER
1584: IF (p_subsequent_port_flag = 'N') AND (l_pto_flag = 'N') THEN
1585:
1586: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1587: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1585:
1586: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1587: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:
1586: IF (p_donor_sp_id <> l_assigned_sp_id) THEN
1587: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:
1594: x_error_message := fnd_message.get;
1587: x_error_code := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:
1594: x_error_message := fnd_message.get;
1595: RETURN;
1588: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1589: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:
1594: x_error_message := fnd_message.get;
1595: RETURN;
1596: END IF;
1590: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1591: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1592: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1593:
1594: x_error_message := fnd_message.get;
1595: RETURN;
1596: END IF;
1597: END IF;
1598:
1656: --- ,val => l_new_status_type_code) ;
1657:
1658: IF (l_new_status_type_code IS null) THEN
1659: x_error_code := xnp_errors.g_invalid_sv_status;
1660: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1661: x_error_message := fnd_message.get;
1662: END IF;
1663:
1664:
1657:
1658: IF (l_new_status_type_code IS null) THEN
1659: x_error_code := xnp_errors.g_invalid_sv_status;
1660: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1661: x_error_message := fnd_message.get;
1662: END IF;
1663:
1664:
1665: FOR l_counter IN 0..l_diff
1806:
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: x_error_code := SQLCODE;
1810: fnd_message.set_name('XNP','STD_ERROR');
1811: fnd_message.set_token('ERROR_LOCN'
1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1813: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1814: x_error_message := fnd_message.get;
1807: EXCEPTION
1808: WHEN OTHERS THEN
1809: x_error_code := SQLCODE;
1810: fnd_message.set_name('XNP','STD_ERROR');
1811: fnd_message.set_token('ERROR_LOCN'
1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1813: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1814: x_error_message := fnd_message.get;
1815:
1809: x_error_code := SQLCODE;
1810: fnd_message.set_name('XNP','STD_ERROR');
1811: fnd_message.set_token('ERROR_LOCN'
1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1813: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1814: x_error_message := fnd_message.get;
1815:
1816: END SOA_CREATE_NRC_PORT_ORDER;
1817:
1810: fnd_message.set_name('XNP','STD_ERROR');
1811: fnd_message.set_token('ERROR_LOCN'
1812: ,'XNP_CORE.SOA_CREATE_NRC_PORT_ORDER');
1813: fnd_message.set_token('ERROR_TEXT',SQLERRM);
1814: x_error_message := fnd_message.get;
1815:
1816: END SOA_CREATE_NRC_PORT_ORDER;
1817:
1818: PROCEDURE SOA_CREATE_DON_PORT_ORDER
1934: ***/
1935:
1936: IF (l_new_status_type_code IS null) THEN
1937: x_error_code := xnp_errors.g_invalid_sv_status;
1938: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1939: x_error_message := fnd_message.get;
1940: END IF;
1941:
1942:
1935:
1936: IF (l_new_status_type_code IS null) THEN
1937: x_error_code := xnp_errors.g_invalid_sv_status;
1938: fnd_message.set_name('XNP','XNP_CVU_INITIAL_STATUS_OF_SV');
1939: x_error_message := fnd_message.get;
1940: END IF;
1941:
1942:
1943: --
1982: IF (p_SUBSEQUENT_PORT_FLAG = 'N') AND (l_PTO_FLAG = 'N') THEN
1983: IF (p_DONOR_SP_ID <> l_ASSIGNED_SP_ID) THEN
1984: x_ERROR_CODE := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1985:
1986: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1983: IF (p_DONOR_SP_ID <> l_ASSIGNED_SP_ID) THEN
1984: x_ERROR_CODE := XNP_ERRORS.G_DONOR_NOT_ASSIGNED_TN;
1985:
1986: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1985:
1986: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1992:
1993: x_error_message := fnd_message.get;
1986: fnd_message.set_name('XNP','NUMRANGE_NOT_BELONGING_TO_DON');
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1992:
1993: x_error_message := fnd_message.get;
1994: RETURN;
1987: fnd_message.set_token('ERROR_LOCN'
1988: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1992:
1993: x_error_message := fnd_message.get;
1994: RETURN;
1995: END IF;
1989: fnd_message.set_token('SN',to_char(p_STARTING_NUMBER));
1990: fnd_message.set_token('EN',to_char(p_ENDING_NUMBER));
1991: fnd_message.set_token('DON',to_char(p_DONOR_SP_ID));
1992:
1993: x_error_message := fnd_message.get;
1994: RETURN;
1995: END IF;
1996: END IF;
1997:
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: x_ERROR_CODE := SQLCODE;
2146: fnd_message.set_name('XNP','STD_ERROR');
2147: fnd_message.set_token('ERROR_LOCN'
2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
2149: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2150: x_error_message := fnd_message.get;
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: x_ERROR_CODE := SQLCODE;
2146: fnd_message.set_name('XNP','STD_ERROR');
2147: fnd_message.set_token('ERROR_LOCN'
2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
2149: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2150: x_error_message := fnd_message.get;
2151:
2145: x_ERROR_CODE := SQLCODE;
2146: fnd_message.set_name('XNP','STD_ERROR');
2147: fnd_message.set_token('ERROR_LOCN'
2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
2149: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2150: x_error_message := fnd_message.get;
2151:
2152: END SOA_CREATE_DON_PORT_ORDER;
2153:
2146: fnd_message.set_name('XNP','STD_ERROR');
2147: fnd_message.set_token('ERROR_LOCN'
2148: ,'XNP_CORE.SOA_CREATE_DON_PORT_ORDER');
2149: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2150: x_error_message := fnd_message.get;
2151:
2152: END SOA_CREATE_DON_PORT_ORDER;
2153:
2154: PROCEDURE SOA_CHECK_NOTIFY_DIR_SVS
2181:
2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN
2184: x_ERROR_CODE := SQLCODE;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN
2184: x_ERROR_CODE := SQLCODE;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=
2183: WHEN NO_DATA_FOUND THEN
2184: x_ERROR_CODE := SQLCODE;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=
2191: fnd_message.get;
2184: x_ERROR_CODE := SQLCODE;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=
2191: fnd_message.get;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2185: fnd_message.set_name('XNP','STD_GET_FAILED');
2186: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=
2191: fnd_message.get;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2193:
2187: fnd_message.set_token('ATTRNAME','RETAIN_DIR_INFO_FLAG');
2188: fnd_message.set_token('KEY','PORTING_ID');
2189: fnd_message.set_token('VALUE',p_PORTING_ID);
2190: x_error_message :=
2191: fnd_message.get;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2193:
2194: fnd_message.set_name('XNP','NOTIFY_DIR_SVS_ERR');
2195: fnd_message.set_token('ERROR_TEXT',x_error_message);
2190: x_error_message :=
2191: fnd_message.get;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2193:
2194: fnd_message.set_name('XNP','NOTIFY_DIR_SVS_ERR');
2195: fnd_message.set_token('ERROR_TEXT',x_error_message);
2196: x_error_message := fnd_message.get;
2197:
2198: IF c_CHECK_STATUS%ISOPEN THEN
2191: fnd_message.get;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2193:
2194: fnd_message.set_name('XNP','NOTIFY_DIR_SVS_ERR');
2195: fnd_message.set_token('ERROR_TEXT',x_error_message);
2196: x_error_message := fnd_message.get;
2197:
2198: IF c_CHECK_STATUS%ISOPEN THEN
2199: CLOSE c_CHECK_STATUS;
2192: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2193:
2194: fnd_message.set_name('XNP','NOTIFY_DIR_SVS_ERR');
2195: fnd_message.set_token('ERROR_TEXT',x_error_message);
2196: x_error_message := fnd_message.get;
2197:
2198: IF c_CHECK_STATUS%ISOPEN THEN
2199: CLOSE c_CHECK_STATUS;
2200: END IF;
2200: END IF;
2201:
2202: WHEN OTHERS THEN
2203: x_ERROR_CODE := SQLCODE;
2204: fnd_message.set_name('XNP','STD_ERROR');
2205: fnd_message.set_token('ERROR_LOCN'
2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2207: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2208: x_error_message := fnd_message.get;
2201:
2202: WHEN OTHERS THEN
2203: x_ERROR_CODE := SQLCODE;
2204: fnd_message.set_name('XNP','STD_ERROR');
2205: fnd_message.set_token('ERROR_LOCN'
2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2207: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2208: x_error_message := fnd_message.get;
2209:
2203: x_ERROR_CODE := SQLCODE;
2204: fnd_message.set_name('XNP','STD_ERROR');
2205: fnd_message.set_token('ERROR_LOCN'
2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2207: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2208: x_error_message := fnd_message.get;
2209:
2210: IF c_CHECK_STATUS%ISOPEN THEN
2211: CLOSE c_CHECK_STATUS;
2204: fnd_message.set_name('XNP','STD_ERROR');
2205: fnd_message.set_token('ERROR_LOCN'
2206: ,'XNP_CORE.SOA_CHECK_NOTIFY_DIR_SVS');
2207: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2208: x_error_message := fnd_message.get;
2209:
2210: IF c_CHECK_STATUS%ISOPEN THEN
2211: CLOSE c_CHECK_STATUS;
2212: END IF;
2248:
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: x_ERROR_CODE := SQLCODE;
2252: fnd_message.set_name('XNP','STD_ERROR');
2253: fnd_message.set_token('ERROR_LOCN'
2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');
2255: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2256: x_error_message := fnd_message.get;
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: x_ERROR_CODE := SQLCODE;
2252: fnd_message.set_name('XNP','STD_ERROR');
2253: fnd_message.set_token('ERROR_LOCN'
2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');
2255: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2256: x_error_message := fnd_message.get;
2257:
2251: x_ERROR_CODE := SQLCODE;
2252: fnd_message.set_name('XNP','STD_ERROR');
2253: fnd_message.set_token('ERROR_LOCN'
2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');
2255: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2256: x_error_message := fnd_message.get;
2257:
2258: END SOA_CHECK_IF_INITIAL_DONOR;
2259:
2252: fnd_message.set_name('XNP','STD_ERROR');
2253: fnd_message.set_token('ERROR_LOCN'
2254: ,'XNP_CORE.SOA_CHECK_IF_INITIAL_DONOR');
2255: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2256: x_error_message := fnd_message.get;
2257:
2258: END SOA_CHECK_IF_INITIAL_DONOR;
2259:
2260: PROCEDURE SOA_UPDATE_CHARGING_INFO
2362: WHEN dup_val_on_index THEN
2363: null;
2364: WHEN OTHERS THEN
2365: x_ERROR_CODE := SQLCODE;
2366: fnd_message.set_name('XNP','STD_ERROR');
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2363: null;
2364: WHEN OTHERS THEN
2365: x_ERROR_CODE := SQLCODE;
2366: fnd_message.set_name('XNP','STD_ERROR');
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2364: WHEN OTHERS THEN
2365: x_ERROR_CODE := SQLCODE;
2366: fnd_message.set_name('XNP','STD_ERROR');
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2372: fnd_message.set_token('ERROR_TEXT',x_error_message);
2365: x_ERROR_CODE := SQLCODE;
2366: fnd_message.set_name('XNP','STD_ERROR');
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2372: fnd_message.set_token('ERROR_TEXT',x_error_message);
2373: x_error_message := fnd_message.get;
2367: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2372: fnd_message.set_token('ERROR_TEXT',x_error_message);
2373: x_error_message := fnd_message.get;
2374:
2375: END SOA_UPDATE_CHARGING_INFO;
2368: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2372: fnd_message.set_token('ERROR_TEXT',x_error_message);
2373: x_error_message := fnd_message.get;
2374:
2375: END SOA_UPDATE_CHARGING_INFO;
2376:
2369: x_error_message := fnd_message.get;
2370:
2371: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
2372: fnd_message.set_token('ERROR_TEXT',x_error_message);
2373: x_error_message := fnd_message.get;
2374:
2375: END SOA_UPDATE_CHARGING_INFO;
2376:
2377: PROCEDURE SMS_INSERT_FE_MAP
2488:
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: x_ERROR_CODE := SQLCODE;
2492: fnd_message.set_name('XNP','STD_ERROR');
2493: fnd_message.set_token('ERROR_LOCN'
2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');
2495: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2496: x_error_message := fnd_message.get;
2489: EXCEPTION
2490: WHEN OTHERS THEN
2491: x_ERROR_CODE := SQLCODE;
2492: fnd_message.set_name('XNP','STD_ERROR');
2493: fnd_message.set_token('ERROR_LOCN'
2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');
2495: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2496: x_error_message := fnd_message.get;
2497:
2491: x_ERROR_CODE := SQLCODE;
2492: fnd_message.set_name('XNP','STD_ERROR');
2493: fnd_message.set_token('ERROR_LOCN'
2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');
2495: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2496: x_error_message := fnd_message.get;
2497:
2498: IF c_CHECK_IF_MAP_EXISTS%ISOPEN THEN
2499: CLOSE c_CHECK_IF_MAP_EXISTS;
2492: fnd_message.set_name('XNP','STD_ERROR');
2493: fnd_message.set_token('ERROR_LOCN'
2494: ,'XNP_CORE.SMS_INSERT_FE_MAP');
2495: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2496: x_error_message := fnd_message.get;
2497:
2498: IF c_CHECK_IF_MAP_EXISTS%ISOPEN THEN
2499: CLOSE c_CHECK_IF_MAP_EXISTS;
2500: END IF;
2605: WHEN dup_val_on_index THEN
2606: null;
2607: WHEN NO_DATA_FOUND THEN
2608: x_ERROR_CODE := SQLCODE;
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2606: null;
2607: WHEN NO_DATA_FOUND THEN
2608: x_ERROR_CODE := SQLCODE;
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2607: WHEN NO_DATA_FOUND THEN
2608: x_ERROR_CODE := SQLCODE;
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2608: x_ERROR_CODE := SQLCODE;
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2609: fnd_message.set_name('XNP','STD_GET_FAILED');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2617: fnd_message.set_name('XNP','UPD_SV_STATUS_ERR');
2610: fnd_message.set_token ('FAILED_PROC','XNP_CORE.SOA_UPDATE_SV_STATUS');
2611: fnd_message.set_token('KEY','OBJECT_REFERENCE');
2612: fnd_message.set_token('VALUE',p_PORTING_ID);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2617: fnd_message.set_name('XNP','UPD_SV_STATUS_ERR');
2618: fnd_message.set_token('ERROR_TEXT',x_error_message);
2613: fnd_message.set_token('ATTRNAME','STATUS_TYPE_CODE');
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2617: fnd_message.set_name('XNP','UPD_SV_STATUS_ERR');
2618: fnd_message.set_token('ERROR_TEXT',x_error_message);
2619: x_error_message := fnd_message.get;
2620:
2621: RETURN;
2614: x_error_message := fnd_message.get;
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2617: fnd_message.set_name('XNP','UPD_SV_STATUS_ERR');
2618: fnd_message.set_token('ERROR_TEXT',x_error_message);
2619: x_error_message := fnd_message.get;
2620:
2621: RETURN;
2622:
2615: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
2616:
2617: fnd_message.set_name('XNP','UPD_SV_STATUS_ERR');
2618: fnd_message.set_token('ERROR_TEXT',x_error_message);
2619: x_error_message := fnd_message.get;
2620:
2621: RETURN;
2622:
2623: WHEN OTHERS THEN
2621: RETURN;
2622:
2623: WHEN OTHERS THEN
2624: x_ERROR_CODE := SQLCODE;
2625: fnd_message.set_name('XNP','STD_ERROR');
2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
2627: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2628: x_error_message := fnd_message.get;
2629:
2622:
2623: WHEN OTHERS THEN
2624: x_ERROR_CODE := SQLCODE;
2625: fnd_message.set_name('XNP','STD_ERROR');
2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
2627: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2628: x_error_message := fnd_message.get;
2629:
2630: END SOA_UPDATE_SV_STATUS;
2623: WHEN OTHERS THEN
2624: x_ERROR_CODE := SQLCODE;
2625: fnd_message.set_name('XNP','STD_ERROR');
2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
2627: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2628: x_error_message := fnd_message.get;
2629:
2630: END SOA_UPDATE_SV_STATUS;
2631:
2624: x_ERROR_CODE := SQLCODE;
2625: fnd_message.set_name('XNP','STD_ERROR');
2626: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_SV_STATUS');
2627: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2628: x_error_message := fnd_message.get;
2629:
2630: END SOA_UPDATE_SV_STATUS;
2631:
2632: PROCEDURE CHECK_SOA_STATUS_EXISTS
2668:
2669: EXCEPTION
2670: WHEN OTHERS THEN
2671: x_ERROR_CODE := SQLCODE;
2672: fnd_message.set_name('XNP','STD_ERROR');
2673: fnd_message.set_token('ERROR_LOCN'
2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
2675: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2676: x_error_message := fnd_message.get;
2669: EXCEPTION
2670: WHEN OTHERS THEN
2671: x_ERROR_CODE := SQLCODE;
2672: fnd_message.set_name('XNP','STD_ERROR');
2673: fnd_message.set_token('ERROR_LOCN'
2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
2675: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2676: x_error_message := fnd_message.get;
2677: IF c_SOA_SV_ID%ISOPEN THEN
2671: x_ERROR_CODE := SQLCODE;
2672: fnd_message.set_name('XNP','STD_ERROR');
2673: fnd_message.set_token('ERROR_LOCN'
2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
2675: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2676: x_error_message := fnd_message.get;
2677: IF c_SOA_SV_ID%ISOPEN THEN
2678: CLOSE c_SOA_SV_ID;
2679: END IF;
2672: fnd_message.set_name('XNP','STD_ERROR');
2673: fnd_message.set_token('ERROR_LOCN'
2674: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
2675: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2676: x_error_message := fnd_message.get;
2677: IF c_SOA_SV_ID%ISOPEN THEN
2678: CLOSE c_SOA_SV_ID;
2679: END IF;
2680:
2713:
2714: EXCEPTION
2715: WHEN OTHERS THEN
2716: x_ERROR_CODE := SQLCODE;
2717: fnd_message.set_name('XNP','STD_ERROR');
2718: fnd_message.set_token('ERROR_LOCN'
2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');
2720: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2721: x_error_message := fnd_message.get;
2714: EXCEPTION
2715: WHEN OTHERS THEN
2716: x_ERROR_CODE := SQLCODE;
2717: fnd_message.set_name('XNP','STD_ERROR');
2718: fnd_message.set_token('ERROR_LOCN'
2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');
2720: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2721: x_error_message := fnd_message.get;
2722:
2716: x_ERROR_CODE := SQLCODE;
2717: fnd_message.set_name('XNP','STD_ERROR');
2718: fnd_message.set_token('ERROR_LOCN'
2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');
2720: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2721: x_error_message := fnd_message.get;
2722:
2723:
2724: END SMS_DELETE_FE_MAP;
2717: fnd_message.set_name('XNP','STD_ERROR');
2718: fnd_message.set_token('ERROR_LOCN'
2719: ,'XNP_CORE.SMS_DELETE_FE_MAP');
2720: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2721: x_error_message := fnd_message.get;
2722:
2723:
2724: END SMS_DELETE_FE_MAP;
2725:
2768:
2769: EXCEPTION
2770: WHEN OTHERS THEN
2771: x_ERROR_CODE := SQLCODE;
2772: fnd_message.set_name('XNP','STD_ERROR');
2773: fnd_message.set_token('ERROR_LOCN'
2774: ,'XNP_CORE.CHECK_DONOR_PHASE');
2775: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2776: x_error_message := fnd_message.get;
2769: EXCEPTION
2770: WHEN OTHERS THEN
2771: x_ERROR_CODE := SQLCODE;
2772: fnd_message.set_name('XNP','STD_ERROR');
2773: fnd_message.set_token('ERROR_LOCN'
2774: ,'XNP_CORE.CHECK_DONOR_PHASE');
2775: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2776: x_error_message := fnd_message.get;
2777:
2771: x_ERROR_CODE := SQLCODE;
2772: fnd_message.set_name('XNP','STD_ERROR');
2773: fnd_message.set_token('ERROR_LOCN'
2774: ,'XNP_CORE.CHECK_DONOR_PHASE');
2775: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2776: x_error_message := fnd_message.get;
2777:
2778: IF c_SOA_SV_ID%ISOPEN THEN
2779: CLOSE c_SOA_SV_ID;
2772: fnd_message.set_name('XNP','STD_ERROR');
2773: fnd_message.set_token('ERROR_LOCN'
2774: ,'XNP_CORE.CHECK_DONOR_PHASE');
2775: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2776: x_error_message := fnd_message.get;
2777:
2778: IF c_SOA_SV_ID%ISOPEN THEN
2779: CLOSE c_SOA_SV_ID;
2780: END IF;
2826:
2827: EXCEPTION
2828: WHEN OTHERS THEN
2829: x_ERROR_CODE := SQLCODE;
2830: fnd_message.set_name('XNP','STD_ERROR');
2831: fnd_message.set_token('ERROR_LOCN'
2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');
2833: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2834: x_error_message := fnd_message.get;
2827: EXCEPTION
2828: WHEN OTHERS THEN
2829: x_ERROR_CODE := SQLCODE;
2830: fnd_message.set_name('XNP','STD_ERROR');
2831: fnd_message.set_token('ERROR_LOCN'
2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');
2833: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2834: x_error_message := fnd_message.get;
2835:
2829: x_ERROR_CODE := SQLCODE;
2830: fnd_message.set_name('XNP','STD_ERROR');
2831: fnd_message.set_token('ERROR_LOCN'
2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');
2833: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2834: x_error_message := fnd_message.get;
2835:
2836: IF c_SOA_SV_ID%ISOPEN THEN
2837: CLOSE c_SOA_SV_ID;
2830: fnd_message.set_name('XNP','STD_ERROR');
2831: fnd_message.set_token('ERROR_LOCN'
2832: ,'XNP_CORE.CHECK_RECIPIENT_PHASE');
2833: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2834: x_error_message := fnd_message.get;
2835:
2836: IF c_SOA_SV_ID%ISOPEN THEN
2837: CLOSE c_SOA_SV_ID;
2838: END IF;
2966: WHEN DUP_VAL_ON_INDEX THEN
2967: null;
2968: WHEN OTHERS THEN
2969: x_ERROR_CODE := SQLCODE;
2970: fnd_message.set_name('XNP','STD_ERROR');
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2967: null;
2968: WHEN OTHERS THEN
2969: x_ERROR_CODE := SQLCODE;
2970: fnd_message.set_name('XNP','STD_ERROR');
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2968: WHEN OTHERS THEN
2969: x_ERROR_CODE := SQLCODE;
2970: fnd_message.set_name('XNP','STD_ERROR');
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2976: fnd_message.set_token('ERROR_TEXT',x_error_message);
2969: x_ERROR_CODE := SQLCODE;
2970: fnd_message.set_name('XNP','STD_ERROR');
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2976: fnd_message.set_token('ERROR_TEXT',x_error_message);
2977: x_error_message := fnd_message.get;
2971: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_RESET_SV_STATUS');
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2976: fnd_message.set_token('ERROR_TEXT',x_error_message);
2977: x_error_message := fnd_message.get;
2978:
2979:
2972: fnd_message.set_token('ERROR_TEXT',SQLERRM);
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2976: fnd_message.set_token('ERROR_TEXT',x_error_message);
2977: x_error_message := fnd_message.get;
2978:
2979:
2980: END SOA_RESET_SV_STATUS;
2973: x_error_message := fnd_message.get;
2974:
2975: fnd_message.set_name('XNP','RESET_SV_STATUS');
2976: fnd_message.set_token('ERROR_TEXT',x_error_message);
2977: x_error_message := fnd_message.get;
2978:
2979:
2980: END SOA_RESET_SV_STATUS;
2981:
3080: null;
3081:
3082: WHEN OTHERS THEN
3083: x_ERROR_CODE := SQLCODE;
3084: fnd_message.set_name('XNP','STD_ERROR');
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3081:
3082: WHEN OTHERS THEN
3083: x_ERROR_CODE := SQLCODE;
3084: fnd_message.set_name('XNP','STD_ERROR');
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3082: WHEN OTHERS THEN
3083: x_ERROR_CODE := SQLCODE;
3084: fnd_message.set_name('XNP','STD_ERROR');
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3090: fnd_message.set_token('ERROR_TEXT',x_error_message);
3083: x_ERROR_CODE := SQLCODE;
3084: fnd_message.set_name('XNP','STD_ERROR');
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3090: fnd_message.set_token('ERROR_TEXT',x_error_message);
3091: x_error_message := fnd_message.get;
3085: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3090: fnd_message.set_token('ERROR_TEXT',x_error_message);
3091: x_error_message := fnd_message.get;
3092:
3093:
3086: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3090: fnd_message.set_token('ERROR_TEXT',x_error_message);
3091: x_error_message := fnd_message.get;
3092:
3093:
3094: END SOA_UPDATE_OLD_SP_DUE_DATE;
3087: x_error_message := fnd_message.get;
3088:
3089: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
3090: fnd_message.set_token('ERROR_TEXT',x_error_message);
3091: x_error_message := fnd_message.get;
3092:
3093:
3094: END SOA_UPDATE_OLD_SP_DUE_DATE;
3095:
3148: EXCEPTION
3149: WHEN OTHERS THEN
3150: x_ERROR_CODE := SQLCODE;
3151: x_ERROR_MESSAGE := SQLERRM;
3152: fnd_message.set_name('XNP','STD_ERROR');
3153: fnd_message.set_token('ERROR_LOCN'
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3149: WHEN OTHERS THEN
3150: x_ERROR_CODE := SQLCODE;
3151: x_ERROR_MESSAGE := SQLERRM;
3152: fnd_message.set_name('XNP','STD_ERROR');
3153: fnd_message.set_token('ERROR_LOCN'
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3151: x_ERROR_MESSAGE := SQLERRM;
3152: fnd_message.set_name('XNP','STD_ERROR');
3153: fnd_message.set_token('ERROR_LOCN'
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3152: fnd_message.set_name('XNP','STD_ERROR');
3153: fnd_message.set_token('ERROR_LOCN'
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3160: x_error_message := fnd_message.get;
3154: ,'XNP_CORE.SMS_DELETE_PORTED_NUMBER');
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3160: x_error_message := fnd_message.get;
3161:
3162:
3155: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3160: x_error_message := fnd_message.get;
3161:
3162:
3163: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3156: x_error_message := fnd_message.get;
3157:
3158: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3160: x_error_message := fnd_message.get;
3161:
3162:
3163: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3164: fnd_message.set_token('ERROR_TEXT',x_error_message);
3159: fnd_message.set_token('ERROR_TEXT',x_error_message);
3160: x_error_message := fnd_message.get;
3161:
3162:
3163: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3164: fnd_message.set_token('ERROR_TEXT',x_error_message);
3165: x_error_message := fnd_message.get;
3166:
3167: IF c_sv_map_id%ISOPEN THEN
3160: x_error_message := fnd_message.get;
3161:
3162:
3163: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3164: fnd_message.set_token('ERROR_TEXT',x_error_message);
3165: x_error_message := fnd_message.get;
3166:
3167: IF c_sv_map_id%ISOPEN THEN
3168: CLOSE c_sv_map_id;
3161:
3162:
3163: fnd_message.set_name('XNP','DEL_PORTED_NUM_ERR');
3164: fnd_message.set_token('ERROR_TEXT',x_error_message);
3165: x_error_message := fnd_message.get;
3166:
3167: IF c_sv_map_id%ISOPEN THEN
3168: CLOSE c_sv_map_id;
3169: END IF;
3241: WHEN dup_val_on_index THEN
3242: null;
3243: WHEN OTHERS THEN
3244: x_ERROR_CODE := SQLCODE;
3245: fnd_message.set_name('XNP','STD_ERROR');
3246: fnd_message.set_token('ERROR_LOCN'
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3242: null;
3243: WHEN OTHERS THEN
3244: x_ERROR_CODE := SQLCODE;
3245: fnd_message.set_name('XNP','STD_ERROR');
3246: fnd_message.set_token('ERROR_LOCN'
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3244: x_ERROR_CODE := SQLCODE;
3245: fnd_message.set_name('XNP','STD_ERROR');
3246: fnd_message.set_token('ERROR_LOCN'
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');
3252: fnd_message.set_token('ERROR_TEXT',x_error_message);
3245: fnd_message.set_name('XNP','STD_ERROR');
3246: fnd_message.set_token('ERROR_LOCN'
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');
3252: fnd_message.set_token('ERROR_TEXT',x_error_message);
3253: x_error_message := fnd_message.get;
3247: ,'XNP_CORE.SMS_UPDATE_FE_MAP_STATUS');
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');
3252: fnd_message.set_token('ERROR_TEXT',x_error_message);
3253: x_error_message := fnd_message.get;
3254:
3255:
3248: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');
3252: fnd_message.set_token('ERROR_TEXT',x_error_message);
3253: x_error_message := fnd_message.get;
3254:
3255:
3256: END SMS_UPDATE_FE_MAP_STATUS;
3249: x_error_message := fnd_message.get;
3250:
3251: fnd_message.set_name('XNP','UPD_FE_MAP_STATUS_ERR');
3252: fnd_message.set_token('ERROR_TEXT',x_error_message);
3253: x_error_message := fnd_message.get;
3254:
3255:
3256: END SMS_UPDATE_FE_MAP_STATUS;
3257:
3389: WHEN dup_val_on_index THEN
3390: null;
3391: WHEN OTHERS THEN
3392: x_ERROR_CODE := SQLCODE;
3393: fnd_message.set_name('XNP','STD_ERROR');
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3390: null;
3391: WHEN OTHERS THEN
3392: x_ERROR_CODE := SQLCODE;
3393: fnd_message.set_name('XNP','STD_ERROR');
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3391: WHEN OTHERS THEN
3392: x_ERROR_CODE := SQLCODE;
3393: fnd_message.set_name('XNP','STD_ERROR');
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3399: fnd_message.set_token('ERROR_TEXT',x_error_message);
3392: x_ERROR_CODE := SQLCODE;
3393: fnd_message.set_name('XNP','STD_ERROR');
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3399: fnd_message.set_token('ERROR_TEXT',x_error_message);
3400: x_error_message := fnd_message.get;
3394: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_REC_PORT_ORDER');
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3399: fnd_message.set_token('ERROR_TEXT',x_error_message);
3400: x_error_message := fnd_message.get;
3401:
3402: END SOA_UPDATE_REC_PORT_ORDER;
3395: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3399: fnd_message.set_token('ERROR_TEXT',x_error_message);
3400: x_error_message := fnd_message.get;
3401:
3402: END SOA_UPDATE_REC_PORT_ORDER;
3403:
3396: x_error_message := fnd_message.get;
3397:
3398: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3399: fnd_message.set_token('ERROR_TEXT',x_error_message);
3400: x_error_message := fnd_message.get;
3401:
3402: END SOA_UPDATE_REC_PORT_ORDER;
3403:
3404: PROCEDURE SOA_UPDATE_DON_PORT_ORDER
3534: WHEN dup_val_on_index THEN
3535: null;
3536: WHEN OTHERS THEN
3537: x_ERROR_CODE := SQLCODE;
3538: fnd_message.set_name('XNP','STD_ERROR');
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3535: null;
3536: WHEN OTHERS THEN
3537: x_ERROR_CODE := SQLCODE;
3538: fnd_message.set_name('XNP','STD_ERROR');
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3536: WHEN OTHERS THEN
3537: x_ERROR_CODE := SQLCODE;
3538: fnd_message.set_name('XNP','STD_ERROR');
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3544: fnd_message.set_token('ERROR_TEXT',x_error_message);
3537: x_ERROR_CODE := SQLCODE;
3538: fnd_message.set_name('XNP','STD_ERROR');
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3544: fnd_message.set_token('ERROR_TEXT',x_error_message);
3545: x_error_message := fnd_message.get;
3539: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DON_PORT_ORDER');
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3544: fnd_message.set_token('ERROR_TEXT',x_error_message);
3545: x_error_message := fnd_message.get;
3546:
3547: END SOA_UPDATE_DON_PORT_ORDER;
3540: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3544: fnd_message.set_token('ERROR_TEXT',x_error_message);
3545: x_error_message := fnd_message.get;
3546:
3547: END SOA_UPDATE_DON_PORT_ORDER;
3548:
3541: x_error_message := fnd_message.get;
3542:
3543: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3544: fnd_message.set_token('ERROR_TEXT',x_error_message);
3545: x_error_message := fnd_message.get;
3546:
3547: END SOA_UPDATE_DON_PORT_ORDER;
3548:
3549: PROCEDURE SMS_MODIFY_PORTED_NUMBER
3636: WHEN dup_val_on_index THEN
3637: null;
3638: WHEN OTHERS THEN
3639: x_ERROR_CODE := SQLCODE;
3640: fnd_message.set_name('XNP','STD_ERROR');
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3637: null;
3638: WHEN OTHERS THEN
3639: x_ERROR_CODE := SQLCODE;
3640: fnd_message.set_name('XNP','STD_ERROR');
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3638: WHEN OTHERS THEN
3639: x_ERROR_CODE := SQLCODE;
3640: fnd_message.set_name('XNP','STD_ERROR');
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3646: fnd_message.set_token('ERROR_TEXT',x_error_message);
3639: x_ERROR_CODE := SQLCODE;
3640: fnd_message.set_name('XNP','STD_ERROR');
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3646: fnd_message.set_token('ERROR_TEXT',x_error_message);
3647: x_error_message := fnd_message.get;
3641: fnd_message.set_token('ERROR_LOCN' ,'XNP_CORE.SMS_MODIFY_PORTED_NUMBER');
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3646: fnd_message.set_token('ERROR_TEXT',x_error_message);
3647: x_error_message := fnd_message.get;
3648:
3649: END SMS_MODIFY_PORTED_NUMBER;
3642: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3646: fnd_message.set_token('ERROR_TEXT',x_error_message);
3647: x_error_message := fnd_message.get;
3648:
3649: END SMS_MODIFY_PORTED_NUMBER;
3650:
3643: x_error_message := fnd_message.get;
3644:
3645: fnd_message.set_name('XNP','UPD_PORT_ORDER_ERR');
3646: fnd_message.set_token('ERROR_TEXT',x_error_message);
3647: x_error_message := fnd_message.get;
3648:
3649: END SMS_MODIFY_PORTED_NUMBER;
3650:
3651: PROCEDURE CHECK_IF_PORTABLE_RANGE
3687:
3688: EXCEPTION
3689: WHEN NO_DATA_FOUND THEN
3690: x_ERROR_CODE := SQLCODE;
3691: fnd_message.set_name('XNP','STD_GET_FAILED');
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3688: EXCEPTION
3689: WHEN NO_DATA_FOUND THEN
3690: x_ERROR_CODE := SQLCODE;
3691: fnd_message.set_name('XNP','STD_GET_FAILED');
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3696: fnd_message.set_token
3690: x_ERROR_CODE := SQLCODE;
3691: fnd_message.set_name('XNP','STD_GET_FAILED');
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3696: fnd_message.set_token
3697: ('VALUE'
3698: ,p_STARTING_NUMBER||':'||p_ENDING_NUMBER
3691: fnd_message.set_name('XNP','STD_GET_FAILED');
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3696: fnd_message.set_token
3697: ('VALUE'
3698: ,p_STARTING_NUMBER||':'||p_ENDING_NUMBER
3699: );
3692: fnd_message.set_token
3693: ('FAILED_PROC','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3694: fnd_message.set_token('ATTRNAME','PORTED_INDICATOR');
3695: fnd_message.set_token('KEY','STARTING_NUMBER:ENDING_NUMBER');
3696: fnd_message.set_token
3697: ('VALUE'
3698: ,p_STARTING_NUMBER||':'||p_ENDING_NUMBER
3699: );
3700: x_error_message :=
3697: ('VALUE'
3698: ,p_STARTING_NUMBER||':'||p_ENDING_NUMBER
3699: );
3700: x_error_message :=
3701: fnd_message.get;
3702: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
3703:
3704: fnd_message.set_name('XNP','CHECK_IF_PORTABLE_ERR');
3705: fnd_message.set_token('ERROR_TEXT',x_error_message);
3700: x_error_message :=
3701: fnd_message.get;
3702: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
3703:
3704: fnd_message.set_name('XNP','CHECK_IF_PORTABLE_ERR');
3705: fnd_message.set_token('ERROR_TEXT',x_error_message);
3706: x_error_message := fnd_message.get;
3707:
3708: IF c_PORTED_INDICATOR%ISOPEN THEN
3701: fnd_message.get;
3702: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
3703:
3704: fnd_message.set_name('XNP','CHECK_IF_PORTABLE_ERR');
3705: fnd_message.set_token('ERROR_TEXT',x_error_message);
3706: x_error_message := fnd_message.get;
3707:
3708: IF c_PORTED_INDICATOR%ISOPEN THEN
3709: CLOSE c_PORTED_INDICATOR;
3702: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
3703:
3704: fnd_message.set_name('XNP','CHECK_IF_PORTABLE_ERR');
3705: fnd_message.set_token('ERROR_TEXT',x_error_message);
3706: x_error_message := fnd_message.get;
3707:
3708: IF c_PORTED_INDICATOR%ISOPEN THEN
3709: CLOSE c_PORTED_INDICATOR;
3710: END IF;
3710: END IF;
3711:
3712: WHEN OTHERS THEN
3713: x_ERROR_CODE := SQLCODE;
3714: fnd_message.set_name('XNP','STD_ERROR');
3715: fnd_message.set_token
3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3717: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3718: x_error_message := fnd_message.get;
3711:
3712: WHEN OTHERS THEN
3713: x_ERROR_CODE := SQLCODE;
3714: fnd_message.set_name('XNP','STD_ERROR');
3715: fnd_message.set_token
3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3717: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3718: x_error_message := fnd_message.get;
3719: IF c_PORTED_INDICATOR%ISOPEN THEN
3713: x_ERROR_CODE := SQLCODE;
3714: fnd_message.set_name('XNP','STD_ERROR');
3715: fnd_message.set_token
3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3717: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3718: x_error_message := fnd_message.get;
3719: IF c_PORTED_INDICATOR%ISOPEN THEN
3720: CLOSE c_PORTED_INDICATOR;
3721: END IF;
3714: fnd_message.set_name('XNP','STD_ERROR');
3715: fnd_message.set_token
3716: ('ERROR_LOCN','XNP_CORE.CHECK_IF_PORTED_NUMBER_RANGE');
3717: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3718: x_error_message := fnd_message.get;
3719: IF c_PORTED_INDICATOR%ISOPEN THEN
3720: CLOSE c_PORTED_INDICATOR;
3721: END IF;
3722:
3793: null;
3794:
3795: WHEN e_SOA_UPDATE_OLD_SP_DUE_DATE THEN
3796: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
3797: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
3798: fnd_message.set_token('PORTING_ID',p_porting_id);
3799:
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3794:
3795: WHEN e_SOA_UPDATE_OLD_SP_DUE_DATE THEN
3796: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
3797: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
3798: fnd_message.set_token('PORTING_ID',p_porting_id);
3799:
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3798: fnd_message.set_token('PORTING_ID',p_porting_id);
3799:
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3804: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3805: x_error_message := fnd_message.get;
3806:
3799:
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3804: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3805: x_error_message := fnd_message.get;
3806:
3807: END SOA_UPDATE_OLD_SP_DUE_DATE;
3800: WHEN OTHERS THEN
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3804: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3805: x_error_message := fnd_message.get;
3806:
3807: END SOA_UPDATE_OLD_SP_DUE_DATE;
3808:
3801: x_ERROR_CODE := SQLCODE;
3802: fnd_message.set_name('XNP','STD_ERROR');
3803: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_DUE_DATE');
3804: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3805: x_error_message := fnd_message.get;
3806:
3807: END SOA_UPDATE_OLD_SP_DUE_DATE;
3808:
3809: PROCEDURE SOA_UPDATE_NEW_SP_DUE_DATE
3875: WHEN dup_val_on_index THEN
3876: null;
3877: WHEN e_SOA_UPDATE_NEW_SP_DUE_DATE THEN
3878: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
3879: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
3880: fnd_message.set_token('PORTING_ID',p_porting_id);
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3876: null;
3877: WHEN e_SOA_UPDATE_NEW_SP_DUE_DATE THEN
3878: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
3879: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
3880: fnd_message.set_token('PORTING_ID',p_porting_id);
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3879: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
3880: fnd_message.set_token('PORTING_ID',p_porting_id);
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3885: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3886: x_error_message := fnd_message.get;
3887:
3880: fnd_message.set_token('PORTING_ID',p_porting_id);
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3885: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3886: x_error_message := fnd_message.get;
3887:
3888: END SOA_UPDATE_NEW_SP_DUE_DATE;
3881: WHEN OTHERS THEN
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3885: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3886: x_error_message := fnd_message.get;
3887:
3888: END SOA_UPDATE_NEW_SP_DUE_DATE;
3889:
3882: x_ERROR_CODE := SQLCODE;
3883: fnd_message.set_name('XNP','STD_ERROR');
3884: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_DUE_DATE');
3885: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3886: x_error_message := fnd_message.get;
3887:
3888: END SOA_UPDATE_NEW_SP_DUE_DATE;
3889:
3890:
3928:
3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: x_ERROR_CODE := SQLCODE;
3932: fnd_message.set_name('XNP','STD_ERROR');
3933: fnd_message.set_token('ERROR_LOCN'
3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');
3935: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3936: x_error_message := fnd_message.get;
3929: EXCEPTION
3930: WHEN OTHERS THEN
3931: x_ERROR_CODE := SQLCODE;
3932: fnd_message.set_name('XNP','STD_ERROR');
3933: fnd_message.set_token('ERROR_LOCN'
3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');
3935: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3936: x_error_message := fnd_message.get;
3937: IF c_SOA_SV_ID%ISOPEN THEN
3931: x_ERROR_CODE := SQLCODE;
3932: fnd_message.set_name('XNP','STD_ERROR');
3933: fnd_message.set_token('ERROR_LOCN'
3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');
3935: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3936: x_error_message := fnd_message.get;
3937: IF c_SOA_SV_ID%ISOPEN THEN
3938: CLOSE c_SOA_SV_ID;
3939: END IF;
3932: fnd_message.set_name('XNP','STD_ERROR');
3933: fnd_message.set_token('ERROR_LOCN'
3934: ,'XNP_CORE.CHECK_DONOR_STATUS_EXISTS');
3935: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3936: x_error_message := fnd_message.get;
3937: IF c_SOA_SV_ID%ISOPEN THEN
3938: CLOSE c_SOA_SV_ID;
3939: END IF;
3940:
3982:
3983: EXCEPTION
3984: WHEN OTHERS THEN
3985: x_ERROR_CODE := SQLCODE;
3986: fnd_message.set_name('XNP','STD_ERROR');
3987: fnd_message.set_token('ERROR_LOCN'
3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');
3989: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3990: x_error_message := fnd_message.get;
3983: EXCEPTION
3984: WHEN OTHERS THEN
3985: x_ERROR_CODE := SQLCODE;
3986: fnd_message.set_name('XNP','STD_ERROR');
3987: fnd_message.set_token('ERROR_LOCN'
3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');
3989: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3990: x_error_message := fnd_message.get;
3991: IF c_SOA_SV_ID%ISOPEN THEN
3985: x_ERROR_CODE := SQLCODE;
3986: fnd_message.set_name('XNP','STD_ERROR');
3987: fnd_message.set_token('ERROR_LOCN'
3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');
3989: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3990: x_error_message := fnd_message.get;
3991: IF c_SOA_SV_ID%ISOPEN THEN
3992: CLOSE c_SOA_SV_ID;
3993: END IF;
3986: fnd_message.set_name('XNP','STD_ERROR');
3987: fnd_message.set_token('ERROR_LOCN'
3988: ,'XNP_CORE.CHECK_RECIPIENT_STATUS_EXISTS');
3989: fnd_message.set_token('ERROR_TEXT',SQLERRM);
3990: x_error_message := fnd_message.get;
3991: IF c_SOA_SV_ID%ISOPEN THEN
3992: CLOSE c_SOA_SV_ID;
3993: END IF;
3994:
4060: WHEN dup_val_on_index THEN
4061: null;
4062: WHEN OTHERS THEN
4063: x_ERROR_CODE := SQLCODE;
4064: fnd_message.set_name('XNP','STD_ERROR');
4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
4066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4067: x_error_message := fnd_message.get;
4068:
4061: null;
4062: WHEN OTHERS THEN
4063: x_ERROR_CODE := SQLCODE;
4064: fnd_message.set_name('XNP','STD_ERROR');
4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
4066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4067: x_error_message := fnd_message.get;
4068:
4069: END SOA_UPDATE_CUTOFF_DATE;
4062: WHEN OTHERS THEN
4063: x_ERROR_CODE := SQLCODE;
4064: fnd_message.set_name('XNP','STD_ERROR');
4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
4066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4067: x_error_message := fnd_message.get;
4068:
4069: END SOA_UPDATE_CUTOFF_DATE;
4070:
4063: x_ERROR_CODE := SQLCODE;
4064: fnd_message.set_name('XNP','STD_ERROR');
4065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CUTOFF_DATE');
4066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4067: x_error_message := fnd_message.get;
4068:
4069: END SOA_UPDATE_CUTOFF_DATE;
4070:
4071: PROCEDURE SOA_UPDATE_CHARGING_INFO
4146: WHEN dup_val_on_index THEN
4147: null;
4148: WHEN OTHERS THEN
4149: x_ERROR_CODE := SQLCODE;
4150: fnd_message.set_name('XNP','STD_ERROR');
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4147: null;
4148: WHEN OTHERS THEN
4149: x_ERROR_CODE := SQLCODE;
4150: fnd_message.set_name('XNP','STD_ERROR');
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4148: WHEN OTHERS THEN
4149: x_ERROR_CODE := SQLCODE;
4150: fnd_message.set_name('XNP','STD_ERROR');
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4156: fnd_message.set_token('ERROR_TEXT',x_error_message);
4149: x_ERROR_CODE := SQLCODE;
4150: fnd_message.set_name('XNP','STD_ERROR');
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4156: fnd_message.set_token('ERROR_TEXT',x_error_message);
4157: x_error_message := fnd_message.get;
4151: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_CHARGING_INFO');
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4156: fnd_message.set_token('ERROR_TEXT',x_error_message);
4157: x_error_message := fnd_message.get;
4158:
4159: END SOA_UPDATE_CHARGING_INFO;
4152: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4156: fnd_message.set_token('ERROR_TEXT',x_error_message);
4157: x_error_message := fnd_message.get;
4158:
4159: END SOA_UPDATE_CHARGING_INFO;
4160:
4153: x_error_message := fnd_message.get;
4154:
4155: fnd_message.set_name('XNP','UPD_CHARGING_INFO_ERR');
4156: fnd_message.set_token('ERROR_TEXT',x_error_message);
4157: x_error_message := fnd_message.get;
4158:
4159: END SOA_UPDATE_CHARGING_INFO;
4160:
4161: PROCEDURE CHECK_SOA_STATUS_EXISTS
4196:
4197: EXCEPTION
4198: WHEN OTHERS THEN
4199: x_ERROR_CODE := SQLCODE;
4200: fnd_message.set_name('XNP','STD_ERROR');
4201: fnd_message.set_token('ERROR_LOCN'
4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
4203: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4204: x_error_message := fnd_message.get;
4197: EXCEPTION
4198: WHEN OTHERS THEN
4199: x_ERROR_CODE := SQLCODE;
4200: fnd_message.set_name('XNP','STD_ERROR');
4201: fnd_message.set_token('ERROR_LOCN'
4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
4203: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4204: x_error_message := fnd_message.get;
4205: IF c_SOA_SV_ID%ISOPEN THEN
4199: x_ERROR_CODE := SQLCODE;
4200: fnd_message.set_name('XNP','STD_ERROR');
4201: fnd_message.set_token('ERROR_LOCN'
4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
4203: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4204: x_error_message := fnd_message.get;
4205: IF c_SOA_SV_ID%ISOPEN THEN
4206: CLOSE c_SOA_SV_ID;
4207: END IF;
4200: fnd_message.set_name('XNP','STD_ERROR');
4201: fnd_message.set_token('ERROR_LOCN'
4202: ,'XNP_CORE.CHECK_SOA_STATUS_EXISTS');
4203: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4204: x_error_message := fnd_message.get;
4205: IF c_SOA_SV_ID%ISOPEN THEN
4206: CLOSE c_SOA_SV_ID;
4207: END IF;
4208: END CHECK_SOA_STATUS_EXISTS;
4272: WHEN dup_val_on_index THEN
4273: null;
4274: WHEN OTHERS THEN
4275: x_ERROR_CODE := SQLCODE;
4276: fnd_message.set_name('XNP','STD_ERROR');
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4273: null;
4274: WHEN OTHERS THEN
4275: x_ERROR_CODE := SQLCODE;
4276: fnd_message.set_name('XNP','STD_ERROR');
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4274: WHEN OTHERS THEN
4275: x_ERROR_CODE := SQLCODE;
4276: fnd_message.set_name('XNP','STD_ERROR');
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4282: fnd_message.set_token('ERROR_TEXT',x_error_message);
4275: x_ERROR_CODE := SQLCODE;
4276: fnd_message.set_name('XNP','STD_ERROR');
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4282: fnd_message.set_token('ERROR_TEXT',x_error_message);
4283: x_error_message := fnd_message.get;
4277: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_OLD_SP_AUTH_FLAG');
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4282: fnd_message.set_token('ERROR_TEXT',x_error_message);
4283: x_error_message := fnd_message.get;
4284:
4285: END SOA_UPDATE_OLD_SP_AUTH_FLAG;
4278: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4282: fnd_message.set_token('ERROR_TEXT',x_error_message);
4283: x_error_message := fnd_message.get;
4284:
4285: END SOA_UPDATE_OLD_SP_AUTH_FLAG;
4286:
4279: x_error_message := fnd_message.get;
4280:
4281: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4282: fnd_message.set_token('ERROR_TEXT',x_error_message);
4283: x_error_message := fnd_message.get;
4284:
4285: END SOA_UPDATE_OLD_SP_AUTH_FLAG;
4286:
4287: PROCEDURE SOA_UPDATE_NEW_SP_AUTH_FLAG
4351: WHEN dup_val_on_index THEN
4352: null;
4353: WHEN OTHERS THEN
4354: x_ERROR_CODE := SQLCODE;
4355: fnd_message.set_name('XNP','STD_ERROR');
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4352: null;
4353: WHEN OTHERS THEN
4354: x_ERROR_CODE := SQLCODE;
4355: fnd_message.set_name('XNP','STD_ERROR');
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4353: WHEN OTHERS THEN
4354: x_ERROR_CODE := SQLCODE;
4355: fnd_message.set_name('XNP','STD_ERROR');
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4361: fnd_message.set_token('ERROR_TEXT',x_error_message);
4354: x_ERROR_CODE := SQLCODE;
4355: fnd_message.set_name('XNP','STD_ERROR');
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4361: fnd_message.set_token('ERROR_TEXT',x_error_message);
4362: x_error_message := fnd_message.get;
4356: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_NEW_SP_AUTH_FLAG');
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4361: fnd_message.set_token('ERROR_TEXT',x_error_message);
4362: x_error_message := fnd_message.get;
4363:
4364: END SOA_UPDATE_NEW_SP_AUTH_FLAG;
4357: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4361: fnd_message.set_token('ERROR_TEXT',x_error_message);
4362: x_error_message := fnd_message.get;
4363:
4364: END SOA_UPDATE_NEW_SP_AUTH_FLAG;
4365:
4358: x_error_message := fnd_message.get;
4359:
4360: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4361: fnd_message.set_token('ERROR_TEXT',x_error_message);
4362: x_error_message := fnd_message.get;
4363:
4364: END SOA_UPDATE_NEW_SP_AUTH_FLAG;
4365:
4366: PROCEDURE SMS_MARK_FES_TO_PROVISION
4429: WHEN dup_val_on_index THEN
4430: null;
4431: WHEN OTHERS THEN
4432: x_ERROR_CODE := SQLCODE;
4433: fnd_message.set_name('XNP','STD_ERROR');
4434: fnd_message.set_token('ERROR_LOCN'
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4430: null;
4431: WHEN OTHERS THEN
4432: x_ERROR_CODE := SQLCODE;
4433: fnd_message.set_name('XNP','STD_ERROR');
4434: fnd_message.set_token('ERROR_LOCN'
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4432: x_ERROR_CODE := SQLCODE;
4433: fnd_message.set_name('XNP','STD_ERROR');
4434: fnd_message.set_token('ERROR_LOCN'
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4440: fnd_message.set_token('ERROR_TEXT',x_error_message);
4433: fnd_message.set_name('XNP','STD_ERROR');
4434: fnd_message.set_token('ERROR_LOCN'
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4440: fnd_message.set_token('ERROR_TEXT',x_error_message);
4441: x_error_message := fnd_message.get;
4435: ,'XNP_CORE.SMS_MARK_FES_TO_PROVISION');
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4440: fnd_message.set_token('ERROR_TEXT',x_error_message);
4441: x_error_message := fnd_message.get;
4442:
4443: END SMS_MARK_FES_TO_PROVISION;
4436: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4440: fnd_message.set_token('ERROR_TEXT',x_error_message);
4441: x_error_message := fnd_message.get;
4442:
4443: END SMS_MARK_FES_TO_PROVISION;
4444:
4437: x_error_message := fnd_message.get;
4438:
4439: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4440: fnd_message.set_token('ERROR_TEXT',x_error_message);
4441: x_error_message := fnd_message.get;
4442:
4443: END SMS_MARK_FES_TO_PROVISION;
4444:
4445: PROCEDURE SMS_MARK_FES_TO_DEPROVISION
4514: WHEN dup_val_on_index THEN
4515: null;
4516: WHEN OTHERS THEN
4517: x_ERROR_CODE := SQLCODE;
4518: fnd_message.set_name('XNP','STD_ERROR');
4519: fnd_message.set_token('ERROR_LOCN'
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4515: null;
4516: WHEN OTHERS THEN
4517: x_ERROR_CODE := SQLCODE;
4518: fnd_message.set_name('XNP','STD_ERROR');
4519: fnd_message.set_token('ERROR_LOCN'
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4517: x_ERROR_CODE := SQLCODE;
4518: fnd_message.set_name('XNP','STD_ERROR');
4519: fnd_message.set_token('ERROR_LOCN'
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4525: fnd_message.set_token('ERROR_TEXT',x_error_message);
4518: fnd_message.set_name('XNP','STD_ERROR');
4519: fnd_message.set_token('ERROR_LOCN'
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4525: fnd_message.set_token('ERROR_TEXT',x_error_message);
4526: x_error_message := fnd_message.get;
4520: ,'XNP_CORE.SMS_MARK_FES_TO_DEPROVISION');
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4525: fnd_message.set_token('ERROR_TEXT',x_error_message);
4526: x_error_message := fnd_message.get;
4527:
4528: END SMS_MARK_FES_TO_DEPROVISION;
4521: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4525: fnd_message.set_token('ERROR_TEXT',x_error_message);
4526: x_error_message := fnd_message.get;
4527:
4528: END SMS_MARK_FES_TO_DEPROVISION;
4529:
4522: x_error_message := fnd_message.get;
4523:
4524: fnd_message.set_name('XNP','UPD_FOR_SV_ERR');
4525: fnd_message.set_token('ERROR_TEXT',x_error_message);
4526: x_error_message := fnd_message.get;
4527:
4528: END SMS_MARK_FES_TO_DEPROVISION;
4529:
4530: PROCEDURE SOA_SET_LOCKED_FLAG
4590: WHEN dup_val_on_index THEN
4591: null;
4592: WHEN NO_DATA_FOUND THEN
4593: x_error_code := SQLCODE;
4594: fnd_message.set_name('XNP','STD_ERROR');
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4591: null;
4592: WHEN NO_DATA_FOUND THEN
4593: x_error_code := SQLCODE;
4594: fnd_message.set_name('XNP','STD_ERROR');
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4592: WHEN NO_DATA_FOUND THEN
4593: x_error_code := SQLCODE;
4594: fnd_message.set_name('XNP','STD_ERROR');
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4593: x_error_code := SQLCODE;
4594: fnd_message.set_name('XNP','STD_ERROR');
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4601: fnd_message.set_token('PORTING_ID',p_porting_id);
4595: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4601: fnd_message.set_token('PORTING_ID',p_porting_id);
4602: x_error_message := fnd_message.get;
4603:
4596: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4601: fnd_message.set_token('PORTING_ID',p_porting_id);
4602: x_error_message := fnd_message.get;
4603:
4604: WHEN OTHERS THEN
4597: x_error_message := fnd_message.get;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4601: fnd_message.set_token('PORTING_ID',p_porting_id);
4602: x_error_message := fnd_message.get;
4603:
4604: WHEN OTHERS THEN
4605: x_error_code := SQLCODE;
4598:
4599: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4600: fnd_message.set_token('ERROR_TEXT',x_error_message);
4601: fnd_message.set_token('PORTING_ID',p_porting_id);
4602: x_error_message := fnd_message.get;
4603:
4604: WHEN OTHERS THEN
4605: x_error_code := SQLCODE;
4606:
4603:
4604: WHEN OTHERS THEN
4605: x_error_code := SQLCODE;
4606:
4607: fnd_message.set_name('XNP','STD_ERROR');
4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4609: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4610: x_error_message := fnd_message.get;
4611:
4604: WHEN OTHERS THEN
4605: x_error_code := SQLCODE;
4606:
4607: fnd_message.set_name('XNP','STD_ERROR');
4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4609: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4610: x_error_message := fnd_message.get;
4611:
4612:
4605: x_error_code := SQLCODE;
4606:
4607: fnd_message.set_name('XNP','STD_ERROR');
4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4609: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4610: x_error_message := fnd_message.get;
4611:
4612:
4613: END SOA_SET_LOCKED_FLAG;
4606:
4607: fnd_message.set_name('XNP','STD_ERROR');
4608: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_locked_flag');
4609: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4610: x_error_message := fnd_message.get;
4611:
4612:
4613: END SOA_SET_LOCKED_FLAG;
4614:
4644:
4645: EXCEPTION
4646: WHEN NO_DATA_FOUND THEN
4647: x_error_code := SQLCODE;
4648: fnd_message.set_name('XNP','STD_ERROR');
4649: fnd_message.set_token('ERROR_LOCN'
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4645: EXCEPTION
4646: WHEN NO_DATA_FOUND THEN
4647: x_error_code := SQLCODE;
4648: fnd_message.set_name('XNP','STD_ERROR');
4649: fnd_message.set_token('ERROR_LOCN'
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4647: x_error_code := SQLCODE;
4648: fnd_message.set_name('XNP','STD_ERROR');
4649: fnd_message.set_token('ERROR_LOCN'
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4648: fnd_message.set_name('XNP','STD_ERROR');
4649: fnd_message.set_token('ERROR_LOCN'
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4656: fnd_message.set_token('PORTING_ID',p_porting_id);
4650: ,'xnp_core.soa_get_locked_flag');
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4656: fnd_message.set_token('PORTING_ID',p_porting_id);
4657: x_error_message := fnd_message.get;
4658:
4651: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4656: fnd_message.set_token('PORTING_ID',p_porting_id);
4657: x_error_message := fnd_message.get;
4658:
4659: IF c_locked_flag%ISOPEN THEN
4652: x_error_message := fnd_message.get;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4656: fnd_message.set_token('PORTING_ID',p_porting_id);
4657: x_error_message := fnd_message.get;
4658:
4659: IF c_locked_flag%ISOPEN THEN
4660: CLOSE c_locked_flag;
4653:
4654: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4655: fnd_message.set_token('ERROR_TEXT',x_error_message);
4656: fnd_message.set_token('PORTING_ID',p_porting_id);
4657: x_error_message := fnd_message.get;
4658:
4659: IF c_locked_flag%ISOPEN THEN
4660: CLOSE c_locked_flag;
4661: END IF;
4662:
4663: WHEN OTHERS THEN
4664: x_error_code := SQLCODE;
4665:
4666: fnd_message.set_name('XNP','STD_ERROR');
4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');
4668: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4669: x_error_message := fnd_message.get;
4670:
4663: WHEN OTHERS THEN
4664: x_error_code := SQLCODE;
4665:
4666: fnd_message.set_name('XNP','STD_ERROR');
4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');
4668: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4669: x_error_message := fnd_message.get;
4670:
4671: IF c_locked_flag%ISOPEN THEN
4664: x_error_code := SQLCODE;
4665:
4666: fnd_message.set_name('XNP','STD_ERROR');
4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');
4668: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4669: x_error_message := fnd_message.get;
4670:
4671: IF c_locked_flag%ISOPEN THEN
4672: CLOSE c_locked_flag;
4665:
4666: fnd_message.set_name('XNP','STD_ERROR');
4667: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_locked_flag');
4668: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4669: x_error_message := fnd_message.get;
4670:
4671: IF c_locked_flag%ISOPEN THEN
4672: CLOSE c_locked_flag;
4673: END IF;
4706:
4707: WHEN NO_DATA_FOUND THEN
4708: x_error_code := SQLCODE;
4709: x_sv_status := NULL;
4710: fnd_message.set_name('XNP','STD_ERROR');
4711: fnd_message.set_token('ERROR_LOCN'
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4707: WHEN NO_DATA_FOUND THEN
4708: x_error_code := SQLCODE;
4709: x_sv_status := NULL;
4710: fnd_message.set_name('XNP','STD_ERROR');
4711: fnd_message.set_token('ERROR_LOCN'
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4709: x_sv_status := NULL;
4710: fnd_message.set_name('XNP','STD_ERROR');
4711: fnd_message.set_token('ERROR_LOCN'
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4710: fnd_message.set_name('XNP','STD_ERROR');
4711: fnd_message.set_token('ERROR_LOCN'
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4718: fnd_message.set_token('PORTING_ID',p_porting_id);
4712: ,'xnp_core.soa_get_sv_status');
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4718: fnd_message.set_token('PORTING_ID',p_porting_id);
4719: x_error_message := fnd_message.get;
4720:
4713: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4718: fnd_message.set_token('PORTING_ID',p_porting_id);
4719: x_error_message := fnd_message.get;
4720:
4721: IF c_sv_status%ISOPEN THEN
4714: x_error_message := fnd_message.get;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4718: fnd_message.set_token('PORTING_ID',p_porting_id);
4719: x_error_message := fnd_message.get;
4720:
4721: IF c_sv_status%ISOPEN THEN
4722: CLOSE c_sv_status;
4715:
4716: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4717: fnd_message.set_token('ERROR_TEXT',x_error_message);
4718: fnd_message.set_token('PORTING_ID',p_porting_id);
4719: x_error_message := fnd_message.get;
4720:
4721: IF c_sv_status%ISOPEN THEN
4722: CLOSE c_sv_status;
4723: END IF;
4725: WHEN OTHERS THEN
4726: x_error_code := SQLCODE;
4727: x_sv_status := NULL;
4728:
4729: fnd_message.set_name('XNP','STD_ERROR');
4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');
4731: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4732: x_error_message := fnd_message.get;
4733:
4726: x_error_code := SQLCODE;
4727: x_sv_status := NULL;
4728:
4729: fnd_message.set_name('XNP','STD_ERROR');
4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');
4731: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4732: x_error_message := fnd_message.get;
4733:
4734: IF c_sv_status%ISOPEN THEN
4727: x_sv_status := NULL;
4728:
4729: fnd_message.set_name('XNP','STD_ERROR');
4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');
4731: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4732: x_error_message := fnd_message.get;
4733:
4734: IF c_sv_status%ISOPEN THEN
4735: CLOSE c_sv_status;
4728:
4729: fnd_message.set_name('XNP','STD_ERROR');
4730: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_sv_status');
4731: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4732: x_error_message := fnd_message.get;
4733:
4734: IF c_sv_status%ISOPEN THEN
4735: CLOSE c_sv_status;
4736: END IF;
4835: WHEN dup_val_on_index THEN
4836: null;
4837: WHEN NO_DATA_FOUND THEN
4838: x_error_code := SQLCODE;
4839: fnd_message.set_name('XNP','STD_ERROR');
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4836: null;
4837: WHEN NO_DATA_FOUND THEN
4838: x_error_code := SQLCODE;
4839: fnd_message.set_name('XNP','STD_ERROR');
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4837: WHEN NO_DATA_FOUND THEN
4838: x_error_code := SQLCODE;
4839: fnd_message.set_name('XNP','STD_ERROR');
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4838: x_error_code := SQLCODE;
4839: fnd_message.set_name('XNP','STD_ERROR');
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4846: fnd_message.set_token('PORTING_ID',p_porting_id);
4840: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4846: fnd_message.set_token('PORTING_ID',p_porting_id);
4847: x_error_message := fnd_message.get;
4848:
4841: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4846: fnd_message.set_token('PORTING_ID',p_porting_id);
4847: x_error_message := fnd_message.get;
4848:
4849: WHEN OTHERS THEN
4842: x_error_message := fnd_message.get;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4846: fnd_message.set_token('PORTING_ID',p_porting_id);
4847: x_error_message := fnd_message.get;
4848:
4849: WHEN OTHERS THEN
4850: x_error_code := SQLCODE;
4843:
4844: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4845: fnd_message.set_token('ERROR_TEXT',x_error_message);
4846: fnd_message.set_token('PORTING_ID',p_porting_id);
4847: x_error_message := fnd_message.get;
4848:
4849: WHEN OTHERS THEN
4850: x_error_code := SQLCODE;
4851:
4848:
4849: WHEN OTHERS THEN
4850: x_error_code := SQLCODE;
4851:
4852: fnd_message.set_name('XNP','STD_ERROR');
4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4854: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4855: x_error_message := fnd_message.get;
4856:
4849: WHEN OTHERS THEN
4850: x_error_code := SQLCODE;
4851:
4852: fnd_message.set_name('XNP','STD_ERROR');
4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4854: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4855: x_error_message := fnd_message.get;
4856:
4857: END SOA_SET_BLOCKED_FLAG;
4850: x_error_code := SQLCODE;
4851:
4852: fnd_message.set_name('XNP','STD_ERROR');
4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4854: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4855: x_error_message := fnd_message.get;
4856:
4857: END SOA_SET_BLOCKED_FLAG;
4858:
4851:
4852: fnd_message.set_name('XNP','STD_ERROR');
4853: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_blocked_flag');
4854: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4855: x_error_message := fnd_message.get;
4856:
4857: END SOA_SET_BLOCKED_FLAG;
4858:
4859: PROCEDURE SOA_GET_BLOCKED_FLAG
4887:
4888: EXCEPTION
4889: WHEN NO_DATA_FOUND THEN
4890: x_error_code := SQLCODE;
4891: fnd_message.set_name('XNP','STD_ERROR');
4892: fnd_message.set_token('ERROR_LOCN'
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4888: EXCEPTION
4889: WHEN NO_DATA_FOUND THEN
4890: x_error_code := SQLCODE;
4891: fnd_message.set_name('XNP','STD_ERROR');
4892: fnd_message.set_token('ERROR_LOCN'
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4890: x_error_code := SQLCODE;
4891: fnd_message.set_name('XNP','STD_ERROR');
4892: fnd_message.set_token('ERROR_LOCN'
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4891: fnd_message.set_name('XNP','STD_ERROR');
4892: fnd_message.set_token('ERROR_LOCN'
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4899: fnd_message.set_token('PORTING_ID',p_porting_id);
4893: ,'xnp_core.soa_get_blocked_flag');
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4899: fnd_message.set_token('PORTING_ID',p_porting_id);
4900: x_error_message := fnd_message.get;
4901:
4894: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4899: fnd_message.set_token('PORTING_ID',p_porting_id);
4900: x_error_message := fnd_message.get;
4901:
4902: IF c_blocked_flag%ISOPEN THEN
4895: x_error_message := fnd_message.get;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4899: fnd_message.set_token('PORTING_ID',p_porting_id);
4900: x_error_message := fnd_message.get;
4901:
4902: IF c_blocked_flag%ISOPEN THEN
4903: CLOSE c_blocked_flag;
4896:
4897: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4898: fnd_message.set_token('ERROR_TEXT',x_error_message);
4899: fnd_message.set_token('PORTING_ID',p_porting_id);
4900: x_error_message := fnd_message.get;
4901:
4902: IF c_blocked_flag%ISOPEN THEN
4903: CLOSE c_blocked_flag;
4904: END IF;
4905:
4906: WHEN OTHERS THEN
4907: x_error_code := SQLCODE;
4908:
4909: fnd_message.set_name('XNP','STD_ERROR');
4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');
4911: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4912: x_error_message := fnd_message.get;
4913:
4906: WHEN OTHERS THEN
4907: x_error_code := SQLCODE;
4908:
4909: fnd_message.set_name('XNP','STD_ERROR');
4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');
4911: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4912: x_error_message := fnd_message.get;
4913:
4914: IF c_blocked_flag%ISOPEN THEN
4907: x_error_code := SQLCODE;
4908:
4909: fnd_message.set_name('XNP','STD_ERROR');
4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');
4911: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4912: x_error_message := fnd_message.get;
4913:
4914: IF c_blocked_flag%ISOPEN THEN
4915: CLOSE c_blocked_flag;
4908:
4909: fnd_message.set_name('XNP','STD_ERROR');
4910: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_blocked_flag');
4911: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4912: x_error_message := fnd_message.get;
4913:
4914: IF c_blocked_flag%ISOPEN THEN
4915: CLOSE c_blocked_flag;
4916: END IF;
4949:
4950: EXCEPTION
4951: WHEN NO_DATA_FOUND THEN
4952: x_error_code := SQLCODE;
4953: fnd_message.set_name('XNP','STD_ERROR');
4954: fnd_message.set_token('ERROR_LOCN'
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4950: EXCEPTION
4951: WHEN NO_DATA_FOUND THEN
4952: x_error_code := SQLCODE;
4953: fnd_message.set_name('XNP','STD_ERROR');
4954: fnd_message.set_token('ERROR_LOCN'
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4952: x_error_code := SQLCODE;
4953: fnd_message.set_name('XNP','STD_ERROR');
4954: fnd_message.set_token('ERROR_LOCN'
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4953: fnd_message.set_name('XNP','STD_ERROR');
4954: fnd_message.set_token('ERROR_LOCN'
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4961: fnd_message.set_token('PORTING_ID',p_porting_id);
4955: ,'xnp_core.soa_get_new_sp_auth_flag');
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4961: fnd_message.set_token('PORTING_ID',p_porting_id);
4962: x_error_message := fnd_message.get;
4963:
4956: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4961: fnd_message.set_token('PORTING_ID',p_porting_id);
4962: x_error_message := fnd_message.get;
4963:
4964: IF c_new_sp_auth_flag%ISOPEN THEN
4957: x_error_message := fnd_message.get;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4961: fnd_message.set_token('PORTING_ID',p_porting_id);
4962: x_error_message := fnd_message.get;
4963:
4964: IF c_new_sp_auth_flag%ISOPEN THEN
4965: CLOSE c_new_sp_auth_flag;
4958:
4959: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
4960: fnd_message.set_token('ERROR_TEXT',x_error_message);
4961: fnd_message.set_token('PORTING_ID',p_porting_id);
4962: x_error_message := fnd_message.get;
4963:
4964: IF c_new_sp_auth_flag%ISOPEN THEN
4965: CLOSE c_new_sp_auth_flag;
4966: END IF;
4967:
4968: WHEN OTHERS THEN
4969: x_error_code := SQLCODE;
4970:
4971: fnd_message.set_name('XNP','STD_ERROR');
4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');
4973: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4974: x_error_message := fnd_message.get;
4975:
4968: WHEN OTHERS THEN
4969: x_error_code := SQLCODE;
4970:
4971: fnd_message.set_name('XNP','STD_ERROR');
4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');
4973: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4974: x_error_message := fnd_message.get;
4975:
4976: IF c_new_sp_auth_flag%ISOPEN THEN
4969: x_error_code := SQLCODE;
4970:
4971: fnd_message.set_name('XNP','STD_ERROR');
4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');
4973: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4974: x_error_message := fnd_message.get;
4975:
4976: IF c_new_sp_auth_flag%ISOPEN THEN
4977: CLOSE c_new_sp_auth_flag;
4970:
4971: fnd_message.set_name('XNP','STD_ERROR');
4972: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_new_sp_auth_flag');
4973: fnd_message.set_token('ERROR_TEXT',SQLERRM);
4974: x_error_message := fnd_message.get;
4975:
4976: IF c_new_sp_auth_flag%ISOPEN THEN
4977: CLOSE c_new_sp_auth_flag;
4978: END IF;
5010:
5011: EXCEPTION
5012: WHEN NO_DATA_FOUND THEN
5013: x_error_code := SQLCODE;
5014: fnd_message.set_name('XNP','STD_ERROR');
5015: fnd_message.set_token('ERROR_LOCN'
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5011: EXCEPTION
5012: WHEN NO_DATA_FOUND THEN
5013: x_error_code := SQLCODE;
5014: fnd_message.set_name('XNP','STD_ERROR');
5015: fnd_message.set_token('ERROR_LOCN'
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5013: x_error_code := SQLCODE;
5014: fnd_message.set_name('XNP','STD_ERROR');
5015: fnd_message.set_token('ERROR_LOCN'
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5014: fnd_message.set_name('XNP','STD_ERROR');
5015: fnd_message.set_token('ERROR_LOCN'
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5022: fnd_message.set_token('PORTING_ID',p_porting_id);
5016: ,'xnp_core.soa_get_old_sp_auth_flag');
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5022: fnd_message.set_token('PORTING_ID',p_porting_id);
5023: x_error_message := fnd_message.get;
5024:
5017: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5022: fnd_message.set_token('PORTING_ID',p_porting_id);
5023: x_error_message := fnd_message.get;
5024:
5025: IF c_old_sp_auth_flag%ISOPEN THEN
5018: x_error_message := fnd_message.get;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5022: fnd_message.set_token('PORTING_ID',p_porting_id);
5023: x_error_message := fnd_message.get;
5024:
5025: IF c_old_sp_auth_flag%ISOPEN THEN
5026: CLOSE c_old_sp_auth_flag;
5019:
5020: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5021: fnd_message.set_token('ERROR_TEXT',x_error_message);
5022: fnd_message.set_token('PORTING_ID',p_porting_id);
5023: x_error_message := fnd_message.get;
5024:
5025: IF c_old_sp_auth_flag%ISOPEN THEN
5026: CLOSE c_old_sp_auth_flag;
5027: END IF;
5028:
5029: WHEN OTHERS THEN
5030: x_error_code := SQLCODE;
5031:
5032: fnd_message.set_name('XNP','STD_ERROR');
5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');
5034: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5035: x_error_message := fnd_message.get;
5036:
5029: WHEN OTHERS THEN
5030: x_error_code := SQLCODE;
5031:
5032: fnd_message.set_name('XNP','STD_ERROR');
5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');
5034: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5035: x_error_message := fnd_message.get;
5036:
5037: IF c_old_sp_auth_flag%ISOPEN THEN
5030: x_error_code := SQLCODE;
5031:
5032: fnd_message.set_name('XNP','STD_ERROR');
5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');
5034: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5035: x_error_message := fnd_message.get;
5036:
5037: IF c_old_sp_auth_flag%ISOPEN THEN
5038: CLOSE c_old_sp_auth_flag;
5031:
5032: fnd_message.set_name('XNP','STD_ERROR');
5033: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_old_sp_auth_flag');
5034: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5035: x_error_message := fnd_message.get;
5036:
5037: IF c_old_sp_auth_flag%ISOPEN THEN
5038: CLOSE c_old_sp_auth_flag;
5039: END IF;
5110: null;
5111:
5112: WHEN e_SOA_UPD_ACTIVATION_DUE_DATE THEN
5113: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
5114: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
5115: fnd_message.set_token('PORTING_ID',p_porting_id);
5116:
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5111:
5112: WHEN e_SOA_UPD_ACTIVATION_DUE_DATE THEN
5113: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
5114: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
5115: fnd_message.set_token('PORTING_ID',p_porting_id);
5116:
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5115: fnd_message.set_token('PORTING_ID',p_porting_id);
5116:
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');
5121: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5122: x_error_message := fnd_message.get;
5123:
5116:
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');
5121: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5122: x_error_message := fnd_message.get;
5123:
5124: END SOA_UPDATE_ACTIVATION_DUE_DATE;
5117: WHEN OTHERS THEN
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');
5121: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5122: x_error_message := fnd_message.get;
5123:
5124: END SOA_UPDATE_ACTIVATION_DUE_DATE;
5125:
5118: x_ERROR_CODE := SQLCODE;
5119: fnd_message.set_name('XNP','STD_ERROR');
5120: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_ACTIVATION_DUE_DATE');
5121: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5122: x_error_message := fnd_message.get;
5123:
5124: END SOA_UPDATE_ACTIVATION_DUE_DATE;
5125:
5126:
5215: EXCEPTION
5216: WHEN NO_DATA_FOUND THEN
5217: x_ERROR_CODE := SQLCODE;
5218:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5216: WHEN NO_DATA_FOUND THEN
5217: x_ERROR_CODE := SQLCODE;
5218:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5217: x_ERROR_CODE := SQLCODE;
5218:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5218:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5219: fnd_message.set_name('XNP','STD_GET_FAILED');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5227: fnd_message.set_name('XNP','CHECK_IF_SP_ASSIGNED_ERR');
5220: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5221: fnd_message.set_token('ATTRNAME','SP_ID');
5222: fnd_message.set_token('KEY','SP_ID');
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5227: fnd_message.set_name('XNP','CHECK_IF_SP_ASSIGNED_ERR');
5228: fnd_message.set_token('ERROR_TEXT',x_error_message);
5223: fnd_message.set_token('VALUE',to_char(p_SP_ID));
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5227: fnd_message.set_name('XNP','CHECK_IF_SP_ASSIGNED_ERR');
5228: fnd_message.set_token('ERROR_TEXT',x_error_message);
5229: x_error_message := fnd_message.get;
5230:
5231: IF c_rn_owner%ISOPEN THEN
5224: x_error_message := fnd_message.get;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5227: fnd_message.set_name('XNP','CHECK_IF_SP_ASSIGNED_ERR');
5228: fnd_message.set_token('ERROR_TEXT',x_error_message);
5229: x_error_message := fnd_message.get;
5230:
5231: IF c_rn_owner%ISOPEN THEN
5232: CLOSE c_rn_owner;
5225: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5226:
5227: fnd_message.set_name('XNP','CHECK_IF_SP_ASSIGNED_ERR');
5228: fnd_message.set_token('ERROR_TEXT',x_error_message);
5229: x_error_message := fnd_message.get;
5230:
5231: IF c_rn_owner%ISOPEN THEN
5232: CLOSE c_rn_owner;
5233: END IF;
5234:
5235: WHEN OTHERS THEN
5236: x_ERROR_CODE := SQLCODE;
5237:
5238: fnd_message.set_name('XNP','STD_ERROR');
5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5240: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5241: x_error_message := fnd_message.get;
5242:
5235: WHEN OTHERS THEN
5236: x_ERROR_CODE := SQLCODE;
5237:
5238: fnd_message.set_name('XNP','STD_ERROR');
5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5240: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5241: x_error_message := fnd_message.get;
5242:
5243: IF c_rn_owner%ISOPEN THEN
5236: x_ERROR_CODE := SQLCODE;
5237:
5238: fnd_message.set_name('XNP','STD_ERROR');
5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5240: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5241: x_error_message := fnd_message.get;
5242:
5243: IF c_rn_owner%ISOPEN THEN
5244: CLOSE c_rn_owner;
5237:
5238: fnd_message.set_name('XNP','STD_ERROR');
5239: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_IF_SP_ASSIGNED');
5240: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5241: x_error_message := fnd_message.get;
5242:
5243: IF c_rn_owner%ISOPEN THEN
5244: CLOSE c_rn_owner;
5245: END IF;
5313: WHEN dup_val_on_index THEN
5314: null;
5315: WHEN NO_DATA_FOUND THEN
5316: x_error_code := SQLCODE;
5317: fnd_message.set_name('XNP','STD_ERROR');
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5314: null;
5315: WHEN NO_DATA_FOUND THEN
5316: x_error_code := SQLCODE;
5317: fnd_message.set_name('XNP','STD_ERROR');
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5315: WHEN NO_DATA_FOUND THEN
5316: x_error_code := SQLCODE;
5317: fnd_message.set_name('XNP','STD_ERROR');
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5316: x_error_code := SQLCODE;
5317: fnd_message.set_name('XNP','STD_ERROR');
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5324: fnd_message.set_token('PORTING_ID',p_porting_id);
5318: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5324: fnd_message.set_token('PORTING_ID',p_porting_id);
5325: x_error_message := fnd_message.get;
5326:
5319: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5324: fnd_message.set_token('PORTING_ID',p_porting_id);
5325: x_error_message := fnd_message.get;
5326:
5327: WHEN OTHERS THEN
5320: x_error_message := fnd_message.get;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5324: fnd_message.set_token('PORTING_ID',p_porting_id);
5325: x_error_message := fnd_message.get;
5326:
5327: WHEN OTHERS THEN
5328: x_error_code := SQLCODE;
5321:
5322: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5323: fnd_message.set_token('ERROR_TEXT',x_error_message);
5324: fnd_message.set_token('PORTING_ID',p_porting_id);
5325: x_error_message := fnd_message.get;
5326:
5327: WHEN OTHERS THEN
5328: x_error_code := SQLCODE;
5329:
5326:
5327: WHEN OTHERS THEN
5328: x_error_code := SQLCODE;
5329:
5330: fnd_message.set_name('XNP','STD_ERROR');
5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5332: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5333: x_error_message := fnd_message.get ;
5334:
5327: WHEN OTHERS THEN
5328: x_error_code := SQLCODE;
5329:
5330: fnd_message.set_name('XNP','STD_ERROR');
5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5332: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5333: x_error_message := fnd_message.get ;
5334:
5335: END SOA_UPDATE_NOTES_INFO;
5328: x_error_code := SQLCODE;
5329:
5330: fnd_message.set_name('XNP','STD_ERROR');
5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5332: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5333: x_error_message := fnd_message.get ;
5334:
5335: END SOA_UPDATE_NOTES_INFO;
5336:
5329:
5330: fnd_message.set_name('XNP','STD_ERROR');
5331: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_notes_info');
5332: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5333: x_error_message := fnd_message.get ;
5334:
5335: END SOA_UPDATE_NOTES_INFO;
5336:
5337: PROCEDURE SOA_UPDATE_NETWORK_INFO
5421: WHEN dup_val_on_index THEN
5422: null;
5423: WHEN NO_DATA_FOUND THEN
5424: x_error_code := SQLCODE;
5425: fnd_message.set_name('XNP','STD_ERROR');
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5422: null;
5423: WHEN NO_DATA_FOUND THEN
5424: x_error_code := SQLCODE;
5425: fnd_message.set_name('XNP','STD_ERROR');
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5423: WHEN NO_DATA_FOUND THEN
5424: x_error_code := SQLCODE;
5425: fnd_message.set_name('XNP','STD_ERROR');
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5424: x_error_code := SQLCODE;
5425: fnd_message.set_name('XNP','STD_ERROR');
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5432: fnd_message.set_token('PORTING_ID',p_porting_id);
5426: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5432: fnd_message.set_token('PORTING_ID',p_porting_id);
5433: x_error_message := fnd_message.get;
5434:
5427: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5432: fnd_message.set_token('PORTING_ID',p_porting_id);
5433: x_error_message := fnd_message.get;
5434:
5435: WHEN OTHERS THEN
5428: x_error_message := fnd_message.get;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5432: fnd_message.set_token('PORTING_ID',p_porting_id);
5433: x_error_message := fnd_message.get;
5434:
5435: WHEN OTHERS THEN
5436: x_error_code := SQLCODE;
5429:
5430: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5431: fnd_message.set_token('ERROR_TEXT',x_error_message);
5432: fnd_message.set_token('PORTING_ID',p_porting_id);
5433: x_error_message := fnd_message.get;
5434:
5435: WHEN OTHERS THEN
5436: x_error_code := SQLCODE;
5437:
5434:
5435: WHEN OTHERS THEN
5436: x_error_code := SQLCODE;
5437:
5438: fnd_message.set_name('XNP','STD_ERROR');
5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5440: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5441: x_error_message := fnd_message.get;
5442:
5435: WHEN OTHERS THEN
5436: x_error_code := SQLCODE;
5437:
5438: fnd_message.set_name('XNP','STD_ERROR');
5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5440: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5441: x_error_message := fnd_message.get;
5442:
5443: END SOA_UPDATE_NETWORK_INFO;
5436: x_error_code := SQLCODE;
5437:
5438: fnd_message.set_name('XNP','STD_ERROR');
5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5440: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5441: x_error_message := fnd_message.get;
5442:
5443: END SOA_UPDATE_NETWORK_INFO;
5444:
5437:
5438: fnd_message.set_name('XNP','STD_ERROR');
5439: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_network_info');
5440: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5441: x_error_message := fnd_message.get;
5442:
5443: END SOA_UPDATE_NETWORK_INFO;
5444:
5445: PROCEDURE SOA_UPDATE_CUSTOMER_INFO
5536: WHEN dup_val_on_index THEN
5537: null;
5538: WHEN NO_DATA_FOUND THEN
5539: x_error_code := SQLCODE;
5540: fnd_message.set_name('XNP','STD_ERROR');
5541: fnd_message.set_token('ERROR_LOCN'
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5537: null;
5538: WHEN NO_DATA_FOUND THEN
5539: x_error_code := SQLCODE;
5540: fnd_message.set_name('XNP','STD_ERROR');
5541: fnd_message.set_token('ERROR_LOCN'
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5539: x_error_code := SQLCODE;
5540: fnd_message.set_name('XNP','STD_ERROR');
5541: fnd_message.set_token('ERROR_LOCN'
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5540: fnd_message.set_name('XNP','STD_ERROR');
5541: fnd_message.set_token('ERROR_LOCN'
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5548: fnd_message.set_token('PORTING_ID',p_porting_id);
5542: ,'xnp_core.soa_update_customer_info');
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5548: fnd_message.set_token('PORTING_ID',p_porting_id);
5549: x_error_message := fnd_message.get;
5550:
5543: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5548: fnd_message.set_token('PORTING_ID',p_porting_id);
5549: x_error_message := fnd_message.get;
5550:
5551: WHEN OTHERS THEN
5544: x_error_message := fnd_message.get;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5548: fnd_message.set_token('PORTING_ID',p_porting_id);
5549: x_error_message := fnd_message.get;
5550:
5551: WHEN OTHERS THEN
5552: x_error_code := SQLCODE;
5545:
5546: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
5547: fnd_message.set_token('ERROR_TEXT',x_error_message);
5548: fnd_message.set_token('PORTING_ID',p_porting_id);
5549: x_error_message := fnd_message.get;
5550:
5551: WHEN OTHERS THEN
5552: x_error_code := SQLCODE;
5553:
5550:
5551: WHEN OTHERS THEN
5552: x_error_code := SQLCODE;
5553:
5554: fnd_message.set_name('XNP','STD_ERROR');
5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');
5556: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5557: x_error_message := fnd_message.get;
5558:
5551: WHEN OTHERS THEN
5552: x_error_code := SQLCODE;
5553:
5554: fnd_message.set_name('XNP','STD_ERROR');
5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');
5556: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5557: x_error_message := fnd_message.get;
5558:
5559: END SOA_UPDATE_CUSTOMER_INFO;
5552: x_error_code := SQLCODE;
5553:
5554: fnd_message.set_name('XNP','STD_ERROR');
5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');
5556: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5557: x_error_message := fnd_message.get;
5558:
5559: END SOA_UPDATE_CUSTOMER_INFO;
5560:
5553:
5554: fnd_message.set_name('XNP','STD_ERROR');
5555: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_update_customer_info');
5556: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5557: x_error_message := fnd_message.get;
5558:
5559: END SOA_UPDATE_CUSTOMER_INFO;
5560:
5561:
5669: WHEN dup_val_on_index THEN
5670: null;
5671: WHEN NO_DATA_FOUND THEN
5672: x_ERROR_CODE := SQLCODE;
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5670: null;
5671: WHEN NO_DATA_FOUND THEN
5672: x_ERROR_CODE := SQLCODE;
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;
5671: WHEN NO_DATA_FOUND THEN
5672: x_ERROR_CODE := SQLCODE;
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;
5679: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5672: x_ERROR_CODE := SQLCODE;
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;
5679: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5680:
5673: fnd_message.set_name('XNP','STD_GET_FAILED');
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;
5679: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5680:
5681: WHEN OTHERS THEN
5674: fnd_message.set_token('FAILED_PROC','XNP_CORE.SOA_UPDATE_PORTING_ID');
5675: fnd_message.set_token('ATTRNAME','PORTING_ID:ORDER_ID');
5676: fnd_message.set_token('KEY','ORDER_ID:PORTING_ID');
5677: fnd_message.set_token('VALUE',to_char(p_order_id)||':'||p_porting_id);
5678: x_error_message := fnd_message.get;
5679: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5680:
5681: WHEN OTHERS THEN
5682: x_ERROR_CODE := SQLCODE;
5679: x_ERROR_MESSAGE := x_error_message||':'||SQLERRM;
5680:
5681: WHEN OTHERS THEN
5682: x_ERROR_CODE := SQLCODE;
5683: fnd_message.set_name('XNP','STD_ERROR');
5684: fnd_message.set_token('ERROR_LOCN'
5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');
5686: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5687: x_error_message := fnd_message.get;
5680:
5681: WHEN OTHERS THEN
5682: x_ERROR_CODE := SQLCODE;
5683: fnd_message.set_name('XNP','STD_ERROR');
5684: fnd_message.set_token('ERROR_LOCN'
5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');
5686: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5687: x_error_message := fnd_message.get;
5688:
5682: x_ERROR_CODE := SQLCODE;
5683: fnd_message.set_name('XNP','STD_ERROR');
5684: fnd_message.set_token('ERROR_LOCN'
5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');
5686: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5687: x_error_message := fnd_message.get;
5688:
5689: END SOA_UPDATE_PORTING_ID;
5690:
5683: fnd_message.set_name('XNP','STD_ERROR');
5684: fnd_message.set_token('ERROR_LOCN'
5685: ,'XNP_CORE.SOA_UPDATE_PORTING_ID');
5686: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5687: x_error_message := fnd_message.get;
5688:
5689: END SOA_UPDATE_PORTING_ID;
5690:
5691: PROCEDURE SMS_UPDATE_PROV_DONE_DATE
5790: EXCEPTION
5791: WHEN NO_DATA_FOUND THEN
5792: x_error_code := SQLCODE;
5793:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5791: WHEN NO_DATA_FOUND THEN
5792: x_error_code := SQLCODE;
5793:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5792: x_error_code := SQLCODE;
5793:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5793:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5794: fnd_message.set_name('XNP','STD_GET_FAILED');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5802: fnd_message.set_name('XNP','CHECK_RN_FOR_RECIPIENT');
5795: fnd_message.set_token('FAILED_PROC','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5796: fnd_message.set_token('ATTRNAME','ROUTING_NUMBER_ID');
5797: fnd_message.set_token('KEY','ROUTING_NUMBER_ID');
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5802: fnd_message.set_name('XNP','CHECK_RN_FOR_RECIPIENT');
5803: fnd_message.set_token('ERROR_TEXT',x_error_message);
5798: fnd_message.set_token('VALUE' ,to_char(p_ROUTING_NUMBER_ID));
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5802: fnd_message.set_name('XNP','CHECK_RN_FOR_RECIPIENT');
5803: fnd_message.set_token('ERROR_TEXT',x_error_message);
5804: x_error_message := fnd_message.get;
5805:
5806:
5799: x_error_message := fnd_message.get;
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5802: fnd_message.set_name('XNP','CHECK_RN_FOR_RECIPIENT');
5803: fnd_message.set_token('ERROR_TEXT',x_error_message);
5804: x_error_message := fnd_message.get;
5805:
5806:
5807: IF c_rn_for_recipient%ISOPEN THEN
5800: x_error_message := x_error_message||':'||SQLERRM;
5801:
5802: fnd_message.set_name('XNP','CHECK_RN_FOR_RECIPIENT');
5803: fnd_message.set_token('ERROR_TEXT',x_error_message);
5804: x_error_message := fnd_message.get;
5805:
5806:
5807: IF c_rn_for_recipient%ISOPEN THEN
5808: CLOSE c_rn_for_recipient;
5809: END IF;
5810:
5811: WHEN OTHERS THEN
5812: x_error_code := SQLCODE;
5813: fnd_message.set_name('XNP','STD_ERROR');
5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5815: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5816: x_error_message := fnd_message.get;
5817:
5810:
5811: WHEN OTHERS THEN
5812: x_error_code := SQLCODE;
5813: fnd_message.set_name('XNP','STD_ERROR');
5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5815: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5816: x_error_message := fnd_message.get;
5817:
5818: IF c_rn_for_recipient%ISOPEN THEN
5811: WHEN OTHERS THEN
5812: x_error_code := SQLCODE;
5813: fnd_message.set_name('XNP','STD_ERROR');
5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5815: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5816: x_error_message := fnd_message.get;
5817:
5818: IF c_rn_for_recipient%ISOPEN THEN
5819: CLOSE c_rn_for_recipient;
5812: x_error_code := SQLCODE;
5813: fnd_message.set_name('XNP','STD_ERROR');
5814: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CHECK_RN_FOR_RECIPIENT');
5815: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5816: x_error_message := fnd_message.get;
5817:
5818: IF c_rn_for_recipient%ISOPEN THEN
5819: CLOSE c_rn_for_recipient;
5820: END IF;
5913:
5914:
5915: -- Return x_error code and x_error_message
5916: IF l_error_message is NOT NULL THEN
5917: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5914:
5915: -- Return x_error code and x_error_message
5916: IF l_error_message is NOT NULL THEN
5917: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5922: X_ERROR_CODE:= -( FND_MESSAGE.GET_NUMBER('XNP',
5915: -- Return x_error code and x_error_message
5916: IF l_error_message is NOT NULL THEN
5917: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5922: X_ERROR_CODE:= -( FND_MESSAGE.GET_NUMBER('XNP',
5923: 'XNP_RVU_VALIDATION_FAILED'));
5916: IF l_error_message is NOT NULL THEN
5917: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5922: X_ERROR_CODE:= -( FND_MESSAGE.GET_NUMBER('XNP',
5923: 'XNP_RVU_VALIDATION_FAILED'));
5924: END IF;
5917: FND_MESSAGE.SET_NAME('XNP','XNP_RVU_VALIDATION_FAILED');
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5922: X_ERROR_CODE:= -( FND_MESSAGE.GET_NUMBER('XNP',
5923: 'XNP_RVU_VALIDATION_FAILED'));
5924: END IF;
5925:
5918: FND_MESSAGE.SET_TOKEN('ORDER_ID',xdp_order.G_external_order_reference);
5919: FND_MESSAGE.SET_TOKEN('WORKITEM_NAME',XDP_OA_UTIL.g_Workitem_Name);
5920: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_message);
5921: x_error_message:= SUBSTR(FND_MESSAGE.GET,1,4000); -- rnyberg 01/26/2001. Added substr since max 4000 chars can be handled in parameter. To fix bug 1580568.
5922: X_ERROR_CODE:= -( FND_MESSAGE.GET_NUMBER('XNP',
5923: 'XNP_RVU_VALIDATION_FAILED'));
5924: END IF;
5925:
5926: EXCEPTION
5926: EXCEPTION
5927: WHEN OTHERS THEN
5928: x_error_code := SQLCODE;
5929:
5930: fnd_message.set_name('XNP','STD_ERROR');
5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');
5932: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5933: x_error_message := fnd_message.get;
5934:
5927: WHEN OTHERS THEN
5928: x_error_code := SQLCODE;
5929:
5930: fnd_message.set_name('XNP','STD_ERROR');
5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');
5932: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5933: x_error_message := fnd_message.get;
5934:
5935:
5928: x_error_code := SQLCODE;
5929:
5930: fnd_message.set_name('XNP','STD_ERROR');
5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');
5932: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5933: x_error_message := fnd_message.get;
5934:
5935:
5936: End RUNTIME_VALIDATION;
5929:
5930: fnd_message.set_name('XNP','STD_ERROR');
5931: fnd_message.set_token('ERROR_LOCN','XNP_CORE.RUNTIME_VALIDATION');
5932: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5933: x_error_message := fnd_message.get;
5934:
5935:
5936: End RUNTIME_VALIDATION;
5937:
5980: WHEN dup_val_on_index THEN
5981: null;
5982: WHEN others THEN
5983: x_error_code := sqlcode;
5984: fnd_message.set_name('XNP','STD ERROR');
5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');
5986: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5987: x_error_message := fnd_message.get;
5988:
5981: null;
5982: WHEN others THEN
5983: x_error_code := sqlcode;
5984: fnd_message.set_name('XNP','STD ERROR');
5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');
5986: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5987: x_error_message := fnd_message.get;
5988:
5989: END CREATE_ORDER_MAPPING;
5982: WHEN others THEN
5983: x_error_code := sqlcode;
5984: fnd_message.set_name('XNP','STD ERROR');
5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');
5986: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5987: x_error_message := fnd_message.get;
5988:
5989: END CREATE_ORDER_MAPPING;
5990:
5983: x_error_code := sqlcode;
5984: fnd_message.set_name('XNP','STD ERROR');
5985: fnd_message.set_token('ERROR_LOCN','XNP_CORE.CREATE_ORDER_MAPPING');
5986: fnd_message.set_token('ERROR_TEXT',SQLERRM);
5987: x_error_message := fnd_message.get;
5988:
5989: END CREATE_ORDER_MAPPING;
5990:
5991: PROCEDURE SOA_UPDATE_DISCONN_DUE_DATE
6056: WHEN dup_val_on_index THEN
6057: null;
6058: WHEN e_SOA_UPDATE_DISCON_DUE_DATE THEN
6059: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6060: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6061: fnd_message.set_token('PORTING_ID',p_porting_id);
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6057: null;
6058: WHEN e_SOA_UPDATE_DISCON_DUE_DATE THEN
6059: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6060: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6061: fnd_message.set_token('PORTING_ID',p_porting_id);
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6060: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6061: fnd_message.set_token('PORTING_ID',p_porting_id);
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6067: x_error_message := fnd_message.get;
6068:
6061: fnd_message.set_token('PORTING_ID',p_porting_id);
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6067: x_error_message := fnd_message.get;
6068:
6069: END SOA_UPDATE_DISCONN_DUE_DATE;
6062: WHEN OTHERS THEN
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6067: x_error_message := fnd_message.get;
6068:
6069: END SOA_UPDATE_DISCONN_DUE_DATE;
6070:
6063: x_ERROR_CODE := SQLCODE;
6064: fnd_message.set_name('XNP','STD_ERROR');
6065: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_DISCONNECT_DUE_DATE');
6066: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6067: x_error_message := fnd_message.get;
6068:
6069: END SOA_UPDATE_DISCONN_DUE_DATE;
6070:
6071:
6137: WHEN dup_val_on_index THEN
6138: null;
6139: WHEN e_SOA_UPDATE_EFF_REL_DUE_DATE THEN
6140: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6141: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6142: fnd_message.set_token('PORTING_ID',p_porting_id);
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6138: null;
6139: WHEN e_SOA_UPDATE_EFF_REL_DUE_DATE THEN
6140: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6141: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6142: fnd_message.set_token('PORTING_ID',p_porting_id);
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6141: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6142: fnd_message.set_token('PORTING_ID',p_porting_id);
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6147: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6148: x_error_message := fnd_message.get;
6149:
6142: fnd_message.set_token('PORTING_ID',p_porting_id);
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6147: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6148: x_error_message := fnd_message.get;
6149:
6150: END SOA_UPDATE_EFFECT_REL_DUE_DATE;
6143: WHEN OTHERS THEN
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6147: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6148: x_error_message := fnd_message.get;
6149:
6150: END SOA_UPDATE_EFFECT_REL_DUE_DATE;
6151:
6144: x_ERROR_CODE := SQLCODE;
6145: fnd_message.set_name('XNP','STD_ERROR');
6146: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_UPDATE_EFFECT_REL_DUE_DATE');
6147: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6148: x_error_message := fnd_message.get;
6149:
6150: END SOA_UPDATE_EFFECT_REL_DUE_DATE;
6151:
6152: PROCEDURE SOA_UPDATE_NUM_RETURN_DUE_DATE
6217: WHEN dup_val_on_index THEN
6218: null;
6219: WHEN e_SOA_UPDATE_NUM_RET_DUE_DATE THEN
6220: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6221: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6222: fnd_message.set_token('PORTING_ID',p_porting_id);
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6218: null;
6219: WHEN e_SOA_UPDATE_NUM_RET_DUE_DATE THEN
6220: x_error_code := XNP_ERRORS.G_INVALID_DATE_FORMAT;
6221: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6222: fnd_message.set_token('PORTING_ID',p_porting_id);
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6221: fnd_message.set_name('XNP','INVALID_DATE_FORMAT_ERR');
6222: fnd_message.set_token('PORTING_ID',p_porting_id);
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6227: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6228: x_error_message := fnd_message.get;
6229:
6222: fnd_message.set_token('PORTING_ID',p_porting_id);
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6227: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6228: x_error_message := fnd_message.get;
6229:
6230: END SOA_UPDATE_NUM_RETURN_DUE_DATE;
6223: WHEN OTHERS THEN
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6227: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6228: x_error_message := fnd_message.get;
6229:
6230: END SOA_UPDATE_NUM_RETURN_DUE_DATE;
6231:
6224: x_ERROR_CODE := SQLCODE;
6225: fnd_message.set_name('XNP','STD_ERROR');
6226: fnd_message.set_token('ERROR_LOCN','XNP_CORE.SOA_NUM_RETURN_DUE_DATE');
6227: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6228: x_error_message := fnd_message.get;
6229:
6230: END SOA_UPDATE_NUM_RETURN_DUE_DATE;
6231:
6232: PROCEDURE SOA_SET_CONCURRENCE_FLAG
6292: WHEN dup_val_on_index THEN
6293: null;
6294: WHEN NO_DATA_FOUND THEN
6295: x_error_code := SQLCODE;
6296: fnd_message.set_name('XNP','STD_ERROR');
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6293: null;
6294: WHEN NO_DATA_FOUND THEN
6295: x_error_code := SQLCODE;
6296: fnd_message.set_name('XNP','STD_ERROR');
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6294: WHEN NO_DATA_FOUND THEN
6295: x_error_code := SQLCODE;
6296: fnd_message.set_name('XNP','STD_ERROR');
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6295: x_error_code := SQLCODE;
6296: fnd_message.set_name('XNP','STD_ERROR');
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6303: fnd_message.set_token('PORTING_ID',p_porting_id);
6297: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6303: fnd_message.set_token('PORTING_ID',p_porting_id);
6304: x_error_message := fnd_message.get;
6305:
6298: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6303: fnd_message.set_token('PORTING_ID',p_porting_id);
6304: x_error_message := fnd_message.get;
6305:
6306: WHEN OTHERS THEN
6299: x_error_message := fnd_message.get;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6303: fnd_message.set_token('PORTING_ID',p_porting_id);
6304: x_error_message := fnd_message.get;
6305:
6306: WHEN OTHERS THEN
6307: x_error_code := SQLCODE;
6300:
6301: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6302: fnd_message.set_token('ERROR_TEXT',x_error_message);
6303: fnd_message.set_token('PORTING_ID',p_porting_id);
6304: x_error_message := fnd_message.get;
6305:
6306: WHEN OTHERS THEN
6307: x_error_code := SQLCODE;
6308:
6305:
6306: WHEN OTHERS THEN
6307: x_error_code := SQLCODE;
6308:
6309: fnd_message.set_name('XNP','STD_ERROR');
6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6312: x_error_message := fnd_message.get;
6313:
6306: WHEN OTHERS THEN
6307: x_error_code := SQLCODE;
6308:
6309: fnd_message.set_name('XNP','STD_ERROR');
6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6312: x_error_message := fnd_message.get;
6313:
6314: END SOA_SET_CONCURRENCE_FLAG;
6307: x_error_code := SQLCODE;
6308:
6309: fnd_message.set_name('XNP','STD_ERROR');
6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6312: x_error_message := fnd_message.get;
6313:
6314: END SOA_SET_CONCURRENCE_FLAG;
6315:
6308:
6309: fnd_message.set_name('XNP','STD_ERROR');
6310: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_set_concurrence_flag');
6311: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6312: x_error_message := fnd_message.get;
6313:
6314: END SOA_SET_CONCURRENCE_FLAG;
6315:
6316: PROCEDURE SOA_GET_CONCURRENCE_FLAG
6345:
6346: EXCEPTION
6347: WHEN NO_DATA_FOUND THEN
6348: x_error_code := SQLCODE;
6349: fnd_message.set_name('XNP','STD_ERROR');
6350: fnd_message.set_token('ERROR_LOCN'
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6346: EXCEPTION
6347: WHEN NO_DATA_FOUND THEN
6348: x_error_code := SQLCODE;
6349: fnd_message.set_name('XNP','STD_ERROR');
6350: fnd_message.set_token('ERROR_LOCN'
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6348: x_error_code := SQLCODE;
6349: fnd_message.set_name('XNP','STD_ERROR');
6350: fnd_message.set_token('ERROR_LOCN'
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6349: fnd_message.set_name('XNP','STD_ERROR');
6350: fnd_message.set_token('ERROR_LOCN'
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6357: fnd_message.set_token('PORTING_ID',p_porting_id);
6351: ,'xnp_core.soa_get_concurrence_flag');
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6357: fnd_message.set_token('PORTING_ID',p_porting_id);
6358: x_error_message := fnd_message.get;
6359:
6352: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6357: fnd_message.set_token('PORTING_ID',p_porting_id);
6358: x_error_message := fnd_message.get;
6359:
6360: IF c_concurrence_flag%ISOPEN THEN
6353: x_error_message := fnd_message.get;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6357: fnd_message.set_token('PORTING_ID',p_porting_id);
6358: x_error_message := fnd_message.get;
6359:
6360: IF c_concurrence_flag%ISOPEN THEN
6361: CLOSE c_concurrence_flag;
6354:
6355: fnd_message.set_name('XNP','UPD_FOR_PORTING_ID_ERR');
6356: fnd_message.set_token('ERROR_TEXT',x_error_message);
6357: fnd_message.set_token('PORTING_ID',p_porting_id);
6358: x_error_message := fnd_message.get;
6359:
6360: IF c_concurrence_flag%ISOPEN THEN
6361: CLOSE c_concurrence_flag;
6362: END IF;
6363:
6364: WHEN OTHERS THEN
6365: x_error_code := SQLCODE;
6366:
6367: fnd_message.set_name('XNP','STD_ERROR');
6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');
6369: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6370: x_error_message := fnd_message.get;
6371:
6364: WHEN OTHERS THEN
6365: x_error_code := SQLCODE;
6366:
6367: fnd_message.set_name('XNP','STD_ERROR');
6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');
6369: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6370: x_error_message := fnd_message.get;
6371:
6372: IF c_concurrence_flag%ISOPEN THEN
6365: x_error_code := SQLCODE;
6366:
6367: fnd_message.set_name('XNP','STD_ERROR');
6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');
6369: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6370: x_error_message := fnd_message.get;
6371:
6372: IF c_concurrence_flag%ISOPEN THEN
6373: CLOSE c_concurrence_flag;
6366:
6367: fnd_message.set_name('XNP','STD_ERROR');
6368: fnd_message.set_token('ERROR_LOCN','xnp_core.soa_get_concurrence_flag');
6369: fnd_message.set_token('ERROR_TEXT',SQLERRM);
6370: x_error_message := fnd_message.get;
6371:
6372: IF c_concurrence_flag%ISOPEN THEN
6373: CLOSE c_concurrence_flag;
6374: END IF;