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_MSG_PUB

Line 78: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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;
82: END Display_Name;

Line 79: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
82: END Display_Name;
83:

Line 168: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 169: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
172:
173: END In_Loop;

Line 300: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 301: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
304:
305: END Has_Activity;

Line 471: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 472: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
475:
476: END Get_Activities;

Line 616: OE_MSG_PUB.Add;

612: -- Warning the user to check the value for absolute date
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);

Line 693: OE_MSG_PUB.Add;

689: -- WorkFlow BackGround Engine duration
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:

Line 704: OE_MSG_PUB.Add;

700: -- time.
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:

Line 725: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 726: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
729:
730: END Wait_And_Loops;

Line 819: OE_MSG_PUB.Add;

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
823: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_ASSGN_WNG');

Line 827: OE_MSG_PUB.Add;

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

Line 845: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 846: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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

Line 1029: OE_MSG_PUB.Add;

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

Line 1041: OE_MSG_PUB.Add;

1037: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_SYNC_DEF');
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;

Line 1132: OE_MSG_PUB.Add;

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

Line 1142: OE_MSG_PUB.Add;

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

Line 1189: OE_MSG_PUB.Add;

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

Line 1220: OE_MSG_PUB.Add;

1216: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_line_process,OE_GLOBALS.G_WFI_LIN));
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;

Line 1249: OE_MSG_PUB.Add;

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

Line 1266: OE_MSG_PUB.Add;

1262: -- must be 'MASTER', else it will be an error.
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

Line 1302: OE_MSG_PUB.Add;

1298: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_order_flow,OE_GLOBALS.G_WFI_HDR));
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

Line 1330: OE_MSG_PUB.Add;

1326: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_order_flow,OE_GLOBALS.G_WFI_HDR));
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;

Line 1353: OE_MSG_PUB.Add;

1349: -- be 'DETAIL', else it will be an error.
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:

Line 1370: OE_MSG_PUB.Add;

1366: -- must be 'DETAIL', else it will be an error. */
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

Line 1394: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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;
1398: END Check_Sync;

Line 1395: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
1398: END Check_Sync;
1399:

Line 1478: OE_MSG_PUB.Add;

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

Line 1497: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 1498: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
1501:
1502: END Out_Transitions;

Line 1557: l_msg_count := OE_MSG_PUB.count_msg;

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;
1561: l_type := OE_GLOBALS.G_WFI_LIN;

Line 1631: OE_MSG_PUB.Add;

1627: FND_MESSAGE.SET_TOKEN('FULFILLMENT_ACTIVITY'
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

Line 1642: OE_MSG_PUB.Add;

1638: FND_MESSAGE.SET_TOKEN('ACTIVITY1'
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

Line 1663: OE_MSG_PUB.Add;

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

Line 1766: OE_MSG_PUB.Add;

1762: FND_MESSAGE.SET_TOKEN('PROCESS1',Display_Name(l_name,OE_GLOBALS.G_WFI_LIN));
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;

Line 1858: OE_MSG_PUB.Add;

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

Line 1908: OE_MSG_PUB.Add;

1904: FND_MESSAGE.SET_NAME('ONT','OE_WFVAL_ACT_ORDER');
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:

Line 1913: X_msg_count := OE_MSG_PUB.count_msg - l_msg_count;

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

Line 1917: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);

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;
1919:
1920: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Line_Flow', 1);
1921: --l_end_time := dbms_utility.get_time;

Line 1931: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:

Line 1932: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935:
1936: END Validate_Line_Flow;

Line 2005: l_msg_count := OE_MSG_PUB.count_msg;

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;
2009: l_type := P_type;

Line 2142: OE_MSG_PUB.Add;

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

Line 2232: OE_MSG_PUB.Add;

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

Line 2247: OE_MSG_PUB.Add;

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

Line 2284: X_msg_count := OE_MSG_PUB.count_msg - l_msg_count;

2280: END LOOP; -- l_instance
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;

Line 2287: X_msg_data := OE_MSG_PUB.get(l_msg_count + 1);

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:
2290: oe_debug_pub.add('Exiting Procedure OE_VALIDATE_WF.Validate_Order_flow', 1);
2291: -- l_end_time := dbms_utility.get_time;

Line 2299: IF OE_MSG_PUB.CHECK_MSG_LEVEL(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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;
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303:

Line 2300: OE_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME, 'Validate');

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;
2302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2303:
2304: END Validate_Order_flow;

Line 2427: OE_MSG_PUB.Initialize;

2423: FND_FILE.put_line(FND_FILE.output,'Please correct the following reported Errors/Warnings, if any -'); --, in the respective Order Types -'); Changed for bug 4438936
2424: IF l_transaction_tbl.COUNT > 0 THEN
2425: FOR l_record_count IN l_transaction_tbl.First .. l_transaction_tbl.Last LOOP
2426:
2427: OE_MSG_PUB.Initialize;
2428: l_msg_total := 0;
2429:
2430: BEGIN
2431: SELECT name

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;