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.OE_VALIDATE_WF dependencies on OE_VALIDATE_WF

Line 1: PACKAGE BODY OE_VALIDATE_WF AS

1: PACKAGE BODY OE_VALIDATE_WF AS
2: /* $Header: OEXVVWFB.pls 120.4 2008/02/15 15:03:50 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VALIDATE_WF';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VALIDATE_WF';

1: PACKAGE BODY OE_VALIDATE_WF AS
2: /* $Header: OEXVVWFB.pls 120.4 2008/02/15 15:03:50 vbkapoor ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VALIDATE_WF';
6:
7: -- Global variables used in the package
8: G_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
9: G_loop_tbl NumberTable;

Line 8: G_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

4: -- Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VALIDATE_WF';
6:
7: -- Global variables used in the package
8: G_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
9: G_loop_tbl NumberTable;
10: G_exit_from_loop VARCHAR2(3) := 'NO';
11: /*----------------------------------------------------------------
12: Function Display_Name

Line 16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API

12: Function Display_Name
13: A function returning Display name of a process name.
14:
15: This program is called by:
16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API

Line 17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API

13: A function returning Display name of a process name.
14:
15: This program is called by:
16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API
21: 6. OE_VALIDATE_WF.Wait_And_Loops() API

Line 18: 3. OE_VALIDATE_WF.Out_Transitions() API

14:
15: This program is called by:
16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API
21: 6. OE_VALIDATE_WF.Wait_And_Loops() API
22: ------------------------------------------------------------------*/

Line 19: 4. OE_VALIDATE_WF.Check_Sync() API

15: This program is called by:
16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API
21: 6. OE_VALIDATE_WF.Wait_And_Loops() API
22: ------------------------------------------------------------------*/
23: FUNCTION Display_Name

Line 20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API

16: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API
21: 6. OE_VALIDATE_WF.Wait_And_Loops() API
22: ------------------------------------------------------------------*/
23: FUNCTION Display_Name
24: ( P_process IN OUT NOCOPY VARCHAR2

Line 21: 6. OE_VALIDATE_WF.Wait_And_Loops() API

17: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
18: 3. OE_VALIDATE_WF.Out_Transitions() API
19: 4. OE_VALIDATE_WF.Check_Sync() API
20: 5. OE_VALIDATE_WF.Line_Flow_Assignment() API
21: 6. OE_VALIDATE_WF.Wait_And_Loops() API
22: ------------------------------------------------------------------*/
23: FUNCTION Display_Name
24: ( P_process IN OUT NOCOPY VARCHAR2
25: , P_item_type IN VARCHAR2

Line 89: 1. OE_VALIDATE_WF.Wait_And_Loops() API

85: Function In_Loop
86: A function returning Boolean.
87:
88: This program is called by:
89: 1. OE_VALIDATE_WF.Wait_And_Loops() API
90: ------------------------------------------------------------------*/
91: FUNCTION In_Loop
92: ( activity1 IN NUMBER
93: , activity2 IN NUMBER

Line 111: oe_debug_pub.add('Entering Function OE_VALIDATE_WF.In_Loop '||to_char(activity1)||' '||to_char(activity2), 1);

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;

Line 154: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop TRUE', 1);

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:

Line 156: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.In_Loop FALSE', 1);

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:

Line 182: 1. OE_VALIDATE_WF.Validate_Order_Flow() API

178: activity (or subprocess) at any level. A function returning
179: Boolean.
180:
181: This program is called by:
182: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
183: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
184: ------------------------------------------------------------------*/
185: FUNCTION Has_Activity
186: ( P_process IN VARCHAR2

Line 183: 2. OE_VALIDATE_WF.Validate_Line_Flow() API

179: Boolean.
180:
181: This program is called by:
182: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
183: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
184: ------------------------------------------------------------------*/
185: FUNCTION Has_Activity
186: ( P_process IN VARCHAR2
187: , P_process_item_type IN VARCHAR2

Line 245: oe_debug_pub.add('Entering Function OE_VALIDATE_WF.Has_Activity', 1);

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;

Line 264: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);

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

Line 288: oe_debug_pub.add('Exiting Function OE_VALIDATE_WF.Has_Activity', 1);

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:

Line 313: 1. OE_VALIDATE_WF.Check_Sync() API

309: Determines all the activities or a particular activity in a
310: workflow process (and subprocess) at any level.
311:
312: This program is called by:
313: 1. OE_VALIDATE_WF.Check_Sync() API
314: 2. OE_VALIDATE_WF.Out_Transitions() API
315: 3. OE_VALIDATE_WF.Validate_Line_Flow() API
316: 4. OE_VALIDATE_WF.Validate_Order_Flow() API
317: ------------------------------------------------------------------*/

Line 314: 2. OE_VALIDATE_WF.Out_Transitions() API

310: workflow process (and subprocess) at any level.
311:
312: This program is called by:
313: 1. OE_VALIDATE_WF.Check_Sync() API
314: 2. OE_VALIDATE_WF.Out_Transitions() API
315: 3. OE_VALIDATE_WF.Validate_Line_Flow() API
316: 4. OE_VALIDATE_WF.Validate_Order_Flow() API
317: ------------------------------------------------------------------*/
318: PROCEDURE Get_Activities

Line 315: 3. OE_VALIDATE_WF.Validate_Line_Flow() API

311:
312: This program is called by:
313: 1. OE_VALIDATE_WF.Check_Sync() API
314: 2. OE_VALIDATE_WF.Out_Transitions() API
315: 3. OE_VALIDATE_WF.Validate_Line_Flow() API
316: 4. OE_VALIDATE_WF.Validate_Order_Flow() API
317: ------------------------------------------------------------------*/
318: PROCEDURE Get_Activities
319: ( P_process IN VARCHAR2

Line 316: 4. OE_VALIDATE_WF.Validate_Order_Flow() API

312: This program is called by:
313: 1. OE_VALIDATE_WF.Check_Sync() API
314: 2. OE_VALIDATE_WF.Out_Transitions() API
315: 3. OE_VALIDATE_WF.Validate_Line_Flow() API
316: 4. OE_VALIDATE_WF.Validate_Order_Flow() API
317: ------------------------------------------------------------------*/
318: PROCEDURE Get_Activities
319: ( P_process IN VARCHAR2
320: , P_process_item_type IN VARCHAR2

Line 400: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Get_Activities', 5);

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;

Line 460: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Get_Activities', 5);

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

Line 482: 1. OE_VALIDATE_WF.Validate_Order_Flow() API

478: /*----------------------------------------------------------------
479: Procedure Wait_And_Loops
480:
481: This program is called by:
482: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
483: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
484: ------------------------------------------------------------------*/
485: PROCEDURE Wait_And_Loops
486: ( P_process IN VARCHAR2

Line 483: 2. OE_VALIDATE_WF.Validate_Line_Flow() API

479: Procedure Wait_And_Loops
480:
481: This program is called by:
482: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
483: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
484: ------------------------------------------------------------------*/
485: PROCEDURE Wait_And_Loops
486: ( P_process IN VARCHAR2
487: , P_process_item_type IN VARCHAR2

Line 511: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);

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:

Line 618: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);

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:

Line 630: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);

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;

Line 714: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Wait_And_Loops', 1);

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

Line 742: 1. OE_VALIDATE_WF.Validate() API

738: assigned. If yes, returns a warning message and puts it on the
739: message stack.
740:
741: This program is called by:
742: 1. OE_VALIDATE_WF.Validate() API
743: 2. Transaction Types form (OEXDTTYP.fmb, OEXTRTYP.pld)
744: ------------------------------------------------------------------*/
745: PROCEDURE Line_Flow_Assignment
746: ( P_name IN VARCHAR2

Line 761: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Line_Flow_Assignment', 1);

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;

Line 834: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Line_Flow_Assignment', 1);

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

Line 860: 1. OE_VALIDATE_WF.Validate_Order_Flow() API

856: p_process has a corresponding wait/continue activity in the
857: OEOL/OEOH flow(s) assigned to p_order_type.
858:
859: This program is called by:
860: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
861: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
862: ------------------------------------------------------------------*/
863: PROCEDURE Check_Sync
864: ( P_process IN VARCHAR2

Line 861: 2. OE_VALIDATE_WF.Validate_Line_Flow() API

857: OEOL/OEOH flow(s) assigned to p_order_type.
858:
859: This program is called by:
860: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
861: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
862: ------------------------------------------------------------------*/
863: PROCEDURE Check_Sync
864: ( P_process IN VARCHAR2
865: , P_process_item_type IN VARCHAR2

Line 911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

907: l_order_flow VARCHAR2(30);
908: l_activity_name VARCHAR2(30);
909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;

Line 912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

908: l_activity_name VARCHAR2(30);
909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;
916: l_end_time NUMBER;

Line 913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

909: l_wfval_out_of_sync VARCHAR2(4);
910:
911: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
912: l_line_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
913: l_header_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
914:
915: l_start_time NUMBER;
916: l_end_time NUMBER;
917:

Line 923: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Check_Sync', 1);

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:

Line 1383: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Check_Sync', 1);

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

Line 1407: 1. OE_VALIDATE_WF.Validate_Order_Flow() API

1403: no OUT transition defined. If any are found, error status is
1404: returned and appropriate error messages logged.
1405:
1406: This program is called by:
1407: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
1408: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
1409: ------------------------------------------------------------------*/
1410: PROCEDURE Out_Transitions
1411: ( P_name IN VARCHAR2

Line 1408: 2. OE_VALIDATE_WF.Validate_Line_Flow() API

1404: returned and appropriate error messages logged.
1405:
1406: This program is called by:
1407: 1. OE_VALIDATE_WF.Validate_Order_Flow() API
1408: 2. OE_VALIDATE_WF.Validate_Line_Flow() API
1409: ------------------------------------------------------------------*/
1410: PROCEDURE Out_Transitions
1411: ( P_name IN VARCHAR2
1412: , P_type IN VARCHAR2

Line 1421: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1417: l_instance NUMBER;
1418: l_name VARCHAR2(30);
1419: l_type VARCHAR2(8);
1420: l_from_process_activity_exists VARCHAR2(1);
1421: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1422: l_start_time NUMBER;
1423: l_end_time NUMBER;
1424: -- l_start_end VARCHAR2(8);
1425:

Line 1427: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Out_Transitions', 1);

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

Line 1486: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Out_Transitions', 1);

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

Line 1509: 1. OE_VALIDATE_WF.Validate() API

1505: Procedure Validate_Line_Flow
1506: << Description >>
1507:
1508: This program is called by:
1509: 1. OE_VALIDATE_WF.Validate() API
1510: 2. Transaction Types form (OEXDTTYP.fmb, OEXTRTYP.pld)
1511: ------------------------------------------------------------------*/
1512: PROCEDURE Validate_Line_Flow
1513: ( P_name IN VARCHAR2

Line 1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1540: l_fulfill_act_exists VARCHAR2(1);
1541: l_type VARCHAR2(8);
1542: l_attr_first_time VARCHAR2(2000);
1543: l_line_process_name VARCHAR2(30);
1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1546: l_start_time NUMBER;
1547: l_end_time NUMBER;
1548: testing_instance NUMBER;

Line 1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1541: l_type VARCHAR2(8);
1542: l_attr_first_time VARCHAR2(2000);
1543: l_line_process_name VARCHAR2(30);
1544: l_hdr_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1545: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1546: l_start_time NUMBER;
1547: l_end_time NUMBER;
1548: testing_instance NUMBER;
1549: hdr_instance NUMBER;

Line 1554: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);

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:

Line 1567: OE_VALIDATE_WF.OUT_TRANSITIONS

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
1571: );

Line 1618: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY

1614: END IF;
1615: END IF; -- l_attr_first_time
1616:
1617: IF l_continue_further THEN
1618: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY
1619: ( P_process => l_name
1620: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1621: , P_activity => fulfill_attributes.FulfillAttr
1622: , P_activity_item_type => OE_GLOBALS.G_WFI_LIN

Line 1791: OE_VALIDATE_WF.CHECK_SYNC

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
1794: , P_order_type_id => NULL
1795: , P_order_flow => l_order_flow

Line 1824: OE_VALIDATE_WF.CHECK_SYNC

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
1827: , P_order_type_id => NULL
1828: , P_order_flow => l_order_flow

Line 1848: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY

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'
1852: , P_activity_item_type => OE_GLOBALS.G_WFI_LIN

Line 1872: OE_VALIDATE_WF.WAIT_AND_LOOPS

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
1875: , P_activity_id => l_all_activity_tbl(l_all_instance).instance_id
1876: , P_activity_label => l_all_activity_tbl(l_all_instance).instance_label

Line 1890: IF OE_VALIDATE_WF.HAS_ACTIVITY

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'
1894: , P_activity_item_type => OE_GLOBALS.G_WFI_LIN

Line 1897: OE_VALIDATE_WF.HAS_ACTIVITY

1893: , P_activity => 'SHIP_LINE'
1894: , P_activity_item_type => OE_GLOBALS.G_WFI_LIN
1895: ) AND
1896:
1897: OE_VALIDATE_WF.HAS_ACTIVITY
1898: ( P_process => l_name
1899: , P_process_item_type => OE_GLOBALS.G_WFI_LIN
1900: , P_activity => 'INVOICE_INTERFACE'
1901: , P_activity_item_type => OE_GLOBALS.G_WFI_LIN

Line 1920: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);

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

Line 1964: 1. OE_VALIDATE_WF.Validate() API

1960: Procedure Validate_Order_flow
1961: << Description >>
1962:
1963: This program is called by:
1964: 1. OE_VALIDATE_WF.Validate() API
1965: 2. Transaction Types form (OEXDTTYP.fmb, OEXTRTYP.pld)
1966: ------------------------------------------------------------------*/
1967: PROCEDURE Validate_Order_flow
1968: ( P_name IN VARCHAR2

Line 1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1985: l_msg_data VARCHAR2(2000);
1986: l_quick_val BOOLEAN := TRUE;
1987: l_msg_count NUMBER;
1988: l_order_type_id NUMBER := NULL;
1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1991: l_start_time NUMBER;
1992: l_end_time NUMBER;
1993: testing_instance NUMBER;

Line 1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;

1986: l_quick_val BOOLEAN := TRUE;
1987: l_msg_count NUMBER;
1988: l_order_type_id NUMBER := NULL;
1989: l_all_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1990: l_lin_activity_tbl OE_VALIDATE_WF.Activities_Tbl_Type;
1991: l_start_time NUMBER;
1992: l_end_time NUMBER;
1993: testing_instance NUMBER;
1994: testing_inst NUMBER;

Line 2002: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);

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:

Line 2014: OE_VALIDATE_WF.OUT_TRANSITIONS

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
2018: );

Line 2164: OE_VALIDATE_WF.CHECK_SYNC

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
2167: , p_order_type_id => l_order_type_id
2168: , P_instance_label => l_all_activity_tbl(testing_instance).instance_label

Line 2199: OE_VALIDATE_WF.CHECK_SYNC

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
2202: , p_order_type_id => l_order_type_id
2203: , P_instance_label => l_all_activity_tbl(instance_count).instance_label

Line 2222: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY

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'
2226: , p_activity_item_type => OE_GLOBALS.G_WFI_HDR

Line 2237: IF NOT OE_VALIDATE_WF.HAS_ACTIVITY

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'
2241: , p_activity_item_type => OE_GLOBALS.G_WFI_HDR

Line 2263: OE_VALIDATE_WF.WAIT_AND_LOOPS

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
2266: , P_activity_id => l_all_activity_tbl(l_instance).instance_id
2267: , P_activity_label => l_all_activity_tbl(l_instance).instance_label

Line 2290: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);

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

Line 2317: 1. OE_VALIDATE_WF.validate_order_flow()

2313: This program is called by:
2314: 1. Validate OM Workflow (OEXVWF) concurrent program
2315:
2316: The program calls the following other programs:
2317: 1. OE_VALIDATE_WF.validate_order_flow()
2318: 2. OE_VALIDATE_WF.validate_line_flow()
2319: ------------------------------------------------------------------*/
2320: PROCEDURE Validate
2321: ( Errbuf OUT NOCOPY VARCHAR2 -- AOL standard

Line 2318: 2. OE_VALIDATE_WF.validate_line_flow()

2314: 1. Validate OM Workflow (OEXVWF) concurrent program
2315:
2316: The program calls the following other programs:
2317: 1. OE_VALIDATE_WF.validate_order_flow()
2318: 2. OE_VALIDATE_WF.validate_line_flow()
2319: ------------------------------------------------------------------*/
2320: PROCEDURE Validate
2321: ( Errbuf OUT NOCOPY VARCHAR2 -- AOL standard
2322: , retcode OUT NOCOPY VARCHAR2 -- AOL standard

Line 2384: oe_debug_pub.add('Entering Procedure OE_VALIDATE_WF.Validate', 1);

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';

Line 2469: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW

2465: END;
2466:
2467: IF l_process_name IS NOT NULL THEN
2468:
2469: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW
2470: ( p_name => l_process_name
2471: , p_order_type_id => l_transaction_tbl(l_record_count).transaction_type_id
2472: , p_type => OE_GLOBALS.G_WFI_HDR
2473: , p_quick_val => FALSE

Line 2490: OE_VALIDATE_WF.LINE_FLOW_ASSIGNMENT

2486: combinations assigned to this order type */
2487:
2488: FOR line_item_processes IN c_line_item_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP
2489:
2490: OE_VALIDATE_WF.LINE_FLOW_ASSIGNMENT
2491: ( p_name => line_item_processes.process_name
2492: , p_item_type => line_item_processes.item_type_code
2493: , x_return_status => l_return_status
2494: , x_msg_count => l_msg_count

Line 2506: OE_VALIDATE_WF.VALIDATE_LINE_FLOW

2502: (OEOL) internal workflow process names assigned to this
2503: order type */
2504:
2505: FOR line_processes IN c_line_process(l_transaction_tbl(l_record_count).transaction_type_id) LOOP
2506: OE_VALIDATE_WF.VALIDATE_LINE_FLOW
2507: ( p_name => line_processes.process_name
2508: , p_order_flow => l_process_name
2509: , p_quick_val => FALSE
2510: , x_return_status => l_return_status

Line 2529: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW

2525: -- Getting associated blanket header (OEBH) internal workflow
2526: -- process name from oe_workflow_assignments
2527: FOR blanket_processes IN c_other_process(l_transaction_tbl(l_record_count).transaction_type_id, OE_GLOBALS.G_WFI_BKT) LOOP
2528:
2529: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW
2530: ( p_name => blanket_processes.process_name
2531: , p_type => OE_GLOBALS.G_WFI_BKT
2532: , p_quick_val => FALSE
2533: , x_return_status => l_return_status

Line 2551: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW

2547: negotiation header (OENH) internal workflow process name from
2548: oe_workflow_assignments; */
2549: FOR negotiation_processes IN c_other_process(l_transaction_tbl(l_record_count).transaction_type_id, OE_GLOBALS.G_WFI_NGO) LOOP
2550:
2551: OE_VALIDATE_WF.VALIDATE_ORDER_FLOW
2552: ( p_name => negotiation_processes.process_name
2553: , p_type => OE_GLOBALS.G_WFI_NGO
2554: , p_quick_val => FALSE
2555: , x_return_status => l_return_status

Line 2584: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate', 1);

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

Line 2601: END OE_VALIDATE_WF; --Package Ends

2597: errbuf := sqlerrm;
2598:
2599: END Validate;
2600:
2601: END OE_VALIDATE_WF; --Package Ends