APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PNP_DEBUG_PKG

Line 178: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locCondotions(+)');

174:
175:
176:
177: BEGIN
178: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locCondotions(+)');
179:
180: --Initialise status parameters...
181: retcode:=0;
182: errbuf:='';

Line 291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');

287:
288: dbms_sql.define_column (l_cursor,1,v_location_id_1);
289: l_rows := dbms_sql.execute(l_cursor);
290:
291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
293: LOOP
294: l_count := dbms_sql.fetch_rows( l_cursor );
295: EXIT WHEN l_count <> 1;

Line 292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');

288: dbms_sql.define_column (l_cursor,1,v_location_id_1);
289: l_rows := dbms_sql.execute(l_cursor);
290:
291: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
292: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
293: LOOP
294: l_count := dbms_sql.fetch_rows( l_cursor );
295: EXIT WHEN l_count <> 1;
296:

Line 410: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');

406: WHERE emp.location_id = V_LOCATION_ID_2
407: AND pa.project_id(+)= emp.project_id
408: AND pat.task_id(+) = emp.task_id
409: AND as_of_date BETWEEN emp.emp_assign_start_date AND NVL(emp.emp_assign_end_date, l_date);
410: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
411: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
412: LOOP
413: FETCH emp_pn
414: INTO v_location_id,

Line 411: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');

407: AND pa.project_id(+)= emp.project_id
408: AND pat.task_id(+) = emp.task_id
409: AND as_of_date BETWEEN emp.emp_assign_start_date AND NVL(emp.emp_assign_end_date, l_date);
410: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
411: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
412: LOOP
413: FETCH emp_pn
414: INTO v_location_id,
415: v_person_id,

Line 624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');

620: END IF;
621:
622: dbms_sql.define_column (l_cursor,1,v_location_id_1);
623: l_rows := dbms_sql.execute(l_cursor);
624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
626: LOOP
627: l_count := dbms_sql.fetch_rows( l_cursor );
628: EXIT WHEN l_count <> 1;

Line 625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');

621:
622: dbms_sql.define_column (l_cursor,1,v_location_id_1);
623: l_rows := dbms_sql.execute(l_cursor);
624: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locQuery(-)');
625: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_locLoop(+)');
626: LOOP
627: l_count := dbms_sql.fetch_rows( l_cursor );
628: EXIT WHEN l_count <> 1;
629: