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 115.10 2003/10/20 19:37:07 sikumar noship $ */
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 1265: AHL_DEBUG_PUB.ENABLE_DEBUG;

1261:
1262: BEGIN
1263:
1264: IF G_DEBUG='Y' THEN
1265: AHL_DEBUG_PUB.ENABLE_DEBUG;
1266: END IF;
1267:
1268: --
1269: -- RUN Mode

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

1276: ,itemkey => itemkey
1277: ,aname => 'UPDATE_GEN_STATUS'
1278: );
1279: IF G_DEBUG='Y' THEN
1280: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_approval_status='||l_approval_status);
1281: END IF;
1282:
1283: /*
1284: IF l_approval_status = 'APPROVED'

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

1297: ,aname => 'REJECT_STATUS_ID'
1298: );
1299: END IF;
1300: IF G_DEBUG='Y' THEN
1301: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status='||l_next_status);
1302:
1303: END IF;
1304: */
1305:

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

1311: ,itemkey => itemkey
1312: ,aname => 'OBJECT_VER'
1313: );
1314: IF G_DEBUG='Y' THEN
1315: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);
1316: END IF;
1317:
1318: l_object_id := wf_engine.getitemattrnumber
1319: (

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

1321: ,itemkey => itemkey
1322: ,aname => 'OBJECT_ID'
1323: );
1324: IF G_DEBUG='Y' THEN
1325: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);
1326: END IF;
1327:
1328: l_status_date := SYSDATE;
1329:

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

1378: x_msg_count => x_msg_count,
1379: x_msg_data => x_msg_data
1380: );
1381: IF G_DEBUG='Y' THEN
1382: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed AHL_PC_HEADER_PVT.UPDATE_PC_HEADER');
1383: END IF;
1384:
1385: l_msg_count := x_msg_count;
1386:

Line 1492: AHL_DEBUG_PUB.ENABLE_DEBUG;

1488:
1489: BEGIN
1490:
1491: IF G_DEBUG='Y' THEN
1492: AHL_DEBUG_PUB.ENABLE_DEBUG;
1493: END IF;
1494:
1495: --
1496: -- RUN mode

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

1503: ,itemkey => itemkey
1504: ,aname => 'ORG_STATUS_ID'
1505: );
1506: IF G_DEBUG='Y' THEN
1507: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);
1508: END IF;
1509:
1510: l_object_version_number := wf_engine.getitemattrnumber
1511: (

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

1513: ,itemkey => itemkey
1514: ,aname => 'OBJECT_VER'
1515: );
1516: IF G_DEBUG='Y' THEN
1517: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);
1518: END IF;
1519:
1520: l_object_id := wf_engine.getitemattrnumber
1521: (

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

1523: ,itemkey => itemkey
1524: ,aname => 'OBJECT_ID'
1525: );
1526: IF G_DEBUG='Y' THEN
1527: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id'||l_object_id);
1528: END IF;
1529:
1530: l_status_date := SYSDATE;
1531:

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

1535: WHERE PC_HEADER_ID = l_object_id AND
1536: OBJECT_VERSION_NUMBER = l_object_version_number;
1537:
1538: IF G_DEBUG='Y' THEN
1539: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed reset of status');
1540: END IF;
1541:
1542: COMMIT;
1543: