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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1177: l_token := fnd_message.get;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1611: pnp_debug_pkg.log(l_desc ||' (-)');
1612:
1613: EXCEPTION
1614: WHEN uom_exception THEN
1615: pnp_debug_pkg.log(fnd_message.get);
1616: raise;
1617: WHEN OTHERS THEN
1618: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1619: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

1614: WHEN uom_exception THEN
1615: pnp_debug_pkg.log(fnd_message.get);
1616: raise;
1617: WHEN OTHERS THEN
1618: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1619: pnp_debug_pkg.put_log_msg(fnd_message.get);
1620: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
1621: raise;
1622: END extract_area;

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

1615: pnp_debug_pkg.log(fnd_message.get);
1616: raise;
1617: WHEN OTHERS THEN
1618: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
1619: pnp_debug_pkg.put_log_msg(fnd_message.get);
1620: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
1621: raise;
1622: END extract_area;
1623:

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

2100: BEGIN
2101:
2102: pnp_debug_pkg.log(l_desc ||' (+)');
2103:
2104: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));

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

2101:
2102: pnp_debug_pkg.log(l_desc ||' (+)');
2103:
2104: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));

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

2102: pnp_debug_pkg.log(l_desc ||' (+)');
2103:
2104: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);

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

2103:
2104: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);

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

2104: fnd_message.set_name('PN','PN_REC_EXP_LN_CP_INFO');
2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);

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

2105: fnd_message.set_token('LOC' , to_char(p_location_id));
2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);
2113: pnp_debug_pkg.put_log_msg('');

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

2106: fnd_message.set_token('PROP' , to_char(p_property_id));
2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);
2113: pnp_debug_pkg.put_log_msg('');
2114: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2107: fnd_message.set_token('STR' , to_char(p_from_date));
2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);
2113: pnp_debug_pkg.put_log_msg('');
2114: pnp_debug_pkg.put_log_msg(fnd_message.get);
2115: pnp_debug_pkg.put_log_msg('');

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

2108: fnd_message.set_token('END' , to_char(p_to_date));
2109: fnd_message.set_token('AOD' , to_char(p_as_of_date));
2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);
2113: pnp_debug_pkg.put_log_msg('');
2114: pnp_debug_pkg.put_log_msg(fnd_message.get);
2115: pnp_debug_pkg.put_log_msg('');
2116:

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

2110: fnd_message.set_token('CUR' , p_currency_code);
2111: fnd_message.set_token('EXPNUM', p_extract_code);
2112: fnd_message.set_token('OVR' , p_keep_override);
2113: pnp_debug_pkg.put_log_msg('');
2114: pnp_debug_pkg.put_log_msg(fnd_message.get);
2115: pnp_debug_pkg.put_log_msg('');
2116:
2117: l_info := ' initializing values';
2118: pnp_debug_pkg.log(l_info);

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

2187: WHERE CURRENT OF get_itf_lines_info;
2188:
2189: END LOOP;
2190:
2191: fnd_message.set_name('PN','PN_REC_EXP_LN');
2192: pnp_debug_pkg.put_log_msg('');
2193: pnp_debug_pkg.put_log_msg(fnd_message.get);
2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

2189: END LOOP;
2190:
2191: fnd_message.set_name('PN','PN_REC_EXP_LN');
2192: pnp_debug_pkg.put_log_msg('');
2193: pnp_debug_pkg.put_log_msg(fnd_message.get);
2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

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

2191: fnd_message.set_name('PN','PN_REC_EXP_LN');
2192: pnp_debug_pkg.put_log_msg('');
2193: pnp_debug_pkg.put_log_msg(fnd_message.get);
2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2198: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2199: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2192: pnp_debug_pkg.put_log_msg('');
2193: pnp_debug_pkg.put_log_msg(fnd_message.get);
2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2198: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2199: pnp_debug_pkg.put_log_msg(fnd_message.get);
2200: pnp_debug_pkg.put_log_msg('');

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

2193: pnp_debug_pkg.put_log_msg(fnd_message.get);
2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2198: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2199: pnp_debug_pkg.put_log_msg(fnd_message.get);
2200: pnp_debug_pkg.put_log_msg('');
2201:

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

2194:
2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2198: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2199: pnp_debug_pkg.put_log_msg(fnd_message.get);
2200: pnp_debug_pkg.put_log_msg('');
2201:
2202: pnp_debug_pkg.log(l_desc ||' (-)');

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

2195: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2196: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2197: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2198: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2199: pnp_debug_pkg.put_log_msg(fnd_message.get);
2200: pnp_debug_pkg.put_log_msg('');
2201:
2202: pnp_debug_pkg.log(l_desc ||' (-)');
2203:

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

2910:
2911: END IF;
2912: END LOOP;
2913:
2914: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2915: pnp_debug_pkg.put_log_msg('');
2916: pnp_debug_pkg.put_log_msg(fnd_message.get);
2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

2912: END LOOP;
2913:
2914: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2915: pnp_debug_pkg.put_log_msg('');
2916: pnp_debug_pkg.put_log_msg(fnd_message.get);
2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

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

2914: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
2915: pnp_debug_pkg.put_log_msg('');
2916: pnp_debug_pkg.put_log_msg(fnd_message.get);
2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2921: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2922: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

2915: pnp_debug_pkg.put_log_msg('');
2916: pnp_debug_pkg.put_log_msg(fnd_message.get);
2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2921: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2922: pnp_debug_pkg.put_log_msg(fnd_message.get);
2923: pnp_debug_pkg.put_log_msg('');

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

2916: pnp_debug_pkg.put_log_msg(fnd_message.get);
2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2921: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2922: pnp_debug_pkg.put_log_msg(fnd_message.get);
2923: pnp_debug_pkg.put_log_msg('');
2924:

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

2917:
2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2921: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2922: pnp_debug_pkg.put_log_msg(fnd_message.get);
2923: pnp_debug_pkg.put_log_msg('');
2924:
2925: pnp_debug_pkg.log(l_desc ||' (-)');

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

2918: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
2919: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
2920: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
2921: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
2922: pnp_debug_pkg.put_log_msg(fnd_message.get);
2923: pnp_debug_pkg.put_log_msg('');
2924:
2925: pnp_debug_pkg.log(l_desc ||' (-)');
2926:

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

3051: END LOOP;
3052:
3053: END IF;
3054:
3055: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3056: pnp_debug_pkg.put_log_msg('');
3057: pnp_debug_pkg.put_log_msg(fnd_message.get);
3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');

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

3053: END IF;
3054:
3055: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3056: pnp_debug_pkg.put_log_msg('');
3057: pnp_debug_pkg.put_log_msg(fnd_message.get);
3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));

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

3055: fnd_message.set_name('PN','PN_REC_ARCL_DTL');
3056: pnp_debug_pkg.put_log_msg('');
3057: pnp_debug_pkg.put_log_msg(fnd_message.get);
3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3062: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3063: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

3056: pnp_debug_pkg.put_log_msg('');
3057: pnp_debug_pkg.put_log_msg(fnd_message.get);
3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3062: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3063: pnp_debug_pkg.put_log_msg(fnd_message.get);
3064: pnp_debug_pkg.put_log_msg('');

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

3057: pnp_debug_pkg.put_log_msg(fnd_message.get);
3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3062: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3063: pnp_debug_pkg.put_log_msg(fnd_message.get);
3064: pnp_debug_pkg.put_log_msg('');
3065:

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

3058:
3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3062: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3063: pnp_debug_pkg.put_log_msg(fnd_message.get);
3064: pnp_debug_pkg.put_log_msg('');
3065:
3066: pnp_debug_pkg.log(l_desc ||' (-)');

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

3059: fnd_message.set_name('PN','PN_CP_RESULT_SUMMARY');
3060: fnd_message.set_token('TOTAL', TO_CHAR(l_total));
3061: fnd_message.set_token('PASS', TO_CHAR(l_total - l_failed));
3062: fnd_message.set_token('FAIL', TO_CHAR(l_failed));
3063: pnp_debug_pkg.put_log_msg(fnd_message.get);
3064: pnp_debug_pkg.put_log_msg('');
3065:
3066: pnp_debug_pkg.log(l_desc ||' (-)');
3067:

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

3391:
3392: BEGIN
3393: pnp_debug_pkg.log(l_desc ||' (+)');
3394:
3395: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);

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

3392: BEGIN
3393: pnp_debug_pkg.log(l_desc ||' (+)');
3394:
3395: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);

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

3393: pnp_debug_pkg.log(l_desc ||' (+)');
3394:
3395: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);

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

3394:
3395: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);
3402: pnp_debug_pkg.put_log_msg('');

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

3395: fnd_message.set_name('PN','PN_REC_EXPCL_DTL_CP_INFO');
3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);
3402: pnp_debug_pkg.put_log_msg('');
3403: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

3396: fnd_message.set_token('EXPCL', to_char(p_expense_class_id));
3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);
3402: pnp_debug_pkg.put_log_msg('');
3403: pnp_debug_pkg.put_log_msg(fnd_message.get);
3404: pnp_debug_pkg.put_log_msg('');

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

3397: fnd_message.set_token('EXPLN', to_char(p_expense_line_id));
3398: fnd_message.set_token('STR' , p_from_date);
3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);
3402: pnp_debug_pkg.put_log_msg('');
3403: pnp_debug_pkg.put_log_msg(fnd_message.get);
3404: pnp_debug_pkg.put_log_msg('');
3405:

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

3399: fnd_message.set_token('END' , p_to_date);
3400: fnd_message.set_token('AOD' , p_as_of_date);
3401: fnd_message.set_token('OVR' , p_keep_override);
3402: pnp_debug_pkg.put_log_msg('');
3403: pnp_debug_pkg.put_log_msg(fnd_message.get);
3404: pnp_debug_pkg.put_log_msg('');
3405:
3406: l_info := ' validating currency';
3407: pnp_debug_pkg.log(l_info);

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

3406: l_info := ' validating currency';
3407: pnp_debug_pkg.log(l_info);
3408:
3409: FOR check_cur IN check_currency LOOP
3410: fnd_message.set_name('PN', 'PN_REC_EXP_CUR_MISMATCH');
3411: RAISE currency_exception;
3412: END LOOP;
3413:
3414: l_info := ' initializing values ';

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

3432:
3433: FOR check_exists IN is_reextract LOOP
3434:
3435: IF check_exists.status = 'LOCKED' THEN
3436: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);

Line 3437: l_token := fnd_message.get;

3433: FOR check_exists IN is_reextract LOOP
3434:
3435: IF check_exists.status = 'LOCKED' THEN
3436: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);

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

3434:
3435: IF check_exists.status = 'LOCKED' THEN
3436: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);

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

3435: IF check_exists.status = 'LOCKED' THEN
3436: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);

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

3436: fnd_message.set_name('PN','PN_REC_EXPCL_DTL');
3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);
3444: pnp_debug_pkg.log(fnd_message.get);

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

3437: l_token := fnd_message.get;
3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);
3444: pnp_debug_pkg.log(fnd_message.get);
3445: RETURN;

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

3438: fnd_message.set_name('PN','PN_REC_NO_REGEN_LOCKED');
3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);
3444: pnp_debug_pkg.log(fnd_message.get);
3445: RETURN;
3446: END IF;

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

3439: fnd_message.set_token('MODULE',l_token);
3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);
3444: pnp_debug_pkg.log(fnd_message.get);
3445: RETURN;
3446: END IF;
3447:

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

3440: fnd_message.set_token('FDATE', p_from_date);
3441: fnd_message.set_token('TDATE', p_to_date);
3442: fnd_message.set_token('AODATE', p_as_of_date);
3443: fnd_message.set_token('NAME', check_exists.expense_class_name);
3444: pnp_debug_pkg.log(fnd_message.get);
3445: RETURN;
3446: END IF;
3447:
3448: l_regenerate := 'Y';

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

3731: pnp_debug_pkg.log(l_desc ||' (-)');
3732:
3733: EXCEPTION
3734: WHEN currency_exception THEN
3735: pnp_debug_pkg.put_log_msg(fnd_message.get);
3736: raise;
3737: WHEN OTHERS THEN
3738: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3739: pnp_debug_pkg.put_log_msg(fnd_message.get);

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

3734: WHEN currency_exception THEN
3735: pnp_debug_pkg.put_log_msg(fnd_message.get);
3736: raise;
3737: WHEN OTHERS THEN
3738: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3739: pnp_debug_pkg.put_log_msg(fnd_message.get);
3740: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3741: raise;
3742: END extract_expense;

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

3735: pnp_debug_pkg.put_log_msg(fnd_message.get);
3736: raise;
3737: WHEN OTHERS THEN
3738: fnd_message.set_name('PN','PN_REC_CP_INCOMPLETE');
3739: pnp_debug_pkg.put_log_msg(fnd_message.get);
3740: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3741: raise;
3742: END extract_expense;
3743:

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

3842: l_info := ' performing input validation ';
3843: pnp_debug_pkg.log(l_info);
3844:
3845: IF NOT (l_location_id IS NOT NULL OR l_property_id IS NOT NULL) THEN
3846: fnd_message.set_name('PN','PN_LOC_PROP_REQ');
3847: raise bad_input_exception;
3848:
3849: ELSIF NOT check_extract_code(p_extract_code, l_location_id, l_property_id,
3850: l_as_of_date, l_from_date, l_to_date, l_currency) THEN

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

3851:
3852: IF p_extract_code IS NOT NULL AND
3853: p_called_from = 'SRS' THEN
3854:
3855: fnd_message.set_name('PN','PN_REC_NONUNIQUE_NUM');
3856: fnd_message.set_token('NUMBER', p_extract_code);
3857: raise bad_input_exception;
3858:
3859: ELSIF p_extract_code IS NULL AND

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

3852: IF p_extract_code IS NOT NULL AND
3853: p_called_from = 'SRS' THEN
3854:
3855: fnd_message.set_name('PN','PN_REC_NONUNIQUE_NUM');
3856: fnd_message.set_token('NUMBER', p_extract_code);
3857: raise bad_input_exception;
3858:
3859: ELSIF p_extract_code IS NULL AND
3860: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',

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

3860: pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_REC_EXPENSE_NUM',
3861: pn_mo_cache_utils.get_current_org_id) = 'N'
3862: THEN
3863:
3864: fnd_message.set_name('PN','PN_REC_EXP_NUM_REQ');
3865: raise bad_input_exception;
3866:
3867: END IF;
3868:

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

3866:
3867: END IF;
3868:
3869: ELSIF NOT check_dates(l_as_of_date, l_from_date, l_to_date, l_location_id, l_property_id, p_extract_code) THEN
3870: fnd_message.set_name('PN','PN_REC_EXT_DT_OVERLAP');
3871: raise bad_input_exception;
3872:
3873: ELSIF l_currency IS NULL THEN
3874: app_exception.raise_exception;

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

3917: pnp_debug_pkg.log(l_desc ||' (-)');
3918:
3919: EXCEPTION
3920: WHEN bad_input_exception THEN
3921: pnp_debug_pkg.log(fnd_message.get);
3922: raise;
3923: WHEN OTHERS THEN
3924: pnp_debug_pkg.log(l_desc || ': Error while ' || l_info);
3925: raise;