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 2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');

2746: INVALID_TERMINATION_DATE EXCEPTION;
2747:
2748: BEGIN
2749:
2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);

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

2747:
2748: BEGIN
2749:
2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);

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

2748: BEGIN
2749:
2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2756: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);

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

2749:
2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2756: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2757:

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

2750: PNP_DEBUG_PKG.log('+++ valid_early_term_date +++');
2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2756: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2757:
2758: /* lease ID must always be passed */

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

2751: PNP_DEBUG_PKG.log('p_lease_id :'||p_lease_id);
2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2756: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2757:
2758: /* lease ID must always be passed */
2759: IF p_lease_id IS NULL OR

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

2752: PNP_DEBUG_PKG.log('p_term_id :'||p_term_id);
2753: PNP_DEBUG_PKG.log('p_normalized :'||p_normalized);
2754: PNP_DEBUG_PKG.log('p_frequency :'||p_frequency);
2755: PNP_DEBUG_PKG.log('p_termination_date :'||p_termination_date);
2756: PNP_DEBUG_PKG.log('p_called_from :'||p_called_from);
2757:
2758: /* lease ID must always be passed */
2759: IF p_lease_id IS NULL OR
2760: p_termination_date IS NULL THEN

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

2892:
2893: EXCEPTION
2894:
2895: WHEN INVALID_PARAM THEN
2896: PNP_DEBUG_PKG.log('Invalid PARAM passed.');
2897: RETURN FALSE;
2898:
2899: WHEN INVALID_TERMINATION_DATE THEN
2900: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');

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

2900: fnd_message.set_name ('PN', 'PN_NO_EARLY_TERMINATE_NORM');
2901: RETURN FALSE;
2902:
2903: WHEN OTHERS THEN
2904: PNP_DEBUG_PKG.log('Something went wrong here!! - '||SQLCODE||': '||SQLERRM);
2905: RETURN FALSE;
2906:
2907: END valid_early_term_date;
2908:

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

6121: AND active_start_date <= l_end_dt
6122: AND active_end_date >= p_st_date;
6123:
6124: BEGIN
6125: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');
6126:
6127: pnp_util_func.fetch_loctn_area(
6128: p_type => pnp_util_func.get_location_type_lookup_code
6129: (

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

6210: EXCEPTION
6211:
6212: WHEN OTHERS THEN
6213: RAISE;
6214: PNP_DEBUG_PKG.debug ('validate_vacant_area(+)');
6215: END validate_vacant_area;
6216:
6217:
6218: /*===========================================================================+

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

6965: l_api_name VARCHAR2(50) := 'pnp_util_func.get_space_assignments';
6966:
6967: BEGIN
6968:
6969: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);

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

6966:
6967: BEGIN
6968:
6969: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);

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

6967: BEGIN
6968:
6969: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);

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

6968:
6969: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
6976: PNP_DEBUG_PKG.DEBUG('----------------------------------');

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

6969: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
6976: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6977:

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

6970: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (+)');
6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
6976: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6977:
6978:

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

6971: PNP_DEBUG_PKG.DEBUG('Get space assignments:INPUT');
6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
6976: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6977:
6978:
6979:

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

6972: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6973: PNP_DEBUG_PKG.DEBUG('Location id : ' || p_location_id);
6974: PNP_DEBUG_PKG.DEBUG('Start Date : ' || p_start_date);
6975: PNP_DEBUG_PKG.DEBUG('End Date : ' || p_end_date);
6976: PNP_DEBUG_PKG.DEBUG('----------------------------------');
6977:
6978:
6979:
6980: FOR space_assign_cust_rec in pn_space_assign_cust_cursor

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

6979:
6980: FOR space_assign_cust_rec in pn_space_assign_cust_cursor
6981: LOOP
6982: l_index := l_index + 1;
6983: PNP_DEBUG_PKG.DEBUG('Assigning Cust data index : '|| l_index);
6984: l_space_assign_cust_tbl(l_index).cust_account_id :=
6985: space_assign_cust_rec.cust_account_id ;
6986: l_space_assign_cust_tbl(l_index).location_id :=
6987: space_assign_cust_rec.location_id ;

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

7013:
7014: FOR space_assign_emp_rec in pn_space_assign_emp_cursor
7015: LOOP
7016: l_index := l_index + 1;
7017: PNP_DEBUG_PKG.DEBUG('Assigning emp data index : '|| l_index);
7018: l_space_assign_emp_tbl(l_index).person_id :=
7019: space_assign_emp_rec.person_id ;
7020: l_space_assign_emp_tbl(l_index).location_id :=
7021: space_assign_emp_rec.location_id ;

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

7041: END LOOP;
7042: x_space_assign_emp_tbl := l_space_assign_emp_tbl;
7043:
7044: x_return_status := FND_API.G_RET_STS_SUCCESS;
7045: PNP_DEBUG_PKG.DEBUG('pnp_util_func.get_space_assignments (-)');
7046:
7047: EXCEPTION
7048: WHEN OTHERS THEN
7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

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

7048: WHEN OTHERS THEN
7049: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7050: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7051: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7052: PNP_DEBUG_PKG.DEBUG('OTHERS EXCEPTION');
7053:
7054:
7055: END get_space_assignments;
7056:

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

7152:
7153: BEGIN
7154: x_return_status := FND_API.G_RET_STS_SUCCESS;
7155:
7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

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

7153: BEGIN
7154: x_return_status := FND_API.G_RET_STS_SUCCESS;
7155:
7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

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

7154: x_return_status := FND_API.G_RET_STS_SUCCESS;
7155:
7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

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

7155:
7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7163: PNP_DEBUG_PKG.log('----------------------------------');

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

7156: PNP_DEBUG_PKG.log('----------------------------------');
7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7163: PNP_DEBUG_PKG.log('----------------------------------');
7164:

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

7157: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignment_for_date (+)');
7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7163: PNP_DEBUG_PKG.log('----------------------------------');
7164:
7165: IF p_start_date > p_start_date_old THEN

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

7158: PNP_DEBUG_PKG.log('Validate Assignment for date:INPUT');
7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7163: PNP_DEBUG_PKG.log('----------------------------------');
7164:
7165: IF p_start_date > p_start_date_old THEN
7166:

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

7159: PNP_DEBUG_PKG.log('----------------------------------');
7160: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7161: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7162: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7163: PNP_DEBUG_PKG.log('----------------------------------');
7164:
7165: IF p_start_date > p_start_date_old THEN
7166:
7167: FOR validate_start_date_rec in validate_start_date_cursor LOOP

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

7181: END LOOP;
7182:
7183: END IF;
7184:
7185: PNP_DEBUG_PKG.DEBUG('pnp_util_func.validate_assignment_for_date (-)');
7186:
7187: EXCEPTION
7188:
7189: WHEN USER_DEF_ERROR THEN

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

7188:
7189: WHEN USER_DEF_ERROR THEN
7190: x_return_status := FND_API.G_RET_STS_ERROR;
7191: fnd_message.set_name('PN','PN_INVALID_DATE_EFFECTIVITY');
7192: PNP_DEBUG_PKG.log('Assignment found for dates');
7193:
7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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

7194: WHEN OTHERS THEN
7195: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7196: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7198: PNP_DEBUG_PKG.log('OTHERS ERROR');
7199:
7200: END validate_assignment_for_date;
7201:
7202:

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

7242:
7243: UNEXPECTED_ERROR EXCEPTION;
7244: BEGIN
7245:
7246: PNP_DEBUG_PKG.log('----------------------------------');
7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

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

7243: UNEXPECTED_ERROR EXCEPTION;
7244: BEGIN
7245:
7246: PNP_DEBUG_PKG.log('----------------------------------');
7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

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

7244: BEGIN
7245:
7246: PNP_DEBUG_PKG.log('----------------------------------');
7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

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

7245:
7246: PNP_DEBUG_PKG.log('----------------------------------');
7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

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

7246: PNP_DEBUG_PKG.log('----------------------------------');
7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');

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

7247: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (+)');
7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');

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

7248: PNP_DEBUG_PKG.log('Validate Assignable area: INPUT');
7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');
7256:

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

7249: PNP_DEBUG_PKG.log('----------------------------------');
7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');
7256:
7257: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

7250: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');
7256:
7257: x_return_status := FND_API.G_RET_STS_SUCCESS;
7258: Get_space_assignments (

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

7251: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7252: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7253: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7254: PNP_DEBUG_PKG.log('----------------------------------');
7255: PNP_DEBUG_PKG.log('Calling get space assignments');
7256:
7257: x_return_status := FND_API.G_RET_STS_SUCCESS;
7258: Get_space_assignments (
7259: p_location_id => p_location_id,

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

7265: x_return_message => x_return_message
7266: );
7267:
7268: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7269: PNP_DEBUG_PKG.log('Error in get space_assignments');
7270: Raise unexpected_error;
7271: END IF;
7272:
7273: IF l_space_assign_cust_tbl.count > 0 THEN

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

7272:
7273: IF l_space_assign_cust_tbl.count > 0 THEN
7274: FOR I in l_space_assign_cust_tbl.FIRST .. l_space_assign_cust_tbl.LAST LOOP
7275: l_index := NVL(l_index,0) + 1;
7276: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl : '||l_index);
7277: l_space_assign_tbl(l_index).assignment_id :=
7278: l_space_assign_cust_tbl(i).assignment_id;
7279: l_space_assign_tbl(l_index).assign_start_date :=
7280: l_space_assign_cust_tbl(i).assign_start_date;

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

7290: END IF;
7291:
7292: IF l_space_Assign_emp_tbl.count > 0 THEN
7293: FOR I in l_space_assign_emp_tbl.FIRST .. l_space_assign_emp_tbl.LAST LOOP
7294: PNP_DEBUG_PKG.log('Assigning values to l_space_assign_tbl for emp: '||l_index);
7295: l_index := NVL(l_index,1) + 1;
7296: l_space_assign_tbl(l_index).assignment_id :=
7297: l_space_assign_emp_tbl(i).assignment_id;
7298: l_space_assign_tbl(l_index).assign_start_date :=

Line 7315: 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);

7311:
7312: IF l_space_assign_tbl.count > 0 THEN
7313: FOR I in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7314: L_total_area :=0;
7315: 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);
7316:
7317: FOR J in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7318:
7319: 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 7319: 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);

7315: 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);
7316:
7317: FOR J in l_space_assign_tbl.FIRST .. l_space_assign_tbl.LAST LOOP
7318:
7319: 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);
7320:
7321: IF l_space_assign_Tbl(j).assign_start_date =
7322: l_space_assign_tbl(i).assign_start_date AND
7323: l_space_assign_Tbl(j).assign_end_date =

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

7330: l_space_assign_tbl(i).assign_start_date
7331: THEN
7332:
7333: l_total_area := l_total_area + l_space_assign_tbl(j).allocated_area;
7334: PNP_DEBUG_PKG.log('Start date range : total : ' || l_total_area);
7335: ElSIF l_space_assign_Tbl(j).assign_start_date <
7336: l_space_assign_tbl(i).assign_end_date AND
7337: l_space_assign_Tbl(j).assign_end_date >=
7338: l_space_assign_tbl(i).assign_end_date

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

7337: l_space_assign_Tbl(j).assign_end_date >=
7338: l_space_assign_tbl(i).assign_end_date
7339: THEN
7340:
7341: PNP_DEBUG_PKG.log('end date range : total : ' || l_total_area);
7342: l_total_area := l_total_area + l_space_assign_tbl(j).allocated_area;
7343: END IF;
7344:
7345: END LOOP;

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

7347: END LOOP;
7348:
7349: END IF;
7350:
7351: PNP_DEBUG_PKG.log('pnp_util_func.validate_assignable_area (-)');
7352: EXCEPTION
7353:
7354:
7355: WHEN UNEXPECTED_ERROR THEN

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

7353:
7354:
7355: WHEN UNEXPECTED_ERROR THEN
7356: x_return_status := FND_API.G_RET_STS_ERROR;
7357: PNP_DEBUG_PKG.log('UNEXPECTED ERROR');
7358:
7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

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

7359: WHEN OTHERS THEN
7360: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7361: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7363: PNP_DEBUG_PKG.log('OTHERS ERROR');
7364:
7365: END validate_assignable_area;
7366:
7367:

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

7431: BEGIN
7432: -- Remove after debug
7433: x_return_status := FND_API.G_RET_STS_SUCCESS;
7434:
7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);

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

7432: -- Remove after debug
7433: x_return_status := FND_API.G_RET_STS_SUCCESS;
7434:
7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);

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

7433: x_return_status := FND_API.G_RET_STS_SUCCESS;
7434:
7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);

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

7434:
7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);

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

7435: PNP_DEBUG_PKG.log('---------------------------------------');
7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);

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

7436: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (+)');
7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);

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

7437: PNP_DEBUG_PKG.log('Validate date assignable_area : INPUT PARAMS');
7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);

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

7438: PNP_DEBUG_PKG.log('---------------------------------------');
7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7446: PNP_DEBUG_PKG.log('---------------------------------------');

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

7439: PNP_DEBUG_PKG.log('Location id : ' || p_location_id);
7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7446: PNP_DEBUG_PKG.log('---------------------------------------');
7447:

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

7440: PNP_DEBUG_PKG.log('Location Type : ' || p_location_type);
7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7446: PNP_DEBUG_PKG.log('---------------------------------------');
7447:
7448: FOR p_location_rec in pn_location_cursor LOOP

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

7441: PNP_DEBUG_PKG.log('Start Date : ' || p_start_date);
7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7446: PNP_DEBUG_PKG.log('---------------------------------------');
7447:
7448: FOR p_location_rec in pn_location_cursor LOOP
7449:

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

7442: PNP_DEBUG_PKG.log('End Date : ' || p_end_date);
7443: PNP_DEBUG_PKG.log('Assignable Area : ' || p_assignable_area);
7444: PNP_DEBUG_PKG.log('Start date old : ' || p_active_start_date_old);
7445: PNP_DEBUG_PKG.log('End date old : ' || p_active_end_date_old);
7446: PNP_DEBUG_PKG.log('---------------------------------------');
7447:
7448: FOR p_location_rec in pn_location_cursor LOOP
7449:
7450: IF NVL(p_location_rec.active_start_date,g_start_of_time) < p_start_date OR

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

7466: ELSE
7467: l_str_date_old := p_active_start_date_old;
7468: END IF;
7469:
7470: PNP_DEBUG_PKG.log('Calling PROCEDURE Validate_assignment_for_date');
7471: Validate_assignment_for_date
7472: ( p_location_id => p_location_id,
7473: p_start_date => p_start_date,
7474: p_end_date => p_end_date,

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

7477: x_return_status => x_return_status,
7478: x_return_message => x_return_message);
7479:
7480: IF not(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7481: PNP_DEBUG_PKG.log('Error in validate_assignment_for_date');
7482: Raise unexpected_error;
7483: END IF;
7484: END IF;
7485: EXIT;

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

7485: EXIT;
7486:
7487: END LOOP;
7488:
7489: PNP_DEBUG_PKG.log('-----------------------------');
7490: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7491: PNP_DEBUG_PKG.log('-----------------------------');
7492:
7493: EXCEPTION

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

7486:
7487: END LOOP;
7488:
7489: PNP_DEBUG_PKG.log('-----------------------------');
7490: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7491: PNP_DEBUG_PKG.log('-----------------------------');
7492:
7493: EXCEPTION
7494:

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

7487: END LOOP;
7488:
7489: PNP_DEBUG_PKG.log('-----------------------------');
7490: PNP_DEBUG_PKG.log('pnp_util_func.validate_date_assignable_area (-)');
7491: PNP_DEBUG_PKG.log('-----------------------------');
7492:
7493: EXCEPTION
7494:
7495: WHEN UNEXPECTED_ERROR THEN

Line 7497: PNP_DEBUG_PKG.disable_file_debug;

7493: EXCEPTION
7494:
7495: WHEN UNEXPECTED_ERROR THEN
7496: x_return_status := FND_API.G_RET_STS_ERROR;
7497: PNP_DEBUG_PKG.disable_file_debug;
7498:
7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);

Line 7503: PNP_DEBUG_PKG.disable_file_debug;

7499: WHEN OTHERS THEN
7500: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
7501: fnd_message.set_token('ERR_MSG',l_api_name||'='|| sqlerrm);
7502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7503: PNP_DEBUG_PKG.disable_file_debug;
7504:
7505: END validate_date_assignable_area;
7506:
7507: ----------------------------------------------------

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

8009: BEGIN
8010:
8011: l_desc := 'pnp_util_func.fetch_tenancy_area';
8012:
8013: pnp_debug_pkg.log(l_desc ||' (+)');
8014:
8015: FOR area_cur IN get_tenancy_info LOOP
8016:
8017: IF p_area_type_code IN ('LOCTN_RENTABLE','LOCTN_USABLE','LOCTN_ASSIGNABLE') THEN

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

8042: END IF;
8043: END IF;
8044: END LOOP;
8045:
8046: pnp_debug_pkg.log(l_desc ||' (-)');
8047:
8048: RETURN ROUND(l_area, 2);
8049:
8050: END fetch_tenancy_area;

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

8415: l_var_rent_num VARCHAR2(30);
8416: RETRO_VARENT_EXCEPTION EXCEPTION;
8417:
8418: BEGIN
8419: pnp_debug_pkg.log('check_var_rent_retro - (+)');
8420:
8421: FOR abat IN chk_abat_retro LOOP
8422:
8423: l_var_rent_num := abat.rent_num;

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

8425: RAISE RETRO_VARENT_EXCEPTION;
8426:
8427: END LOOP;
8428:
8429: pnp_debug_pkg.log('check_var_rent_retro - (-)');
8430: EXCEPTION
8431:
8432: WHEN RETRO_VARENT_EXCEPTION THEN
8433: fnd_message.set_name('PN', 'PN_RETRO_VARENT_ERR');

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

8460: l_days number;
8461: l_from_date DATE;
8462: l_to_date DATE;
8463: BEGIN
8464: pnp_debug_pkg.log('get_yr_mth_days - (+)');
8465:
8466: /* init local start - end dates */
8467: l_from_date := p_from_date;
8468: l_to_date := p_to_date;

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

8494: IF p_days<0 THEN
8495: p_days:=0;
8496: END IF;
8497:
8498: pnp_debug_pkg.log('get_yr_mth_days - (-)');
8499:
8500: END get_yr_mth_days;
8501:
8502: -------------------------------------------------------------------------------

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

8515: l_to_date DATE;
8516:
8517: BEGIN
8518:
8519: pnp_debug_pkg.log('get_yr_mth_days - (+)');
8520:
8521: IF p_from_date IS NOT NULL THEN
8522: IF NVL(p_yrs,0) = 0 AND
8523: NVL(p_mths,0) = 0 AND

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

8534: ELSE
8535: RETURN NULL;
8536: END IF;
8537:
8538: pnp_debug_pkg.log('get_yr_mth_days - (-)');
8539: END get_date_from_ymd;
8540: -- Retro End
8541:
8542: /* public view as of date setter/getters functions */