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_ITEMCOMP_APPROVAL_PVT dependencies on AHL_ITEMCOMP_APPROVAL_PVT

Line 1: PACKAGE BODY AHL_ITEMCOMP_APPROVAL_PVT AS

1: PACKAGE BODY AHL_ITEMCOMP_APPROVAL_PVT AS
2: /* $Header: AHLVCWFB.pls 120.0 2005/05/26 01:48:12 appldev noship $ */
3: --------------------------------------------------------------------------
4: -- PROCEDURE
5: -- Set_Activity_Details

Line 77: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start SetActvityDetails');

73:
74: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
75: THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
77: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start SetActvityDetails');
78: END IF;
79: -- Debug info.
80:
81: fnd_msg_pub.initialize;

Line 143: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_comp_rec.ITEM_COMPOSITION_ID);

139:
140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
141: THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
143: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_comp_rec.ITEM_COMPOSITION_ID);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
145: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);
146:
147: END IF;

Line 145: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);

141: THEN
142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
143: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','ItemGroups Name'||l_item_comp_rec.ITEM_COMPOSITION_ID);
144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
145: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Subject:'||l_subject);
146:
147: END IF;
148:
149:

Line 202: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_subject'||l_subject);

198: );
199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
200: THEN
201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
202: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_subject'||l_subject);
203: END IF;
204:
205:
206: -----------------------------------------------------------------------------------

Line 213: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);

209:
210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
211: THEN
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
213: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
215: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);

Line 215: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);

211: THEN
212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
213: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
215: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
219: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));

Line 217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);

213: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Before getting approval details'||l_subject);
214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
215: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
219: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
221: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));

Line 219: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));

215: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_object-->'||l_object);
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
219: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
221: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));
222: END IF;
223: ahl_generic_aprv_pvt.get_approval_details(

Line 221: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));

217: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_type-->'||l_approval_type);
218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
219: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---l_approval_RULE_ID-->'||TO_CHAR(L_APPROVAL_RULE_ID));
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
221: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', '---L_APPROVER_SEQ-->'||TO_CHAR(L_APPROVER_SEQ));
222: END IF;
223: ahl_generic_aprv_pvt.get_approval_details(
224: p_object => l_object,
225: p_approval_type => l_approval_type,

Line 235: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);

231:
232:
233: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
235: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','AfterGetApprovalDetails:'||l_return_status||'-'||l_subject);
236: END IF;
237:
238: IF l_return_status = fnd_api.g_ret_sts_success THEN
239:

Line 308: 'AHL_ITEMCOMP_APPROVAL_PVT'

304: resultout := 'COMPLETE:ERROR';
305:
306: WHEN OTHERS THEN
307: wf_core.context(
308: 'AHL_ITEMCOMP_APPROVAL_PVT'
309: ,'Set_Activity_Details'
310: ,itemtype
311: ,itemkey
312: ,actid

Line 364: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfForwardFyi');

360:
361: BEGIN
362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
364: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfForwardFyi');
365: END IF;
366:
367: -- Debug info.
368:

Line 440: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','ntf_forward_fyi',

436: p_msg_data => l_msg_data ,
437: p_attr_name => 'ERROR_MSG',
438: x_error_msg => l_error_msg
439: ) ;
440: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','ntf_forward_fyi',
441: l_item_type,l_item_key,l_error_msg);
442: RAISE;
443: WHEN OTHERS THEN
444: wf_core.context( 'AHLGAPP'

Line 495: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfApproved Fyi');

491:
492: BEGIN
493: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
495: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfApproved Fyi');
496: END IF;
497:
498: document_type := 'text/plain';
499:

Line 568: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approved_FYI',

564: p_msg_data => l_msg_data ,
565: p_attr_name => 'ERROR_MSG',
566: x_error_msg => l_error_msg
567: ) ;
568: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approved_FYI',
569: l_item_type,l_item_key,l_error_msg);
570: RAISE;
571: WHEN OTHERS THEN
572: wf_core.context( 'AHLGAPP'

Line 644: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','NtfyFinalApprovalFyi');

640: BEGIN
641:
642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
643: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
644: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','NtfyFinalApprovalFyi');
645: END IF;
646:
647:
648: document_type := 'text/plain';

Line 652: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Notify Final approval;');

648: document_type := 'text/plain';
649:
650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
652: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Notify Final approval;');
653: END IF;
654: -- parse document_id for the ':' dividing item type name from item key value
655: -- document_id value will take the form : starting with
656: -- release 2.5 version of this demo

Line 720: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Final_Approval_FYI',

716: p_msg_data => l_msg_data ,
717: p_attr_name => 'ERROR_MSG',
718: x_error_msg => l_error_msg
719: ) ;
720: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Final_Approval_FYI',
721: l_item_type,l_item_key,l_error_msg);
722: RAISE;
723: WHEN OTHERS THEN
724: wf_core.context( 'AHLGAPP'

Line 793: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start NtfyRejectedFYi');

789:
790: BEGIN
791: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
792: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
793: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start NtfyRejectedFYi');
794: END IF;
795:
796:
797: document_type := 'text/plain';

Line 868: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Rejected_FYI',

864: p_msg_data => l_msg_data ,
865: p_attr_name => 'ERROR_MSG',
866: x_error_msg => l_error_msg
867: ) ;
868: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Rejected_FYI',
869: l_item_type,l_item_key,l_error_msg);
870: RAISE;
871:
872: WHEN OTHERS THEN

Line 945: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfyApproval');

941:
942: BEGIN
943: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
945: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfyApproval');
946: END IF;
947:
948: document_type := 'text/plain';
949:

Line 1024: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approval',

1020: p_msg_data => l_msg_data ,
1021: p_attr_name => 'ERROR_MSG',
1022: x_error_msg => l_error_msg
1023: ) ;
1024: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approval',
1025: l_item_type,l_item_key,l_error_msg);
1026: RAISE;
1027: WHEN OTHERS THEN
1028: wf_core.context( 'AHLGAPP'

Line 1098: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfyApprovalRemainder');

1094:
1095: BEGIN
1096: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1098: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Start NtfyApprovalRemainder');
1099: END IF;
1100:
1101:
1102: document_type := 'text/plain';

Line 1180: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approval_Reminder',

1176: p_msg_data => l_msg_data ,
1177: p_attr_name => 'ERROR_MSG',
1178: x_error_msg => l_error_msg
1179: ) ;
1180: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Approval_Reminder',
1181: l_item_type,l_item_key,l_error_msg);
1182: RAISE;
1183: WHEN OTHERS THEN
1184: wf_core.context( 'AHLGAPP'

Line 1255: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'NtfyErrorAct');

1251:
1252: BEGIN
1253: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1255: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'NtfyErrorAct');
1256: END IF;
1257:
1258:
1259: document_type := 'text/plain';

Line 1329: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Error_Act',

1325: p_msg_data => l_msg_data ,
1326: p_attr_name => 'ERROR_MSG',
1327: x_error_msg => l_error_msg
1328: ) ;
1329: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Error_Act',
1330: l_item_type,l_item_key,l_error_msg);
1331: RAISE;
1332: WHEN OTHERS THEN
1333: wf_core.context( 'AHL_ITEMCOMP_APPROVAL_PVT'

Line 1333: wf_core.context( 'AHL_ITEMCOMP_APPROVAL_PVT'

1329: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','Ntf_Error_Act',
1330: l_item_type,l_item_key,l_error_msg);
1331: RAISE;
1332: WHEN OTHERS THEN
1333: wf_core.context( 'AHL_ITEMCOMP_APPROVAL_PVT'
1334: , 'Ntf_Error_Act'
1335: , l_item_type
1336: , l_item_key
1337: );

Line 1401: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');

1397:
1398: BEGIN
1399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1401: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
1402: END IF;
1403:
1404: IF funcmode = 'RUN' THEN
1405: l_approval_status := wf_engine.getitemattrtext(

Line 1412: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');

1408: ,aname => 'UPDATE_GEN_STATUS'
1409: );
1410: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1412: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
1413: END IF;
1414:
1415: IF l_approval_status = 'APPROVED' THEN
1416: l_next_status := wf_engine.getitemattrText(

Line 1445: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));

1441: l_status_date := SYSDATE;
1442:
1443: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1445: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1446: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1447: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));

Line 1447: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);

1443: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1445: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1446: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1447: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);

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

1445: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_object_id:'||to_char(l_object_id));
1446: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1447: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);
1452: END IF;
1453:

Line 1451: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);

1447: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','l_approvalStatus:'||l_approval_status);
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Object version id check :'||to_char(l_object_id));
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1451: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'l_approval_status:'||l_approval_status);
1452: END IF;
1453:
1454: OPEN GetItemCompDet(l_object_id);
1455: FETCH GetItemCompDet into l_item_comp_rec;

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

1473: );
1474:
1475: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1477: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','After Complete Item Group Revision:L_ApprovalStatus'||l_approval_status);
1478: END IF;
1479:
1480: if (sql%notfound)
1481: then

Line 1518: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);

1514: EXCEPTION
1515: WHEN fnd_api.g_exc_error THEN
1516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1518: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details','Error G_exec UpdateSatus:'||sqlerrm);
1519: END IF;
1520: FND_MSG_PUB.Count_And_Get (
1521: p_encoded => FND_API.G_FALSE,
1522: p_count => l_msg_count,

Line 1540: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);

1536:
1537: WHEN OTHERS THEN
1538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1540: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'UpdateStatus Whenothers Err:'||sqlerrm);
1541:
1542: END IF;
1543:
1544: wf_core.context(

Line 1545: 'AHL_ITEMCOMP_APPROVAL_PVT'

1541:
1542: END IF;
1543:
1544: wf_core.context(
1545: 'AHL_ITEMCOMP_APPROVAL_PVT'
1546: ,'Update_Status'
1547: ,itemtype
1548: ,itemkey
1549: ,actid

Line 1613: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start RevertStatus');

1609:
1610: BEGIN
1611: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1613: 'AHL_ITEMCOMP_APPROVAL_PVT.Set_Activity_Details', 'Start RevertStatus');
1614: END IF;
1615:
1616: l_return_Status:='S';
1617: IF funcmode = 'RUN' THEN

Line 1696: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','revert_status',

1692: p_msg_data => l_msg_data ,
1693: p_attr_name => 'ERROR_MSG',
1694: x_error_msg => l_error_msg
1695: ) ;
1696: wf_core.context('AHL_ITEMCOMP_APPROVAL_PVT','revert_status',
1697: itemtype,itemkey,actid,funcmode,l_error_msg);
1698: RAISE;
1699: WHEN OTHERS THEN
1700: wf_core.context(

Line 1701: 'AHL_ITEMCOMP_APPROVAL_PVT'

1697: itemtype,itemkey,actid,funcmode,l_error_msg);
1698: RAISE;
1699: WHEN OTHERS THEN
1700: wf_core.context(
1701: 'AHL_ITEMCOMP_APPROVAL_PVT'
1702: ,'REVERT_STATUS'
1703: ,itemtype
1704: ,itemkey
1705: ,actid

Line 1713: END AHL_ITEMCOMP_APPROVAL_PVT;

1709: RAISE;
1710:
1711: END Revert_Status;
1712:
1713: END AHL_ITEMCOMP_APPROVAL_PVT;