DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_NTF_UTIL dependencies on ENG_WORKFLOW_UTIL

Line 329: Eng_Workflow_Util.GetChangeObject

325: x_mesg_attribute_rec.notification_id := TO_NUMBER(substr(document_id, l_index2 + 1));
326:
327:
328: -- Get Change Object Identifier
329: Eng_Workflow_Util.GetChangeObject
330: ( p_item_type => x_mesg_attribute_rec.item_type
331: , p_item_key => x_mesg_attribute_rec.item_key
332: , x_change_id => x_mesg_attribute_rec.change_id
333: , x_change_notice => x_mesg_attribute_rec.change_notice

Line 340: Eng_Workflow_Util.GetChangeLineObject

336:
337:
338: begin
339: -- Get Change Line Object Identifier
340: Eng_Workflow_Util.GetChangeLineObject
341: ( p_item_type => x_mesg_attribute_rec.item_type
342: , p_item_key => x_mesg_attribute_rec.item_key
343: , x_change_line_id => x_mesg_attribute_rec.change_line_id
344: ) ;

Line 365: Eng_Workflow_Util.GetHostURL

361: , x_html_body_msg_name => l_html_body_msg_name
362: ) ;
363:
364: -- Get Host URL
365: Eng_Workflow_Util.GetHostURL
366: ( p_item_type => x_mesg_attribute_rec.item_type
367: , p_item_key => x_mesg_attribute_rec.item_key
368: , x_host_url => x_mesg_attribute_rec.host_url
369: ) ;

Line 372: Eng_Workflow_Util.GetStyleSheet

368: , x_host_url => x_mesg_attribute_rec.host_url
369: ) ;
370:
371: -- Get Style Sheet
372: Eng_Workflow_Util.GetStyleSheet
373: ( p_item_type => x_mesg_attribute_rec.item_type
374: , p_item_key => x_mesg_attribute_rec.item_key
375: , x_style_sheet => x_mesg_attribute_rec.style_sheet
376: ) ;

Line 380: Eng_Workflow_Util.GetWFChangeObjectInfo

376: ) ;
377:
378:
379: -- Get Workflow Change Object Info
380: Eng_Workflow_Util.GetWFChangeObjectInfo
381: ( p_item_type => x_mesg_attribute_rec.item_type
382: , p_item_key => x_mesg_attribute_rec.item_key
383: , x_change_name => x_mesg_attribute_rec.change_name
384: , x_description => x_mesg_attribute_rec.description

Line 402: Eng_Workflow_Util.GetWFChangeLineObjectInfo

398: x_mesg_attribute_rec.change_line_id > 0
399: THEN
400:
401: -- Get Change Line Object Info
402: Eng_Workflow_Util.GetWFChangeLineObjectInfo
403: ( p_item_type => x_mesg_attribute_rec.item_type
404: , p_item_key => x_mesg_attribute_rec.item_key
405: , x_line_sequence_number => x_mesg_attribute_rec.line_sequence_number
406: , x_line_name => x_mesg_attribute_rec.line_name

Line 413: Eng_Workflow_Util.GetChangeLineItemSubjectInfo

409: , x_line_assignee => x_mesg_attribute_rec.line_assignee
410: , x_line_assignee_company => x_mesg_attribute_rec.line_assignee_company
411: ) ;
412:
413: Eng_Workflow_Util.GetChangeLineItemSubjectInfo
414: ( p_change_id => x_mesg_attribute_rec.change_id
415: , p_change_line_id => x_mesg_attribute_rec.change_line_id
416: , x_organization_id => x_mesg_attribute_rec.item_organization_id
417: , x_item_id => x_mesg_attribute_rec.item_id

Line 426: Eng_Workflow_Util.GetChangeItemSubjectInfo

422: ) ;
423:
424: ELSE
425:
426: Eng_Workflow_Util.GetChangeItemSubjectInfo
427: ( p_change_id => x_mesg_attribute_rec.change_id
428: , x_organization_id => x_mesg_attribute_rec.item_organization_id
429: , x_item_id => x_mesg_attribute_rec.item_id
430: , x_item_name => x_mesg_attribute_rec.item_name

Line 442: Eng_Workflow_Util.GetActionId

438:
439: begin
440:
441: -- Get Action Id
442: Eng_Workflow_Util.GetActionId
443: ( p_item_type => x_mesg_attribute_rec.item_type
444: , p_item_key => x_mesg_attribute_rec.item_key
445: , x_action_id => x_mesg_attribute_rec.action_id
446: ) ;

Line 456: Eng_Workflow_Util.GetActionInfo

452:
453:
454: IF x_mesg_attribute_rec.action_id IS NOT NULL THEN
455:
456: Eng_Workflow_Util.GetActionInfo
457: ( p_action_id => x_mesg_attribute_rec.action_id
458: , x_action_desc => x_mesg_attribute_rec.action_desc
459: , x_action_party_id => x_mesg_attribute_rec.action_party_id
460: , x_action_party_name => x_mesg_attribute_rec.action_party_name

Line 475: Eng_Workflow_Util.GetRouteId

471:
472: begin
473:
474: -- Get Route Id
475: Eng_Workflow_Util.GetRouteId
476: ( p_item_type => x_mesg_attribute_rec.item_type
477: , p_item_key => x_mesg_attribute_rec.item_key
478: , x_route_id => x_mesg_attribute_rec.route_id
479: ) ;

Line 492: -- Eng_Workflow_Util.GetRouteInfo

488: IF x_mesg_attribute_rec.route_id IS NOT NULL THEN
489:
490: NULL ;
491: --
492: -- Eng_Workflow_Util.GetRouteInfo
493: -- ( p_route_id => x_mesg_attribute_rec.route_id
494: -- , x_XXXX => x_mesg_attribute_rec.XXX
495: -- ) ;
496: --

Line 503: Eng_Workflow_Util.GetRouteStepId

499:
500: begin
501:
502: -- Get Step Id
503: Eng_Workflow_Util.GetRouteStepId
504: ( p_item_type => x_mesg_attribute_rec.item_type
505: , p_item_key => x_mesg_attribute_rec.item_key
506: , x_route_step_id => x_mesg_attribute_rec.step_id
507: ) ;

Line 517: Eng_Workflow_Util.GetRouteStepInfo

513:
514:
515: IF x_mesg_attribute_rec.step_id IS NOT NULL THEN
516:
517: Eng_Workflow_Util.GetRouteStepInfo
518: ( p_route_step_id => x_mesg_attribute_rec.step_id
519: , x_step_seq_num => x_mesg_attribute_rec.step_seq_num
520: , x_required_date => x_mesg_attribute_rec.required_date
521: , x_condition_type => x_mesg_attribute_rec.condition_type

Line 872: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageTextBody' ) ;

868: NL := FND_GLOBAL.NEWLINE;
869:
870:
871: -- For Test/Debug
872: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageTextBody' ) ;
873: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
874: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
876:

Line 873: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );

869:
870:
871: -- For Test/Debug
872: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageTextBody' ) ;
873: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
874: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
876:
877:

Line 874: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);

870:
871: -- For Test/Debug
872: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageTextBody' ) ;
873: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
874: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
876:
877:
878: -- Call GetMessageHTMLBody if display type is text/plain

Line 875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);

871: -- For Test/Debug
872: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageTextBody' ) ;
873: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
874: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
875: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
876:
877:
878: -- Call GetMessageHTMLBody if display type is text/plain
879: IF (display_type = WF_NOTIFICATION.DOC_HTML ) THEN

Line 899: -- Eng_Workflow_Util.Close_Debug_Session;

895: , x_mesg_attribute_rec => l_mesg_attribute_rec
896: ) ;
897:
898:
899: -- Eng_Workflow_Util.Close_Debug_Session;
900:
901: -- We are not supporting text message notification by default
902: -- WF_NOTIFICATION.WriteToClob( document , l_doc);
903:

Line 1071: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageHTMLBody' ) ;

1067: -- Init Var
1068: NL := FND_GLOBAL.NEWLINE;
1069:
1070: -- For Test/Debug
1071: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageHTMLBody' ) ;
1072: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
1073: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
1074: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
1075:

Line 1072: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );

1068: NL := FND_GLOBAL.NEWLINE;
1069:
1070: -- For Test/Debug
1071: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageHTMLBody' ) ;
1072: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
1073: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
1074: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
1075:
1076:

Line 1073: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);

1069:
1070: -- For Test/Debug
1071: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageHTMLBody' ) ;
1072: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
1073: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
1074: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
1075:
1076:
1077: /* Not supporting text

Line 1074: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);

1070: -- For Test/Debug
1071: -- Eng_Workflow_Util.Open_Debug_Session( '/sqlcom/log/plm115d' , 'GetMessageHTMLBody' ) ;
1072: -- Eng_Workflow_Util.Write_Debug('document id ' || document_id );
1073: -- Eng_Workflow_Util.Write_Debug('display_type ' || display_type);
1074: -- Eng_Workflow_Util.Write_Debug('document_type ' || document_type);
1075:
1076:
1077: /* Not supporting text
1078: -- Call GetMessageHTMLBody if display type is text/plain

Line 1146: || Eng_Workflow_Util.GetFunctionWebHTMLCall

1142:
1143: -- Item Detail URL
1144: -- Ex) /OA_HTML/OA.jsp?OAFunc=EGO_ITEM_OVERVIEW&inventoryItemId=999&organizationId=999
1145: l_item_url := '/OA_HTML/'
1146: || Eng_Workflow_Util.GetFunctionWebHTMLCall
1147: (p_function_name => 'EGO_ITEM_OVERVIEW' )
1148: || '&inventoryItemId='
1149: || TO_CHAR(l_mesg_attribute_rec.item_id)
1150: || '&organizationId='

Line 1157: || Eng_Workflow_Util.GetFunctionWebHTMLCall

1153:
1154: -- Item Revision Detail URL
1155: -- Ex) /OA_HTML/OA.jsp?OAFunc=EGO_ITEM_REVISIONS&inventoryItemId=999&organizationId=999&revisionCode=A
1156: l_item_revision_url := '/OA_HTML/'
1157: || Eng_Workflow_Util.GetFunctionWebHTMLCall
1158: (p_function_name => 'EGO_ITEM_REVISIONS' )
1159: || '&inventoryItemId='
1160: || TO_CHAR(l_mesg_attribute_rec.item_id)
1161: || '&organizationId='

Line 1173: l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE AND

1169:
1170:
1171:
1172: IF l_mesg_attribute_rec.step_id IS NOT NULL AND
1173: l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE AND
1174: l_mesg_attribute_rec.wf_msg_name <> G_ABORT_STEP_MSG
1175: THEN
1176:
1177: FND_MESSAGE.SET_NAME('ENG', 'ENG_STEP_INSTRUCTIONS') ;

Line 1183: ( l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE

1179:
1180: END IF ;
1181:
1182: IF l_mesg_attribute_rec.action_id IS NOT NULL AND
1183: ( l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
1184: OR l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE )
1185: THEN
1186:
1187: IF l_mesg_attribute_rec.wf_msg_name = G_REQUEST_COMMENT_MSG

Line 1184: OR l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE )

1180: END IF ;
1181:
1182: IF l_mesg_attribute_rec.action_id IS NOT NULL AND
1183: ( l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ACTION_ITEM_TYPE
1184: OR l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_LINE_ACTION_ITEM_TYPE )
1185: THEN
1186:
1187: IF l_mesg_attribute_rec.wf_msg_name = G_REQUEST_COMMENT_MSG
1188: THEN

Line 1217: || Eng_Workflow_Util.GetFunctionWebHTMLCall

1213: IF l_change_url_type = 'SUMMARY'
1214: THEN
1215:
1216: l_change_detail_url := '/OA_HTML/'
1217: || Eng_Workflow_Util.GetFunctionWebHTMLCall
1218: (p_function_name => 'ENG_CHANGE_SUMMARY_PAGE' )
1219: || '&changeId='
1220: || TO_CHAR(l_mesg_attribute_rec.change_id)
1221: || '&OAFunc=ENG_CHANGE_SUMMARY_PAGE' ;

Line 1227: || Eng_Workflow_Util.GetFunctionWebHTMLCall

1223:
1224: ELSE
1225:
1226: l_change_detail_url := '/OA_HTML/'
1227: || Eng_Workflow_Util.GetFunctionWebHTMLCall
1228: (p_function_name => 'ENG_CHANGE_DETAIL_PAGE' )
1229: || '&changeId='
1230: || TO_CHAR(l_mesg_attribute_rec.change_id)
1231: || '&OAFunc=ENG_CHANGE_DETAIL_PAGE' ;

Line 1250: || Eng_Workflow_Util.GetFunctionWebHTMLCall

1246: THEN
1247: l_change_name := l_mesg_attribute_rec.line_name ;
1248: l_change_description := l_mesg_attribute_rec.line_description ;
1249: l_change_detail_url := '/OA_HTML/'
1250: || Eng_Workflow_Util.GetFunctionWebHTMLCall
1251: (p_function_name => 'ENG_CHANGE_LINE_DETAIL_PAGE' )
1252: || '&changeLineId='
1253: || TO_CHAR(l_mesg_attribute_rec.change_line_id)
1254: || '&OAFunc=ENG_CHANGE_LINE_DETAIL_PAGE' ;

Line 1427: -- Eng_Workflow_Util.Close_Debug_Session;

1423: l_doc := l_doc || CLOSE_TR || NL ;
1424: l_doc := l_doc || CLOSE_TAB || NL ;
1425:
1426:
1427: -- Eng_Workflow_Util.Close_Debug_Session;
1428:
1429: WF_NOTIFICATION.WriteToClob( document , l_doc);
1430:
1431: -- Executing Custom Hook: Eng_Workflow_Ext.GetCustomMessageSubject