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_ITEMGROUPS_APPROVAL_PVT dependencies on AHL_ITEMGROUPS_APPROVAL_PVT

Line 1: PACKAGE BODY AHL_ITEMGROUPS_APPROVAL_PVT AS

1: PACKAGE BODY AHL_ITEMGROUPS_APPROVAL_PVT AS
2: /* $Header: AHLVIWFB.pls 120.0 2005/05/26 01:58:44 appldev noship $ */
3: --------------------------------------------------------------------------
4: -- PROCEDURE
5: -- Set_Activity_Details

Line 69: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start SetActvityDetails');

65:
66: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
67: THEN
68: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
69: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start SetActvityDetails');
70: END IF;
71: -- Debug info.
72:
73: fnd_msg_pub.initialize;

Line 108: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_group_rec.name);

104:
105: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
106: THEN
107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
108: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_group_rec.name);
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);
111:
112: END IF;

Line 110: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);

106: THEN
107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
108: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_group_rec.name);
109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
110: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);
111:
112: END IF;
113:
114:

Line 167: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_subject'||l_subject);

163: );
164: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
165: THEN
166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
167: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_subject'||l_subject);
168: END IF;
169:
170:
171: -----------------------------------------------------------------------------------

Line 178: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);

174:
175: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
176: THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
178: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
180: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);

Line 180: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);

176: THEN
177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
178: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
180: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));

Line 182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);

178: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
180: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
185: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
186: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));

Line 184: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));

180: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
185: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
186: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));
187: END IF;
188: ahl_generic_aprv_pvt.get_approval_details(

Line 186: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));

182: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
184: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
185: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
186: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));
187: END IF;
188: ahl_generic_aprv_pvt.get_approval_details(
189: p_object => l_object,
190: p_approval_type => l_approval_type,

Line 200: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);

196:
197:
198: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
200: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);
201: END IF;
202:
203: IF l_return_status = fnd_api.g_ret_sts_success THEN
204:

Line 273: 'AHL_ITEMGROUPS_APPROVAL_PVT'

269: resultout := 'COMPLETE:ERROR';
270:
271: WHEN OTHERS THEN
272: wf_core.context(
273: 'AHL_ITEMGROUPS_APPROVAL_PVT'
274: ,'Set_Activity_Details'
275: ,itemtype
276: ,itemkey
277: ,actid

Line 328: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfForwardFyi');

324:
325: BEGIN
326: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
328: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfForwardFyi');
329: END IF;
330:
331: -- Debug info.
332:

Line 405: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','ntf_forward_fyi',

401: p_msg_data => l_msg_data ,
402: p_attr_name => 'ERROR_MSG',
403: x_error_msg => l_error_msg
404: ) ;
405: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','ntf_forward_fyi',
406: l_item_type,l_item_key,l_error_msg);
407: RAISE;
408: WHEN OTHERS THEN
409: wf_core.context( 'AHLGAPP'

Line 459: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfApproved Fyi');

455:
456: BEGIN
457: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
459: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfApproved Fyi');
460: END IF;
461:
462: document_type := 'text/plain';
463:

Line 531: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approved_FYI',

527: p_msg_data => l_msg_data ,
528: p_attr_name => 'ERROR_MSG',
529: x_error_msg => l_error_msg
530: ) ;
531: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approved_FYI',
532: l_item_type,l_item_key,l_error_msg);
533: RAISE;
534: WHEN OTHERS THEN
535: wf_core.context( 'AHLGAPP'

Line 606: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','NtfyFinalApprovalFyi');

602: BEGIN
603:
604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
606: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','NtfyFinalApprovalFyi');
607: END IF;
608:
609:
610: document_type := 'text/plain';

Line 614: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Notify Final approval;');

610: document_type := 'text/plain';
611:
612: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
613: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
614: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Notify Final approval;');
615: END IF;
616: -- parse document_id for the ':' dividing item type name from item key value
617: -- document_id value will take the form : starting with
618: -- release 2.5 version of this demo

Line 681: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Final_Approval_FYI',

677: p_msg_data => l_msg_data ,
678: p_attr_name => 'ERROR_MSG',
679: x_error_msg => l_error_msg
680: ) ;
681: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Final_Approval_FYI',
682: l_item_type,l_item_key,l_error_msg);
683: RAISE;
684: WHEN OTHERS THEN
685: wf_core.context( 'AHLGAPP'

Line 753: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start NtfyRejectedFYi');

749:
750: BEGIN
751: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
753: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start NtfyRejectedFYi');
754: END IF;
755:
756:
757: document_type := 'text/plain';

Line 828: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Rejected_FYI',

824: p_msg_data => l_msg_data ,
825: p_attr_name => 'ERROR_MSG',
826: x_error_msg => l_error_msg
827: ) ;
828: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Rejected_FYI',
829: l_item_type,l_item_key,l_error_msg);
830: RAISE;
831:
832: WHEN OTHERS THEN

Line 904: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfyApproval');

900:
901: BEGIN
902: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
904: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfyApproval');
905: END IF;
906:
907: document_type := 'text/plain';
908:

Line 984: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approval',

980: p_msg_data => l_msg_data ,
981: p_attr_name => 'ERROR_MSG',
982: x_error_msg => l_error_msg
983: ) ;
984: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approval',
985: l_item_type,l_item_key,l_error_msg);
986: RAISE;
987: WHEN OTHERS THEN
988: wf_core.context( 'AHLGAPP'

Line 1057: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfyApprovalRemainder');

1053:
1054: BEGIN
1055: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1056: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1057: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Start NtfyApprovalRemainder');
1058: END IF;
1059:
1060:
1061: document_type := 'text/plain';

Line 1140: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approval_Reminder',

1136: p_msg_data => l_msg_data ,
1137: p_attr_name => 'ERROR_MSG',
1138: x_error_msg => l_error_msg
1139: ) ;
1140: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Approval_Reminder',
1141: l_item_type,l_item_key,l_error_msg);
1142: RAISE;
1143: WHEN OTHERS THEN
1144: wf_core.context( 'AHLGAPP'

Line 1214: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'NtfyErrorAct');

1210:
1211: BEGIN
1212: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1214: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'NtfyErrorAct');
1215: END IF;
1216:
1217:
1218: document_type := 'text/plain';

Line 1293: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Error_Act',

1289: p_msg_data => l_msg_data ,
1290: p_attr_name => 'ERROR_MSG',
1291: x_error_msg => l_error_msg
1292: ) ;
1293: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Error_Act',
1294: l_item_type,l_item_key,l_error_msg);
1295: RAISE;
1296: WHEN OTHERS THEN
1297: wf_core.context( 'AHL_ITEMGROUPS_APPROVAL_PVT'

Line 1297: wf_core.context( 'AHL_ITEMGROUPS_APPROVAL_PVT'

1293: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','Ntf_Error_Act',
1294: l_item_type,l_item_key,l_error_msg);
1295: RAISE;
1296: WHEN OTHERS THEN
1297: wf_core.context( 'AHL_ITEMGROUPS_APPROVAL_PVT'
1298: , 'Ntf_Error_Act'
1299: , l_item_type
1300: , l_item_key
1301: );

Line 1364: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');

1360:
1361: BEGIN
1362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1364: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
1365: END IF;
1366:
1367: IF funcmode = 'RUN' THEN
1368: l_approval_status := wf_engine.getitemattrtext(

Line 1375: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');

1371: ,aname => 'UPDATE_GEN_STATUS'
1372: );
1373: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1374: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1375: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
1376: END IF;
1377:
1378: IF l_approval_status = 'APPROVED' THEN
1379: l_next_status := wf_engine.getitemattrText(

Line 1408: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));

1404: l_status_date := SYSDATE;
1405:
1406: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1408: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1410: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1412: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));

Line 1410: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);

1406: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1408: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1410: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1412: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1414: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);

Line 1412: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));

1408: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1410: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1412: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1414: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);
1415: END IF;
1416:

Line 1414: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);

1410: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1412: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1414: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);
1415: END IF;
1416:
1417: OPEN GetItemGroupDet(l_object_id);
1418: FETCH GetItemGroupDet into l_item_group_rec;

Line 1454: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','After Complete Item Group Revision:L_ApprovalStatus'||l_approval_status);

1450: p_object_version_number =>l_object_version_number
1451: );
1452: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1454: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','After Complete Item Group Revision:L_ApprovalStatus'||l_approval_status);
1455: END IF;
1456:
1457: if (sql%notfound)
1458: then

Line 1495: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);

1491: EXCEPTION
1492: WHEN fnd_api.g_exc_error THEN
1493: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1494: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1495: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1496: END IF;
1497: FND_MSG_PUB.Count_And_Get (
1498: p_encoded => FND_API.G_FALSE,
1499: p_count => l_msg_count,

Line 1517: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);

1513:
1514: WHEN OTHERS THEN
1515: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1517: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);
1518:
1519: END IF;
1520:
1521: wf_core.context(

Line 1522: 'AHL_ITEMGROUPS_APPROVAL_PVT'

1518:
1519: END IF;
1520:
1521: wf_core.context(
1522: 'AHL_ITEMGROUPS_APPROVAL_PVT'
1523: ,'Update_Status'
1524: ,itemtype
1525: ,itemkey
1526: ,actid

Line 1589: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start RevertStatus');

1585:
1586: BEGIN
1587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1588: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1589: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start RevertStatus');
1590: END IF;
1591:
1592: l_return_Status:='S';
1593: IF funcmode = 'RUN' THEN

Line 1682: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','revert_status',

1678: p_msg_data => l_msg_data ,
1679: p_attr_name => 'ERROR_MSG',
1680: x_error_msg => l_error_msg
1681: ) ;
1682: wf_core.context('AHL_ITEMGROUPS_APPROVAL_PVT','revert_status',
1683: itemtype,itemkey,actid,funcmode,l_error_msg);
1684: RAISE;
1685: WHEN OTHERS THEN
1686: wf_core.context(

Line 1687: 'AHL_ItemGroups_APPROVAL_PVT'

1683: itemtype,itemkey,actid,funcmode,l_error_msg);
1684: RAISE;
1685: WHEN OTHERS THEN
1686: wf_core.context(
1687: 'AHL_ItemGroups_APPROVAL_PVT'
1688: ,'REVERT_STATUS'
1689: ,itemtype
1690: ,itemkey
1691: ,actid

Line 1699: END AHL_ITEMGROUPS_APPROVAL_PVT;

1695: RAISE;
1696:
1697: END Revert_Status;
1698:
1699: END AHL_ITEMGROUPS_APPROVAL_PVT;