DBA Data[Home] [Help]

APPS.PA_CI_IMPACT_TYPE_USAGE_PVT dependencies on FND_MSG_PUB

Line 48: fnd_msg_pub.initialize;

44: SAVEPOINT create_ci_impact_type_usage;
45: END IF;
46:
47: IF p_init_msg_list = 'T' THEN
48: fnd_msg_pub.initialize;
49: END IF;
50:
51: x_return_status := 'S';
52: x_msg_count := 0;

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

89: ROLLBACK TO create_ci_impact_type_usage;
90: END IF;
91: END IF;
92:
93: fnd_msg_pub.count_and_get(p_count => x_msg_count,
94: p_data => x_msg_data);
95:
96: pa_debug.reset_err_stack;
97:

Line 105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

101: ROLLBACK TO create_ci_impact_type_usage;
102: END IF;
103:
104: x_return_status := 'U';
105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
106: p_procedure_name => 'CREATE_CI_IMPACT_TYPE_USAGE',
107: p_error_text => SUBSTRB(SQLERRM,1,240));
108:
109: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

105: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
106: p_procedure_name => 'CREATE_CI_IMPACT_TYPE_USAGE',
107: p_error_text => SUBSTRB(SQLERRM,1,240));
108:
109: fnd_msg_pub.count_and_get(p_count => x_msg_count,
110: p_data => x_msg_data);
111: END create_ci_impact_type_usage;
112:
113: --start:| 16-FEB-2009 cklee R12.1.2 setup ehancement

Line 139: fnd_msg_pub.initialize;

135: SAVEPOINT update_ci_impact_type_usage;
136: END IF;
137:
138: IF p_init_msg_list = 'T' THEN
139: fnd_msg_pub.initialize;
140: END IF;
141:
142: x_return_status := 'S';
143: x_msg_count := 0;

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

156: ROLLBACK TO update_ci_impact_type_usage;
157: END IF;
158: END IF;
159:
160: fnd_msg_pub.count_and_get(p_count => x_msg_count,
161: p_data => x_msg_data);
162:
163: pa_debug.reset_err_stack;
164:

Line 172: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

168: ROLLBACK TO update_ci_impact_type_usage;
169: END IF;
170:
171: x_return_status := 'U';
172: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
173: p_procedure_name => 'UPDATE_CI_IMPACT_TYPE_USAGE',
174: p_error_text => SUBSTRB(SQLERRM,1,240));
175:
176: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

172: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
173: p_procedure_name => 'UPDATE_CI_IMPACT_TYPE_USAGE',
174: p_error_text => SUBSTRB(SQLERRM,1,240));
175:
176: fnd_msg_pub.count_and_get(p_count => x_msg_count,
177: p_data => x_msg_data);
178:
179: end update_ci_impact_type_usage;
180: --end:| 16-FEB-2009 cklee R12.1.2 setup ehancement

Line 228: fnd_msg_pub.initialize;

224: SAVEPOINT delete_ci_impact_type_usage;
225: END IF;
226:
227: IF p_init_msg_list = 'T' THEN
228: fnd_msg_pub.initialize;
229: END IF;
230:
231: x_return_status := 'S';
232: x_msg_count := 0;

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

291: ROLLBACK TO delete_ci_impact_type_usage;
292: END IF;
293: END IF;
294:
295: fnd_msg_pub.count_and_get(p_count => x_msg_count,
296: p_data => x_msg_data);
297:
298: pa_debug.reset_err_stack;
299:

Line 307: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPES_PVT',

303: ROLLBACK TO delete_ci_impact_type_usage;
304: END IF;
305:
306: x_return_status := 'U';
307: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPES_PVT',
308: p_procedure_name => 'DELETE_CI_IMPACT_TYPE_USAGE',
309: p_error_text => SUBSTRB(SQLERRM,1,240));
310:
311: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

307: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPES_PVT',
308: p_procedure_name => 'DELETE_CI_IMPACT_TYPE_USAGE',
309: p_error_text => SUBSTRB(SQLERRM,1,240));
310:
311: fnd_msg_pub.count_and_get(p_count => x_msg_count,
312: p_data => x_msg_data);
313: END delete_ci_impact_type_usage;
314:
315: PROCEDURE apply_ci_impact_type_usage (

Line 399: fnd_msg_pub.initialize;

395: SAVEPOINT apply_ci_impact_type_usage;
396: END IF;
397:
398: IF p_init_msg_list = 'T' THEN
399: fnd_msg_pub.initialize;
400: END IF;
401:
402: x_return_status := 'S';
403: x_msg_count := 0;

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

629: END IF;
630: END IF;
631:
632: -- Get message count and if count is 1, get message info
633: fnd_msg_pub.count_and_get(p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: pa_debug.reset_err_stack;
637:

Line 645: FND_MSG_PUB.Count_And_Get

641: IF p_commit = 'T' THEN
642: ROLLBACK TO apply_ci_impact_type_usage;
643: END IF;
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MSG_PUB.Count_And_Get
646: (p_count => x_msg_count,
647: p_data => x_msg_data);
648:
649:

Line 656: FND_MSG_PUB.Count_And_Get

652: IF p_commit = 'T' THEN
653: ROLLBACK TO apply_ci_impact_type_usage;
654: END IF;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: FND_MSG_PUB.Count_And_Get
657: (p_count => x_msg_count,
658: p_data => x_msg_data);
659:
660:

Line 668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',

664: ROLLBACK TO apply_ci_impact_type_usage;
665: END IF;
666:
667: x_return_status := 'U';
668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
669: p_procedure_name => 'APPLY_CI_IMPACT_TYPE_USAGE',
670: p_error_text => SUBSTRB(SQLERRM,1,240));
671:
672: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

668: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACT_TYPE_USAGE_PVT',
669: p_procedure_name => 'APPLY_CI_IMPACT_TYPE_USAGE',
670: p_error_text => SUBSTRB(SQLERRM,1,240));
671:
672: fnd_msg_pub.count_and_get(p_count => x_msg_count,
673: p_data => x_msg_data);
674:
675:
676: