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_RECOVERY_EXTRACT_PKG dependencies on FND_MESSAGE

Line 1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');

1091: BEGIN
1092:
1093: pnp_debug_pkg.log(l_desc ||' (+)');
1094:
1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');
1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);

Line 1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));

1092:
1093: pnp_debug_pkg.log(l_desc ||' (+)');
1094:
1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');
1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);

Line 1097: fnd_message.set_token('STR' , p_from_date);

1093: pnp_debug_pkg.log(l_desc ||' (+)');
1094:
1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');
1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);
1101: pnp_debug_pkg.put_log_msg('');

Line 1098: fnd_message.set_token('END' , p_to_date);

1094:
1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');
1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);
1101: pnp_debug_pkg.put_log_msg('');
1102: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1099: fnd_message.set_token('AOD' , p_as_of_date);

1095: fnd_message.set_name('PN','PN_REC_ARCL_DTL_CP_INFO');
1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);
1101: pnp_debug_pkg.put_log_msg('');
1102: pnp_debug_pkg.put_log_msg(fnd_message.get);
1103: pnp_debug_pkg.put_log_msg('');

Line 1100: fnd_message.set_token('OVR' , p_keep_override);

1096: fnd_message.set_token('ARCL' , to_char(p_area_class_id));
1097: fnd_message.set_token('STR' , p_from_date);
1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);
1101: pnp_debug_pkg.put_log_msg('');
1102: pnp_debug_pkg.put_log_msg(fnd_message.get);
1103: pnp_debug_pkg.put_log_msg('');
1104:

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

1098: fnd_message.set_token('END' , p_to_date);
1099: fnd_message.set_token('AOD' , p_as_of_date);
1100: fnd_message.set_token('OVR' , p_keep_override);
1101: pnp_debug_pkg.put_log_msg('');
1102: pnp_debug_pkg.put_log_msg(fnd_message.get);
1103: pnp_debug_pkg.put_log_msg('');
1104:
1105: l_vacancy_date_table.delete;
1106: l_vacancy_num_table.delete;

Line 1151: fnd_message.set_name('PN', 'PN_REC_UOM_MULTIPLE');

1147: IF l_arcl_propid IS NOT NULL AND l_arcl_locid IS NULL THEN
1148: FOR validate_rec IN get_uom_info_from_prop(l_arcl_propid) LOOP
1149: IF l_uom_code IS NULL THEN l_uom_code := validate_rec.uom_code;
1150: ELSIF l_uom_code <> validate_rec.uom_code THEN
1151: fnd_message.set_name('PN', 'PN_REC_UOM_MULTIPLE');
1152: RAISE uom_exception;
1153: END IF;
1154: END LOOP;
1155: ELSIF l_arcl_locid IS NOT NULL THEN

Line 1159: fnd_message.set_name('PN', 'PN_REC_UOM_MULTIPLE');

1155: ELSIF l_arcl_locid IS NOT NULL THEN
1156: FOR validate_rec IN get_uom_info_from_locn(l_arcl_locid) LOOP
1157: IF l_uom_code IS NULL THEN l_uom_code := validate_rec.uom_code;
1158: ELSIF l_uom_code <> validate_rec.uom_code THEN
1159: fnd_message.set_name('PN', 'PN_REC_UOM_MULTIPLE');
1160: RAISE uom_exception;
1161: END IF;
1162: END LOOP;
1163: END IF;

Line 1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');

1170:
1171: FOR get_ovr_rec IN get_ovr_from_curnt LOOP
1172:
1173: IF get_ovr_rec.status = 'LOCKED' THEN
1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);

Line 1175: l_token := fnd_message.get;

1171: FOR get_ovr_rec IN get_ovr_from_curnt LOOP
1172:
1173: IF get_ovr_rec.status = 'LOCKED' THEN
1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);

Line 1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');

1172:
1173: IF get_ovr_rec.status = 'LOCKED' THEN
1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);

Line 1177: fnd_message.set_token('MODULE',l_token);

1173: IF get_ovr_rec.status = 'LOCKED' THEN
1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);

Line 1178: fnd_message.set_token('FDATE', p_from_date);

1174: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);
1182: pnp_debug_pkg.log(fnd_message.get);

Line 1179: fnd_message.set_token('TDATE', p_to_date);

1175: l_token := fnd_message.get;
1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);
1182: pnp_debug_pkg.log(fnd_message.get);
1183: RETURN;

Line 1180: fnd_message.set_token('AODATE', p_as_of_date);

1176: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);
1182: pnp_debug_pkg.log(fnd_message.get);
1183: RETURN;
1184: END IF;

Line 1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);

1177: fnd_message.set_token('MODULE',l_token);
1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);
1182: pnp_debug_pkg.log(fnd_message.get);
1183: RETURN;
1184: END IF;
1185:

Line 1182: pnp_debug_pkg.log(fnd_message.get);

1178: fnd_message.set_token('FDATE', p_from_date);
1179: fnd_message.set_token('TDATE', p_to_date);
1180: fnd_message.set_token('AODATE', p_as_of_date);
1181: fnd_message.set_token('NAME', get_ovr_rec.area_class_name);
1182: pnp_debug_pkg.log(fnd_message.get);
1183: RETURN;
1184: END IF;
1185:
1186: l_count := l_area_cls_ln_curnt_ovr.COUNT;

Line 1603: pnp_debug_pkg.log(fnd_message.get);

1599: pnp_debug_pkg.log(l_desc ||' (-)');
1600:
1601: EXCEPTION
1602: WHEN uom_exception THEN
1603: pnp_debug_pkg.log(fnd_message.get);
1604: raise;
1605: WHEN OTHERS THEN
1606: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1607: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1606: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');

1602: WHEN uom_exception THEN
1603: pnp_debug_pkg.log(fnd_message.get);
1604: raise;
1605: WHEN OTHERS THEN
1606: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1607: pnp_debug_pkg.put_log_msg(fnd_message.get);
1608: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
1609: raise;
1610: END extract_area;

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

1603: pnp_debug_pkg.log(fnd_message.get);
1604: raise;
1605: WHEN OTHERS THEN
1606: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1607: pnp_debug_pkg.put_log_msg(fnd_message.get);
1608: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
1609: raise;
1610: END extract_area;
1611:

Line 2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');

2088: BEGIN
2089:
2090: pnp_debug_pkg.log(l_desc ||' (+)');
2091:
2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));

Line 2093: fnd_message.set_token('LOC' , to_char(p_location_id));

2089:
2090: pnp_debug_pkg.log(l_desc ||' (+)');
2091:
2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));

Line 2094: fnd_message.set_token('PROP' , to_char(p_property_id));

2090: pnp_debug_pkg.log(l_desc ||' (+)');
2091:
2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);

Line 2095: fnd_message.set_token('STR' , to_char(p_from_date));

2091:
2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);

Line 2096: fnd_message.set_token('END' , to_char(p_to_date));

2092: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);

Line 2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));

2093: fnd_message.set_token('LOC' , to_char(p_location_id));
2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);
2101: pnp_debug_pkg.put_log_msg('');

Line 2098: fnd_message.set_token('CUR' , p_currency_code);

2094: fnd_message.set_token('PROP' , to_char(p_property_id));
2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);
2101: pnp_debug_pkg.put_log_msg('');
2102: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2099: fnd_message.set_token('EXPNUM', p_extract_code);

2095: fnd_message.set_token('STR' , to_char(p_from_date));
2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);
2101: pnp_debug_pkg.put_log_msg('');
2102: pnp_debug_pkg.put_log_msg(fnd_message.get);
2103: pnp_debug_pkg.put_log_msg('');

Line 2100: fnd_message.set_token('OVR' , p_keep_override);

2096: fnd_message.set_token('END' , to_char(p_to_date));
2097: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);
2101: pnp_debug_pkg.put_log_msg('');
2102: pnp_debug_pkg.put_log_msg(fnd_message.get);
2103: pnp_debug_pkg.put_log_msg('');
2104:

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

2098: fnd_message.set_token('CUR' , p_currency_code);
2099: fnd_message.set_token('EXPNUM', p_extract_code);
2100: fnd_message.set_token('OVR' , p_keep_override);
2101: pnp_debug_pkg.put_log_msg('');
2102: pnp_debug_pkg.put_log_msg(fnd_message.get);
2103: pnp_debug_pkg.put_log_msg('');
2104:
2105: l_info := ' initializing values';
2106: pnp_debug_pkg.log(l_info);

Line 2179: fnd_message.set_name('PN','PN_REC_EXP_LN');

2175: WHERE CURRENT OF get_itf_lines_info;
2176:
2177: END LOOP;
2178:
2179: fnd_message.set_name('PN','PN_REC_EXP_LN');
2180: pnp_debug_pkg.put_log_msg('');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

2177: END LOOP;
2178:
2179: fnd_message.set_name('PN','PN_REC_EXP_LN');
2180: pnp_debug_pkg.put_log_msg('');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

Line 2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

2179: fnd_message.set_name('PN','PN_REC_EXP_LN');
2180: pnp_debug_pkg.put_log_msg('');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2187: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));

2180: pnp_debug_pkg.put_log_msg('');
2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2187: pnp_debug_pkg.put_log_msg(fnd_message.get);
2188: pnp_debug_pkg.put_log_msg('');

Line 2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

2181: pnp_debug_pkg.put_log_msg(fnd_message.get);
2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2187: pnp_debug_pkg.put_log_msg(fnd_message.get);
2188: pnp_debug_pkg.put_log_msg('');
2189:

Line 2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));

2182:
2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2187: pnp_debug_pkg.put_log_msg(fnd_message.get);
2188: pnp_debug_pkg.put_log_msg('');
2189:
2190: pnp_debug_pkg.log(l_desc ||' (-)');

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

2183: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2184: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2185: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2186: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2187: pnp_debug_pkg.put_log_msg(fnd_message.get);
2188: pnp_debug_pkg.put_log_msg('');
2189:
2190: pnp_debug_pkg.log(l_desc ||' (-)');
2191:

Line 2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');

2898:
2899: END IF;
2900: END LOOP;
2901:
2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2903: pnp_debug_pkg.put_log_msg('');
2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

2900: END LOOP;
2901:
2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2903: pnp_debug_pkg.put_log_msg('');
2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

Line 2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

2902: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2903: pnp_debug_pkg.put_log_msg('');
2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2910: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));

2903: pnp_debug_pkg.put_log_msg('');
2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2910: pnp_debug_pkg.put_log_msg(fnd_message.get);
2911: pnp_debug_pkg.put_log_msg('');

Line 2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

2904: pnp_debug_pkg.put_log_msg(fnd_message.get);
2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2910: pnp_debug_pkg.put_log_msg(fnd_message.get);
2911: pnp_debug_pkg.put_log_msg('');
2912:

Line 2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));

2905:
2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2910: pnp_debug_pkg.put_log_msg(fnd_message.get);
2911: pnp_debug_pkg.put_log_msg('');
2912:
2913: pnp_debug_pkg.log(l_desc ||' (-)');

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

2906: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2907: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2908: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2909: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2910: pnp_debug_pkg.put_log_msg(fnd_message.get);
2911: pnp_debug_pkg.put_log_msg('');
2912:
2913: pnp_debug_pkg.log(l_desc ||' (-)');
2914:

Line 3043: fnd_message.set_name('PN','PN_REC_ARCL_DTL');

3039: END LOOP;
3040:
3041: END IF;
3042:
3043: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3044: pnp_debug_pkg.put_log_msg('');
3045: pnp_debug_pkg.put_log_msg(fnd_message.get);
3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

3041: END IF;
3042:
3043: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3044: pnp_debug_pkg.put_log_msg('');
3045: pnp_debug_pkg.put_log_msg(fnd_message.get);
3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

Line 3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

3043: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3044: pnp_debug_pkg.put_log_msg('');
3045: pnp_debug_pkg.put_log_msg(fnd_message.get);
3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3051: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));

3044: pnp_debug_pkg.put_log_msg('');
3045: pnp_debug_pkg.put_log_msg(fnd_message.get);
3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3051: pnp_debug_pkg.put_log_msg(fnd_message.get);
3052: pnp_debug_pkg.put_log_msg('');

Line 3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

3045: pnp_debug_pkg.put_log_msg(fnd_message.get);
3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3051: pnp_debug_pkg.put_log_msg(fnd_message.get);
3052: pnp_debug_pkg.put_log_msg('');
3053:

Line 3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));

3046:
3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3051: pnp_debug_pkg.put_log_msg(fnd_message.get);
3052: pnp_debug_pkg.put_log_msg('');
3053:
3054: pnp_debug_pkg.log(l_desc ||' (-)');

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

3047: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3048: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3049: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3050: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3051: pnp_debug_pkg.put_log_msg(fnd_message.get);
3052: pnp_debug_pkg.put_log_msg('');
3053:
3054: pnp_debug_pkg.log(l_desc ||' (-)');
3055:

Line 3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');

3379:
3380: BEGIN
3381: pnp_debug_pkg.log(l_desc ||' (+)');
3382:
3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);

Line 3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));

3380: BEGIN
3381: pnp_debug_pkg.log(l_desc ||' (+)');
3382:
3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);

Line 3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));

3381: pnp_debug_pkg.log(l_desc ||' (+)');
3382:
3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);

Line 3386: fnd_message.set_token('STR' , p_from_date);

3382:
3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);
3390: pnp_debug_pkg.put_log_msg('');

Line 3387: fnd_message.set_token('END' , p_to_date);

3383: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);
3390: pnp_debug_pkg.put_log_msg('');
3391: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 3388: fnd_message.set_token('AOD' , p_as_of_date);

3384: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);
3390: pnp_debug_pkg.put_log_msg('');
3391: pnp_debug_pkg.put_log_msg(fnd_message.get);
3392: pnp_debug_pkg.put_log_msg('');

Line 3389: fnd_message.set_token('OVR' , p_keep_override);

3385: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3386: fnd_message.set_token('STR' , p_from_date);
3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);
3390: pnp_debug_pkg.put_log_msg('');
3391: pnp_debug_pkg.put_log_msg(fnd_message.get);
3392: pnp_debug_pkg.put_log_msg('');
3393:

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

3387: fnd_message.set_token('END' , p_to_date);
3388: fnd_message.set_token('AOD' , p_as_of_date);
3389: fnd_message.set_token('OVR' , p_keep_override);
3390: pnp_debug_pkg.put_log_msg('');
3391: pnp_debug_pkg.put_log_msg(fnd_message.get);
3392: pnp_debug_pkg.put_log_msg('');
3393:
3394: l_info := ' validating currency';
3395: pnp_debug_pkg.log(l_info);

Line 3398: fnd_message.set_name('PN', 'PN_REC_EXP_CUR_MISMATCH');

3394: l_info := ' validating currency';
3395: pnp_debug_pkg.log(l_info);
3396:
3397: FOR check_cur IN check_currency LOOP
3398: fnd_message.set_name('PN', 'PN_REC_EXP_CUR_MISMATCH');
3399: RAISE currency_exception;
3400: END LOOP;
3401:
3402: l_info := ' initializing values ';

Line 3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');

3420:
3421: FOR check_exists IN is_reextract LOOP
3422:
3423: IF check_exists.status = 'LOCKED' THEN
3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);

Line 3425: l_token := fnd_message.get;

3421: FOR check_exists IN is_reextract LOOP
3422:
3423: IF check_exists.status = 'LOCKED' THEN
3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);

Line 3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');

3422:
3423: IF check_exists.status = 'LOCKED' THEN
3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);

Line 3427: fnd_message.set_token('MODULE',l_token);

3423: IF check_exists.status = 'LOCKED' THEN
3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);

Line 3428: fnd_message.set_token('FDATE', p_from_date);

3424: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);
3432: pnp_debug_pkg.log(fnd_message.get);

Line 3429: fnd_message.set_token('TDATE', p_to_date);

3425: l_token := fnd_message.get;
3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);
3432: pnp_debug_pkg.log(fnd_message.get);
3433: RETURN;

Line 3430: fnd_message.set_token('AODATE', p_as_of_date);

3426: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);
3432: pnp_debug_pkg.log(fnd_message.get);
3433: RETURN;
3434: END IF;

Line 3431: fnd_message.set_token('NAME', check_exists.expense_class_name);

3427: fnd_message.set_token('MODULE',l_token);
3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);
3432: pnp_debug_pkg.log(fnd_message.get);
3433: RETURN;
3434: END IF;
3435:

Line 3432: pnp_debug_pkg.log(fnd_message.get);

3428: fnd_message.set_token('FDATE', p_from_date);
3429: fnd_message.set_token('TDATE', p_to_date);
3430: fnd_message.set_token('AODATE', p_as_of_date);
3431: fnd_message.set_token('NAME', check_exists.expense_class_name);
3432: pnp_debug_pkg.log(fnd_message.get);
3433: RETURN;
3434: END IF;
3435:
3436: l_regenerate := 'Y';

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

3719: pnp_debug_pkg.log(l_desc ||' (-)');
3720:
3721: EXCEPTION
3722: WHEN currency_exception THEN
3723: pnp_debug_pkg.put_log_msg(fnd_message.get);
3724: raise;
3725: WHEN OTHERS THEN
3726: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3727: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 3726: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');

3722: WHEN currency_exception THEN
3723: pnp_debug_pkg.put_log_msg(fnd_message.get);
3724: raise;
3725: WHEN OTHERS THEN
3726: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3727: pnp_debug_pkg.put_log_msg(fnd_message.get);
3728: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3729: raise;
3730: END extract_expense;

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

3723: pnp_debug_pkg.put_log_msg(fnd_message.get);
3724: raise;
3725: WHEN OTHERS THEN
3726: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3727: pnp_debug_pkg.put_log_msg(fnd_message.get);
3728: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3729: raise;
3730: END extract_expense;
3731:

Line 3834: fnd_message.set_name('PN','PN_LOC_PROP_REQ');

3830: l_info := ' performing input validation ';
3831: pnp_debug_pkg.log(l_info);
3832:
3833: IF NOT (l_location_id IS NOT NULL OR l_property_id IS NOT NULL) THEN
3834: fnd_message.set_name('PN','PN_LOC_PROP_REQ');
3835: raise bad_input_exception;
3836:
3837: ELSIF NOT check_extract_code(p_extract_code, l_location_id, l_property_id,
3838: l_as_of_date, l_from_date, l_to_date, l_currency) THEN

Line 3843: fnd_message.set_name('PN','PN_REC_NONUNIQUE_NUM');

3839:
3840: IF p_extract_code IS NOT NULL AND
3841: p_called_from = 'SRS' THEN
3842:
3843: fnd_message.set_name('PN','PN_REC_NONUNIQUE_NUM');
3844: fnd_message.set_token('NUMBER', p_extract_code);
3845: raise bad_input_exception;
3846:
3847: ELSIF p_extract_code IS NULL AND

Line 3844: fnd_message.set_token('NUMBER', p_extract_code);

3840: IF p_extract_code IS NOT NULL AND
3841: p_called_from = 'SRS' THEN
3842:
3843: fnd_message.set_name('PN','PN_REC_NONUNIQUE_NUM');
3844: fnd_message.set_token('NUMBER', p_extract_code);
3845: raise bad_input_exception;
3846:
3847: ELSIF p_extract_code IS NULL AND
3848: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',

Line 3852: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');

3848: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3849: pn_mo_cache_utils.get_current_org_id) = 'N'
3850: THEN
3851:
3852: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');
3853: raise bad_input_exception;
3854:
3855: END IF;
3856:

Line 3858: fnd_message.set_name('PN','PN_REC_EXT_DT_OVERLAP');

3854:
3855: END IF;
3856:
3857: ELSIF NOT check_dates(l_as_of_date, l_from_date, l_to_date, l_location_id, l_property_id, p_extract_code) THEN
3858: fnd_message.set_name('PN','PN_REC_EXT_DT_OVERLAP');
3859: raise bad_input_exception;
3860:
3861: ELSIF l_currency IS NULL THEN
3862: app_exception.raise_exception;

Line 3909: pnp_debug_pkg.log(fnd_message.get);

3905: pnp_debug_pkg.log(l_desc ||' (-)');
3906:
3907: EXCEPTION
3908: WHEN bad_input_exception THEN
3909: pnp_debug_pkg.log(fnd_message.get);
3910: raise;
3911: WHEN OTHERS THEN
3912: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3913: raise;