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 FND_API

Line 72: WHEN FND_API.G_EXC_ERROR THEN

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

Line 73: RAISE FND_API.G_EXC_ERROR;

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

Line 74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 75: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
82: END Display_Name;
83:
84: /*----------------------------------------------------------------
85: Function In_Loop

Line 162: WHEN FND_API.G_EXC_ERROR THEN

158:
159: RETURN l_return_status;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
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

Line 163: RAISE FND_API.G_EXC_ERROR;

159: RETURN l_return_status;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
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);

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
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

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
172:
173: END In_Loop;
174:
175: /*----------------------------------------------------------------

Line 294: WHEN FND_API.G_EXC_ERROR THEN

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

Line 295: RAISE FND_API.G_EXC_ERROR;

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

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
304:
305: END Has_Activity;
306:
307: /*----------------------------------------------------------------

Line 465: WHEN FND_API.G_EXC_ERROR THEN

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;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469: WHEN OTHERS THEN

Line 466: RAISE FND_API.G_EXC_ERROR;

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

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

463:
464: EXCEPTION
465: WHEN FND_API.G_EXC_ERROR THEN
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

Line 468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

464: EXCEPTION
465: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
475:
476: END Get_Activities;
477:
478: /*----------------------------------------------------------------

Line 514: X_return_status := FND_API.G_RET_STS_SUCCESS;

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:
516: -- Copying passed into locals
517: l_api := p_api;
518: l_process := P_process;

Line 707: X_return_status := FND_API.G_RET_STS_ERROR;

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
710:
711: oe_debug_pub.add('In W.A.L. : Not in Loop ',5);

Line 719: WHEN FND_API.G_EXC_ERROR THEN

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;
721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: WHEN OTHERS THEN

Line 720: RAISE FND_API.G_EXC_ERROR;

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

Line 721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

717:
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
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

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
729:
730: END Wait_And_Loops;
731:
732: /*----------------------------------------------------------------

Line 765: l_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 775: l_return_status := FND_API.G_RET_STS_ERROR;

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;
776: l_msg_count := l_msg_count + 1;
777:
778: ELSIF ( l_name like '%ATO_ITEM%' )
779: AND ( l_item_type IS NULL OR l_item_type <> 'ATO_ITEM') THEN

Line 784: l_return_status := FND_API.G_RET_STS_ERROR;

780: l_msg_count := l_msg_count + 1;
781:
782: ELSIF ( l_name = 'R_ATO_MODEL_LINE' )
783: AND ( l_item_type IS NULL OR l_item_type <> 'ATO_MODEL') THEN
784: l_return_status := FND_API.G_RET_STS_ERROR;
785: l_msg_count := l_msg_count + 1;
786:
787: ELSIF ( l_name like '%ATO_MODEL%' )
788: AND ( l_item_type IS NULL OR l_item_type <> 'ATO_MODEL') THEN

Line 794: l_return_status := FND_API.G_RET_STS_ERROR;

790:
791: ELSIF ( l_name = 'R_CONFIGURATION_LINE' )
792: AND ( l_item_type IS NULL
793: OR l_item_type <> 'CONFIGURATION') THEN
794: l_return_status := FND_API.G_RET_STS_ERROR;
795: l_msg_count := l_msg_count + 1;
796:
797: ELSIF ( l_name like '%CONFIG%' )
798: AND ( l_item_type IS NULL

Line 805: l_return_status := FND_API.G_RET_STS_ERROR;

801:
802: ELSIF ( l_name = 'R_OTA_LINE' )
803: AND ( l_item_type IS NULL
804: OR l_item_type <> 'EDUCATION_ITEM') THEN
805: l_return_status := FND_API.G_RET_STS_ERROR;
806: l_msg_count := l_msg_count + 1;
807:
808: ELSIF ( l_name like '%OTA%' )
809: AND ( l_item_type IS NULL

Line 815: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

811: l_msg_count := l_msg_count + 1;
812:
813: END IF;
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;

Line 839: WHEN FND_API.G_EXC_ERROR THEN

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;
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: WHEN OTHERS THEN

Line 840: RAISE FND_API.G_EXC_ERROR;

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

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837:
838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
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

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: EXCEPTION
839: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
849:
850: END Line_Flow_Assignment;
851:
852:

Line 926: X_return_status := FND_API.G_RET_STS_SUCCESS;

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:
928: -- Copying passed into locals
929: l_process := P_process;
930: l_instance_label := p_instance_label;

Line 1032: X_return_status := FND_API.G_RET_STS_ERROR;

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:
1035: ELSIF l_process_item_type = OE_GLOBALS.G_WFI_LIN THEN
1036: IF (NVL(l_flow_name,'DETAIL') <> 'MASTER') THEN

Line 1044: X_return_status := FND_API.G_RET_STS_ERROR;

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
1047:
1048: ELSIF l_function = 'WF_STANDARD.WAITFORFLOW' THEN

Line 1134: X_return_status := FND_API.G_RET_STS_ERROR;

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
1138: IF (NVL(l_flow_name,'DETAIL') <> 'MASTER') THEN

Line 1144: X_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1191: X_return_status := FND_API.G_RET_STS_ERROR;

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
1195: -- line process then the above count=0 can still display the correct

Line 1224: X_return_status := FND_API.G_RET_STS_ERROR;

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;
1226:
1227: -- Important : The above changes are done keeping in mind that for
1228: -- one activity name, we can have many instance labels, with

Line 1251: X_return_status := FND_API.G_RET_STS_ERROR;

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
1255: IF NOT( l_coresp_cont_act = 'YES'

Line 1268: X_return_status := FND_API.G_RET_STS_ERROR;

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
1272: END LOOP; -- l_line_instance

Line 1305: X_return_status := FND_API.G_RET_STS_ERROR;

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:
1308: FOR l_hdr_instance IN l_header_activity_tbl.FIRST .. l_header_activity_tbl.LAST
1309: LOOP

Line 1333: X_return_status := FND_API.G_RET_STS_ERROR;

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:
1336: IF l_header_activity_tbl.COUNT > 0 THEN
1337: FOR l_hdr_instance IN l_header_activity_tbl.FIRST .. l_header_activity_tbl.LAST

Line 1355: X_return_status := FND_API.G_RET_STS_ERROR;

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
1359: IF NOT( l_coresp_cont_act = 'YES'

Line 1372: X_return_status := FND_API.G_RET_STS_ERROR;

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:
1376: END IF; -- instance_label = l_matching_activity

Line 1388: WHEN FND_API.G_EXC_ERROR THEN

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;
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: WHEN OTHERS THEN

Line 1389: RAISE FND_API.G_EXC_ERROR;

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

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386:
1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1387: EXCEPTION
1388: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1398: END Check_Sync;
1399:
1400: /*----------------------------------------------------------------
1401: Procedure Out_Transitions

Line 1429: X_return_status := FND_API.G_RET_STS_SUCCESS;

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
1432: l_name := P_name;
1433: l_type := P_type;

Line 1480: X_return_status := FND_API.G_RET_STS_ERROR;

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;
1484: END IF; -- COUNT > 0

Line 1491: WHEN FND_API.G_EXC_ERROR THEN

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;
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: WHEN OTHERS THEN

Line 1492: RAISE FND_API.G_EXC_ERROR;

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

Line 1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1489:
1490: EXCEPTION
1491: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1490: EXCEPTION
1491: WHEN FND_API.G_EXC_ERROR THEN
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');

Line 1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
1501:
1502: END Out_Transitions;
1503:
1504: /*----------------------------------------------------------------

Line 1556: X_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1559: -- Copying passed into locals
1560: l_name := P_name;

Line 1573: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1569: , P_type => OE_GLOBALS.G_WFI_LIN
1570: , X_return_status => l_return_status
1571: );
1572:
1573: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1574: X_return_status := l_return_status;
1575: END IF;
1576: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1576: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1572:
1573: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1574: X_return_status := l_return_status;
1575: END IF;
1576: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;
1579:
1580: G_all_activity_tbl.DELETE;

Line 1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1573: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1574: X_return_status := l_return_status;
1575: END IF;
1576: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1578: END IF;
1579:
1580: G_all_activity_tbl.DELETE;
1581: G_exit_from_loop := 'NO';

Line 1633: X_return_status := FND_API.G_RET_STS_ERROR;

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');
1637: FND_MESSAGE.SET_TOKEN('PROCESS_NAME',Display_Name(l_name,l_type));

Line 1767: X_return_status := FND_API.G_RET_STS_ERROR;

1763: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_activity);
1764: FND_MESSAGE.SET_TOKEN('ACTIVITY2',l_hdr_activity_tbl(hdr_instance).activity_name);
1765: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_order_flow,OE_GLOBALS.G_WFI_HDR));
1766: OE_MSG_PUB.Add;
1767: X_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;
1769: END IF;
1770: END LOOP;
1771: END IF;

Line 1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1799: , P_type => l_all_activity_tbl(testing_instance).type
1800: , P_instance_id => l_all_activity_tbl(testing_instance).instance_id
1801: , X_return_status => l_return_status
1802: );
1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1804: X_return_status := l_return_status;
1805: END IF;
1806: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1806: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1802: );
1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1804: X_return_status := l_return_status;
1805: END IF;
1806: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END IF;
1809: END IF;
1810: END LOOP; -- testing_instance

Line 1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1804: X_return_status := l_return_status;
1805: END IF;
1806: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END IF;
1809: END IF;
1810: END LOOP; -- testing_instance
1811: END IF; -- l_all_activity_tbl.COUNT

Line 1837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1833: , P_instance_id => l_all_activity_tbl(testing_instance).instance_id
1834: , X_return_status => l_return_status
1835: );
1836:
1837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1838: X_return_status := l_return_status;
1839: END IF;
1840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1836:
1837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1838: X_return_status := l_return_status;
1839: END IF;
1840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;
1843: END IF;
1844: END LOOP;

Line 1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1837: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1838: X_return_status := l_return_status;
1839: END IF;
1840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1842: END IF;
1843: END IF;
1844: END LOOP;
1845: END IF;

Line 1880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1876: , P_activity_label => l_all_activity_tbl(l_all_instance).instance_label
1877: , P_api => l_all_activity_tbl(l_all_instance).function
1878: , X_return_status => l_return_status
1879: );
1880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1881: X_return_status := l_return_status;
1882: END IF;
1883: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1883: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1879: );
1880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1881: X_return_status := l_return_status;
1882: END IF;
1883: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: END IF; -- function = DEFER/WAIT
1887: END LOOP; -- l_all_instance

Line 1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1880: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1881: X_return_status := l_return_status;
1882: END IF;
1883: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1885: END IF;
1886: END IF; -- function = DEFER/WAIT
1887: END LOOP; -- l_all_instance
1888:

Line 1925: --WHEN FND_API.G_EXC_ERROR THEN

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

Line 1926: -- RAISE FND_API.G_EXC_ERROR;

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

Line 1927: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
1933: END IF;

Line 1934: 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');
1933: END IF;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:
1936: END Validate_Line_Flow;
1937:
1938: PROCEDURE Validate_Line_Flow /* Bug # 4908592 */

Line 2004: X_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2007: -- Copying passed into locals
2008: l_name := P_name;

Line 2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2016: , p_type => l_type
2017: , x_return_status => l_return_status
2018: );
2019:
2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: X_return_status := l_return_status;
2022: END IF;
2023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2019:
2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: X_return_status := l_return_status;
2022: END IF;
2023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2025: END IF;
2026:
2027: G_all_activity_tbl.DELETE;

Line 2024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2020: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2021: X_return_status := l_return_status;
2022: END IF;
2023: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2025: END IF;
2026:
2027: G_all_activity_tbl.DELETE;
2028: G_exit_from_loop := 'NO';

Line 2143: X_return_status := FND_API.G_RET_STS_ERROR;

2139: FND_MESSAGE.SET_TOKEN('ACTIVITY1',l_activity);
2140: FND_MESSAGE.SET_TOKEN('ACTIVITY2',l_lin_activity_tbl(line_instance).activity_name);
2141: FND_MESSAGE.SET_TOKEN('PROCESS2',Display_Name(l_line_process_name,OE_GLOBALS.G_WFI_LIN));
2142: OE_MSG_PUB.Add;
2143: X_return_status := FND_API.G_RET_STS_ERROR;
2144: END IF;
2145: END IF;
2146: END LOOP;
2147: END IF;

