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.JTF_ESCWFACTIVITY_PVT dependencies on FND_LOG

Line 82: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

78:
79:
80: g_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
81:
82: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
83:
84: PROCEDURE debug(p_level NUMBER, p_module VARCHAR2, p_message VARCHAR2) IS
85: BEGIN
86: IF g_debug = 'Y' AND p_level >= g_debug_level THEN

Line 87: fnd_log.string(p_level, 'jtf.plsql.JTF_ESCWFACTIVITY_PVT.' || p_module, p_message);

83:
84: PROCEDURE debug(p_level NUMBER, p_module VARCHAR2, p_message VARCHAR2) IS
85: BEGIN
86: IF g_debug = 'Y' AND p_level >= g_debug_level THEN
87: fnd_log.string(p_level, 'jtf.plsql.JTF_ESCWFACTIVITY_PVT.' || p_module, p_message);
88: END IF;
89: END debug;
90:
91:

Line 161: debug( fnd_log.level_statement

157: l_process_name JTF_BRM_PROCESSES.WORKFLOW_PROCESS_NAME%TYPE;
158:
159: BEGIN
160:
161: debug( fnd_log.level_statement
162: , 'Get_WorkflowAttribute'
163: , 'input attr name'||p_attr_name|| 'return type'||p_return_type
164: );
165: OPEN c_get_rule(g_rule_id);

Line 173: debug( fnd_log.level_error, 'Get_WorkflowAttribute', 'There is no rule for the query'||g_rule_id);

169: THEN
170: -----------------------------------------------------------------------
171: -- Query Rule didn't find a record
172: -----------------------------------------------------------------------
173: debug( fnd_log.level_error, 'Get_WorkflowAttribute', 'There is no rule for the query'||g_rule_id);
174: CLOSE c_get_rule;
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177: CLOSE C_GET_RULE;

Line 194: debug( fnd_log.level_statement, 'Get_WorkflowAttribute', 'the attribute value is '||l_attr_value);

190: , p_wf_process_name => l_process_name
191: , p_wf_attribute_name => p_attr_name
192: );
193: END IF;
194: debug( fnd_log.level_statement, 'Get_WorkflowAttribute', 'the attribute value is '||l_attr_value);
195: RETURN(l_attr_value);
196:
197: EXCEPTION
198: WHEN OTHERS

