DBA Data[Home] [Help]

APPS.PNRX_SP_UTIL_BY_LEASE dependencies on PNP_DEBUG_PKG

Line 101: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(+)');

97: v_compare BOOLEAN;
98:
99:
100: BEGIN
101: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(+)');
102: --Initialise status parameters...
103: retcode:=0;
104: errbuf:='';
105: fnd_profile.get('LOGIN_ID', l_login_id);

Line 148: pnp_debug_pkg.log(' l_statement:'||l_statement);

144:
145: l_statement :=
146: l_statement || lease_number_where_clause ;
147:
148: pnp_debug_pkg.log(' l_statement:'||l_statement);
149: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
150:
151: dbms_sql.bind_variable
152: (l_cursor,'l_as_of_date',l_as_of_date );

Line 529: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(-)');

525: END IF;
526:
527: COMMIT;
528:
529: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(-)');
530: --If there is something amiss...
531: EXCEPTION
532: WHEN OTHERS THEN
533: retcode:=2;