eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_CAT_SQE_PVT dependencies on ICX_CAT_UTIL_PVT

Line 40: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

36: BEGIN
37:
38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
39: l_log_string := 'Starting create_sqes_for_zone: ' || p_content_zone_id;
40: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
41: END IF;
42: l_err_loc := 100;
43:
44: -- now we will construct the intermedia expressions for the zone

Line 59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

55: l_err_loc := 400;
56: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
57: l_log_string := 'One of the intermedia expressions for this zone is > 2000 bytes.';
58: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
59: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
60: END IF;
61: -- length exceeded, cannot create sqes, return status is error(E)
62: x_return_status := 'E';
63: ELSE

Line 74: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

70:
71: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
72: l_log_string := 'New sqe sequence is: ' || l_sqe_sequence;
73: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
74: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
75: END IF;
76: l_err_loc := 600;
77: -- and form the sqe names
78: l_int_sqe_name := 'icxzi' || l_sqe_sequence;

Line 91: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: l_log_string := 'Finished Storing sqes';
90: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
91: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
92: END IF;
93:
94: l_err_loc := 800;
95: -- now if the original content zone had an sqe_sequence, store it in deleted sqes

Line 106: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

102:
103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: l_log_string := 'Inserted old sqe sequence into deleted sqes. Old sqe sequence: ' || x_sqe_sequence;
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
106: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
107: END IF;
108: END IF;
109:
110: l_err_loc := 900;

Line 125: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

121:
122: l_err_loc := 1100;
123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: l_log_string := 'End create_sqes_for_zone: ' || p_content_zone_id || ' return status is ' || x_return_status;
125: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
126: END IF;
127:
128: EXCEPTION
129: WHEN OTHERS THEN

Line 156: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

152: BEGIN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: l_log_string := 'Starting combine_exprs: expr1 = ' || p_expr1 || ' expr2 = ' || p_expr2
155: || ' expr3 = ' || p_expr3;
156: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
157: END IF;
158: l_err_loc := 100;
159: -- first set first to 1 i.e true
160: l_first := 1;

Line 194: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

190:
191: l_err_loc := 400;
192: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: l_log_string := 'End combine_exprs: result expr is: ' || x_result_expr;
194: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
195: END IF;
196:
197: EXCEPTION
198: WHEN OTHERS THEN

Line 237: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

233: l_everything_expr VARCHAR2(2000);
234: BEGIN
235: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
236: l_log_string := 'Starting construct_exprs_for_zone';
237: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
238: END IF;
239: l_err_loc := 100;
240:
241: -- first we initialize the fixed sqes

Line 276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

272:
273: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
274: l_log_string := 'Item Type expr for Internal: ' || l_item_type_expr;
275: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
276: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
277: END IF;
278: l_err_loc := 700;
279: -- now we combine the expressions for internal
280: -- note that we pass '' for supplier since this is not needed

Line 314: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

310:
311: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
312: l_log_string := 'Item Type expr for Purchase: ' || l_item_type_expr;
313: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
314: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
315: END IF;
316:
317: l_err_loc := 1500;
318: -- now we combine the expressions for purchase

Line 346: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

342: END IF;
343: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
344: l_log_string := 'Item Type expr for both: ' || l_item_type_expr;
345: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
346: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
347: END IF;
348: l_err_loc := 2500;
349: -- now we combine the expressions for purchase
350: combine_exprs(l_supplier_and_site_expr, l_category_expr, l_item_type_expr, x_both_intermedia_expression);

Line 364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);

360: --Bug 13527354
361: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
362: l_log_string := 'End construct_exprs_for_zone: Internal String:'
363: || x_int_intermedia_expression;
364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
365: l_log_string:= ' Purchase String: ' || x_purch_intermedia_expression;
366: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
367: l_log_string:= ' Both String: ' || x_both_intermedia_expression;
368: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

Line 366: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);

362: l_log_string := 'End construct_exprs_for_zone: Internal String:'
363: || x_int_intermedia_expression;
364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
365: l_log_string:= ' Purchase String: ' || x_purch_intermedia_expression;
366: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
367: l_log_string:= ' Both String: ' || x_both_intermedia_expression;
368: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
369: END IF;
370: EXCEPTION

Line 368: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

364: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
365: l_log_string:= ' Purchase String: ' || x_purch_intermedia_expression;
366: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name,l_api_name,l_log_string);
367: l_log_string:= ' Both String: ' || x_both_intermedia_expression;
368: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
369: END IF;
370: EXCEPTION
371: WHEN OTHERS THEN
372: ROLLBACK;

Line 400: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

396: l_supplier_and_site_expr VARCHAR2(32000);
397: BEGIN
398: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
399: l_log_string := 'Starting construct_supp_and_site_expr';
400: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
401: END IF;
402: l_err_loc := 100;
403:
404: -- initialize the expressions to ''

Line 539: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

535: l_err_loc := 3200;
536: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
537: l_log_string := 'End construct_supp_and_site_expr: Supplier and site expr is:'
538: || x_supplier_and_site_expr;
539: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
540: END IF;
541: EXCEPTION
542: WHEN OTHERS THEN
543: ROLLBACK;

Line 571: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

567: l_current_category_id_list VARCHAR2(32000);
568: BEGIN
569: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: l_log_string := 'Starting construct_category_expr';
571: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
572: END IF;
573: l_err_loc := 100;
574: -- initialize the expressions to ''
575: l_category_id_list := '';

Line 693: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

689: l_err_loc := 1800;
690: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
691: l_log_string := 'End construct_category_expr: Category expr is:'
692: || x_category_expr;
693: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
694: END IF;
695: EXCEPTION
696: WHEN OTHERS THEN
697: ROLLBACK;

Line 715: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

711: l_sqe_sequences ICX_TBL_NUMBER;
712: BEGIN
713: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
714: l_log_string := 'Starting purge_deleted_sqes';
715: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
716: END IF;
717:
718: l_err_loc := 100;
719:

Line 741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

737: FOR i in 1..l_sqe_sequences.COUNT LOOP
738: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
739: l_log_string := 'Removing sqes for sqe_sequence: ' || l_sqe_sequences(i);
740: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));

Line 762: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

758:
759: l_err_loc := 500;
760: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
761: l_log_string := 'End purge_deleted_sqes';
762: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
763: END IF;
764:
765: EXCEPTION
766: WHEN OTHERS THEN

Line 806: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

802: l_first_errored_zone PLS_INTEGER;
803: BEGIN
804: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
805: l_log_string := 'Starting sync_sqes_hier_change_internal';
806: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
807: END IF;
808: l_first_errored_zone := 1;
809: x_return_status := 'S';
810:

Line 862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

858: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
860: || ' to sqe_sequence: ' || l_sqe_sequences(i);
861: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
862: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
863: END IF;
864: ELSE
865: l_err_loc := 700;
866: x_return_status := 'E';

Line 870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

866: x_return_status := 'E';
867: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
868: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
869: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
870: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
871: END IF;
872: -- error
873: IF (l_first_errored_zone = 1) THEN
874: l_first_errored_zone := 0;

Line 893: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

889: WHERE zone_id = l_content_zone_ids(i);
890:
891: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
892: l_log_string := 'End sync_sqes_hier_change_internal';
893: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
894: END IF;
895: EXCEPTION
896: WHEN OTHERS THEN
897: ROLLBACK;

Line 927: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

923: l_token_list VARCHAR2(4000);
924: BEGIN
925: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
926: l_log_string := 'Starting sync_sqes_for_hierarchy_change';
927: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
928: END IF;
929: l_err_loc := 100;
930:
931: -- first start off with no error

Line 953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

949: IF (l_return_status = 'E') THEN
950: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
951: l_log_string := 'Could not sync sqes for some zones. Updating the job to error.';
952: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
953: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
954: END IF;
955: l_err_loc := 600;
956: -- update the job status to error
957: x_retcode := 1;

Line 982: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

978:
979: l_err_loc := 1100;
980: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
981: l_log_string := 'End sync_sqes_for_hierarchy_change';
982: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
983: END IF;
984:
985: EXCEPTION
986: WHEN OTHERS THEN

Line 1027: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

1023: l_errored_zone_name_list VARCHAR2(4000);
1024: BEGIN
1025: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1026: l_log_string := 'Starting sync_sqes_hier_change';
1027: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1028: END IF;
1029: l_err_loc := 100;
1030: -- call the main API to do the sync
1031: sync_sqes_hier_change_internal(x_return_status, l_errored_zone_name_list);

Line 1039: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1035: IF (x_return_status = 'E') THEN
1036: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1037: l_log_string := 'Could not sync sqes for some zones. Returning error.';
1038: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1039: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1040: END IF;
1041: l_err_loc := 800;
1042: INSERT INTO icx_por_failed_line_messages
1043: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,

Line 1060: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

1056:
1057: l_err_loc := 1000;
1058: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: l_log_string := 'End sync_sqes_hier_change';
1060: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1061: END IF;
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: ROLLBACK;

Line 1099: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);

1095: l_token_list VARCHAR2(4000);
1096: BEGIN
1097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: l_log_string := 'Starting sync_sqes_for_all_zones';
1099: ICX_CAT_UTIL_PVT.logProcBegin(g_pkg_name, l_api_name, l_log_string);
1100: END IF;
1101: -- first start off with no error
1102: l_first_errored_zone := 1;
1103:

Line 1154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1150: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: l_log_string := 'Succesfully updating the sequence for content_zone: ' || l_content_zone_ids(i)
1152: || ' to sqe_sequence: ' || l_sqe_sequences(i);
1153: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1154: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1155: END IF;
1156: ELSE
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);

Line 1160: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);

1156: ELSE
1157: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: l_log_string := 'Error for content_zone: ' || l_content_zone_ids(i) || ' sqe_sequence: ' || l_sqe_sequences(i);
1159: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1160: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
1161: END IF;
1162: l_err_loc := 700;
1163: -- error
1164: IF (l_first_errored_zone = 1) THEN

Line 1189: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);

1185:
1186: l_err_loc := 1000;
1187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1188: l_log_string := 'End sync_sqes_for_all_zones';
1189: ICX_CAT_UTIL_PVT.logProcEnd(g_pkg_name, l_api_name, l_log_string);
1190: END IF;
1191:
1192: EXCEPTION
1193: WHEN OTHERS THEN