APPS.PON_FORMS_SECTIONS_PVT dependencies on PON_FORMS_UTIL_PVT

Line 33: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_form_id= ' || p_form_id ||

29:
30: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMS_SECTIONS';
31:
32: BEGIN
33: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_form_id= ' || p_form_id ||
34: ', p_name = ' || p_name ||
35: ', p_description = ' || p_description ||
36: ', p_tip_text = ' || p_tip_text ||
37: ', p_source_language = ' || p_source_language);

Line 69: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');

65: fnd_global.login_id
66: from fnd_languages a
67: where a.installed_flag in ('I', 'B');
68:
69: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in inserting rows in pon_forms_section_tl');

Line 73: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in inserting rows in pon_forms_section_tl');

69: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
70:
71: EXCEPTION
72: WHEN OTHERS THEN
73: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in inserting rows in pon_forms_section_tl');
74: p_result := 1;
75: p_err_msg := SQLERRM;
76: p_err_code := SQLCODE;
77:

Line 108: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_forms_sections_id = ' || p_forms_sections_id ||

104:
105: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMS_SECTIONS';
106:
107: BEGIN
108: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_forms_sections_id = ' || p_forms_sections_id ||
109: ', p_name = ' || p_name ||
110: ', p_description ' || p_description ||
111: ', p_tip_text = ' || p_tip_text ||
112: ', p_language = ' || p_language);

Line 129: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');

125: where
126: form_id = p_forms_sections_id and
127: language = userenv('LANG');
128:
129: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in updating rows in pon_forms_section_tl');

Line 133: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in updating rows in pon_forms_section_tl');

129: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in updating rows in pon_forms_section_tl');
134: p_result := 1;
135: p_err_msg := SQLERRM;
136: p_err_code := SQLCODE;
137: RAISE_APPLICATION_ERROR(-20202, 'Exception at PON_FORMS_SECTIONS_PKG.update_forms_sections:' || p_err_code || ' : ' || p_err_msg);

Line 162: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_form_id = ' || p_form_id);

158: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMS_SECTIONS';
159:
160: BEGIN
161:
162: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'BEGIN: p_form_id = ' || p_form_id);
163:
164: p_result := 0;
165:
166: delete from pon_forms_sections_tl where form_id=p_form_id;

Line 168: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');

164: p_result := 0;
165:
166: delete from pon_forms_sections_tl where form_id=p_form_id;
167:
168: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in deleteing rows from pon_forms_section_tl');

Line 172: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in deleteing rows from pon_forms_section_tl');

168: PON_FORMS_UTIL_PVT.print_debug_log (l_api_name, 'END');
169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: PON_FORMS_UTIL_PVT.print_error_log (l_api_name, 'Exception in deleteing rows from pon_forms_section_tl');
173: p_result := 1;
174: p_err_msg := SQLERRM;
175: p_err_code := SQLCODE;
176: