64: RETURN l_return_value;
65:
66: EXCEPTION
67: WHEN OTHERS THEN
68: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
69: RAISE;
70: END;
71:
72: --------------------------------------------------------------------------------
126: RETURN l_return_value;
127:
128: EXCEPTION
129: WHEN OTHERS THEN
130: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
131: RAISE;
132: END;
133:
134:
189: RETURN l_return_value;
190:
191: EXCEPTION
192: WHEN OTHERS THEN
193: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
194: RAISE;
195: END;
196:
197:
233: return l_style_id;
234:
235: EXCEPTION
236: WHEN OTHERS THEN
237: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
238: RAISE;
239: END;
240:
241:
348: l_progress := '030';
349:
350: EXCEPTION
351: WHEN OTHERS THEN
352: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
353: RAISE;
354: END;
355:
356: -- GRP call for the PVT procedure
399:
400:
401: EXCEPTION
402: WHEN OTHERS THEN
403: PO_MESSAGE_S.sql_error(g_pkg_name,l_api_name,l_progress,SQLCODE,SQLERRM);
404: RAISE;
405: END;
406:
407: