[Home] [Help]
38: l_item_type := P_item_type;
39:
40: BEGIN
41:
42: oe_debug_pub.add('Entering Display_Name for process : '||l_process,5);
43:
44: SELECT DISTINCT wa.name, wa.display_name
45: INTO l_process_name, l_display_name
46: FROM wf_activities_tl wa
55: AND p1.language = wa.language
56: );
57: EXCEPTION
58: WHEN NO_DATA_FOUND THEN
59: oe_debug_pub.add('NO_DATA_FOUND in Display_Name',1);
60: l_process_name := NULL;
61: l_display_name := NULL;
62: END;
63:
64: IF l_process_name IS NOT NULL AND l_display_name IS NOT NULL THEN
65: l_process := l_process_name||' ( '||l_display_name||' )';
66: END IF;
67:
68: oe_debug_pub.add('Exiting Display_Name for process : '||l_process,5);
69: RETURN l_process;
70:
71: EXCEPTION
72: WHEN FND_API.G_EXC_ERROR THEN
73: RAISE FND_API.G_EXC_ERROR;
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
76: WHEN OTHERS THEN
77: oe_debug_pub.add('Error in Display_Name : '||Sqlerrm,5);
78: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
79: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
80: END IF;
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: l_activity_id2 NUMBER;
108:
109: BEGIN
110:
111: oe_debug_pub.add('Entering Function OE_VALIDATE_WF.In_Loop '||to_char(activity1)||' '||to_char(activity2), 1);
112:
113: -- Copying passed into locals
114: l_activity_id1 := activity1;
115: l_activity_id2 := activity2;
118: G_loop_tbl.DELETE;
119: END IF;
120:
121: FOR processing_act in c_process_activity(l_activity_id2) LOOP
122: oe_debug_pub.add('processing_act.to_process_activity, activity1 '||to_char(processing_act.to_process_activity) ||' '||to_char(activity1), 5);
123:
124: IF processing_act.to_process_activity = l_activity_id1 THEN
125: l_return_status := TRUE;
126: EXIT;
150: END IF; -- processing_act.to_process_activity
151: END LOOP; -- processing_act
152:
153: IF l_return_status THEN
154: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop TRUE', 1);
155: ELSE
156: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop FALSE', 1);
157: END IF;
158:
152:
153: IF l_return_status THEN
154: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop TRUE', 1);
155: ELSE
156: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop FALSE', 1);
157: END IF;
158:
159: RETURN l_return_status;
160:
163: RAISE FND_API.G_EXC_ERROR;
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: WHEN OTHERS THEN
167: oe_debug_pub.add('Error in In_Loop : '||Sqlerrm,5);
168: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
169: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
170: END IF;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
241: l_start_time NUMBER;
242: l_end_time NUMBER;
243:
244: BEGIN
245: oe_debug_pub.add('Entering Function OE_VALIDATE_WF.Has_Activity', 1);
246: -- l_start_time := dbms_utility.get_time;
247:
248: -- Copying passed into locals
249: l_process := P_process;
250: l_process_item_type := P_process_item_type;
251: l_activity := P_activity;
252: l_activity_item_type := P_activity_item_type;
253:
254: oe_debug_pub.add('In H.A. Process '||l_process, 5);
255: oe_debug_pub.add('In H.A. Activity '||l_activity, 5);
256:
257: OPEN c_direct( l_process_item_type, l_process
258: , l_activity_item_type, l_activity) ;
251: l_activity := P_activity;
252: l_activity_item_type := P_activity_item_type;
253:
254: oe_debug_pub.add('In H.A. Process '||l_process, 5);
255: oe_debug_pub.add('In H.A. Activity '||l_activity, 5);
256:
257: OPEN c_direct( l_process_item_type, l_process
258: , l_activity_item_type, l_activity) ;
259: FETCH c_direct INTO l_instance_id;
259: FETCH c_direct INTO l_instance_id;
260:
261: IF c_direct%FOUND THEN
262: CLOSE c_direct;
263: oe_debug_pub.add('Return Status TRUE', 1);
264: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);
265: -- l_end_time := dbms_utility.get_time;
266: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
267: RETURN TRUE;
260:
261: IF c_direct%FOUND THEN
262: CLOSE c_direct;
263: oe_debug_pub.add('Return Status TRUE', 1);
264: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);
265: -- l_end_time := dbms_utility.get_time;
266: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
267: RETURN TRUE;
268: ELSE
262: CLOSE c_direct;
263: oe_debug_pub.add('Return Status TRUE', 1);
264: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);
265: -- l_end_time := dbms_utility.get_time;
266: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
267: RETURN TRUE;
268: ELSE
269: CLOSE c_direct;
270: END IF;
284: EXIT;
285: END IF;
286: END LOOP;
287:
288: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);
289: -- l_end_time := dbms_utility.get_time;
290: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
291: RETURN l_return_status;
292:
286: END LOOP;
287:
288: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);
289: -- l_end_time := dbms_utility.get_time;
290: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
291: RETURN l_return_status;
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: RAISE FND_API.G_EXC_ERROR;
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
298: WHEN OTHERS THEN
299: oe_debug_pub.add('Error in Has_Activity : '||Sqlerrm,5);
300: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
301: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
302: END IF;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: l_process_act_version NUMBER;
397:
398: BEGIN
399:
400: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Get_Activities', 5);
401: -- l_start_time := dbms_utility.get_time;
402:
403: -- Copying passed into locals
404: l_process := P_process;
405: l_process_item_type := P_process_item_type;
406: l_instance_label := P_instance_label;
407: l_activity_item_type := P_activity_item_type;
408:
409: oe_debug_pub.add('In G.A. process '||l_process, 5);
410: oe_debug_pub.add('In G.A. Instance_Label '||l_instance_label, 5);
411:
412: SELECT MAX(process_version)
413: INTO l_process_act_version
406: l_instance_label := P_instance_label;
407: l_activity_item_type := P_activity_item_type;
408:
409: oe_debug_pub.add('In G.A. process '||l_process, 5);
410: oe_debug_pub.add('In G.A. Instance_Label '||l_instance_label, 5);
411:
412: SELECT MAX(process_version)
413: INTO l_process_act_version
414: FROM wf_process_activities p1
448: , P_activity_item_type => l_activity_item_type -- acttype
449: );
450:
451: IF G_exit_from_loop = 'YES' THEN
452: oe_debug_pub.add('In G.A. Exiting from sub-recursion',5);
453: EXIT;
454: END IF;
455:
456: END LOOP;
454: END IF;
455:
456: END LOOP;
457: ELSE
458: oe_debug_pub.add('In G.A. Calling NO recursion',5);
459: END IF;
460: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Get_Activities', 5);
461: -- l_end_time := dbms_utility.get_time;
462: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
456: END LOOP;
457: ELSE
458: oe_debug_pub.add('In G.A. Calling NO recursion',5);
459: END IF;
460: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Get_Activities', 5);
461: -- l_end_time := dbms_utility.get_time;
462: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
463:
464: EXCEPTION
458: oe_debug_pub.add('In G.A. Calling NO recursion',5);
459: END IF;
460: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Get_Activities', 5);
461: -- l_end_time := dbms_utility.get_time;
462: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
463:
464: EXCEPTION
465: WHEN FND_API.G_EXC_ERROR THEN
466: RAISE FND_API.G_EXC_ERROR;
466: RAISE FND_API.G_EXC_ERROR;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469: WHEN OTHERS THEN
470: oe_debug_pub.add('Error in Get_Activities : '||Sqlerrm,5);
471: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
472: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
473: END IF;
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: l_mode_name VARCHAR2(30);
508: l_mode_text_value VARCHAR2(100);
509:
510: BEGIN
511: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
512: -- l_start_time := dbms_utility.get_time;
513:
514: X_return_status := FND_API.G_RET_STS_SUCCESS;
515:
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: l_text_value := NULL;
536: l_wait_mode_name := NULL;
537: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for WAIT_MODE', 1);
538: END;
539:
540: IF l_text_value = 'ABSOLUTE' THEN
541: BEGIN
547: AND name = 'WAIT_ABSOLUTE_DATE';
548: EXCEPTION
549: WHEN NO_DATA_FOUND THEN
550: l_mode_text_value := NULL;
551: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for ABSOLUTE DATE', 1);
552: END;
553:
554: ELSIF l_text_value = 'DAY_OF_MONTH' THEN
555: BEGIN
561: AND name = 'WAIT_DAY_OF_MONTH';
562: EXCEPTION
563: WHEN NO_DATA_FOUND THEN
564: l_mode_text_value := NULL;
565: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for DAY OF MONTH', 1);
566: END;
567:
568: ELSIF l_text_value = 'DAY_OF_WEEK' THEN
569: BEGIN
575: AND name = 'WAIT_DAY_OF_WEEK';
576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: l_mode_text_value := NULL;
579: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for DAY OF WEEK', 1);
580: END;
581:
582: ELSIF l_text_value = 'RELATIVE' THEN
583: BEGIN
589: AND name = 'WAIT_RELATIVE_TIME';
590: EXCEPTION
591: WHEN NO_DATA_FOUND THEN
592: l_mode_text_value := NULL;
593: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for RELATIVE TIME', 1);
594: END;
595:
596: ELSIF l_text_value = 'TIME' THEN
597: BEGIN
603: AND name = 'WAIT_TIME';
604: EXCEPTION
605: WHEN NO_DATA_FOUND THEN
606: l_mode_text_value := NULL;
607: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for WAIT TIME', 1);
608: END;
609: END IF;
610:
611: IF l_wait_mode_name = 'WAIT_MODE' AND l_text_value = 'ABSOLUTE' THEN
613: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_WAIT_ABS');
614: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_label);
615: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
616: OE_MSG_PUB.Add;
617: oe_debug_pub.add('LOG 1 : Added OE_WFVAL_WAIT_ABS',5);
618: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
619: -- l_end_time := dbms_utility.get_time;
620: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
621: RETURN;
614: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_label);
615: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
616: OE_MSG_PUB.Add;
617: oe_debug_pub.add('LOG 1 : Added OE_WFVAL_WAIT_ABS',5);
618: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
619: -- l_end_time := dbms_utility.get_time;
620: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
621: RETURN;
622:
616: OE_MSG_PUB.Add;
617: oe_debug_pub.add('LOG 1 : Added OE_WFVAL_WAIT_ABS',5);
618: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
619: -- l_end_time := dbms_utility.get_time;
620: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
621: RETURN;
622:
623: ELSIF (l_text_value = 'ABSOLUTE' AND l_mode_text_value > SYSDATE) OR
624: (l_text_value = 'DAY_OF_MONTH' AND l_mode_text_value IS NOT NULL) OR
625: (l_text_value = 'DAY_OF_WEEK' AND l_mode_text_value IS NOT NULL) OR
626: l_text_value NOT IN ('ABSOLUTE', 'DAY_OF_MONTH', 'DAY_OF_WEEK', 'RELATIVE') THEN -- not applicable
627:
628: -- Presently it is Not Applicable
629: oe_debug_pub.add('Presently not applicable');
630: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
631: -- l_end_time := dbms_utility.get_time;
632: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
633: RETURN;
626: l_text_value NOT IN ('ABSOLUTE', 'DAY_OF_MONTH', 'DAY_OF_WEEK', 'RELATIVE') THEN -- not applicable
627:
628: -- Presently it is Not Applicable
629: oe_debug_pub.add('Presently not applicable');
630: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
631: -- l_end_time := dbms_utility.get_time;
632: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
633: RETURN;
634: END IF;
628: -- Presently it is Not Applicable
629: oe_debug_pub.add('Presently not applicable');
630: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
631: -- l_end_time := dbms_utility.get_time;
632: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
633: RETURN;
634: END IF;
635: END IF; -- IF l_api
636:
636:
637: -- Here, it is assumed that the assigned api is [DEFER] or
638: -- [WAIT WITH RELATIVE TIME].
639:
640: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
641: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
642:
643: IF IN_LOOP
644: ( activity1 => l_activity_id
637: -- Here, it is assumed that the assigned api is [DEFER] or
638: -- [WAIT WITH RELATIVE TIME].
639:
640: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
641: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
642:
643: IF IN_LOOP
644: ( activity1 => l_activity_id
645: , activity2 => l_activity_id
654: AND name = 'WAIT_MODE';
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: l_text_value_relative := NULL;
658: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for WAIT_MODE with activity_id '||l_activity_id, 1);
659: END;
660:
661:
662: IF l_text_value_relative = 'RELATIVE' THEN
668: AND name = 'WAIT_RELATIVE_TIME';
669: EXCEPTION
670: WHEN NO_DATA_FOUND THEN
671: l_number_value := NULL;
672: oe_debug_pub.add('NO_DATA_FOUND in Wait_And_Loops for RELATIVE TIME with activity_id '||l_activity_id, 1);
673: END;
674: END IF; -- l_text_value_relative
675: END IF; -- l_api
676:
673: END;
674: END IF; -- l_text_value_relative
675: END IF; -- l_api
676:
677: oe_debug_pub.add('In W.A.L. : l_api '||l_api,5);
678: oe_debug_pub.add('In W.A.L. : l_test_value_relative '||l_text_value_relative,5);
679: oe_debug_pub.add('In W.A.L. : l_number_value '||l_number_value,5);
680: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
681: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
674: END IF; -- l_text_value_relative
675: END IF; -- l_api
676:
677: oe_debug_pub.add('In W.A.L. : l_api '||l_api,5);
678: oe_debug_pub.add('In W.A.L. : l_test_value_relative '||l_text_value_relative,5);
679: oe_debug_pub.add('In W.A.L. : l_number_value '||l_number_value,5);
680: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
681: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
682: -- l_api = 'WF_STANDARD.WAIT' AND Relative Time is > 0
675: END IF; -- l_api
676:
677: oe_debug_pub.add('In W.A.L. : l_api '||l_api,5);
678: oe_debug_pub.add('In W.A.L. : l_test_value_relative '||l_text_value_relative,5);
679: oe_debug_pub.add('In W.A.L. : l_number_value '||l_number_value,5);
680: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
681: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
682: -- l_api = 'WF_STANDARD.WAIT' AND Relative Time is > 0
683:
676:
677: oe_debug_pub.add('In W.A.L. : l_api '||l_api,5);
678: oe_debug_pub.add('In W.A.L. : l_test_value_relative '||l_text_value_relative,5);
679: oe_debug_pub.add('In W.A.L. : l_number_value '||l_number_value,5);
680: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
681: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
682: -- l_api = 'WF_STANDARD.WAIT' AND Relative Time is > 0
683:
684: IF (l_api = 'WF_STANDARD.WAIT')
677: oe_debug_pub.add('In W.A.L. : l_api '||l_api,5);
678: oe_debug_pub.add('In W.A.L. : l_test_value_relative '||l_text_value_relative,5);
679: oe_debug_pub.add('In W.A.L. : l_number_value '||l_number_value,5);
680: oe_debug_pub.add('In W.A.L. : l_text_value '||l_text_value,5);
681: oe_debug_pub.add('In W.A.L. : l_wait_mode_name '||l_wait_mode_name,5);
682: -- l_api = 'WF_STANDARD.WAIT' AND Relative Time is > 0
683:
684: IF (l_api = 'WF_STANDARD.WAIT')
685: AND (l_text_value_relative = 'RELATIVE')
690: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_LOOP_WNG');
691: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_label);
692: FND_MESSAGE.SET_TOKEN('PROCESS',Display_Name(l_process,l_process_item_type));
693: OE_MSG_PUB.Add;
694: oe_debug_pub.add('LOG 2 : Added OE_WFVAL_LOOP_WNG' ,1);
695:
696: ELSE
697:
698: -- The same code will get called even if the process is in
701: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_LOOP_ERR');
702: FND_MESSAGE.SET_TOKEN('ACTIVITY',l_activity_label);
703: FND_MESSAGE.SET_TOKEN('PROCESS',Display_Name(l_process,l_process_item_type));
704: OE_MSG_PUB.Add;
705: oe_debug_pub.add('LOG 3 : Added OE_WFVAL_LOOP_ERR' ,1);
706: -- Error for WAIT with Relative Time = 0 or DEFER
707: X_return_status := FND_API.G_RET_STS_ERROR;
708:
709: END IF; -- l_number_value
707: X_return_status := FND_API.G_RET_STS_ERROR;
708:
709: END IF; -- l_number_value
710:
711: oe_debug_pub.add('In W.A.L. : Not in Loop ',5);
712: END IF; -- in_loop
713:
714: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
715: -- l_end_time := dbms_utility.get_time;
710:
711: oe_debug_pub.add('In W.A.L. : Not in Loop ',5);
712: END IF; -- in_loop
713:
714: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
715: -- l_end_time := dbms_utility.get_time;
716: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
717:
718: EXCEPTION
712: END IF; -- in_loop
713:
714: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);
715: -- l_end_time := dbms_utility.get_time;
716: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
717:
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: RAISE FND_API.G_EXC_ERROR;
720: RAISE FND_API.G_EXC_ERROR;
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: WHEN OTHERS THEN
724: oe_debug_pub.add('Error in Wait_And_Loops : '||Sqlerrm,5);
725: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
726: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
727: END IF;
728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: l_start_time NUMBER;
758: l_end_time NUMBER;
759:
760: BEGIN
761: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Line_Flow_Assignment', 1);
762: --l_start_time := dbms_utility.get_time;
763:
764: -- Copying passed into locals
765: l_return_status := FND_API.G_RET_STS_SUCCESS;
766: l_msg_count := 0;
767: l_name := P_name;
768: l_item_type := P_item_type;
769:
770: oe_debug_pub.add(' In L.F.A. : l_name: '||l_name,5);
771: oe_debug_pub.add(' In L.F.A. : l_item_type: '||l_item_type,5);
772:
773: IF ( l_name = 'R_ATO_ITEM_LINE' )
774: AND ( l_item_type IS NULL OR l_item_type <> 'ATO_ITEM') THEN
767: l_name := P_name;
768: l_item_type := P_item_type;
769:
770: oe_debug_pub.add(' In L.F.A. : l_name: '||l_name,5);
771: oe_debug_pub.add(' In L.F.A. : l_item_type: '||l_item_type,5);
772:
773: IF ( l_name = 'R_ATO_ITEM_LINE' )
774: AND ( l_item_type IS NULL OR l_item_type <> 'ATO_ITEM') THEN
775: l_return_status := FND_API.G_RET_STS_ERROR;
816: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_ASSGN_ERR');
817: FND_MESSAGE.SET_TOKEN('PROCESS', Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
818: FND_MESSAGE.SET_TOKEN( 'ITEM_TYPE', NVL(l_item_type, 'STANDARD'));
819: OE_MSG_PUB.Add;
820: oe_debug_pub.add('LOG 4 : Added OE_WFVAL_ASSGN_ERR' ,1);
821:
822: ELSIF l_msg_count > 0 THEN
823: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_ASSGN_WNG');
824: FND_MESSAGE.SET_TOKEN('PROCESS',Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
824: FND_MESSAGE.SET_TOKEN('PROCESS',Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
825: -- FND_MESSAGE.SET_TOKEN('PROCESS',Display_Name(l_name,l_item_type)); #4617652
826: FND_MESSAGE.SET_TOKEN( 'ITEM_TYPE', NVL(l_item_type, 'STANDARD'));
827: OE_MSG_PUB.Add;
828: oe_debug_pub.add('LOG 5 : Added OE_WFVAL_ASSGN_WNG', 1);
829:
830: END IF;
831:
832: X_return_status := l_return_status;
830: END IF;
831:
832: X_return_status := l_return_status;
833: X_msg_count := l_msg_count;
834: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Line_Flow_Assignment', 1);
835: -- l_end_time := dbms_utility.get_time;
836: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
837:
838: EXCEPTION
832: X_return_status := l_return_status;
833: X_msg_count := l_msg_count;
834: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Line_Flow_Assignment', 1);
835: -- l_end_time := dbms_utility.get_time;
836: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
840: RAISE FND_API.G_EXC_ERROR;
840: RAISE FND_API.G_EXC_ERROR;
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: WHEN OTHERS THEN
844: oe_debug_pub.add('Error in Line_Flow_Assignment : '||Sqlerrm,5);
845: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
847: END IF;
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: l_type VARCHAR2(8);
920: l_instance_id NUMBER;
921:
922: BEGIN
923: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Check_Sync', 1);
924: -- l_start_time := dbms_utility.get_time;
925:
926: X_return_status := FND_API.G_RET_STS_SUCCESS;
927:
954: -- passed activity with CONTINUEFLOW function
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957: l_wait_text_default := NULL;
958: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Activity',1);
959: NULL;
960: WHEN OTHERS THEN
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
957: l_wait_text_default := NULL;
958: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Activity',1);
959: NULL;
960: WHEN OTHERS THEN
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
963: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
964: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
965: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
958: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Activity',1);
959: NULL;
960: WHEN OTHERS THEN
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
963: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
964: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
965: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
966: NULL;
959: NULL;
960: WHEN OTHERS THEN
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
963: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
964: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
965: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
966: NULL;
967: END;
960: WHEN OTHERS THEN
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
963: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
964: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
965: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
966: NULL;
967: END;
968:
961: oe_debug_pub.add('Check Sync WAITING ACTIVITY',1);
962: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
963: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
964: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
965: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
966: NULL;
967: END;
968:
969: BEGIN
981: -- the previous sql has a function of type WAITFORFLOW
982: EXCEPTION
983: WHEN NO_DATA_FOUND THEN
984: l_coresp_cont_act := 'NO';
985: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_cont_act',1);
986: NULL;
987: WHEN OTHERS THEN
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
984: l_coresp_cont_act := 'NO';
985: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_cont_act',1);
986: NULL;
987: WHEN OTHERS THEN
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
990: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
991: oe_debug_pub.add('Check Sync : l_wait_text_default : '||l_wait_text_default,1);
992: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
985: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_cont_act',1);
986: NULL;
987: WHEN OTHERS THEN
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
990: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
991: oe_debug_pub.add('Check Sync : l_wait_text_default : '||l_wait_text_default,1);
992: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
993: NULL;
986: NULL;
987: WHEN OTHERS THEN
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
990: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
991: oe_debug_pub.add('Check Sync : l_wait_text_default : '||l_wait_text_default,1);
992: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
993: NULL;
994: END;
987: WHEN OTHERS THEN
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
990: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
991: oe_debug_pub.add('Check Sync : l_wait_text_default : '||l_wait_text_default,1);
992: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
993: NULL;
994: END;
995:
988: oe_debug_pub.add('Check Sync l_coresp_cont_act',1);
989: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
990: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
991: oe_debug_pub.add('Check Sync : l_wait_text_default : '||l_wait_text_default,1);
992: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
993: NULL;
994: END;
995:
996: BEGIN
1004: -- [MASTER/DETAIL]
1005: EXCEPTION
1006: WHEN NO_DATA_FOUND THEN
1007: l_flow_name := NULL;
1008: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Flow',1);
1009: NULL;
1010: WHEN OTHERS THEN
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1007: l_flow_name := NULL;
1008: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Flow',1);
1009: NULL;
1010: WHEN OTHERS THEN
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1013: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1014: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1015: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1008: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Waiting Flow',1);
1009: NULL;
1010: WHEN OTHERS THEN
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1013: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1014: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1015: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1016: NULL;
1009: NULL;
1010: WHEN OTHERS THEN
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1013: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1014: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1015: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1016: NULL;
1017: END;
1010: WHEN OTHERS THEN
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1013: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1014: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1015: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1016: NULL;
1017: END;
1018: -- Assigning Act attributes WAITING_ACTIVITY to matching
1011: oe_debug_pub.add('Check Sync WAITING_FLOW',1);
1012: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1013: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1014: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1015: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1016: NULL;
1017: END;
1018: -- Assigning Act attributes WAITING_ACTIVITY to matching
1019: -- activity. Assigning 'WAIT' to l_w_c, to determine the
1026: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1027: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_instance_label);
1028: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
1029: OE_MSG_PUB.Add;
1030: oe_debug_pub.add('LOG 6 : Added OE_WFVAL_SYNC_DEF' ,1);
1031: -- incorrect synchronization activity definition
1032: X_return_status := FND_API.G_RET_STS_ERROR;
1033: END IF;
1034:
1038: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_instance_label);
1039: --l_all_activity_tbl(l_instance).instance_label
1040: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
1041: OE_MSG_PUB.Add;
1042: oe_debug_pub.add('LOG 7 : Added OE_WFVAL_SYNC_DEF', 1);
1043: -- Added message OE_WFVAL_SYNC_DEF;
1044: X_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF; -- l_process_item_type
1057: -- passed activity with WAITFORFLOW function
1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: l_cont_text_default := NULL;
1061: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1062: NULL;
1063: WHEN OTHERS THEN
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1060: l_cont_text_default := NULL;
1061: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1062: NULL;
1063: WHEN OTHERS THEN
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1066: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1067: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1068: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1061: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1062: NULL;
1063: WHEN OTHERS THEN
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1066: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1067: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1068: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1069: NULL;
1062: NULL;
1063: WHEN OTHERS THEN
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1066: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1067: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1068: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1069: NULL;
1070: END;
1063: WHEN OTHERS THEN
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1066: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1067: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1068: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1069: NULL;
1070: END;
1071:
1064: oe_debug_pub.add('Check Sync CONTINUATION_ACTIVITY ',1);
1065: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1066: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1067: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1068: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1069: NULL;
1070: END;
1071:
1072: BEGIN
1084: -- given by the previous sql has a function of type CONTINUEFLOW
1085: EXCEPTION
1086: WHEN NO_DATA_FOUND THEN
1087: l_coresp_wait_act := 'NO';
1088: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_wait_act',1);
1089: NULL;
1090: WHEN OTHERS THEN
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1087: l_coresp_wait_act := 'NO';
1088: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_wait_act',1);
1089: NULL;
1090: WHEN OTHERS THEN
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1093: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1094: oe_debug_pub.add('Check Sync : l_cont_text_default : '||l_cont_text_default,1);
1095: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1088: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for l_coresp_wait_act',1);
1089: NULL;
1090: WHEN OTHERS THEN
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1093: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1094: oe_debug_pub.add('Check Sync : l_cont_text_default : '||l_cont_text_default,1);
1095: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1096: NULL;
1089: NULL;
1090: WHEN OTHERS THEN
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1093: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1094: oe_debug_pub.add('Check Sync : l_cont_text_default : '||l_cont_text_default,1);
1095: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1096: NULL;
1097: END;
1090: WHEN OTHERS THEN
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1093: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1094: oe_debug_pub.add('Check Sync : l_cont_text_default : '||l_cont_text_default,1);
1095: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1096: NULL;
1097: END;
1098:
1091: oe_debug_pub.add('Check Sync l_coresp_wait_act',1);
1092: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1093: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1094: oe_debug_pub.add('Check Sync : l_cont_text_default : '||l_cont_text_default,1);
1095: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1096: NULL;
1097: END;
1098:
1099: BEGIN
1106: -- [MASTER/DETAIL]
1107: EXCEPTION
1108: WHEN NO_DATA_FOUND THEN
1109: l_flow_name := NULL;
1110: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1111: NULL;
1112: WHEN OTHERS THEN
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1109: l_flow_name := NULL;
1110: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1111: NULL;
1112: WHEN OTHERS THEN
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1115: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1116: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1117: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1110: oe_debug_pub.add('NO_DATA_FOUND in Check Sync for Continue Flow',1);
1111: NULL;
1112: WHEN OTHERS THEN
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1115: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1116: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1117: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1118: NULL;
1111: NULL;
1112: WHEN OTHERS THEN
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1115: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1116: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1117: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1118: NULL;
1119: END;
1112: WHEN OTHERS THEN
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1115: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1116: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1117: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1118: NULL;
1119: END;
1120:
1113: oe_debug_pub.add('Check Sync CONTINUATION_FLOW',1);
1114: oe_debug_pub.add('Check Sync : Line_process : '||l_process,1);
1115: oe_debug_pub.add('Check Sync : Header_process : '||l_order_flow,1);
1116: oe_debug_pub.add('Check Sync : Activity Name : '||l_instance_label,1);
1117: oe_debug_pub.add('Check Sync : Error : '||sqlerrm,1);
1118: NULL;
1119: END;
1120:
1121: -- Assigning Act attributes CONTINUATION_ACTIVITY to matching
1129: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1130: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_instance_label);
1131: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
1132: OE_MSG_PUB.Add;
1133: oe_debug_pub.add('LOG 8 : Added OE_WFVAL_SYNC_DEF',1);
1134: X_return_status := FND_API.G_RET_STS_ERROR;
1135: END IF;
1136:
1137: ELSIF l_process_item_type = OE_GLOBALS.G_WFI_LIN THEN
1139: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1140: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_instance_label);
1141: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_process,l_process_item_type));
1142: OE_MSG_PUB.Add;
1143: oe_debug_pub.add('LOG 9 : Added OE_WFVAL_SYNC_DEF' ,1);
1144: X_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146: END IF; -- l_process_item_type
1147:
1148: END IF; -- l_all_activity_tbl(l_instance).API assignment
1149:
1150: IF l_matching_activity IS NOT NULL THEN
1151:
1152: oe_debug_pub.add('In C.S. Matching Activity is not null',1);
1153: IF l_process_item_type = OE_GLOBALS.G_WFI_HDR THEN
1154: -- Selecting distinct order line workflow processes assigned
1155: -- to p_order_type
1156: OPEN c_all_line_flows(l_order_type_id);
1177: );
1178:
1179: l_line_activity_tbl := G_all_activity_tbl;
1180:
1181: oe_debug_pub.add('C.S. Line Act tbl COUNT : '||l_line_activity_tbl.COUNT,1);
1182:
1183: IF l_line_activity_tbl.COUNT = 0 THEN
1184: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
1185: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_line_process,OE_GLOBALS.G_WFI_LIN));
1186: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_matching_activity);
1187: FND_MESSAGE.SET_TOKEN('ACTIVITY2', l_instance_label);
1188: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_process,l_process_item_type));
1189: OE_MSG_PUB.Add;
1190: oe_debug_pub.add('Check_Sync : LOG 10i : Added OE_WFVAL_SYNC_MISS',1);
1191: X_return_status := FND_API.G_RET_STS_ERROR;
1192:
1193: ELSE
1194: -- Important: If with the above cases, there exists no activity in a
1207: l_wfval_out_of_sync := 'NO';
1208: END IF;
1209: END LOOP;
1210:
1211: oe_debug_pub.add('In C.S. l_wfval_out_of_sync is : '||l_wfval_out_of_sync,5);
1212: IF l_wfval_out_of_sync = 'YES' THEN
1213: -- IF NOT Each selected process contains, on some level,
1214: -- instance_label = l_matching_activity THEN
1215: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
1217: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_matching_activity);
1218: FND_MESSAGE.SET_TOKEN('ACTIVITY2', l_instance_label);
1219: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_process,l_process_item_type));
1220: OE_MSG_PUB.Add;
1221: oe_debug_pub.add('LOG 10 : Added OE_WFVAL_SYNC_MISS',1);
1222: -- synchronization activity missing its counterpart
1223: -- activity
1224: X_return_status := FND_API.G_RET_STS_ERROR;
1225: END IF;
1246: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1247: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_matching_activity);
1248: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_line_process,OE_GLOBALS.G_WFI_LIN));
1249: OE_MSG_PUB.Add;
1250: oe_debug_pub.add('LOG 11 : Added OE_WFVAL_SYNC_DEF',1);
1251: X_return_status := FND_API.G_RET_STS_ERROR;
1252: END IF;
1253:
1254: ELSIF l_w_c = 'WAIT' THEN
1263: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1264: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_matching_activity);
1265: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_line_process,OE_GLOBALS.G_WFI_LIN));
1266: OE_MSG_PUB.Add;
1267: oe_debug_pub.add('LOG 12 : Added OE_WFVAL_SYNC_DEF',1 );
1268: X_return_status := FND_API.G_RET_STS_ERROR;
1269: END IF;
1270: END IF; -- l_w_c
1271: END IF; -- l_matching_activity
1289: , P_activity_item_type => OE_GLOBALS.G_WFI_HDR
1290: );
1291:
1292: l_header_activity_tbl := G_all_activity_tbl;
1293: oe_debug_pub.add('C.S. Hdr Act tbl COUNT : '||l_header_activity_tbl.COUNT,1);
1294: l_wfval_out_of_sync := NULL;
1295:
1296: IF l_header_activity_tbl.COUNT = 0 THEN
1297: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
1299: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_matching_activity);
1300: FND_MESSAGE.SET_TOKEN('ACTIVITY2', l_instance_label);
1301: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_process,l_process_item_type));
1302: OE_MSG_PUB.Add;
1303: oe_debug_pub.add('Check_Sync : LOG 13i : Added OE_WFVAL_SYNC_MISS',1);
1304: -- synchronization activity missing its counterpart activity;
1305: X_return_status := FND_API.G_RET_STS_ERROR;
1306: ELSIF l_header_activity_tbl.COUNT > 0 THEN
1307:
1317: END IF;
1318: END LOOP;
1319: END IF; -- l_header_activity_tbl
1320:
1321: oe_debug_pub.add('In C.S. l_wfval_out_of_sync is : '||l_wfval_out_of_sync,5);
1322: IF l_wfval_out_of_sync = 'YES' THEN
1323: -- IF NOT l_order_flow contains instance_label =
1324: -- l_matching_activity THEN
1325: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
1327: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_matching_activity);
1328: FND_MESSAGE.SET_TOKEN('ACTIVITY2', l_instance_label);
1329: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_process,l_process_item_type));
1330: OE_MSG_PUB.Add;
1331: oe_debug_pub.add('LOG 13 : Added OE_WFVAL_SYNC_MISS' ,1);
1332: -- synchronization activity missing its counterpart activity;
1333: X_return_status := FND_API.G_RET_STS_ERROR;
1334: END IF;
1335:
1350: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1351: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL',l_matching_activity);
1352: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_order_flow,OE_GLOBALS.G_WFI_HDR));
1353: OE_MSG_PUB.Add;
1354: oe_debug_pub.add('LOG 14 : Added OE_WFVAL_SYNC_DEF' ,1);
1355: X_return_status := FND_API.G_RET_STS_ERROR;
1356: END IF;
1357:
1358: ELSIF l_w_c = 'WAIT' THEN
1367: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
1368: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_matching_activity);
1369: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_order_flow,OE_GLOBALS.G_WFI_HDR));
1370: OE_MSG_PUB.Add;
1371: oe_debug_pub.add('LOG 15 : Added OE_WFVAL_SYNC_DEF',1 );
1372: X_return_status := FND_API.G_RET_STS_ERROR;
1373: END IF;
1374: END IF; -- l_w_c
1375:
1379: END IF; -- l_order_flow
1380: END IF; -- l_process_item_type
1381: END IF; -- l_matching_activity
1382:
1383: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Check_Sync', 1);
1384: -- l_end_time := dbms_utility.get_time;
1385: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1386:
1387: EXCEPTION
1381: END IF; -- l_matching_activity
1382:
1383: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Check_Sync', 1);
1384: -- l_end_time := dbms_utility.get_time;
1385: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1386:
1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
1389: RAISE FND_API.G_EXC_ERROR;
1389: RAISE FND_API.G_EXC_ERROR;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: WHEN OTHERS THEN
1393: oe_debug_pub.add('Error in Check Sync : '||Sqlerrm,5);
1394: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1395: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
1396: END IF;
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1423: l_end_time NUMBER;
1424: -- l_start_end VARCHAR2(8);
1425:
1426: BEGIN
1427: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Out_Transitions', 1);
1428: -- l_start_time := dbms_utility.get_time;
1429: X_return_status := FND_API.G_RET_STS_SUCCESS;
1430:
1431: -- Copying passed into locals
1445: , P_activity_item_type => NULL
1446: );
1447: l_all_activity_tbl := G_all_activity_tbl;
1448:
1449: oe_debug_pub.add(' In O.T. l_all_activity_tbl.COUNT is : '||l_all_activity_tbl.COUNT ,5);
1450: IF l_all_activity_tbl.COUNT > 0 THEN
1451: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1452: IF NOT (NVL(l_all_activity_tbl(l_instance).start_end, 'N') = WF_ENGINE.ENG_END) THEN
1453: oe_debug_pub.add(' In O.T. Instance_Label is : '||l_all_activity_tbl(l_instance).instance_label,5);
1449: oe_debug_pub.add(' In O.T. l_all_activity_tbl.COUNT is : '||l_all_activity_tbl.COUNT ,5);
1450: IF l_all_activity_tbl.COUNT > 0 THEN
1451: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1452: IF NOT (NVL(l_all_activity_tbl(l_instance).start_end, 'N') = WF_ENGINE.ENG_END) THEN
1453: oe_debug_pub.add(' In O.T. Instance_Label is : '||l_all_activity_tbl(l_instance).instance_label,5);
1454: oe_debug_pub.add(' In O.T. Activity start_end : '||l_all_activity_tbl(l_instance).start_end,5);
1455: BEGIN
1456: SELECT 'Y'
1457: INTO l_from_process_activity_exists
1450: IF l_all_activity_tbl.COUNT > 0 THEN
1451: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1452: IF NOT (NVL(l_all_activity_tbl(l_instance).start_end, 'N') = WF_ENGINE.ENG_END) THEN
1453: oe_debug_pub.add(' In O.T. Instance_Label is : '||l_all_activity_tbl(l_instance).instance_label,5);
1454: oe_debug_pub.add(' In O.T. Activity start_end : '||l_all_activity_tbl(l_instance).start_end,5);
1455: BEGIN
1456: SELECT 'Y'
1457: INTO l_from_process_activity_exists
1458: FROM wf_activity_transitions
1461: AND ROWNUM = 1;
1462: EXCEPTION
1463: WHEN NO_DATA_FOUND THEN
1464: l_from_process_activity_exists := 'N';
1465: oe_debug_pub.add('O.T. Process Activity do not exists',1);
1466: oe_debug_pub.add('O.T. Activity Name : '||l_all_activity_tbl(l_instance).activity_name,1);
1467: oe_debug_pub.add('O.T. From instance_id : '||l_all_activity_tbl(l_instance).instance_id,1);
1468: NULL;
1469: WHEN OTHERS THEN
1462: EXCEPTION
1463: WHEN NO_DATA_FOUND THEN
1464: l_from_process_activity_exists := 'N';
1465: oe_debug_pub.add('O.T. Process Activity do not exists',1);
1466: oe_debug_pub.add('O.T. Activity Name : '||l_all_activity_tbl(l_instance).activity_name,1);
1467: oe_debug_pub.add('O.T. From instance_id : '||l_all_activity_tbl(l_instance).instance_id,1);
1468: NULL;
1469: WHEN OTHERS THEN
1470: oe_debug_pub.add('Error O.T. '||sqlerrm,1);
1463: WHEN NO_DATA_FOUND THEN
1464: l_from_process_activity_exists := 'N';
1465: oe_debug_pub.add('O.T. Process Activity do not exists',1);
1466: oe_debug_pub.add('O.T. Activity Name : '||l_all_activity_tbl(l_instance).activity_name,1);
1467: oe_debug_pub.add('O.T. From instance_id : '||l_all_activity_tbl(l_instance).instance_id,1);
1468: NULL;
1469: WHEN OTHERS THEN
1470: oe_debug_pub.add('Error O.T. '||sqlerrm,1);
1471: NULL;
1466: oe_debug_pub.add('O.T. Activity Name : '||l_all_activity_tbl(l_instance).activity_name,1);
1467: oe_debug_pub.add('O.T. From instance_id : '||l_all_activity_tbl(l_instance).instance_id,1);
1468: NULL;
1469: WHEN OTHERS THEN
1470: oe_debug_pub.add('Error O.T. '||sqlerrm,1);
1471: NULL;
1472: END;
1473:
1474: IF (l_from_process_activity_exists = 'N') THEN
1475: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_NO_OUT_TRANS');
1476: FND_MESSAGE.SET_TOKEN('ACTIVITY_LABEL', l_all_activity_tbl(l_instance).instance_label);
1477: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
1478: OE_MSG_PUB.Add;
1479: oe_debug_pub.add('LOG 16 : Added OE_WFVAL_NO_OUT_TRANS',1 );
1480: X_return_status := FND_API.G_RET_STS_ERROR;
1481: END IF;
1482: END IF; -- IF start_end <> WF_ENGINE.ENG_END
1483: END LOOP;
1482: END IF; -- IF start_end <> WF_ENGINE.ENG_END
1483: END LOOP;
1484: END IF; -- COUNT > 0
1485:
1486: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Out_Transitions', 1);
1487: -- l_end_time := dbms_utility.get_time;
1488: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1489:
1490: EXCEPTION
1484: END IF; -- COUNT > 0
1485:
1486: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Out_Transitions', 1);
1487: -- l_end_time := dbms_utility.get_time;
1488: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1489:
1490: EXCEPTION
1491: WHEN FND_API.G_EXC_ERROR THEN
1492: RAISE FND_API.G_EXC_ERROR;
1492: RAISE FND_API.G_EXC_ERROR;
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: WHEN OTHERS THEN
1496: oe_debug_pub.add('Error in Out_Transitions : '||Sqlerrm);
1497: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1498: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
1499: END IF;
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1550: l_activity VARCHAR2(30);
1551: matching_activity_exists BOOLEAN := FALSE;
1552:
1553: BEGIN
1554: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);
1555: -- l_start_time := dbms_utility.get_time;
1556: X_return_status := FND_API.G_RET_STS_SUCCESS;
1557: l_msg_count := OE_MSG_PUB.count_msg;
1558:
1562: l_order_flow := P_order_flow;
1563: l_errors_only := p_quick_val;
1564: l_fulfill_act_exists := 'N';
1565:
1566: oe_debug_pub.add('Calling Out Transitions from Validate Line Flow',5);
1567: OE_VALIDATE_WF.OUT_TRANSITIONS
1568: ( P_name => l_name
1569: , P_type => OE_GLOBALS.G_WFI_LIN
1570: , X_return_status => l_return_status
1580: G_all_activity_tbl.DELETE;
1581: G_exit_from_loop := 'NO';
1582: l_attr_first_time := NULL;
1583:
1584: oe_debug_pub.add('Calling Get Activities for Lines from Validate Line Flow',5);
1585: Get_Activities
1586: ( P_process => l_name
1587: , P_process_item_type => l_type
1588: , P_instance_label => NULL
1628: , fulfill_attributes.FulfillAttr);
1629: FND_MESSAGE.SET_TOKEN('FULFILL_LINE'
1630: , l_all_activity_tbl(l_instance).instance_label);
1631: OE_MSG_PUB.Add;
1632: oe_debug_pub.add('LOG 17: Add OE_WFVAL_NO_FULFILL_ACT',1);
1633: X_return_status := FND_API.G_RET_STS_ERROR;
1634:
1635: ELSIF NOT l_errors_only THEN
1636: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_ACT_ORDER');
1639: , fulfill_attributes.FulfillAttr);
1640: FND_MESSAGE.SET_TOKEN('ACTIVITY2'
1641: , l_all_activity_tbl(l_instance).instance_label);
1642: OE_MSG_PUB.Add;
1643: oe_debug_pub.add('LOG 18 : Added OE_WFVAL_ACT_ORDER' ,1);
1644: END IF; -- HAS_ACTIVITY
1645: END IF; -- l_continue_further
1646: END IF; -- fulfill_attributes.FulfillAttr
1647:
1645: END IF; -- l_continue_further
1646: END IF; -- fulfill_attributes.FulfillAttr
1647:
1648: END LOOP; -- fulfill_attributes
1649: oe_debug_pub.add('Fulfill attributes are : '||l_attr_first_time,5);
1650:
1651: END IF; -- l_all_activity_tbl = FULFILL_LINE
1652: END LOOP; -- l_instance
1653: END IF; -- COUNT > 0
1653: END IF; -- COUNT > 0
1654: -- IF no FULFILL_LINE activity was detected in the above step AND
1655: -- NOT l_errors_only then adding message OE_WFVAL_MISSING_ACTIVITY
1656:
1657: oe_debug_pub.add('Fulfill Activity Exists (Y/N) : '||l_fulfill_act_exists,5);
1658:
1659: IF l_fulfill_act_exists = 'N' AND NOT l_errors_only THEN
1660: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_MISSING_ACTIVITY');
1661: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
1660: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_MISSING_ACTIVITY');
1661: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
1662: FND_MESSAGE.SET_TOKEN('ACTIVITY_NAME','FULFILL_LINE');
1663: OE_MSG_PUB.Add;
1664: oe_debug_pub.add('LOG 19 : Added OE_WFVAL_MISSING_ACTIVITY',1);
1665: END IF;
1666:
1667: IF l_errors_only THEN
1668:
1669: BEGIN
1670:
1671: G_all_activity_tbl.DELETE;
1672: G_exit_from_loop := 'NO';
1673: oe_debug_pub.add('Calling Get Activities for Header in Validate Order Line',5);
1674:
1675: Get_Activities
1676: ( P_process => l_order_flow
1677: , P_process_item_type => OE_GLOBALS.G_WFI_HDR
1691: /* Bug # 4908592 Start */
1692: (NVL(p_item_type, 'NULL') <> 'CONFIGURATION' AND
1693: l_hdr_activity_tbl(hdr_instance).activity_name = 'BOOK_CONT_L') THEN
1694: /* Bug # 4908592 End */
1695: oe_debug_pub.add('In VLF : for Act '||l_hdr_activity_tbl(hdr_instance).activity_name,5);
1696: oe_debug_pub.add('In VLF : for function '||l_hdr_activity_tbl(hdr_instance).function,5);
1697: oe_debug_pub.add('In VLF : for instance_id '||l_hdr_activity_tbl(hdr_instance).instance_id,5);
1698:
1699: IF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
1692: (NVL(p_item_type, 'NULL') <> 'CONFIGURATION' AND
1693: l_hdr_activity_tbl(hdr_instance).activity_name = 'BOOK_CONT_L') THEN
1694: /* Bug # 4908592 End */
1695: oe_debug_pub.add('In VLF : for Act '||l_hdr_activity_tbl(hdr_instance).activity_name,5);
1696: oe_debug_pub.add('In VLF : for function '||l_hdr_activity_tbl(hdr_instance).function,5);
1697: oe_debug_pub.add('In VLF : for instance_id '||l_hdr_activity_tbl(hdr_instance).instance_id,5);
1698:
1699: IF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
1700: BEGIN
1693: l_hdr_activity_tbl(hdr_instance).activity_name = 'BOOK_CONT_L') THEN
1694: /* Bug # 4908592 End */
1695: oe_debug_pub.add('In VLF : for Act '||l_hdr_activity_tbl(hdr_instance).activity_name,5);
1696: oe_debug_pub.add('In VLF : for function '||l_hdr_activity_tbl(hdr_instance).function,5);
1697: oe_debug_pub.add('In VLF : for instance_id '||l_hdr_activity_tbl(hdr_instance).instance_id,5);
1698:
1699: IF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
1700: BEGIN
1701: SELECT text_value
1707: -- passed activity with CONTINUEFLOW function
1708: EXCEPTION
1709: WHEN NO_DATA_FOUND THEN
1710: l_activity := NULL;
1711: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
1712: NULL;
1713: WHEN OTHERS THEN
1714: oe_debug_pub.add('Validate_Line_Flow WAITING ACTIVITY',1);
1715: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1710: l_activity := NULL;
1711: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
1712: NULL;
1713: WHEN OTHERS THEN
1714: oe_debug_pub.add('Validate_Line_Flow WAITING ACTIVITY',1);
1715: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1716: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1717: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1718: NULL;
1711: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
1712: NULL;
1713: WHEN OTHERS THEN
1714: oe_debug_pub.add('Validate_Line_Flow WAITING ACTIVITY',1);
1715: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1716: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1717: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1718: NULL;
1719: END;
1712: NULL;
1713: WHEN OTHERS THEN
1714: oe_debug_pub.add('Validate_Line_Flow WAITING ACTIVITY',1);
1715: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1716: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1717: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1718: NULL;
1719: END;
1720:
1713: WHEN OTHERS THEN
1714: oe_debug_pub.add('Validate_Line_Flow WAITING ACTIVITY',1);
1715: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1716: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1717: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1718: NULL;
1719: END;
1720:
1721: ELSIF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN
1729: -- passed activity with WAITFORFLOW function
1730: EXCEPTION
1731: WHEN NO_DATA_FOUND THEN
1732: l_activity := NULL;
1733: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
1734: NULL;
1735: WHEN OTHERS THEN
1736: oe_debug_pub.add('Validate_Line_Flow CONTINUATION_ACTIVITY',1);
1737: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1732: l_activity := NULL;
1733: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
1734: NULL;
1735: WHEN OTHERS THEN
1736: oe_debug_pub.add('Validate_Line_Flow CONTINUATION_ACTIVITY',1);
1737: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1738: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1739: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1740: NULL;
1733: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
1734: NULL;
1735: WHEN OTHERS THEN
1736: oe_debug_pub.add('Validate_Line_Flow CONTINUATION_ACTIVITY',1);
1737: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1738: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1739: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1740: NULL;
1741: END;
1734: NULL;
1735: WHEN OTHERS THEN
1736: oe_debug_pub.add('Validate_Line_Flow CONTINUATION_ACTIVITY',1);
1737: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1738: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1739: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1740: NULL;
1741: END;
1742: END IF;
1735: WHEN OTHERS THEN
1736: oe_debug_pub.add('Validate_Line_Flow CONTINUATION_ACTIVITY',1);
1737: oe_debug_pub.add('Validate_Line_Flow : Header_process : '||l_order_flow,1);
1738: oe_debug_pub.add('Validate_Line_Flow : Activity Name : '||l_hdr_activity_tbl(hdr_instance).instance_label,1);
1739: oe_debug_pub.add('Validate_Line_Flow : Error : '||sqlerrm,1);
1740: NULL;
1741: END;
1742: END IF;
1743:
1740: NULL;
1741: END;
1742: END IF;
1743:
1744: oe_debug_pub.add('In VLF : Matching Activity is : '||l_activity,5);
1745: matching_activity_exists := FALSE;
1746: IF l_activity IS NOT NULL THEN
1747: IF l_all_activity_tbl.COUNT > 0 THEN
1748: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1755: END IF;
1756:
1757: IF (matching_activity_exists <> TRUE) THEN
1758:
1759: oe_debug_pub.add('In VLF : Matching activity do not exists, logging message',1);
1760:
1761: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
1762: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
1763: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_activity);
1775: NULL;
1776: END;
1777:
1778:
1779: oe_debug_pub.add('In VLF : Done with a/c flows check',5);
1780: oe_debug_pub.add('In VLF : Starting check sync for quick validation TRUE',5);
1781:
1782: IF l_all_activity_tbl.COUNT > 0 THEN
1783: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1776: END;
1777:
1778:
1779: oe_debug_pub.add('In VLF : Done with a/c flows check',5);
1780: oe_debug_pub.add('In VLF : Starting check sync for quick validation TRUE',5);
1781:
1782: IF l_all_activity_tbl.COUNT > 0 THEN
1783: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1784: IF l_all_activity_tbl(testing_instance).activity_name IN
1783: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1784: IF l_all_activity_tbl(testing_instance).activity_name IN
1785: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
1786: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
1787: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1788: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1789: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1790:
1791: OE_VALIDATE_WF.CHECK_SYNC
1784: IF l_all_activity_tbl(testing_instance).activity_name IN
1785: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
1786: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
1787: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1788: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1789: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1790:
1791: OE_VALIDATE_WF.CHECK_SYNC
1792: ( P_process => l_name
1785: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
1786: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
1787: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1788: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1789: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1790:
1791: OE_VALIDATE_WF.CHECK_SYNC
1792: ( P_process => l_name
1793: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1810: END LOOP; -- testing_instance
1811: END IF; -- l_all_activity_tbl.COUNT
1812: END IF; -- l_errors_only
1813:
1814: oe_debug_pub.add('In VLF : Starting check sync for quick validation FALSE',5);
1815: IF NOT l_errors_only THEN
1816: IF l_all_activity_tbl.COUNT > 0 THEN --Vaibhav
1817: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1818: IF l_all_activity_tbl(testing_instance).function IN
1816: IF l_all_activity_tbl.COUNT > 0 THEN --Vaibhav
1817: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1818: IF l_all_activity_tbl(testing_instance).function IN
1819: ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
1820: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1821: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1822: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1823:
1824: OE_VALIDATE_WF.CHECK_SYNC
1817: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
1818: IF l_all_activity_tbl(testing_instance).function IN
1819: ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
1820: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1821: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1822: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1823:
1824: OE_VALIDATE_WF.CHECK_SYNC
1825: ( P_process => l_name
1818: IF l_all_activity_tbl(testing_instance).function IN
1819: ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
1820: oe_debug_pub.add('In VLF : For Instance Label '||l_all_activity_tbl(testing_instance).instance_label,5);
1821: oe_debug_pub.add('In VLF : For Instance Id '||l_all_activity_tbl(testing_instance).instance_id,5);
1822: oe_debug_pub.add('In VLF : For function '||l_all_activity_tbl(testing_instance).function,5);
1823:
1824: OE_VALIDATE_WF.CHECK_SYNC
1825: ( P_process => l_name
1826: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1843: END IF;
1844: END LOOP;
1845: END IF;
1846:
1847: oe_debug_pub.add('In VLF : Calling Has Activity for CLOSE_LINE in process : '||l_name,5);
1848: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY
1849: ( P_process => l_name
1850: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1851: , P_activity => 'CLOSE_LINE'
1855: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_MISSING_ACTIVITY');
1856: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
1857: FND_MESSAGE.SET_TOKEN('ACTIVITY_NAME','CLOSE_LINE');
1858: OE_MSG_PUB.Add;
1859: oe_debug_pub.add('LOG 20 : OE_WFVAL_MISSING_ACTIVITY',1);
1860: END IF;
1861:
1862: -- Activities in process p_name assigned APIs
1863: -- wf_standard.defer or wf_standard.wait */
1865: IF l_all_activity_tbl(l_all_instance).function= 'WF_STANDARD.DEFER'
1866: OR l_all_activity_tbl(l_all_instance).function = 'WF_STANDARD.WAIT'
1867: THEN
1868:
1869: oe_debug_pub.add('In VLF : Calling Wait And Loops for instance_label '||l_all_activity_tbl(l_all_instance).instance_label,5);
1870: oe_debug_pub.add('In VLF : Calling Wait And Loops for instance_id '||l_all_activity_tbl(l_all_instance).instance_id,5);
1871:
1872: OE_VALIDATE_WF.WAIT_AND_LOOPS
1873: ( P_process => l_name
1866: OR l_all_activity_tbl(l_all_instance).function = 'WF_STANDARD.WAIT'
1867: THEN
1868:
1869: oe_debug_pub.add('In VLF : Calling Wait And Loops for instance_label '||l_all_activity_tbl(l_all_instance).instance_label,5);
1870: oe_debug_pub.add('In VLF : Calling Wait And Loops for instance_id '||l_all_activity_tbl(l_all_instance).instance_id,5);
1871:
1872: OE_VALIDATE_WF.WAIT_AND_LOOPS
1873: ( P_process => l_name
1874: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1885: END IF;
1886: END IF; -- function = DEFER/WAIT
1887: END LOOP; -- l_all_instance
1888:
1889: oe_debug_pub.add('In VLF : Calling Has Activity for INVOICE_INTERFACE and SHIP_LINE in process : '||l_name,5);
1890: IF OE_VALIDATE_WF.HAS_ACTIVITY
1891: ( P_process => l_name
1892: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1893: , P_activity => 'SHIP_LINE'
1905: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
1906: FND_MESSAGE.SET_TOKEN('ACTIVITY1','SHIP_LINE');
1907: FND_MESSAGE.SET_TOKEN('ACTIVITY2','INVOICE_INTERFACE');
1908: OE_MSG_PUB.Add;
1909: oe_debug_pub.add('LOG 21 : Added OE_WFVAL_ACT_ORDER' ,1) ;
1910: END IF;
1911: END IF; -- NOT l_errors_only
1912:
1913: X_msg_count := OE_MSG_PUB.count_msg - l_msg_count;
1910: END IF;
1911: END IF; -- NOT l_errors_only
1912:
1913: X_msg_count := OE_MSG_PUB.count_msg - l_msg_count;
1914: oe_debug_pub.add('In VLF : msg count : '||X_msg_count,5);
1915:
1916: IF x_msg_count > 0 THEN
1917: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);
1918: END IF;
1916: IF x_msg_count > 0 THEN
1917: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);
1918: END IF;
1919:
1920: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);
1921: --l_end_time := dbms_utility.get_time;
1922: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1923:
1924: EXCEPTION
1918: END IF;
1919:
1920: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);
1921: --l_end_time := dbms_utility.get_time;
1922: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
1923:
1924: EXCEPTION
1925: --WHEN FND_API.G_EXC_ERROR THEN
1926: -- RAISE FND_API.G_EXC_ERROR;
1924: EXCEPTION
1925: --WHEN FND_API.G_EXC_ERROR THEN
1926: -- RAISE FND_API.G_EXC_ERROR;
1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1928: oe_debug_pub.add('Error in Validate_Line_Flow : '||sqlerrm,5);
1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1930: WHEN OTHERS THEN
1931: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1932: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
1998: -- l_activity_sum VARCHAR2(120);
1999: matching_activity_exists BOOLEAN := FALSE;
2000:
2001: BEGIN
2002: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);
2003: -- l_start_time := dbms_utility.get_time;
2004: X_return_status := FND_API.G_RET_STS_SUCCESS;
2005: l_msg_count := OE_MSG_PUB.count_msg;
2006:
2009: l_type := P_type;
2010: l_order_type_id := P_order_type_id;
2011: l_quick_val := p_quick_val;
2012:
2013: oe_debug_pub.add('Calling Out Transition from Validate Order Flow',5);
2014: OE_VALIDATE_WF.OUT_TRANSITIONS
2015: ( p_name => l_name
2016: , p_type => l_type
2017: , x_return_status => l_return_status
2025: END IF;
2026:
2027: G_all_activity_tbl.DELETE;
2028: G_exit_from_loop := 'NO';
2029: oe_debug_pub.add('Calling Get_activities for Header from Validate Order Flow '||l_name,5);
2030:
2031: Get_Activities
2032: ( P_process => l_name
2033: , P_process_item_type => l_type
2051: AND ROWNUM = 1;
2052:
2053: G_all_activity_tbl.DELETE;
2054: G_exit_from_loop := 'NO';
2055: oe_debug_pub.add('Calling Get Activities for Lines in Validate Order Flow '||l_line_process_name,5);
2056:
2057: Get_Activities
2058: ( P_process => l_line_process_name
2059: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
2067: FOR line_instance IN l_lin_activity_tbl.FIRST .. l_lin_activity_tbl.LAST LOOP
2068: IF l_lin_activity_tbl(line_instance).activity_name IN
2069: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
2070: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
2071: oe_debug_pub.add('In VOF : For Act '||l_lin_activity_tbl(line_instance).activity_name,5);
2072: oe_debug_pub.add('In VOF : For function '||l_lin_activity_tbl(line_instance).function,5);
2073: oe_debug_pub.add('In VOF : For Instance_id '||l_lin_activity_tbl(line_instance).instance_id,5);
2074:
2075: IF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
2068: IF l_lin_activity_tbl(line_instance).activity_name IN
2069: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
2070: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
2071: oe_debug_pub.add('In VOF : For Act '||l_lin_activity_tbl(line_instance).activity_name,5);
2072: oe_debug_pub.add('In VOF : For function '||l_lin_activity_tbl(line_instance).function,5);
2073: oe_debug_pub.add('In VOF : For Instance_id '||l_lin_activity_tbl(line_instance).instance_id,5);
2074:
2075: IF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
2076: BEGIN
2069: ('FULFILLMENT_CONT_H', 'INVOICING_WAIT_FOR_H','APPROVE_WAIT_FOR_H' /* Bug 6411686 */
2070: ,'BOOK_WAIT_FOR_H', 'CLOSE_CONT_H') THEN
2071: oe_debug_pub.add('In VOF : For Act '||l_lin_activity_tbl(line_instance).activity_name,5);
2072: oe_debug_pub.add('In VOF : For function '||l_lin_activity_tbl(line_instance).function,5);
2073: oe_debug_pub.add('In VOF : For Instance_id '||l_lin_activity_tbl(line_instance).instance_id,5);
2074:
2075: IF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN
2076: BEGIN
2077: SELECT text_value
2083: -- passed activity with CONTINUEFLOW function
2084: EXCEPTION
2085: WHEN NO_DATA_FOUND THEN
2086: l_activity := NULL;
2087: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
2088: NULL;
2089: WHEN OTHERS THEN
2090: oe_debug_pub.add('Validate_Order_flow WAITING ACTIVITY',1);
2091: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2086: l_activity := NULL;
2087: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
2088: NULL;
2089: WHEN OTHERS THEN
2090: oe_debug_pub.add('Validate_Order_flow WAITING ACTIVITY',1);
2091: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2092: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2093: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2094: NULL;
2087: oe_debug_pub.add(' In No Data Found for WAITING_ACTIVITY',1);
2088: NULL;
2089: WHEN OTHERS THEN
2090: oe_debug_pub.add('Validate_Order_flow WAITING ACTIVITY',1);
2091: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2092: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2093: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2094: NULL;
2095: END;
2088: NULL;
2089: WHEN OTHERS THEN
2090: oe_debug_pub.add('Validate_Order_flow WAITING ACTIVITY',1);
2091: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2092: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2093: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2094: NULL;
2095: END;
2096:
2089: WHEN OTHERS THEN
2090: oe_debug_pub.add('Validate_Order_flow WAITING ACTIVITY',1);
2091: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2092: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2093: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2094: NULL;
2095: END;
2096:
2097: ELSIF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN
2105: -- passed activity with WAITFORFLOW function
2106: EXCEPTION
2107: WHEN NO_DATA_FOUND THEN
2108: l_activity := NULL;
2109: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
2110: NULL;
2111: WHEN OTHERS THEN
2112: oe_debug_pub.add('Validate_Order_flow CONTINUATION_ACTIVITY',1);
2113: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2108: l_activity := NULL;
2109: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
2110: NULL;
2111: WHEN OTHERS THEN
2112: oe_debug_pub.add('Validate_Order_flow CONTINUATION_ACTIVITY',1);
2113: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2114: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2115: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2116: NULL;
2109: oe_debug_pub.add(' In No Data Found for CONTINUATION_ACTIVITY',1);
2110: NULL;
2111: WHEN OTHERS THEN
2112: oe_debug_pub.add('Validate_Order_flow CONTINUATION_ACTIVITY',1);
2113: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2114: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2115: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2116: NULL;
2117: END;
2110: NULL;
2111: WHEN OTHERS THEN
2112: oe_debug_pub.add('Validate_Order_flow CONTINUATION_ACTIVITY',1);
2113: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2114: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2115: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2116: NULL;
2117: END;
2118: END IF;
2111: WHEN OTHERS THEN
2112: oe_debug_pub.add('Validate_Order_flow CONTINUATION_ACTIVITY',1);
2113: oe_debug_pub.add('Validate_Order_flow : Line_process : '||l_line_process_name,1);
2114: oe_debug_pub.add('Validate_Order_flow : Activity Name : '||l_lin_activity_tbl(line_instance).instance_label,1);
2115: oe_debug_pub.add('Validate_Order_flow : Error : '||sqlerrm,1);
2116: NULL;
2117: END;
2118: END IF;
2119:
2116: NULL;
2117: END;
2118: END IF;
2119:
2120: oe_debug_pub.add('In VOF : matching activity is '||l_activity,5);
2121: matching_activity_exists := FALSE;
2122: IF l_activity IS NOT NULL THEN
2123: IF l_all_activity_tbl.COUNT > 0 THEN
2124: FOR testing_inst IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
2122: IF l_activity IS NOT NULL THEN
2123: IF l_all_activity_tbl.COUNT > 0 THEN
2124: FOR testing_inst IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
2125: IF ( l_all_activity_tbl(testing_inst).activity_name = l_activity ) THEN
2126: oe_debug_pub.add('In VOF : matching activity Exists '||l_all_activity_tbl(testing_inst).activity_name,5);
2127: matching_activity_exists := TRUE;
2128: EXIT;
2129: END IF;
2130: END LOOP;
2132: END IF;
2133:
2134: IF (matching_activity_exists <> TRUE) THEN
2135:
2136: oe_debug_pub.add('In VOF : matching activity do not Exists, logging message',1);
2137: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_MISS');
2138: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_name,OE_GLOBALS.G_WFI_HDR));
2139: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_activity);
2140: FND_MESSAGE.SET_TOKEN('ACTIVITY2',l_lin_activity_tbl(line_instance).activity_name);
2156: FOR testing_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
2157: IF l_all_activity_tbl(testing_instance).activity_name IN
2158: ('FULFILLMENT_WAIT_FOR_L', 'INVOICING_CONT_L' /*, Commented for #6818912 'APPROVE_CONT_L' Bug 6411686 */ ,'BOOK_CONT_L', 'CLOSE_WAIT_FOR_L') THEN
2159:
2160: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(testing_instance).instance_label,5);
2161: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(testing_instance).function,5);
2162: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(testing_instance).instance_id,5);
2163:
2164: OE_VALIDATE_WF.CHECK_SYNC
2157: IF l_all_activity_tbl(testing_instance).activity_name IN
2158: ('FULFILLMENT_WAIT_FOR_L', 'INVOICING_CONT_L' /*, Commented for #6818912 'APPROVE_CONT_L' Bug 6411686 */ ,'BOOK_CONT_L', 'CLOSE_WAIT_FOR_L') THEN
2159:
2160: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(testing_instance).instance_label,5);
2161: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(testing_instance).function,5);
2162: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(testing_instance).instance_id,5);
2163:
2164: OE_VALIDATE_WF.CHECK_SYNC
2165: ( P_process => l_name
2158: ('FULFILLMENT_WAIT_FOR_L', 'INVOICING_CONT_L' /*, Commented for #6818912 'APPROVE_CONT_L' Bug 6411686 */ ,'BOOK_CONT_L', 'CLOSE_WAIT_FOR_L') THEN
2159:
2160: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(testing_instance).instance_label,5);
2161: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(testing_instance).function,5);
2162: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(testing_instance).instance_id,5);
2163:
2164: OE_VALIDATE_WF.CHECK_SYNC
2165: ( P_process => l_name
2166: , P_process_item_type => l_type
2191: FOR instance_count IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
2192: IF l_all_activity_tbl(instance_count).function
2193: IN ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
2194:
2195: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(instance_count).instance_label,5);
2196: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(instance_count).function,5);
2197: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(instance_count).instance_id,5);
2198:
2199: OE_VALIDATE_WF.CHECK_SYNC
2192: IF l_all_activity_tbl(instance_count).function
2193: IN ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
2194:
2195: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(instance_count).instance_label,5);
2196: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(instance_count).function,5);
2197: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(instance_count).instance_id,5);
2198:
2199: OE_VALIDATE_WF.CHECK_SYNC
2200: ( P_process => l_name
2193: IN ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN
2194:
2195: oe_debug_pub.add('In VOF : For Instance_Label '||l_all_activity_tbl(instance_count).instance_label,5);
2196: oe_debug_pub.add('In VOF : For function '||l_all_activity_tbl(instance_count).function,5);
2197: oe_debug_pub.add('In VOF : For Instance_id '||l_all_activity_tbl(instance_count).instance_id,5);
2198:
2199: OE_VALIDATE_WF.CHECK_SYNC
2200: ( P_process => l_name
2201: , P_process_item_type => l_type
2217: END IF;
2218: END LOOP; -- instance_count
2219: END IF; -- l_all_activity_tbl.COUNT
2220:
2221: oe_debug_pub.add('In VOF : Calling Has_Activity for BOOK_ORDER',5);
2222: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY
2223: ( p_process => l_name
2224: , p_process_item_type => l_type
2225: , p_activity => 'BOOK_ORDER'
2229: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_MISSING_ACTIVITY');
2230: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
2231: FND_MESSAGE.SET_TOKEN('ACTIVITY_NAME','BOOK_ORDER');
2232: OE_MSG_PUB.Add;
2233: oe_debug_pub.add('LOG 22 : Added OE_WFVAL_MISSING_ACTIVITY',1);
2234: END IF;
2235:
2236: oe_debug_pub.add('In VOF : Calling Has_Activity for CLOSE_HEADER',5);
2237: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY
2232: OE_MSG_PUB.Add;
2233: oe_debug_pub.add('LOG 22 : Added OE_WFVAL_MISSING_ACTIVITY',1);
2234: END IF;
2235:
2236: oe_debug_pub.add('In VOF : Calling Has_Activity for CLOSE_HEADER',5);
2237: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY
2238: ( p_process => l_name
2239: , p_process_item_type => l_type
2240: , p_activity => 'CLOSE_HEADER'
2244: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_MISSING_ACTIVITY');
2245: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));
2246: FND_MESSAGE.SET_TOKEN('ACTIVITY_NAME','CLOSE_HEADER');
2247: OE_MSG_PUB.Add;
2248: oe_debug_pub.add('LOG 23 : Added OE_WFVAL_MISSING_ACTIVITY',1);
2249: END IF;
2250: END IF; -- only for l_type = OE_GLOBALS.G_WFI_HDR
2251:
2252: -- All activities in process p_name assigned APIs
2256: IF l_all_activity_tbl(l_instance).function= 'WF_STANDARD.DEFER'
2257: OR l_all_activity_tbl(l_instance).function = 'WF_STANDARD.WAIT'
2258: THEN
2259:
2260: oe_debug_pub.add('In VOF : Calling Wait And Loops for instance_label '||l_all_activity_tbl(l_instance).instance_label,5);
2261: oe_debug_pub.add('In VOF : Calling Wait And Loops for instance_id '||l_all_activity_tbl(l_instance).instance_id,5);
2262:
2263: OE_VALIDATE_WF.WAIT_AND_LOOPS
2264: ( P_process => l_name
2257: OR l_all_activity_tbl(l_instance).function = 'WF_STANDARD.WAIT'
2258: THEN
2259:
2260: oe_debug_pub.add('In VOF : Calling Wait And Loops for instance_label '||l_all_activity_tbl(l_instance).instance_label,5);
2261: oe_debug_pub.add('In VOF : Calling Wait And Loops for instance_id '||l_all_activity_tbl(l_instance).instance_id,5);
2262:
2263: OE_VALIDATE_WF.WAIT_AND_LOOPS
2264: ( P_process => l_name
2265: , P_process_item_type => l_type
2281:
2282: END IF; -- NOT l_quick_val
2283:
2284: X_msg_count := OE_MSG_PUB.count_msg - l_msg_count;
2285: oe_debug_pub.add('In VOF : msg count : '||X_msg_count,5);
2286: IF x_msg_count > 0 THEN
2287: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);
2288: END IF;
2289:
2286: IF x_msg_count > 0 THEN
2287: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);
2288: END IF;
2289:
2290: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);
2291: -- l_end_time := dbms_utility.get_time;
2292: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
2293:
2294: EXCEPTION
2288: END IF;
2289:
2290: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);
2291: -- l_end_time := dbms_utility.get_time;
2292: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
2293:
2294: EXCEPTION
2295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2296: oe_debug_pub.add('Error in Validate_Order_Flow : '||sqlerrm,5);
2292: -- oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
2293:
2294: EXCEPTION
2295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2296: oe_debug_pub.add('Error in Validate_Order_Flow : '||sqlerrm,5);
2297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2298: WHEN OTHERS THEN
2299: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2300: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');
2380: l_end_time NUMBER;
2381: l_msg_total NUMBER;
2382:
2383: BEGIN
2384: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate', 1);
2385: -- l_start_time := dbms_utility.get_time;
2386: Retcode := 0;
2387: Errbuf := NULL;
2388: l_validating_flow := 'No Name Mentioned';
2440: FND_FILE.put_line(FND_FILE.output,' ');
2441: FND_FILE.put_line(FND_FILE.output,'Validating Order Type : '||l_validating_flow||' ('||l_transaction_tbl(l_record_count).transaction_type_id||')');
2442: FND_FILE.put_line(FND_FILE.output,rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2443:
2444: oe_debug_pub.add(' ');
2445: oe_debug_pub.add('Validating Order Type : '||l_validating_flow||' ('||l_transaction_tbl(l_record_count).transaction_type_id||')');
2446: oe_debug_pub.add(rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2447:
2448: IF l_transaction_tbl(l_record_count).sales_document_type_code='O' THEN
2441: FND_FILE.put_line(FND_FILE.output,'Validating Order Type : '||l_validating_flow||' ('||l_transaction_tbl(l_record_count).transaction_type_id||')');
2442: FND_FILE.put_line(FND_FILE.output,rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2443:
2444: oe_debug_pub.add(' ');
2445: oe_debug_pub.add('Validating Order Type : '||l_validating_flow||' ('||l_transaction_tbl(l_record_count).transaction_type_id||')');
2446: oe_debug_pub.add(rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2447:
2448: IF l_transaction_tbl(l_record_count).sales_document_type_code='O' THEN
2449: -- Uunconditionally for pre-11.5.10 releases)
2442: FND_FILE.put_line(FND_FILE.output,rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2443:
2444: oe_debug_pub.add(' ');
2445: oe_debug_pub.add('Validating Order Type : '||l_validating_flow||' ('||l_transaction_tbl(l_record_count).transaction_type_id||')');
2446: oe_debug_pub.add(rpad('-',(27+length(l_validating_flow)+length(l_transaction_tbl(l_record_count).transaction_type_id)),'-'));
2447:
2448: IF l_transaction_tbl(l_record_count).sales_document_type_code='O' THEN
2449: -- Uunconditionally for pre-11.5.10 releases)
2450: -- Getting associated order header() internal workflow process name
2580:
2581: END LOOP; -- End Loop l_record_count
2582: END IF;
2583:
2584: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate', 1);
2585: -- l_end_time := dbms_utility.get_time;
2586: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
2587:
2588: EXCEPTION
2582: END IF;
2583:
2584: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate', 1);
2585: -- l_end_time := dbms_utility.get_time;
2586: --oe_debug_pub.add(' Time taken = '||l_end_time- l_start_time);
2587:
2588: EXCEPTION
2589: WHEN FND_API.G_EXC_ERROR THEN
2590: retcode := 2;