39: );
40:
41: EXCEPTION
42: WHEN OTHERS THEN
43: fnd_message.set_name ('PN', 'PN_EXP_LOC_TO_CAD_ITF');
44: RAISE;
45:
46: END;
47:
59: );
60:
61: EXCEPTION
62: WHEN OTHERS THEN
63: fnd_message.set_name ('PN', 'PN_EXP_SPC_TO_CAD_ITF');
64: RAISE;
65:
66: END;
67:
197: v_standard_type_lookup_code PN_LOCATIONS.STANDARD_TYPE_LOOKUP_CODE%TYPE; --BUG#5359173
198:
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;
198:
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 :=
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
781: -------------------------------------------
782:
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');
782:
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);
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);
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);
792:
793:
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);
792:
793:
794: END IF;
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:
800: ', Location Code: ' || v_Location_Code ||
801: ', Location Id: ' || v_Location_Id
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;
801: ', Location Id: ' || v_Location_Id
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:
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
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);
824:
825: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SUCCESS');
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);
824:
825: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SUCCESS');
826: fnd_message.set_token('NUM', v_success);
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);
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);
828:
829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');
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);
828:
829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');
830: fnd_message.set_token('NUM', v_fail);
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);
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);
832: PNP_DEBUG_PKG.put_log_msg('
833: ===============================================================================');
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);
832: PNP_DEBUG_PKG.put_log_msg('
833: ===============================================================================');
834: EXCEPTION
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
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);
932: pnp_debug_pkg.put_log_msg(fnd_message.get);
933:
934:
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);
932: pnp_debug_pkg.put_log_msg(fnd_message.get);
933:
934:
935: l_cursor := dbms_sql.open_cursor;
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:
1266: -------------------------------------------
1267:
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');
1267:
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);
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);
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);
1277:
1278: END IF;
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);
1277:
1278: END IF;
1279:
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:
1285: ', Location Id: ' || v_Location_Id ||
1286: ', Location Code: ' || v_Location_Code
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;
1286: ', Location Code: ' || v_Location_Code
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:
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