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.PN_SPACE_ASSIGN_CUST_PKG dependencies on PNP_DEBUG_PKG

Line 83: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (+) SpcAsgnId: '

79: l_org_id NUMBER;
80:
81: BEGIN
82:
83: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (+) SpcAsgnId: '
84: ||x_cust_space_assign_id||', LocId: '||x_location_id
85: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
86: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
87: ||', CustId: '||x_cust_account_id);

Line 228: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (-) SpcAsgnId: '

224: RAISE NO_DATA_FOUND;
225: END IF;
226: CLOSE c;
227:
228: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.INSERT_ROW (-) SpcAsgnId: '
229: ||x_cust_space_assign_id||', LocId: '||x_location_id
230: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
231: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
232: ||', CustId: '||x_cust_account_id);

Line 284: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (+) SpcAsgnId: '

280: FOR UPDATE OF cust_space_assign_id NOWAIT;
281:
282: BEGIN
283:
284: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (+) SpcAsgnId: '
285: ||x_cust_space_assign_id);
286:
287: OPEN c1;
288: FETCH c1 INTO tlcustinfo;

Line 463: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (-) SpcAsgnId: '

459: OR ((tlcustinfo.TENANCY_ID is null) AND (X_TENANCY_ID is null))) THEN
460: pn_var_rent_pkg.lock_row_exception('TENANCY_ID',tlcustinfo.TENANCY_ID);
461: END IF;
462:
463: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.LOCK_ROW (-) SpcAsgnId: '
464: ||x_cust_space_assign_id);
465:
466: END Lock_Row;
467:

Line 534: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (+) SpcAsgnId: '

530: l_status VARCHAR2(100);
531: l_err_msg VARCHAR2(30);
532:
533: BEGIN
534: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (+) SpcAsgnId: '
535: ||x_cust_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
536: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
537: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
538: ||', CustId: '||x_cust_account_id);

Line 724: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (-) SpcAsgnId: '

720: IF (SQL%NOTFOUND) THEN
721: RAISE NO_DATA_FOUND;
722: END IF;
723:
724: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.UPDATE_ROW (-) SpcAsgnId: '
725: ||x_cust_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
726: ||', StrDt: '||TO_CHAR(x_cust_assign_start_date,'MM/DD/YYYY')
727: ||', EndDt: '||TO_CHAR(x_cust_assign_end_date, 'MM/DD/YYYY')
728: ||', CustId: '||x_cust_account_id);

Line 747: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (+) SpcAsgnId: '

743: IS
744:
745: BEGIN
746:
747: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (+) SpcAsgnId: '
748: ||x_cust_space_assign_id);
749:
750:
751: DELETE FROM pn_space_assign_cust_all

Line 758: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (-) SpcAsgnId: '

754: IF (SQL%NOTFOUND) THEN
755: RAISE NO_DATA_FOUND;
756: END IF;
757:
758: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.DELETE_ROW (-) SpcAsgnId: '
759: ||x_cust_space_assign_id);
760:
761: END Delete_Row;
762:

Line 795: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (+)');

791: AND cust_assign_start_date <= p_assgn_end_dt
792: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))
793: >= p_assgn_str_dt);
794: BEGIN
795: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (+)');
796:
797: OPEN check_cust_assignment;
798: FETCH check_cust_assignment INTO l_err_flag;
799: CLOSE check_cust_assignment;

Line 805: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (-) '||p_return_status);

801: IF NVL(l_err_flag,'N') = 'Y' THEN
802: p_return_status := 'DUP_ASSIGN';
803: END IF;
804:
805: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.CHK_DUP_CUST_ASSIGN (-) '||p_return_status);
806: END chk_dup_cust_assign;
807:
808: -------------------------------------------------------------------
809: -- PROCEDURE : GET_DUP_CUST_ASSIGN_COUNT

Line 834: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (+)');

830: AND cust_assign_start_date <= p_assgn_end_dt
831: AND NVL(cust_assign_end_date, TO_DATE('12/31/4712', 'MM/DD/YYYY'))
832: >= p_assgn_str_dt;
833: BEGIN
834: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (+)');
835:
836: FOR cust_assign IN get_cust_assignment
837: LOOP
838: l_assign_count := l_assign_count + 1;

Line 847: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (-) '||p_assign_count);

843:
844: p_assign_count := l_assign_count;
845: p_dup_assign_count := l_dup_assign_count;
846:
847: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.GET_DUP_CUST_ASSIGN_COUNT (-) '||p_assign_count);
848: END get_dup_cust_assign_count;
849:
850: -----------------------------------------------------------------------
851: -- FUNCTION : check_assign_arcl_line

Line 1155: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (+) Loc Id: '||p_location_id

1151: END LOOP;
1152:
1153: l_profile := pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id);
1154:
1155: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (+) Loc Id: '||p_location_id
1156: ||', l_profile: '||l_profile);
1157:
1158: i := 1;
1159: FOR main_rec IN csr_main

Line 1163: pnp_debug_pkg.debug('Csr_Main i: '||i

1159: FOR main_rec IN csr_main
1160:
1161: LOOP
1162:
1163: pnp_debug_pkg.debug('Csr_Main i: '||i
1164: ||', Assign Start Dt: '||main_rec.start_date
1165: ||', End Dt: '||main_rec.end_date
1166: ||', Area: '||main_rec.allocated_area
1167: ||', Type/Id: '||main_rec.assign_type_id

Line 1189: pnp_debug_pkg.debug('counter i= '||i||', date table= '||l_date_table(i));

1185:
1186: FOR i IN 1 .. l_date_table.count-1
1187: LOOP
1188:
1189: pnp_debug_pkg.debug('counter i= '||i||', date table= '||l_date_table(i));
1190: IF l_date_table(i) > to_date('12/31/4712','MM/DD/YYYY') THEN
1191: pnp_debug_pkg.debug('date table.......exit '|| l_date_table(i));
1192: EXIT;
1193: END IF;

Line 1191: pnp_debug_pkg.debug('date table.......exit '|| l_date_table(i));

1187: LOOP
1188:
1189: pnp_debug_pkg.debug('counter i= '||i||', date table= '||l_date_table(i));
1190: IF l_date_table(i) > to_date('12/31/4712','MM/DD/YYYY') THEN
1191: pnp_debug_pkg.debug('date table.......exit '|| l_date_table(i));
1192: EXIT;
1193: END IF;
1194:
1195: p_date1:= l_date_table(i);

Line 1200: pnp_debug_pkg.debug('Update Cust Row Assign_Id: '|| cust_split_rec.cust_space_assign_id

1196:
1197: FOR cust_split_rec IN csr_cust_split(l_date_table(i))
1198: LOOP
1199:
1200: pnp_debug_pkg.debug('Update Cust Row Assign_Id: '|| cust_split_rec.cust_space_assign_id
1201: ||', Loc_Id: '|| cust_split_rec.location_id
1202: ||', Cust_Id: '|| cust_split_rec.cust_account_id);
1203:
1204: tlcustinfo := NULL;

Line 1258: pnp_debug_pkg.debug('Update Emp Row Assign_Id: '|| emp_split_rec.emp_space_assign_id

1254:
1255: FOR emp_split_rec IN csr_emp_split(l_date_table(i))
1256: LOOP
1257:
1258: pnp_debug_pkg.debug('Update Emp Row Assign_Id: '|| emp_split_rec.emp_space_assign_id
1259: ||', Loc_Id: '|| emp_split_rec.location_id
1260: ||', Emp_Id: '|| emp_split_rec.person_id);
1261:
1262: pn_space_assign_emp_pkg.tlempinfo := emp_split_rec;

Line 1307: pnp_debug_pkg.debug('To distribute Area_Pct and Area... (+)');

1303: END LOOP;
1304:
1305: END LOOP;
1306:
1307: pnp_debug_pkg.debug('To distribute Area_Pct and Area... (+)');
1308: FOR cust_rec IN csr_cust
1309:
1310: LOOP
1311:

Line 1374: pnp_debug_pkg.debug('Done distributing Area_Pct and Area... (-)');

1370: WHERE ROWID = emp_rec.ROWID;
1371: END IF;
1372: END IF;
1373: END LOOP;
1374: pnp_debug_pkg.debug('Done distributing Area_Pct and Area... (-)');
1375:
1376: pn_space_assign_cust_pkg.Defrag_Contig_Assign(p_location_id);
1377:
1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);

Line 1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);

1374: pnp_debug_pkg.debug('Done distributing Area_Pct and Area... (-)');
1375:
1376: pn_space_assign_cust_pkg.Defrag_Contig_Assign(p_location_id);
1377:
1378: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Assignment_Split (-) Loc Id: '||p_location_id);
1379:
1380: END assignment_split;
1381:
1382: -------------------------------------------------------------------------------

Line 1425: pnp_debug_pkg.debug('Area_Pct_And_Area (+) Loc Id: '||x_location_id

1421: l_utilized := PN_SPACE_ASSIGN_CUST_PKG.assignment_count(x_location_id,x_start_date,x_end_date);
1422: l_alloc_area_pct := TRUNC(100 / l_utilized, 2); /*4533091*/
1423: l_alloc_area := TRUNC(x_usable_area / l_utilized, 2); /*4533091*/
1424:
1425: pnp_debug_pkg.debug('Area_Pct_And_Area (+) Loc Id: '||x_location_id
1426: ||', Area: '||x_usable_area
1427: ||', StrDt: '||TO_CHAR(x_start_date,'MM/DD/YYYY')
1428: ||', EndDt: '||TO_CHAR(x_end_date, 'MM/DD/YYYY')
1429: ||', lUtil: '||l_utilized

Line 1503: pnp_debug_pkg.debug('Area_Pct_And_Area (-) Loc Id: '||x_location_id);

1499: END IF;
1500: END IF;
1501: END IF;
1502:
1503: pnp_debug_pkg.debug('Area_Pct_And_Area (-) Loc Id: '||x_location_id);
1504: END area_pct_and_area;
1505:
1506: /*===========================================================================+
1507: -- NAME : assignment_count

Line 1880: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (+) Loc Id: '||p_location_id);

1876:
1877:
1878: BEGIN
1879:
1880: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (+) Loc Id: '||p_location_id);
1881:
1882: cust_tab.delete;
1883: l_rec_num := 0;
1884:

Line 1892: pnp_debug_pkg.debug('Cust_Tab i= '||l_rec_num

1888: FOR cust_rec IN csr_cust LOOP
1889: l_rec_num := NVL(cust_tab.count,0) + 1;
1890: cust_tab(l_rec_num) := cust_rec;
1891:
1892: pnp_debug_pkg.debug('Cust_Tab i= '||l_rec_num
1893: ||', cust: '||cust_rec.cust_account_id
1894: ||', str: '||cust_rec.cust_assign_start_date
1895: ||', end: '||cust_rec.cust_assign_end_date
1896: ||', Id: '||cust_rec.cust_space_assign_id

Line 1900: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num: '||l_rec_num);

1896: ||', Id: '||cust_rec.cust_space_assign_id
1897: ||', area= '||cust_rec.allocated_area);
1898: END LOOP;
1899:
1900: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num: '||l_rec_num);
1901:
1902: IF NVL(l_rec_num,0) > 1 THEN
1903: FOR i in 1..CUST_TAB.count-1 LOOP
1904:

Line 1905: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num>1 Start_LOOP i= '||i

1901:
1902: IF NVL(l_rec_num,0) > 1 THEN
1903: FOR i in 1..CUST_TAB.count-1 LOOP
1904:
1905: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num>1 Start_LOOP i= '||i
1906: ||', cust_asgn_id= '||NVL(cust_tab(i).cust_space_assign_id,0));
1907:
1908: IF cust_tab(i+1).location_id = cust_tab(i).location_id
1909: AND cust_tab(i+1).cust_account_id = cust_tab(i).cust_account_id

Line 1943: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_diff: '||l_diff);

1939:
1940: l_diff := cust_tab(i+1).cust_assign_start_date -
1941: cust_tab(i).cust_assign_end_date;
1942:
1943: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_diff: '||l_diff);
1944:
1945: IF l_diff = 1 THEN
1946:
1947: ---------------------------------------------------------------------------

Line 1968: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num>1 End_LOOP i= '||i);

1964: pn_space_assign_cust_pkg.delete_row(cust_tab(i).cust_space_assign_id);
1965:
1966: END IF;
1967: END IF;
1968: pnp_debug_pkg.debug('Defrag_Contig_Assign Cust_Tab... l_rec_num>1 End_LOOP i= '||i);
1969: END LOOP;
1970: END IF;
1971:
1972: emp_tab.delete;

Line 1983: pnp_debug_pkg.debug('Emp_Tab i= '||l_rec_num

1979: FOR emp_rec IN csr_emp LOOP
1980: l_rec_num := NVL(emp_tab.count,0) + 1;
1981: emp_tab(l_rec_num) := emp_rec;
1982:
1983: pnp_debug_pkg.debug('Emp_Tab i= '||l_rec_num
1984: ||', Emp: '||emp_rec.person_id
1985: ||', str: '||emp_rec.emp_assign_start_date
1986: ||', end: '||emp_rec.emp_assign_end_date
1987: ||', Id: '||emp_rec.emp_space_assign_id

Line 1991: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num: '||l_rec_num);

1987: ||', Id: '||emp_rec.emp_space_assign_id
1988: ||', area= '||emp_rec.allocated_area);
1989: END LOOP;
1990:
1991: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num: '||l_rec_num);
1992:
1993: IF NVL(l_rec_num,0) > 1 THEN
1994: FOR i in 1..EMP_TAB.count-1 LOOP
1995:

Line 1996: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 Start_LOOP i= '||i);

1992:
1993: IF NVL(l_rec_num,0) > 1 THEN
1994: FOR i in 1..EMP_TAB.count-1 LOOP
1995:
1996: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 Start_LOOP i= '||i);
1997:
1998: IF emp_tab(i+1).location_id = emp_tab(i).location_id
1999: AND emp_tab(i+1).person_id = emp_tab(i).person_id
2000: AND NVL(emp_tab(i+1).cost_center_code,0) = NVL(emp_tab(i).cost_center_code,0)

Line 2028: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_diff: '||l_diff);

2024:
2025: l_diff := emp_tab(i+1).emp_assign_start_date -
2026: emp_tab(i).emp_assign_end_date;
2027:
2028: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_diff: '||l_diff);
2029:
2030: IF l_diff = 1 THEN
2031: ---------------------------------------------------------------------------
2032: -- If stepping thru emp PL/SQL table records finds contigous records with

Line 2052: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 End_LOOP i= '||i);

2048: pn_space_assign_emp_pkg.delete_row(emp_tab(i).emp_space_assign_id);
2049:
2050: END IF;
2051: END IF;
2052: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 End_LOOP i= '||i);
2053: END LOOP;
2054: END IF;
2055:
2056: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (-) Loc Id: '||p_location_id);

Line 2056: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (-) Loc Id: '||p_location_id);

2052: pnp_debug_pkg.debug('Defrag_Contig_Assign Emp_Tab... l_rec_num>1 End_LOOP i= '||i);
2053: END LOOP;
2054: END IF;
2055:
2056: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.Defrag_Contig_Assign (-) Loc Id: '||p_location_id);
2057:
2058: END Defrag_Contig_Assign;
2059:
2060: -------------------------------------------------------------------------------

Line 2077: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (+)');

2073: l_exists BOOLEAN;
2074:
2075: BEGIN
2076:
2077: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (+)');
2078:
2079: -- do simple bubble search to identify new tables.
2080: FOR i IN 1..p_new_table.COUNT LOOP
2081:

Line 2094: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (-)');

2090: END IF;
2091:
2092: END LOOP;
2093:
2094: pnp_debug_pkg.debug('PN_SPACE_ASSIGN_CUST_PKG.merge_tables (-)');
2095:
2096: END;
2097:
2098: -------------------------------------------------------------------------------

Line 2138: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (+)');

2134: l_result_tbl loc_id_tbl;
2135:
2136: BEGIN
2137:
2138: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (+)');
2139:
2140: IF x_emp_space_assign_id IS NULL THEN
2141:
2142: UPDATE pn_space_assign_emp_all

Line 2181: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (-)');

2177: merge_tables(p_base_table => l_result_tbl, p_new_table => l_loc_tbl_conc_cc);
2178:
2179: x_loc_id_tbl := l_result_tbl;
2180:
2181: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_emp (-)');
2182:
2183: END delete_other_assignments_emp;
2184:
2185:

Line 2222: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');

2218: l_result_tbl loc_id_tbl;
2219:
2220: BEGIN
2221:
2222: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');
2223:
2224: IF x_cust_space_assign_id IS NULL THEN
2225:
2226: UPDATE pn_space_assign_cust_all

Line 2263: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');

2259: merge_tables(p_base_table => l_result_tbl, p_new_table => l_loc_tbl_conc);
2260:
2261: x_loc_id_tbl := l_result_tbl;
2262:
2263: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_CUST_PKG.delete_other_assignments_cust (+)');
2264:
2265: END delete_other_assignments_cust;
2266:
2267: