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 STANDARD

Line 523: IF l_api = 'WF_STANDARD.WAIT' THEN

519: l_activity_id := P_activity_id;
520: l_activity_label := P_activity_label;
521: l_process_item_type := P_process_item_type;
522:
523: IF l_api = 'WF_STANDARD.WAIT' THEN
524:
525: -- Getting the attribute Wait Mode of activity p_activity_id
526: -- and the attributes of Wait Mode
527: BEGIN

Line 648: IF l_api = 'WF_STANDARD.WAIT' THEN

644: ( activity1 => l_activity_id
645: , activity2 => l_activity_id
646: ) THEN
647:
648: IF l_api = 'WF_STANDARD.WAIT' THEN
649: BEGIN
650: SELECT text_value
651: INTO l_text_value_relative
652: FROM wf_activity_attr_values

Line 682: -- l_api = 'WF_STANDARD.WAIT' AND Relative Time is > 0

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')
686: AND (l_number_value > 0) THEN

Line 684: IF (l_api = 'WF_STANDARD.WAIT')

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')
686: AND (l_number_value > 0) THEN
687:
688: -- Warning user that wait time should be >= average

Line 818: FND_MESSAGE.SET_TOKEN( 'ITEM_TYPE', NVL(l_item_type, 'STANDARD'));

814:
815: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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

Line 826: FND_MESSAGE.SET_TOKEN( 'ITEM_TYPE', NVL(l_item_type, 'STANDARD'));

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

Line 944: IF l_function = 'WF_STANDARD.CONTINUEFLOW' THEN

940: l_type := P_type; --Vaibhav
941: l_instance_id := P_instance_id; --Vaibhav
942: l_matching_activity := NULL;
943:
944: IF l_function = 'WF_STANDARD.CONTINUEFLOW' THEN
945:
946: BEGIN
947: SELECT text_value
948: INTO l_wait_text_default

Line 973: WHERE wa.function = 'WF_STANDARD.WAITFORFLOW'

969: BEGIN
970: SELECT 'YES'
971: INTO l_coresp_cont_act
972: FROM wf_activities wa
973: WHERE wa.function = 'WF_STANDARD.WAITFORFLOW'
974: AND wa.name = l_wait_text_default
975: AND wa.item_type IN ('OEOH','OEOL')
976: AND wa.version = ( SELECT MAX(version)
977: FROM wf_activities wa1

Line 1048: ELSIF l_function = 'WF_STANDARD.WAITFORFLOW' THEN

1044: X_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: END IF; -- l_process_item_type
1047:
1048: ELSIF l_function = 'WF_STANDARD.WAITFORFLOW' THEN
1049: -- l_all_activity_tbl(l_instance).function
1050: BEGIN
1051: SELECT text_value
1052: INTO l_cont_text_default

Line 1076: WHERE wa.function = 'WF_STANDARD.CONTINUEFLOW'

1072: BEGIN
1073: SELECT 'YES'
1074: INTO l_coresp_wait_act
1075: FROM wf_activities wa
1076: WHERE wa.function = 'WF_STANDARD.CONTINUEFLOW'
1077: AND wa.name = l_cont_text_default
1078: AND wa.item_type IN ('OEOH','OEOL')
1079: AND wa.version = ( SELECT MAX(version)
1080: FROM wf_activities wa1

Line 1241: -- WF_STANDARD.CONTINUEFLOW, matching activity attr

1237: IF NOT( l_coresp_wait_act = 'YES'
1238: AND l_matching_activity = l_line_activity_tbl(l_line_instance).instance_label)
1239: AND (NVL(l_flow_name,'MASTER') <> 'DETAIL') THEN
1240: -- Matching activity must be assigned API
1241: -- WF_STANDARD.CONTINUEFLOW, matching activity attr
1242: -- WAITING_ACTIVITY must equal to Act.instance_label,
1243: -- and matching activity attribute WAITING_FLOW
1244: -- must be 'MASTER', else it will be an error.
1245:

Line 1259: -- WF_STANDARD.WAITFORFLOW, matching activity attr

1255: IF NOT( l_coresp_cont_act = 'YES'
1256: AND l_matching_activity = l_line_activity_tbl(l_line_instance).instance_label)
1257: AND (NVL(l_flow_name,'MASTER') <> 'DETAIL' ) THEN
1258: -- Matching activity must be assigned API
1259: -- WF_STANDARD.WAITFORFLOW, matching activity attr
1260: -- CONTINUATION_FLOW must equal to Act.instance_label,
1261: -- and matching activity attribute CONTINUATION_FLOW
1262: -- must be 'MASTER', else it will be an error.
1263: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');

Line 1346: -- WF_STANDARD.CONTINUEFLOW, matching activity attr

1342: IF NOT( l_coresp_wait_act = 'YES'
1343: AND l_matching_activity = l_header_activity_tbl(l_hdr_instance).instance_label)
1344: AND (NVL(l_flow_name,'DETAIL') <> 'MASTER') THEN
1345: -- Matching activity must be assigned API
1346: -- WF_STANDARD.CONTINUEFLOW, matching activity attr
1347: -- WAITING_ACTIVITY must equal to Act.instance_label,
1348: -- and matching activity attribute WAITING_FLOW must
1349: -- be 'DETAIL', else it will be an error.
1350: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');

Line 1363: -- WF_STANDARD.WAITFORFLOW, matching activity attr

1359: IF NOT( l_coresp_cont_act = 'YES'
1360: AND l_matching_activity = l_header_activity_tbl(l_hdr_instance).instance_label)
1361: AND (NVL(l_flow_name,'DETAIL') <> 'MASTER') THEN
1362: -- Matching activity must be assigned API
1363: -- WF_STANDARD.WAITFORFLOW, matching activity attr
1364: -- CONTINUATION_FLOW must equal to Act.instance_label,
1365: -- and matching activity attribute CONTINUATION_FLOW
1366: -- must be 'DETAIL', else it will be an error. */
1367: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');

Line 1699: IF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.CONTINUEFLOW' THEN

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
1702: INTO l_activity
1703: FROM wf_activity_attr_values waa

Line 1721: ELSIF l_hdr_activity_tbl(hdr_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN

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
1722: BEGIN
1723: SELECT text_value
1724: INTO l_activity
1725: FROM wf_activity_attr_values waa

Line 1819: ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN

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
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:

Line 1863: -- wf_standard.defer or wf_standard.wait */

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 */
1864: FOR l_all_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
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

Line 1865: IF l_all_activity_tbl(l_all_instance).function= 'WF_STANDARD.DEFER'

1861:
1862: -- Activities in process p_name assigned APIs
1863: -- wf_standard.defer or wf_standard.wait */
1864: FOR l_all_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
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);

Line 1866: OR l_all_activity_tbl(l_all_instance).function = 'WF_STANDARD.WAIT'

1862: -- Activities in process p_name assigned APIs
1863: -- wf_standard.defer or wf_standard.wait */
1864: FOR l_all_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
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);

Line 2075: IF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.CONTINUEFLOW' 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
2078: INTO l_activity
2079: FROM wf_activity_attr_values waa

Line 2097: ELSIF l_lin_activity_tbl(line_instance).function = 'WF_STANDARD.WAITFORFLOW' THEN

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
2098: BEGIN
2099: SELECT text_value
2100: INTO l_activity
2101: FROM wf_activity_attr_values waa

Line 2193: IN ('WF_STANDARD.CONTINUEFLOW', 'WF_STANDARD.WAITFORFLOW') THEN

2189: IF l_type = OE_GLOBALS.G_WFI_HDR THEN
2190: IF l_all_activity_tbl.COUNT > 0 THEN
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);

Line 2253: -- wf_standard.defer or wf_standard.wait

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
2253: -- wf_standard.defer or wf_standard.wait
2254:
2255: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
2256: IF l_all_activity_tbl(l_instance).function= 'WF_STANDARD.DEFER'
2257: OR l_all_activity_tbl(l_instance).function = 'WF_STANDARD.WAIT'

Line 2256: IF l_all_activity_tbl(l_instance).function= 'WF_STANDARD.DEFER'

2252: -- All activities in process p_name assigned APIs
2253: -- wf_standard.defer or wf_standard.wait
2254:
2255: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
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);

Line 2257: OR l_all_activity_tbl(l_instance).function = 'WF_STANDARD.WAIT'

2253: -- wf_standard.defer or wf_standard.wait
2254:
2255: FOR l_instance IN l_all_activity_tbl.FIRST .. l_all_activity_tbl.LAST LOOP
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);

Line 2321: ( Errbuf OUT NOCOPY VARCHAR2 -- AOL standard

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
2323: , P_order_type_id IN NUMBER DEFAULT NULL
2324: )
2325: IS

Line 2322: , retcode OUT NOCOPY VARCHAR2 -- AOL standard

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
2323: , P_order_type_id IN NUMBER DEFAULT NULL
2324: )
2325: IS
2326: