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.GME_COMMON_PVT dependencies on FND_MSG_PUB

Line 132: fnd_msg_pub.ADD;

128: IF p_token6_name IS NOT NULL THEN
129: fnd_message.set_token (p_token6_name, p_token6_value);
130: END IF;
131:
132: fnd_msg_pub.ADD;
133:
134: IF g_debug <= gme_debug.g_log_procedure THEN
135: --FPBug#4351032 modified to include new token and value
136: gme_debug.put_line ( 'FROM LOG_MESSAGE '

Line 171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

167: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
168: END IF;
169: EXCEPTION
170: WHEN OTHERS THEN
171: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
172:
173: IF g_debug <= gme_debug.g_log_unexpected THEN
174: gme_debug.put_line ( 'When others exception in '
175: || g_pkg_name

Line 372: fnd_msg_pub.ADD;

368: RETURN TRUE;
369: EXCEPTION
370: WHEN invalid_user THEN
371: fnd_message.set_name ('INV', 'INV_INT_USRCODE');
372: fnd_msg_pub.ADD;
373: RETURN FALSE;
374: WHEN missing_profile_option THEN
375: RETURN FALSE;
376: WHEN inv_params_not_found THEN

Line 378: fnd_msg_pub.ADD;

374: WHEN missing_profile_option THEN
375: RETURN FALSE;
376: WHEN inv_params_not_found THEN
377: fnd_message.set_name ('INV', 'INV-NO ORG INFORMATION');
378: fnd_msg_pub.ADD;
379: RETURN FALSE;
380: WHEN gmd_params_not_defined THEN
381: RETURN FALSE;
382: WHEN gme_params_not_defined THEN

Line 395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

391: || ' Error is '
392: || SQLERRM);
393: END IF;
394:
395: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
396: RETURN FALSE;
397: END setup;
398:
399: PROCEDURE set_timestamp

Line 406: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

402: BEGIN
403: gme_common_pvt.g_timestamp := SYSDATE;
404: EXCEPTION
405: WHEN OTHERS THEN
406: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
407:
408: IF g_debug <= gme_debug.g_log_unexpected THEN
409: gme_debug.put_line ( 'When others exception in '
410: || g_pkg_name

Line 427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

423: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
424: gme_common_pvt.set_timestamp;
425: EXCEPTION
426: WHEN OTHERS THEN
427: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
428:
429: IF g_debug <= gme_debug.g_log_unexpected THEN
430: gme_debug.put_line ( 'When others exception in '
431: || g_pkg_name

Line 447: l_msg_count := fnd_msg_pub.count_msg;

443: IS
444: l_msg_count NUMBER;
445: l_api_name CONSTANT VARCHAR2 (30) := 'count_and_get';
446: BEGIN
447: l_msg_count := fnd_msg_pub.count_msg;
448: x_data :=
449: fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last
450: ,p_encoded => p_encoded);
451: x_count := l_msg_count;

Line 449: fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last

445: l_api_name CONSTANT VARCHAR2 (30) := 'count_and_get';
446: BEGIN
447: l_msg_count := fnd_msg_pub.count_msg;
448: x_data :=
449: fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last
450: ,p_encoded => p_encoded);
451: x_count := l_msg_count;
452: EXCEPTION
453: WHEN OTHERS THEN

Line 454: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

450: ,p_encoded => p_encoded);
451: x_count := l_msg_count;
452: EXCEPTION
453: WHEN OTHERS THEN
454: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
455:
456: IF g_debug <= gme_debug.g_log_unexpected THEN
457: gme_debug.put_line ( 'When others exception in '
458: || g_pkg_name

Line 489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

485: x_timestamp := gme_common_pvt.g_timestamp;
486: EXCEPTION
487: WHEN OTHERS THEN
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
490: fnd_msg_pub.count_and_get (p_count => l_message_count
491: ,p_data => l_message_list);
492:
493: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 490: fnd_msg_pub.count_and_get (p_count => l_message_count

486: EXCEPTION
487: WHEN OTHERS THEN
488: x_return_status := fnd_api.g_ret_sts_unexp_error;
489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
490: fnd_msg_pub.count_and_get (p_count => l_message_count
491: ,p_data => l_message_list);
492:
493: IF g_debug <= gme_debug.g_log_unexpected THEN
494: gme_debug.put_line ( 'When others exception in '

Line 614: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

610: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
611: END IF;
612: EXCEPTION
613: WHEN OTHERS THEN
614: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
615:
616: IF g_debug <= gme_debug.g_log_unexpected THEN
617: gme_debug.put_line ( 'When others exception in '
618: || g_pkg_name

Line 740: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

736: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
737: END IF;
738: EXCEPTION
739: WHEN OTHERS THEN
740: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
741:
742: IF g_debug <= gme_debug.g_log_unexpected THEN
743: gme_debug.put_line ( 'When others exception in '
744: || g_pkg_name

Line 1207: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1203: EXCEPTION
1204: WHEN expected_error THEN
1205: RETURN (NULL);
1206: WHEN OTHERS THEN
1207: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1208:
1209: IF g_debug <= gme_debug.g_log_unexpected THEN
1210: gme_debug.put_line ( 'When others exception in '
1211: || g_pkg_name

Line 1280: fnd_msg_pub.ADD;

1276: EXCEPTION
1277: WHEN invalid_doc_no THEN
1278: x_batch_header_rec.batch_no := NULL;
1279: fnd_message.set_name ('GME', 'GME_INVALID_AUTO_DOC');
1280: fnd_msg_pub.ADD;
1281: ROLLBACK;
1282: WHEN app_exception.record_lock_exception THEN
1283: gme_common_pvt.log_message ('GME_DOC_SEQ_LOCK'
1284: ,'S1'

Line 1290: fnd_msg_pub.ADD;

1286: ROLLBACK;
1287: WHEN NO_DATA_FOUND THEN
1288: x_batch_header_rec.batch_no := NULL;
1289: fnd_message.set_name ('GMA', 'SY_NODOCSEQREC');
1290: fnd_msg_pub.ADD;
1291: ROLLBACK;
1292: WHEN OTHERS THEN
1293: IF g_debug <= gme_debug.g_log_unexpected THEN
1294: gme_debug.put_line ( 'When others exception in '

Line 1302: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1298: || ' Error is '
1299: || SQLERRM);
1300: END IF;
1301:
1302: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1303: x_batch_header_rec.batch_no := NULL;
1304: ROLLBACK;
1305: END create_document_no;
1306:

Line 1380: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1376: || ' Error is '
1377: || SQLERRM);
1378: END IF;
1379:
1380: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1381: RETURN FALSE;
1382: END calc_date_from_prod_rule;
1383:
1384: PROCEDURE calc_mtl_req_date (

Line 1495: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1491: || ' Error is '
1492: || SQLERRM);
1493: END IF;
1494:
1495: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1496: x_return_status := fnd_api.g_ret_sts_unexp_error;
1497: END calc_mtl_req_date;
1498:
1499: FUNCTION is_qty_below_capacity (

Line 1670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1666: || ' Error is '
1667: || SQLERRM);
1668: END IF;
1669:
1670: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1671: RETURN FALSE;
1672: END is_qty_below_capacity;
1673:
1674: FUNCTION resource_qty_below_capacity (p_batch_id IN NUMBER)

Line 1748: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1744: || ' Error is '
1745: || SQLERRM);
1746: END IF;
1747:
1748: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1749: RETURN FALSE;
1750: END resource_qty_below_capacity;
1751:
1752: FUNCTION eff_locator_control (

Line 1887: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1883: || ' Error is '
1884: || SQLERRM);
1885: END IF;
1886:
1887: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1888: RETURN -1;
1889: END eff_locator_control;
1890:
1891: FUNCTION check_locator (

Line 1965: fnd_msg_pub.ADD;

1961: ,p_is_from_locator => NULL
1962: ,p_dynamic_ok => TRUE) =
1963: inv_validate.f) THEN
1964: fnd_message.set_name ('INV', 'INV_INVALID_LOCATION');
1965: fnd_msg_pub.ADD;
1966:
1967: IF g_debug <= gme_debug.g_log_statement THEN
1968: gme_debug.put_line ( g_pkg_name
1969: || '.'

Line 1993: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1989: || ' Error IS '
1990: || SQLERRM);
1991: END IF;
1992:
1993: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1994: RETURN FALSE;
1995: END check_locator;
1996:
1997: FUNCTION check_subinventory (

Line 2099: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2095: || ' Error is '
2096: || SQLERRM);
2097: END IF;
2098:
2099: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2100: RETURN FALSE;
2101: END check_subinventory;
2102:
2103: FUNCTION validate_validity_rule (

Line 2339: fnd_msg_pub.ADD;

2335: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
2336: fnd_message.set_token ('ITEM_NO', l_item_no);
2337: fnd_message.set_token ('FROM_UOM', l_from_uom);
2338: fnd_message.set_token ('TO_UOM', l_to_uom);
2339: fnd_msg_pub.ADD;
2340: RETURN FALSE;
2341: WHEN validation_failure THEN
2342: gme_common_pvt.log_message ('GME_INVALID_VALIDITY_RULE_QTY');
2343: RETURN FALSE;

Line 2354: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2350: || ' Error is '
2351: || SQLERRM);
2352: END IF;
2353:
2354: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2355: RETURN FALSE;
2356: END validate_validity_rule;
2357:
2358: PROCEDURE get_batch_shortages (

Line 2786: fnd_msg_pub.add;

2782: fnd_message.set_token ('TO_UOM', l_item_rec.primary_uom_code);
2783: IF (cur_get_materials%ISOPEN) THEN
2784: CLOSE cur_get_materials;
2785: END IF;
2786: fnd_msg_pub.add;
2787: WHEN exception_ins_err THEN
2788: x_return_status := fnd_api.g_ret_sts_unexp_error;
2789: IF (cur_get_materials%ISOPEN) THEN
2790: CLOSE cur_get_materials;

Line 2804: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2800: END IF;
2801: IF (cur_get_materials%ISOPEN) THEN
2802: CLOSE cur_get_materials;
2803: END IF;
2804: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2805: x_return_status := fnd_api.g_ret_sts_unexp_error;
2806: END get_batch_shortages;
2807:
2808: PROCEDURE get_open_qty (

Line 3058: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3054: || ' Error is '
3055: || SQLERRM);
3056: END IF;
3057:
3058: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3059: x_return_status := fnd_api.g_ret_sts_unexp_error;
3060: END get_open_qty;
3061:
3062: FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)

Line 3104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3100: || ' Error is '
3101: || SQLERRM);
3102: END IF;
3103:
3104: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3105: RETURN FALSE;
3106: END insert_exceptions;
3107:
3108: FUNCTION populate_temp_from_struct (

Line 3141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3137: || ' Error is '
3138: || SQLERRM);
3139: END IF;
3140:
3141: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3142: RETURN FALSE;
3143: END populate_temp_from_struct;
3144:
3145: FUNCTION is_material_assoc_to_step (

Line 3183: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3179: || ' Error is '
3180: || SQLERRM);
3181: END IF;
3182:
3183: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3184: l_is_assoc := FALSE;
3185: RETURN l_is_assoc;
3186: END is_material_assoc_to_step;
3187:

Line 3235: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3231: || ' Error is '
3232: || SQLERRM);
3233: END IF;
3234: --FPBug#4585491 commented out the following line
3235: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3236: RETURN FALSE;
3237: WHEN OTHERS THEN
3238: IF g_debug <= gme_debug.g_log_unexpected THEN
3239: gme_debug.put_line ( 'When others exception in '

Line 3247: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3243: || ' Error is '
3244: || SQLERRM);
3245: END IF;
3246:
3247: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3248: RETURN FALSE;
3249: END get_assoc_step;
3250:
3251: FUNCTION get_batch_header (

Line 3335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3331: || ' Error is '
3332: || SQLERRM);
3333: END IF;
3334:
3335: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3336: RETURN FALSE;
3337: END get_batch_header;
3338:
3339: FUNCTION get_batch_step (

Line 3408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3404: || ' Error is '
3405: || SQLERRM);
3406: END IF;
3407:
3408: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3409: RETURN FALSE;
3410: END get_batch_step;
3411:
3412: FUNCTION create_history (

Line 3448: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3444: || ' Error is '
3445: || SQLERRM);
3446: END IF;
3447:
3448: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3449: RETURN FALSE;
3450: END create_history;
3451:
3452: FUNCTION close_period_check_flexible (

Line 3502: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3498: || ' Error is '
3499: || SQLERRM);
3500: END IF;
3501:
3502: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3503: RETURN FALSE;
3504: END close_period_check_flexible;
3505:
3506: FUNCTION get_batchstep_rsrc (

Line 3936: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3932:
3933: RETURN TRUE;
3934: EXCEPTION
3935: WHEN invalid_validity_rule THEN
3936: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3937: RETURN FALSE;
3938: WHEN OTHERS THEN
3939: IF (NVL (g_debug, 0) > 0) THEN
3940: gme_debug.put_line ( g_pkg_name

Line 3948: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

3944: || ' OTHERS:'
3945: || SQLERRM);
3946: END IF;
3947:
3948: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3949: RETURN FALSE;
3950: END check_validity_rule_dates;
3951:
3952: /*======================================================================

Line 4515: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4511: || l_msg_data);
4512: END IF; -- 4944024 END
4513: WHEN OTHERS THEN
4514: x_return_status := fnd_api.g_ret_sts_unexp_error;
4515: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4516:
4517: IF (NVL (g_debug, 0) > 0) THEN
4518: gme_debug.put_line ( g_pkg_name
4519: || '.'

Line 4594: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4590:
4591: RETURN l_is_auto;
4592: EXCEPTION
4593: WHEN OTHERS THEN
4594: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4595:
4596: IF (NVL (g_debug, 0) > 0) THEN
4597: gme_debug.put_line ( g_pkg_name
4598: || '.'

Line 4674: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4670: || ' Error is '
4671: || SQLERRM);
4672: END IF;
4673:
4674: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4675: RETURN FALSE;
4676: END get_material_detail;
4677: -- Pawan Kumar Added for bug 5138929
4678: FUNCTION check_close_period (

Line 4698: FND_MSG_PUB.Add;

4694: ,period_id => l_period_id
4695: ,open_past_period => l_open_past_period);
4696: IF (l_period_id = 0) THEN
4697: FND_MESSAGE.SET_NAME('INV','INV_NO_OPEN_PERIOD');
4698: FND_MSG_PUB.Add;
4699: RETURN FALSE;
4700: ELSIF (l_period_id = -1) THEN
4701: FND_MESSAGE.SET_NAME('INV', 'INV_RETRIEVE_PERIOD');
4702: FND_MSG_PUB.Add;

Line 4702: FND_MSG_PUB.Add;

4698: FND_MSG_PUB.Add;
4699: RETURN FALSE;
4700: ELSIF (l_period_id = -1) THEN
4701: FND_MESSAGE.SET_NAME('INV', 'INV_RETRIEVE_PERIOD');
4702: FND_MSG_PUB.Add;
4703: RETURN FALSE;
4704: ELSIF (l_period_id > 0) THEN
4705: RETURN TRUE;
4706: END IF;

Line 4719: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4715: || ' Error is '
4716: || SQLERRM);
4717: END IF;
4718:
4719: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4720: RETURN FALSE;
4721: END check_close_period;
4722:
4723: /*======================================================================

Line 4825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4821: || g_pkg_name|| '.'||l_api_name||'Error is '
4822: || SQLERRM);
4823: END IF;
4824: x_return_status := fnd_api.g_ret_sts_unexp_error;
4825: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4826:
4827: END Validate_batch;
4828: /*======================================================================
4829: -- PROCEDURE :

Line 4942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

4938: || ' Error is '
4939: || SQLERRM);
4940: END IF;
4941: x_return_status := fnd_api.g_ret_sts_unexp_error;
4942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4943: gme_common_pvt.count_and_get (x_count => x_message_count
4944: ,p_encoded => fnd_api.g_false
4945: ,x_data => x_message_list);
4946: END Validate_material_detail;

Line 5049: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

5045: || ' Error is '
5046: || SQLERRM);
5047: END IF;
5048: x_return_status := fnd_api.g_ret_sts_unexp_error;
5049: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5050: gme_common_pvt.count_and_get (x_count => x_message_count
5051: ,p_encoded => fnd_api.g_false
5052: ,x_data => x_message_list);
5053: END Validate_batch_step;

Line 5181: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

5177: || ' Error is '
5178: || SQLERRM);
5179: END IF;
5180:
5181: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5182: x_return_status := fnd_api.g_ret_sts_unexp_error;
5183: END fetch_trans_date;
5184: /*======================================================================
5185: * -- PROCEDURE :

Line 5251: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

5247: END IF;
5248: RETURN TRUE;
5249: EXCEPTION
5250: WHEN OTHERS THEN
5251: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5252: RETURN FALSE;
5253:
5254: END check_oprn_effectivity_dates ;
5255: