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.PN_EXP_TO_CAD_ITF dependencies on PNP_DEBUG_PKG

Line 203: pnp_debug_pkg.put_log_msg(fnd_message.get);

199: BEGIN
200:
201: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
202: fnd_message.set_token ('TYPE',p_locn_type);
203: pnp_debug_pkg.put_log_msg(fnd_message.get);
204:
205: l_cursor := dbms_sql.open_cursor;
206: l_statement :=
207: 'SELECT

Line 787: pnp_debug_pkg.put_log_msg(fnd_message.get);

783: IF v_counter = 1 THEN
784:
785: fnd_message.set_name ('PN','PN_BATCH_NAME');
786: fnd_message.set_token ('NAME',p_batch_name);
787: pnp_debug_pkg.put_log_msg(fnd_message.get);
788:
789: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
790: fnd_message.set_token ('TYPE',p_locn_type);
791: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 791: pnp_debug_pkg.put_log_msg(fnd_message.get);

787: pnp_debug_pkg.put_log_msg(fnd_message.get);
788:
789: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
790: fnd_message.set_token ('TYPE',p_locn_type);
791: pnp_debug_pkg.put_log_msg(fnd_message.get);
792:
793:
794: END IF;
795:

Line 797: PNP_DEBUG_PKG.log (

793:
794: END IF;
795:
796:
797: PNP_DEBUG_PKG.log (
798: 'Record NUMBER: ' || v_Counter ||
799: ', ' || Insert_Update ||
800: ', Location Code: ' || v_Location_Code ||
801: ', Location Id: ' || v_Location_Id

Line 806: pnp_debug_pkg.put_log_msg(fnd_message.get);

802: );
803:
804: fnd_message.set_name ('PN','PN_XPEAM_LOC');
805: fnd_message.set_token ('LOC_CODE',v_Location_Code);
806: pnp_debug_pkg.put_log_msg(fnd_message.get);
807:
808: END LOOP;
809:
810: IF dbms_sql.is_open (l_cursor) THEN

Line 819: PNP_DEBUG_PKG.put_log_msg('

815: COMMIT;
816:
817: -- log the summary
818: v_success := v_counter - v_fail;
819: PNP_DEBUG_PKG.put_log_msg('
820: ===============================================================================');
821: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_TOTAL');
822: fnd_message.set_token('NUM', v_Counter);
823: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

Line 823: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

819: PNP_DEBUG_PKG.put_log_msg('
820: ===============================================================================');
821: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_TOTAL');
822: fnd_message.set_token('NUM', v_Counter);
823: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
824:
825: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SUCCESS');
826: fnd_message.set_token('NUM', v_success);
827: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

Line 827: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

823: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
824:
825: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SUCCESS');
826: fnd_message.set_token('NUM', v_success);
827: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
828:
829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');
830: fnd_message.set_token('NUM', v_fail);
831: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

Line 831: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);

827: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
828:
829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');
830: fnd_message.set_token('NUM', v_fail);
831: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
832: PNP_DEBUG_PKG.put_log_msg('
833: ===============================================================================');
834: EXCEPTION
835: WHEN OTHERS THEN

Line 832: PNP_DEBUG_PKG.put_log_msg('

828:
829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');
830: fnd_message.set_token('NUM', v_fail);
831: PNP_DEBUG_PKG.put_log_msg(fnd_message.get);
832: PNP_DEBUG_PKG.put_log_msg('
833: ===============================================================================');
834: EXCEPTION
835: WHEN OTHERS THEN
836: RAISE;

Line 927: pnp_debug_pkg.put_log_msg('inside exp_spc_to_cad_itf');

923: v_PROJECT_ID NUMBER;
924: v_TASK_ID NUMBER;
925:
926: BEGIN
927: pnp_debug_pkg.put_log_msg('inside exp_spc_to_cad_itf');
928: vl_date := NVL(vl_date, fnd_date.canonical_to_date('4712/12/31:00:00:00'));
929:
930: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
931: fnd_message.set_token ('TYPE',p_locn_type);

Line 932: pnp_debug_pkg.put_log_msg(fnd_message.get);

928: vl_date := NVL(vl_date, fnd_date.canonical_to_date('4712/12/31:00:00:00'));
929:
930: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
931: fnd_message.set_token ('TYPE',p_locn_type);
932: pnp_debug_pkg.put_log_msg(fnd_message.get);
933:
934:
935: l_cursor := dbms_sql.open_cursor;
936:

Line 1009: pnp_debug_pkg.log(' after parse ');

1005:
1006:
1007: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
1008:
1009: pnp_debug_pkg.log(' after parse ');
1010:
1011: dbms_sql.bind_variable
1012: (l_cursor,'as_of_date',l_as_of_date );
1013:

Line 1074: pnp_debug_pkg.log(' after fetch_rows');

1070: LOOP
1071:
1072: l_count := dbms_sql.fetch_rows( l_cursor );
1073:
1074: pnp_debug_pkg.log(' after fetch_rows');
1075: EXIT WHEN l_count <>1;
1076:
1077: dbms_sql.column_value (l_cursor, 1,v_EMP_SPACE_ASSIGN_ID);
1078: dbms_sql.column_value (l_cursor, 2,v_LOCATION_ID);

Line 1130: pnp_debug_pkg.log(' bfore insert ');

1126: IF (exists_in_itf = 0) THEN
1127:
1128: -- Insert the fetched data INTO PN_EMP_SPACE_ASSIGN_ITF table.
1129:
1130: pnp_debug_pkg.log(' bfore insert ');
1131:
1132: INSERT INTO PN_EMP_SPACE_ASSIGN_ITF (
1133: BATCH_NAME,
1134: ENTRY_TYPE,

Line 1207: PNP_DEBUG_PKG.log('Inserted Row ' || v_Counter);

1203: );
1204:
1205: Insert_Update := 'Insert';
1206:
1207: PNP_DEBUG_PKG.log('Inserted Row ' || v_Counter);
1208:
1209: END IF;
1210:
1211:

Line 1258: PNP_DEBUG_PKG.log('Updated Row ' || v_Counter);

1254: END IF;
1255:
1256: Insert_Update := 'Update';
1257:
1258: PNP_DEBUG_PKG.log('Updated Row ' || v_Counter);
1259:
1260: END IF;
1261:
1262:

Line 1272: pnp_debug_pkg.put_log_msg(fnd_message.get);

1268: IF v_Counter = 1 THEN
1269:
1270: fnd_message.set_name ('PN','PN_BATCH_NAME');
1271: fnd_message.set_token ('NAME',p_batch_name);
1272: pnp_debug_pkg.put_log_msg(fnd_message.get);
1273:
1274: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
1275: fnd_message.set_token ('TYPE',p_locn_type);
1276: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1276: pnp_debug_pkg.put_log_msg(fnd_message.get);

1272: pnp_debug_pkg.put_log_msg(fnd_message.get);
1273:
1274: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');
1275: fnd_message.set_token ('TYPE',p_locn_type);
1276: pnp_debug_pkg.put_log_msg(fnd_message.get);
1277:
1278: END IF;
1279:
1280:

Line 1281: PNP_DEBUG_PKG.log (

1277:
1278: END IF;
1279:
1280:
1281: PNP_DEBUG_PKG.log (
1282: 'Record Number: ' || v_Counter ||
1283: ', ' || Insert_Update ||
1284: ', Emp Space Assign Id: '|| v_emp_space_assign_id ||
1285: ', Location Id: ' || v_Location_Id ||

Line 1291: pnp_debug_pkg.put_log_msg(fnd_message.get);

1287: );
1288:
1289: fnd_message.set_name ('PN','PN_XPEAM_LOC');
1290: fnd_message.set_token ('LOC_CODE',v_Location_Code);
1291: pnp_debug_pkg.put_log_msg(fnd_message.get);
1292:
1293: END LOOP;
1294:
1295: IF dbms_sql.is_open (l_cursor) THEN