APPS.PN_LEASE_PVT dependencies on PN_LANDLORD_SERVICES_PKG

Line 7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);

7557: --l_index := 1;
7558: ----------------------dbms_output.put_line('In OBLIGATION_INSERT_ROW:p_obligation_tblIN FOR OUTSIDE IF'||p_obligation_tbl(l_index).temp_flag);--Rupak
7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,
7565: X_LANDLORD_SERVICE_ID => l_landlord_service_id,

Line 7563: PN_LANDLORD_SERVICES_PKG.insert_row(

7559: IF p_tbl(l_index).temp_flag = 1 THEN
7560: ----------------------dbms_output.put_line ('INSERT ROW INTO PN_LANDLORD_SERVICES_ALL STARTED FOR OBLIGATIONS');--Rupak
7561: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Calling PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7562: l_landlord_service_id := NULL;
7563: PN_LANDLORD_SERVICES_PKG.insert_row(
7564: X_ROWID => l_row_id,
7565: X_LANDLORD_SERVICE_ID => l_landlord_service_id,
7566: X_LEASE_ID => p_lease_id,
7567: X_LEASE_CHANGE_ID => p_lease_change_id,

Line 7604: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:PN_LANDLORD_SERVICES_PKG.INSERT_ROW Successful',3);

7600: X_OBLIGATION_REFERENCE => p_obligation_tbl(l_index).obligation_reference,
7601: X_OBLIGATION_COMMENTS => p_obligation_tbl(l_index).obligation_comments,
7602: X_org_id => fnd_global.org_id
7603: );
7604: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:PN_LANDLORD_SERVICES_PKG.INSERT_ROW Successful',3);
7605: ----------------------dbms_output.put_line (' RECORD : '||l_index|| ' WITH landlord_service_id: '||l_landlord_service_id||' INSERTED');
7606: p_obligation_tbl(l_index).landlord_service_id := p_obligation_tbl(l_index).landlord_service_id;
7607: END IF;
7608:

Line 7616: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Exception:PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);

7612: WHEN OTHERS THEN
7613: x_return_status := fnd_api.g_ret_sts_unexp_error;
7614: ----------------------dbms_output.put_line('INSERT INTO OBLIGATIONS FAILED') ;
7615: ----------------------dbms_output.put_line('In OBLIGATION INSERT ROW PROC:sqlcode: '||sqlcode||'and sqlerrm: '||sqlerrm);--Rupak
7616: pvt_debug(g_pkg_name||'-OBLIGATION_INSERT_ROW:Exception:PN_LANDLORD_SERVICES_PKG.INSERT_ROW',3);
7617: END OBLIGATION_INSERT_ROW;
7618:
7619: PROCEDURE CREATE_OBLIGATION (
7620: p_lease_id IN NUMBER

Line 8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);

8124: BEGIN
8125: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP');--Rupak
8126: IF p_tbl(l_index).temp_flag = 2 THEN
8127: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP IN IF');--Rupak
8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);
8129: BEGIN
8130: PN_LANDLORD_SERVICES_PKG.update_Row
8131: (
8132: X_LANDLORD_SERVICE_ID => p_obligation_tbl(l_index).landlord_service_id,

Line 8130: PN_LANDLORD_SERVICES_PKG.update_Row

8126: IF p_tbl(l_index).temp_flag = 2 THEN
8127: ----------------------dbms_output.put_line('RECORD UPDATE STARTED FOR OBLIGATIONSIN FOR LOOP IN IF');--Rupak
8128: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Calling PN_LANDLORD_SERVICES_PKG.update_Row',3);
8129: BEGIN
8130: PN_LANDLORD_SERVICES_PKG.update_Row
8131: (
8132: X_LANDLORD_SERVICE_ID => p_obligation_tbl(l_index).landlord_service_id,
8133: X_LEASE_ID => p_lease_id,
8134: X_LEASE_CHANGE_ID => p_lease_change_id,

Line 8169: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:PN_LANDLORD_SERVICES_PKG.update_Row Successful',3);

8165: X_OBLIGATION_REFERENCE => p_obligation_tbl(l_index).obligation_reference,
8166: X_OBLIGATION_COMMENTS => p_obligation_tbl(l_index).obligation_comments
8167: );
8168: ----------------------dbms_output.put_line('RECORD '||l_index||' UPDATED FOR OBLIGATIONS');--Rupak
8169: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:PN_LANDLORD_SERVICES_PKG.update_Row Successful',3);
8170:
8171: EXCEPTION
8172: WHEN OTHERS THEN
8173: ----------------------dbms_output.put_line('EXCEPTION:UPDATE OBLIGATIONS'||SQLERRM);--Rupak

Line 8174: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Exception:PN_LANDLORD_SERVICES_PKG.update_Row'||SQLERRM,3);

8170:
8171: EXCEPTION
8172: WHEN OTHERS THEN
8173: ----------------------dbms_output.put_line('EXCEPTION:UPDATE OBLIGATIONS'||SQLERRM);--Rupak
8174: pvt_debug(g_pkg_name||'-OBLIGATION_UPDATE_ROW:Exception:PN_LANDLORD_SERVICES_PKG.update_Row'||SQLERRM,3);
8175: null;
8176: END;
8177: END IF;
8178: EXCEPTION