DBA Data[Home] [Help]

APPS.AHL_APPROVALS_PVT dependencies on AHL_DEBUG_PUB

Line 24: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;

20: -----------------------------------------------------------------
21: -- Global CONSTANTS
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_Approvals_PVT';
23: -- Reema : FND Logging
24: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
25:
26: -- Perform record level(inter-field) validation only
27: G_VALID_APPROVER CONSTANT NUMBER:= 50;
28: G_VALID_QUALIFIER CONSTANT NUMBER:= 40;

Line 177: Ahl_Debug_Pub.enable_debug;

173: --------------------- initialize -----------------------
174: SAVEPOINT Process_Approvals;
175: -- Check if API is called in debug mode. If yes, enable debug.
176: IF G_DEBUG='Y' THEN
177: Ahl_Debug_Pub.enable_debug;
178: END IF;
179: -- Debug info.
180: IF G_DEBUG='Y' THEN
181: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 181: Ahl_Debug_Pub.debug( l_full_name ||':Start');

177: Ahl_Debug_Pub.enable_debug;
178: END IF;
179: -- Debug info.
180: IF G_DEBUG='Y' THEN
181: Ahl_Debug_Pub.debug( l_full_name ||':Start');
182: END IF;
183:
184: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
185: Fnd_Msg_Pub.initialize;

Line 201: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

197: x_return_status := Fnd_Api.g_ret_sts_success;
198:
199: ----------------------- validate -----------------------
200: IF G_DEBUG='Y' THEN
201: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
202: END IF;
203:
204: ---------------Manipulations in Approval Rules---------------
205: IF (l_x_Approval_Rules_Rec.operation_flag = 'C' OR l_x_Approval_Rules_Rec.operation_flag = 'c') THEN

Line 300: Ahl_Debug_Pub.debug( l_full_name ||':End');

296: p_count => x_msg_count,
297: p_data => x_msg_data
298: );
299: IF G_DEBUG='Y' THEN
300: Ahl_Debug_Pub.debug( l_full_name ||':End');
301: END IF;
302: -- Check if API is called in debug mode. If yes, disable debug.
303: IF G_DEBUG='Y' THEN
304: Ahl_Debug_Pub.disable_debug;

Line 304: Ahl_Debug_Pub.disable_debug;

300: Ahl_Debug_Pub.debug( l_full_name ||':End');
301: END IF;
302: -- Check if API is called in debug mode. If yes, disable debug.
303: IF G_DEBUG='Y' THEN
304: Ahl_Debug_Pub.disable_debug;
305: END IF;
306:
307: EXCEPTION
308: WHEN Fnd_Api.g_exc_error THEN

Line 614: Ahl_Debug_Pub.enable_debug;

610: --------------------- initialize -----------------------
611: SAVEPOINT Create_Approval_Rules;
612: -- Check if API is called in debug mode. If yes, enable debug.
613: IF G_DEBUG='Y' THEN
614: Ahl_Debug_Pub.enable_debug;
615: END IF;
616: -- Debug info.
617: IF G_DEBUG='Y' THEN
618: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 618: Ahl_Debug_Pub.debug( l_full_name ||':Start');

614: Ahl_Debug_Pub.enable_debug;
615: END IF;
616: -- Debug info.
617: IF G_DEBUG='Y' THEN
618: Ahl_Debug_Pub.debug( l_full_name ||':Start');
619: END IF;
620:
621: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
622: Fnd_Msg_Pub.initialize;

Line 635: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

631: END IF;
632: x_return_status := Fnd_Api.g_ret_sts_success;
633: ----------------------- validate -----------------------
634: IF G_DEBUG='Y' THEN
635: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
636: END IF;
637:
638: Validate_Approval_Rules (
639: p_api_version => l_api_version,

Line 727: Ahl_Debug_Pub.debug( l_full_name ||':Insert');

723: END IF;
724: */
725: -------------------------- insert --------------------------
726: IF G_DEBUG='Y' THEN
727: Ahl_Debug_Pub.debug( l_full_name ||':Insert');
728: END IF;
729:
730: -- Invoke the table handler to create a record
731: --

Line 787: Ahl_Debug_Pub.debug( l_full_name ||':End');

783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );
786: IF G_DEBUG='Y' THEN
787: Ahl_Debug_Pub.debug( l_full_name ||':End');
788: END IF;
789: -- Check if API is called in debug mode. If yes, disable debug.
790: IF G_DEBUG='Y' THEN
791: Ahl_Debug_Pub.disable_debug;

Line 791: Ahl_Debug_Pub.disable_debug;

787: Ahl_Debug_Pub.debug( l_full_name ||':End');
788: END IF;
789: -- Check if API is called in debug mode. If yes, disable debug.
790: IF G_DEBUG='Y' THEN
791: Ahl_Debug_Pub.disable_debug;
792: END IF;
793:
794: EXCEPTION
795: WHEN Fnd_Api.g_exc_error THEN

Line 877: Ahl_Debug_Pub.enable_debug;

873: SAVEPOINT Update_Approval_Rules;
874:
875: -- Check if API is called in debug mode. If yes, enable debug.
876: IF G_DEBUG='Y' THEN
877: Ahl_Debug_Pub.enable_debug;
878: END IF;
879: -- Debug info.
880: IF G_DEBUG='Y' THEN
881: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 881: Ahl_Debug_Pub.debug( l_full_name ||':Start');

877: Ahl_Debug_Pub.enable_debug;
878: END IF;
879: -- Debug info.
880: IF G_DEBUG='Y' THEN
881: Ahl_Debug_Pub.debug( l_full_name ||':Start');
882: END IF;
883: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
884: Fnd_Msg_Pub.initialize;
885: END IF;

Line 897: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

893: END IF;
894: x_return_status := Fnd_Api.g_ret_sts_success;
895: ----------------------- validate ----------------------
896: IF G_DEBUG='Y' THEN
897: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
898: END IF;
899:
900: --
901: -- To check whether the Operating Name is valid.

Line 1018: Ahl_Debug_Pub.debug( l_full_name ||':before status order Update');

1014: FETCH CUR_STATUS INTO l_status;
1015: CLOSE CUR_STATUS;
1016:
1017: IF G_DEBUG='Y' THEN
1018: Ahl_Debug_Pub.debug( l_full_name ||':before status order Update');
1019: END IF;
1020:
1021: IF UPPER(l_status) <> UPPER(p_Approval_Rules_rec.status_code) THEN
1022:

Line 1060: Ahl_Debug_Pub.debug( l_full_name ||':Update');

1056: CLOSE CUR_SEED;
1057:
1058: -------------------------- update --------------------
1059: IF G_DEBUG='Y' THEN
1060: Ahl_Debug_Pub.debug( l_full_name ||':Update');
1061: END IF;
1062:
1063: Ahl_Approval_Rules_Pkg.UPDATE_ROW (
1064: X_APPROVAL_RULE_ID => l_Approval_Rules_rec.APPROVAL_RULE_ID,

Line 1108: Ahl_Debug_Pub.debug( l_full_name ||':End');

1104: p_data => x_msg_data
1105: );
1106:
1107: IF G_DEBUG='Y' THEN
1108: Ahl_Debug_Pub.debug( l_full_name ||':End');
1109: END IF;
1110:
1111: -- Check if API is called in debug mode. If yes, disable debug.
1112: IF G_DEBUG='Y' THEN

Line 1113: Ahl_Debug_Pub.disable_debug;

1109: END IF;
1110:
1111: -- Check if API is called in debug mode. If yes, disable debug.
1112: IF G_DEBUG='Y' THEN
1113: Ahl_Debug_Pub.disable_debug;
1114: END IF;
1115: EXCEPTION
1116: WHEN Fnd_Api.g_exc_error THEN
1117: ROLLBACK TO Update_Approval_Rules;

Line 1532: Ahl_Debug_Pub.enable_debug;

1528: --------------------- initialize -----------------------
1529: SAVEPOINT Delete_Approval_Rules;
1530: -- Check if API is called in debug mode. If yes, enable debug.
1531: IF G_DEBUG='Y' THEN
1532: Ahl_Debug_Pub.enable_debug;
1533: END IF;
1534: -- Debug info.
1535: IF G_DEBUG='Y' THEN
1536: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 1536: Ahl_Debug_Pub.debug( l_full_name ||':Start');

1532: Ahl_Debug_Pub.enable_debug;
1533: END IF;
1534: -- Debug info.
1535: IF G_DEBUG='Y' THEN
1536: Ahl_Debug_Pub.debug( l_full_name ||':Start');
1537: END IF;
1538: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1539: Fnd_Msg_Pub.initialize;
1540: END IF;

Line 1553: Ahl_Debug_Pub.debug( l_full_name ||':Delete');

1549: x_return_status := Fnd_Api.g_ret_sts_success;
1550:
1551: ------------------------ delete ------------------------
1552: IF G_DEBUG='Y' THEN
1553: Ahl_Debug_Pub.debug( l_full_name ||':Delete');
1554: END IF;
1555:
1556: OPEN c_Approval_Rules;
1557: FETCH c_Approval_Rules INTO l_Approval_Rules_rec;

Line 1605: Ahl_Debug_Pub.debug( l_full_name ||':End');

1601: p_count => x_msg_count,
1602: p_data => x_msg_data
1603: );
1604: IF G_DEBUG='Y' THEN
1605: Ahl_Debug_Pub.debug( l_full_name ||':End');
1606: END IF;
1607: -- Check if API is called in debug mode. If yes, disable debug.
1608: IF G_DEBUG='Y' THEN
1609: Ahl_Debug_Pub.disable_debug;

Line 1609: Ahl_Debug_Pub.disable_debug;

1605: Ahl_Debug_Pub.debug( l_full_name ||':End');
1606: END IF;
1607: -- Check if API is called in debug mode. If yes, disable debug.
1608: IF G_DEBUG='Y' THEN
1609: Ahl_Debug_Pub.disable_debug;
1610: END IF;
1611: EXCEPTION
1612: WHEN Fnd_Api.g_exc_error THEN
1613: ROLLBACK TO Delete_Approval_Rules;

Line 1666: Ahl_Debug_Pub.enable_debug;

1662: BEGIN
1663: --------------------- initialize -----------------------
1664: -- Check if API is called in debug mode. If yes, enable debug.
1665: IF G_DEBUG='Y' THEN
1666: Ahl_Debug_Pub.enable_debug;
1667: END IF;
1668: -- Debug info.
1669: IF G_DEBUG='Y' THEN
1670: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 1670: Ahl_Debug_Pub.debug( l_full_name ||':Start');

1666: Ahl_Debug_Pub.enable_debug;
1667: END IF;
1668: -- Debug info.
1669: IF G_DEBUG='Y' THEN
1670: Ahl_Debug_Pub.debug( l_full_name ||':Start');
1671: END IF;
1672: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
1673: Fnd_Msg_Pub.initialize;
1674: END IF;

Line 1686: Ahl_Debug_Pub.debug( l_full_name ||':Check items');

1682: END IF;
1683: x_return_status := Fnd_Api.g_ret_sts_success;
1684: ---------------------- validate ------------------------
1685: IF G_DEBUG='Y' THEN
1686: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
1687: END IF;
1688: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1689: Check_Approval_Rules_Items (
1690: p_Approval_Rules_rec => p_Approval_Rules_rec,

Line 1701: Ahl_Debug_Pub.debug( l_full_name ||':Check record');

1697: RAISE Fnd_Api.g_exc_error;
1698: END IF;
1699: END IF;
1700: IF G_DEBUG='Y' THEN
1701: Ahl_Debug_Pub.debug( l_full_name ||':Check record');
1702: END IF;
1703:
1704: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
1705: Check_Approval_Rules_Record (

Line 1723: Ahl_Debug_Pub.debug( l_full_name ||':End');

1719: p_count => x_msg_count,
1720: p_data => x_msg_data
1721: );
1722: IF G_DEBUG='Y' THEN
1723: Ahl_Debug_Pub.debug( l_full_name ||':End');
1724: END IF;
1725: -- Check if API is called in debug mode. If yes, disable debug.
1726: IF G_DEBUG='Y' THEN
1727: Ahl_Debug_Pub.disable_debug;

Line 1727: Ahl_Debug_Pub.disable_debug;

1723: Ahl_Debug_Pub.debug( l_full_name ||':End');
1724: END IF;
1725: -- Check if API is called in debug mode. If yes, disable debug.
1726: IF G_DEBUG='Y' THEN
1727: Ahl_Debug_Pub.disable_debug;
1728: END IF;
1729: EXCEPTION
1730: WHEN Fnd_Api.g_exc_error THEN
1731: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1986: Ahl_Debug_Pub.debug( 'START DATE:'||TO_CHAR(l_Approval_Rules_rec.active_start_date,'DD_MON_YYYY'));

1982: l_count NUMBER := 0;
1983:
1984: BEGIN
1985: IF G_DEBUG='Y' THEN
1986: Ahl_Debug_Pub.debug( 'START DATE:'||TO_CHAR(l_Approval_Rules_rec.active_start_date,'DD_MON_YYYY'));
1987: Ahl_Debug_Pub.debug( 'END DATE:'||TO_CHAR(l_Approval_Rules_rec.active_end_date,'DD_MON_YYYY'));
1988: END IF;
1989:
1990: IF l_Approval_Rules_rec.active_start_date IS NOT NULL THEN

Line 1987: Ahl_Debug_Pub.debug( 'END DATE:'||TO_CHAR(l_Approval_Rules_rec.active_end_date,'DD_MON_YYYY'));

1983:
1984: BEGIN
1985: IF G_DEBUG='Y' THEN
1986: Ahl_Debug_Pub.debug( 'START DATE:'||TO_CHAR(l_Approval_Rules_rec.active_start_date,'DD_MON_YYYY'));
1987: Ahl_Debug_Pub.debug( 'END DATE:'||TO_CHAR(l_Approval_Rules_rec.active_end_date,'DD_MON_YYYY'));
1988: END IF;
1989:
1990: IF l_Approval_Rules_rec.active_start_date IS NOT NULL THEN
1991: IF l_Approval_Rules_rec.active_end_Date IS NOT NULL THEN

Line 2378: Ahl_Debug_Pub.enable_debug;

2374: --------------------- initialize -----------------------
2375: SAVEPOINT Create_Approvers;
2376: -- Check if API is called in debug mode. If yes, enable debug.
2377: IF G_DEBUG='Y' THEN
2378: Ahl_Debug_Pub.enable_debug;
2379: END IF;
2380: -- Debug info.
2381: IF G_DEBUG='Y' THEN
2382: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 2382: Ahl_Debug_Pub.debug( l_full_name ||':Start');

2378: Ahl_Debug_Pub.enable_debug;
2379: END IF;
2380: -- Debug info.
2381: IF G_DEBUG='Y' THEN
2382: Ahl_Debug_Pub.debug( l_full_name ||':Start');
2383: END IF;
2384:
2385: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
2386: Fnd_Msg_Pub.initialize;

Line 2399: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

2395: END IF;
2396: x_return_status := Fnd_Api.g_ret_sts_success;
2397: ----------------------- validate -----------------------
2398: IF G_DEBUG='Y' THEN
2399: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
2400: END IF;
2401:
2402: Validate_Approvers (
2403: p_api_version => l_api_version,

Line 2483: Ahl_Debug_Pub.debug( l_full_name ||':Insert');

2479: END IF;
2480:
2481: -------------------------- insert --------------------------
2482: IF G_DEBUG='Y' THEN
2483: Ahl_Debug_Pub.debug( l_full_name ||':Insert');
2484: END IF;
2485: -- Invoke the table handler to create a record
2486: --
2487: Ahl_Approvers_Pkg.Insert_Row (

Line 2534: Ahl_Debug_Pub.debug( l_full_name ||':End');

2530: p_count => x_msg_count,
2531: p_data => x_msg_data
2532: );
2533: IF G_DEBUG='Y' THEN
2534: Ahl_Debug_Pub.debug( l_full_name ||':End');
2535: END IF;
2536: -- Check if API is called in debug mode. If yes, disable debug.
2537: IF G_DEBUG='Y' THEN
2538: Ahl_Debug_Pub.disable_debug;

Line 2538: Ahl_Debug_Pub.disable_debug;

2534: Ahl_Debug_Pub.debug( l_full_name ||':End');
2535: END IF;
2536: -- Check if API is called in debug mode. If yes, disable debug.
2537: IF G_DEBUG='Y' THEN
2538: Ahl_Debug_Pub.disable_debug;
2539: END IF;
2540:
2541: EXCEPTION
2542: WHEN Fnd_Api.g_exc_error THEN

Line 2602: Ahl_Debug_Pub.enable_debug;

2598: SAVEPOINT Update_Approvers;
2599:
2600: -- Check if API is called in debug mode. If yes, enable debug.
2601: IF G_DEBUG='Y' THEN
2602: Ahl_Debug_Pub.enable_debug;
2603: END IF;
2604: -- Debug info.
2605: IF G_DEBUG='Y' THEN
2606: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 2606: Ahl_Debug_Pub.debug( l_full_name ||':Start');

2602: Ahl_Debug_Pub.enable_debug;
2603: END IF;
2604: -- Debug info.
2605: IF G_DEBUG='Y' THEN
2606: Ahl_Debug_Pub.debug( l_full_name ||':Start');
2607: END IF;
2608: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
2609: Fnd_Msg_Pub.initialize;
2610: END IF;

Line 2622: Ahl_Debug_Pub.debug( l_full_name ||':Validate');

2618: END IF;
2619: x_return_status := Fnd_Api.g_ret_sts_success;
2620: ----------------------- validate ----------------------
2621: IF G_DEBUG='Y' THEN
2622: Ahl_Debug_Pub.debug( l_full_name ||':Validate');
2623: END IF;
2624: -- replace g_miss_char/num/date with current column values
2625: Complete_Approvers_Rec (p_Approvers_rec, l_Approvers_rec);
2626: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

Line 2666: Ahl_Debug_Pub.debug( l_full_name ||':Update');

2662: END IF;
2663:
2664: ------------------------- update --------------------
2665: IF G_DEBUG='Y' THEN
2666: Ahl_Debug_Pub.debug( l_full_name ||':Update');
2667: END IF;
2668:
2669: Ahl_Approvers_Pkg. UPDATE_ROW (
2670: X_APPROVAL_APPROVER_ID => l_Approvers_rec.APPROVAL_APPROVER_ID,

Line 2707: Ahl_Debug_Pub.debug( l_full_name ||':End');

2703: p_count => x_msg_count,
2704: p_data => x_msg_data
2705: );
2706: IF G_DEBUG='Y' THEN
2707: Ahl_Debug_Pub.debug( l_full_name ||':End');
2708: END IF;
2709: -- Check if API is called in debug mode. If yes, disable debug.
2710: IF G_DEBUG='Y' THEN
2711: Ahl_Debug_Pub.disable_debug;

Line 2711: Ahl_Debug_Pub.disable_debug;

2707: Ahl_Debug_Pub.debug( l_full_name ||':End');
2708: END IF;
2709: -- Check if API is called in debug mode. If yes, disable debug.
2710: IF G_DEBUG='Y' THEN
2711: Ahl_Debug_Pub.disable_debug;
2712: END IF;
2713: EXCEPTION
2714: WHEN Fnd_Api.g_exc_error THEN
2715: ROLLBACK TO Update_Approvers;

Line 2848: Ahl_Debug_Pub.enable_debug;

2844: --------------------- initialize -----------------------
2845: SAVEPOINT Delete_Approvers;
2846: -- Check if API is called in debug mode. If yes, enable debug.
2847: IF G_DEBUG='Y' THEN
2848: Ahl_Debug_Pub.enable_debug;
2849: END IF;
2850: -- Debug info.
2851: IF G_DEBUG='Y' THEN
2852: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 2852: Ahl_Debug_Pub.debug( l_full_name ||':Start');

2848: Ahl_Debug_Pub.enable_debug;
2849: END IF;
2850: -- Debug info.
2851: IF G_DEBUG='Y' THEN
2852: Ahl_Debug_Pub.debug( l_full_name ||':Start');
2853: END IF;
2854: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
2855: Fnd_Msg_Pub.initialize;
2856: END IF;

Line 2907: Ahl_Debug_Pub.debug( l_full_name ||':Delete');

2903: /* End Code for checking approvals by shbhanda Mar'08---*/
2904:
2905: ------------------------ delete ------------------------
2906: IF G_DEBUG='Y' THEN
2907: Ahl_Debug_Pub.debug( l_full_name ||':Delete');
2908: END IF;
2909: -- Delete data
2910:
2911: DELETE FROM Ahl_Approvers

Line 2932: Ahl_Debug_Pub.debug( l_full_name ||':End');

2928: p_count => x_msg_count,
2929: p_data => x_msg_data
2930: );
2931: IF G_DEBUG='Y' THEN
2932: Ahl_Debug_Pub.debug( l_full_name ||':End');
2933: END IF;
2934: -- Check if API is called in debug mode. If yes, disable debug.
2935: IF G_DEBUG='Y' THEN
2936: Ahl_Debug_Pub.disable_debug;

Line 2936: Ahl_Debug_Pub.disable_debug;

2932: Ahl_Debug_Pub.debug( l_full_name ||':End');
2933: END IF;
2934: -- Check if API is called in debug mode. If yes, disable debug.
2935: IF G_DEBUG='Y' THEN
2936: Ahl_Debug_Pub.disable_debug;
2937: END IF;
2938: EXCEPTION
2939: WHEN Fnd_Api.g_exc_error THEN
2940: ROLLBACK TO Delete_Approvers;

Line 2995: Ahl_Debug_Pub.enable_debug;

2991: BEGIN
2992: --------------------- initialize -----------------------
2993: -- Check if API is called in debug mode. If yes, enable debug.
2994: IF G_DEBUG='Y' THEN
2995: Ahl_Debug_Pub.enable_debug;
2996: END IF;
2997: -- Debug info.
2998: IF G_DEBUG='Y' THEN
2999: Ahl_Debug_Pub.debug( l_full_name ||':Start');

Line 2999: Ahl_Debug_Pub.debug( l_full_name ||':Start');

2995: Ahl_Debug_Pub.enable_debug;
2996: END IF;
2997: -- Debug info.
2998: IF G_DEBUG='Y' THEN
2999: Ahl_Debug_Pub.debug( l_full_name ||':Start');
3000: END IF;
3001: IF Fnd_Api.to_boolean (p_init_msg_list) THEN
3002: Fnd_Msg_Pub.initialize;
3003: END IF;

Line 3015: Ahl_Debug_Pub.debug( l_full_name ||':Check items');

3011: END IF;
3012: x_return_status := Fnd_Api.g_ret_sts_success;
3013: ---------------------- validate ------------------------
3014: IF G_DEBUG='Y' THEN
3015: Ahl_Debug_Pub.debug( l_full_name ||':Check items');
3016: END IF;
3017:
3018: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3019: Check_Approvers_Items (

Line 3031: Ahl_Debug_Pub.debug( l_full_name ||':Check record');

3027: RAISE Fnd_Api.g_exc_error;
3028: END IF;
3029: END IF;
3030: IF G_DEBUG='Y' THEN
3031: Ahl_Debug_Pub.debug( l_full_name ||':Check record');
3032: END IF;
3033:
3034: -------------------- finish --------------------------
3035: Fnd_Msg_Pub.count_and_get (

Line 3041: Ahl_Debug_Pub.debug( l_full_name ||':End');

3037: p_count => x_msg_count,
3038: p_data => x_msg_data
3039: );
3040: IF G_DEBUG='Y' THEN
3041: Ahl_Debug_Pub.debug( l_full_name ||':End');
3042: END IF;
3043: -- Check if API is called in debug mode. If yes, disable debug.
3044: IF G_DEBUG='Y' THEN
3045: Ahl_Debug_Pub.disable_debug;

Line 3045: Ahl_Debug_Pub.disable_debug;

3041: Ahl_Debug_Pub.debug( l_full_name ||':End');
3042: END IF;
3043: -- Check if API is called in debug mode. If yes, disable debug.
3044: IF G_DEBUG='Y' THEN
3045: Ahl_Debug_Pub.disable_debug;
3046: END IF;
3047: EXCEPTION
3048: WHEN Fnd_Api.g_exc_error THEN
3049: x_return_status := Fnd_Api.g_ret_sts_error;