DBA Data[Home] [Help]

APPS.GME_GANTT_PKG dependencies on FND_MESSAGE

Line 2022: fnd_message.set_name ('GME', 'GME_DATE_OUTSIDE_SHOP_CALENDAR');

2018: x_calendar_no := r_pad (g_mfg_calendar_code, 16);
2019: x_calendar_desc := r_pad (g_calendar_desc, 40);
2020: EXCEPTION
2021: WHEN inv_calendar_sel THEN
2022: fnd_message.set_name ('GME', 'GME_DATE_OUTSIDE_SHOP_CALENDAR');
2023: --Bug3315440
2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));
2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));

Line 2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));

2020: EXCEPTION
2021: WHEN inv_calendar_sel THEN
2022: fnd_message.set_name ('GME', 'GME_DATE_OUTSIDE_SHOP_CALENDAR');
2023: --Bug3315440
2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));
2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));
2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));

Line 2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));

2021: WHEN inv_calendar_sel THEN
2022: fnd_message.set_name ('GME', 'GME_DATE_OUTSIDE_SHOP_CALENDAR');
2023: --Bug3315440
2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));
2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));
2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));
2029: fnd_message.set_token ('SEL_DATE'

Line 2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));

2022: fnd_message.set_name ('GME', 'GME_DATE_OUTSIDE_SHOP_CALENDAR');
2023: --Bug3315440
2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));
2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));
2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));
2029: fnd_message.set_token ('SEL_DATE'
2030: ,fnd_date.date_to_displaydt (p_date,2) );

Line 2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));

2024: --FND_MESSAGE.SET_TOKEN('SEL_DATE', TO_CHAR(p_date,'DD-MON-YYYY'));
2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));
2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));
2029: fnd_message.set_token ('SEL_DATE'
2030: ,fnd_date.date_to_displaydt (p_date,2) );
2031: fnd_message.set_token ('CAL_BEGIN_DATE'
2032: ,fnd_date.date_to_displaydt (g_calendar_start,2) );

Line 2029: fnd_message.set_token ('SEL_DATE'

2025: --FND_MESSAGE.SET_TOKEN('CAL_BEGIN_DATE', TO_CHAR(g_calendar_start,'DD-MON-YYYY'));
2026: --FND_MESSAGE.SET_TOKEN('CAL_END_DATE', TO_CHAR(g_calendar_end,'DD-MON-YYYY'));
2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));
2029: fnd_message.set_token ('SEL_DATE'
2030: ,fnd_date.date_to_displaydt (p_date,2) );
2031: fnd_message.set_token ('CAL_BEGIN_DATE'
2032: ,fnd_date.date_to_displaydt (g_calendar_start,2) );
2033: fnd_message.set_token ('CAL_END_DATE'

Line 2031: fnd_message.set_token ('CAL_BEGIN_DATE'

2027: --Bug4068469: removed trunc from the set_token call
2028: --FND_MESSAGE.SET_TOKEN('SEL_DATE', trunc(fnd_date.date_to_displayDT(p_date),'DD-MON-YYYY'));
2029: fnd_message.set_token ('SEL_DATE'
2030: ,fnd_date.date_to_displaydt (p_date,2) );
2031: fnd_message.set_token ('CAL_BEGIN_DATE'
2032: ,fnd_date.date_to_displaydt (g_calendar_start,2) );
2033: fnd_message.set_token ('CAL_END_DATE'
2034: ,fnd_date.date_to_displaydt (g_calendar_end,2) );
2035: x_return_code := 'F';

Line 2033: fnd_message.set_token ('CAL_END_DATE'

2029: fnd_message.set_token ('SEL_DATE'
2030: ,fnd_date.date_to_displaydt (p_date,2) );
2031: fnd_message.set_token ('CAL_BEGIN_DATE'
2032: ,fnd_date.date_to_displaydt (g_calendar_start,2) );
2033: fnd_message.set_token ('CAL_END_DATE'
2034: ,fnd_date.date_to_displaydt (g_calendar_end,2) );
2035: x_return_code := 'F';
2036: x_error_msg := r_pad (fnd_message.get, 1000);
2037: WHEN no_calendar_assigned THEN

Line 2036: x_error_msg := r_pad (fnd_message.get, 1000);

2032: ,fnd_date.date_to_displaydt (g_calendar_start,2) );
2033: fnd_message.set_token ('CAL_END_DATE'
2034: ,fnd_date.date_to_displaydt (g_calendar_end,2) );
2035: x_return_code := 'F';
2036: x_error_msg := r_pad (fnd_message.get, 1000);
2037: WHEN no_calendar_assigned THEN
2038: x_calendar_assigned := 'N';
2039: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2040: x_return_code := 'F';

Line 2039: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');

2035: x_return_code := 'F';
2036: x_error_msg := r_pad (fnd_message.get, 1000);
2037: WHEN no_calendar_assigned THEN
2038: x_calendar_assigned := 'N';
2039: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2040: x_return_code := 'F';
2041: x_error_msg := r_pad (fnd_message.get, 1000);
2042: WHEN OTHERS THEN
2043: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2041: x_error_msg := r_pad (fnd_message.get, 1000);

2037: WHEN no_calendar_assigned THEN
2038: x_calendar_assigned := 'N';
2039: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2040: x_return_code := 'F';
2041: x_error_msg := r_pad (fnd_message.get, 1000);
2042: WHEN OTHERS THEN
2043: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2044: END fetch_shop_calendar;
2045:

Line 2138: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');

2134: END IF;
2135: END IF;
2136: EXCEPTION
2137: WHEN inv_calendar_sel THEN
2138: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
2139: fnd_message.set_token ('ERROR', SQLERRM);
2140: x_return_code := 'F';
2141: x_error_msg := fnd_message.get;
2142: WHEN fetch_cal_error THEN

Line 2139: fnd_message.set_token ('ERROR', SQLERRM);

2135: END IF;
2136: EXCEPTION
2137: WHEN inv_calendar_sel THEN
2138: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
2139: fnd_message.set_token ('ERROR', SQLERRM);
2140: x_return_code := 'F';
2141: x_error_msg := fnd_message.get;
2142: WHEN fetch_cal_error THEN
2143: x_error_msg := r_pad (fnd_message.get, 1000);

Line 2141: x_error_msg := fnd_message.get;

2137: WHEN inv_calendar_sel THEN
2138: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
2139: fnd_message.set_token ('ERROR', SQLERRM);
2140: x_return_code := 'F';
2141: x_error_msg := fnd_message.get;
2142: WHEN fetch_cal_error THEN
2143: x_error_msg := r_pad (fnd_message.get, 1000);
2144: WHEN no_cal_assigned_to_org THEN
2145: x_return_code := 'F';

Line 2143: x_error_msg := r_pad (fnd_message.get, 1000);

2139: fnd_message.set_token ('ERROR', SQLERRM);
2140: x_return_code := 'F';
2141: x_error_msg := fnd_message.get;
2142: WHEN fetch_cal_error THEN
2143: x_error_msg := r_pad (fnd_message.get, 1000);
2144: WHEN no_cal_assigned_to_org THEN
2145: x_return_code := 'F';
2146: WHEN OTHERS THEN
2147: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2208: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');

2204: END IF; */
2205:
2206: --- Warn the user that start date is a non working time
2207: IF NOT l_is_working_day THEN
2208: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2209: --Bug3315440
2210: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_start_date,'DD-MON-YYYY HH24 MI SS'));
2211: --Bug4068469: removed trunc from the set_token call
2212: fnd_message.set_token ('PDATE'

Line 2210: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_start_date,'DD-MON-YYYY HH24 MI SS'));

2206: --- Warn the user that start date is a non working time
2207: IF NOT l_is_working_day THEN
2208: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2209: --Bug3315440
2210: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_start_date,'DD-MON-YYYY HH24 MI SS'));
2211: --Bug4068469: removed trunc from the set_token call
2212: fnd_message.set_token ('PDATE'
2213: ,fnd_date.date_to_displaydt (p_start_date,2) );
2214: RAISE non_work_time;

Line 2212: fnd_message.set_token ('PDATE'

2208: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2209: --Bug3315440
2210: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_start_date,'DD-MON-YYYY HH24 MI SS'));
2211: --Bug4068469: removed trunc from the set_token call
2212: fnd_message.set_token ('PDATE'
2213: ,fnd_date.date_to_displaydt (p_start_date,2) );
2214: RAISE non_work_time;
2215: END IF;
2216: END IF;

Line 2238: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');

2234: END IF; */
2235:
2236: --- Warn the user that end date is a non working time
2237: IF NOT l_is_working_day THEN
2238: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2239: --Bug3315440
2240: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_end_date,'DD-MON-YYYY HH24 MI SS'));
2241: --Bug4068469: removed trunc from the set_token call
2242: fnd_message.set_token ('PDATE'

Line 2240: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_end_date,'DD-MON-YYYY HH24 MI SS'));

2236: --- Warn the user that end date is a non working time
2237: IF NOT l_is_working_day THEN
2238: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2239: --Bug3315440
2240: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_end_date,'DD-MON-YYYY HH24 MI SS'));
2241: --Bug4068469: removed trunc from the set_token call
2242: fnd_message.set_token ('PDATE'
2243: ,fnd_date.date_to_displaydt (p_end_date,2) );
2244: RAISE non_work_time;

Line 2242: fnd_message.set_token ('PDATE'

2238: fnd_message.set_name ('GME', 'GME_SHOP_NON_WKG');
2239: --Bug3315440
2240: -- FND_MESSAGE.SET_TOKEN('PDATE', TO_CHAR(p_end_date,'DD-MON-YYYY HH24 MI SS'));
2241: --Bug4068469: removed trunc from the set_token call
2242: fnd_message.set_token ('PDATE'
2243: ,fnd_date.date_to_displaydt (p_end_date,2) );
2244: RAISE non_work_time;
2245: END IF;
2246: END IF;

Line 2250: x_error_msg := r_pad (fnd_message.get, 1000);

2246: END IF;
2247: EXCEPTION
2248: WHEN non_work_time THEN
2249: x_return_code := 'C';
2250: x_error_msg := r_pad (fnd_message.get, 1000);
2251: WHEN reschedule_error THEN
2252: x_return_code := 'F';
2253: x_error_msg := r_pad (fnd_message.get, 1000);
2254: WHEN no_calendar_assigned THEN

Line 2253: x_error_msg := r_pad (fnd_message.get, 1000);

2249: x_return_code := 'C';
2250: x_error_msg := r_pad (fnd_message.get, 1000);
2251: WHEN reschedule_error THEN
2252: x_return_code := 'F';
2253: x_error_msg := r_pad (fnd_message.get, 1000);
2254: WHEN no_calendar_assigned THEN
2255: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2256: x_return_code := 'F';
2257: x_error_msg := r_pad (fnd_message.get, 1000);

Line 2255: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');

2251: WHEN reschedule_error THEN
2252: x_return_code := 'F';
2253: x_error_msg := r_pad (fnd_message.get, 1000);
2254: WHEN no_calendar_assigned THEN
2255: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2256: x_return_code := 'F';
2257: x_error_msg := r_pad (fnd_message.get, 1000);
2258: WHEN OTHERS THEN
2259: --Bug4068469: set x_return_code and the x_error_msg

Line 2257: x_error_msg := r_pad (fnd_message.get, 1000);

2253: x_error_msg := r_pad (fnd_message.get, 1000);
2254: WHEN no_calendar_assigned THEN
2255: fnd_message.set_name ('GMP', 'GME_NO_CAL_ASSIGNED_TO_PLANT');
2256: x_return_code := 'F';
2257: x_error_msg := r_pad (fnd_message.get, 1000);
2258: WHEN OTHERS THEN
2259: --Bug4068469: set x_return_code and the x_error_msg
2260: x_return_code := 'U';
2261: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2262: x_error_msg := r_pad (fnd_message.get, 1000);

2258: WHEN OTHERS THEN
2259: --Bug4068469: set x_return_code and the x_error_msg
2260: x_return_code := 'U';
2261: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2262: x_error_msg := r_pad (fnd_message.get, 1000);
2263: END validate_reschedule_event;
2264:
2265: /*======================================================================
2266: # For timezone changes.