APPS.PN_LEASE_PVT dependencies on PN_LEASE_MILESTONES_PKG

Line 8530: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW:',3);

8526: for l_index in p_milestone_tbl.FIRST..p_milestone_tbl.LAST LOOP
8527: ----------------------dbms_output.put_line('In MILESTONE_INSERT_ROW IN FOR OUT IF'||p_tbl(l_index).temp_flag);--Rupak
8528: IF p_tbl(l_index).temp_flag = 1 THEN
8529: ----------------------dbms_output.put_line('In MILESTONE_INSERT_ROWIN IF');--Rupak
8530: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW:',3);
8531: l_milestone_id := NULL;
8532: pn_lease_milestones_pkg.insert_row(
8533: X_ROWID => l_row_id,
8534: X_LEASE_MILESTONE_ID => l_milestone_id,

Line 8532: pn_lease_milestones_pkg.insert_row(

8528: IF p_tbl(l_index).temp_flag = 1 THEN
8529: ----------------------dbms_output.put_line('In MILESTONE_INSERT_ROWIN IF');--Rupak
8530: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW:',3);
8531: l_milestone_id := NULL;
8532: pn_lease_milestones_pkg.insert_row(
8533: X_ROWID => l_row_id,
8534: X_LEASE_MILESTONE_ID => l_milestone_id,
8535: X_LEASE_CHANGE_ID => p_lease_change_id,
8536: X_MILESTONE_TYPE_CODE => p_milestone_tbl(l_index).milestone_type_code,

Line 8572: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW Successful',3);

8568: x_org_id => fnd_global.org_id
8569: );
8570:
8571: ----------------------dbms_output.put_line('RECORD FOR MILESTONE CREATED WITH MILESTONE ID: '|| l_milestone_id);--Rupak
8572: pvt_debug(g_pkg_name||'-MILESTONE_INSERT_ROW:Calling PN_LEASE_MILESTONES_PKG.INSERT_ROW Successful',3);
8573: p_milestone_tbl(l_index).lease_milestone_id := l_milestone_id;
8574: END IF;
8575: END loop;
8576:

Line 9006: pn_lease_milestones_pkg.Update_Row (

9002: ----------------------dbms_output.put_line ('p_milestone_tbl(l_index).lead_days'||p_milestone_tbl(l_index).lead_days);--Rupak
9003: ----------------------dbms_output.put_line ('p_milestone_tbl(l_index).frequency'||p_milestone_tbl(l_index).frequency);--Rupak
9004: pvt_debug(g_pkg_name||'-Inside MILESTONE_UPDATE_ROW',3);
9005: BEGIN
9006: pn_lease_milestones_pkg.Update_Row (
9007: X_LEASE_MILESTONE_ID => p_milestone_tbl(l_index).lease_milestone_id,
9008: X_LEASE_CHANGE_ID => p_lease_change_id,
9009: X_MILESTONE_TYPE_CODE => p_milestone_tbl(l_index).milestone_type_code,
9010: X_OPTION_ID => p_option_id,

Line 9042: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW Successful',3);

9038: X_LAST_UPDATE_LOGIN => fnd_global.user_id
9039: );
9040:
9041: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR MILESTONES');--Rupak
9042: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW Successful',3);
9043: EXCEPTION
9044: WHEN OTHERS THEN
9045: ----------------------dbms_output.put_line('EXCEPTION MILE STONES:'||SQLERRM);
9046: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW:Exception'||SQLERRM,3);

Line 9046: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW:Exception'||SQLERRM,3);

9042: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW Successful',3);
9043: EXCEPTION
9044: WHEN OTHERS THEN
9045: ----------------------dbms_output.put_line('EXCEPTION MILE STONES:'||SQLERRM);
9046: pvt_debug(g_pkg_name||'-MILESTONE_UPDATE_ROW:PN_LEASE_MILESTONES_PKG.UPDATE_ROW:Exception'||SQLERRM,3);
9047: END;
9048: END IF;
9049: END loop;
9050: x_return_status := fnd_api.g_ret_sts_success;