DBA Data[Home] [Help]

APPS.GCS_ADJ_APPROVAL_WF_PKG dependencies on FND_LOG

Line 6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2: /* $Header: gcsameintgb.pls 120.0 2007/11/21 18:09:37 hakumar ship $ */
3: --------------------------------------------------------------
4: -- Global Variables --
5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'GCS_INTG_APPROVALS_PKG.';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:

Line 7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

3: --------------------------------------------------------------
4: -- Global Variables --
5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'GCS_INTG_APPROVALS_PKG.';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11:

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: --------------------------------------------------------------
6: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
8: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'GCS_INTG_APPROVALS_PKG.';
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10:
11:
12: --------------------------------------------------------------------------------
13: -- PRIVATE CONSTANTS

Line 120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

116: l_user_name := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'USER_NAME');
117:
118: l_debug_info := 'Before Calling get Role Info ' || p_item_key ;
119: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
120: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
121: l_api_name,l_debug_info);
122: END IF;
123:
124: WF_DIRECTORY.GetRoleOrigSysInfo(

Line 152: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

148:
149: l_debug_info := 'Before calling Update GCS Entry Headers, item_key: ' || p_item_key || 'Submitter Name '|| l_submitter_name;
150:
151: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
152: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
153: l_api_name,l_debug_info);
154: END IF;
155:
156: --- By default adjustment is approved, and later if there are

Line 175: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

171:
172: l_debug_info := 'Generate PDF request ID ' || to_char(l_request_id) ;
173:
174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
176: l_api_name,l_debug_info);
177: END IF;
178:
179:

Line 273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

269:
270: BEGIN
271: l_debug_info := 'Start Adjustment Approval Workflow Process';
272: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
273: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
274: l_api_name,l_debug_info);
275: END IF;
276:
277:

Line 280: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

276:
277:
278: l_debug_info := 'Before ame_api2.clearAllApprovals';
279: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
281: l_api_name,l_debug_info);
282: END IF;
283:
284: ame_api2.clearAllApprovals( applicationidin => G_FCH_APPLICATION_ID,

Line 292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

288:
289:
290: l_debug_info := 'Getting Attibutes values';
291: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
293: l_api_name,l_debug_info);
294: END IF;
295:
296:

Line 337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

333: wf_engine.AbortProcess('GCSADJ', l_itemkey, 'MASTER', null);
334:
335: l_debug_info := 'Previous WF Process aborted';
336: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
338: l_api_name,l_debug_info);
339: END IF;
340:
341:

Line 346: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

342: EXCEPTION
343: WHEN OTHERS THEN
344: l_debug_info := 'Previous WF Process aborted error';
345: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
346: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
347: l_api_name,l_debug_info);
348: END IF;
349:
350: End;

Line 358: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

354: where pk1_value = to_char(l_entry_id);
355:
356: l_debug_info := ' Deleted Doc :'|| to_char(l_entry_id) || '.pdf';
357: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
359: l_api_name,l_debug_info);
360: END IF;
361:
362:

Line 371: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

367:
368:
369: l_debug_info := 'Calling WF_ENGINE.createProcess(GCSADJ, ' || l_itemkey || ', MASTER);';
370: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
371: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
372: l_api_name,l_debug_info);
373: END IF;
374:
375:

Line 380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

376: wf_engine.createProcess('GCSADJ', l_itemkey, 'MASTER');
377:
378: l_debug_info := 'Before Update of Adjustments to Initiated';
379: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
381: l_api_name,l_debug_info);
382: END IF;
383:
384: UPDATE GCS_ENTRY_HEADERS

Line 392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

388:
389:
390: l_debug_info := 'Before setting item attributes' ;
391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
392: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
393: l_api_name,l_debug_info);
394: END IF;
395:
396: l_calling_sequence := l_api_name;

Line 509: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

505:
506: l_debug_info := 'Before Calling WF_ENGINE.startProcess(GCSADJ,'
507: || l_itemkey || ');';
508: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
510: l_api_name,l_debug_info);
511: END IF;
512:
513: WF_ENGINE.startProcess('GCSADJ', l_itemkey);

Line 522: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

518: p_wfitemkey := l_itemkey;
519: l_debug_info := 'End';
520:
521: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
522: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
523: l_api_name,l_debug_info);
524: END IF;
525:
526: EXCEPTION

Line 600: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

596: l_application_id := G_FCH_APPLICATION_ID;
597:
598: l_debug_info := 'Calling Get Next Approvers ' || p_item_key ;
599: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
601: l_api_name,l_debug_info);
602: END IF;
603:
604: l_entry_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

615: nextApproversOut => l_next_approvers );
616:
617: l_debug_info := 'Approval Process Status ' || l_complete;
618: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
619: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
620: END IF;
621:
622: -- IF l_complete = ame_util.booleanFalse THEN -- there is a status of complete no approvers
623:

Line 628: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

624: IF l_next_approvers.count < 1 THEN
625: -- No more approvers
626: l_debug_info := 'No more approvers ' || p_item_key ;
627: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
629: l_api_name,l_debug_info);
630: END IF;
631:
632: x_result_out := WF_ENGINE.eng_completed || ':' || G_NO;

Line 637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

633:
634: ELSE
635: l_debug_info := 'New Approver ';
636: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
637: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
638: END IF;
639:
640: l_next_approver := l_next_approvers(1);
641: g_next_approver := l_next_approver;

Line 647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

643:
644: IF l_valid_approver = FALSE Then
645: l_debug_info := 'Invalid approver, does not have wf role';
646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
648: END IF;
649:
650: end if;
651:

Line 656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

652: if (l_next_approver.approval_status = AME_UTIL.exceptionStatus) then
653: l_debug_info := 'Next approver exception error';
654:
655: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
657: END IF;
658:
659: end if;
660:

Line 679: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

675: l_debug_info := 'Approver found, item: ' || p_item_key || 'Role: ' || l_role_name || ' ID:' || to_char(l_approver_id) ||
676: ' Name: ' || l_approver_name;
677:
678: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
679: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
680: END IF;
681:
682: WF_ENGINE.SetItemAttrNumber(
683: p_item_type, p_item_key, 'APPROVER_ID', l_approver_id);

Line 704: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

700:
701: -- set the workflow history region
702: l_debug_info:='setting history region attribute information';
703: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
705: l_api_name,l_debug_info);
706: END IF;
707:
708: l_wf_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/per/ame/transactionhistory/webui/TransactionHistoryRN' || '&' || 'AMETxnID='|| TO_CHAR(l_entry_id) || '&' || 'AMETxnType=GCS_ADJUSTMENT'|| '&' || 'AMEFndAppID=266';

Line 712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

708: l_wf_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/per/ame/transactionhistory/webui/TransactionHistoryRN' || '&' || 'AMETxnID='|| TO_CHAR(l_entry_id) || '&' || 'AMETxnType=GCS_ADJUSTMENT'|| '&' || 'AMEFndAppID=266';
709:
710: l_debug_info:='setting attachment attribute information';
711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
713: l_api_name,l_debug_info);
714: END IF;
715:
716: l_attachment := 'FND:entity=GCS_ENTRY_HEADERS'||'&'||'pk1name=ENTRY_ID'||'&'||'pk1value='||l_entry_id;

Line 728: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

724: --ELSE
725: -- Process Complete
726: -- l_debug_info := 'Process Complete' || p_item_key ;
727: -- IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
728: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
729: -- l_api_name,l_debug_info);
730: -- END IF;
731: -- x_result_out := WF_ENGINE.eng_completed || ':' || G_NO;
732: -- END IF;

Line 768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

764: BEGIN
765:
766: l_debug_info := 'Start Process Approval';
767: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
768: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
769: l_api_name,l_debug_info);
770: END IF;
771:
772: l_calling_sequence := l_api_name;

Line 804: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

800:
801: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name: '|| l_role_name || 'Approver id: ' || l_approver_id ;
802:
803: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
805: END IF;
806:
807: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
808:

Line 810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

806:
807: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
808:
809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
811: END IF;
812:
813: g_next_approver.orig_system:= l_approver_orig_system;
814: g_next_approver.orig_system_id:=l_approver_id;

Line 838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

834: itemIdIn => to_char(l_entry_id));
835: */
836: l_debug_info := 'Updated Approval status in AME records';
837: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
839: END IF;
840:
841: WF_ENGINE.SetItemAttrText('GCSADJ',
842: p_item_key,

Line 848: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

844: null);
845:
846: l_debug_info := 'End';
847: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
849: END IF;
850: x_result_out := wf_engine.eng_completed||':'|| AME_UTIL.approvedStatus;
851:
852: EXCEPTION

Line 882: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

878: BEGIN
879:
880: l_debug_info := 'Start Process Rejected';
881: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
882: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
883: l_api_name,l_debug_info);
884: END IF;
885:
886: l_calling_sequence := l_api_name;

Line 916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

912:
913: l_debug_info := 'Before calling AME Update Status, entry : ' || l_entry_id || ', Status' || AME_UTIL.approvedStatus || ' role name '|| l_role_name || 'Approver id ' || l_approver_id ;
914:
915: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
917: END IF;
918:
919: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
920:

Line 922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

918:
919: l_debug_info := 'AME relevant info, itemclass: ' ||ame_util.headerItemClassName ||',item id ' || l_entry_id ;
920:
921: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
923: END IF;
924:
925: g_next_approver.orig_system:= l_approver_orig_system;
926: g_next_approver.orig_system_id:=l_approver_id;

Line 951: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

947: */
948:
949: l_debug_info := 'Updated Approval status ';
950: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
951: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
952: END IF;
953:
954: WF_ENGINE.SetItemAttrText('GCSADJ',
955: p_item_key,

Line 961: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

957: null);
958:
959: l_debug_info := 'End';
960: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
961: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
962: END IF;
963: x_result_out := wf_engine.eng_completed||':'||AME_UTIL.approvedStatus;
964:
965: EXCEPTION

Line 1005: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1001: BEGIN
1002:
1003: l_debug_info := 'Start Update Adjustment';
1004: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1005: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1006: l_api_name,l_debug_info);
1007: END IF;
1008:
1009: l_prev_calling_sequence := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'CALLING_SEQUENCE');

Line 1013: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||

1009: l_prev_calling_sequence := WF_ENGINE.GetItemAttrText(p_item_type, p_item_key, 'CALLING_SEQUENCE');
1010:
1011: l_debug_info := l_prev_calling_sequence;
1012: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1013: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||
1014: l_api_name,l_debug_info);
1015: END IF;
1016:
1017: l_calling_sequence := l_api_name;

Line 1042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1038: 'ROLE_NAME');
1039:
1040: l_debug_info := 'Before Updating GCS Entries, entry : ' || l_entry_id || ' calling sequence '|| l_prev_calling_sequence;
1041: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1042: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1043: END IF;
1044:
1045:
1046: if l_prev_calling_sequence = 'process_approval' then

Line 1067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);

1063:
1064: l_debug_info := 'Updated GCS Entries with status : ' || nvl(l_status,'NULL');
1065:
1066: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME|| l_api_name,l_debug_info);
1068: END IF;
1069:
1070:
1071: IF (l_prev_calling_sequence = 'process_approval' OR l_prev_calling_sequence = 'fch_check_approvals' ) THEN

Line 1075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1071: IF (l_prev_calling_sequence = 'process_approval' OR l_prev_calling_sequence = 'fch_check_approvals' ) THEN
1072:
1073: l_debug_info := 'Preparing Consolidation Impact Event: ' || l_event_name;
1074: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1076: END IF;
1077:
1078: l_orig_entry_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1079: p_item_key,

Line 1104: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1100:
1101: l_debug_info := ' Event Raised';
1102:
1103: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1104: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1105: END IF;
1106:
1107: l_writeback := WF_ENGINE.GetItemAttrText(p_item_type,
1108: p_item_key,

Line 1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

1136: argument5 => l_conversion_type );
1137:
1138: l_debug_info := ' Submitted Writeback request ID : ' || l_request_id;
1139: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1140: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1141: END IF;
1142:
1143: end if;
1144: end if;