Line 2176: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2172: , P_instance_id => l_all_activity_tbl(testing_instance).instance_id
2173: , x_return_status => l_return_status
2174: );
2175:
2176: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2177: X_return_status := l_return_status;
2178: END IF;
2179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2175:
2176: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2177: X_return_status := l_return_status;
2178: END IF;
2179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2181: END IF;
2182: END IF;
2183:

Line 2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2176: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2177: X_return_status := l_return_status;
2178: END IF;
2179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2181: END IF;
2182: END IF;
2183:
2184: END LOOP; -- testing_instance

Line 2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2207: , P_instance_id => l_all_activity_tbl(instance_count).instance_id
2208: , x_return_status => l_return_status
2209: );
2210:
2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2212: X_return_status := l_return_status;
2213: END IF;
2214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2210:
2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2212: X_return_status := l_return_status;
2213: END IF;
2214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2216: END IF;
2217: END IF;
2218: END LOOP; -- instance_count

Line 2215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2211: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2212: X_return_status := l_return_status;
2213: END IF;
2214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2216: END IF;
2217: END IF;
2218: END LOOP; -- instance_count
2219: END IF; -- l_all_activity_tbl.COUNT

Line 2272: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2268: , P_api => l_all_activity_tbl(l_instance).function
2269: , x_return_status => l_return_status
2270: );
2271:
2272: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2273: X_return_status := l_return_status;
2274: END IF;
2275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2271:
2272: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2273: X_return_status := l_return_status;
2274: END IF;
2275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: END IF; -- function = DEFER/WAIT

Line 2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2272: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2273: X_return_status := l_return_status;
2274: END IF;
2275: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: END IF; -- function = DEFER/WAIT
2280: END LOOP; -- l_instance

Line 2295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
2301: END IF;

Line 2302: 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');
2301: END IF;
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303:
2304: END Validate_Order_flow;
2305:
2306: /*----------------------------------------------------------------

Line 2481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2477: );
2478:
2479: l_msg_total := l_msg_total + l_msg_count;
2480:
2481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: /* Selecting from oe_workflow_assignments distinct order line
2485: (OEOL) internal workflow process names and OM item type

Line 2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2478:
2479: l_msg_total := l_msg_total + l_msg_count;
2480:
2481: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2483: END IF;
2484: /* Selecting from oe_workflow_assignments distinct order line
2485: (OEOL) internal workflow process names and OM item type
2486: combinations assigned to this order type */

Line 2497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2493: , x_return_status => l_return_status
2494: , x_msg_count => l_msg_count
2495: );
2496:
2497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500: END LOOP; -- line_item_processes
2501: /* Selecting from oe_workflow_assignments distinct order line

Line 2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2494: , x_msg_count => l_msg_count
2495: );
2496:
2497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2499: END IF;
2500: END LOOP; -- line_item_processes
2501: /* Selecting from oe_workflow_assignments distinct order line
2502: (OEOL) internal workflow process names assigned to this

Line 2516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2512: , x_msg_data => l_msg_data
2513: );
2514:
2515: l_msg_total := l_msg_total + l_msg_count;
2516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2518: END IF;
2519: END LOOP; -- End Loop line_processes
2520:

Line 2517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2513: );
2514:
2515: l_msg_total := l_msg_total + l_msg_count;
2516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2518: END IF;
2519: END LOOP; -- End Loop line_processes
2520:
2521: END IF;

Line 2539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2535: , x_msg_data => l_msg_data
2536: );
2537:
2538: l_msg_total := l_msg_total + l_msg_count;
2539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2541: END IF;
2542: END LOOP; -- End Loop blanket_processes
2543: END IF; -- IF sales_document_type_code = 'O'/'B'

Line 2540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2536: );
2537:
2538: l_msg_total := l_msg_total + l_msg_count;
2539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2541: END IF;
2542: END LOOP; -- End Loop blanket_processes
2543: END IF; -- IF sales_document_type_code = 'O'/'B'
2544:

Line 2561: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2557: , x_msg_data => l_msg_data
2558: );
2559:
2560: l_msg_total := l_msg_total + l_msg_count;
2561: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: END IF;
2564: END LOOP; -- End Loop negotiation_processes
2565: END IF; -- End of Applicable for Release 11.5.10 + only

Line 2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2558: );
2559:
2560: l_msg_total := l_msg_total + l_msg_count;
2561: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2563: END IF;
2564: END LOOP; -- End Loop negotiation_processes
2565: END IF; -- End of Applicable for Release 11.5.10 + only
2566:

Line 2571: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE); -- #4617652

2567: IF NVL(FND_PROFILE.VALUE('CONC_REQUEST_ID'), 0) <> 0 THEN
2568: -- Called from concurrent request */
2569: IF l_msg_total > 0 THEN
2570: FOR I IN 1 .. l_msg_total LOOP
2571: l_msg_data := to_char(I)||'. '||OE_MSG_PUB.Get(I,FND_API.G_FALSE); -- #4617652
2572: FND_FILE.put_line(FND_FILE.output, l_msg_data);
2573: -- Writing validation messages into the concurrent
2574: -- request output file
2575: END LOOP;

Line 2589: WHEN FND_API.G_EXC_ERROR THEN

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;
2591: errbuf := 'Please check the log file for error messages';
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: retcode := 2;

Line 2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2588: EXCEPTION
2589: WHEN FND_API.G_EXC_ERROR THEN
2590: retcode := 2;
2591: errbuf := 'Please check the log file for error messages';
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: retcode := 2;
2594: errbuf := 'Please check the log file for error messages';
2595: WHEN OTHERS THEN
2596: retcode := 2;