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.PO_ASL_API_GRP dependencies on PO_ASL_ATTRIBUTES

Line 120: UPDATE po_asl_attributes_gt PAA

116:
117: l_progress := 15;
118: po_asl_api_pvt.log('count at prg ' || l_progress || ':' || SQL%ROWCOUNT);
119:
120: UPDATE po_asl_attributes_gt PAA
121: SET asl_id = (SELECT asl_id
122: FROM po_approved_supplier_list_gt PASL
123: WHERE PASL.user_key = PAA.user_key
124: AND ROWNUM < 2);

Line 225: 'po_asl_attributes_gt' ,

221:
222: --Reject records if attributes mode is add, asl mode is update/delete and
223: --attributes already exists for that org
224: SELECT PAAGT.user_key ,
225: 'po_asl_attributes_gt' ,
226: fnd_message.get_string('PO','DUPLICATE_ATTRIBUTES')
227: BULK COLLECT INTO
228: l_user_key_tbl ,
229: l_entity_name ,

Line 231: FROM po_asl_attributes_gt PAAGT,

227: BULK COLLECT INTO
228: l_user_key_tbl ,
229: l_entity_name ,
230: l_reject_reason
231: FROM po_asl_attributes_gt PAAGT,
232: po_approved_supplier_list_gt ASLGT
233: WHERE EXISTS
234: (SELECT 1
235: FROM po_asl_attributes PAA

Line 235: FROM po_asl_attributes PAA

231: FROM po_asl_attributes_gt PAAGT,
232: po_approved_supplier_list_gt ASLGT
233: WHERE EXISTS
234: (SELECT 1
235: FROM po_asl_attributes PAA
236: WHERE PAAGT.asl_id = PAA.asl_id
237: AND PAAGT.using_organization_id = PAA.using_organization_id)
238: AND ASLGT.user_key = PAAGT.user_key
239: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

Line 250: 'po_asl_attributes_gt' ,

246:
247: --Reject records if attributes mode is add, asl mode is create and
248: --attributes already exists for that org, i.e., duplicate input
249: SELECT PAAGT.user_key ,
250: 'po_asl_attributes_gt' ,
251: fnd_message.get_string('PO','DUPLICATE_ATTRIBUTES')
252: BULK COLLECT INTO
253: l_user_key_tbl ,
254: l_entity_name ,

Line 256: FROM po_asl_attributes_gt PAAGT,

252: BULK COLLECT INTO
253: l_user_key_tbl ,
254: l_entity_name ,
255: l_reject_reason
256: FROM po_asl_attributes_gt PAAGT,
257: po_approved_supplier_list_gt ASLGT
258: WHERE 2 <=
259: (SELECT Count(user_key)
260: FROM po_asl_attributes_gt PAA

Line 260: FROM po_asl_attributes_gt PAA

256: FROM po_asl_attributes_gt PAAGT,
257: po_approved_supplier_list_gt ASLGT
258: WHERE 2 <=
259: (SELECT Count(user_key)
260: FROM po_asl_attributes_gt PAA
261: WHERE PAAGT.asl_id = PAA.asl_id
262: AND PAAGT.using_organization_id = PAA.using_organization_id)
263: AND ASLGT.user_key = PAAGT.user_key
264: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 275: 'po_asl_attributes_gt' ,

271:
272: --Reject records if attributes mode is delete, asl mode is update and
273: --attributes doesn't exists for that org
274: SELECT PAAGT.user_key ,
275: 'po_asl_attributes_gt' ,
276: fnd_message.get_string('PO','ATTRIBUTES_NOT_EXIST')
277: BULK COLLECT INTO
278: l_user_key_tbl ,
279: l_entity_name ,

Line 281: FROM po_asl_attributes_gt PAAGT,

277: BULK COLLECT INTO
278: l_user_key_tbl ,
279: l_entity_name ,
280: l_reject_reason
281: FROM po_asl_attributes_gt PAAGT,
282: po_approved_supplier_list_gt ASLGT
283: WHERE NOT EXISTS
284: (SELECT 1
285: FROM po_asl_attributes PAA

Line 285: FROM po_asl_attributes PAA

281: FROM po_asl_attributes_gt PAAGT,
282: po_approved_supplier_list_gt ASLGT
283: WHERE NOT EXISTS
284: (SELECT 1
285: FROM po_asl_attributes PAA
286: WHERE PAAGT.asl_id = PAA.asl_id
287: AND PAAGT.using_organization_id = PAA.using_organization_id)
288: AND ASLGT.user_key = PAAGT.user_key
289: AND ASLGT.process_action = PO_ASL_API_PUB.g_ACTION_UPDATE

Line 809: FROM po_asl_attributes_gt PAA

805: WHERE Upper(ASLGT.vendor_business_type) = 'MANUFACTURER'
806: AND
807: (EXISTS
808: (SELECT 1
809: FROM po_asl_attributes_gt PAA
810: WHERE PAA.asl_id = ASLGT.asl_id
811: AND PAA.user_key = ASLGT.user_key)
812: OR
813: EXISTS

Line 877: -- This will validate data in po_asl_attributes_gt table

873:
874: --Name: validate_asl_attr_gt
875:
876: --Function:
877: -- This will validate data in po_asl_attributes_gt table
878:
879: --Parameters:
880:
881: --OUT:

Line 917: 'po_asl_attributes_gt' AS entity ,

913: l_reject_reason
914: FROM (
915: --Reject records if item or site is null and country code is not null
916: SELECT user_key ,
917: 'po_asl_attributes_gt' AS entity ,
918: fnd_message.get_string('PO','COUNTRY_CODE_NOT_EMPTY') AS msg
919: FROM po_asl_attributes_gt PAAGT
920: WHERE (PAAGT.item_id IS NULL
921: OR PAAGT.vendor_site_id IS NULL)

Line 919: FROM po_asl_attributes_gt PAAGT

915: --Reject records if item or site is null and country code is not null
916: SELECT user_key ,
917: 'po_asl_attributes_gt' AS entity ,
918: fnd_message.get_string('PO','COUNTRY_CODE_NOT_EMPTY') AS msg
919: FROM po_asl_attributes_gt PAAGT
920: WHERE (PAAGT.item_id IS NULL
921: OR PAAGT.vendor_site_id IS NULL)
922: AND PAAGT.country_of_origin_code_dsp IS NOT NULL
923:

Line 928: 'po_asl_attributes_gt' AS entity ,

924: UNION ALL
925: --Reject records if Purchasing UOM empty and enable_plan_schedule_flag or
926: --enable_ship_schedule_flag is checked
927: SELECT user_key ,
928: 'po_asl_attributes_gt' AS entity ,
929: fnd_message.get_string('PO','PURCHASING_UOM_MANDATORY') AS msg
930: FROM po_asl_attributes_gt PAAGT
931: WHERE (PAAGT.enable_plan_schedule_flag_dsp = 'Y'
932: OR PAAGT.enable_ship_schedule_flag_dsp = 'Y')

Line 930: FROM po_asl_attributes_gt PAAGT

926: --enable_ship_schedule_flag is checked
927: SELECT user_key ,
928: 'po_asl_attributes_gt' AS entity ,
929: fnd_message.get_string('PO','PURCHASING_UOM_MANDATORY') AS msg
930: FROM po_asl_attributes_gt PAAGT
931: WHERE (PAAGT.enable_plan_schedule_flag_dsp = 'Y'
932: OR PAAGT.enable_ship_schedule_flag_dsp = 'Y')
933: AND (PAAGT.purchasing_unit_of_measure_dsp IS NULL
934: OR Trim(PAAGT.purchasing_unit_of_measure_dsp) = '')

Line 941: 'po_asl_attributes_gt' AS entity ,

937: --Reject records if enable_autoschedule_flag is Y when
938: --enable_plan_schedule_flag_dsp and enable_ship_schedule_flag_dsp
939: --are unchecked.
940: SELECT user_key ,
941: 'po_asl_attributes_gt' AS entity ,
942: fnd_message.get_string('PO','INVALID_AUTOSCHEDULE_FLAG') AS msg
943: FROM po_asl_attributes_gt PAAGT
944: WHERE Nvl(PAAGT.enable_plan_schedule_flag_dsp,'N') <> 'Y'
945: AND Nvl(PAAGT.enable_ship_schedule_flag_dsp,'N') <> 'Y'

Line 943: FROM po_asl_attributes_gt PAAGT

939: --are unchecked.
940: SELECT user_key ,
941: 'po_asl_attributes_gt' AS entity ,
942: fnd_message.get_string('PO','INVALID_AUTOSCHEDULE_FLAG') AS msg
943: FROM po_asl_attributes_gt PAAGT
944: WHERE Nvl(PAAGT.enable_plan_schedule_flag_dsp,'N') <> 'Y'
945: AND Nvl(PAAGT.enable_ship_schedule_flag_dsp,'N') <> 'Y'
946: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'
947:

Line 952: 'po_asl_attributes_gt' AS entity ,

948: UNION ALL
949: --Reject records if plan bucket pattern empty if enable_autoschedule_flag
950: --and enable_plan_schedule_flag enabled
951: SELECT user_key ,
952: 'po_asl_attributes_gt' AS entity ,
953: fnd_message.get_string('PO','PLAN_BUCKET_MANDATORY') AS msg
954: FROM po_asl_attributes_gt PAAGT
955: WHERE PAAGT.enable_plan_schedule_flag_dsp = 'Y'
956: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'

Line 954: FROM po_asl_attributes_gt PAAGT

950: --and enable_plan_schedule_flag enabled
951: SELECT user_key ,
952: 'po_asl_attributes_gt' AS entity ,
953: fnd_message.get_string('PO','PLAN_BUCKET_MANDATORY') AS msg
954: FROM po_asl_attributes_gt PAAGT
955: WHERE PAAGT.enable_plan_schedule_flag_dsp = 'Y'
956: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'
957: AND PAAGT.plan_bucket_pattern_id IS NULL
958:

Line 963: 'po_asl_attributes_gt' AS entity ,

959: UNION ALL
960: --Reject records if plan schedule type empty if enable_autoschedule_flag
961: --and enable_plan_schedule_flag enabled
962: SELECT user_key ,
963: 'po_asl_attributes_gt' AS entity ,
964: fnd_message.get_string('PO','PLAN_SCHEDULE_MANDATORY') AS msg
965: FROM po_asl_attributes_gt PAAGT
966: WHERE PAAGT.enable_plan_schedule_flag_dsp = 'Y'
967: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'

Line 965: FROM po_asl_attributes_gt PAAGT

961: --and enable_plan_schedule_flag enabled
962: SELECT user_key ,
963: 'po_asl_attributes_gt' AS entity ,
964: fnd_message.get_string('PO','PLAN_SCHEDULE_MANDATORY') AS msg
965: FROM po_asl_attributes_gt PAAGT
966: WHERE PAAGT.enable_plan_schedule_flag_dsp = 'Y'
967: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'
968: AND (PAAGT.plan_schedule_type IS NULL
969: OR Trim(PAAGT.plan_schedule_type) = ''));

Line 987: 'po_asl_attributes_gt' AS entity ,

983: FROM (
984: --Reject records if ship bucket pattern empty if enable_autoschedule_flag
985: --and enable_ship_schedule_flag enabled
986: SELECT user_key ,
987: 'po_asl_attributes_gt' AS entity ,
988: fnd_message.get_string('PO','SHIP_BUCKET_MANDATORY') AS msg
989: FROM po_asl_attributes_gt PAAGT
990: WHERE PAAGT.enable_ship_schedule_flag_dsp = 'Y'
991: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'

Line 989: FROM po_asl_attributes_gt PAAGT

985: --and enable_ship_schedule_flag enabled
986: SELECT user_key ,
987: 'po_asl_attributes_gt' AS entity ,
988: fnd_message.get_string('PO','SHIP_BUCKET_MANDATORY') AS msg
989: FROM po_asl_attributes_gt PAAGT
990: WHERE PAAGT.enable_ship_schedule_flag_dsp = 'Y'
991: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'
992: AND PAAGT.ship_bucket_pattern_id IS NULL
993:

Line 998: 'po_asl_attributes_gt' AS entity ,

994: UNION ALL
995: --Reject records if ship schedule type empty if enable_autoschedule_flag
996: --and enable_ship_schedule_flag enabled
997: SELECT user_key ,
998: 'po_asl_attributes_gt' AS entity ,
999: fnd_message.get_string('PO','SHIP_SCHEDULE_MANDATORY') AS msg
1000: FROM po_asl_attributes_gt PAAGT
1001: WHERE PAAGT.enable_ship_schedule_flag_dsp = 'Y'
1002: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'

Line 1000: FROM po_asl_attributes_gt PAAGT

996: --and enable_ship_schedule_flag enabled
997: SELECT user_key ,
998: 'po_asl_attributes_gt' AS entity ,
999: fnd_message.get_string('PO','SHIP_SCHEDULE_MANDATORY') AS msg
1000: FROM po_asl_attributes_gt PAAGT
1001: WHERE PAAGT.enable_ship_schedule_flag_dsp = 'Y'
1002: AND PAAGT.enable_autoschedule_flag_dsp = 'Y'
1003: AND (PAAGT.ship_schedule_type IS NULL
1004: OR Trim(PAAGT.ship_schedule_type) = '')

Line 1010: 'po_asl_attributes_gt' AS entity ,

1006: UNION ALL
1007: --Reject records if there is an entry in po_supplier_item_capacity_gt
1008: -- when global_flag is N and VMI flag is not checked
1009: SELECT PAAGT.user_key ,
1010: 'po_asl_attributes_gt' AS entity ,
1011: fnd_message.get_string('PO','INVALID_SUPP_ITEM_CAP_ENTRY') AS msg
1012: FROM po_asl_attributes_gt PAAGT,
1013: po_approved_supplier_list_gt ASLGT
1014: WHERE PAAGT.user_key = ASLGT.user_key

Line 1012: FROM po_asl_attributes_gt PAAGT,

1008: -- when global_flag is N and VMI flag is not checked
1009: SELECT PAAGT.user_key ,
1010: 'po_asl_attributes_gt' AS entity ,
1011: fnd_message.get_string('PO','INVALID_SUPP_ITEM_CAP_ENTRY') AS msg
1012: FROM po_asl_attributes_gt PAAGT,
1013: po_approved_supplier_list_gt ASLGT
1014: WHERE PAAGT.user_key = ASLGT.user_key
1015: AND ASLGT.using_organization_id <> -1
1016: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'

Line 1043: 'po_asl_attributes_gt' AS entity ,

1039: FROM (
1040: --Reject records if plan bucket pattern is not empty if
1041: --enable_autoschedule_flag or enable_plan_schedule_flag disabled
1042: SELECT user_key ,
1043: 'po_asl_attributes_gt' AS entity ,
1044: fnd_message.get_string('PO','INVALID_PLAN_BUCKET') AS msg
1045: FROM po_asl_attributes_gt PAAGT
1046: WHERE (Nvl(PAAGT.enable_plan_schedule_flag_dsp, 'N') <> 'Y'
1047: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')

Line 1045: FROM po_asl_attributes_gt PAAGT

1041: --enable_autoschedule_flag or enable_plan_schedule_flag disabled
1042: SELECT user_key ,
1043: 'po_asl_attributes_gt' AS entity ,
1044: fnd_message.get_string('PO','INVALID_PLAN_BUCKET') AS msg
1045: FROM po_asl_attributes_gt PAAGT
1046: WHERE (Nvl(PAAGT.enable_plan_schedule_flag_dsp, 'N') <> 'Y'
1047: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')
1048: AND PAAGT.plan_bucket_pattern_id IS NOT NULL
1049:

Line 1054: 'po_asl_attributes_gt' AS entity ,

1050: UNION ALL
1051: --Reject records if plan schedule type not empty if
1052: --enable_autoschedule_flag or enable_plan_schedule_flag disabled
1053: SELECT user_key ,
1054: 'po_asl_attributes_gt' AS entity ,
1055: fnd_message.get_string('PO','INVALID_PLAN_SCHEDULE') AS msg
1056: FROM po_asl_attributes_gt PAAGT
1057: WHERE (Nvl(PAAGT.enable_plan_schedule_flag_dsp, 'N') <> 'Y'
1058: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')

Line 1056: FROM po_asl_attributes_gt PAAGT

1052: --enable_autoschedule_flag or enable_plan_schedule_flag disabled
1053: SELECT user_key ,
1054: 'po_asl_attributes_gt' AS entity ,
1055: fnd_message.get_string('PO','INVALID_PLAN_SCHEDULE') AS msg
1056: FROM po_asl_attributes_gt PAAGT
1057: WHERE (Nvl(PAAGT.enable_plan_schedule_flag_dsp, 'N') <> 'Y'
1058: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')
1059: AND PAAGT.plan_schedule_type IS NOT NULL
1060:

Line 1065: 'po_asl_attributes_gt' AS entity ,

1061: UNION ALL
1062: --Reject records if ship bucket pattern not empty if
1063: --enable_autoschedule_flag or enable_ship_schedule_flag disabled
1064: SELECT user_key ,
1065: 'po_asl_attributes_gt' AS entity ,
1066: fnd_message.get_string('PO','INVALID_SHIP_BUCKET') AS msg
1067: FROM po_asl_attributes_gt PAAGT
1068: WHERE (Nvl(PAAGT.enable_ship_schedule_flag_dsp, 'N') <> 'Y'
1069: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')

Line 1067: FROM po_asl_attributes_gt PAAGT

1063: --enable_autoschedule_flag or enable_ship_schedule_flag disabled
1064: SELECT user_key ,
1065: 'po_asl_attributes_gt' AS entity ,
1066: fnd_message.get_string('PO','INVALID_SHIP_BUCKET') AS msg
1067: FROM po_asl_attributes_gt PAAGT
1068: WHERE (Nvl(PAAGT.enable_ship_schedule_flag_dsp, 'N') <> 'Y'
1069: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')
1070: AND PAAGT.ship_bucket_pattern_id IS NOT NULL
1071:

Line 1076: 'po_asl_attributes_gt' AS entity ,

1072: UNION ALL
1073: --Reject records if ship schedule type not empty if
1074: --enable_autoschedule_flag or enable_ship_schedule_flag disabled
1075: SELECT user_key ,
1076: 'po_asl_attributes_gt' AS entity ,
1077: fnd_message.get_string('PO','INVALID_SHIP_SCHEDULE') AS msg
1078: FROM po_asl_attributes_gt PAAGT
1079: WHERE (Nvl(PAAGT.enable_ship_schedule_flag_dsp, 'N') <> 'Y'
1080: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')

Line 1078: FROM po_asl_attributes_gt PAAGT

1074: --enable_autoschedule_flag or enable_ship_schedule_flag disabled
1075: SELECT user_key ,
1076: 'po_asl_attributes_gt' AS entity ,
1077: fnd_message.get_string('PO','INVALID_SHIP_SCHEDULE') AS msg
1078: FROM po_asl_attributes_gt PAAGT
1079: WHERE (Nvl(PAAGT.enable_ship_schedule_flag_dsp, 'N') <> 'Y'
1080: OR Nvl(PAAGT.enable_autoschedule_flag_dsp, 'N') <> 'Y')
1081: AND PAAGT.ship_schedule_type IS NOT NULL
1082: );

Line 1100: 'po_asl_attributes_gt' AS entity ,

1096: FROM (
1097: --Reject records if authorization flag is not checked and
1098: --there is an entry for chv_authorizations in case of CREATE
1099: SELECT user_key ,
1100: 'po_asl_attributes_gt' AS entity ,
1101: fnd_message.get_string('PO','INVALID_AUTHORIZATION_ENTRY') AS msg
1102: FROM po_asl_attributes_gt PAAGT
1103: WHERE NVL(PAAGT.enable_authorizations_flag_dsp,'N') <> 'Y'
1104: AND EXISTS

Line 1102: FROM po_asl_attributes_gt PAAGT

1098: --there is an entry for chv_authorizations in case of CREATE
1099: SELECT user_key ,
1100: 'po_asl_attributes_gt' AS entity ,
1101: fnd_message.get_string('PO','INVALID_AUTHORIZATION_ENTRY') AS msg
1102: FROM po_asl_attributes_gt PAAGT
1103: WHERE NVL(PAAGT.enable_authorizations_flag_dsp,'N') <> 'Y'
1104: AND EXISTS
1105: (SELECT 1
1106: FROM chv_authorizations_gt CHV

Line 1116: 'po_asl_attributes_gt' AS entity ,

1112: UNION ALL
1113: --Reject records if there is an entry in po_supplier_item_tolerance_gt
1114: -- when global_flag is N and VMI flag is not checked
1115: SELECT PAAGT.user_key ,
1116: 'po_asl_attributes_gt' AS entity ,
1117: fnd_message.get_string('PO','INVALID_SUPP_ITEM_TOL_ENTRY') AS msg
1118: FROM po_asl_attributes_gt PAAGT,
1119: po_approved_supplier_list_gt ASLGT
1120: WHERE PAAGT.user_key = ASLGT.user_key

Line 1118: FROM po_asl_attributes_gt PAAGT,

1114: -- when global_flag is N and VMI flag is not checked
1115: SELECT PAAGT.user_key ,
1116: 'po_asl_attributes_gt' AS entity ,
1117: fnd_message.get_string('PO','INVALID_SUPP_ITEM_TOL_ENTRY') AS msg
1118: FROM po_asl_attributes_gt PAAGT,
1119: po_approved_supplier_list_gt ASLGT
1120: WHERE PAAGT.user_key = ASLGT.user_key
1121: AND ASLGT.using_organization_id <> -1
1122: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'

Line 1134: 'po_asl_attributes_gt' AS entity ,

1130:
1131: UNION ALL
1132: --Reject records if Price Update tolerance is -ve number
1133: SELECT user_key ,
1134: 'po_asl_attributes_gt' AS entity ,
1135: fnd_message.get_string('PO','INVALID_PRICE_UPDATE_TOLERANCE') AS msg
1136: FROM po_asl_attributes_gt PAAGT
1137: WHERE PAAGT.price_update_tolerance_dsp < 0);
1138:

Line 1136: FROM po_asl_attributes_gt PAAGT

1132: --Reject records if Price Update tolerance is -ve number
1133: SELECT user_key ,
1134: 'po_asl_attributes_gt' AS entity ,
1135: fnd_message.get_string('PO','INVALID_PRICE_UPDATE_TOLERANCE') AS msg
1136: FROM po_asl_attributes_gt PAAGT
1137: WHERE PAAGT.price_update_tolerance_dsp < 0);
1138:
1139: l_progress := 40;
1140: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 1155: 'po_asl_attributes_gt' AS entity ,

1151: FROM (
1152: --Reject records if delivery calendar code is entered when global_flag is N
1153: --or VMI flag is not checked
1154: SELECT user_key ,
1155: 'po_asl_attributes_gt' AS entity ,
1156: fnd_message.get_string('PO','DELIVERY_CALENDAR_NOT_NULL') AS msg
1157: FROM po_asl_attributes_gt PAAGT
1158: WHERE PAAGT.delivery_calendar_dsp IS NOT NULL
1159: AND PAAGT.using_organization_id <> -1

Line 1157: FROM po_asl_attributes_gt PAAGT

1153: --or VMI flag is not checked
1154: SELECT user_key ,
1155: 'po_asl_attributes_gt' AS entity ,
1156: fnd_message.get_string('PO','DELIVERY_CALENDAR_NOT_NULL') AS msg
1157: FROM po_asl_attributes_gt PAAGT
1158: WHERE PAAGT.delivery_calendar_dsp IS NOT NULL
1159: AND PAAGT.using_organization_id <> -1
1160: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1161:

Line 1165: 'po_asl_attributes_gt' AS entity ,

1161:
1162: UNION ALL
1163: --Reject records if delivery calendar code is entered and not valid
1164: SELECT user_key ,
1165: 'po_asl_attributes_gt' AS entity ,
1166: fnd_message.get_string('PO','INVALID_DELIVERY_CALENDAR_CODE') AS msg
1167: FROM po_asl_attributes_gt PAAGT
1168: WHERE PAAGT.delivery_calendar_dsp IS NOT NULL
1169: AND NOT EXISTS

Line 1167: FROM po_asl_attributes_gt PAAGT

1163: --Reject records if delivery calendar code is entered and not valid
1164: SELECT user_key ,
1165: 'po_asl_attributes_gt' AS entity ,
1166: fnd_message.get_string('PO','INVALID_DELIVERY_CALENDAR_CODE') AS msg
1167: FROM po_asl_attributes_gt PAAGT
1168: WHERE PAAGT.delivery_calendar_dsp IS NOT NULL
1169: AND NOT EXISTS
1170: (SELECT 1
1171: FROM bom_calendars BOM

Line 1179: 'po_asl_attributes_gt' AS entity ,

1175: UNION ALL
1176: --Reject records if delivery calendar code is entered when global_flag is N
1177: --or VMI flag is not checked
1178: SELECT user_key ,
1179: 'po_asl_attributes_gt' AS entity ,
1180: fnd_message.get_string('PO','PROCESSING_LEAD_TIME_NOT_NULL') AS msg
1181: FROM po_asl_attributes_gt PAAGT
1182: WHERE PAAGT.processing_lead_time_dsp IS NOT NULL
1183: AND PAAGT.using_organization_id <> -1

Line 1181: FROM po_asl_attributes_gt PAAGT

1177: --or VMI flag is not checked
1178: SELECT user_key ,
1179: 'po_asl_attributes_gt' AS entity ,
1180: fnd_message.get_string('PO','PROCESSING_LEAD_TIME_NOT_NULL') AS msg
1181: FROM po_asl_attributes_gt PAAGT
1182: WHERE PAAGT.processing_lead_time_dsp IS NOT NULL
1183: AND PAAGT.using_organization_id <> -1
1184: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1185:

Line 1189: 'po_asl_attributes_gt' AS entity ,

1185:
1186: UNION ALL
1187: --Reject records if Processing lead time is -ve number or zero
1188: SELECT user_key ,
1189: 'po_asl_attributes_gt' AS entity ,
1190: fnd_message.get_string('PO','INVALID_PROCESSING_LEAD_TIME') AS msg
1191: FROM po_asl_attributes_gt PAAGT
1192: WHERE PAAGT.processing_lead_time_dsp <= 0);
1193:

Line 1191: FROM po_asl_attributes_gt PAAGT

1187: --Reject records if Processing lead time is -ve number or zero
1188: SELECT user_key ,
1189: 'po_asl_attributes_gt' AS entity ,
1190: fnd_message.get_string('PO','INVALID_PROCESSING_LEAD_TIME') AS msg
1191: FROM po_asl_attributes_gt PAAGT
1192: WHERE PAAGT.processing_lead_time_dsp <= 0);
1193:
1194: l_progress := 50;
1195: l_user_key_tbl1 := l_user_key_tbl1 MULTISET UNION ALL l_user_key_tbl ;

Line 1209: 'po_asl_attributes_gt' AS entity ,

1205: l_reject_reason
1206: FROM (
1207: --Reject records if Min Order Qty is -ve number or zero
1208: SELECT user_key ,
1209: 'po_asl_attributes_gt' AS entity ,
1210: fnd_message.get_string('PO','INVALID_MIN_ORDER_QTY') AS msg
1211: FROM po_asl_attributes_gt PAAGT
1212: WHERE PAAGT.min_order_qty_dsp <= 0
1213:

Line 1211: FROM po_asl_attributes_gt PAAGT

1207: --Reject records if Min Order Qty is -ve number or zero
1208: SELECT user_key ,
1209: 'po_asl_attributes_gt' AS entity ,
1210: fnd_message.get_string('PO','INVALID_MIN_ORDER_QTY') AS msg
1211: FROM po_asl_attributes_gt PAAGT
1212: WHERE PAAGT.min_order_qty_dsp <= 0
1213:
1214: UNION ALL
1215: --Reject records if fixed lot multiple is -ve number or zero

Line 1217: 'po_asl_attributes_gt' AS entity ,

1213:
1214: UNION ALL
1215: --Reject records if fixed lot multiple is -ve number or zero
1216: SELECT user_key ,
1217: 'po_asl_attributes_gt' AS entity ,
1218: fnd_message.get_string('PO','INVALID_FIXED_LOT_MULTIPLE') AS msg
1219: FROM po_asl_attributes_gt PAAGT
1220: WHERE PAAGT.fixed_lot_multiple_dsp <= 0
1221:

Line 1219: FROM po_asl_attributes_gt PAAGT

1215: --Reject records if fixed lot multiple is -ve number or zero
1216: SELECT user_key ,
1217: 'po_asl_attributes_gt' AS entity ,
1218: fnd_message.get_string('PO','INVALID_FIXED_LOT_MULTIPLE') AS msg
1219: FROM po_asl_attributes_gt PAAGT
1220: WHERE PAAGT.fixed_lot_multiple_dsp <= 0
1221:
1222: UNION ALL
1223: --Reject records if enable_vmi_flag is checked when site is null or

Line 1227: 'po_asl_attributes_gt' AS entity ,

1223: --Reject records if enable_vmi_flag is checked when site is null or
1224: --ASL created for commodity or PO_THIRD_PARTY_STOCK_GRP.validate_local_asl
1225: --retunrs false
1226: SELECT user_key ,
1227: 'po_asl_attributes_gt' AS entity ,
1228: fnd_message.get_string('PO','INVALID_VMI_FLAG') AS msg
1229: FROM po_asl_attributes_gt PAAGT
1230: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1231: AND (PAAGT.vendor_site_id IS NULL

Line 1229: FROM po_asl_attributes_gt PAAGT

1225: --retunrs false
1226: SELECT user_key ,
1227: 'po_asl_attributes_gt' AS entity ,
1228: fnd_message.get_string('PO','INVALID_VMI_FLAG') AS msg
1229: FROM po_asl_attributes_gt PAAGT
1230: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1231: AND (PAAGT.vendor_site_id IS NULL
1232: OR PAAGT.item_id IS NULL
1233: OR validate_vmi(

Line 1253: 'po_asl_attributes_gt' AS entity ,

1249: l_reject_reason
1250: FROM (
1251: --Reject records if vmi_flag is not checked and automatic allowed is checked
1252: SELECT user_key ,
1253: 'po_asl_attributes_gt' AS entity ,
1254: fnd_message.get_string('PO','INVALID_AUTO_REPLENISH_FLAG') AS msg
1255: FROM po_asl_attributes_gt PAAGT
1256: WHERE Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1257: AND PAAGT.enable_vmi_auto_replenish_flag = 'Y'

Line 1255: FROM po_asl_attributes_gt PAAGT

1251: --Reject records if vmi_flag is not checked and automatic allowed is checked
1252: SELECT user_key ,
1253: 'po_asl_attributes_gt' AS entity ,
1254: fnd_message.get_string('PO','INVALID_AUTO_REPLENISH_FLAG') AS msg
1255: FROM po_asl_attributes_gt PAAGT
1256: WHERE Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1257: AND PAAGT.enable_vmi_auto_replenish_flag = 'Y'
1258:
1259: UNION ALL

Line 1263: 'po_asl_attributes_gt' AS entity ,

1259: UNION ALL
1260: --Reject records if vmi_flag is not checked and replenishment
1261: --method is entered
1262: SELECT user_key ,
1263: 'po_asl_attributes_gt' AS entity ,
1264: fnd_message.get_string('PO','INVALID_REPLENISH_METHOD') AS msg
1265: FROM po_asl_attributes_gt PAAGT
1266: WHERE Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1267: AND PAAGT.replenishment_method IS NOT NULL

Line 1265: FROM po_asl_attributes_gt PAAGT

1261: --method is entered
1262: SELECT user_key ,
1263: 'po_asl_attributes_gt' AS entity ,
1264: fnd_message.get_string('PO','INVALID_REPLENISH_METHOD') AS msg
1265: FROM po_asl_attributes_gt PAAGT
1266: WHERE Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'
1267: AND PAAGT.replenishment_method IS NOT NULL
1268:
1269: UNION ALL

Line 1273: 'po_asl_attributes_gt' AS entity ,

1269: UNION ALL
1270: --Reject records if automatic allowed is not checked and replenishment
1271: --approval is not 'SUPPLIER_OR_BUYER'
1272: SELECT user_key ,
1273: 'po_asl_attributes_gt' AS entity ,
1274: fnd_message.get_string('PO','INVALID_REPLENISH_APPROVAL') AS msg
1275: FROM po_asl_attributes_gt PAAGT
1276: WHERE Nvl(PAAGT.enable_vmi_auto_replenish_flag,'N') <> 'Y'
1277: AND PAAGT.vmi_replenishment_approval <>'SUPPLIER_OR_BUYER'

Line 1275: FROM po_asl_attributes_gt PAAGT

1271: --approval is not 'SUPPLIER_OR_BUYER'
1272: SELECT user_key ,
1273: 'po_asl_attributes_gt' AS entity ,
1274: fnd_message.get_string('PO','INVALID_REPLENISH_APPROVAL') AS msg
1275: FROM po_asl_attributes_gt PAAGT
1276: WHERE Nvl(PAAGT.enable_vmi_auto_replenish_flag,'N') <> 'Y'
1277: AND PAAGT.vmi_replenishment_approval <>'SUPPLIER_OR_BUYER'
1278: AND PAAGT.vmi_replenishment_approval IS NOT NULL
1279:

Line 1284: 'po_asl_attributes_gt' AS entity ,

1280: UNION ALL
1281: --Reject records if vmi_flag, automatic allowed is checked and
1282: --replenishment approval is empty
1283: SELECT user_key ,
1284: 'po_asl_attributes_gt' AS entity ,
1285: fnd_message.get_string('PO','REPLENISH_APPROVAL_REQUIRED') AS msg
1286: FROM po_asl_attributes_gt PAAGT
1287: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1288: AND PAAGT.enable_vmi_auto_replenish_flag = 'Y'

Line 1286: FROM po_asl_attributes_gt PAAGT

1282: --replenishment approval is empty
1283: SELECT user_key ,
1284: 'po_asl_attributes_gt' AS entity ,
1285: fnd_message.get_string('PO','REPLENISH_APPROVAL_REQUIRED') AS msg
1286: FROM po_asl_attributes_gt PAAGT
1287: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1288: AND PAAGT.enable_vmi_auto_replenish_flag = 'Y'
1289: AND PAAGT.vmi_replenishment_approval IS NULL
1290:

Line 1295: 'po_asl_attributes_gt' AS entity ,

1291:
1292: UNION ALL
1293: --Reject records if vmi_flag is checked and replenishment method is empty
1294: SELECT user_key ,
1295: 'po_asl_attributes_gt' AS entity ,
1296: fnd_message.get_string('PO','REPLENISH_METHOD_REQUIRED') AS msg
1297: FROM po_asl_attributes_gt PAAGT
1298: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1299: AND PAAGT.replenishment_method IS NULL

Line 1297: FROM po_asl_attributes_gt PAAGT

1293: --Reject records if vmi_flag is checked and replenishment method is empty
1294: SELECT user_key ,
1295: 'po_asl_attributes_gt' AS entity ,
1296: fnd_message.get_string('PO','REPLENISH_METHOD_REQUIRED') AS msg
1297: FROM po_asl_attributes_gt PAAGT
1298: WHERE PAAGT.enable_vmi_flag_dsp = 'Y'
1299: AND PAAGT.replenishment_method IS NULL
1300:
1301: UNION ALL

Line 1304: 'po_asl_attributes_gt' AS entity ,

1300:
1301: UNION ALL
1302: --Reject records if forecast horizon is not +ve integer or zero
1303: SELECT user_key ,
1304: 'po_asl_attributes_gt' AS entity ,
1305: fnd_message.get_string('PO','INVALID_FORECAST_HORIZON') AS msg
1306: FROM po_asl_attributes_gt PAAGT
1307: WHERE PAAGT.forecast_horizon_dsp <= 0
1308: OR Round(PAAGT.forecast_horizon_dsp) <> PAAGT.forecast_horizon_dsp

Line 1306: FROM po_asl_attributes_gt PAAGT

1302: --Reject records if forecast horizon is not +ve integer or zero
1303: SELECT user_key ,
1304: 'po_asl_attributes_gt' AS entity ,
1305: fnd_message.get_string('PO','INVALID_FORECAST_HORIZON') AS msg
1306: FROM po_asl_attributes_gt PAAGT
1307: WHERE PAAGT.forecast_horizon_dsp <= 0
1308: OR Round(PAAGT.forecast_horizon_dsp) <> PAAGT.forecast_horizon_dsp
1309: OR (PAAGT.forecast_horizon_dsp IS NOT NULL
1310: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y'));

Line 1328: 'po_asl_attributes_gt' AS entity ,

1324: FROM (
1325: --Reject records if VMI Min Qty is -ve number or is entered when
1326: --vmi_flag is not checked or replenishment method is 2/4
1327: SELECT user_key ,
1328: 'po_asl_attributes_gt' AS entity ,
1329: fnd_message.get_string('PO','INVALID_VIM_MIN_QTY') AS msg
1330: FROM po_asl_attributes_gt PAAGT
1331: WHERE PAAGT.vmi_min_qty_dsp < 0
1332: OR (PAAGT.vmi_min_qty_dsp <> 0

Line 1330: FROM po_asl_attributes_gt PAAGT

1326: --vmi_flag is not checked or replenishment method is 2/4
1327: SELECT user_key ,
1328: 'po_asl_attributes_gt' AS entity ,
1329: fnd_message.get_string('PO','INVALID_VIM_MIN_QTY') AS msg
1330: FROM po_asl_attributes_gt PAAGT
1331: WHERE PAAGT.vmi_min_qty_dsp < 0
1332: OR (PAAGT.vmi_min_qty_dsp <> 0
1333: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y')
1334: OR (PAAGT.vmi_min_qty_dsp <> 0

Line 1342: 'po_asl_attributes_gt' AS entity ,

1338: --Reject records if VMI Max Qty is -ve number or is entered when
1339: --vmi flag is not checked or replenishment method is 2/3/4 or
1340: --this qty is less than vmi min qty
1341: SELECT user_key ,
1342: 'po_asl_attributes_gt' AS entity ,
1343: fnd_message.get_string('PO','INVALID_VIM_MAX_QTY') AS msg
1344: FROM po_asl_attributes_gt PAAGT
1345: WHERE PAAGT.vmi_max_qty_dsp < 0
1346: OR (PAAGT.vmi_max_qty_dsp < PAAGT.vmi_min_qty_dsp)

Line 1344: FROM po_asl_attributes_gt PAAGT

1340: --this qty is less than vmi min qty
1341: SELECT user_key ,
1342: 'po_asl_attributes_gt' AS entity ,
1343: fnd_message.get_string('PO','INVALID_VIM_MAX_QTY') AS msg
1344: FROM po_asl_attributes_gt PAAGT
1345: WHERE PAAGT.vmi_max_qty_dsp < 0
1346: OR (PAAGT.vmi_max_qty_dsp < PAAGT.vmi_min_qty_dsp)
1347: OR (PAAGT.vmi_max_qty_dsp <> 0
1348: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y')

Line 1356: 'po_asl_attributes_gt' AS entity ,

1352: UNION ALL
1353: --Reject records if VMI Min Days is not +ve integer or is entered when
1354: --vmi flag is not checked or replenishment method is 1/3
1355: SELECT user_key ,
1356: 'po_asl_attributes_gt' AS entity ,
1357: fnd_message.get_string('PO','INVALID_VIM_MIN_DAYS') AS msg
1358: FROM po_asl_attributes_gt PAAGT
1359: WHERE PAAGT.vmi_min_days_dsp < 0
1360: OR Round(PAAGT.vmi_min_days_dsp) <> PAAGT.vmi_min_days_dsp

Line 1358: FROM po_asl_attributes_gt PAAGT

1354: --vmi flag is not checked or replenishment method is 1/3
1355: SELECT user_key ,
1356: 'po_asl_attributes_gt' AS entity ,
1357: fnd_message.get_string('PO','INVALID_VIM_MIN_DAYS') AS msg
1358: FROM po_asl_attributes_gt PAAGT
1359: WHERE PAAGT.vmi_min_days_dsp < 0
1360: OR Round(PAAGT.vmi_min_days_dsp) <> PAAGT.vmi_min_days_dsp
1361: OR (PAAGT.vmi_min_days_dsp <> 0
1362: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y')

Line 1370: 'po_asl_attributes_gt' AS entity ,

1366: UNION ALL
1367: --Reject records if VMI Max Days is not +ve integer or is entered when
1368: --vmi flag is not checked or replenishment method is 1/3/4
1369: SELECT user_key ,
1370: 'po_asl_attributes_gt' AS entity ,
1371: fnd_message.get_string('PO','INVALID_VIM_MAXS_DAYS') AS msg
1372: FROM po_asl_attributes_gt PAAGT
1373: WHERE PAAGT.vmi_max_days_dsp < 0
1374: OR Round(PAAGT.vmi_max_days_dsp) <> PAAGT.vmi_max_days_dsp

Line 1372: FROM po_asl_attributes_gt PAAGT

1368: --vmi flag is not checked or replenishment method is 1/3/4
1369: SELECT user_key ,
1370: 'po_asl_attributes_gt' AS entity ,
1371: fnd_message.get_string('PO','INVALID_VIM_MAXS_DAYS') AS msg
1372: FROM po_asl_attributes_gt PAAGT
1373: WHERE PAAGT.vmi_max_days_dsp < 0
1374: OR Round(PAAGT.vmi_max_days_dsp) <> PAAGT.vmi_max_days_dsp
1375: OR (PAAGT.vmi_max_days_dsp < PAAGT.vmi_min_days_dsp)
1376: OR (PAAGT.vmi_max_days_dsp <> 0

Line 1385: 'po_asl_attributes_gt' AS entity ,

1381: UNION ALL
1382: --Reject records if Fixed Order Quantity is -ve number or is entered when
1383: --vmi flag is not checked or replenishment method is 1/2
1384: SELECT user_key ,
1385: 'po_asl_attributes_gt' AS entity ,
1386: fnd_message.get_string('PO','INVALID_FIXED_ORDER_QTY') AS msg
1387: FROM po_asl_attributes_gt PAAGT
1388: WHERE PAAGT.fixed_order_quantity_dsp < 0
1389: OR (PAAGT.fixed_order_quantity_dsp <> 0

Line 1387: FROM po_asl_attributes_gt PAAGT

1383: --vmi flag is not checked or replenishment method is 1/2
1384: SELECT user_key ,
1385: 'po_asl_attributes_gt' AS entity ,
1386: fnd_message.get_string('PO','INVALID_FIXED_ORDER_QTY') AS msg
1387: FROM po_asl_attributes_gt PAAGT
1388: WHERE PAAGT.fixed_order_quantity_dsp < 0
1389: OR (PAAGT.fixed_order_quantity_dsp <> 0
1390: AND Nvl(PAAGT.enable_vmi_flag_dsp,'N') <> 'Y')
1391: OR (PAAGT.fixed_order_quantity_dsp <> 0

Line 1410: 'po_asl_attributes_gt' AS entity ,

1406: --Reject records if consigned from supplier is checked when site is null or
1407: --ASL created for commodity or PO_THIRD_PARTY_STOCK_GRP.validate_local_asl
1408: --retunrs false
1409: SELECT user_key ,
1410: 'po_asl_attributes_gt' AS entity ,
1411: fnd_message.get_string('PO','INVALID_CONSIGNED_FLAG') AS msg
1412: FROM po_asl_attributes_gt PAAGT
1413: WHERE PAAGT.consigned_from_supp_flag_dsp = 'Y'
1414: AND (PAAGT.vendor_site_id IS NULL

Line 1412: FROM po_asl_attributes_gt PAAGT

1408: --retunrs false
1409: SELECT user_key ,
1410: 'po_asl_attributes_gt' AS entity ,
1411: fnd_message.get_string('PO','INVALID_CONSIGNED_FLAG') AS msg
1412: FROM po_asl_attributes_gt PAAGT
1413: WHERE PAAGT.consigned_from_supp_flag_dsp = 'Y'
1414: AND (PAAGT.vendor_site_id IS NULL
1415: OR PAAGT.item_id IS NULL
1416: OR validate_vmi(

Line 1424: 'po_asl_attributes_gt' AS entity ,

1420:
1421: UNION ALL
1422: --Reject records if Consigned billing cycle is -ve number
1423: SELECT user_key ,
1424: 'po_asl_attributes_gt' AS entity ,
1425: fnd_message.get_string('PO','INVALID_CONSIGN_BILL_CYCLE') AS msg
1426: FROM po_asl_attributes_gt PAAGT
1427: WHERE PAAGT.consigned_billing_cycle_dsp < 0
1428: OR (PAAGT.consigned_billing_cycle_dsp IS NOT NULL

Line 1426: FROM po_asl_attributes_gt PAAGT

1422: --Reject records if Consigned billing cycle is -ve number
1423: SELECT user_key ,
1424: 'po_asl_attributes_gt' AS entity ,
1425: fnd_message.get_string('PO','INVALID_CONSIGN_BILL_CYCLE') AS msg
1426: FROM po_asl_attributes_gt PAAGT
1427: WHERE PAAGT.consigned_billing_cycle_dsp < 0
1428: OR (PAAGT.consigned_billing_cycle_dsp IS NOT NULL
1429: AND Nvl(PAAGT.consigned_from_supp_flag_dsp,'N') <> 'Y')
1430:

Line 1435: 'po_asl_attributes_gt' AS entity ,

1431: UNION ALL
1432: --Reject records if Consume on Aging flag is checked when Consigned flag
1433: --is not checked
1434: SELECT user_key ,
1435: 'po_asl_attributes_gt' AS entity ,
1436: fnd_message.get_string('PO','INVALID_CONSUME_AGING_FLAG') AS msg
1437: FROM po_asl_attributes_gt PAAGT
1438: WHERE PAAGT.consume_on_aging_flag_dsp = 'Y'
1439: AND Nvl(PAAGT.consigned_from_supp_flag_dsp,'N') <> 'Y'

Line 1437: FROM po_asl_attributes_gt PAAGT

1433: --is not checked
1434: SELECT user_key ,
1435: 'po_asl_attributes_gt' AS entity ,
1436: fnd_message.get_string('PO','INVALID_CONSUME_AGING_FLAG') AS msg
1437: FROM po_asl_attributes_gt PAAGT
1438: WHERE PAAGT.consume_on_aging_flag_dsp = 'Y'
1439: AND Nvl(PAAGT.consigned_from_supp_flag_dsp,'N') <> 'Y'
1440:
1441: UNION ALL

Line 1445: 'po_asl_attributes_gt' AS entity ,

1441: UNION ALL
1442: --Reject records if ageing period is not +ve number or zero or is entered
1443: --when consume of ageing flag is not checked
1444: SELECT user_key ,
1445: 'po_asl_attributes_gt' AS entity ,
1446: fnd_message.get_string('PO','INVALID_AGEING_PERIOD') AS msg
1447: FROM po_asl_attributes_gt PAAGT
1448: WHERE PAAGT.aging_period_dsp <= 0
1449: OR Round(PAAGT.aging_period_dsp) <> PAAGT.aging_period_dsp

Line 1447: FROM po_asl_attributes_gt PAAGT

1443: --when consume of ageing flag is not checked
1444: SELECT user_key ,
1445: 'po_asl_attributes_gt' AS entity ,
1446: fnd_message.get_string('PO','INVALID_AGEING_PERIOD') AS msg
1447: FROM po_asl_attributes_gt PAAGT
1448: WHERE PAAGT.aging_period_dsp <= 0
1449: OR Round(PAAGT.aging_period_dsp) <> PAAGT.aging_period_dsp
1450: OR (Nvl(PAAGT.consume_on_aging_flag_dsp,'N') <> 'Y'
1451: AND PAAGT.aging_period_dsp IS NOT NULL)

Line 1457: 'po_asl_attributes_gt' AS entity ,

1453: UNION ALL
1454: --Reject records if vendor site is null and supplier scheduling tab details
1455: --are given
1456: SELECT user_key ,
1457: 'po_asl_attributes_gt' AS entity ,
1458: fnd_message.get_string('PO','SUPPLIER_SCHEDULING_DISABLED') AS msg
1459: FROM po_asl_attributes_gt PAAGT
1460: WHERE PAAGT.vendor_site_id IS NULL
1461: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE

Line 1459: FROM po_asl_attributes_gt PAAGT

1455: --are given
1456: SELECT user_key ,
1457: 'po_asl_attributes_gt' AS entity ,
1458: fnd_message.get_string('PO','SUPPLIER_SCHEDULING_DISABLED') AS msg
1459: FROM po_asl_attributes_gt PAAGT
1460: WHERE PAAGT.vendor_site_id IS NULL
1461: AND PAAGT.process_action <> PO_ASL_API_PUB.g_ACTION_DELETE
1462: AND (PAAGT.enable_plan_schedule_flag_dsp = 'Y'
1463: OR PAAGT.enable_ship_schedule_flag_dsp = 'Y'