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_PUB dependencies on FND_MESSAGE

Line 1944: fnd_message.get_string('PO','OWNING_ORG_NOT_FOUND') AS msg

1940: l_reject_reason
1941: FROM
1942: (SELECT user_key ,
1943: 'po_approved_supplier_list_gt' AS entity ,
1944: fnd_message.get_string('PO','OWNING_ORG_NOT_FOUND') AS msg
1945: FROM po_approved_supplier_list_gt
1946: WHERE owning_organization_dsp IS NOT NULL
1947: AND owning_organization_id IS NULL
1948:

Line 1953: fnd_message.get_string('PO','STATUS_NOT_FOUND') AS msg

1949: UNION ALL
1950:
1951: SELECT user_key ,
1952: 'po_approved_supplier_list_gt' AS entity ,
1953: fnd_message.get_string('PO','STATUS_NOT_FOUND') AS msg
1954: FROM po_approved_supplier_list_gt
1955: WHERE asl_status_dsp IS NOT NULL
1956: AND asl_status_id IS NULL
1957:

Line 1962: fnd_message.get_string('PO','MANUFACTURER_NOT_FOUND') AS msg

1958: UNION ALL
1959:
1960: SELECT user_key ,
1961: 'po_approved_supplier_list_gt' AS entity ,
1962: fnd_message.get_string('PO','MANUFACTURER_NOT_FOUND') AS msg
1963: FROM po_approved_supplier_list_gt
1964: WHERE (manufacturer_dsp IS NOT NULL
1965: AND manufacturer_id IS NULL)
1966: OR

Line 1974: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg

1970: UNION ALL
1971:
1972: SELECT user_key ,
1973: 'po_approved_supplier_list_gt' AS entity ,
1974: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
1975: FROM po_approved_supplier_list_gt
1976: WHERE vendor_dsp IS NOT NULL
1977: AND vendor_id IS NULL
1978:

Line 1983: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg

1979: UNION ALL
1980:
1981: SELECT user_key ,
1982: 'po_approved_supplier_list_gt' AS entity ,
1983: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
1984: FROM po_approved_supplier_list_gt
1985: WHERE item_dsp IS NOT NULL
1986: AND item_id IS NULL);
1987:

Line 2000: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg

1996: l_reject_reason1
1997: FROM
1998: (SELECT user_key ,
1999: 'po_approved_supplier_list_gt' AS entity ,
2000: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2001: FROM po_approved_supplier_list_gt
2002: WHERE category_dsp IS NOT NULL
2003: AND category_id IS NULL
2004:

Line 2009: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg

2005: UNION ALL
2006:
2007: SELECT user_key ,
2008: 'po_approved_supplier_list_gt' AS entity ,
2009: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2010: FROM po_approved_supplier_list_gt
2011: WHERE vendor_site_dsp IS NOT NULL
2012: AND vendor_site_id IS NULL
2013:

Line 2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2014: UNION ALL
2015:
2016: SELECT user_key ,
2017: 'po_approved_supplier_list_gt' AS entity ,
2018: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2019: FROM po_approved_supplier_list_gt
2020: WHERE process_action NOT IN
2021: (PO_ASL_API_PUB.g_ACTION_CREATE,
2022: PO_ASL_API_PUB.g_ACTION_UPDATE,

Line 2103: fnd_message.get_string('PO','REL_GEN_METHOD_NOT_FOUND') AS msg

2099: l_reject_reason
2100: FROM (
2101: SELECT user_key ,
2102: 'po_asl_attributes_gt' AS entity ,
2103: fnd_message.get_string('PO','REL_GEN_METHOD_NOT_FOUND') AS msg
2104: FROM po_asl_attributes_gt
2105: WHERE release_generation_method_dsp IS NOT NULL
2106: AND release_generation_method IS NULL
2107:

Line 2112: fnd_message.get_string('PO','PLAN_SCHEDULE_NOT_FOUND') AS msg

2108: UNION ALL
2109:
2110: SELECT user_key ,
2111: 'po_asl_attributes_gt' AS entity ,
2112: fnd_message.get_string('PO','PLAN_SCHEDULE_NOT_FOUND') AS msg
2113: FROM po_asl_attributes_gt
2114: WHERE plan_schedule_type_dsp IS NOT NULL
2115: AND plan_schedule_type IS NULL
2116:

Line 2121: fnd_message.get_string('PO','SHIP_SCHEDULE_NOT_FOUND') AS msg

2117: UNION ALL
2118:
2119: SELECT user_key ,
2120: 'po_asl_attributes_gt' AS entity ,
2121: fnd_message.get_string('PO','SHIP_SCHEDULE_NOT_FOUND') AS msg
2122: FROM po_asl_attributes_gt
2123: WHERE ship_schedule_type_dsp IS NOT NULL
2124: AND ship_schedule_type IS NULL
2125:

Line 2130: fnd_message.get_string('PO','PLAN_BUCKET_NOT_FOUND') AS msg

2126: UNION ALL
2127:
2128: SELECT user_key ,
2129: 'po_asl_attributes_gt' AS entity ,
2130: fnd_message.get_string('PO','PLAN_BUCKET_NOT_FOUND') AS msg
2131: FROM po_asl_attributes_gt
2132: WHERE plan_bucket_pattern_dsp IS NOT NULL
2133: AND plan_bucket_pattern_id IS NULL
2134:

Line 2139: fnd_message.get_string('PO','SHIP_BUCKET_NOT_FOUND') AS msg

2135: UNION ALL
2136:
2137: SELECT user_key ,
2138: 'po_asl_attributes_gt' AS entity ,
2139: fnd_message.get_string('PO','SHIP_BUCKET_NOT_FOUND') AS msg
2140: FROM po_asl_attributes_gt
2141: WHERE ship_bucket_pattern_dsp IS NOT NULL
2142: AND ship_bucket_pattern_id IS NULL);
2143: l_progress := 10;

Line 2155: fnd_message.get_string('PO','SHCEDULER_NOT_FOUND') AS msg

2151: l_reject_reason1
2152: FROM (
2153: SELECT user_key ,
2154: 'po_asl_attributes_gt' AS entity ,
2155: fnd_message.get_string('PO','SHCEDULER_NOT_FOUND') AS msg
2156: FROM po_asl_attributes_gt
2157: WHERE scheduler_dsp IS NOT NULL
2158: AND scheduler_id IS NULL
2159:

Line 2164: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg

2160: UNION ALL
2161:
2162: SELECT user_key ,
2163: 'po_asl_attributes_gt' AS entity ,
2164: fnd_message.get_string('PO','VENDOR_NOT_FOUND') AS msg
2165: FROM po_asl_attributes_gt
2166: WHERE vendor_dsp IS NOT NULL
2167: AND vendor_id IS NULL
2168:

Line 2173: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg

2169: UNION ALL
2170:
2171: SELECT user_key ,
2172: 'po_asl_attributes_gt' AS entity ,
2173: fnd_message.get_string('PO','ITEM_NOT_FOUND') AS msg
2174: FROM po_asl_attributes_gt
2175: WHERE item_dsp IS NOT NULL
2176: AND item_id IS NULL
2177:

Line 2182: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg

2178: UNION ALL
2179:
2180: SELECT user_key ,
2181: 'po_asl_attributes_gt' AS entity ,
2182: fnd_message.get_string('PO','CATEGORY_NOT_FOUND') AS msg
2183: FROM po_asl_attributes_gt
2184: WHERE category_dsp IS NOT NULL
2185: AND category_id IS NULL
2186:

Line 2191: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg

2187: UNION ALL
2188:
2189: SELECT user_key ,
2190: 'po_asl_attributes_gt' AS entity ,
2191: fnd_message.get_string('PO','VENDOR_SITE_NOT_FOUND') AS msg
2192: FROM po_asl_attributes_gt
2193: WHERE vendor_site_dsp IS NOT NULL
2194: AND vendor_site_id IS NULL
2195:

Line 2200: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg

2196: UNION ALL
2197:
2198: SELECT user_key ,
2199: 'po_asl_attributes_gt' AS entity ,
2200: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2201: FROM po_asl_attributes_gt
2202: WHERE using_organization_dsp IS NOT NULL
2203: AND using_organization_id IS NULL);
2204:

Line 2220: fnd_message.get_string('PO','REPL_APPROVAL_NOT_FOUND') AS msg

2216: l_reject_reason
2217: FROM (
2218: SELECT user_key ,
2219: 'po_asl_attributes_gt' AS entity ,
2220: fnd_message.get_string('PO','REPL_APPROVAL_NOT_FOUND') AS msg
2221: FROM po_asl_attributes_gt
2222: WHERE vmi_replenishment_approval_dsp IS NOT NULL
2223: AND vmi_replenishment_approval IS NULL
2224:

Line 2229: fnd_message.get_string('PO','REPL_METHOD_NOT_FOUND') AS msg

2225: UNION ALL
2226:
2227: SELECT user_key ,
2228: 'po_asl_attributes_gt' AS entity ,
2229: fnd_message.get_string('PO','REPL_METHOD_NOT_FOUND') AS msg
2230: FROM po_asl_attributes_gt
2231: WHERE replenishment_method_dsp IS NOT NULL
2232: AND replenishment_method IS NULL
2233:

Line 2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2234: UNION ALL
2235: --Reject records if process action is other than ADD,UPDATE,DELETE
2236: SELECT user_key ,
2237: 'po_asl_attributes_gt' AS entity ,
2238: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2239: FROM po_asl_attributes_gt
2240: WHERE process_action NOT IN
2241: (PO_ASL_API_PUB.g_ACTION_ADD,
2242: PO_ASL_API_PUB.g_ACTION_UPDATE,

Line 2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg

2247: --Reject records if ASL Process action is create and attribute's process
2248: --action is delete/update
2249: SELECT PAA.user_key ,
2250: 'po_asl_attributes_gt' AS entity ,
2251: fnd_message.get_string('PO','INVALID_PAA_ACTION') AS msg
2252: FROM po_asl_attributes_gt PAA,
2253: po_approved_supplier_list_gt ASL
2254: WHERE ASL.user_key = PAA.user_key
2255: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 2341: fnd_message.get_string('PO','AUTH_CODE_NOT_FOUND') AS msg

2337: l_rejection_reason
2338: FROM
2339: (SELECT user_key ,
2340: 'chv_authorizations_gt' AS entity ,
2341: fnd_message.get_string('PO','AUTH_CODE_NOT_FOUND') AS msg
2342: FROM chv_authorizations_gt
2343: WHERE authorization_code_dsp IS NOT NULL
2344: AND authorization_code IS NULL
2345:

Line 2350: fnd_message.get_string('PO','DOC_TYPE_NOT_FOUND') AS msg

2346: UNION ALL
2347:
2348: SELECT user_key ,
2349: 'po_asl_documents_gt' AS entity ,
2350: fnd_message.get_string('PO','DOC_TYPE_NOT_FOUND') AS msg
2351: FROM po_asl_documents_gt
2352: WHERE document_type_dsp IS NOT NULL
2353: AND document_type_code IS NULL
2354:

Line 2359: fnd_message.get_string('PO','DOC_HEADER_NOT_FOUND') AS msg

2355: UNION ALL
2356:
2357: SELECT user_key ,
2358: 'po_asl_documents_gt' AS entity ,
2359: fnd_message.get_string('PO','DOC_HEADER_NOT_FOUND') AS msg
2360: FROM po_asl_documents_gt
2361: WHERE document_header_dsp IS NOT NULL
2362: AND document_header_id IS NULL
2363:

Line 2368: fnd_message.get_string('PO','DOC_LINE_NOT_FOUND') AS msg

2364: UNION ALL
2365:
2366: SELECT user_key ,
2367: 'po_asl_documents_gt' AS entity ,
2368: fnd_message.get_string('PO','DOC_LINE_NOT_FOUND') AS msg
2369: FROM po_asl_documents_gt
2370: WHERE document_line_num_dsp IS NOT NULL
2371: AND document_line_id IS NULL
2372:

Line 2393: fnd_message.get_string('PO','INVALID_PAD_ACTION') AS msg

2389: --Reject records if ASL Process action is create and document's process
2390: --action is delete/update
2391: SELECT PAD.user_key ,
2392: 'po_asl_documents_gt' AS entity ,
2393: fnd_message.get_string('PO','INVALID_PAD_ACTION') AS msg
2394: FROM po_asl_documents_gt PAD,
2395: po_approved_supplier_list_gt ASL
2396: WHERE ASL.user_key = PAD.user_key
2397: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg

2401: --Reject records if ASL Process action is create and authorization's process
2402: --action is delete/update
2403: SELECT CHV.user_key ,
2404: 'chv_authorizations_gt' AS entity ,
2405: fnd_message.get_string('PO','INVALID_CHV_ACTION') AS msg
2406: FROM chv_authorizations_gt CHV,
2407: po_approved_supplier_list_gt ASL
2408: WHERE ASL.user_key = CHV.user_key
2409: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg

2413: --Reject records if ASL Process action is create and capacity's process
2414: --action is delete/update
2415: SELECT CAP.user_key ,
2416: 'po_supplier_item_capacity_gt' AS entity ,
2417: fnd_message.get_string('PO','INVALID_CAP_ACTION') AS msg
2418: FROM po_supplier_item_capacity_gt CAP,
2419: po_approved_supplier_list_gt ASL
2420: WHERE ASL.user_key = CAP.user_key
2421: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg

2425: --Reject records if ASL Process action is create and tolerance's process
2426: --action is delete/update
2427: SELECT TOL.user_key ,
2428: 'po_supplier_item_tolerance_gt' AS entity ,
2429: fnd_message.get_string('PO','INVALID_TOL_ACTION') AS msg
2430: FROM po_supplier_item_tolerance_gt TOL,
2431: po_approved_supplier_list_gt ASL
2432: WHERE ASL.user_key = TOL.user_key
2433: AND ASL.process_action = PO_ASL_API_PUB.g_ACTION_CREATE

Line 2454: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg

2450: FROM
2451: (
2452: SELECT user_key ,
2453: 'po_asl_documents_gt' AS entity ,
2454: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2455: FROM po_asl_documents_gt
2456: WHERE using_organization_dsp IS NOT NULL
2457: AND using_organization_id IS NULL
2458:

Line 2463: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg

2459: UNION ALL
2460:
2461: SELECT user_key ,
2462: 'chv_authorizations_gt' AS entity ,
2463: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2464: FROM chv_authorizations_gt
2465: WHERE using_organization_dsp IS NOT NULL
2466: AND using_organization_id IS NULL
2467:

Line 2472: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg

2468: UNION ALL
2469:
2470: SELECT user_key ,
2471: 'po_supplier_item_capacity_gt' AS entity ,
2472: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2473: FROM po_supplier_item_capacity_gt
2474: WHERE using_organization_dsp IS NOT NULL
2475: AND using_organization_id IS NULL
2476:

Line 2481: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg

2477: UNION ALL
2478:
2479: SELECT user_key ,
2480: 'po_supplier_item_tolerance_gt' AS entity,
2481: fnd_message.get_string('PO','USING_ORG_NOT_FOUND') AS msg
2482: FROM po_supplier_item_tolerance_gt
2483: WHERE using_organization_dsp IS NOT NULL
2484: AND using_organization_id IS NULL
2485: );

Line 2504: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2500: FROM
2501: (
2502: SELECT user_key ,
2503: 'po_asl_documents_gt' AS entity ,
2504: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2505: FROM po_asl_documents_gt
2506: WHERE process_action NOT IN
2507: (PO_ASL_API_PUB.g_ACTION_ADD ,
2508: PO_ASL_API_PUB.g_ACTION_UPDATE,

Line 2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2512: UNION
2513:
2514: SELECT user_key ,
2515: 'chv_authorizations_gt' AS entity ,
2516: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2517: FROM chv_authorizations_gt
2518: WHERE process_action NOT IN
2519: (PO_ASL_API_PUB.g_ACTION_ADD ,
2520: PO_ASL_API_PUB.g_ACTION_UPDATE,

Line 2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2524: UNION
2525:
2526: SELECT user_key ,
2527: 'po_supplier_item_capacity_gt' AS entity ,
2528: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2529: FROM po_supplier_item_capacity_gt
2530: WHERE process_action NOT IN
2531: (PO_ASL_API_PUB.g_ACTION_ADD ,
2532: PO_ASL_API_PUB.g_ACTION_UPDATE,

Line 2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg

2536: UNION
2537:
2538: SELECT user_key ,
2539: 'po_supplier_item_tolerance_gt' AS entity ,
2540: fnd_message.get_string('PO','INVALID_PROCESS_ACTION') AS msg
2541: FROM po_supplier_item_tolerance_gt
2542: WHERE process_action NOT IN
2543: (PO_ASL_API_PUB.g_ACTION_ADD ,
2544: PO_ASL_API_PUB.g_ACTION_UPDATE,