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.GR_WF_UTIL_PUB dependencies on FND_MSG_PUB

Line 70: FND_MSG_PUB.Initialize;

66:
67: l_commit := 'F';
68: /************* Initialize the message list if true *************/
69: IF FND_API.To_Boolean(p_init_msg_list) THEN
70: FND_MSG_PUB.Initialize;
71: END IF;
72:
73: /************* Check the API version passed in matches the internal API version. *************/
74:

Line 90: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

86:
87: /************* Check for Parameter Organization Id *************/
88:
89: IF p_orgn_id is NULL THEN
90: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
91: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Organization provided is null - failed to initate the Document Rebuild Workflow.');
92: END IF;
93: RAISE ORGN_ID_IS_NULL;
94: END IF;

Line 99: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

95:
96: /************* Check for Parameter Item Id *************/
97:
98: IF p_item_id is NULL THEN
99: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
100: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Item provided is null - failed to initate the Document Rebuild Workflow.');
101: END IF;
102: RAISE ITEM_ID_IS_NULL;
103: END IF;

Line 105: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

101: END IF;
102: RAISE ITEM_ID_IS_NULL;
103: END IF;
104:
105: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
106: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Check for the GR_DOC_UPD_REQ_WF_ENABLE Profile defined.');
107: END IF;
108: /************* Check for Profiles *************/
109: IF (FND_PROFILE.DEFINED('GR_DOC_UPD_REQ_WF_ENABLED')) THEN

Line 115: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

111: l_doc_rbld_req := FND_PROFILE.Value('GR_DOC_UPD_REQ_WF_ENABLED');
112:
113: /************* If the Workflow Profile is Enabled *************/
114: IF (l_doc_rbld_req = 'E') THEN
115: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
116: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is enabled and get thee Item details for the Item ID : ' || p_item_id);
117: END IF;
118: /************* Get the Item Details *************/
119: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, p_item_id, l_item_no, l_item_desc);

Line 120: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

116: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is enabled and get thee Item details for the Item ID : ' || p_item_id);
117: END IF;
118: /************* Get the Item Details *************/
119: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, p_item_id, l_item_no, l_item_desc);
120: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
121: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Organization ID : ' || p_orgn_id || ' Item ID : ' || p_item_id || ' Item Number : ' || l_item_no || ' Item Description : ' || l_item_desc);
122: END IF;
123: IF l_item_no IS NOT NULL THEN
124: /************* Initiate the Document Rebuild Required Workflow *************/

Line 125: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

121: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Organization ID : ' || p_orgn_id || ' Item ID : ' || p_item_id || ' Item Number : ' || l_item_no || ' Item Description : ' || l_item_desc);
122: END IF;
123: IF l_item_no IS NOT NULL THEN
124: /************* Initiate the Document Rebuild Required Workflow *************/
125: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
126: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Regulatory Item found. ');
127: END IF;
128: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, p_item_id, l_item_no, l_item_desc, NULL, NULL, p_user_id);
129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

125: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
126: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Regulatory Item found. ');
127: END IF;
128: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, p_item_id, l_item_no, l_item_desc, NULL, NULL, p_user_id);
129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
130: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Item Change. ');
131: END IF;
132: ELSE
133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

129: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
130: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Item Change. ');
131: END IF;
132: ELSE
133: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
134: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the workflow failed as the Item is not a Regulatory Item.');
135: END IF;
136: END IF;
137: ELSE

Line 138: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

134: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the workflow failed as the Item is not a Regulatory Item.');
135: END IF;
136: END IF;
137: ELSE
138: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
139: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
140: END IF;
141: END IF;
142: ELSE

Line 143: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

139: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
140: END IF;
141: END IF;
142: ELSE
143: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
144: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is Undefined.');
145: END IF;
146: END IF;
147: /************* Initialize commit flag only if true *************/

Line 263: FND_MSG_PUB.Initialize;

259: l_commit := 'F';
260:
261: /************* Initialize the message list if true *************/
262: IF FND_API.To_Boolean(p_init_msg_list) THEN
263: FND_MSG_PUB.Initialize;
264: END IF;
265:
266: /************* Check the API version passed in matches the internal API version. *************/
267:

Line 283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

279:
280: /************* Check for Parameter Organization Id *************/
281:
282: IF p_orgn_id is NULL THEN
283: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
284: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Organization provided is null - failed to initate the Document Rebuild Workflow.');
285: END IF;
286: RAISE ORGN_ID_IS_NULL;
287: END IF;

