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.PNP_UTIL_FUNC dependencies on PNP_DEBUG_PKG

Line 2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');

2901: INVALID_TERMINATION_DATE EXCEPTION;
2902:
2903: BEGIN
2904:
2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);

Line 2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);

2902:
2903: BEGIN
2904:
2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);

Line 2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);

2903: BEGIN
2904:
2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);

Line 2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);

2904:
2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2912:

Line 2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);

2905: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2912:
2913: /* lease ID must always be passed */

Line 2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);

2906: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2912:
2913: /* lease ID must always be passed */
2914: IF p_lease_id IS NULL OR

Line 2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);

2907: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2908: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2909: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2910: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2911: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2912:
2913: /* lease ID must always be passed */
2914: IF p_lease_id IS NULL OR
2915: p_termination_date IS NULL THEN

Line 3051: PNP_DEBUG_PKG.log('Invalid PARAM passed.');

3047:
3048: EXCEPTION
3049:
3050: WHEN INVALID_PARAM THEN
3051: PNP_DEBUG_PKG.log('Invalid PARAM passed.');
3052: RETURN FALSE;
3053:
3054: WHEN INVALID_TERMINATION_DATE THEN
3055: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');

Line 3059: PNP_DEBUG_PKG.log('Something went wrong here!! - '||SQLCODE||': '||SQLERRM);

3055: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');
3056: RETURN FALSE;
3057:
3058: WHEN OTHERS THEN
3059: PNP_DEBUG_PKG.log('Something went wrong here!! - '||SQLCODE||': '||SQLERRM);
3060: RETURN FALSE;
3061:
3062: END valid_early_term_date;
3063:

Line 6286: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');

6282: AND active_start_date <= l_end_dt
6283: AND active_end_date >= p_st_date;
6284:
6285: BEGIN
6286: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');
6287:
6288: pnp_util_func.fetch_loctn_area(
6289: p_type => pnp_util_func.get_location_type_lookup_code
6290: (

Line 6375: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');

6371: EXCEPTION
6372:
6373: WHEN OTHERS THEN
6374: RAISE;
6375: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');
6376: END validate_vacant_area;
6377:
6378:
6379: /*===========================================================================+

Line 7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');

7126: l_api_name VARCHAR2(50) := 'pnp_util_func.get_space_assignments';
7127:
7128: BEGIN
7129:
7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);

Line 7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');

7127:
7128: BEGIN
7129:
7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);

Line 7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');

7128: BEGIN
7129:
7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);

Line 7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');

7129:
7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');

Line 7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);

7130: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7138:

Line 7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);

7131: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7138:
7139:

Line 7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);

7132: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7138:
7139:
7140:

Line 7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');

7133: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7134: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
7135: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
7136: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
7137: PNP_DEBUG_PKG.DEBUG('----------------------------------');
7138:
7139:
7140:
7141: FOR space_assign_cust_rec in pn_space_assign_cust_cursor

Line 7144: PNP_DEBUG_PKG.DEBUG('Assigning Cust data index : '|| l_index);

7140:
7141: FOR space_assign_cust_rec in pn_space_assign_cust_cursor
7142: LOOP
7143: l_index := l_index + 1;
7144: PNP_DEBUG_PKG.DEBUG('Assigning Cust data index : '|| l_index);
7145: l_space_assign_cust_tbl(l_index).cust_account_id :=
7146: space_assign_cust_rec.cust_account_id ;
7147: l_space_assign_cust_tbl(l_index).location_id :=
7148: space_assign_cust_rec.location_id ;

Line 7178: PNP_DEBUG_PKG.DEBUG('Assigning emp data index : '|| l_index);

7174:
7175: FOR space_assign_emp_rec in pn_space_assign_emp_cursor
7176: LOOP
7177: l_index := l_index + 1;
7178: PNP_DEBUG_PKG.DEBUG('Assigning emp data index : '|| l_index);
7179: l_space_assign_emp_tbl(l_index).person_id :=
7180: space_assign_emp_rec.person_id ;
7181: l_space_assign_emp_tbl(l_index).location_id :=
7182: space_assign_emp_rec.location_id ;

Line 7206: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');

7202: END LOOP;
7203: x_space_assign_emp_tbl := l_space_assign_emp_tbl;
7204:
7205: x_return_status := FND_API.G_RET_STS_SUCCESS;
7206: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7207:
7208: EXCEPTION
7209: WHEN OTHERS THEN
7210: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 7213: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');

7209: WHEN OTHERS THEN
7210: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7211: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7213: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7214:
7215:
7216: END get_space_assignments;
7217:

Line 7317: PNP_DEBUG_PKG.log('----------------------------------');

7313:
7314: BEGIN
7315: x_return_status := FND_API.G_RET_STS_SUCCESS;
7316:
7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

Line 7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');

7314: BEGIN
7315: x_return_status := FND_API.G_RET_STS_SUCCESS;
7316:
7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

Line 7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');

7315: x_return_status := FND_API.G_RET_STS_SUCCESS;
7316:
7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

Line 7320: PNP_DEBUG_PKG.log('----------------------------------');

7316:
7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7324: PNP_DEBUG_PKG.log('----------------------------------');

Line 7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

7317: PNP_DEBUG_PKG.log('----------------------------------');
7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7324: PNP_DEBUG_PKG.log('----------------------------------');
7325:

Line 7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

7318: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7324: PNP_DEBUG_PKG.log('----------------------------------');
7325:
7326: IF p_start_date > p_start_date_old THEN

Line 7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

7319: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7324: PNP_DEBUG_PKG.log('----------------------------------');
7325:
7326: IF p_start_date > p_start_date_old THEN
7327:

Line 7324: PNP_DEBUG_PKG.log('----------------------------------');

7320: PNP_DEBUG_PKG.log('----------------------------------');
7321: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7322: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7323: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7324: PNP_DEBUG_PKG.log('----------------------------------');
7325:
7326: IF p_start_date > p_start_date_old THEN
7327:
7328: FOR validate_start_date_rec in validate_start_date_cursor LOOP

Line 7346: PNP_DEBUG_PKG.DEBUG('pnp_util_func.validate_assignment_for_date (-)');

7342: END LOOP;
7343:
7344: END IF;
7345:
7346: PNP_DEBUG_PKG.DEBUG('pnp_util_func.validate_assignment_for_date (-)');
7347:
7348: EXCEPTION
7349:
7350: WHEN USER_DEF_ERROR THEN

Line 7353: PNP_DEBUG_PKG.log('Assignment found for dates');

7349:
7350: WHEN USER_DEF_ERROR THEN
7351: x_return_status := FND_API.G_RET_STS_ERROR;
7352: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7353: PNP_DEBUG_PKG.log('Assignment found for dates');
7354:
7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7357: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

Line 7359: PNP_DEBUG_PKG.log('OTHERS ERROR');

7355: WHEN OTHERS THEN
7356: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7357: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7359: PNP_DEBUG_PKG.log('OTHERS ERROR');
7360:
7361: END validate_assignment_for_date;
7362:
7363:

Line 7407: PNP_DEBUG_PKG.log('----------------------------------');

7403:
7404: UNEXPECTED_ERROR EXCEPTION;
7405: BEGIN
7406:
7407: PNP_DEBUG_PKG.log('----------------------------------');
7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

Line 7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');

7404: UNEXPECTED_ERROR EXCEPTION;
7405: BEGIN
7406:
7407: PNP_DEBUG_PKG.log('----------------------------------');
7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

Line 7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');

7405: BEGIN
7406:
7407: PNP_DEBUG_PKG.log('----------------------------------');
7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

Line 7410: PNP_DEBUG_PKG.log('----------------------------------');

7406:
7407: PNP_DEBUG_PKG.log('----------------------------------');
7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

Line 7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

7407: PNP_DEBUG_PKG.log('----------------------------------');
7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');

Line 7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

7408: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');

Line 7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

7409: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');
7417:

Line 7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

7410: PNP_DEBUG_PKG.log('----------------------------------');
7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');
7417:
7418: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7415: PNP_DEBUG_PKG.log('----------------------------------');

7411: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');
7417:
7418: x_return_status := FND_API.G_RET_STS_SUCCESS;
7419: Get_space_assignments (

Line 7416: PNP_DEBUG_PKG.log('Calling get space assignments');

7412: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7413: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7414: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7415: PNP_DEBUG_PKG.log('----------------------------------');
7416: PNP_DEBUG_PKG.log('Calling get space assignments');
7417:
7418: x_return_status := FND_API.G_RET_STS_SUCCESS;
7419: Get_space_assignments (
7420: p_location_id => p_location_id,

Line 7430: PNP_DEBUG_PKG.log('Error in get space_assignments');

7426: x_return_message => x_return_message
7427: );
7428:
7429: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7430: PNP_DEBUG_PKG.log('Error in get space_assignments');
7431: Raise unexpected_error;
7432: END IF;
7433:
7434: IF l_space_assign_cust_tbl.count > 0 THEN

Line 7437: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl : '||l_index);

7433:
7434: IF l_space_assign_cust_tbl.count > 0 THEN
7435: FOR I in l_space_assign_cust_tbl.FIRST .. l_space_assign_cust_tbl.LAST LOOP
7436: l_index := NVL(l_index,0) + 1;
7437: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl : '||l_index);
7438: l_space_assign_tbl(l_index).assignment_id :=
7439: l_space_assign_cust_tbl(i).assignment_id;
7440: l_space_assign_tbl(l_index).assign_start_date :=
7441: l_space_assign_cust_tbl(i).assign_start_date;

Line 7455: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl for emp: '||l_index);

7451: END IF;
7452:
7453: IF l_space_Assign_emp_tbl.count > 0 THEN
7454: FOR I in l_space_assign_emp_tbl.FIRST .. l_space_assign_emp_tbl.LAST LOOP
7455: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl for emp: '||l_index);
7456: l_index := NVL(l_index,1) + 1;
7457: l_space_assign_tbl(l_index).assignment_id :=
7458: l_space_assign_emp_tbl(i).assignment_id;
7459: l_space_assign_tbl(l_index).assign_start_date :=

Line 7476: PNP_DEBUG_PKG.log('I := ' ||i|| ' start_date ' || l_space_assign_tbl(i).assign_start_date || ' end date '|| l_space_assign_tbl(i).assign_end_date);

7472:
7473: IF l_space_assign_tbl.count > 0 THEN
7474: FOR I in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7475: L_total_area :=0;
7476: PNP_DEBUG_PKG.log('I := ' ||i|| ' start_date ' || l_space_assign_tbl(i).assign_start_date || ' end date '|| l_space_assign_tbl(i).assign_end_date);
7477:
7478: FOR J in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7479:
7480: PNP_DEBUG_PKG.log('J := ' ||J|| ' start_date ' || l_space_assign_tbl(j).assign_start_date || ' end date '|| l_space_assign_tbl(j).assign_end_date);

Line 7480: PNP_DEBUG_PKG.log('J := ' ||J|| ' start_date ' || l_space_assign_tbl(j).assign_start_date || ' end date '|| l_space_assign_tbl(j).assign_end_date);

7476: PNP_DEBUG_PKG.log('I := ' ||i|| ' start_date ' || l_space_assign_tbl(i).assign_start_date || ' end date '|| l_space_assign_tbl(i).assign_end_date);
7477:
7478: FOR J in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7479:
7480: PNP_DEBUG_PKG.log('J := ' ||J|| ' start_date ' || l_space_assign_tbl(j).assign_start_date || ' end date '|| l_space_assign_tbl(j).assign_end_date);
7481:
7482: IF l_space_assign_Tbl(j).assign_start_date =
7483: l_space_assign_tbl(i).assign_start_date AND
7484: l_space_assign_Tbl(j).assign_end_date =

Line 7495: PNP_DEBUG_PKG.log('Start date range : total : ' || l_total_area);

7491: l_space_assign_tbl(i).assign_start_date
7492: THEN
7493:
7494: l_total_area := l_total_area + l_space_assign_tbl(j).allocated_area;
7495: PNP_DEBUG_PKG.log('Start date range : total : ' || l_total_area);
7496: ElSIF l_space_assign_Tbl(j).assign_start_date <
7497: l_space_assign_tbl(i).assign_end_date AND
7498: l_space_assign_Tbl(j).assign_end_date >=
7499: l_space_assign_tbl(i).assign_end_date

Line 7502: PNP_DEBUG_PKG.log('end date range : total : ' || l_total_area);

7498: l_space_assign_Tbl(j).assign_end_date >=
7499: l_space_assign_tbl(i).assign_end_date
7500: THEN
7501:
7502: PNP_DEBUG_PKG.log('end date range : total : ' || l_total_area);
7503: l_total_area := l_total_area + l_space_assign_tbl(j).allocated_area;
7504: END IF;
7505:
7506: END LOOP;

Line 7512: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (-)');

7508: END LOOP;
7509:
7510: END IF;
7511:
7512: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (-)');
7513: EXCEPTION
7514:
7515:
7516: WHEN UNEXPECTED_ERROR THEN

Line 7518: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');

7514:
7515:
7516: WHEN UNEXPECTED_ERROR THEN
7517: x_return_status := FND_API.G_RET_STS_ERROR;
7518: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7519:
7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7522: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

Line 7524: PNP_DEBUG_PKG.log('OTHERS ERROR');

7520: WHEN OTHERS THEN
7521: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7522: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7524: PNP_DEBUG_PKG.log('OTHERS ERROR');
7525:
7526: END validate_assignable_area;
7527:
7528:

Line 7596: PNP_DEBUG_PKG.log('---------------------------------------');

7592: BEGIN
7593: -- Remove after debug
7594: x_return_status := FND_API.G_RET_STS_SUCCESS;
7595:
7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

Line 7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');

7593: -- Remove after debug
7594: x_return_status := FND_API.G_RET_STS_SUCCESS;
7595:
7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);

Line 7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');

7594: x_return_status := FND_API.G_RET_STS_SUCCESS;
7595:
7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

Line 7599: PNP_DEBUG_PKG.log('---------------------------------------');

7595:
7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

Line 7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

7596: PNP_DEBUG_PKG.log('---------------------------------------');
7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

Line 7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);

7597: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);

Line 7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

7598: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);

Line 7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

7599: PNP_DEBUG_PKG.log('---------------------------------------');
7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7607: PNP_DEBUG_PKG.log('---------------------------------------');

Line 7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

7600: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7607: PNP_DEBUG_PKG.log('---------------------------------------');
7608:

Line 7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);

7601: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7607: PNP_DEBUG_PKG.log('---------------------------------------');
7608:
7609: FOR p_location_rec in pn_location_cursor LOOP

Line 7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);

7602: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7607: PNP_DEBUG_PKG.log('---------------------------------------');
7608:
7609: FOR p_location_rec in pn_location_cursor LOOP
7610:

Line 7607: PNP_DEBUG_PKG.log('---------------------------------------');

7603: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7604: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7605: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7606: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7607: PNP_DEBUG_PKG.log('---------------------------------------');
7608:
7609: FOR p_location_rec in pn_location_cursor LOOP
7610:
7611: IF NVL(p_location_rec.active_start_date,g_start_of_time) < p_start_date OR

Line 7631: PNP_DEBUG_PKG.log('Calling PROCEDURE Validate_assignment_for_date');

7627: ELSE
7628: l_str_date_old := p_active_start_date_old;
7629: END IF;
7630:
7631: PNP_DEBUG_PKG.log('Calling PROCEDURE Validate_assignment_for_date');
7632: Validate_assignment_for_date
7633: ( p_location_id => p_location_id,
7634: p_start_date => p_start_date,
7635: p_end_date => p_end_date,

Line 7642: PNP_DEBUG_PKG.log('Error in validate_assignment_for_date');

7638: x_return_status => x_return_status,
7639: x_return_message => x_return_message);
7640:
7641: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7642: PNP_DEBUG_PKG.log('Error in validate_assignment_for_date');
7643: Raise unexpected_error;
7644: END IF;
7645: END IF;
7646: EXIT;

Line 7650: PNP_DEBUG_PKG.log('-----------------------------');

7646: EXIT;
7647:
7648: END LOOP;
7649:
7650: PNP_DEBUG_PKG.log('-----------------------------');
7651: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7652: PNP_DEBUG_PKG.log('-----------------------------');
7653:
7654: EXCEPTION

Line 7651: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');

7647:
7648: END LOOP;
7649:
7650: PNP_DEBUG_PKG.log('-----------------------------');
7651: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7652: PNP_DEBUG_PKG.log('-----------------------------');
7653:
7654: EXCEPTION
7655:

Line 7652: PNP_DEBUG_PKG.log('-----------------------------');

7648: END LOOP;
7649:
7650: PNP_DEBUG_PKG.log('-----------------------------');
7651: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7652: PNP_DEBUG_PKG.log('-----------------------------');
7653:
7654: EXCEPTION
7655:
7656: WHEN UNEXPECTED_ERROR THEN

Line 7658: PNP_DEBUG_PKG.disable_file_debug;

7654: EXCEPTION
7655:
7656: WHEN UNEXPECTED_ERROR THEN
7657: x_return_status := FND_API.G_RET_STS_ERROR;
7658: PNP_DEBUG_PKG.disable_file_debug;
7659:
7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7662: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

Line 7664: PNP_DEBUG_PKG.disable_file_debug;

7660: WHEN OTHERS THEN
7661: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7662: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7664: PNP_DEBUG_PKG.disable_file_debug;
7665:
7666: END validate_date_assignable_area;
7667:
7668: ----------------------------------------------------

Line 8181: pnp_debug_pkg.log(l_desc ||' (+)');

8177: BEGIN
8178:
8179: l_desc := 'pnp_util_func.fetch_tenancy_area';
8180:
8181: pnp_debug_pkg.log(l_desc ||' (+)');
8182:
8183: FOR area_cur IN get_tenancy_info LOOP
8184:
8185: IF p_area_type_code IN ('LOCTN_RENTABLE','LOCTN_USABLE','LOCTN_ASSIGNABLE') THEN

Line 8214: pnp_debug_pkg.log(l_desc ||' (-)');

8210: END IF;
8211: END IF;
8212: END LOOP;
8213:
8214: pnp_debug_pkg.log(l_desc ||' (-)');
8215:
8216: RETURN ROUND(l_area, 4);
8217:
8218: END fetch_tenancy_area;

Line 8587: pnp_debug_pkg.log('check_var_rent_retro - (+)');

8583: l_var_rent_num VARCHAR2(30);
8584: RETRO_VARENT_EXCEPTION EXCEPTION;
8585:
8586: BEGIN
8587: pnp_debug_pkg.log('check_var_rent_retro - (+)');
8588:
8589: FOR abat IN chk_abat_retro LOOP
8590:
8591: l_var_rent_num := abat.rent_num;

Line 8597: pnp_debug_pkg.log('check_var_rent_retro - (-)');

8593: RAISE RETRO_VARENT_EXCEPTION;
8594:
8595: END LOOP;
8596:
8597: pnp_debug_pkg.log('check_var_rent_retro - (-)');
8598: EXCEPTION
8599:
8600: WHEN RETRO_VARENT_EXCEPTION THEN
8601: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');

Line 8632: pnp_debug_pkg.log('get_yr_mth_days - (+)');

8628: l_days number;
8629: l_from_date DATE;
8630: l_to_date DATE;
8631: BEGIN
8632: pnp_debug_pkg.log('get_yr_mth_days - (+)');
8633:
8634: /* init local start - end dates */
8635: l_from_date := p_from_date;
8636: l_to_date := p_to_date;

Line 8666: pnp_debug_pkg.log('get_yr_mth_days - (-)');

8662: IF p_days<0 THEN
8663: p_days:=0;
8664: END IF;
8665:
8666: pnp_debug_pkg.log('get_yr_mth_days - (-)');
8667:
8668: END get_yr_mth_days;
8669:
8670: -------------------------------------------------------------------------------

Line 8687: pnp_debug_pkg.log('get_date_from_ymd - (+)');

8683: l_to_date DATE;
8684:
8685: BEGIN
8686:
8687: pnp_debug_pkg.log('get_date_from_ymd - (+)');
8688:
8689: IF p_from_date IS NOT NULL THEN
8690: IF NVL(p_yrs,0) = 0 AND
8691: NVL(p_mths,0) = 0 AND

Line 8716: pnp_debug_pkg.log('get_date_from_ymd - (-)');

8712: ELSE
8713: RETURN NULL;
8714: END IF;
8715:
8716: pnp_debug_pkg.log('get_date_from_ymd - (-)');
8717: END get_date_from_ymd;
8718: -- Retro End
8719:
8720: /* public view as of date setter/getters functions */