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 FND_LOG

Line 74: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

70:
71:
72: BEGIN
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;

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

72: BEGIN
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:

Line 140: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

136:
137: END IF;
138: CLOSE GetItemCompDet;
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,

Line 142: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

138: CLOSE GetItemCompDet;
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:

Line 144: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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;
148:

Line 199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

195: ,itemkey => itemkey
196: ,aname => 'ERROR_SUBJECT'
197: ,avalue => l_error_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;

Line 201: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

197: ,avalue => l_error_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:

Line 210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

206: -----------------------------------------------------------------------------------
207: -- Get Approval Rule and First Approver Sequence
208: -----------------------------------------------------------------------------------
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,

Line 212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

208: -----------------------------------------------------------------------------------
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,

Line 214: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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));
220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 218: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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));
222: END IF;

Line 220: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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(
224: p_object => l_object,

Line 233: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

229: x_return_status => l_return_status
230: );
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:

Line 234: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

230: );
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

Line 362: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

358:
359:
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:

Line 363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

359:
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.

Line 493: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

489: l_msg_data VARCHAR2(4000);
490: l_error_msg VARCHAR2(2000);
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:

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

490: l_error_msg VARCHAR2(2000);
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';

Line 642: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

638:
639:
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:

Line 643: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

639:
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:

Line 650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

646:
647:
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

Line 651: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

647:
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

Line 791: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

787: l_error_msg VARCHAR2(2000);
788:
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:

Line 792: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

788:
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:

Line 943: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

939: l_msg_data VARCHAR2(4000);
940: l_error_msg VARCHAR2(2000);
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:

Line 944: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

940: l_error_msg VARCHAR2(2000);
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';

Line 1096: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1092: l_msg_data VARCHAR2(4000);
1093: l_error_msg VARCHAR2(2000);
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:

Line 1097: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1093: l_error_msg VARCHAR2(2000);
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:

Line 1253: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1249: l_msg_data VARCHAR2(4000);
1250:
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:

Line 1254: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1250:
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:

Line 1399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1395: l_commit BOOLEAN :=false;
1396:
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:

Line 1400: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1396:
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

Line 1410: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1406: itemtype => itemtype
1407: ,itemkey => itemkey
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:

Line 1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1407: ,itemkey => itemkey
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

Line 1443: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1439: );
1440:
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);

Line 1444: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1440:
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,

Line 1446: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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));
1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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);
1452: END IF;

Line 1450: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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:
1454: OPEN GetItemCompDet(l_object_id);

Line 1475: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1471: P_ITEM_COMP_ID =>l_object_id,
1472: p_object_version_number =>l_object_version_number
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:

Line 1476: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1472: p_object_version_number =>l_object_version_number
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)

Line 1516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1512:
1513:
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 (

Line 1517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1513:
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,

Line 1538: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1534: itemtype,itemkey,actid,funcmode,l_error_msg);
1535: RAISE;
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;

Line 1539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1535: RAISE;
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:

Line 1611: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1607:
1608: l_item_comp_rec GetItemCompDet%ROWTYPE;
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:

Line 1612: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1608: l_item_comp_rec GetItemCompDet%ROWTYPE;
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';