Line 293: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

289:
290: /************* Check for Parameter Item Id *************/
291:
292: IF p_item_id is NULL THEN
293: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
294: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Item ID provided is null - failed to initate the Document Rebuild Workflow.');
295: END IF;
296: RAISE ITEM_ID_IS_NULL;
297: END IF;

Line 302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

298:
299: /************* Check for Parameter Formula Id but not for for Validity rules (formula vers passed as -1 )*************/
300:
301: IF p_formula_vers <> -1 and p_formula_no is NULL AND p_formula_vers is NULL THEN -- bug 6193989 added check for -1
302: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
303: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Formula No provided is null - failed to initate the Document Rebuild Workflow.');
304: END IF;
305: RAISE FORMULA_ID_IS_NULL;
306: END IF;

Line 309: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

305: RAISE FORMULA_ID_IS_NULL;
306: END IF;
307:
308:
309: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
310: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Check for the GR_DOC_UPD_REQ_WF_ENABLE Profile defined.');
311: END IF;
312: /************* Check for Profiles *************/
313: IF (FND_PROFILE.DEFINED('GR_DOC_UPD_REQ_WF_ENABLED')) THEN

Line 319: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

315: l_doc_rbld_req := FND_PROFILE.Value('GR_DOC_UPD_REQ_WF_ENABLED');
316:
317: /************* If the Workflow Profile is Enabled *************/
318: IF (l_doc_rbld_req = 'E') THEN
319: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
320: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is enabled and get thee Item details for the Item ID : ' || p_item_id);
321: END IF;
322: /************* Get the Item Details *************/
323: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, p_item_id, l_item_no, l_item_desc);

Line 324: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

320: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is enabled and get thee Item details for the Item ID : ' || p_item_id);
321: END IF;
322: /************* Get the Item Details *************/
323: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, p_item_id, l_item_no, l_item_desc);
324: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
325: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Organization ID : ' || p_orgn_id || ' Item ID : ' || p_item_id || ' Item Number : ' || l_item_no || ' Item Description : ' || l_item_desc);
326: END IF;
327: /************* Get the Formula Details ************
328: Gr_Wf_Util_PVT.Get_formula_Details(p_formula_id, l_formula_no, l_formula_vers);

Line 329: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

325: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Organization ID : ' || p_orgn_id || ' Item ID : ' || p_item_id || ' Item Number : ' || l_item_no || ' Item Description : ' || l_item_desc);
326: END IF;
327: /************* Get the Formula Details ************
328: Gr_Wf_Util_PVT.Get_formula_Details(p_formula_id, l_formula_no, l_formula_vers);
329: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
330: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Formula ID : ' || p_formula_id || ' Formula Number : ' || l_formula_no || ' Formula Version : ' || l_formula_vers);
331: END IF; */
332: IF l_item_no IS NOT NULL THEN
333: /************* Initiate the Document Rebuild Required Workflow *************/

Line 334: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

330: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the Formula ID : ' || p_formula_id || ' Formula Number : ' || l_formula_no || ' Formula Version : ' || l_formula_vers);
331: END IF; */
332: IF l_item_no IS NOT NULL THEN
333: /************* Initiate the Document Rebuild Required Workflow *************/
334: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
335: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Regulatory Item found. ');
336: END IF;
337: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, p_item_id, l_item_no, l_item_desc, p_formula_no, p_formula_vers, p_user_id);
338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

334: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
335: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Regulatory Item found. ');
336: END IF;
337: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, p_item_id, l_item_no, l_item_desc, p_formula_no, p_formula_vers, p_user_id);
338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
339: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Formula Change. ');
340: END IF;
341: ELSE
342: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 342: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

338: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
339: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Formula Change. ');
340: END IF;
341: ELSE
342: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
343: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the workflow failed as the Item is not a Regulatory Item.');
344: END IF;
345: END IF;
346: ELSE

Line 347: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

343: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the workflow failed as the Item is not a Regulatory Item.');
344: END IF;
345: END IF;
346: ELSE
347: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
348: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
349: END IF;
350: END IF;
351: ELSE

Line 352: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

348: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
349: END IF;
350: END IF;
351: ELSE
352: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
353: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is Undefined.');
354: END IF;
355: END IF;
356:

Line 484: FND_MSG_PUB.Initialize;

480: l_commit := 'F';
481:
482: /************* Initialize the message list if true *************/
483: IF FND_API.To_Boolean(p_init_msg_list) THEN
484: FND_MSG_PUB.Initialize;
485: END IF;
486:
487: /************* Check the API version passed in matches the internal API version. *************/
488:

Line 504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

500:
501: /************* Check for Parameter Organization Id *************/
502:
503: IF p_orgn_id is NULL THEN
504: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
505: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Organization provided is null - failed to initate the Document Rebuild Workflow.');
506: END IF;
507: RAISE ORGN_ID_IS_NULL;
508: END IF;

Line 513: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

509:
510: /************* Check for Parameter Item Id *************/
511:
512: IF p_item_id is NULL THEN
513: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
514: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Item ID provided is null - failed to initate the Document Rebuild Workflow.');
515: END IF;
516: RAISE ITEM_ID_IS_NULL;
517: END IF;

Line 522: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

518:
519: /************* Check for Parameter Formula Id *************/
520:
521: IF p_sales_order_no is NULL THEN
522: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
523: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Sales Order Number provided is null - failed to initate the Document Rebuild Workflow.');
524: END IF;
525: RAISE SO_NUMBER_IS_NULL;
526: END IF;

Line 528: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

524: END IF;
525: RAISE SO_NUMBER_IS_NULL;
526: END IF;
527:
528: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
529: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Check for the GR_SO_CHECK_FOR_HAZARDS Profile defined.');
530: END IF;
531:
532: /************* Check for Profiles *************/

Line 538: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

534: l_so_chk_hzrd := FND_PROFILE.Value('GR_SO_CHECK_FOR_HAZARDS');
535:
536: /************* If the Workflow Profile is Enabled *************/
537: IF (l_so_chk_hzrd = 'Y') THEN
538: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
539: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_SO_CHECK_FOR_HAZARDS is set to Yes and get the Item details for the Item ID : ' || p_item_id);
540: END IF;
541:
542: /************* Get the Item Details *************/

Line 544: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

540: END IF;
541:
542: /************* Get the Item Details *************/
543: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, p_item_id, l_item_no, l_item_desc);
544: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
545: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the
546: Organization ID : ' || p_orgn_id ||
547: ' Item ID : ' || p_item_id || ' Item Number : ' || l_item_no ||
548: ' Item Description : ' ||l_item_desc ||' Sales Order Number : '

Line 553: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

549: || p_sales_order_no);
550: END IF;
551:
552: IF l_item_no IS NOT NULL THEN
553: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
554: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Sales Order is created for a Regulatory Item. ');
555: END IF;
556: /************* Initiate the XML Outbound Message *************/
557: Gr_Wf_Util_PVT.SEND_OUTBOUND_DOCUMENT ('GR', 'GRIOO', p_sales_order_no,p_sales_order_org_id); -- 6689912

Line 558: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

554: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Sales Order is created for a Regulatory Item. ');
555: END IF;
556: /************* Initiate the XML Outbound Message *************/
557: Gr_Wf_Util_PVT.SEND_OUTBOUND_DOCUMENT ('GR', 'GRIOO', p_sales_order_no,p_sales_order_org_id); -- 6689912
558: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
559: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiated the Outbound for Sales Order. ');
560: END IF;
561: ELSE
562: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 562: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

558: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
559: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiated the Outbound for Sales Order. ');
560: END IF;
561: ELSE
562: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
563: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the Outbound Message failed as the Sales Order Line Item is not a Regulatory Item.');
564: END IF;
565: END IF;
566: ELSE

Line 567: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

563: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiation of the Outbound Message failed as the Sales Order Line Item is not a Regulatory Item.');
564: END IF;
565: END IF;
566: ELSE
567: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
568: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_SO_CHECK_FOR_HAZARDS is disabled, therefore the initiation of the Outbound Message failed.');
569: END IF;
570: END IF;
571: ELSE

Line 572: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

568: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_SO_CHECK_FOR_HAZARDS is disabled, therefore the initiation of the Outbound Message failed.');
569: END IF;
570: END IF;
571: ELSE
572: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
573: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_SO_CHECK_FOR_HAZARDS is Undefined.');
574: END IF;
575: END IF;
576:

Line 713: FND_MSG_PUB.Initialize;

709: l_code_block := 'Initialize';
710:
711: /************* Initialize the message list if true *************/
712: IF FND_API.To_Boolean(p_init_msg_list) THEN
713: FND_MSG_PUB.Initialize;
714: END IF;
715:
716: /************* Check the API version passed in matches the internal API version. *************/
717:

Line 733: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

729:
730: /************* Check for Parameter Organization Id *************/
731:
732: IF p_orgn_id is NULL THEN
733: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
734: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Organization provided is null - failed to initate the Document Rebuild Workflow.');
735: END IF;
736: RAISE ORGN_ID_IS_NULL;
737: END IF;

Line 742: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

738:
739: /************* Check for Parameter Item Id *************/
740:
741: IF p_tech_parm_id is NULL THEN
742: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
743: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Tech Data ID provided is null - failed to initate the Document Rebuild Workflow.');
744: END IF;
745: RAISE ITEM_ID_IS_NULL;
746: END IF;

Line 751: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

747:
748: /************* Check for Parameter Tech Data Id *************/
749:
750: IF p_tech_data_id is NULL THEN
751: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
752: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Technical Data ID provided is null - failed to initate the Document Rebuild Workflow.');
753: END IF;
754: RAISE TECH_DATA_ID_IS_NULL;
755: END IF;

Line 757: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

753: END IF;
754: RAISE TECH_DATA_ID_IS_NULL;
755: END IF;
756:
757: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
758: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Check for the GR_DOC_UPD_REQ_WF_ENABLE Profile defined.');
759: END IF;
760: /************* Check for Profiles *************/
761: IF (FND_PROFILE.DEFINED('GR_DOC_UPD_REQ_WF_ENABLED')) THEN

Line 775: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

771: IF l_item_id IS NULL THEN
772: RAISE ITEM_ID_IS_NULL;
773: END IF;
774:
775: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
776: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is enabled and get the Item details for the Item ID : '|| l_item_id);
777: END IF;
778:
779: FOR c1 in get_tech_parm_details LOOP

Line 782: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

778:
779: FOR c1 in get_tech_parm_details LOOP
780: /************* Get the Item Details *************/
781: Gr_Wf_Util_PVT.Get_Item_Details(p_orgn_id, l_item_id, l_item_no, l_item_desc);
782: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
783: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Details for the
784: Organization ID : ' || p_orgn_id || ' Item ID : ' ||
785: l_item_id || ' Item Number : ' || l_item_no ||
786: ' Item Description : ' || l_item_desc || 'Technical

Line 793: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

789: /************* Check for Technical Parameters and Regulatory Item *************/
790: IF Gr_Wf_Util_PVT.CHECK_FOR_TECH_PARAM (c1.tech_parm_name) AND
791: l_item_no IS NOT NULL THEN
792: /************* Initiate the Document Rebuild Required Workflow *************/
793: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
794: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Technical Parameter ' || c1.tech_parm_name || ' is defined for this Item ' || l_item_no);
795: END IF;
796: /************* Initiate the Workflow *************/
797: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, l_item_id, l_item_no, l_item_desc, NULL, NULL, p_user_id);

Line 798: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

794: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Technical Parameter ' || c1.tech_parm_name || ' is defined for this Item ' || l_item_no);
795: END IF;
796: /************* Initiate the Workflow *************/
797: Gr_Wf_Util_PVT.WF_INIT (p_orgn_id, l_item_id, l_item_no, l_item_desc, NULL, NULL, p_user_id);
798: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
799: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Formula Change. ');
800: END IF;
801: ELSE
802: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

Line 802: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

798: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
799: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Initiate the workflow for Formula Change. ');
800: END IF;
801: ELSE
802: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
803: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Technical Parameter ' || c1.tech_parm_name || ' is not defined for this Item ' || l_item_no);
804: END IF;
805: END IF;
806: END LOOP;

Line 809: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

805: END IF;
806: END LOOP;
807: CLOSE get_tech_parm_details;
808: ELSE
809: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
810: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
811: END IF;
812: END IF;
813: ELSE

Line 814: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN

810: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is disabled, therefore the initiation of the workflow failed.');
811: END IF;
812: END IF;
813: ELSE
814: IF FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW >= G_Debug_Level THEN
815: gr_wf_util_pvt.log_msg(g_pkg_name || ' : Profile GR_DOC_UPD_REQ_WF_ENABLE is Undefined.');
816: END IF;
817: END IF;
818: