DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on FND_MESSAGE

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

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

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

1170: APP_EXCEPTION.Raise_Exception;
1171: END IF;
1172:
1173: IF p_cal_start_date > p_vr_comm_date THEN
1174: fnd_message.set_name ('PN','PN_VAR_GLCAL_LATER');
1175: APP_EXCEPTION.Raise_Exception;
1176: END IF;
1177:
1178: IF p_vr_term_date < p_cal_end_date THEN

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

4230: IS
4231: BEGIN
4232: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4233:
4234: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4235: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4236: fnd_message.set_token ('NEW_VALUE',p_new_value);
4237: app_exception.raise_exception;
4238:

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

4231: BEGIN
4232: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4233:
4234: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4235: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4236: fnd_message.set_token ('NEW_VALUE',p_new_value);
4237: app_exception.raise_exception;
4238:
4239: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (-)');

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

4232: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (+)');
4233:
4234: fnd_message.set_name ('PN','PN_RECORD_CHANGED');
4235: fnd_message.set_token ('COLUMN_NAME',p_column_name);
4236: fnd_message.set_token ('NEW_VALUE',p_new_value);
4237: app_exception.raise_exception;
4238:
4239: pnp_debug_pkg.debug ('PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION (-)');
4240: END lock_row_exception;

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

4553:
4554: EXCEPTION
4555:
4556: WHEN NO_DATA_FOUND THEN
4557: fnd_message.set_name ('PN','PN_VAR_CHECK_DATES');
4558: APP_EXCEPTION.Raise_Exception;
4559:
4560: WHEN OTHERS THEN
4561: RETURN NULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7056: pnp_debug_pkg.debug('error ' || sqlerrm);
7057: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7058: fnd_message.set_token('ERR_MSG',sqlerrm);
7059: x_return_status := FND_API.G_RET_STS_ERROR;
7060: pnp_debug_pkg.debug (fnd_message.get);
7061: pnp_debug_pkg.put_log_msg (fnd_message.get);
7062: END create_new_bkpts;
7063:
7064:

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

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

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

10219: pnp_debug_pkg.log('pn_var_rent_pkg.process_vr_exp_con +End+ (+)');
10220:
10221: EXCEPTION
10222: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10223: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10224: fnd_message.set_token ('REQ_NUM',p_request_id);
10225: errbuf := fnd_message.get;
10226: pnp_debug_pkg.put_log_msg (errbuf);
10227: retcode := 2;

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

10220:
10221: EXCEPTION
10222: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10223: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10224: fnd_message.set_token ('REQ_NUM',p_request_id);
10225: errbuf := fnd_message.get;
10226: pnp_debug_pkg.put_log_msg (errbuf);
10227: retcode := 2;
10228: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN

Line 10225: errbuf := fnd_message.get;

10221: EXCEPTION
10222: WHEN SCH_ITEMS_FAILED_EXCEPTION THEN
10223: fnd_message.set_name ('PN', 'PN_SCH_ITEMS_REQ_FAILED');
10224: fnd_message.set_token ('REQ_NUM',p_request_id);
10225: errbuf := fnd_message.get;
10226: pnp_debug_pkg.put_log_msg (errbuf);
10227: retcode := 2;
10228: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10229: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');

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

10225: errbuf := fnd_message.get;
10226: pnp_debug_pkg.put_log_msg (errbuf);
10227: retcode := 2;
10228: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10229: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');
10230: errbuf := fnd_message.get;
10231: pnp_debug_pkg.put_log_msg (errbuf);
10232: retcode := 2;
10233: WHEN INCORRECT_VR_DATES_EXCEPTION THEN

Line 10230: errbuf := fnd_message.get;

10226: pnp_debug_pkg.put_log_msg (errbuf);
10227: retcode := 2;
10228: WHEN INCORRECT_VR_CONTEXT_EXCEPTION THEN
10229: fnd_message.set_name ('PN', 'INCORRECT_VR_CONTEXT');
10230: errbuf := fnd_message.get;
10231: pnp_debug_pkg.put_log_msg (errbuf);
10232: retcode := 2;
10233: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10234: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');

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

10230: errbuf := fnd_message.get;
10231: pnp_debug_pkg.put_log_msg (errbuf);
10232: retcode := 2;
10233: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10234: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');
10235: errbuf := fnd_message.get;
10236: pnp_debug_pkg.put_log_msg (errbuf);
10237: retcode := 2;
10238: WHEN MISSING_CHANGE_ID_EXCEPTION THEN

Line 10235: errbuf := fnd_message.get;

10231: pnp_debug_pkg.put_log_msg (errbuf);
10232: retcode := 2;
10233: WHEN INCORRECT_VR_DATES_EXCEPTION THEN
10234: fnd_message.set_name ('PN', 'INCORRECT_VR_DATES');
10235: errbuf := fnd_message.get;
10236: pnp_debug_pkg.put_log_msg (errbuf);
10237: retcode := 2;
10238: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10239: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');

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

10235: errbuf := fnd_message.get;
10236: pnp_debug_pkg.put_log_msg (errbuf);
10237: retcode := 2;
10238: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10239: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');
10240: errbuf := fnd_message.get;
10241: pnp_debug_pkg.put_log_msg (errbuf);
10242: retcode := 2;
10243: WHEN MISSING_SETUP_EXCEPTION THEN

Line 10240: errbuf := fnd_message.get;

10236: pnp_debug_pkg.put_log_msg (errbuf);
10237: retcode := 2;
10238: WHEN MISSING_CHANGE_ID_EXCEPTION THEN
10239: fnd_message.set_name ('PN', 'MISSING_CHANGE_ID');
10240: errbuf := fnd_message.get;
10241: pnp_debug_pkg.put_log_msg (errbuf);
10242: retcode := 2;
10243: WHEN MISSING_SETUP_EXCEPTION THEN
10244: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');

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

10240: errbuf := fnd_message.get;
10241: pnp_debug_pkg.put_log_msg (errbuf);
10242: retcode := 2;
10243: WHEN MISSING_SETUP_EXCEPTION THEN
10244: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
10245: errbuf := fnd_message.get;
10246: pnp_debug_pkg.put_log_msg (errbuf);
10247: retcode := 2;
10248: WHEN OTHERS THEN

Line 10245: errbuf := fnd_message.get;

10241: pnp_debug_pkg.put_log_msg (errbuf);
10242: retcode := 2;
10243: WHEN MISSING_SETUP_EXCEPTION THEN
10244: fnd_message.set_name ('PN', 'MISSING_SETUP_CONTEXT');
10245: errbuf := fnd_message.get;
10246: pnp_debug_pkg.put_log_msg (errbuf);
10247: retcode := 2;
10248: WHEN OTHERS THEN
10249: Errbuf := SQLERRM;