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.ECE_EXTRACT_UTILS_PUB dependencies on ECE_EXTRACT_UTILS_PUB

Line 1: PACKAGE BODY ece_extract_utils_pub AS

1: PACKAGE BODY ece_extract_utils_pub AS
2: -- $Header: ECPEXTUB.pls 120.2 2005/09/29 11:39:23 arsriniv ship $
3: debug_mode_on_insert BOOLEAN := FALSE;
4: debug_mode_on_select BOOLEAN := FALSE;
5: debug_mode_on_prod BOOLEAN := FALSE;

Line 44: EC_DEBUG.PUSH('ece_extract_utils_pub.select_clause');

40:
41: iRow_count NUMBER := p_source_tbl.count;
42: iDebug NUMBER := 0;
43: BEGIN
44: EC_DEBUG.PUSH('ece_extract_utils_pub.select_clause');
45: if EC_DEBUG.G_debug_level >= 2 then
46: EC_DEBUG.PL(3, 'cTransaction_Type : ',cTransaction_Type);
47: EC_DEBUG.PL(3, 'cCommunication_Method: ',cCommunication_Method);
48: end if;

Line 133: EC_DEBUG.POP('ece_extract_utils_pub.select_clause');

129: values( sysdate, 76451, ece_error_s.nextval, stmt_3);
130: end;
131: end if;
132:
133: EC_DEBUG.POP('ece_extract_utils_pub.select_clause');
134: exception
135: when others then
136: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Select_Clause');
137: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');

Line 136: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Select_Clause');

132:
133: EC_DEBUG.POP('ece_extract_utils_pub.select_clause');
134: exception
135: when others then
136: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Select_Clause');
137: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
138: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
139: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
140:

Line 223: EC_DEBUG.PUSH('ece_extract_utils_pub.insert_into_interface_tbl');

219:
220: BEGIN
221:
222: if EC_DEBUG.G_debug_level >= 2 then
223: EC_DEBUG.PUSH('ece_extract_utils_pub.insert_into_interface_tbl');
224: EC_DEBUG.PL(3, 'iRun_id : ',iRun_id);
225: EC_DEBUG.PL(3, 'cTransaction_Type: ',cTransaction_Type);
226: EC_DEBUG.PL(3, 'cCommunication_Method: ',cCommunication_Method);
227: EC_DEBUG.PL(3, 'cInterface_Table: ',cInterface_Table);

Line 509: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_interface_tbl');

505: xProgress := 'EXTUB-20-1230';
506: dbms_sql.close_cursor(c_Insert_cur);
507:
508: if EC_DEBUG.G_debug_level >= 2 then
509: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_interface_tbl');
510: end if;
511: exception
512: when others
513: then

Line 514: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl');

510: end if;
511: exception
512: when others
513: then
514: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl');
515: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
516: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
517: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
518:

Line 712: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface');

708: xProgress := 'EXTUB-30-1280';
709: dummy := dbms_sql.execute(p_Insert_cur);
710: exception
711: when others then
712: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface');
713: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
714: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
715: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', g_error_count);
716:

Line 785: EC_DEBUG.PUSH('ece_extract_utils_pub.insert_into_prod_interface_pvt');

781: n_number NUMBER;
782: c_count NUMBER;
783:
784: BEGIN
785: EC_DEBUG.PUSH('ece_extract_utils_pub.insert_into_prod_interface_pvt');
786: if EC_DEBUG.G_debug_level >= 2 then
787: EC_DEBUG.PL(3, 'p_api_version_number : ',p_api_version_number);
788: EC_DEBUG.PL(3, 'p_init_msg_list: ',p_init_msg_list);
789: EC_DEBUG.PL(3, 'p_simulate: ',p_simulate);

Line 989: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface_pvt');

985: dummy := dbms_sql.execute(p_Insert_cur);
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface_pvt');
990: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
991: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
992:
993: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');

Line 1031: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_prod_interface_pvt');

1027: -- Standard call to get message count and if count is 1, get message info.
1028: fnd_msg_pub.count_and_get(
1029: p_count => x_msg_count,
1030: p_data => x_msg_data);
1031: EC_DEBUG.POP('ece_extract_utils_pub.insert_into_prod_interface_pvt');
1032:
1033: EXCEPTION
1034: WHEN fnd_api.g_exc_error THEN
1035: ROLLBACK TO insert_into_prod_interface_pvt;

Line 1080: ec_debug.push('ECE_EXTRACT_UTILS_PUB.FIND_POS');

1076: pos_not_found EXCEPTION;
1077: cOutput_path VARCHAR2(120);
1078:
1079: BEGIN
1080: ec_debug.push('ECE_EXTRACT_UTILS_PUB.FIND_POS');
1081: if EC_DEBUG.G_debug_level >= 2 then
1082: ec_debug.pl(3,'p_in_text: ',p_in_text);
1083: end if;
1084: FOR k IN 1..l_row_count LOOP

Line 1099: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.FIND_POS');

1095: IF NOT b_found THEN
1096: RAISE pos_not_found;
1097: END IF;
1098:
1099: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.FIND_POS');
1100:
1101: EXCEPTION
1102: WHEN pos_not_found THEN
1103: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME',cIn_string);

Line 1107: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.FIND_POS');

1103: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME',cIn_string);
1104: app_exception.raise_exception;
1105:
1106: WHEN OTHERS THEN
1107: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.FIND_POS');
1108: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1109: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1110: app_exception.raise_exception;
1111:

Line 1123: EC_DEBUG.PUSH('ece_extract_utils_pub.POS_OF');

1119: b_found BOOLEAN := FALSE;
1120: pos_not_found EXCEPTION;
1121: cOutput_path VARCHAR2(120);
1122: BEGIN
1123: EC_DEBUG.PUSH('ece_extract_utils_pub.POS_OF');
1124: if EC_DEBUG.G_debug_level >= 2 then
1125: EC_DEBUG.PL(3, 'cCol_name: ',cCol_name);
1126: end if;
1127:

Line 1134: EC_DEBUG.POP('ece_extract_utils_pub.POS_OF');

1130: b_found := TRUE;
1131: if EC_DEBUG.G_debug_level >= 2 then
1132: EC_DEBUG.PL(3, 'k: ',k);
1133: end if;
1134: EC_DEBUG.POP('ece_extract_utils_pub.POS_OF');
1135: return(k);
1136: exit;
1137: end if;
1138: end loop;

Line 1150: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.POS_OF');

1146: WHEN pos_not_found THEN
1147: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'upper(cCol_name)');
1148: app_exception.raise_exception;
1149: WHEN OTHERS THEN
1150: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.POS_OF');
1151: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1152: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1153: app_exception.raise_exception;
1154: END pos_of;

Line 1171: ec_debug.push('ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');

1167: cOutput_path VARCHAR2(120);
1168:
1169: BEGIN
1170: if EC_DEBUG.G_debug_level >= 2 then
1171: ec_debug.push('ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');
1172: ec_debug.pl(3,'p_in_text: ',p_in_text);
1173: end if;
1174: FOR k IN 1..l_row_count LOOP
1175: IF UPPER(NVL(l_plsql_tbl(k).ext_column_name,'NULL')) = cIn_string THEN

Line 1190: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');

1186:
1187: if EC_DEBUG.G_debug_level >= 2 then
1188: ec_debug.pl(3,'p_position: ',p_position);
1189: ec_debug.pl(3,'o_value: ',o_value);
1190: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');
1191: end if;
1192:
1193: EXCEPTION
1194: WHEN pos_not_found THEN

Line 1199: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');

1195: ec_debug.pl(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME',cIn_string);
1196: app_exception.raise_exception;
1197:
1198: WHEN OTHERS THEN
1199: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');
1200: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: app_exception.raise_exception;
1203: END ext_get_value;

Line 1212: ec_debug.push('ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');

1208: p_value IN varchar2)
1209: IS
1210: BEGIN
1211: if EC_DEBUG.G_debug_level >= 2 then
1212: ec_debug.push('ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');
1213: ec_debug.pl(3,'p_position: ',p_position);
1214: ec_debug.pl(3,'p_value: ',p_value);
1215: end if;
1216: l_plsql_tbl(p_position).value := p_value;

Line 1219: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');

1215: end if;
1216: l_plsql_tbl(p_position).value := p_value;
1217:
1218: if EC_DEBUG.G_debug_level >= 2 then
1219: ec_debug.pop('ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');
1220: end if;
1221:
1222: EXCEPTION
1223: WHEN OTHERS THEN

Line 1224: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');

1220: end if;
1221:
1222: EXCEPTION
1223: WHEN OTHERS THEN
1224: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');
1225: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1226: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1227: app_exception.raise_exception;
1228: end ext_insert_value;

Line 1230: END ece_extract_utils_pub;

1226: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1227: app_exception.raise_exception;
1228: end ext_insert_value;
1229:
1230: END ece_extract_utils_pub;
1231: