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 FND_LOG

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

62:
63:
64: BEGIN
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;

Line 68: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

101: l_subject := fnd_message.get;
102: END IF;
103: CLOSE GetItemGroupDet;
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,

Line 107: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

103: CLOSE GetItemGroupDet;
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:

Line 109: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

160: ,itemkey => itemkey
161: ,aname => 'ERROR_SUBJECT'
162: ,avalue => 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;

Line 166: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

171: -----------------------------------------------------------------------------------
172: -- Get Approval Rule and First Approver Sequence
173: -----------------------------------------------------------------------------------
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,

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 185: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

194: x_return_status => l_return_status
195: );
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:

Line 199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

322:
323:
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:

Line 327: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 458: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

600:
601:
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:

Line 605: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

608:
609:
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

Line 613: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 752: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1056: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

1208: l_msg_data VARCHAR2(4000);
1209:
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:

Line 1213: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

1358: l_commit BOOLEAN :=false;
1359:
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:

Line 1363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

1369: itemtype => itemtype
1370: ,itemkey => itemkey
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:

Line 1374: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

1402: );
1403:
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);

Line 1407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 1409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 1411: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

Line 1413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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:
1417: OPEN GetItemGroupDet(l_object_id);

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

1448: p_appr_status =>l_approval_status,
1449: p_ItemGroups_id =>l_object_id,
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:

Line 1453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1449: p_ItemGroups_id =>l_object_id,
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)

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

1489:
1490:
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 (

Line 1494: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

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

Line 1516: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

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

1583:
1584: l_item_group_rec GetItemGroupDet%ROWTYPE;
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:

Line 1588: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1584: l_item_group_rec GetItemGroupDet%ROWTYPE;
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';