DBA Data[Home] [Help]

APPS.PA_CI_TYPE_USAGE_PUB dependencies on FND_MSG_PUB

Line 34: fnd_msg_pub.initialize;

30: SAVEPOINT create_ci_type_usage;
31: END IF;
32:
33: IF p_init_msg_list = FND_API.G_TRUE THEN
34: fnd_msg_pub.initialize;
35: END IF;
36:
37: x_return_status := 'S';
38: x_msg_count := 0;

Line 53: fnd_msg_pub.add();

49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: x_return_status := 'E';
52: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
53: fnd_msg_pub.add();
54: WHEN TOO_MANY_ROWS THEN
55: x_return_status := 'E';
56: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
57: fnd_msg_pub.add();

Line 57: fnd_msg_pub.add();

53: fnd_msg_pub.add();
54: WHEN TOO_MANY_ROWS THEN
55: x_return_status := 'E';
56: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
57: fnd_msg_pub.add();
58: END;
59: END IF;
60:
61: IF x_return_status = 'S' THEN

Line 72: fnd_msg_pub.add();

68: x_error_message_code => l_error_message_code);
69:
70: IF x_return_status <> 'S' THEN
71: fnd_message.set_name('PA', l_error_message_code);
72: fnd_msg_pub.add();
73: END IF;
74:
75: END IF;
76:

Line 102: fnd_msg_pub.count_and_get(p_count => x_msg_count,

98: ROLLBACK TO create_ci_type_usage;
99: END IF;
100: END IF;
101:
102: fnd_msg_pub.count_and_get(p_count => x_msg_count,
103: p_data => x_msg_data);
104:
105: pa_debug.reset_err_stack;
106:

Line 114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',

110: ROLLBACK TO create_ci_type_usage;
111: END IF;
112:
113: x_return_status := 'U';
114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
115: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
116: p_error_text => SUBSTRB(SQLERRM,1,240));
117:
118: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 118: fnd_msg_pub.count_and_get(p_count => x_msg_count,

114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
115: p_procedure_name => 'CREATE_CI_TYPE_USAGE',
116: p_error_text => SUBSTRB(SQLERRM,1,240));
117:
118: fnd_msg_pub.count_and_get(p_count => x_msg_count,
119: p_data => x_msg_data);
120: END create_ci_type_usage;
121:
122: PROCEDURE update_ci_type_usage (

Line 152: fnd_msg_pub.initialize;

148: SAVEPOINT update_ci_type_usage;
149: END IF;
150:
151: IF p_init_msg_list = FND_API.G_TRUE THEN
152: fnd_msg_pub.initialize;
153: END IF;
154:
155: x_return_status := 'S';
156: x_msg_count := 0;

Line 171: fnd_msg_pub.add();

167: EXCEPTION
168: WHEN NO_DATA_FOUND THEN
169: x_return_status := 'E';
170: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
171: fnd_msg_pub.add();
172: WHEN TOO_MANY_ROWS THEN
173: x_return_status := 'E';
174: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
175: fnd_msg_pub.add();

Line 175: fnd_msg_pub.add();

171: fnd_msg_pub.add();
172: WHEN TOO_MANY_ROWS THEN
173: x_return_status := 'E';
174: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
175: fnd_msg_pub.add();
176: END;
177: END IF;
178:
179: IF x_return_status = 'S' THEN

Line 190: fnd_msg_pub.add();

186: x_error_message_code => l_error_message_code);
187:
188: IF x_return_status <> 'S' THEN
189: fnd_message.set_name('PA', l_error_message_code);
190: fnd_msg_pub.add();
191: END IF;
192:
193: END IF;
194:

Line 220: fnd_msg_pub.count_and_get(p_count => x_msg_count,

216: ROLLBACK TO update_ci_type_usage;
217: END IF;
218: END IF;
219:
220: fnd_msg_pub.count_and_get(p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: pa_debug.reset_err_stack;
224:

Line 232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',

228: ROLLBACK TO update_ci_type_usage;
229: END IF;
230:
231: x_return_status := 'U';
232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
233: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
234: p_error_text => SUBSTRB(SQLERRM,1,240));
235:
236: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 236: fnd_msg_pub.count_and_get(p_count => x_msg_count,

232: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPE_USAGE_PUB',
233: p_procedure_name => 'UPDATE_CI_TYPE_USAGE',
234: p_error_text => SUBSTRB(SQLERRM,1,240));
235:
236: fnd_msg_pub.count_and_get(p_count => x_msg_count,
237: p_data => x_msg_data);
238: END update_ci_type_usage;
239:
240: PROCEDURE delete_ci_type_usage (

Line 267: fnd_msg_pub.initialize;

263: SAVEPOINT delete_ci_type_usage;
264: END IF;
265:
266: IF p_init_msg_list = FND_API.G_TRUE THEN
267: fnd_msg_pub.initialize;
268: END IF;
269:
270: x_return_status := 'S';
271: x_msg_count := 0;

Line 287: fnd_msg_pub.add();

283: EXCEPTION
284: WHEN NO_DATA_FOUND THEN
285: x_return_status := 'E';
286: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
287: fnd_msg_pub.add();
288: WHEN TOO_MANY_ROWS THEN
289: x_return_status := 'E';
290: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
291: fnd_msg_pub.add();

Line 291: fnd_msg_pub.add();

287: fnd_msg_pub.add();
288: WHEN TOO_MANY_ROWS THEN
289: x_return_status := 'E';
290: fnd_message.set_name('PA', 'PA_PROJ_TYPE_INV_AMBIGUOUS');
291: fnd_msg_pub.add();
292: END;
293: END IF;
294:
295: IF x_return_status = 'S' THEN

Line 306: fnd_msg_pub.add();

302: x_error_message_code => l_error_message_code);
303:
304: IF x_return_status <> 'S' THEN
305: fnd_message.set_name('PA', l_error_message_code);
306: fnd_msg_pub.add();
307: END IF;
308:
309: END IF;
310:

Line 333: fnd_msg_pub.count_and_get(p_count => x_msg_count,

329: ROLLBACK TO delete_ci_type_usage;
330: END IF;
331: END IF;
332:
333: fnd_msg_pub.count_and_get(p_count => x_msg_count,
334: p_data => x_msg_data);
335:
336: pa_debug.reset_err_stack;
337:

Line 345: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PUB',

341: ROLLBACK TO delete_ci_type_usage;
342: END IF;
343:
344: x_return_status := 'U';
345: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PUB',
346: p_procedure_name => 'DELETE_CI_TYPE_USAGE',
347: p_error_text => SUBSTRB(SQLERRM,1,240));
348:
349: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 349: fnd_msg_pub.count_and_get(p_count => x_msg_count,

345: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_TYPES_PUB',
346: p_procedure_name => 'DELETE_CI_TYPE_USAGE',
347: p_error_text => SUBSTRB(SQLERRM,1,240));
348:
349: fnd_msg_pub.count_and_get(p_count => x_msg_count,
350: p_data => x_msg_data);
351: END delete_ci_type_usage;
352:
353: END pa_ci_type_usage_pub;