APPS.PN_SPACE_ASSIGN_EMP_PKG dependencies on PNP_DEBUG_PKG

Line 74: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.INSERT_ROW (+) SpcAsgnId: '

70: l_org_id NUMBER;
71:
72: BEGIN
73:
74: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.INSERT_ROW (+) SpcAsgnId: '
75: ||x_emp_space_assign_id||', LocId: '||x_location_id
76: ||', StrDt: '||TO_CHAR(x_emp_assign_start_date,'MM/DD/YYYY')
77: ||', EndDt: '||TO_CHAR(x_emp_assign_end_date, 'MM/DD/YYYY')
78: ||', CC: '||x_cost_center_code||', PerId: '||x_person_id);

Line 208: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.INSERT_ROW (-) SpcAsgnId: '

204: RAISE NO_DATA_FOUND;
205: END IF;
206: CLOSE C;
207:
208: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.INSERT_ROW (-) SpcAsgnId: '
209: ||x_emp_space_assign_id||', LocId: '||x_location_id
210: ||', StrDt: '||TO_CHAR(x_emp_assign_start_date,'MM/DD/YYYY')
211: ||', EndDt: '||TO_CHAR(x_emp_assign_end_date, 'MM/DD/YYYY')
212: ||', CC: '||x_cost_center_code||', PerId: '||x_person_id);

Line 259: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.LOCK_ROW (+) SpcAsgnId: '

255: FOR UPDATE OF emp_space_assign_id NOWAIT;
256:
257: BEGIN
258:
259: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.LOCK_ROW (+) SpcAsgnId: '
260: ||x_emp_space_assign_id);
261:
262: OPEN c1;
263: FETCH c1 INTO tlempinfo;

Line 404: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.LOCK_ROW (-) SpcAsgnId: '

400: OR ((tlempinfo.attribute15 IS NULL) AND (x_attribute15 IS NULL))) THEN
401: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlempinfo.attribute15);
402: END IF;
403:
404: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.LOCK_ROW (-) SpcAsgnId: '
405: ||x_emp_space_assign_id);
406:
407: END Lock_Row;
408:

Line 467: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW (+) SpcAsgnId: '

463: l_asgn_mode VARCHAR2(30);
464:
465: BEGIN
466:
467: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW (+) SpcAsgnId: '
468: ||x_emp_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
469: ||', StrDt: '||TO_CHAR(x_emp_assign_start_date,'MM/DD/YYYY')
470: ||', EndDt: '||TO_CHAR(x_emp_assign_end_date, 'MM/DD/YYYY')
471: ||', CC: '||x_cost_center_code||', PerId: '||x_person_id);

Line 640: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW (-) SpcAsgnId: '

636: EXCEPTION
637: WHEN OTHERS THEN
638: app_exception.raise_exception;
639:
640: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW (-) SpcAsgnId: '
641: ||x_emp_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
642: ||', StrDt: '||TO_CHAR(x_emp_assign_start_date,'MM/DD/YYYY')
643: ||', EndDt: '||TO_CHAR(x_emp_assign_end_date, 'MM/DD/YYYY')
644: ||', CC: '||x_cost_center_code||', PerId: '||x_person_id);

Line 668: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.DELETE_ROW (+) SpcAsgnId: '

664: PROCEDURE delete_row(x_emp_space_assign_id IN NUMBER) IS
665:
666: BEGIN
667:
668: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.DELETE_ROW (+) SpcAsgnId: '
669: ||x_emp_space_assign_id);
670:
671: DELETE FROM pn_space_assign_emp_all
672: WHERE emp_space_assign_id = x_emp_space_assign_id;

Line 679: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.DELETE_ROW (-) SpcAsgnId: '

675: IF (SQL%NOTFOUND) THEN
676: RAISE NO_DATA_FOUND;
677: END IF;
678:
679: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.DELETE_ROW (-) SpcAsgnId: '
680: ||x_emp_space_assign_id);
681:
682: END delete_row;
683:

Line 737: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.check_office_assign_gaps(+)');

733: AND location_id = p_loc_id);
734:
735: BEGIN
736:
737: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.check_office_assign_gaps(+)');
738:
739: loctn_tab.delete;
740: l_rec_num := 0;
741: l_err_flag := 'N';

Line 795: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.check_office_assign_gaps(-)');

791: app_exception.raise_exception;
792: END IF;
793: END IF;
794:
795: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.check_office_assign_gaps(-)');
796:
797: END check_office_assign_gaps;
798:
799: -------------------------------------------------------------------------------

Line 898: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.GET_LEAST_ST_DATE_ASSIGNMENT(+)');

894: WHERE location_id = p_loc
895: AND cost_center_code = p_cc);
896:
897: BEGIN
898: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.GET_LEAST_ST_DATE_ASSIGNMENT(+)');
899:
900: IF p_emp_id IS NOT NULL THEN
901: FOR emp IN get_person_assign_id(p_loc_id, p_emp_id) LOOP
902: l_emp_space_assign_id := emp.emp_space_assign_id;

Line 910: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.GET_LEAST_ST_DATE_ASSIGNMENT(-)');

906: l_emp_space_assign_id := emp.emp_space_assign_id;
907: END LOOP;
908: END IF;
909:
910: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.GET_LEAST_ST_DATE_ASSIGNMENT(-)');
911:
912: RETURN l_emp_space_assign_id;
913:
914: END get_Least_st_date_assignment;