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.MTH_EQUIPMENT_PKG dependencies on MTH_UTIL_PKG

Line 29: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);

25: v_error_code_2 VARCHAR2(4000) DEFAULT NULL;
26: v_error_code_3 VARCHAR2(1);
27:
28: BEGIN
29: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
30:
31: -- Initialize default parameters
32: v_log_date := sysdate;
33: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 33: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

29: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
30:
31: -- Initialize default parameters
32: v_log_date := sysdate;
33: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
34:
35: -- validate the group id
36: v_error_code_1 := VALIDATE_GROUP_ID();
37:

Line 53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);

49:
50: IF (v_error_code_1 IS NULL AND v_error_code_2 IS NULL ) THEN
51:
52: -- Call mth_run_log_pre_load
53: -- mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_date);
54: -- Moved to call to inside MTH_POPULATE_EQUIP_DENORM
55:
56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();

Line 60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);

56: -- call the procedure to populate entries into denorm table if the validations are successful
57: MTH_POPULATE_EQUIP_DENORM();
58:
59: -- Call mth_run_log_post_load
60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);
61:
62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);
64: END IF;

Line 63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);

59: -- Call mth_run_log_post_load
60: mth_util_pkg.mth_run_log_post_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val);
61:
62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);
64: END IF;
65:
66: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
67:

Line 66: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

62: ELSE
63: mth_util_pkg.log_msg('Validations failed. Check log for more details',mth_util_pkg.G_DBG_EXCEPTION);
64: END IF;
65:
66: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
67:
68: COMMIT;
69: EXCEPTION
70: WHEN OTHERS THEN

Line 72: mth_util_pkg.log_msg('Exception OTHERS in MTH_LOAD_EQUIP_HIER_DENORM', mth_util_pkg.G_DBG_EXCEPTION);

68: COMMIT;
69: EXCEPTION
70: WHEN OTHERS THEN
71: --Call logging API and then throw exception
72: mth_util_pkg.log_msg('Exception OTHERS in MTH_LOAD_EQUIP_HIER_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
73: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
74: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
75: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
76: ROLLBACK;

Line 73: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

69: EXCEPTION
70: WHEN OTHERS THEN
71: --Call logging API and then throw exception
72: mth_util_pkg.log_msg('Exception OTHERS in MTH_LOAD_EQUIP_HIER_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
73: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
74: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
75: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
76: ROLLBACK;
77: RAISE;

Line 74: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

70: WHEN OTHERS THEN
71: --Call logging API and then throw exception
72: mth_util_pkg.log_msg('Exception OTHERS in MTH_LOAD_EQUIP_HIER_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
73: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
74: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
75: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
76: ROLLBACK;
77: RAISE;
78: END;

Line 75: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

71: --Call logging API and then throw exception
72: mth_util_pkg.log_msg('Exception OTHERS in MTH_LOAD_EQUIP_HIER_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
73: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
74: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
75: mth_util_pkg.log_msg('MTH_LOAD_EQUIP_HIER_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
76: ROLLBACK;
77: RAISE;
78: END;
79:

Line 112: mth_util_pkg.log_msg('VALIDATE_GROUP_ID start', mth_util_pkg.G_DBG_PROC_FUN_START);

108: v_limit NUMBER :=5000;
109:
110: BEGIN
111:
112: mth_util_pkg.log_msg('VALIDATE_GROUP_ID start', mth_util_pkg.G_DBG_PROC_FUN_START);
113: OPEN c_equip_hierarchy FOR 'Select NVL(GROUP_ID, 1) GROUP_ID, LEVEL_FK_KEY, HIERARCHY_ID, LEVEL_NUM, EFFECTIVE_DATE
114: FROM MTH_EQUIP_HIERARCHY
115: ORDER BY HIERARCHY_ID, LEVEL_NUM, LEVEL_FK_KEY, EFFECTIVE_DATE ';
116: FETCH c_equip_hierarchy BULK COLLECT INTO r_equip_hierarchy.GROUP_ID,

Line 128: mth_util_pkg.log_msg(r_equip_hierarchy.LEVEL_FK_KEY(i) || ' has failed the validation for group id for the pair ' ||

124: AND r_equip_hierarchy.LEVEL_NUM(i+1) = r_equip_hierarchy.LEVEL_NUM(i)
125: AND r_equip_hierarchy.LEVEL_FK_KEY(i+1) = r_equip_hierarchy.LEVEL_FK_KEY(i)
126: AND r_equip_hierarchy.EFFECTIVE_DATE(i+1) > r_equip_hierarchy.EFFECTIVE_DATE(i)
127: AND r_equip_hierarchy.GROUP_ID(i+1) < r_equip_hierarchy.GROUP_ID(i))THEN
128: mth_util_pkg.log_msg(r_equip_hierarchy.LEVEL_FK_KEY(i) || ' has failed the validation for group id for the pair ' ||
129: '(' ||r_equip_hierarchy.GROUP_ID(i) || ' , ' ||r_equip_hierarchy.EFFECTIVE_DATE(i) || ')' || ' , ' ||
130: ' (' ||r_equip_hierarchy.GROUP_ID(i+1) || ' , ' ||r_equip_hierarchy.EFFECTIVE_DATE(i+1) || ') ',mth_util_pkg.G_DBG_EXCEPTION);
131: v_error_flag := 1;
132: END IF;

Line 130: ' (' ||r_equip_hierarchy.GROUP_ID(i+1) || ' , ' ||r_equip_hierarchy.EFFECTIVE_DATE(i+1) || ') ',mth_util_pkg.G_DBG_EXCEPTION);

126: AND r_equip_hierarchy.EFFECTIVE_DATE(i+1) > r_equip_hierarchy.EFFECTIVE_DATE(i)
127: AND r_equip_hierarchy.GROUP_ID(i+1) < r_equip_hierarchy.GROUP_ID(i))THEN
128: mth_util_pkg.log_msg(r_equip_hierarchy.LEVEL_FK_KEY(i) || ' has failed the validation for group id for the pair ' ||
129: '(' ||r_equip_hierarchy.GROUP_ID(i) || ' , ' ||r_equip_hierarchy.EFFECTIVE_DATE(i) || ')' || ' , ' ||
130: ' (' ||r_equip_hierarchy.GROUP_ID(i+1) || ' , ' ||r_equip_hierarchy.EFFECTIVE_DATE(i+1) || ') ',mth_util_pkg.G_DBG_EXCEPTION);
131: v_error_flag := 1;
132: END IF;
133: END LOOP;
134: CLOSE c_equip_hierarchy ;

Line 138: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);

134: CLOSE c_equip_hierarchy ;
135: IF(v_error_flag = 1) THEN
136: v_error_code := v_error_code || ' Data contains invalid group id(s). Please check the log for more details.';
137: END IF;
138: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);
139: RETURN v_error_code ;
140:
141: --COMMIT;
142: EXCEPTION

Line 145: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_GROUP_ID', mth_util_pkg.G_DBG_EXCEPTION);

141: --COMMIT;
142: EXCEPTION
143: WHEN OTHERS THEN
144: --Call logging API and then throw exception
145: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_GROUP_ID', mth_util_pkg.G_DBG_EXCEPTION);
146: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
147: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
148: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);
149: ROLLBACK;

Line 146: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

142: EXCEPTION
143: WHEN OTHERS THEN
144: --Call logging API and then throw exception
145: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_GROUP_ID', mth_util_pkg.G_DBG_EXCEPTION);
146: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
147: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
148: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);
149: ROLLBACK;
150: RAISE;

Line 147: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

143: WHEN OTHERS THEN
144: --Call logging API and then throw exception
145: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_GROUP_ID', mth_util_pkg.G_DBG_EXCEPTION);
146: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
147: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
148: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);
149: ROLLBACK;
150: RAISE;
151:

Line 148: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);

144: --Call logging API and then throw exception
145: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_GROUP_ID', mth_util_pkg.G_DBG_EXCEPTION);
146: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
147: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
148: mth_util_pkg.log_msg('VALIDATE_GROUP_ID end', mth_util_pkg.G_DBG_PROC_FUN_END);
149: ROLLBACK;
150: RAISE;
151:
152: END ;

Line 192: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL start', mth_util_pkg.G_DBG_PROC_FUN_START);

188: r_equip_hierarchy c_equip_hierarchy%ROWTYPE ;
189:
190: BEGIN
191:
192: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL start', mth_util_pkg.G_DBG_PROC_FUN_START);
193:
194: OPEN c_equip_hierarchy ;
195: LOOP
196: FETCH c_equip_hierarchy INTO r_equip_hierarchy ;

Line 199: mth_util_pkg.log_msg(' Child ' || r_equip_hierarchy.child_level_fk_key || ' is missing parent ' || r_equip_hierarchy.parent_fk_key,mth_util_pkg.G_DBG_EXCEPTION);

195: LOOP
196: FETCH c_equip_hierarchy INTO r_equip_hierarchy ;
197: EXIT WHEN c_equip_hierarchy%NOTFOUND ;
198: IF (r_equip_hierarchy.parent_level_fk_key IS NULL)THEN
199: mth_util_pkg.log_msg(' Child ' || r_equip_hierarchy.child_level_fk_key || ' is missing parent ' || r_equip_hierarchy.parent_fk_key,mth_util_pkg.G_DBG_EXCEPTION);
200: v_error_flag_mp := 1;
201: END IF;
202:
203: IF (r_equip_hierarchy.parent_date > r_equip_hierarchy.child_date )THEN

Line 204: mth_util_pkg.log_msg(' Child ' || r_equip_hierarchy.child_level_fk_key || ' has non existent parent : ' || r_equip_hierarchy.parent_fk_key,mth_util_pkg.G_DBG_EXCEPTION);

200: v_error_flag_mp := 1;
201: END IF;
202:
203: IF (r_equip_hierarchy.parent_date > r_equip_hierarchy.child_date )THEN
204: mth_util_pkg.log_msg(' Child ' || r_equip_hierarchy.child_level_fk_key || ' has non existent parent : ' || r_equip_hierarchy.parent_fk_key,mth_util_pkg.G_DBG_EXCEPTION);
205: v_error_flag_nep := 1;
206: END IF;
207:
208: END LOOP;

Line 216: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);

212: END IF;
213: IF(v_error_flag_nep = 1) THEN
214: v_error_code := v_error_code || ' Child entities are having non existent parents. Please check the log for more details.';
215: END IF;
216: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);
217: RETURN v_error_code ;
218:
219:
220: --COMMIT;

Line 224: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_CHILD_PARENT_REL', mth_util_pkg.G_DBG_EXCEPTION);

220: --COMMIT;
221: EXCEPTION
222: WHEN OTHERS THEN
223: --Call logging API and then throw exception
224: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_CHILD_PARENT_REL', mth_util_pkg.G_DBG_EXCEPTION);
225: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
226: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
227: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);
228: ROLLBACK;

Line 225: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

221: EXCEPTION
222: WHEN OTHERS THEN
223: --Call logging API and then throw exception
224: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_CHILD_PARENT_REL', mth_util_pkg.G_DBG_EXCEPTION);
225: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
226: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
227: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);
228: ROLLBACK;
229: RAISE;

Line 226: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

222: WHEN OTHERS THEN
223: --Call logging API and then throw exception
224: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_CHILD_PARENT_REL', mth_util_pkg.G_DBG_EXCEPTION);
225: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
226: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
227: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);
228: ROLLBACK;
229: RAISE;
230:

Line 227: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);

223: --Call logging API and then throw exception
224: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_CHILD_PARENT_REL', mth_util_pkg.G_DBG_EXCEPTION);
225: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
226: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
227: mth_util_pkg.log_msg('VALIDATE_CHILD_PARENT_REL end', mth_util_pkg.G_DBG_PROC_FUN_END);
228: ROLLBACK;
229: RAISE;
230:
231: END ;

Line 371: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);

367: is_invalid VARCHAR2(1);
368:
369: BEGIN
370:
371: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
372: mth_util_pkg.log_msg('p_print_message = ' || p_print_message , mth_util_pkg.G_DBG_PARAM_VAL);
373:
374: is_invalid := 'N';
375:

Line 372: mth_util_pkg.log_msg('p_print_message = ' || p_print_message , mth_util_pkg.G_DBG_PARAM_VAL);

368:
369: BEGIN
370:
371: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
372: mth_util_pkg.log_msg('p_print_message = ' || p_print_message , mth_util_pkg.G_DBG_PARAM_VAL);
373:
374: is_invalid := 'N';
375:
376: IF nvl(p_print_message,'N') = 'N' THEN

Line 391: mth_util_pkg.log_msg('In hierarhcy with ID ' || r_equip_hierarchy_dtl.HIERARCHY_ID || ' level_num ' ||

387: LOOP
388: FETCH c_equip_hierarchy_dtl INTO r_equip_hierarchy_dtl;
389: EXIT WHEN c_equip_hierarchy_dtl%NOTFOUND;
390: is_invalid := 'Y';
391: mth_util_pkg.log_msg('In hierarhcy with ID ' || r_equip_hierarchy_dtl.HIERARCHY_ID || ' level_num ' ||
392: r_equip_hierarchy_dtl.LEVEL_NUM || ' ' || r_equip_hierarchy_dtl.LEVEL_NAME || '(' ||
393: r_equip_hierarchy_dtl.LEVEL_FK_KEY || ') is moved to parent with key ' || r_equip_hierarchy_dtl.PARENT_FK_KEY ||
394: ' as on ' || to_char(r_equip_hierarchy_dtl.EFFECTIVE_DATE,'DD-MON-YYYY HH24:MI:SS') ||
395: ' while it has a child - ' || r_equip_hierarchy_dtl.CHILD_LEVEL_NAME || ' - at level_num ' ||

Line 397: to_char(r_equip_hierarchy_dtl.CHILD_EFFECTIVE_DATE,'DD-MON-YYYY HH24:MI:SS') || ').', mth_util_pkg.G_DBG_EXCEPTION);

393: r_equip_hierarchy_dtl.LEVEL_FK_KEY || ') is moved to parent with key ' || r_equip_hierarchy_dtl.PARENT_FK_KEY ||
394: ' as on ' || to_char(r_equip_hierarchy_dtl.EFFECTIVE_DATE,'DD-MON-YYYY HH24:MI:SS') ||
395: ' while it has a child - ' || r_equip_hierarchy_dtl.CHILD_LEVEL_NAME || ' - at level_num ' ||
396: r_equip_hierarchy_dtl.CHILD_LEVEL_NUM || ' with a later effective date (' ||
397: to_char(r_equip_hierarchy_dtl.CHILD_EFFECTIVE_DATE,'DD-MON-YYYY HH24:MI:SS') || ').', mth_util_pkg.G_DBG_EXCEPTION);
398: END LOOP;
399: END IF;
400:
401: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 401: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);

397: to_char(r_equip_hierarchy_dtl.CHILD_EFFECTIVE_DATE,'DD-MON-YYYY HH24:MI:SS') || ').', mth_util_pkg.G_DBG_EXCEPTION);
398: END LOOP;
399: END IF;
400:
401: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
402: RETURN is_invalid ;
403:
404:
405: --COMMIT;

Line 409: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_PARENT_MOVE_DATE', mth_util_pkg.G_DBG_EXCEPTION);

405: --COMMIT;
406: EXCEPTION
407: WHEN OTHERS THEN
408: --Call logging API and then throw exception
409: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_PARENT_MOVE_DATE', mth_util_pkg.G_DBG_EXCEPTION);
410: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
411: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
412: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
413: ROLLBACK;

Line 410: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

406: EXCEPTION
407: WHEN OTHERS THEN
408: --Call logging API and then throw exception
409: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_PARENT_MOVE_DATE', mth_util_pkg.G_DBG_EXCEPTION);
410: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
411: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
412: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
413: ROLLBACK;
414: RAISE;

Line 411: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

407: WHEN OTHERS THEN
408: --Call logging API and then throw exception
409: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_PARENT_MOVE_DATE', mth_util_pkg.G_DBG_EXCEPTION);
410: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
411: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
412: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
413: ROLLBACK;
414: RAISE;
415:

Line 412: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);

408: --Call logging API and then throw exception
409: mth_util_pkg.log_msg('Exception OTHERS in VALIDATE_PARENT_MOVE_DATE', mth_util_pkg.G_DBG_EXCEPTION);
410: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
411: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
412: mth_util_pkg.log_msg('VALIDATE_PARENT_MOVE_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
413: ROLLBACK;
414: RAISE;
415:
416: END ;

Line 471: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);

467:
468: r_equip_hierarchy c_equip_hierarchy%ROWTYPE ;
469:
470: BEGIN
471: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
472:
473: -- Initialize default parameters
474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

471: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
472:
473: -- Initialize default parameters
474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:

Line 477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);

473: -- Initialize default parameters
474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:
480:
481: open c_equip_hierarchy(v_log_from_date,v_log_to_date);

Line 478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

474: v_log_to_date := sysdate;
475: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
476:
477: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIPMENT_DENORM_D',v_unassigned_val,'INCR',NULL,0,v_log_to_date);
478: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIPMENT_DENORM_D',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
479:
480:
481: open c_equip_hierarchy(v_log_from_date,v_log_to_date);
482: loop

Line 498: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

494:
495: END IF ;
496: end loop;
497: close c_equip_hierarchy ;
498: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
499:
500: --COMMIT;
501: EXCEPTION
502: WHEN OTHERS THEN

Line 504: mth_util_pkg.log_msg('Exception OTHERS in MTH_POPULATE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);

500: --COMMIT;
501: EXCEPTION
502: WHEN OTHERS THEN
503: --Call logging API and then throw exception
504: mth_util_pkg.log_msg('Exception OTHERS in MTH_POPULATE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
505: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
506: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
507: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
508: ROLLBACK;

Line 505: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

501: EXCEPTION
502: WHEN OTHERS THEN
503: --Call logging API and then throw exception
504: mth_util_pkg.log_msg('Exception OTHERS in MTH_POPULATE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
505: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
506: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
507: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
508: ROLLBACK;
509: RAISE;

Line 506: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

502: WHEN OTHERS THEN
503: --Call logging API and then throw exception
504: mth_util_pkg.log_msg('Exception OTHERS in MTH_POPULATE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
505: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
506: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
507: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
508: ROLLBACK;
509: RAISE;
510:

Line 507: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

503: --Call logging API and then throw exception
504: mth_util_pkg.log_msg('Exception OTHERS in MTH_POPULATE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
505: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
506: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
507: mth_util_pkg.log_msg('MTH_POPULATE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
508: ROLLBACK;
509: RAISE;
510:
511: END ;

Line 596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);

592:
593:
594: BEGIN
595:
596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);

Line 597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);

593:
594: BEGIN
595:
596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);

Line 598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);

594: BEGIN
595:
596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);

Line 599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);

595:
596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
603:

Line 600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);

596: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
603:
604: -- Initialize default parameters

Line 601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);

597: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
603:
604: -- Initialize default parameters
605: v_log_date := sysdate;

Line 602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);

598: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
599: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
600: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
601: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
603:
604: -- Initialize default parameters
605: v_log_date := sysdate;
606: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 606: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

602: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
603:
604: -- Initialize default parameters
605: v_log_date := sysdate;
606: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
607: v_count := 0;
608:
609: -- load v_row with the ancestors for the specified entry to be inserted into the denorm table
610:

Line 617: mth_util_pkg.log_msg('-- c_equip_denorm%NOTFOUND',mth_util_pkg.G_DBG_VAR_VAL);

613: fetch c_equip_denorm into r_equip_denorm ;
614: /*Ensure that an insert happens even when denorm table is empty and the parent cursor does not return any row*/
615: exit when (c_equip_denorm%NOTFOUND AND v_count > 0) ;
616: if (c_equip_denorm%NOTFOUND) then
617: mth_util_pkg.log_msg('-- c_equip_denorm%NOTFOUND',mth_util_pkg.G_DBG_VAR_VAL);
618: end if;
619:
620: IF (p_level_num > 1) THEN
621: v_row.level1_hierarchy_key := r_equip_denorm.level1_hierarchy_key;

Line 1031: mth_util_pkg.log_msg('Dimension_key inserted - ' || v_dimension_key, mth_util_pkg.G_DBG_VAR_VAL);

1027: v_row.last_update_login,
1028: v_row.level_num
1029: )
1030: RETURNING dimension_key INTO v_dimension_key;
1031: mth_util_pkg.log_msg('Dimension_key inserted - ' || v_dimension_key, mth_util_pkg.G_DBG_VAR_VAL);
1032: v_count := 1;
1033: end loop;
1034: close c_equip_denorm ;
1035:

Line 1036: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

1032: v_count := 1;
1033: end loop;
1034: close c_equip_denorm ;
1035:
1036: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1037:
1038: --COMMIT;
1039: EXCEPTION
1040: WHEN OTHERS THEN

Line 1042: mth_util_pkg.log_msg('Exception OTHERS in MTH_INSERT_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);

1038: --COMMIT;
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: --Call logging API and then throw exception
1042: mth_util_pkg.log_msg('Exception OTHERS in MTH_INSERT_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1043: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1044: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1045: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1046: ROLLBACK;

Line 1043: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: --Call logging API and then throw exception
1042: mth_util_pkg.log_msg('Exception OTHERS in MTH_INSERT_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1043: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1044: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1045: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1046: ROLLBACK;
1047: RAISE;

Line 1044: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

1040: WHEN OTHERS THEN
1041: --Call logging API and then throw exception
1042: mth_util_pkg.log_msg('Exception OTHERS in MTH_INSERT_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1043: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1044: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1045: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1046: ROLLBACK;
1047: RAISE;
1048:

Line 1045: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

1041: --Call logging API and then throw exception
1042: mth_util_pkg.log_msg('Exception OTHERS in MTH_INSERT_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1043: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1044: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1045: mth_util_pkg.log_msg('MTH_INSERT_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1046: ROLLBACK;
1047: RAISE;
1048:
1049: END ;

Line 1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);

1084: r_move_equip_denorm MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1085: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1086:
1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);

Line 1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);

1085: v_row MTH_EQUIPMENT_DENORM_D%ROWTYPE;
1086:
1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);

Line 1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);

1086:
1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);

Line 1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);

1087: BEGIN
1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
1095:

Line 1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);

1088: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM start', mth_util_pkg.G_DBG_PROC_FUN_START);
1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
1095:
1096: -- Initialize default parameters

Line 1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);

1089: mth_util_pkg.log_msg('p_level_fk_key = ' || p_level_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
1095:
1096: -- Initialize default parameters
1097: v_log_date := sysdate;

Line 1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);

1090: mth_util_pkg.log_msg('p_parent_fk_key = ' || p_parent_fk_key , mth_util_pkg.G_DBG_PARAM_VAL);
1091: mth_util_pkg.log_msg('p_hierarchy_id = ' || p_hierarchy_id , mth_util_pkg.G_DBG_PARAM_VAL);
1092: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1093: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
1095:
1096: -- Initialize default parameters
1097: v_log_date := sysdate;
1098: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 1098: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

1094: mth_util_pkg.log_msg('p_level_name = ' || p_level_name , mth_util_pkg.G_DBG_PARAM_VAL);
1095:
1096: -- Initialize default parameters
1097: v_log_date := sysdate;
1098: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1099:
1100: /*Select the entry at given level to be moved, along with its children*/
1101:
1102:

Line 1210: mth_util_pkg.log_msg('r_move_equip_denorm.level_num = ' || r_move_equip_denorm.level_num,mth_util_pkg.G_DBG_VAR_VAL);

1206: LOOP
1207: fetch c_move_equip_denorm into r_move_equip_denorm ;
1208: exit when c_move_equip_denorm%NOTFOUND ;
1209:
1210: mth_util_pkg.log_msg('r_move_equip_denorm.level_num = ' || r_move_equip_denorm.level_num,mth_util_pkg.G_DBG_VAR_VAL);
1211:
1212: /*Check if the parent entry is to be moved- usually the first row from the above result set*/
1213: IF(r_move_equip_denorm.level_num = p_level_num)THEN
1214:

Line 1272: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

1268: CLOSE c_move_equip_denorm ;
1269:
1270:
1271:
1272: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1273:
1274: --COMMIT;
1275: EXCEPTION
1276: WHEN OTHERS THEN

Line 1278: mth_util_pkg.log_msg('Exception OTHERS in MTH_MOVE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);

1274: --COMMIT;
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: --Call logging API and then throw exception
1278: mth_util_pkg.log_msg('Exception OTHERS in MTH_MOVE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1279: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1280: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1281: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1282: ROLLBACK;

Line 1279: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: --Call logging API and then throw exception
1278: mth_util_pkg.log_msg('Exception OTHERS in MTH_MOVE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1279: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1280: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1281: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1282: ROLLBACK;
1283: RAISE;

Line 1280: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

1276: WHEN OTHERS THEN
1277: --Call logging API and then throw exception
1278: mth_util_pkg.log_msg('Exception OTHERS in MTH_MOVE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1279: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1280: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1281: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1282: ROLLBACK;
1283: RAISE;
1284: END;

Line 1281: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);

1277: --Call logging API and then throw exception
1278: mth_util_pkg.log_msg('Exception OTHERS in MTH_MOVE_EQUIP_DENORM', mth_util_pkg.G_DBG_EXCEPTION);
1279: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1280: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1281: mth_util_pkg.log_msg('MTH_MOVE_EQUIP_DENORM end', mth_util_pkg.G_DBG_PROC_FUN_END);
1282: ROLLBACK;
1283: RAISE;
1284: END;
1285: /*******************************************************************************

Line 1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);

1309: r_expire_denorm mth_equipment_denorm_d%ROWTYPE;
1310: v_expiration_date DATE;
1311:
1312: BEGIN
1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
1314: mth_util_pkg.log_msg('p_dimension_key = ' || p_dimension_key , mth_util_pkg.G_DBG_PARAM_VAL);
1315: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1317:

Line 1314: mth_util_pkg.log_msg('p_dimension_key = ' || p_dimension_key , mth_util_pkg.G_DBG_PARAM_VAL);

1310: v_expiration_date DATE;
1311:
1312: BEGIN
1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
1314: mth_util_pkg.log_msg('p_dimension_key = ' || p_dimension_key , mth_util_pkg.G_DBG_PARAM_VAL);
1315: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1317:
1318: -- Initialize default parameters

Line 1315: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);

1311:
1312: BEGIN
1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
1314: mth_util_pkg.log_msg('p_dimension_key = ' || p_dimension_key , mth_util_pkg.G_DBG_PARAM_VAL);
1315: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1317:
1318: -- Initialize default parameters
1319: v_log_date := sysdate;

Line 1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);

1312: BEGIN
1313: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE start', mth_util_pkg.G_DBG_PROC_FUN_START);
1314: mth_util_pkg.log_msg('p_dimension_key = ' || p_dimension_key , mth_util_pkg.G_DBG_PARAM_VAL);
1315: mth_util_pkg.log_msg('p_level_num = ' || p_level_num , mth_util_pkg.G_DBG_PARAM_VAL);
1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1317:
1318: -- Initialize default parameters
1319: v_log_date := sysdate;
1320: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

Line 1320: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

1316: mth_util_pkg.log_msg('p_effective_date = ' || to_char(p_effective_date,'DD-MON-YYYY HH24:MI:SS') , mth_util_pkg.G_DBG_PARAM_VAL);
1317:
1318: -- Initialize default parameters
1319: v_log_date := sysdate;
1320: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1321: v_expiration_date := p_effective_date - 1/86400;
1322:
1323: /*For the levels 2-10, set the expiration date based on the dimension key.Also pick the parent row information for filling in the
1324: expiration dates for the rest of the parent levels */

Line 1460: mth_util_pkg.log_msg('Number of rows updated - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1456: WHERE dimension_key = p_dimension_key
1457: AND level_num = 10;
1458:
1459: END IF;
1460: mth_util_pkg.log_msg('Number of rows updated - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1461: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1462:
1463: --COMMIT;
1464: EXCEPTION

Line 1461: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);

1457: AND level_num = 10;
1458:
1459: END IF;
1460: mth_util_pkg.log_msg('Number of rows updated - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1461: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1462:
1463: --COMMIT;
1464: EXCEPTION
1465: WHEN OTHERS THEN

Line 1467: mth_util_pkg.log_msg('Exception OTHERS in MTH_SET_EXPIRATION_DATE', mth_util_pkg.G_DBG_EXCEPTION);

1463: --COMMIT;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: --Call logging API and then throw exception
1467: mth_util_pkg.log_msg('Exception OTHERS in MTH_SET_EXPIRATION_DATE', mth_util_pkg.G_DBG_EXCEPTION);
1468: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1469: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1470: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1471: ROLLBACK;

Line 1468: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: --Call logging API and then throw exception
1467: mth_util_pkg.log_msg('Exception OTHERS in MTH_SET_EXPIRATION_DATE', mth_util_pkg.G_DBG_EXCEPTION);
1468: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1469: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1470: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1471: ROLLBACK;
1472: RAISE;

Line 1469: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

1465: WHEN OTHERS THEN
1466: --Call logging API and then throw exception
1467: mth_util_pkg.log_msg('Exception OTHERS in MTH_SET_EXPIRATION_DATE', mth_util_pkg.G_DBG_EXCEPTION);
1468: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1469: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1470: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1471: ROLLBACK;
1472: RAISE;
1473: END;

Line 1470: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);

1466: --Call logging API and then throw exception
1467: mth_util_pkg.log_msg('Exception OTHERS in MTH_SET_EXPIRATION_DATE', mth_util_pkg.G_DBG_EXCEPTION);
1468: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1469: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1470: mth_util_pkg.log_msg('MTH_SET_EXPIRATION_DATE end', mth_util_pkg.G_DBG_PROC_FUN_END);
1471: ROLLBACK;
1472: RAISE;
1473: END;
1474:

Line 1494: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;

1490: BEGIN
1491:
1492: -- Initialize default parameters
1493: v_log_to_date := sysdate;
1494: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1495:
1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);
1497:
1498: -- Call mth_run_log_pre_load

Line 1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);

1492: -- Initialize default parameters
1493: v_log_to_date := sysdate;
1494: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
1495:
1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);
1497:
1498: -- Call mth_run_log_pre_load
1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);
1500:

Line 1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);

1495:
1496: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP start', mth_util_pkg.G_DBG_PROC_FUN_START);
1497:
1498: -- Call mth_run_log_pre_load
1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);
1500:
1501: -- Call GET_RUN_LOG_DATES
1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
1503:

Line 1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

1498: -- Call mth_run_log_pre_load
1499: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val,NULL,NULL,0,v_log_to_date);
1500:
1501: -- Call GET_RUN_LOG_DATES
1502: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_HRCHY_UA_MAP',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
1503:
1504: MERGE INTO MTH_EQUIP_HIERARCHY MEQU
1505: USING
1506: (SELECT MDM.HIERARCHY_ID,

Line 1512: MTH_UTIL_PKG.MTH_UA_GET_MEANING() PARENT_NAME

1508: ME.EQUIPMENT_PK_KEY ,
1509: v_unassigned_val PARENT_FK_KEY,
1510: To_Date('01-01-1900','DD-MM-YYYY') EFFECTIVE_DATE,
1511: ME.EQUIPMENT_NAME EQUIPMENT_NAME,
1512: MTH_UTIL_PKG.MTH_UA_GET_MEANING() PARENT_NAME
1513: FROM MTH_EQUIPMENTS_D ME,MTH_DIM_HIERARCHY MDM
1514: WHERE MDM.DIMENSION_NAME = 'EQUIPMENT'
1515: )CATCH_ALL
1516:

Line 1559: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1555: CATCH_ALL.EQUIPMENT_NAME,
1556: CATCH_ALL.PARENT_NAME,
1557: 1)
1558: ;
1559: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1560:
1561: MERGE
1562: INTO
1563: MTH_EQUIP_HIERARCHY MEQ

Line 1619: MTH_UTIL_PKG.MTH_UA_GET_VAL(),

1615: (UN_ALL.HIERARCHY_ID,
1616: UN_ALL.LEVEL_NUM,
1617: UN_ALL.LEVEL_KEY,
1618: UN_ALL.PARENT_KEY,
1619: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1620: UN_ALL.EFFECTIVE_DATE,
1621: v_log_to_date,
1622: v_log_to_date,
1623: MTH_UTIL_PKG.MTH_UA_GET_VAL(),

Line 1623: MTH_UTIL_PKG.MTH_UA_GET_VAL(),

1619: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1620: UN_ALL.EFFECTIVE_DATE,
1621: v_log_to_date,
1622: v_log_to_date,
1623: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1624: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1625: UN_ALL.LEVEL_NAME,
1626: UN_ALL.PARENT_NAME,
1627: 1)

Line 1624: MTH_UTIL_PKG.MTH_UA_GET_VAL(),

1620: UN_ALL.EFFECTIVE_DATE,
1621: v_log_to_date,
1622: v_log_to_date,
1623: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1624: MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1625: UN_ALL.LEVEL_NAME,
1626: UN_ALL.PARENT_NAME,
1627: 1)
1628: ;

Line 1629: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1625: UN_ALL.LEVEL_NAME,
1626: UN_ALL.PARENT_NAME,
1627: 1)
1628: ;
1629: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1630:
1631: MERGE
1632: INTO
1633: MTH_EQUIP_HIERARCHY MEQB

Line 1649: MTH_UTIL_PKG.MTH_UA_GET_MEANING UNASSIGNED_PARENT_NAME

1645: --MEH.LAST_UPDATE_DATE LAST_UPDATE_DATE,
1646: --Commented to ensure distinct works fine in case reassignment happens on a
1647: --different date
1648: MEH.LEVEL_NAME,
1649: MTH_UTIL_PKG.MTH_UA_GET_MEANING UNASSIGNED_PARENT_NAME
1650: FROM MTH_EQUIP_HIERARCHY MEH
1651: WHERE
1652: MEH.LAST_UPDATE_DATE >= v_log_from_date AND
1653: MEH.LEVEL_FK_KEY <> -99999

Line 1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

1695: MERGE_QUERY.LEVEL_NAME,
1696: MERGE_QUERY.UNASSIGNED_PARENT_NAME,
1697: 1)
1698: ;
1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703:

Line 1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);

1698: ;
1699: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_HIERARCHY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703:
1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1705: COMMIT;
1706: EXCEPTION

Line 1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);

1700:
1701: ----Call mth_run_log_post_load
1702: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_HRCHY_UA_MAP',v_unassigned_val);
1703:
1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1705: COMMIT;
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);

Line 1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);

1704: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1705: COMMIT;
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1709: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1710: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1711: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1712: ROLLBACK;

Line 1709: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

1705: COMMIT;
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1709: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1710: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1711: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1712: ROLLBACK;
1713: RAISE;

Line 1710: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1709: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1710: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1711: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1712: ROLLBACK;
1713: RAISE;
1714:

Line 1711: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);

1707: WHEN OTHERS THEN
1708: mth_util_pkg.log_msg('Exception OTHERS in MTH_EQUIP_HRCHY_UA_MAP', mth_util_pkg.G_DBG_EXCEPTION);
1709: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
1710: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
1711: mth_util_pkg.log_msg('MTH_EQUIP_HRCHY_UA_MAP end', mth_util_pkg.G_DBG_PROC_FUN_END);
1712: ROLLBACK;
1713: RAISE;
1714:
1715: END MTH_EQUIP_HRCHY_UA_MAP;