DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on FND_MSG_PUB

Line 1954: FND_MSG_PUB.initialize;

1950: rel_row:=0;
1951: FOR r_id IN c_id (p_worker_id, l_txn_from_date, l_txn_to_date ) LOOP
1952: l_iface_error_text := NULL;
1953: rel_row:=rel_row+1;
1954: FND_MSG_PUB.initialize;
1955: BEGIN
1956:
1957: -- 1. Validate relationship_type_code
1958: BEGIN

Line 1967: fnd_msg_pub.add;

1963: EXCEPTION
1964: WHEN NO_DATA_FOUND THEN
1965: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
1966: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
1967: fnd_msg_pub.add;
1968: l_msg_index := 1;
1969: fnd_msg_pub.count_and_get
1970: (p_count => x_msg_count,
1971: p_data => x_msg_data

Line 1969: fnd_msg_pub.count_and_get

1965: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
1966: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
1967: fnd_msg_pub.add;
1968: l_msg_index := 1;
1969: fnd_msg_pub.count_and_get
1970: (p_count => x_msg_count,
1971: p_data => x_msg_data
1972: );
1973: l_msg_count := x_msg_count;

Line 1976: x_msg_data := fnd_msg_pub.get

1972: );
1973: l_msg_count := x_msg_count;
1974: WHILE l_msg_count > 0
1975: LOOP
1976: x_msg_data := fnd_msg_pub.get
1977: (l_msg_index,
1978: fnd_api.g_false
1979: );
1980: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2004: fnd_msg_pub.add;

2000: IF l_quantity <> 1
2001: THEN
2002: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
2003: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2004: fnd_msg_pub.add;
2005: l_msg_index := 1;
2006: fnd_msg_pub.count_and_get
2007: (p_count => x_msg_count,
2008: p_data => x_msg_data

Line 2006: fnd_msg_pub.count_and_get

2002: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
2003: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2004: fnd_msg_pub.add;
2005: l_msg_index := 1;
2006: fnd_msg_pub.count_and_get
2007: (p_count => x_msg_count,
2008: p_data => x_msg_data
2009: );
2010: l_msg_count := x_msg_count;

Line 2013: x_msg_data := fnd_msg_pub.get

2009: );
2010: l_msg_count := x_msg_count;
2011: WHILE l_msg_count > 0
2012: LOOP
2013: x_msg_data := fnd_msg_pub.get
2014: (l_msg_index,
2015: fnd_api.g_false
2016: );
2017: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2028: fnd_msg_pub.add;

2024: EXCEPTION
2025: WHEN NO_DATA_FOUND THEN
2026: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
2027: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2028: fnd_msg_pub.add;
2029: l_msg_index := 1;
2030: fnd_msg_pub.count_and_get
2031: (p_count => x_msg_count,
2032: p_data => x_msg_data

Line 2030: fnd_msg_pub.count_and_get

2026: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
2027: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2028: fnd_msg_pub.add;
2029: l_msg_index := 1;
2030: fnd_msg_pub.count_and_get
2031: (p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );
2034: l_msg_count := x_msg_count;

Line 2037: x_msg_data := fnd_msg_pub.get

2033: );
2034: l_msg_count := x_msg_count;
2035: WHILE l_msg_count > 0
2036: LOOP
2037: x_msg_data := fnd_msg_pub.get
2038: (l_msg_index,
2039: fnd_api.g_false
2040: );
2041: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2054: fnd_msg_pub.add;

2050: ( p_instance_id => r_id.object_id)
2051: THEN
2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2054: fnd_msg_pub.add;
2055: l_msg_index := 1;
2056: fnd_msg_pub.count_and_get
2057: (p_count => x_msg_count,
2058: p_data => x_msg_data

Line 2056: fnd_msg_pub.count_and_get

2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2054: fnd_msg_pub.add;
2055: l_msg_index := 1;
2056: fnd_msg_pub.count_and_get
2057: (p_count => x_msg_count,
2058: p_data => x_msg_data
2059: );
2060: l_msg_count := x_msg_count;

Line 2063: x_msg_data := fnd_msg_pub.get

2059: );
2060: l_msg_count := x_msg_count;
2061: WHILE l_msg_count > 0
2062: LOOP
2063: x_msg_data := fnd_msg_pub.get
2064: (l_msg_index,
2065: fnd_api.g_false
2066: );
2067: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2090: fnd_msg_pub.add;

2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
2089: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2090: fnd_msg_pub.add;
2091: l_msg_index := 1;
2092: fnd_msg_pub.count_and_get
2093: (p_count => x_msg_count,
2094: p_data => x_msg_data

Line 2092: fnd_msg_pub.count_and_get

2088: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
2089: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2090: fnd_msg_pub.add;
2091: l_msg_index := 1;
2092: fnd_msg_pub.count_and_get
2093: (p_count => x_msg_count,
2094: p_data => x_msg_data
2095: );
2096: l_msg_count := x_msg_count;

Line 2099: x_msg_data := fnd_msg_pub.get

2095: );
2096: l_msg_count := x_msg_count;
2097: WHILE l_msg_count > 0
2098: LOOP
2099: x_msg_data := fnd_msg_pub.get
2100: (l_msg_index,
2101: fnd_api.g_false
2102: );
2103: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2116: fnd_msg_pub.add;

2112: ( p_instance_id => r_id.subject_id)
2113: THEN
2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2116: fnd_msg_pub.add;
2117: l_msg_index := 1;
2118: fnd_msg_pub.count_and_get
2119: (p_count => x_msg_count,
2120: p_data => x_msg_data

Line 2118: fnd_msg_pub.count_and_get

2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2116: fnd_msg_pub.add;
2117: l_msg_index := 1;
2118: fnd_msg_pub.count_and_get
2119: (p_count => x_msg_count,
2120: p_data => x_msg_data
2121: );
2122: l_msg_count := x_msg_count;

Line 2125: x_msg_data := fnd_msg_pub.get

2121: );
2122: l_msg_count := x_msg_count;
2123: WHILE l_msg_count > 0
2124: LOOP
2125: x_msg_data := fnd_msg_pub.get
2126: (l_msg_index,
2127: fnd_api.g_false
2128: );
2129: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2144: fnd_msg_pub.add;

2140: (r_id.relationship_end_date <> fnd_api.g_miss_date))
2141: THEN
2142: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
2143: fnd_message.set_token('ACTIVE_END_DATE',r_id.relationship_end_date);
2144: fnd_msg_pub.add;
2145: l_msg_index := 1;
2146: fnd_msg_pub.count_and_get
2147: (p_count => x_msg_count,
2148: p_data => x_msg_data

Line 2146: fnd_msg_pub.count_and_get

2142: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
2143: fnd_message.set_token('ACTIVE_END_DATE',r_id.relationship_end_date);
2144: fnd_msg_pub.add;
2145: l_msg_index := 1;
2146: fnd_msg_pub.count_and_get
2147: (p_count => x_msg_count,
2148: p_data => x_msg_data
2149: );
2150: l_msg_count := x_msg_count;

Line 2153: x_msg_data := fnd_msg_pub.get

2149: );
2150: l_msg_count := x_msg_count;
2151: WHILE l_msg_count > 0
2152: LOOP
2153: x_msg_data := fnd_msg_pub.get
2154: (l_msg_index,
2155: fnd_api.g_false
2156: );
2157: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2179: fnd_msg_pub.add;

2175: AND ROWNUM=1;
2176: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2179: fnd_msg_pub.add;
2180: l_msg_index := 1;
2181: fnd_msg_pub.count_and_get
2182: (p_count => x_msg_count,
2183: p_data => x_msg_data

Line 2181: fnd_msg_pub.count_and_get

2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2179: fnd_msg_pub.add;
2180: l_msg_index := 1;
2181: fnd_msg_pub.count_and_get
2182: (p_count => x_msg_count,
2183: p_data => x_msg_data
2184: );
2185: l_msg_count := x_msg_count;

Line 2188: x_msg_data := fnd_msg_pub.get

2184: );
2185: l_msg_count := x_msg_count;
2186: WHILE l_msg_count > 0
2187: LOOP
2188: x_msg_data := fnd_msg_pub.get
2189: (l_msg_index,
2190: fnd_api.g_false
2191: );
2192: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2213: fnd_msg_pub.count_and_get

2209: x_msg_data =>x_msg_data
2210: );
2211: IF x_return_status<>fnd_api.g_ret_sts_success THEN
2212: l_msg_index := 1;
2213: fnd_msg_pub.count_and_get
2214: (p_count => x_msg_count,
2215: p_data => x_msg_data
2216: );
2217: l_msg_count := x_msg_count;

Line 2220: x_msg_data := fnd_msg_pub.get

2216: );
2217: l_msg_count := x_msg_count;
2218: WHILE l_msg_count > 0
2219: LOOP
2220: x_msg_data := fnd_msg_pub.get
2221: (l_msg_index,
2222: fnd_api.g_false
2223: );
2224: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2248: fnd_msg_pub.add;

2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);
2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;
2249: l_msg_index := 1;
2250: fnd_msg_pub.count_and_get
2251: (p_count => x_msg_count,
2252: p_data => x_msg_data

Line 2250: fnd_msg_pub.count_and_get

2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;
2249: l_msg_index := 1;
2250: fnd_msg_pub.count_and_get
2251: (p_count => x_msg_count,
2252: p_data => x_msg_data
2253: );
2254: l_msg_count := x_msg_count;

Line 2257: x_msg_data := fnd_msg_pub.get

2253: );
2254: l_msg_count := x_msg_count;
2255: WHILE l_msg_count > 0
2256: LOOP
2257: x_msg_data := fnd_msg_pub.get
2258: (l_msg_index,
2259: fnd_api.g_false
2260: );
2261: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2281: fnd_msg_pub.add;

