DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on FND_MESSAGE

Line 1165: fnd_message.set_name ('PN','PN_VAR_GLCAL_SHORT');

1161: p_cal_start_date_orig := p_cal_start_date;
1162: p_cal_end_date_orig := p_cal_end_date;
1163:
1164: IF p_cal_end_date < p_vr_term_date THEN
1165: fnd_message.set_name ('PN','PN_VAR_GLCAL_SHORT');
1166: APP_EXCEPTION.Raise_Exception;
1167: END IF;
1168:
1169: IF p_cal_start_date > p_vr_comm_date THEN

Line 1170: fnd_message.set_name ('PN','PN_VAR_GLCAL_LATER');

1166: APP_EXCEPTION.Raise_Exception;
1167: END IF;
1168:
1169: IF p_cal_start_date > p_vr_comm_date THEN
1170: fnd_message.set_name ('PN','PN_VAR_GLCAL_LATER');
1171: APP_EXCEPTION.Raise_Exception;
1172: END IF;
1173:
1174: IF p_vr_term_date < p_cal_end_date THEN

Line 4230: fnd_message.set_name ('PN','PN_RECORD_CHANGED');

4226: IS
4227: BEGIN
4228: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4229:
4230: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4231: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4232: fnd_message.set_token ('NEW_VALUE',p_new_value);
4233: app_exception.raise_exception;
4234:

Line 4231: fnd_message.set_token ('COLUMN_NAME',p_column_name);

4227: BEGIN
4228: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4229:
4230: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4231: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4232: fnd_message.set_token ('NEW_VALUE',p_new_value);
4233: app_exception.raise_exception;
4234:
4235: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (-)');

Line 4232: fnd_message.set_token ('NEW_VALUE',p_new_value);

4228: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4229:
4230: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4231: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4232: fnd_message.set_token ('NEW_VALUE',p_new_value);
4233: app_exception.raise_exception;
4234:
4235: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (-)');
4236: END lock_row_exception;

Line 4553: fnd_message.set_name ('PN','PN_VAR_CHECK_DATES');

4549:
4550: EXCEPTION
4551:
4552: WHEN NO_DATA_FOUND THEN
4553: fnd_message.set_name ('PN','PN_VAR_CHECK_DATES');
4554: APP_EXCEPTION.Raise_Exception;
4555:
4556: WHEN OTHERS THEN
4557: RETURN NULL;

Line 6440: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

6436: END LOOP; --- end loop for var_rent_dates_rec will always have one row.
6437:
6438: EXCEPTION
6439: WHEN OTHERS THEN
6440: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6441: fnd_message.set_token('ERR_MSG',sqlerrm);
6442: x_return_status := FND_API.G_RET_STS_ERROR;
6443: pnp_debug_pkg.put_log_msg (fnd_message.get);
6444: --PNP_DEBUG_PKG.disable_file_debug;

Line 6441: fnd_message.set_token('ERR_MSG',sqlerrm);

6437:
6438: EXCEPTION
6439: WHEN OTHERS THEN
6440: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6441: fnd_message.set_token('ERR_MSG',sqlerrm);
6442: x_return_status := FND_API.G_RET_STS_ERROR;
6443: pnp_debug_pkg.put_log_msg (fnd_message.get);
6444: --PNP_DEBUG_PKG.disable_file_debug;
6445:

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

6439: WHEN OTHERS THEN
6440: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6441: fnd_message.set_token('ERR_MSG',sqlerrm);
6442: x_return_status := FND_API.G_RET_STS_ERROR;
6443: pnp_debug_pkg.put_log_msg (fnd_message.get);
6444: --PNP_DEBUG_PKG.disable_file_debug;
6445:
6446: END extend_periods ;
6447:

Line 6956: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

6952:
6953: EXCEPTION
6954: WHEN OTHERS THEN
6955: pnp_debug_pkg.debug('error ' || sqlerrm);
6956: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6957: fnd_message.set_token('ERR_MSG',sqlerrm);
6958: x_return_status := FND_API.G_RET_STS_ERROR;
6959: pnp_debug_pkg.debug (fnd_message.get);
6960: pnp_debug_pkg.put_log_msg (fnd_message.get);