Line 200: debug( fnd_log.level_unexpected, 'Get_WorkflowAttribute'

196:
197: EXCEPTION
198: WHEN OTHERS
199: THEN
200: debug( fnd_log.level_unexpected, 'Get_WorkflowAttribute'
201: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
202: );
203: RAISE;
204:

Line 254: debug( fnd_log.level_error, 'Get_EmployeeID', 'Employee details not found for the resource'||p_resource_id);

250: THEN
251: -----------------------------------------------------------------------
252: -- Query Resources didn't find a record
253: -----------------------------------------------------------------------
254: debug( fnd_log.level_error, 'Get_EmployeeID', 'Employee details not found for the resource'||p_resource_id);
255: CLOSE c_query_emp;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: CLOSE c_query_emp;

Line 259: debug( fnd_log.level_statement, 'Get_EmployeeID', 'Employee id for the resource'||p_resource_id||':'||l_person_id);

255: CLOSE c_query_emp;
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: CLOSE c_query_emp;
259: debug( fnd_log.level_statement, 'Get_EmployeeID', 'Employee id for the resource'||p_resource_id||':'||l_person_id);
260: RETURN(l_person_id);
261:
262: EXCEPTION
263: WHEN FND_API.G_EXC_ERROR

Line 266: debug( fnd_log.level_error, 'Get_EmployeeID'

262: EXCEPTION
263: WHEN FND_API.G_EXC_ERROR
264: THEN
265: x_resultout := FND_API.G_Ret_Sts_Error;
266: debug( fnd_log.level_error, 'Get_EmployeeID'
267: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
268: );
269: RETURN(NULL);
270: WHEN OTHERS

Line 273: debug( fnd_log.level_unexpected, 'Get_EmployeeID'

269: RETURN(NULL);
270: WHEN OTHERS
271: THEN
272: x_resultout := FND_API.G_Ret_Sts_Unexp_Error;
273: debug( fnd_log.level_unexpected, 'Get_EmployeeID'
274: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
275: );
276: RETURN(NULL);
277:

Line 326: debug( fnd_log.level_error, 'Get_EmployeeRole', 'No role found for the employee:'||p_employee_id);

322:
323: IF (l_wf_role IS NULL)
324: THEN
325: x_resultout := FND_API.G_RET_STS_ERROR;
326: debug( fnd_log.level_error, 'Get_EmployeeRole', 'No role found for the employee:'||p_employee_id);
327: END IF;
328: RETURN(l_wf_role);
329:
330: EXCEPTION

Line 334: debug( fnd_log.level_error, 'Get_EmployeeRole'

330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR
332: THEN
333: x_resultout := FND_API.G_Ret_Sts_Error;
334: debug( fnd_log.level_error, 'Get_EmployeeRole'
335: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
336: );
337: RETURN(NULL);
338: WHEN OTHERS

Line 341: debug( fnd_log.level_unexpected, 'Get_EmployeeRole'

337: RETURN(NULL);
338: WHEN OTHERS
339: THEN
340: x_resultout := FND_API.G_Ret_Sts_Unexp_Error;
341: debug( fnd_log.level_unexpected, 'Get_EmployeeRole'
342: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
343: );
344: RETURN(NULL);
345:

Line 397: debug( fnd_log.level_error, 'Get_RuleOwner', 'No resource found for the rule owner:'||g_rule_owner);

393: THEN
394: -------------------------------------------------------------------
395: -- Query Resources didn't find a record
396: -------------------------------------------------------------------
397: debug( fnd_log.level_error, 'Get_RuleOwner', 'No resource found for the rule owner:'||g_rule_owner);
398: CLOSE c_query_resource;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401: CLOSE c_query_resource;

Line 405: debug( fnd_log.level_statement, 'Get_RuleOwner', 'The returned rule owner is :'||l_owner_id);

401: CLOSE c_query_resource;
402: ELSE
403: l_owner_id := g_rule_owner;
404: END IF;
405: debug( fnd_log.level_statement, 'Get_RuleOwner', 'The returned rule owner is :'||l_owner_id);
406: RETURN(l_owner_id);
407:
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR

Line 488: debug( fnd_log.level_statement, l_api_name, 'Input ID type'||p_id_type);

484:
485: Begin
486: x_resultout := FND_API.G_Ret_Sts_Success;
487:
488: debug( fnd_log.level_statement, l_api_name, 'Input ID type'||p_id_type);
489:
490: -------------------------------------------------------------------------
491: -- Get the primary contact from the escalation territory
492: -------------------------------------------------------------------------

Line 507: debug( fnd_log.level_statement, l_api_name, 'business rule owner for'||l_resource_id);

503: THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: debug( fnd_log.level_statement, l_api_name, 'business rule owner for'||l_resource_id);
508:
509: l_contact_id := l_resource_id;
510:
511: x_res_type := jtf_ec_pub.g_escalation_owner_type_code;

Line 517: debug( fnd_log.level_statement, l_api_name, 'escalation territory exists for source doc');

513: -----------------------------------------------------------------------
514: -- Territory exists in the source document
515: -- Use primary contact in relevant escalation territory
516: -----------------------------------------------------------------------
517: debug( fnd_log.level_statement, l_api_name, 'escalation territory exists for source doc');
518:
519: JTF_TERRITORY_GET_PUB.Get_Escalation_Territory
520: ( p_api_version => 1.0
521: , p_init_msg_list => FND_API.G_TRUE

Line 531: debug( fnd_log.level_statement, l_api_name, 'Getting the members for territory'||l_esc_territory);

527: );
528:
529: IF (l_return_status = FND_API.G_Ret_Sts_Success)
530: THEN
531: debug( fnd_log.level_statement, l_api_name, 'Getting the members for territory'||l_esc_territory);
532: JTF_TERRITORY_GET_PUB.Get_Escalation_TerrMembers
533: ( 1.0
534: , p_terr_id => l_esc_territory
535: , p_init_msg_list => FND_API.G_TRUE

Line 541: debug( fnd_log.level_statement, l_api_name, 'retrieving members was:'||l_return_status);

537: , x_msg_count => l_msg_count
538: , x_msg_data => l_msg_data
539: , x_QualifyingRsc_out_tbl => l_terr_resource_table
540: );
541: debug( fnd_log.level_statement, l_api_name, 'retrieving members was:'||l_return_status);
542: IF (l_return_status = FND_API.G_Ret_Sts_Success)
543: THEN
544: l_index := l_terr_resource_table.First;
545: LOOP

Line 561: debug( fnd_log.level_error, l_api_name, 'employee id not found for'||l_resource_id);

557: l_contact_id := Get_EmployeeID( p_resource_id => l_resource_id
558: , x_resultout => l_resultout
559: );
560: IF (l_resultout <> FND_API.G_Ret_Sts_Success) Then
561: debug( fnd_log.level_error, l_api_name, 'employee id not found for'||l_resource_id);
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: ELSE
565: l_contact_id := l_resource_id;

Line 580: debug( fnd_log.level_statement, l_api_name, 'business rule owner for'||l_resource_id);

576: THEN
577: RAISE FND_API.G_EXC_ERROR;
578: END IF;
579:
580: debug( fnd_log.level_statement, l_api_name, 'business rule owner for'||l_resource_id);
581:
582: l_contact_id := l_resource_id;
583:
584: x_res_type := jtf_ec_pub.g_escalation_owner_type_code;

Line 590: debug( fnd_log.level_error, l_api_name, 'Getting the members for territory failed');

586: ELSE
587: -------------------------------------------------------------------
588: -- Error from Get_Escalation_TerrMembers API
589: -------------------------------------------------------------------
590: debug( fnd_log.level_error, l_api_name, 'Getting the members for territory failed');
591: RAISE FND_API.G_EXC_ERROR;
592: END IF;
593: ELSE
594: ---------------------------------------------------------------------

Line 597: debug( fnd_log.level_error, l_api_name, 'Getting the escalation territory failed');

593: ELSE
594: ---------------------------------------------------------------------
595: -- Error from Get_Escalation_Territory API
596: ---------------------------------------------------------------------
597: debug( fnd_log.level_error, l_api_name, 'Getting the escalation territory failed');
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600: END IF;
601: RETURN(l_contact_id);

Line 607: debug(fnd_log.LEVEL_statement, l_api_name, 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);

603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR
605: THEN
606: x_resultout := FND_API.G_Ret_Sts_Error;
607: debug(fnd_log.LEVEL_statement, l_api_name, 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);
608: RETURN(NULL);
609: WHEN OTHERS
610: THEN
611: x_resultout := FND_API.G_Ret_Sts_Unexp_Error;

Line 612: debug( fnd_log.level_unexpected, l_api_name , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);

608: RETURN(NULL);
609: WHEN OTHERS
610: THEN
611: x_resultout := FND_API.G_Ret_Sts_Unexp_Error;
612: debug( fnd_log.level_unexpected, l_api_name , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);
613: RETURN(NULL);
614:
615: END Get_EscTerrContact;
616:

Line 713: debug(fnd_log.level_statement, l_api_name,'input doc role'||p_document_role||' input id type'||p_id_type);

709: BEGIN
710: x_resultout := FND_API.G_Ret_Sts_Success;
711: x_res_type := jtf_ec_pub.g_escalation_owner_type_code;
712:
713: debug(fnd_log.level_statement, l_api_name,'input doc role'||p_document_role||' input id type'||p_id_type);
714:
715: IF (p_document_role = 'UNASSIGNED')
716: THEN
717: -----------------------------------------------------------------------

Line 731: debug(fnd_log.level_error, l_api_name, 'Retrieving Business Rule Owner Failed');

727: , x_resultout => l_resultout
728: );
729: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
730: THEN
731: debug(fnd_log.level_error, l_api_name, 'Retrieving Business Rule Owner Failed');
732: RAISE FND_API.G_EXC_ERROR;
733: END IF;
734: ELSIF ( (p_document_role = 'ESC_TERRITORY_PRIMARY')
735: OR ( (g_owner_id Is Null) AND g_owner_group_id IS NULL)

Line 748: debug(fnd_log.level_error, l_api_name, 'Retrieving Escalation Primary Contact Failed for esc_terr_primary');

744: , x_resultout => l_resultout
745: );
746: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
747: THEN
748: debug(fnd_log.level_error, l_api_name, 'Retrieving Escalation Primary Contact Failed for esc_terr_primary');
749: RAISE FND_API.G_EXC_ERROR;
750: END IF;
751: ELSIF (p_document_role = 'DOCUMENT_OWNER')
752: THEN

Line 764: debug(fnd_log.level_error, l_api_name, 'Retrieving Escalation Primary Contact Failed for document_owner');

760: , x_resultout => l_resultout
761: );
762: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
763: THEN
764: debug(fnd_log.level_error, l_api_name, 'Retrieving Escalation Primary Contact Failed for document_owner');
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: Elsif g_res_type_code = 'RS_EMPLOYEE' Then
768: ---------------------------------------------------------------------

Line 781: debug(fnd_log.level_error, l_api_name ,'Retrieving DocumentOwner for Employee Resource failed for:'||l_person_id);

777: IF (l_resultout = FND_API.G_Ret_Sts_Success)
778: THEN
779: l_person_id := l_source_id;
780: ELSE
781: debug(fnd_log.level_error, l_api_name ,'Retrieving DocumentOwner for Employee Resource failed for:'||l_person_id);
782: RAISE FND_API.G_EXC_ERROR;
783: END IF;
784: END IF;
785: Else

Line 797: debug(fnd_log.level_statement, l_api_name, 'group res for:'||g_owner_id||' is:'||l_resource_id);

793:
794: IF (c_query_group%FOUND)
795: THEN
796: CLOSE c_query_group;
797: debug(fnd_log.level_statement, l_api_name, 'group res for:'||g_owner_id||' is:'||l_resource_id);
798: If p_id_type = 'EMPLOYEE' Then
799: l_source_id := Get_EmployeeID( p_resource_id => l_resource_id
800: , x_resultout => l_resultout
801: );

Line 803: debug(fnd_log.level_statement, l_api_name, 'employee id found:'||l_source_id);

799: l_source_id := Get_EmployeeID( p_resource_id => l_resource_id
800: , x_resultout => l_resultout
801: );
802: IF (l_resultout = FND_API.G_Ret_Sts_Success) Then
803: debug(fnd_log.level_statement, l_api_name, 'employee id found:'||l_source_id);
804: l_person_id := l_source_id;
805: ELSE
806: debug(fnd_log.level_error, l_api_name, 'Retrieving Employee ID for Manager failed');
807: RAISE FND_API.G_EXC_ERROR;

Line 806: debug(fnd_log.level_error, l_api_name, 'Retrieving Employee ID for Manager failed');

802: IF (l_resultout = FND_API.G_Ret_Sts_Success) Then
803: debug(fnd_log.level_statement, l_api_name, 'employee id found:'||l_source_id);
804: l_person_id := l_source_id;
805: ELSE
806: debug(fnd_log.level_error, l_api_name, 'Retrieving Employee ID for Manager failed');
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: Else
810: l_person_id := l_resource_id;

Line 827: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for group resource');

823: , x_resultout => l_resultout
824: );
825: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
826: THEN
827: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for group resource');
828: --
829: -- simply assign it to the group
830: --
831: x_res_type := g_owner_group_type;

Line 850: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for DOCUMENT_OWNER_MGR');

846: , x_resultout => l_resultout
847: );
848: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
849: THEN
850: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for DOCUMENT_OWNER_MGR');
851: RAISE FND_API.G_EXC_ERROR;
852: END IF;
853: Elsif g_res_type_code = 'RS_EMPLOYEE' Then
854: ---------------------------------------------------------------------

Line 865: debug(fnd_log.level_error, l_api_name, 'Query for HR manager failed for owner'||g_owner_id);

861: -------------------------------------------------------------------
862: -- Query HR Manager didn't find a record
863: -------------------------------------------------------------------
864: CLOSE c_query_hr_manager;
865: debug(fnd_log.level_error, l_api_name, 'Query for HR manager failed for owner'||g_owner_id);
866: RAISE FND_API.G_EXC_ERROR;
867: END IF;
868: CLOSE c_query_hr_manager;
869: IF (p_id_type = 'RESOURCE')

Line 889: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for id type'||p_id_type);

885: , x_resultout => l_resultout
886: );
887: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
888: THEN
889: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for id type'||p_id_type);
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892: ELSE
893: l_person_id := l_resource_id;

Line 917: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for group resource');

913: , x_resultout => l_resultout
914: );
915: IF (l_resultout <> FND_API.G_Ret_Sts_Success)
916: THEN
917: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for group resource');
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: Else
921: debug(fnd_log.level_statement, l_api_name, 'Employee ID found is:'||l_resource_id);

Line 921: debug(fnd_log.level_statement, l_api_name, 'Employee ID found is:'||l_resource_id);

917: debug(fnd_log.level_error, l_api_name, 'Escaltion Primary Contact failed for group resource');
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: Else
921: debug(fnd_log.level_statement, l_api_name, 'Employee ID found is:'||l_resource_id);
922: l_person_id := l_resource_id;
923: CLOSE c_query_group;
924: End If;
925: End If;

Line 927: debug(fnd_log.level_error, l_api_name, 'Unhandled Document Owner Role');

923: CLOSE c_query_group;
924: End If;
925: End If;
926: ELSE
927: debug(fnd_log.level_error, l_api_name, 'Unhandled Document Owner Role');
928: -----------------------------------------------------------------------
929: -- Unhandled value for p_document_role
930: -----------------------------------------------------------------------
931:

Line 934: debug(fnd_log.level_statement, l_api_name, 'Returning the person id: '||l_person_id);

930: -----------------------------------------------------------------------
931:
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: debug(fnd_log.level_statement, l_api_name, 'Returning the person id: '||l_person_id);
935: RETURN(l_person_id);
936:
937: EXCEPTION
938: WHEN FND_API.G_EXC_ERROR

Line 944: debug( fnd_log.level_unexpected, l_api_name, 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);

940: x_resultout := FND_API.G_Ret_Sts_Error;
941: RETURN(NULL);
942: WHEN OTHERS
943: THEN
944: debug( fnd_log.level_unexpected, l_api_name, 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM);
945: x_resultout := FND_API.G_Ret_Sts_Unexp_Error;
946: RETURN(NULL);
947:
948: END Get_PersonID;

Line 1054: debug( fnd_log.level_statement

1050: , itemkey => itemkey
1051: , aname => 'RULE_ID'
1052: );
1053:
1054: debug( fnd_log.level_statement
1055: , 'Set_Globals'
1056: , 'Objectid is: '||g_object_id||' Object type: '||g_object_type||' Rule Id:'||g_rule_id
1057: );
1058: -------------------------------------------------------------------------

Line 1087: debug( fnd_log.level_error,'Set_Globals', 'Defect Details Not Found Using:'||g_object_id);

1083: THEN
1084: ---------------------------------------------------------------------
1085: -- Query of Defect details didn't find a record
1086: ---------------------------------------------------------------------
1087: debug( fnd_log.level_error,'Set_Globals', 'Defect Details Not Found Using:'||g_object_id);
1088: CLOSE c_object;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: CLOSE c_object;

Line 1131: debug( fnd_log.level_error

1127: THEN
1128: ---------------------------------------------------------------------
1129: -- Query of Service Request details didn't find a record
1130: ---------------------------------------------------------------------
1131: debug( fnd_log.level_error
1132: , 'Set_Globals'
1133: , 'Service Request Details Not Found Using:'||g_object_id);
1134:
1135: CLOSE c_object;

Line 1165: debug( fnd_log.level_statement,'Set_Globals','Task Details Found');

1161: IF ( (l_return_status = FND_API.G_Ret_Sts_Success)
1162: AND (l_returned > 0)
1163: )
1164: THEN
1165: debug( fnd_log.level_statement,'Set_Globals','Task Details Found');
1166: g_owner_id := l_task_table(1).owner_id;
1167: g_territory := l_task_table(1).owner_territory_id;
1168: g_res_type_code := l_task_table(1).owner_type_code;
1169: --Added by MPADHIAR for Bug#5068840

Line 1179: debug(fnd_log.level_error,'Set_Globals','Task Details Not Found Using:'||g_object_id);

1175: ELSE
1176: ---------------------------------------------------------------------
1177: -- Query API returned an error
1178: ---------------------------------------------------------------------
1179: debug(fnd_log.level_error,'Set_Globals','Task Details Not Found Using:'||g_object_id);
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182: ELSE
1183: -----------------------------------------------------------------------

Line 1186: debug(fnd_log.level_statement,'Set_Globals','Invalid Object Type'||g_object_type);

1182: ELSE
1183: -----------------------------------------------------------------------
1184: -- It's an invalid object type
1185: -----------------------------------------------------------------------
1186: debug(fnd_log.level_statement,'Set_Globals','Invalid Object Type'||g_object_type);
1187: RAISE FND_API.G_EXC_ERROR;
1188: END IF;
1189: -------------------------------------------------------------------------
1190: -- Get the object name from AK

Line 1199: debug(fnd_log.level_error,'Set_Globals','Object Name from AK not found for:'||g_object_type);

1195: THEN
1196: -----------------------------------------------------------------------
1197: -- Query AK_OBJECTS didn't find a record
1198: -----------------------------------------------------------------------
1199: debug(fnd_log.level_error,'Set_Globals','Object Name from AK not found for:'||g_object_type);
1200: CLOSE c_query_ak;
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203: CLOSE c_query_ak;

Line 1216: debug(fnd_log.level_error,'Set_Globals','Rule details not found for rule ID:'||g_rule_id);

1212: THEN
1213: -----------------------------------------------------------------------
1214: -- Query rule didn't find a record
1215: -----------------------------------------------------------------------
1216: debug(fnd_log.level_error,'Set_Globals','Rule details not found for rule ID:'||g_rule_id);
1217: CLOSE c_query_rule;
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220: CLOSE c_query_rule;

Line 1239: debug(fnd_log.level_error,'Set_Globals', 'Details from JTF_OBJECTS not found for:'||g_object_type_code);

1235: THEN
1236: -----------------------------------------------------------------------
1237: -- Query jtf_objects didn't find a record
1238: -----------------------------------------------------------------------
1239: debug(fnd_log.level_error,'Set_Globals', 'Details from JTF_OBJECTS not found for:'||g_object_type_code);
1240: CLOSE c_obj_details;
1241: RAISE FND_API.G_EXC_ERROR;
1242: END IF;
1243: CLOSE c_obj_details;

Line 1257: debug(fnd_log.level_error,'Set_Globals','Object Details not found for object name:'||g_jtf_object_name);

1253: THEN
1254: -----------------------------------------------------------------------
1255: -- Query of object details didn't find a record
1256: -----------------------------------------------------------------------
1257: debug(fnd_log.level_error,'Set_Globals','Object Details not found for object name:'||g_jtf_object_name);
1258: CLOSE c_object;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: CLOSE c_object;

Line 1263: debug( fnd_log.level_statement

1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: CLOSE c_object;
1262:
1263: debug( fnd_log.level_statement
1264: , 'Set_Globals'
1265: , 'g_object_name: ' || g_object_name
1266: || ' g_jtf_object_name: ' || g_jtf_object_name
1267: || ' g_object_type_code:' || g_object_type_code

Line 1313: debug( fnd_log.level_unexpected, 'Set_Globals'

1309: resultout := FND_API.G_Ret_Sts_Error;
1310:
1311: WHEN OTHERS
1312: THEN
1313: debug( fnd_log.level_unexpected, 'Set_Globals'
1314: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
1315: );
1316:
1317: resultout := FND_API.G_Ret_Sts_Unexp_Error;

Line 1432: debug(fnd_log.level_statement,l_api_name, 'template name is: '||l_template_name);

1428: ( p_attr_name => 'CS_ESC_TASK_TEMPLATE_SR'
1429: , p_return_type => 'VALUE'
1430: );
1431: END IF;
1432: debug(fnd_log.level_statement,l_api_name, 'template name is: '||l_template_name);
1433: IF (l_template_name IS NOT NULL)
1434: THEN
1435: -------------------------------------------------------------------
1436: -- Get task owner's role from the Workflow attribute

Line 1457: debug(fnd_log.level_statement, l_api_name,'task owner role is: '||l_owner_role);

1453: ( p_attr_name => 'CS_ESC_NOTIF_TASK_OWNER_ROLE'
1454: , p_return_type => 'CODE'
1455: );
1456: END IF;
1457: debug(fnd_log.level_statement, l_api_name,'task owner role is: '||l_owner_role);
1458: -------------------------------------------------------------------
1459: -- Get ID of person who is to own the task
1460: -------------------------------------------------------------------
1461: l_owner_id := Get_PersonID( p_document_role => l_owner_role

Line 1483: debug(fnd_log.level_statement, l_api_name,'template id: '||l_template_id);

1479: then
1480: close c_Get_Template_id;
1481: end if;
1482:
1483: debug(fnd_log.level_statement, l_api_name,'template id: '||l_template_id);
1484:
1485: -----------------------------------------------------------------
1486: -- Create the notification task
1487: -----------------------------------------------------------------

Line 1507: debug(fnd_log.level_statement, l_api_name,'Notification Task creation was : '||l_return_status);

1503: , x_msg_count => l_msg_count
1504: , x_msg_data => l_msg_data
1505: , x_task_details_tbl => l_task_details_table
1506: );
1507: debug(fnd_log.level_statement, l_api_name,'Notification Task creation was : '||l_return_status);
1508: IF (l_return_status = FND_API.G_Ret_Sts_Success)
1509: THEN
1510: l_notif_task_id := l_task_details_table(1).task_id;
1511: ---------------------------------------------------------------

Line 1536: debug(fnd_log.level_statement, l_api_name,'Notification Task created with task id:'|| l_notif_task_id);

1532: THEN
1533: -------------------------------------------------------------
1534: -- Update the notification task with name and description
1535: -------------------------------------------------------------
1536: debug(fnd_log.level_statement, l_api_name,'Notification Task created with task id:'|| l_notif_task_id);
1537: JTF_TASKS_PUB.Update_Task( p_api_version => 1.0
1538: , p_init_msg_list => FND_API.G_True
1539: , p_object_version_number => l_obj_version
1540: , p_task_id => l_notif_task_id

Line 1547: debug(fnd_log.level_statement, l_api_name,'Updation of the notification task completes with : '||l_return_status);

1543: , x_return_status => l_return_status
1544: , x_msg_count => l_msg_count
1545: , x_msg_data => l_msg_data
1546: );
1547: debug(fnd_log.level_statement, l_api_name,'Updation of the notification task completes with : '||l_return_status);
1548:
1549: IF (l_return_status = FND_API.G_Ret_Sts_Success)
1550: THEN
1551: -----------------------------------------------------------

Line 1568: debug(fnd_log.level_statement, l_api_name, 'Reference creation completes with : '||l_return_status);

1564: , x_msg_count => l_msg_count
1565: , x_msg_data => l_msg_data
1566: , x_task_reference_id => l_task_reference_id
1567: );
1568: debug(fnd_log.level_statement, l_api_name, 'Reference creation completes with : '||l_return_status);
1569: IF (l_return_status = FND_API.G_Ret_Sts_Success)
1570: THEN
1571: ---------------------------------------------------------
1572: -- Get task assignee's role from the Workflow attribute

Line 1593: debug(fnd_log.level_statement, l_api_name, 'Assignee Role to whom task will be assigned : '||l_assign_role);

1589: ( p_attr_name => 'CS_ESC_NOTIF_TASK_ASSIGN_ROLE'
1590: , p_return_type => 'CODE'
1591: );
1592: END IF;
1593: debug(fnd_log.level_statement, l_api_name, 'Assignee Role to whom task will be assigned : '||l_assign_role);
1594: ---------------------------------------------------------
1595: -- Get ID of person who is to be assigned the task
1596: ---------------------------------------------------------
1597: l_assign_id := Get_PersonID

Line 1625: debug(fnd_log.level_statement, l_api_name, 'Assignment creation completes with : '||l_return_status);

1621: , x_msg_count => l_msg_count
1622: , x_msg_data => l_msg_data
1623: , x_task_assignment_id => l_task_assign_id
1624: );
1625: debug(fnd_log.level_statement, l_api_name, 'Assignment creation completes with : '||l_return_status);
1626: IF (l_return_status <> FND_API.G_Ret_Sts_Success)
1627: THEN
1628: ---------------------------------------------------
1629: -- Create_Task_Assignment API failed

Line 1640: debug(fnd_log.level_statement, l_api_name, 'Getting Person ID failed');

1636: END IF;
1637: END IF;
1638: END IF;
1639: ELSE
1640: debug(fnd_log.level_statement, l_api_name, 'Getting Person ID failed');
1641: -------------------------------------------------------
1642: -- Get_PersonID (assign_id) failed
1643: -------------------------------------------------------
1644: IF (l_resultout = FND_API.G_Ret_Sts_Error)

Line 1655: debug(fnd_log.level_statement, l_api_name,'Creating Reference failed');

1651: ELSE
1652: ---------------------------------------------------------
1653: -- Create_References API failed
1654: ---------------------------------------------------------
1655: debug(fnd_log.level_statement, l_api_name,'Creating Reference failed');
1656: IF (l_return_status = FND_API.G_Ret_Sts_Error)
1657: THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSE

Line 1667: debug(fnd_log.level_statement, l_api_name,'Update Task failed');

1663: ELSE
1664: -----------------------------------------------------------
1665: -- Update_Task API failed
1666: -----------------------------------------------------------
1667: debug(fnd_log.level_statement, l_api_name,'Update Task failed');
1668: IF (l_return_status = FND_API.G_Ret_Sts_Error)
1669: THEN
1670: RAISE FND_API.G_EXC_ERROR;
1671: ELSE

Line 1679: debug(fnd_log.level_statement, l_api_name,'Query Task failed');

1675: ELSE
1676: -------------------------------------------------------------
1677: -- Query_Task API failed
1678: -------------------------------------------------------------
1679: debug(fnd_log.level_statement, l_api_name,'Query Task failed');
1680: IF (l_return_status = FND_API.G_Ret_Sts_Error)
1681: THEN
1682: RAISE FND_API.G_EXC_ERROR;
1683: ELSE

Line 1688: debug(fnd_log.level_error, l_api_name,'Creating Task From Template failed');

1684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1685: END IF;
1686: END IF;
1687: ELSE
1688: debug(fnd_log.level_error, l_api_name,'Creating Task From Template failed');
1689: ---------------------------------------------------------------
1690: -- Create_Task_From_Template API failed
1691: ---------------------------------------------------------------
1692: IF (l_return_status = FND_API.G_Ret_Sts_Error)

Line 1703: debug(fnd_log.level_error, l_api_name,'Getting Person ID failed');

1699: ELSE
1700: -----------------------------------------------------------------
1701: -- Get_PersonID (owner_id) failed
1702: -----------------------------------------------------------------
1703: debug(fnd_log.level_error, l_api_name,'Getting Person ID failed');
1704: IF (l_resultout = FND_API.G_Ret_Sts_Error)
1705: THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: ELSE

Line 1715: debug(fnd_log.level_error, l_api_name,'invalid profile value for JTF_ESC_TASK_TEMPLATE_NAME');

1711: ELSE
1712: -------------------------------------------------------------------
1713: -- Invalid profile value for JTF_ESC_TASK_TEMPLATE_NAME
1714: -------------------------------------------------------------------
1715: debug(fnd_log.level_error, l_api_name,'invalid profile value for JTF_ESC_TASK_TEMPLATE_NAME');
1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718: ---------------------------------------------------------------------
1719: -- If we get here then it's all been successful - return 'COMPLETE'

Line 1738: debug(fnd_log.level_error, l_api_name,'unknown function from Workflow');

1734: ELSE
1735: ---------------------------------------------------------------------
1736: -- Unknown function from WF - raise error
1737: ---------------------------------------------------------------------
1738: debug(fnd_log.level_error, l_api_name,'unknown function from Workflow');
1739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1740: END IF;
1741: ELSE
1742: -----------------------------------------------------------------------

Line 1745: debug(fnd_log.level_error, l_api_name,'set_globals failed with error:'||resultout);

1741: ELSE
1742: -----------------------------------------------------------------------
1743: -- Set_Globals failed
1744: -----------------------------------------------------------------------
1745: debug(fnd_log.level_error, l_api_name,'set_globals failed with error:'||resultout);
1746: IF (resultout = FND_API.G_Ret_Sts_Error)
1747: THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: ELSE

Line 1753: debug(fnd_log.level_statement, l_api_name, 'Result Out is '||resultout);

1749: ELSE
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: END IF;
1752: END IF;
1753: debug(fnd_log.level_statement, l_api_name, 'Result Out is '||resultout);
1754:
1755: EXCEPTION
1756: WHEN FND_API.G_EXC_ERROR
1757: THEN

Line 1759: debug(fnd_log.level_error, l_api_name, ' The error:' || Get_Messages_On_Stack());

1755: EXCEPTION
1756: WHEN FND_API.G_EXC_ERROR
1757: THEN
1758: resultout := 'COMPLETE:' || g_noncritical;
1759: debug(fnd_log.level_error, l_api_name, ' The error:' || Get_Messages_On_Stack());
1760: WF_CORE.Context( pkg_name => g_pkg_name
1761: , proc_name => 'Create_NotifTask'
1762: , arg1 => itemtype
1763: , arg2 => itemkey

Line 1771: debug(fnd_log.level_unexpected, l_api_name, ' The error:' || Get_Messages_On_Stack());

1767: RAISE;
1768: WHEN OTHERS
1769: THEN
1770: resultout := 'COMPLETE:' || g_critical;
1771: debug(fnd_log.level_unexpected, l_api_name, ' The error:' || Get_Messages_On_Stack());
1772: WF_CORE.Context( pkg_name => g_pkg_name
1773: , proc_name => 'Create_NotifTask'
1774: , arg1 => itemtype
1775: , arg2 => itemkey

Line 1861: debug( fnd_log.level_statement

1857: ---------------------------------------------------------------------
1858: -- Get esc owner's role from the Workflow attribute. Get esc level
1859: -- and default status from the profile options
1860: ---------------------------------------------------------------------
1861: debug( fnd_log.level_statement
1862: , l_api_name
1863: , 'funcmode = RUN'
1864: ||'itemtype '||itemtype
1865: ||'itemkey'||itemkey

Line 1888: debug(fnd_log.level_statement, l_api_name,'Owner role is: '||l_owner_role);

1884: , p_return_type => 'CODE'
1885: );
1886: END IF;
1887:
1888: debug(fnd_log.level_statement, l_api_name,'Owner role is: '||l_owner_role);
1889:
1890: l_esc_status := FND_PROFILE.Value
1891: ( name => 'JTF_EC_DEFAULT_STATUS'
1892: );

Line 1897: debug(fnd_log.level_statement, l_api_name, 'Escalation status is: '||l_esc_status||' Level is: '||l_esc_level);

1893: l_esc_level := FND_PROFILE.Value
1894: ( name => 'JTF_EC_DEFAULT_ESCALATION_LEVEL'
1895: );
1896:
1897: debug(fnd_log.level_statement, l_api_name, 'Escalation status is: '||l_esc_status||' Level is: '||l_esc_level);
1898:
1899: ---------------------------------------------------------------------
1900: -- Get ID of person who is to own the task
1901: ---------------------------------------------------------------------

Line 1908: debug( fnd_log.level_statement

1904: , x_res_type => l_resource_type
1905: , x_resultout => l_resultout
1906: );
1907:
1908: debug( fnd_log.level_statement
1909: , l_api_name
1910: , 'Result Out is:'||l_resultout
1911: ||'Owner Id is: '||l_owner_id
1912: ||'Res type'||l_resource_type

Line 1977: debug(fnd_log.level_statement, l_api_name, 'Escalation API failed because:'||l_msg||l_msg_count);

1973: -- Create_Escalation API failed
1974: -----------------------------------------------------------------
1975: IF (l_return_status = FND_API.G_Ret_Sts_Error)
1976: THEN
1977: debug(fnd_log.level_statement, l_api_name, 'Escalation API failed because:'||l_msg||l_msg_count);
1978: ---------------------------------------------------------------
1979: -- No need to report the 'document already escalated' error
1980: ---------------------------------------------------------------
1981: IF (l_msg_name <> 'JTF_TK_ESC_DOC_EXIST')

Line 1986: debug(fnd_log.level_statement, l_api_name, 'Escalation API failed with unexpected error'||l_msg||l_msg_count);

1982: THEN
1983: RAISE FND_API.G_EXC_ERROR;
1984: END IF;
1985: ELSE
1986: debug(fnd_log.level_statement, l_api_name, 'Escalation API failed with unexpected error'||l_msg||l_msg_count);
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END IF;
1989: END IF;
1990: ELSE

Line 1994: debug(fnd_log.level_statement, l_api_name, 'Get_PersonID failed');

1990: ELSE
1991: -------------------------------------------------------------------
1992: -- Get_PersonID failed
1993: -------------------------------------------------------------------
1994: debug(fnd_log.level_statement, l_api_name, 'Get_PersonID failed');
1995: IF (l_resultout = FND_API.G_Ret_Sts_Error)
1996: THEN
1997: RAISE FND_API.G_EXC_ERROR;
1998: ELSE

Line 2031: debug(fnd_log.level_statement, l_api_name, 'Set_Globals is not successful: '||resultout);

2027: ELSE
2028: -----------------------------------------------------------------------
2029: -- Set_Globals failed
2030: -----------------------------------------------------------------------
2031: debug(fnd_log.level_statement, l_api_name, 'Set_Globals is not successful: '||resultout);
2032: IF (resultout = FND_API.G_Ret_Sts_Error)
2033: THEN
2034: RAISE FND_API.G_EXC_ERROR;
2035: ELSE

Line 2039: debug(fnd_log.level_statement, l_api_name, 'Return status of the API:'||resultout);

2035: ELSE
2036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2037: END IF;
2038: END IF;
2039: debug(fnd_log.level_statement, l_api_name, 'Return status of the API:'||resultout);
2040: EXCEPTION
2041: WHEN FND_API.G_EXC_ERROR
2042: THEN
2043: resultout := 'COMPLETE:' || g_noncritical;

Line 2045: debug(fnd_log.level_error, l_api_name, 'API returns with Expected Error');

2041: WHEN FND_API.G_EXC_ERROR
2042: THEN
2043: resultout := 'COMPLETE:' || g_noncritical;
2044:
2045: debug(fnd_log.level_error, l_api_name, 'API returns with Expected Error');
2046:
2047: WF_CORE.Context( pkg_name => g_pkg_name
2048: , proc_name => 'Create_EscTask'
2049: , arg1 => itemtype

Line 2059: debug(fnd_log.level_unexpected, l_api_name, 'API returns with unexpected error');

2055: WHEN OTHERS
2056: THEN
2057: resultout := 'COMPLETE:' || g_critical;
2058:
2059: debug(fnd_log.level_unexpected, l_api_name, 'API returns with unexpected error');
2060:
2061: WF_CORE.Context( pkg_name => g_pkg_name
2062: , proc_name => 'Create_EscTask'
2063: , arg1 => itemtype

Line 2142: debug( fnd_log.level_statement, l_api_name, 'Notification role is:'||l_notif_role);

2138: ( p_attr_name => 'CS_ESC_NOTIF_ROLE'
2139: , p_return_type => 'CODE'
2140: );
2141: END IF;
2142: debug( fnd_log.level_statement, l_api_name, 'Notification role is:'||l_notif_role);
2143: ---------------------------------------------------------------------
2144: -- Get ID of person who is to be notified
2145: ---------------------------------------------------------------------
2146: g_notif_person_id := Get_PersonID

Line 2157: debug(fnd_log.level_statement, l_api_name, 'Finding workflow role of:'||g_notif_person_id);

2153: THEN
2154: -------------------------------------------------------------------
2155: -- Work out WF internal name for the employee
2156: -------------------------------------------------------------------
2157: debug(fnd_log.level_statement, l_api_name, 'Finding workflow role of:'||g_notif_person_id);
2158: l_wf_role := Get_EmployeeRole
2159: ( p_employee_id => g_notif_person_id
2160: , x_resultout => l_resultout
2161: );

Line 2162: debug(fnd_log.level_statement, l_api_name, 'Finding Workflow role completed with '||l_resultout);

2158: l_wf_role := Get_EmployeeRole
2159: ( p_employee_id => g_notif_person_id
2160: , x_resultout => l_resultout
2161: );
2162: debug(fnd_log.level_statement, l_api_name, 'Finding Workflow role completed with '||l_resultout);
2163: IF (l_resultout = FND_API.G_Ret_Sts_Success)
2164: THEN
2165: -----------------------------------------------------------------
2166: -- Set the WF attribute

Line 2168: debug(fnd_log.level_statement, l_api_name, 'Setting the NTF_PERSON with:'||l_wf_role);

2164: THEN
2165: -----------------------------------------------------------------
2166: -- Set the WF attribute
2167: -----------------------------------------------------------------
2168: debug(fnd_log.level_statement, l_api_name, 'Setting the NTF_PERSON with:'||l_wf_role);
2169: WF_ENGINE.SetItemAttrText( itemtype => itemtype
2170: , itemkey => itemkey
2171: , aname => 'NTF_PERSON'
2172: , avalue => l_wf_role

Line 2184: debug(fnd_log.level_error, l_api_name, 'Getting Employee Role Failed');

2180: -- Get_EmployeeRole failed
2181: -----------------------------------------------------------------
2182: IF (l_resultout = FND_API.G_Ret_Sts_Error)
2183: THEN
2184: debug(fnd_log.level_error, l_api_name, 'Getting Employee Role Failed');
2185: RAISE FND_API.G_EXC_ERROR;
2186: ELSE
2187: debug(fnd_log.level_unexpected, l_api_name, 'Getting Employee Role Failed with unexpected error');
2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2187: debug(fnd_log.level_unexpected, l_api_name, 'Getting Employee Role Failed with unexpected error');

2183: THEN
2184: debug(fnd_log.level_error, l_api_name, 'Getting Employee Role Failed');
2185: RAISE FND_API.G_EXC_ERROR;
2186: ELSE
2187: debug(fnd_log.level_unexpected, l_api_name, 'Getting Employee Role Failed with unexpected error');
2188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2189: END IF;
2190: END IF;
2191: ELSE

Line 2195: debug(fnd_log.level_statement, l_api_name, 'Getting Person ID failed with:'||l_resultout);

2191: ELSE
2192: -------------------------------------------------------------------
2193: -- Get_PersonId failed
2194: -------------------------------------------------------------------
2195: debug(fnd_log.level_statement, l_api_name, 'Getting Person ID failed with:'||l_resultout);
2196: IF (l_resultout = FND_API.G_Ret_Sts_Error)
2197: THEN
2198: RAISE FND_API.G_EXC_ERROR;
2199: ELSE

Line 2219: debug(fnd_log.level_unexpected, l_api_name, 'Unknown WF action requested');

2215: ELSE
2216: ---------------------------------------------------------------------
2217: -- Unknown function from WF - raise error
2218: ---------------------------------------------------------------------
2219: debug(fnd_log.level_unexpected, l_api_name, 'Unknown WF action requested');
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221: END IF;
2222: ELSE
2223: -----------------------------------------------------------------------

Line 2226: debug(fnd_log.level_unexpected, l_api_name, 'Setting Globals failed with:'||l_resultout);

2222: ELSE
2223: -----------------------------------------------------------------------
2224: -- Set_Globals failed
2225: -----------------------------------------------------------------------
2226: debug(fnd_log.level_unexpected, l_api_name, 'Setting Globals failed with:'||l_resultout);
2227: IF (resultout = FND_API.G_Ret_Sts_Error)
2228: THEN
2229: RAISE FND_API.G_EXC_ERROR;
2230: ELSE

Line 2234: debug(fnd_log.level_statement, l_api_name, 'Return status of the API:'||resultout);

2230: ELSE
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: END IF;
2233: END IF;
2234: debug(fnd_log.level_statement, l_api_name, 'Return status of the API:'||resultout);
2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR
2238: THEN

Line 2240: debug( fnd_log.level_error

2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR
2238: THEN
2239: resultout := 'COMPLETE:' || g_noncritical;
2240: debug( fnd_log.level_error
2241: , l_api_name
2242: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
2243: );
2244: WF_CORE.Context( pkg_name => g_pkg_name

Line 2255: debug( fnd_log.level_unexpected

2251: RAISE;
2252: WHEN OTHERS
2253: THEN
2254: resultout := 'COMPLETE:' || g_critical;
2255: debug( fnd_log.level_unexpected
2256: , l_api_name
2257: , 'Error occured: Code:'|| SQLCODE || 'Error:'|| SQLERRM
2258: );
2259: WF_CORE.Context( pkg_name => g_pkg_name