APPS.PN_LEASE_PVT dependencies on PN_INSURANCE_REQUIREMENTS_PKG

Line 9452: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:Calling PN_INSURANCE_REQUIREMENTS_PKG.INSERT_ROW',3);

9448:
9449: ----------------------dbms_output.put_line('temp flag value in insert proc: '|| p_tbl(l_index).temp_flag);
9450: IF p_tbl(l_index).temp_flag = 1 THEN
9451: l_insurance_requirement_id := NULL;
9452: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:Calling PN_INSURANCE_REQUIREMENTS_PKG.INSERT_ROW',3);
9453: pn_insurance_requirements_pkg.insert_row (
9454: X_ROWID => l_row_id
9455: ,X_INSURANCE_REQUIREMENT_ID => l_insurance_requirement_id
9456: ,X_INSURANCE_TYPE_LOOKUP_CODE => p_insurance_tbl(l_index).insurance_type_lookup_code

Line 9453: pn_insurance_requirements_pkg.insert_row (

9449: ----------------------dbms_output.put_line('temp flag value in insert proc: '|| p_tbl(l_index).temp_flag);
9450: IF p_tbl(l_index).temp_flag = 1 THEN
9451: l_insurance_requirement_id := NULL;
9452: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:Calling PN_INSURANCE_REQUIREMENTS_PKG.INSERT_ROW',3);
9453: pn_insurance_requirements_pkg.insert_row (
9454: X_ROWID => l_row_id
9455: ,X_INSURANCE_REQUIREMENT_ID => l_insurance_requirement_id
9456: ,X_INSURANCE_TYPE_LOOKUP_CODE => p_insurance_tbl(l_index).insurance_type_lookup_code
9457: ,X_LEASE_ID => p_lease_id

Line 9493: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:PN_INSURANCE_REQUIREMENTS_PKG.INSERT_ROW Succesful',3);

9489: );
9490:
9491: --SAVEPOINT A;
9492: ----------------------dbms_output.put_line ('INSURANCE ROW CREATED');--Rupak
9493: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:PN_INSURANCE_REQUIREMENTS_PKG.INSERT_ROW Succesful',3);
9494: IF l_insurance_requirement_id IS NOT NULL AND p_insurance_tbl(l_index).insurance_milestone_tbl.count <> 0 THEN
9495: ----------------------dbms_output.put_line ('--------CREATE MILESTONE------');--Rupak
9496: pvt_debug(g_pkg_name||'-INSURANCE_INSERT_ROW:Calling CREATE_MILESTONE',3);
9497: CREATE_MILESTONE (

Line 9984: pn_insurance_requirements_pkg.Update_Row

9980: IF p_tbl(l_index).temp_flag = 2 THEN
9981: ----------------------dbms_output.put_line('UPDATE INSURANCE PROCEDURE FOR RECORD: '||l_index ||'STARTED');--Rupak
9982: pvt_debug(g_pkg_name||'-INSURANCE_UPDATE_ROW:'||'UPDATE INSURANCE PROCEDURE FOR RECORD: '||l_index ||'STARTED',3);
9983: BEGIN
9984: pn_insurance_requirements_pkg.Update_Row
9985: (
9986: X_INSURANCE_REQUIREMENT_ID => p_insurance_tbl(l_index).insurance_requirement_id,
9987: X_INSURANCE_TYPE_LOOKUP_CODE => p_insurance_tbl(l_index).insurance_type_lookup_code,
9988: X_LEASE_ID => p_lease_id,

Line 10026: pvt_debug(g_pkg_name||'-INSURANCE_UPDATE_ROW:PN_INSURANCE_REQUIREMENTS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);

10022: l_insurance_requirement_id := p_insurance_tbl(l_index).insurance_requirement_id;
10023: EXCEPTION
10024: WHEN OTHERS THEN
10025: ----------------------dbms_output.put_line('EXCEPTION:In INSURANCE_UPDATE_ROW:3'||SQLERRM);--Rupak
10026: pvt_debug(g_pkg_name||'-INSURANCE_UPDATE_ROW:PN_INSURANCE_REQUIREMENTS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);
10027: END;
10028: IF p_insurance_tbl(l_index).insurance_milestone_tbl.count<>0 THEN
10029: ----------------------dbms_output.put_line('UPDATE MILESTONE PROCEDURE FOR RECORD: '||l_index ||'STARTED');--Rupak
10030: UPDATE_MILESTONE (