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.ASO_APR_APPROVALS_PKG dependencies on ASO_DEBUG_PUB

Line 59: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

55: CURSOR c2 IS
56: SELECT aso_apr_obj_header_s.NEXTVAL
57: FROM sys.DUAL;
58: BEGIN
59: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
60: aso_debug_pub.ADD (
61: 'Begin Header_Insert_Row procedure ',
62: 1,
63: 'N'

Line 60: aso_debug_pub.ADD (

56: SELECT aso_apr_obj_header_s.NEXTVAL
57: FROM sys.DUAL;
58: BEGIN
59: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
60: aso_debug_pub.ADD (
61: 'Begin Header_Insert_Row procedure ',
62: 1,
63: 'N'
64: );

Line 340: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

336: NULL,
337: p_requester_group_id
338: ));
339:
340: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
341: aso_debug_pub.ADD (
342: 'End Header_Insert_Row procedure ',
343: 1,
344: 'N'

Line 341: aso_debug_pub.ADD (

337: p_requester_group_id
338: ));
339:
340: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
341: aso_debug_pub.ADD (
342: 'End Header_Insert_Row procedure ',
343: 1,
344: 'N'
345: );

Line 350: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

346: END IF;
347: EXCEPTION
348: WHEN OTHERS
349: THEN
350: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
351: aso_debug_pub.ADD (
352: 'Exception in Header_Insert_Row procedure ',
353: 1,
354: 'N'

Line 351: aso_debug_pub.ADD (

347: EXCEPTION
348: WHEN OTHERS
349: THEN
350: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
351: aso_debug_pub.ADD (
352: 'Exception in Header_Insert_Row procedure ',
353: 1,
354: 'N'
355: );

Line 356: aso_debug_pub.ADD (

352: 'Exception in Header_Insert_Row procedure ',
353: 1,
354: 'N'
355: );
356: aso_debug_pub.ADD (
357: 'errmsg is ' || SUBSTR (
358: SQLERRM,
359: 1,
360: 250

Line 410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

406: p_requester_comments VARCHAR2,
407: p_requester_group_id NUMBER
408: ) IS
409: BEGIN
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.ADD (
412: 'Begin Header_Update_Row procedure ',
413: 1,
414: 'N'

Line 411: aso_debug_pub.ADD (

407: p_requester_group_id NUMBER
408: ) IS
409: BEGIN
410: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
411: aso_debug_pub.ADD (
412: 'Begin Header_Update_Row procedure ',
413: 1,
414: 'N'
415: );

Line 642: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

638: THEN
639: RAISE NO_DATA_FOUND;
640: END IF;
641:
642: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
643: aso_debug_pub.ADD (
644: 'End Header_Update_Row procedure ',
645: 1,
646: 'N'

Line 643: aso_debug_pub.ADD (

639: RAISE NO_DATA_FOUND;
640: END IF;
641:
642: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
643: aso_debug_pub.ADD (
644: 'End Header_Update_Row procedure ',
645: 1,
646: 'N'
647: );

Line 655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

651: PROCEDURE header_delete_row (
652: p_object_approval_id NUMBER
653: ) IS
654: BEGIN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Begin Header_Delete_Row procedure ',
658: 1,
659: 'N'

Line 656: aso_debug_pub.ADD (

652: p_object_approval_id NUMBER
653: ) IS
654: BEGIN
655: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
656: aso_debug_pub.ADD (
657: 'Begin Header_Delete_Row procedure ',
658: 1,
659: 'N'
660: );

Line 671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

667: THEN
668: RAISE NO_DATA_FOUND;
669: END IF;
670:
671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
672: aso_debug_pub.ADD (
673: 'End Header_Delete_Row procedure ',
674: 1,
675: 'N'

Line 672: aso_debug_pub.ADD (

668: RAISE NO_DATA_FOUND;
669: END IF;
670:
671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
672: aso_debug_pub.ADD (
673: 'End Header_Delete_Row procedure ',
674: 1,
675: 'N'
676: );

Line 731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

727: FOR UPDATE OF object_approval_id NOWAIT;
728:
729: recinfo c%ROWTYPE;
730: BEGIN
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.ADD (
733: 'Begin Header_Lock_Row procedure ',
734: 1,
735: 'N'

Line 732: aso_debug_pub.ADD (

728:
729: recinfo c%ROWTYPE;
730: BEGIN
731: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
732: aso_debug_pub.ADD (
733: 'Begin Header_Lock_Row procedure ',
734: 1,
735: 'N'
736: );

Line 769: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

765: );
766: app_exception.raise_exception;
767: END IF;
768:
769: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
770: aso_debug_pub.ADD (
771: 'End Header_Lock_Row procedure ',
772: 1,
773: 'N'

Line 770: aso_debug_pub.ADD (

766: app_exception.raise_exception;
767: END IF;
768:
769: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
770: aso_debug_pub.ADD (
771: 'End Header_Lock_Row procedure ',
772: 1,
773: 'N'
774: );

Line 830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

826: CURSOR c2 IS
827: SELECT aso_apr_obj_det_s.NEXTVAL
828: FROM sys.DUAL;
829: BEGIN
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.ADD (
832: 'Begin Detail_Insert_Row procedure ',
833: 1,
834: 'N'

Line 831: aso_debug_pub.ADD (

827: SELECT aso_apr_obj_det_s.NEXTVAL
828: FROM sys.DUAL;
829: BEGIN
830: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
831: aso_debug_pub.ADD (
832: 'Begin Detail_Insert_Row procedure ',
833: 1,
834: 'N'
835: );

Line 1165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1161: p_approver_cat
1162: )
1163: );
1164:
1165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1166: aso_debug_pub.ADD (
1167: 'End Detail_Insert_Row procedure ',
1168: 1,
1169: 'N'

Line 1166: aso_debug_pub.ADD (

1162: )
1163: );
1164:
1165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1166: aso_debug_pub.ADD (
1167: 'End Detail_Insert_Row procedure ',
1168: 1,
1169: 'N'
1170: );

Line 1174: -- aso_debug_pub.add('Exception in Detail_Insert_Row procedure ', 1, 'N');

1170: );
1171: END IF;
1172: -- EXCEPTION
1173: -- WHEN OTHERS THEN
1174: -- aso_debug_pub.add('Exception in Detail_Insert_Row procedure ', 1, 'N');
1175: -- aso_debug_pub.add('errmsg is '||substr(SQLERRM,1,250), 1, 'N');
1176:
1177: END detail_insert_row;
1178:

Line 1175: -- aso_debug_pub.add('errmsg is '||substr(SQLERRM,1,250), 1, 'N');

1171: END IF;
1172: -- EXCEPTION
1173: -- WHEN OTHERS THEN
1174: -- aso_debug_pub.add('Exception in Detail_Insert_Row procedure ', 1, 'N');
1175: -- aso_debug_pub.add('errmsg is '||substr(SQLERRM,1,250), 1, 'N');
1176:
1177: END detail_insert_row;
1178:
1179: PROCEDURE detail_update_row (

Line 1228: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1224: p_authority varchar2 Default null,--rassharm
1225: p_approver_cat varchar2 default null--rassharm
1226: ) IS
1227: BEGIN
1228: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1229: aso_debug_pub.ADD (
1230: 'Begin Detail_Update_Row procedure ',
1231: 1,
1232: 'N'

Line 1229: aso_debug_pub.ADD (

1225: p_approver_cat varchar2 default null--rassharm
1226: ) IS
1227: BEGIN
1228: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1229: aso_debug_pub.ADD (
1230: 'Begin Detail_Update_Row procedure ',
1231: 1,
1232: 'N'
1233: );

Line 1466: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1462: THEN
1463: RAISE NO_DATA_FOUND;
1464: END IF;
1465:
1466: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1467: aso_debug_pub.ADD (
1468: 'End Detail_Update_Row procedure ',
1469: 1,
1470: 'N'

Line 1467: aso_debug_pub.ADD (

1463: RAISE NO_DATA_FOUND;
1464: END IF;
1465:
1466: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1467: aso_debug_pub.ADD (
1468: 'End Detail_Update_Row procedure ',
1469: 1,
1470: 'N'
1471: );

Line 1524: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1520: FOR UPDATE OF approval_det_id NOWAIT;
1521:
1522: recinfo c%ROWTYPE;
1523: BEGIN
1524: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1525: aso_debug_pub.ADD (
1526: 'Begin Detail_Lock_Row procedure ',
1527: 1,
1528: 'N'

Line 1525: aso_debug_pub.ADD (

1521:
1522: recinfo c%ROWTYPE;
1523: BEGIN
1524: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1525: aso_debug_pub.ADD (
1526: 'Begin Detail_Lock_Row procedure ',
1527: 1,
1528: 'N'
1529: );

Line 1562: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1558: );
1559: app_exception.raise_exception;
1560: END IF;
1561:
1562: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1563: aso_debug_pub.ADD (
1564: 'End Detail_Lock_Row procedure ',
1565: 1,
1566: 'N'

Line 1563: aso_debug_pub.ADD (

1559: app_exception.raise_exception;
1560: END IF;
1561:
1562: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1563: aso_debug_pub.ADD (
1564: 'End Detail_Lock_Row procedure ',
1565: 1,
1566: 'N'
1567: );

Line 1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1571: PROCEDURE detail_delete_row (
1572: p_approval_det_id NUMBER
1573: ) IS
1574: BEGIN
1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1576: aso_debug_pub.ADD (
1577: 'Begin Detail_Delete_Row procedure ',
1578: 1,
1579: 'N'

Line 1576: aso_debug_pub.ADD (

1572: p_approval_det_id NUMBER
1573: ) IS
1574: BEGIN
1575: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1576: aso_debug_pub.ADD (
1577: 'Begin Detail_Delete_Row procedure ',
1578: 1,
1579: 'N'
1580: );

Line 1591: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1587: THEN
1588: RAISE NO_DATA_FOUND;
1589: END IF;
1590:
1591: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1592: aso_debug_pub.ADD (
1593: 'End Detail_Delete_Row procedure ',
1594: 1,
1595: 'N'

Line 1592: aso_debug_pub.ADD (

1588: RAISE NO_DATA_FOUND;
1589: END IF;
1590:
1591: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1592: aso_debug_pub.ADD (
1593: 'End Detail_Delete_Row procedure ',
1594: 1,
1595: 'N'
1596: );

Line 1639: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1635: CURSOR c2 IS
1636: SELECT aso_apr_rule_s.NEXTVAL
1637: FROM sys.DUAL;
1638: BEGIN
1639: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1640: aso_debug_pub.ADD (
1641: 'Begin Rule_Insert_Row procedure ',
1642: 1,
1643: 'N'

Line 1640: aso_debug_pub.ADD (

1636: SELECT aso_apr_rule_s.NEXTVAL
1637: FROM sys.DUAL;
1638: BEGIN
1639: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1640: aso_debug_pub.ADD (
1641: 'Begin Rule_Insert_Row procedure ',
1642: 1,
1643: 'N'
1644: );

Line 1872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1868: NULL,
1869: p_object_version_number
1870: ));
1871:
1872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1873: aso_debug_pub.ADD (
1874: 'End Rule_Insert_Row procedure ',
1875: 1,
1876: 'N'

Line 1873: aso_debug_pub.ADD (

1869: p_object_version_number
1870: ));
1871:
1872: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1873: aso_debug_pub.ADD (
1874: 'End Rule_Insert_Row procedure ',
1875: 1,
1876: 'N'
1877: );

Line 1916: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1912: p_security_group_id NUMBER,
1913: p_object_version_number NUMBER
1914: ) IS
1915: BEGIN
1916: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1917: aso_debug_pub.ADD (
1918: 'Begin Rule_Update_Row procedure ',
1919: 1,
1920: 'N'

Line 1917: aso_debug_pub.ADD (

1913: p_object_version_number NUMBER
1914: ) IS
1915: BEGIN
1916: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1917: aso_debug_pub.ADD (
1918: 'Begin Rule_Update_Row procedure ',
1919: 1,
1920: 'N'
1921: );

Line 2114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

2110: p_object_version_number
2111: )
2112: WHERE rule_id = p_rule_id;
2113:
2114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2115: aso_debug_pub.ADD (
2116: 'End Rule_Update_Row procedure ',
2117: 1,
2118: 'N'

Line 2115: aso_debug_pub.ADD (

2111: )
2112: WHERE rule_id = p_rule_id;
2113:
2114: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2115: aso_debug_pub.ADD (
2116: 'End Rule_Update_Row procedure ',
2117: 1,
2118: 'N'
2119: );

Line 2165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

2161: FOR UPDATE OF rule_id NOWAIT;
2162:
2163: recinfo c%ROWTYPE;
2164: BEGIN
2165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2166: aso_debug_pub.ADD (
2167: 'Begin Rule_Lock_Row procedure ',
2168: 1,
2169: 'N'

Line 2166: aso_debug_pub.ADD (

2162:
2163: recinfo c%ROWTYPE;
2164: BEGIN
2165: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2166: aso_debug_pub.ADD (
2167: 'Begin Rule_Lock_Row procedure ',
2168: 1,
2169: 'N'
2170: );

Line 2203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

2199: );
2200: app_exception.raise_exception;
2201: END IF;
2202:
2203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2204: aso_debug_pub.ADD (
2205: 'End Rule_Lock_Row procedure ',
2206: 1,
2207: 'N'

Line 2204: aso_debug_pub.ADD (

2200: app_exception.raise_exception;
2201: END IF;
2202:
2203: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2204: aso_debug_pub.ADD (
2205: 'End Rule_Lock_Row procedure ',
2206: 1,
2207: 'N'
2208: );

Line 2216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

2212: PROCEDURE rule_delete_row (
2213: p_rule_id NUMBER
2214: ) IS
2215: BEGIN
2216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2217: aso_debug_pub.ADD (
2218: 'Begin Rule_Delete_Row procedure ',
2219: 1,
2220: 'N'

Line 2217: aso_debug_pub.ADD (

2213: p_rule_id NUMBER
2214: ) IS
2215: BEGIN
2216: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2217: aso_debug_pub.ADD (
2218: 'Begin Rule_Delete_Row procedure ',
2219: 1,
2220: 'N'
2221: );

Line 2232: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

2228: THEN
2229: RAISE NO_DATA_FOUND;
2230: END IF;
2231:
2232: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2233: aso_debug_pub.ADD (
2234: 'End Rule_Delete_Row procedure ',
2235: 1,
2236: 'N'

Line 2233: aso_debug_pub.ADD (

2229: RAISE NO_DATA_FOUND;
2230: END IF;
2231:
2232: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2233: aso_debug_pub.ADD (
2234: 'End Rule_Delete_Row procedure ',
2235: 1,
2236: 'N'
2237: );