APPS.PN_LEASE_PVT dependencies on PN_OPTIONS_PKG

Line 10563: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling pn_options_pkg.insert_row',3);

10559: pvt_debug(g_pkg_name||'-Inside OPTION_INSERT_ROW',3);
10560: for l_index in p_option_tbl.FIRST..p_option_tbl.LAST loop
10561: IF p_tbl(l_index).temp_flag = 1 THEN
10562: ----------------------dbms_output.put_line('Options:Insert Row'); --Rupak
10563: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling pn_options_pkg.insert_row',3);
10564: l_option_id := NULL;
10565: BEGIN
10566: pn_options_pkg.insert_row (
10567: x_rowid => l_row_id

Line 10566: pn_options_pkg.insert_row (

10562: ----------------------dbms_output.put_line('Options:Insert Row'); --Rupak
10563: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling pn_options_pkg.insert_row',3);
10564: l_option_id := NULL;
10565: BEGIN
10566: pn_options_pkg.insert_row (
10567: x_rowid => l_row_id
10568: , x_option_id => l_option_id
10569: , x_attribute14 => p_option_tbl(l_index).attribute14
10570: , x_attribute15 => p_option_tbl(l_index).attribute15

Line 10611: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling PN_OPTIONS_PKG.INSERT_ROW Successful',3);

10607: , x_org_id => fnd_global.org_id
10608: );
10609:
10610: ----------------------dbms_output.put_line('Options:AFter Insert Row');--Rupak
10611: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Calling PN_OPTIONS_PKG.INSERT_ROW Successful',3);
10612: EXCEPTION
10613: WHEN OTHERS THEN
10614: --NULL
10615: ----------------------dbms_output.put_line('ERROR IN OPTIONS INSERTION:'||SQLERRM);

Line 10616: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Exception:PN_OPTIONS_PKG.INSERT_ROW',3);

10612: EXCEPTION
10613: WHEN OTHERS THEN
10614: --NULL
10615: ----------------------dbms_output.put_line('ERROR IN OPTIONS INSERTION:'||SQLERRM);
10616: pvt_debug(g_pkg_name||'OPTION_INSERT_ROW:Exception:PN_OPTIONS_PKG.INSERT_ROW',3);
10617: END;
10618: --SAVEPOINT A;
10619: IF l_option_id IS NOT NULL AND p_option_tbl(l_index).option_milestone_tbl.count <> 0 THEN
10620: ----------------------dbms_output.put_line ('--------CREATE MILESTONE------');

Line 11222: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:Calling PN_OPTIONS_PKG.UPDATE_ROW',3);

11218: IF p_tbl(l_index).temp_flag = 2 THEN
11219: ----------------------dbms_output.put_line ('RECORD UPDATION STARTED FOR OPTIONS');--Rupak
11220:
11221:
11222: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:Calling PN_OPTIONS_PKG.UPDATE_ROW',3);
11223: pn_options_pkg.update_row (
11224: x_option_id => p_option_tbl(l_index).option_id
11225: , x_lease_id => p_lease_id
11226: , x_lease_change_id => p_lease_change_id

Line 11223: pn_options_pkg.update_row (

11219: ----------------------dbms_output.put_line ('RECORD UPDATION STARTED FOR OPTIONS');--Rupak
11220:
11221:
11222: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:Calling PN_OPTIONS_PKG.UPDATE_ROW',3);
11223: pn_options_pkg.update_row (
11224: x_option_id => p_option_tbl(l_index).option_id
11225: , x_lease_id => p_lease_id
11226: , x_lease_change_id => p_lease_change_id
11227: , x_option_num => p_option_tbl(l_index).option_num

Line 11263: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW Successful',3);

11259: , x_option_notice_reqd => p_option_tbl(l_index).option_notice_reqd
11260: , x_option_comments => p_option_tbl(l_index).comments
11261: );
11262: ----------------------dbms_output.put_line ('RECORD UPDATION COMPLETED FOR OPTIONS');--Rupak
11263: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW Successful',3);
11264:
11265: -- SAVEPOINT A;
11266: ----------------------dbms_output.put_line('UPDATE PROCEDURE FOR RECORD: '||l_index ||'COMPLETED');--Rupak
11267: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW;Exception'||SQLERRM,3);

Line 11267: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW;Exception'||SQLERRM,3);

11263: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW Successful',3);
11264:
11265: -- SAVEPOINT A;
11266: ----------------------dbms_output.put_line('UPDATE PROCEDURE FOR RECORD: '||l_index ||'COMPLETED');--Rupak
11267: pvt_debug(g_pkg_name||'OPTION_UPDATE_ROW:PN_OPTIONS_PKG.UPDATE_ROW;Exception'||SQLERRM,3);
11268: l_option_id := p_option_tbl(l_index).option_id;
11269:
11270: IF p_option_tbl(l_index).option_milestone_tbl.count<>0 THEN
11271: ----------------------dbms_output.put_line('UPDATE MILESTONE PROCEDURE FOR RECORD: '||l_index ||'STARTED');