2277: ,p_relationship_id => NULL )
2278: THEN
2279: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2280: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2281: fnd_msg_pub.add;
2282: l_msg_index := 1;
2283: fnd_msg_pub.count_and_get
2284: (p_count => x_msg_count,
2285: p_data => x_msg_data

Line 2283: fnd_msg_pub.count_and_get

2279: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2280: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2281: fnd_msg_pub.add;
2282: l_msg_index := 1;
2283: fnd_msg_pub.count_and_get
2284: (p_count => x_msg_count,
2285: p_data => x_msg_data
2286: );
2287: l_msg_count := x_msg_count;

Line 2290: x_msg_data := fnd_msg_pub.get

2286: );
2287: l_msg_count := x_msg_count;
2288: WHILE l_msg_count > 0
2289: LOOP
2290: x_msg_data := fnd_msg_pub.get
2291: (l_msg_index,
2292: fnd_api.g_false
2293: );
2294: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2313: fnd_msg_pub.add;

2309: ,p_relationship_id => NULL )
2310: THEN
2311: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2312: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2313: fnd_msg_pub.add;
2314: l_msg_index := 1;
2315: fnd_msg_pub.count_and_get
2316: (p_count => x_msg_count,
2317: p_data => x_msg_data

Line 2315: fnd_msg_pub.count_and_get

2311: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2312: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2313: fnd_msg_pub.add;
2314: l_msg_index := 1;
2315: fnd_msg_pub.count_and_get
2316: (p_count => x_msg_count,
2317: p_data => x_msg_data
2318: );
2319: l_msg_count := x_msg_count;

Line 2322: x_msg_data := fnd_msg_pub.get

2318: );
2319: l_msg_count := x_msg_count;
2320: WHILE l_msg_count > 0
2321: LOOP
2322: x_msg_data := fnd_msg_pub.get
2323: (l_msg_index,
2324: fnd_api.g_false
2325: );
2326: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2391: FND_MSG_PUB.initialize;

2387: LOOP
2388: BEGIN
2389: l_iface_error_text := NULL;
2390: rel_row:=rel_row+1;
2391: FND_MSG_PUB.initialize;
2392: csi_ml_util_pvt.Get_top_most_parent
2393: ( p_subject_id => l_upd_ins_csr.subject_id
2394: ,p_rel_type_code => l_upd_ins_csr.relationship_type_code
2395: ,p_process_status => 'V'

Line 2492: fnd_msg_pub.add;

2488: THEN
2489: /*
2490: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
2491: fnd_message.set_token('instance_id',l_instance_rec.instance_id);
2492: fnd_msg_pub.add;
2493: */
2494: l_msg_index := 1;
2495:
2496: fnd_msg_pub.count_and_get

Line 2496: fnd_msg_pub.count_and_get

2492: fnd_msg_pub.add;
2493: */
2494: l_msg_index := 1;
2495:
2496: fnd_msg_pub.count_and_get
2497: ( p_count => x_msg_count
2498: ,p_data => x_msg_data
2499: );
2500: l_msg_count := x_msg_count;

Line 2503: x_msg_data := fnd_msg_pub.get

2499: );
2500: l_msg_count := x_msg_count;
2501: WHILE l_msg_count > 0
2502: LOOP
2503: x_msg_data := fnd_msg_pub.get
2504: ( l_msg_index
2505: ,fnd_api.g_false
2506: );
2507: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);

Line 2560: FND_MSG_PUB.initialize;

2556: LOOP
2557: BEGIN
2558: l_iface_error_text := NULL;
2559: rel_row := rel_row+1;
2560: FND_MSG_PUB.initialize;
2561:
2562: csi_ml_util_pvt.Get_top_most_parent
2563: ( p_subject_id => l_re_upd_csr.subject_id
2564: ,p_rel_type_code => l_re_upd_csr.relationship_type_code

Line 2646: fnd_msg_pub.count_and_get

2642: THEN
2643:
2644: l_msg_index := 1;
2645:
2646: fnd_msg_pub.count_and_get
2647: ( p_count => x_msg_count
2648: ,p_data => x_msg_data
2649: );
2650: l_msg_count := x_msg_count;

Line 2653: x_msg_data := fnd_msg_pub.get

2649: );
2650: l_msg_count := x_msg_count;
2651: WHILE l_msg_count > 0
2652: LOOP
2653: x_msg_data := fnd_msg_pub.get
2654: ( l_msg_index
2655: ,fnd_api.g_false
2656: );
2657: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);