eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PNP_DEBUG_PKG

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

170: l_count INTEGER;
171:
172: BEGIN
173:
174: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(+)');
175: --Initialise status parameters...
176: retcode:=0;
177: errbuf:='';
178: fnd_profile.get('LOGIN_ID', l_login_id);

Line 198: PNP_DEBUG_PKG.put_log_msg('report_type:'||report_type);

194: lease_number_WHERE_clause := ' AND 1 = 1 ';
195: END IF;
196:
197: --validate report type...
198: PNP_DEBUG_PKG.put_log_msg('report_type:'||report_type);
199: IF report_type IN ('EMPLOYEE','ALL') THEN
200: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(+)');
201: l_statement :=
202: 'SELECT

Line 200: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(+)');

196:
197: --validate report type...
198: PNP_DEBUG_PKG.put_log_msg('report_type:'||report_type);
199: IF report_type IN ('EMPLOYEE','ALL') THEN
200: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(+)');
201: l_statement :=
202: 'SELECT
203: distinct
204: ten.location_id LOCATION_ID,

Line 270: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(+)');

266: dbms_sql.define_column (l_cursor,22,V_ATTRIBUTE15,150);
267:
268: l_rows := dbms_sql.execute(l_cursor);
269:
270: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(+)');
271: l_count_1 := 0;
272: LOOP
273: l_count_1 := l_count_1 + 1;
274: l_count := dbms_sql.fetch_rows( l_cursor );

Line 331: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(+)');

327: AND active_end_date >= as_of_date
328: START WITH loc.location_id = V_LOCATION_ID_1
329: CONNECT BY PRIOR loc.location_id = loc.parent_location_id
330: AND as_of_date between prior active_start_date AND prior active_end_date);
331: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(+)');
332: l_count_2 := 0;
333: LOOP
334: l_count_2 := l_count_2 + 1;
335: FETCH c_e_assign_pn into V_LOCATION_ID_2 ,

Line 378: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn# '

374: WHERE emp.location_id = V_LOCATION_ID_2
375: AND pa.project_id(+) = emp.project_id
376: AND pat.task_id(+) = emp.task_id
377: AND as_of_date between emp.emp_assign_start_date AND NVL(emp.emp_assign_end_date, l_date);
378: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn# '
379: ||l_count_2||': emp_pn Loop(+)');
380: l_count_3 := 0;
381: LOOP
382: l_count_3 := l_count_3 + 1;

Line 547: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn# '

543: V_CREATED_BY ,
544: l_request_id );
545: END IF;
546: END LOOP;
547: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn# '
548: ||l_count_2||': emp_pn Loop(-)');
549: END LOOP;
550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');
551: END LOOP;

Line 550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');

546: END LOOP;
547: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn# '
548: ||l_count_2||': emp_pn Loop(-)');
549: END LOOP;
550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');
551: END LOOP;
552: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(-)');
553: IF dbms_sql.is_open (l_cursor) THEN
554: dbms_sql.close_cursor (l_cursor);

Line 552: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(-)');

548: ||l_count_2||': emp_pn Loop(-)');
549: END LOOP;
550: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn# '||l_count_1||': c_e_assign_pn Loop(-)');
551: END LOOP;
552: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_Emp: c_e_pn Loop(-)');
553: IF dbms_sql.is_open (l_cursor) THEN
554: dbms_sql.close_cursor (l_cursor);
555: END IF;
556:

Line 558: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(-)');

554: dbms_sql.close_cursor (l_cursor);
555: END IF;
556:
557: COMMIT;
558: pnp_debug_pkg.put_log_msg('pn_sp_assign_Emp(-)');
559: END IF;
560:
561:
562: V_LOC_TYPE := null ; ----Added BUG#2226865

Line 568: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(+)');

564: l_count_2 := 0;
565: l_count_3 := 0;
566:
567: IF report_type IN ('CUSTOMER','ALL') THEN
568: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(+)');
569:
570: l_statement :=
571: 'SELECT
572: distinct

Line 644: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(+)');

640:
641:
642: l_rows := dbms_sql.execute(l_cursor);
643:
644: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(+)');
645: l_count_1 := 0;
646: LOOP
647: l_count_1 := l_count_1 + 1;
648: l_count := dbms_sql.fetch_rows( l_cursor );

Line 706: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(+)');

702: START WITH loc.location_id = V_LOCATION_ID_1
703: CONNECT BY PRIOR loc.location_id = loc.parent_location_id
704: AND as_of_date between prior active_start_date AND prior active_end_date);
705:
706: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(+)');
707: l_count_2 := 0;
708: LOOP
709: l_count_2 := l_count_2 + 1;
710: FETCH c_c_assign_pn into V_LOCATION_ID_2 ,

Line 764: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn# '

760: hcsu.site_use_id(+)= cust.site_use_id AND
761: pa.project_id(+) = cust.project_id AND
762: pat.task_id(+) = cust.task_id
763: AND as_of_date between cust.cust_assign_start_date AND NVL(cust.cust_assign_end_date, l_date);
764: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn# '
765: ||l_count_2||': cust_pn Loop(+)');
766: l_count_3 := 0;
767: LOOP
768: l_count_3 := l_count_3 + 1;

Line 935: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn# '

931: V_CREATED_BY ,
932: l_request_id );
933: END IF;
934: END LOOP;
935: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn# '
936: ||l_count_2||': cust_pn Loop(-)');
937: END LOOP;
938: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(-)');
939: END LOOP;

Line 938: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(-)');

934: END LOOP;
935: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn# '
936: ||l_count_2||': cust_pn Loop(-)');
937: END LOOP;
938: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn# '||l_count_1||': c_c_assign_pn Loop(-)');
939: END LOOP;
940:
941: IF dbms_sql.is_open (l_cursor) THEN
942: dbms_sql.close_cursor (l_cursor);

Line 945: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(-)');

941: IF dbms_sql.is_open (l_cursor) THEN
942: dbms_sql.close_cursor (l_cursor);
943: END IF;
944:
945: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(-)');
946: COMMIT;
947: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(-)');
948: END IF;
949:

Line 947: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(-)');

943: END IF;
944:
945: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust: c_c_pn Loop(-)');
946: COMMIT;
947: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(-)');
948: END IF;
949:
950: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(-)');
951:

Line 950: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(-)');

946: COMMIT;
947: pnp_debug_pkg.put_log_msg('pn_sp_assign_Cust(-)');
948: END IF;
949:
950: PNP_DEBUG_PKG.put_log_msg('pn_sp_assign_leaseConditions(-)');
951:
952: --If there is something amiss...
953: EXCEPTION
954: WHEN OTHERS THEN