DBA Data[Home] [Help]

APPS.PN_LEASE_PVT dependencies on PN_RIGHTS_PKG

Line 6562: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:Calling PN_RIGHTS_PKG.INSERT_ROW',3);

6558: INITIALIZE_RIGHTS_REC( p_right_rec => p_right_tbl(l_index)
6559: , p_lease_context => 'CREATE_RIGHTS'
6560: , x_return_status => x_return_status
6561: );
6562: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:Calling PN_RIGHTS_PKG.INSERT_ROW',3);
6563: pn_rights_pkg.insert_row(
6564: x_rowid => l_row_id
6565: , x_right_id => l_right_id
6566: , x_right_num => p_right_tbl(l_index).right_num

Line 6563: pn_rights_pkg.insert_row(

6559: , p_lease_context => 'CREATE_RIGHTS'
6560: , x_return_status => x_return_status
6561: );
6562: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:Calling PN_RIGHTS_PKG.INSERT_ROW',3);
6563: pn_rights_pkg.insert_row(
6564: x_rowid => l_row_id
6565: , x_right_id => l_right_id
6566: , x_right_num => p_right_tbl(l_index).right_num
6567: , x_lease_id => p_lease_id

Line 6600: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW Successful',3);

6596: , x_org_id => fnd_global.org_id
6597: );
6598:
6599: ----------------------dbms_output.put_line('RECORD FOR RIGHTS CREATED WITH RIGHT ID: '|| l_right_id);--Rupak
6600: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW Successful',3);
6601: p_right_tbl(l_index).right_id := l_right_id;
6602: EXCEPTION
6603: WHEN OTHERS THEN
6604: --NULL

Line 6606: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW:Exception'||SQLERRM,3);

6602: EXCEPTION
6603: WHEN OTHERS THEN
6604: --NULL
6605: ----------------------dbms_output.put_line('Exception In Insert RIGHTS'||SQLERRM);
6606: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW:Exception'||SQLERRM,3);
6607: END;
6608: -- END IF;
6609: END loop;
6610:

Line 7021: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:Calling PN_RIGHTS_PKG.UPDATE_ROW',3);

7017: ----------------------dbms_output.put_line (' RIGHT_UPDATE_ROW :IN FOR'||p_tbl(l_index).temp_flag);--Rupak
7018: BEGIN
7019: IF p_tbl(l_index).temp_flag = 2 THEN
7020: ----------------------dbms_output.put_line (' RIGHT_UPDATE_ROW:IN IF RRECORD UPDATION STARTED FOR RIGHTS');--Rupak
7021: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:Calling PN_RIGHTS_PKG.UPDATE_ROW',3);
7022:
7023: pn_rights_pkg.update_row(
7024: x_right_id => p_right_tbl(l_index).right_id
7025: , x_lease_id => p_lease_id

Line 7023: pn_rights_pkg.update_row(

7019: IF p_tbl(l_index).temp_flag = 2 THEN
7020: ----------------------dbms_output.put_line (' RIGHT_UPDATE_ROW:IN IF RRECORD UPDATION STARTED FOR RIGHTS');--Rupak
7021: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:Calling PN_RIGHTS_PKG.UPDATE_ROW',3);
7022:
7023: pn_rights_pkg.update_row(
7024: x_right_id => p_right_tbl(l_index).right_id
7025: , x_lease_id => p_lease_id
7026: , x_lease_change_id => p_lease_change_id
7027: , x_right_num => p_right_tbl(l_index).right_num

Line 7057: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:PN_RIGHTS_PKG.UPDATE_ROW Successful',3);

7053: );
7054:
7055:
7056: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR RIGHTS');--Rupak
7057: pvt_debug(g_pkg_name||'-RIGHT_UPDATE_ROW:PN_RIGHTS_PKG.UPDATE_ROW Successful',3);
7058:
7059: END IF;
7060: EXCEPTION
7061: WHEN OTHERS THEN

Line 7063: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW:Exception'||SQLERRM,3);

7059: END IF;
7060: EXCEPTION
7061: WHEN OTHERS THEN
7062: l_right_count := l_right_count+1;
7063: pvt_debug(g_pkg_name||'-RIGHT_INSERT_ROW:PN_RIGHTS_PKG.INSERT_ROW:Exception'||SQLERRM,3);
7064: END;
7065: END LOOP;
7066: IF l_right_count = 0 THEN
7067: x_return_status := fnd_api.g_ret_sts_success;