202: end if;
203:
204: -- Initialize message list if p_init_msg_list is set to TRUE.
205: if fnd_api.to_boolean(p_init_msg_list) then
206: fnd_msg_pub.initialize;
207: end if;
208:
209: -- Initialize API return status to success
210: x_return_status := fnd_api.g_ret_sts_success;
299: commit work;
300: end if;
301:
302: -- Standard call to get message count and if count is 1, get message info.
303: fnd_msg_pub.count_and_get(p_count => x_msg_count,
304: p_data => x_msg_data);
305: if ec_debug.G_debug_level >= 2 then
306: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
307: end if;
308:
309: EXCEPTION
310: WHEN fnd_api.g_exc_error then
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count,
313: p_data => x_msg_data);
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
315:
316: WHEN fnd_api.g_exc_unexpected_error then
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
315:
316: WHEN fnd_api.g_exc_unexpected_error then
317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count,
319: p_data => x_msg_data);
320: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
321:
322: WHEN no_process_rule_info then
338: end if;
339: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
340: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
343: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
344: end if;
345: fnd_msg_pub.count_and_get (p_count => x_msg_count,
346: p_data => x_msg_data);
339: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
340: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
343: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
344: end if;
345: fnd_msg_pub.count_and_get (p_count => x_msg_count,
346: p_data => x_msg_data);
347: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
343: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
344: end if;
345: fnd_msg_pub.count_and_get (p_count => x_msg_count,
346: p_data => x_msg_data);
347: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
348:
349: END Validate_Process_Rules;
771: end if;
772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: if fnd_api.to_boolean(p_init_msg_list) then
775: fnd_msg_pub.initialize;
776: end if;
777:
778: -- Initialize API return status to success
779: x_return_status := fnd_api.g_ret_sts_success;
955: commit work;
956: end if;
957:
958: -- Standard call to get message count and if count is 1, get message info.
959: fnd_msg_pub.count_and_get(p_count => x_msg_count,
960: p_data => x_msg_data);
961:
962: if ec_debug.G_debug_level = 3 then
963: ec_debug.pl (3, 'x_return_status', x_return_status);
974: -- if (c_ignore_flag%ISOPEN) then
975: -- close c_ignore_flag;
976: -- end if;
977: x_return_status := fnd_api.g_ret_sts_error;
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data);
980: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
981:
982: WHEN fnd_api.g_exc_unexpected_error then
989: /* if (c_ignore_flag%ISOPEN) then
990: close c_ignore_flag;
991: end if; */
992: x_return_status := fnd_api.g_ret_sts_error;
993: fnd_msg_pub.count_and_get (p_count => x_msg_count,
994: p_data => x_msg_data);
995: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
996:
997: WHEN OTHERS THEN
1006: end if; */
1007: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1008: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1011: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
1012: end if;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data);
1007: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1008: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1011: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
1012: end if;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data);
1015: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1011: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
1012: end if;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1014: p_data => x_msg_data);
1015: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
1016:
1017: END Validate_Column_Rules;