Line 6957: fnd_message.set_token('ERR_MSG',sqlerrm);

6953: EXCEPTION
6954: WHEN OTHERS THEN
6955: pnp_debug_pkg.debug('error ' || sqlerrm);
6956: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6957: fnd_message.set_token('ERR_MSG',sqlerrm);
6958: x_return_status := FND_API.G_RET_STS_ERROR;
6959: pnp_debug_pkg.debug (fnd_message.get);
6960: pnp_debug_pkg.put_log_msg (fnd_message.get);
6961: --PNP_DEBUG_PKG.disable_file_debug;

Line 6959: pnp_debug_pkg.debug (fnd_message.get);

6955: pnp_debug_pkg.debug('error ' || sqlerrm);
6956: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6957: fnd_message.set_token('ERR_MSG',sqlerrm);
6958: x_return_status := FND_API.G_RET_STS_ERROR;
6959: pnp_debug_pkg.debug (fnd_message.get);
6960: pnp_debug_pkg.put_log_msg (fnd_message.get);
6961: --PNP_DEBUG_PKG.disable_file_debug;
6962: END extend_group_dates;
6963:

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

6956: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
6957: fnd_message.set_token('ERR_MSG',sqlerrm);
6958: x_return_status := FND_API.G_RET_STS_ERROR;
6959: pnp_debug_pkg.debug (fnd_message.get);
6960: pnp_debug_pkg.put_log_msg (fnd_message.get);
6961: --PNP_DEBUG_PKG.disable_file_debug;
6962: END extend_group_dates;
6963:
6964: /*===========================================================================+

Line 7053: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

7049: put_log ('PN_VAR_RENT_PKG.create_new_bkpts (-)');
7050: EXCEPTION
7051: WHEN OTHERS THEN
7052: pnp_debug_pkg.debug('error ' || sqlerrm);
7053: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7054: fnd_message.set_token('ERR_MSG',sqlerrm);
7055: x_return_status := FND_API.G_RET_STS_ERROR;
7056: pnp_debug_pkg.debug (fnd_message.get);
7057: pnp_debug_pkg.put_log_msg (fnd_message.get);

Line 7054: fnd_message.set_token('ERR_MSG',sqlerrm);

7050: EXCEPTION
7051: WHEN OTHERS THEN
7052: pnp_debug_pkg.debug('error ' || sqlerrm);
7053: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7054: fnd_message.set_token('ERR_MSG',sqlerrm);
7055: x_return_status := FND_API.G_RET_STS_ERROR;
7056: pnp_debug_pkg.debug (fnd_message.get);
7057: pnp_debug_pkg.put_log_msg (fnd_message.get);
7058: END create_new_bkpts;

Line 7056: pnp_debug_pkg.debug (fnd_message.get);

7052: pnp_debug_pkg.debug('error ' || sqlerrm);
7053: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7054: fnd_message.set_token('ERR_MSG',sqlerrm);
7055: x_return_status := FND_API.G_RET_STS_ERROR;
7056: pnp_debug_pkg.debug (fnd_message.get);
7057: pnp_debug_pkg.put_log_msg (fnd_message.get);
7058: END create_new_bkpts;
7059:
7060:

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

7053: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7054: fnd_message.set_token('ERR_MSG',sqlerrm);
7055: x_return_status := FND_API.G_RET_STS_ERROR;
7056: pnp_debug_pkg.debug (fnd_message.get);
7057: pnp_debug_pkg.put_log_msg (fnd_message.get);
7058: END create_new_bkpts;
7059:
7060:
7061: FUNCTION GET_PRORATION_RULE(p_var_rent_id IN NUMBER DEFAULT NULL,

Line 10206: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');

10202: pnp_debug_pkg.log('pn_var_rent_pkg.process_vr_exp_con +End+ (+)');
10203:
10204: EXCEPTION
10205: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10206: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10207: fnd_message.set_token ('REQ_NUM',p_request_id);
10208: errbuf := fnd_message.get;
10209: pnp_debug_pkg.put_log_msg (errbuf);
10210: retcode := 2;

Line 10207: fnd_message.set_token ('REQ_NUM',p_request_id);

10203:
10204: EXCEPTION
10205: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10206: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10207: fnd_message.set_token ('REQ_NUM',p_request_id);
10208: errbuf := fnd_message.get;
10209: pnp_debug_pkg.put_log_msg (errbuf);
10210: retcode := 2;
10211: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN

Line 10208: errbuf := fnd_message.get;

10204: EXCEPTION
10205: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10206: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10207: fnd_message.set_token ('REQ_NUM',p_request_id);
10208: errbuf := fnd_message.get;
10209: pnp_debug_pkg.put_log_msg (errbuf);
10210: retcode := 2;
10211: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10212: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');

Line 10212: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');

10208: errbuf := fnd_message.get;
10209: pnp_debug_pkg.put_log_msg (errbuf);
10210: retcode := 2;
10211: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10212: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');
10213: errbuf := fnd_message.get;
10214: pnp_debug_pkg.put_log_msg (errbuf);
10215: retcode := 2;
10216: WHEN INCORRECT_VR_DATES_EXCEPTION THEN

Line 10213: errbuf := fnd_message.get;

10209: pnp_debug_pkg.put_log_msg (errbuf);
10210: retcode := 2;
10211: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10212: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');
10213: errbuf := fnd_message.get;
10214: pnp_debug_pkg.put_log_msg (errbuf);
10215: retcode := 2;
10216: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10217: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');

Line 10217: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');

10213: errbuf := fnd_message.get;
10214: pnp_debug_pkg.put_log_msg (errbuf);
10215: retcode := 2;
10216: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10217: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');
10218: errbuf := fnd_message.get;
10219: pnp_debug_pkg.put_log_msg (errbuf);
10220: retcode := 2;
10221: WHEN MISSING_CHANGE_ID_EXCEPTION THEN

Line 10218: errbuf := fnd_message.get;

10214: pnp_debug_pkg.put_log_msg (errbuf);
10215: retcode := 2;
10216: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10217: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');
10218: errbuf := fnd_message.get;
10219: pnp_debug_pkg.put_log_msg (errbuf);
10220: retcode := 2;
10221: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10222: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');

Line 10222: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');

10218: errbuf := fnd_message.get;
10219: pnp_debug_pkg.put_log_msg (errbuf);
10220: retcode := 2;
10221: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10222: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');
10223: errbuf := fnd_message.get;
10224: pnp_debug_pkg.put_log_msg (errbuf);
10225: retcode := 2;
10226: WHEN MISSING_SETUP_EXCEPTION THEN

Line 10223: errbuf := fnd_message.get;

10219: pnp_debug_pkg.put_log_msg (errbuf);
10220: retcode := 2;
10221: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10222: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');
10223: errbuf := fnd_message.get;
10224: pnp_debug_pkg.put_log_msg (errbuf);
10225: retcode := 2;
10226: WHEN MISSING_SETUP_EXCEPTION THEN
10227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

Line 10227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

10223: errbuf := fnd_message.get;
10224: pnp_debug_pkg.put_log_msg (errbuf);
10225: retcode := 2;
10226: WHEN MISSING_SETUP_EXCEPTION THEN
10227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
10228: errbuf := fnd_message.get;
10229: pnp_debug_pkg.put_log_msg (errbuf);
10230: retcode := 2;
10231: WHEN OTHERS THEN

Line 10228: errbuf := fnd_message.get;

10224: pnp_debug_pkg.put_log_msg (errbuf);
10225: retcode := 2;
10226: WHEN MISSING_SETUP_EXCEPTION THEN
10227: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
10228: errbuf := fnd_message.get;
10229: pnp_debug_pkg.put_log_msg (errbuf);
10230: retcode := 2;
10231: WHEN OTHERS THEN
10232: Errbuf := SQLERRM;