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.AHL_PC_APPROVAL_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_PC_APPROVAL_PVT AS
2: /* $Header: AHLVPWKB.pls 120.2.12020000.2 2012/12/07 13:30:22 sareepar ship $ */
3:
4: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: PROCEDURE SET_ACTIVITY_DETAILS
8: (
9: itemtype IN VARCHAR2

Line 41: AHL_DEBUG_PUB.ENABLE_DEBUG;

37:
38: BEGIN
39:
40: IF G_DEBUG='Y' THEN
41: AHL_DEBUG_PUB.ENABLE_DEBUG;
42: END IF;
43:
44: fnd_msg_pub.initialize;
45:

Line 49: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Begin');

45:
46: l_return_status := FND_API.g_ret_sts_success;
47:
48: IF G_DEBUG='Y' THEN
49: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Begin');
50: END IF;
51:
52: l_object_id := wf_engine.getitemattrnumber
53: (

Line 60: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- OBJECT_ID='||l_object_id);

56: ,aname => 'OBJECT_ID'
57: );
58:
59: IF G_DEBUG='Y' THEN
60: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- OBJECT_ID='||l_object_id);
61: END IF;
62:
63: l_object_details.operating_unit_id := NULL;
64: l_object_details.priority := NULL;

Line 96: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);

92: ,aname => 'FORWARD_SUBJECT'
93: ,avalue => l_subject
94: );
95: IF G_DEBUG='Y' THEN
96: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FORWARD_SUBJECT='||l_subject);
97: END IF;
98:
99: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVAL_SUBJECT');
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 112: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);

108: ,aname => 'APPROVAL_SUBJECT'
109: ,avalue => l_subject
110: );
111: IF G_DEBUG='Y' THEN
112: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVAL_SUBJECT='||l_subject);
113: END IF;
114:
115: fnd_message.set_name('AHL', 'AHL_PC_NTF_REJECT_SUBJECT');
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 128: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);

124: ,aname => 'REJECT_SUBJECT'
125: ,avalue => l_subject
126: );
127: IF G_DEBUG='Y' THEN
128: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REJECT_SUBJECT='||l_subject);
129: END IF;
130:
131: fnd_message.set_name('AHL', 'AHL_PC_NTF_APPROVED_SUBJECT');
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 144: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);

140: ,aname => 'APPROVED_SUBJECT'
141: ,avalue => l_subject
142: );
143: IF G_DEBUG='Y' THEN
144: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVED_SUBJECT='||l_subject);
145: END IF;
146:
147: fnd_message.set_name('AHL', 'AHL_PC_NTF_FINAL_SUBJECT');
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 160: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);

156: ,aname => 'FINAL_SUBJECT'
157: ,avalue => l_subject
158: );
159: IF G_DEBUG='Y' THEN
160: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- FINAL_SUBJECT='||l_subject);
161: END IF;
162:
163: fnd_message.set_name('AHL', 'AHL_PC_NTF_REMIND_SUBJECT');
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 176: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);

172: ,aname => 'REMIND_SUBJECT'
173: ,avalue => l_subject
174: );
175: IF G_DEBUG='Y' THEN
176: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- REMIND_SUBJECT='||l_subject);
177: END IF;
178:
179: fnd_message.set_name('AHL', 'AHL_PC_NTF_ERROR_SUBJECT');
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);

Line 192: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);

188: ,aname => 'ERROR_SUBJECT'
189: ,avalue => l_subject
190: );
191: IF G_DEBUG='Y' THEN
192: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- ERROR_SUBJECT='||l_subject);
193: END IF;
194:
195: AHL_GENERIC_APRV_PVT.GET_APPROVAL_DETAILS
196: (

Line 205: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Completed GET_APPROVAL_DETAILS');

201: x_approver_seq => l_approver_seq,
202: x_return_status => l_return_status
203: );
204: IF G_DEBUG='Y' THEN
205: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Completed GET_APPROVAL_DETAILS');
206: END IF;
207:
208: IF l_return_status = FND_API.g_ret_sts_success
209: THEN

Line 218: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);

214: aname => 'RULE_ID',
215: avalue => l_approval_rule_id
216: );
217: IF G_DEBUG='Y' THEN
218: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
219: END IF;
220:
221: wf_engine.setitemattrnumber
222: (

Line 229: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);

225: aname => 'APPROVER_SEQ',
226: avalue => l_approver_seq
227: );
228: IF G_DEBUG='Y' THEN
229: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- APPROVER_SEQ='||l_approver_seq);
230: END IF;
231:
232: resultout := 'COMPLETE:SUCCESS';
233: RETURN;

Line 335: AHL_DEBUG_PUB.ENABLE_DEBUG;

331:
332: BEGIN
333:
334: IF G_DEBUG='Y' THEN
335: AHL_DEBUG_PUB.ENABLE_DEBUG;
336: END IF;
337:
338: document_type := 'text/plain';
339:

Line 389: AHL_DEBUG_PUB.debug('PCWF -- NTF_FORWARD_FYI -- document='||document);

385: CLOSE GET_PC_HEADER_DET;
386:
387: document := document || l_body;
388: IF G_DEBUG='Y' THEN
389: AHL_DEBUG_PUB.debug('PCWF -- NTF_FORWARD_FYI -- document='||document);
390: END IF;
391:
392: COMMIT;
393: RETURN;

Line 465: AHL_DEBUG_PUB.ENABLE_DEBUG;

461:
462: BEGIN
463:
464: IF G_DEBUG='Y' THEN
465: AHL_DEBUG_PUB.ENABLE_DEBUG;
466: END IF;
467:
468: document_type := 'text/plain';
469:

Line 519: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVED_FYI -- document='||document);

515: CLOSE GET_PC_HEADER_DET;
516:
517: document := document || l_body;
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVED_FYI -- document='||document);
520: END IF;
521:
522: RETURN;
523:

Line 592: AHL_DEBUG_PUB.ENABLE_DEBUG;

588:
589: BEGIN
590:
591: IF G_DEBUG='Y' THEN
592: AHL_DEBUG_PUB.ENABLE_DEBUG;
593: END IF;
594:
595: document_type := 'text/plain';
596:

Line 638: AHL_DEBUG_PUB.debug('PCWF -- NTF_FINAL_APPROVAL_FYI -- document='||document);

634: CLOSE GET_PC_HEADER_DET;
635:
636: document := document || l_body;
637: IF G_DEBUG='Y' THEN
638: AHL_DEBUG_PUB.debug('PCWF -- NTF_FINAL_APPROVAL_FYI -- document='||document);
639: END IF;
640:
641: RETURN;
642:

Line 714: AHL_DEBUG_PUB.ENABLE_DEBUG;

710:
711: BEGIN
712:
713: IF G_DEBUG='Y' THEN
714: AHL_DEBUG_PUB.ENABLE_DEBUG;
715: END IF;
716:
717: document_type := 'text/plain';
718:

Line 768: AHL_DEBUG_PUB.debug('PCWF -- NTF_REJECTED_FYI -- document='||document);

764: CLOSE GET_PC_HEADER_DET;
765:
766: document := document || l_body;
767: IF G_DEBUG='Y' THEN
768: AHL_DEBUG_PUB.debug('PCWF -- NTF_REJECTED_FYI -- document='||document);
769: END IF;
770:
771: RETURN;
772:

Line 844: AHL_DEBUG_PUB.ENABLE_DEBUG;

840:
841: BEGIN
842:
843: IF G_DEBUG='Y' THEN
844: AHL_DEBUG_PUB.ENABLE_DEBUG;
845: END IF;
846:
847: document_type := 'text/plain';
848:

Line 907: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVAL -- document='||document);

903: CLOSE GET_PC_HEADER_DET;
904:
905: document := document || l_body;
906: IF G_DEBUG='Y' THEN
907: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVAL -- document='||document);
908: END IF;
909:
910: RETURN;
911:

Line 982: AHL_DEBUG_PUB.ENABLE_DEBUG;

978:
979: BEGIN
980:
981: IF G_DEBUG='Y' THEN
982: AHL_DEBUG_PUB.ENABLE_DEBUG;
983: END IF;
984:
985: document_type := 'text/plain';
986:

Line 1045: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVAL_REMINDER -- document='||document);

1041: CLOSE GET_PC_HEADER_DET;
1042:
1043: document := document || l_body;
1044: IF G_DEBUG='Y' THEN
1045: AHL_DEBUG_PUB.debug('PCWF -- NTF_APPROVAL_REMINDER -- document='||document);
1046: END IF;
1047:
1048: RETURN;
1049:

Line 1118: AHL_DEBUG_PUB.ENABLE_DEBUG;

1114:
1115: BEGIN
1116:
1117: IF G_DEBUG='Y' THEN
1118: AHL_DEBUG_PUB.ENABLE_DEBUG;
1119: END IF;
1120:
1121: document_type := 'text/plain';
1122:

Line 1179: AHL_DEBUG_PUB.debug('PCWF -- NTF_ERROR_ACT -- document='||document);

1175: CLOSE GET_PC_HEADER_DET;
1176:
1177: document := document || l_body;
1178: IF G_DEBUG='Y' THEN
1179: AHL_DEBUG_PUB.debug('PCWF -- NTF_ERROR_ACT -- document='||document);
1180: END IF;
1181:
1182: RETURN;
1183:

Line 1270: AHL_DEBUG_PUB.ENABLE_DEBUG;

1266:
1267: BEGIN
1268:
1269: IF G_DEBUG='Y' THEN
1270: AHL_DEBUG_PUB.ENABLE_DEBUG;
1271: END IF;
1272:
1273: --
1274: -- RUN Mode

Line 1285: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_approval_status='||l_approval_status);

1281: ,itemkey => itemkey
1282: ,aname => 'UPDATE_GEN_STATUS'
1283: );
1284: IF G_DEBUG='Y' THEN
1285: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_approval_status='||l_approval_status);
1286: END IF;
1287:
1288: /*
1289: IF l_approval_status = 'APPROVED'

Line 1306: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status='||l_next_status);

1302: ,aname => 'REJECT_STATUS_ID'
1303: );
1304: END IF;
1305: IF G_DEBUG='Y' THEN
1306: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status='||l_next_status);
1307:
1308: END IF;
1309: */
1310:

Line 1320: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);

1316: ,itemkey => itemkey
1317: ,aname => 'OBJECT_VER'
1318: );
1319: IF G_DEBUG='Y' THEN
1320: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);
1321: END IF;
1322:
1323: l_object_id := wf_engine.getitemattrnumber
1324: (

Line 1345: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);

1341: l_bue_flag := 'Y';
1342: END IF;
1343:
1344: IF G_DEBUG='Y' THEN
1345: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);
1346: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_msg='||l_bue_msg);
1347: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_flag='||l_bue_flag);
1348: END IF;
1349:

Line 1346: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_msg='||l_bue_msg);

1342: END IF;
1343:
1344: IF G_DEBUG='Y' THEN
1345: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);
1346: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_msg='||l_bue_msg);
1347: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_flag='||l_bue_flag);
1348: END IF;
1349:
1350: l_status_date := SYSDATE;

Line 1347: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_flag='||l_bue_flag);

1343:
1344: IF G_DEBUG='Y' THEN
1345: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);
1346: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_msg='||l_bue_msg);
1347: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_bue_flag='||l_bue_flag);
1348: END IF;
1349:
1350: l_status_date := SYSDATE;
1351:

Line 1407: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed AHL_PC_HEADER_PVT.UPDATE_PC_HEADER');

1403: x_msg_data => x_msg_data,
1404: x_warning_msg_data => x_warning_msg_data
1405: );
1406: IF G_DEBUG='Y' THEN
1407: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed AHL_PC_HEADER_PVT.UPDATE_PC_HEADER');
1408: END IF;
1409:
1410: l_msg_count := x_msg_count;
1411:

Line 1517: AHL_DEBUG_PUB.ENABLE_DEBUG;

1513:
1514: BEGIN
1515:
1516: IF G_DEBUG='Y' THEN
1517: AHL_DEBUG_PUB.ENABLE_DEBUG;
1518: END IF;
1519:
1520: --
1521: -- RUN mode

Line 1532: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);

1528: ,itemkey => itemkey
1529: ,aname => 'ORG_STATUS_ID'
1530: );
1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);
1533: END IF;
1534:
1535: l_object_version_number := wf_engine.getitemattrnumber
1536: (

Line 1542: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);

1538: ,itemkey => itemkey
1539: ,aname => 'OBJECT_VER'
1540: );
1541: IF G_DEBUG='Y' THEN
1542: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);
1543: END IF;
1544:
1545: l_object_id := wf_engine.getitemattrnumber
1546: (

Line 1552: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id'||l_object_id);

1548: ,itemkey => itemkey
1549: ,aname => 'OBJECT_ID'
1550: );
1551: IF G_DEBUG='Y' THEN
1552: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id'||l_object_id);
1553: END IF;
1554:
1555: l_status_date := SYSDATE;
1556:

Line 1564: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed reset of status');

1560: WHERE PC_HEADER_ID = l_object_id AND
1561: OBJECT_VERSION_NUMBER = l_object_version_number;
1562:
1563: IF G_DEBUG='Y' THEN
1564: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed reset of status');
1565: END IF;
1566:
1567: COMMIT;
1568: