DBA Data[Home] [Help]

APPS.PN_EXP_TO_CAD_ITF dependencies on FND_MESSAGE

Line 43: fnd_message.set_name ('PN', 'PN_EXP_LOC_TO_CAD_ITF');

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:

Line 63: fnd_message.set_name ('PN', 'PN_EXP_SPC_TO_CAD_ITF');

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:

Line 201: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

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;

Line 202: fnd_message.set_token ('TYPE',p_locn_type);

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 :=

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 785: fnd_message.set_name ('PN','PN_BATCH_NAME');

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');

Line 786: fnd_message.set_token ('NAME',p_batch_name);

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);

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 789: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

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:

Line 790: fnd_message.set_token ('TYPE',p_locn_type);

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;

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 804: fnd_message.set_name ('PN','PN_XPEAM_LOC');

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;

Line 805: fnd_message.set_token ('LOC_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;
809:

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 821: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_TOTAL');

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');

Line 822: fnd_message.set_token('NUM', v_Counter);

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);

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 825: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_SUCCESS');

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');

Line 826: fnd_message.set_token('NUM', v_success);

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);

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 829: fnd_message.set_name('PN', 'PN_CAFM_LOCATION_FAILURE');

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: ===============================================================================');

Line 830: fnd_message.set_token('NUM', v_fail);

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

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 930: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

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:

Line 931: fnd_message.set_token ('TYPE',p_locn_type);

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;

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 1270: fnd_message.set_name ('PN','PN_BATCH_NAME');

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');

Line 1271: fnd_message.set_token ('NAME',p_batch_name);

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);

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 1274: fnd_message.set_name ('PN','PN_HRSYNC_LOC_TYPE');

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;

Line 1275: fnd_message.set_token ('TYPE',p_locn_type);

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:

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 1289: fnd_message.set_name ('PN','PN_XPEAM_LOC');

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;

Line 1290: fnd_message.set_token ('LOC_CODE',v_Location_Code);

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:

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