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 218: fnd_msg_pub.ADD;

214: IF p_token6_name IS NOT NULL THEN
215: fnd_message.set_token (p_token6_name, p_token6_value);
216: END IF;
217:
218: fnd_msg_pub.ADD;
219:
220: IF g_debug <= gme_debug.g_log_procedure THEN
221: --FPBug#4351032 modified to include new token and value
222: gme_debug.put_line ( 'FROM LOG_MESSAGE '

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

253: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
254: END IF;
255: EXCEPTION
256: WHEN OTHERS THEN
257: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
258:
259: IF g_debug <= gme_debug.g_log_unexpected THEN
260: gme_debug.put_line ( 'When others exception in '
261: || g_pkg_name

Line 462: fnd_msg_pub.ADD;

458: RETURN TRUE;
459: EXCEPTION
460: WHEN invalid_user THEN
461: fnd_message.set_name ('INV', 'INV_INT_USRCODE');
462: fnd_msg_pub.ADD;
463: RETURN FALSE;
464: WHEN missing_profile_option THEN
465: RETURN FALSE;
466: WHEN inv_params_not_found THEN

Line 468: fnd_msg_pub.ADD;

464: WHEN missing_profile_option THEN
465: RETURN FALSE;
466: WHEN inv_params_not_found THEN
467: fnd_message.set_name ('INV', 'INV-NO ORG INFORMATION');
468: fnd_msg_pub.ADD;
469: RETURN FALSE;
470: WHEN gmd_params_not_defined THEN
471: RETURN FALSE;
472: WHEN gme_params_not_defined THEN

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

481: || ' Error is '
482: || SQLERRM);
483: END IF;
484:
485: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
486: RETURN FALSE;
487: END setup;
488:
489: PROCEDURE set_timestamp

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

492: BEGIN
493: gme_common_pvt.g_timestamp := SYSDATE;
494: EXCEPTION
495: WHEN OTHERS THEN
496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
497:
498: IF g_debug <= gme_debug.g_log_unexpected THEN
499: gme_debug.put_line ( 'When others exception in '
500: || g_pkg_name

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

513: gme_common_pvt.g_login_id := fnd_profile.VALUE ('LOGIN_ID');
514: gme_common_pvt.set_timestamp;
515: EXCEPTION
516: WHEN OTHERS THEN
517: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
518:
519: IF g_debug <= gme_debug.g_log_unexpected THEN
520: gme_debug.put_line ( 'When others exception in '
521: || g_pkg_name

Line 537: l_msg_count := fnd_msg_pub.count_msg;

533: IS
534: l_msg_count NUMBER;
535: l_api_name CONSTANT VARCHAR2 (30) := 'count_and_get';
536: BEGIN
537: l_msg_count := fnd_msg_pub.count_msg;
538: x_data :=
539: fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last
540: ,p_encoded => p_encoded);
541: x_count := l_msg_count;

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

535: l_api_name CONSTANT VARCHAR2 (30) := 'count_and_get';
536: BEGIN
537: l_msg_count := fnd_msg_pub.count_msg;
538: x_data :=
539: fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last
540: ,p_encoded => p_encoded);
541: x_count := l_msg_count;
542: EXCEPTION
543: WHEN OTHERS THEN

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

540: ,p_encoded => p_encoded);
541: x_count := l_msg_count;
542: EXCEPTION
543: WHEN OTHERS THEN
544: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
545:
546: IF g_debug <= gme_debug.g_log_unexpected THEN
547: gme_debug.put_line ( 'When others exception in '
548: || g_pkg_name

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

575: x_timestamp := gme_common_pvt.g_timestamp;
576: EXCEPTION
577: WHEN OTHERS THEN
578: x_return_status := fnd_api.g_ret_sts_unexp_error;
579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
580: fnd_msg_pub.count_and_get (p_count => l_message_count
581: ,p_data => l_message_list);
582:
583: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 580: fnd_msg_pub.count_and_get (p_count => l_message_count

576: EXCEPTION
577: WHEN OTHERS THEN
578: x_return_status := fnd_api.g_ret_sts_unexp_error;
579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
580: fnd_msg_pub.count_and_get (p_count => l_message_count
581: ,p_data => l_message_list);
582:
583: IF g_debug <= gme_debug.g_log_unexpected THEN
584: gme_debug.put_line ( 'When others exception in '

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

700: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
701: END IF;
702: EXCEPTION
703: WHEN OTHERS THEN
704: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
705:
706: IF g_debug <= gme_debug.g_log_unexpected THEN
707: gme_debug.put_line ( 'When others exception in '
708: || g_pkg_name

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

826: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
831:
832: IF g_debug <= gme_debug.g_log_unexpected THEN
833: gme_debug.put_line ( 'When others exception in '
834: || g_pkg_name

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

1293: EXCEPTION
1294: WHEN expected_error THEN
1295: RETURN (NULL);
1296: WHEN OTHERS THEN
1297: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1298:
1299: IF g_debug <= gme_debug.g_log_unexpected THEN
1300: gme_debug.put_line ( 'When others exception in '
1301: || g_pkg_name

Line 1370: fnd_msg_pub.ADD;

1366: EXCEPTION
1367: WHEN invalid_doc_no THEN
1368: x_batch_header_rec.batch_no := NULL;
1369: fnd_message.set_name ('GME', 'GME_INVALID_AUTO_DOC');
1370: fnd_msg_pub.ADD;
1371: ROLLBACK;
1372: WHEN app_exception.record_lock_exception THEN
1373: gme_common_pvt.log_message ('GME_DOC_SEQ_LOCK'
1374: ,'S1'

Line 1380: fnd_msg_pub.ADD;

1376: ROLLBACK;
1377: WHEN NO_DATA_FOUND THEN
1378: x_batch_header_rec.batch_no := NULL;
1379: fnd_message.set_name ('GMA', 'SY_NODOCSEQREC');
1380: fnd_msg_pub.ADD;
1381: ROLLBACK;
1382: WHEN OTHERS THEN
1383: IF g_debug <= gme_debug.g_log_unexpected THEN
1384: gme_debug.put_line ( 'When others exception in '

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

1388: || ' Error is '
1389: || SQLERRM);
1390: END IF;
1391:
1392: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1393: x_batch_header_rec.batch_no := NULL;
1394: ROLLBACK;
1395: END create_document_no;
1396:

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

1473: || ' Error is '
1474: || SQLERRM);
1475: END IF;
1476:
1477: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1478: RETURN FALSE;
1479: END calc_date_from_prod_rule;
1480:
1481: PROCEDURE calc_mtl_req_date (

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

1588: || ' Error is '
1589: || SQLERRM);
1590: END IF;
1591:
1592: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: END calc_mtl_req_date;
1595:
1596: FUNCTION is_qty_below_capacity (

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

1763: || ' Error is '
1764: || SQLERRM);
1765: END IF;
1766:
1767: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1768: RETURN FALSE;
1769: END is_qty_below_capacity;
1770:
1771: FUNCTION resource_qty_below_capacity (p_batch_id IN NUMBER)

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

1850: || ' Error is '
1851: || SQLERRM);
1852: END IF;
1853:
1854: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1855: RETURN FALSE;
1856: END resource_qty_below_capacity;
1857:
1858: FUNCTION eff_locator_control (

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 -1;
1995: END eff_locator_control;
1996:
1997: FUNCTION check_locator (

Line 2071: fnd_msg_pub.ADD;

2067: ,p_is_from_locator => NULL
2068: ,p_dynamic_ok => TRUE) =
2069: inv_validate.f) THEN
2070: fnd_message.set_name ('INV', 'INV_INVALID_LOCATION');
2071: fnd_msg_pub.ADD;
2072:
2073: IF g_debug <= gme_debug.g_log_statement THEN
2074: gme_debug.put_line ( g_pkg_name
2075: || '.'

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_locator;
2102:
2103: FUNCTION check_subinventory (

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

2201: || ' Error is '
2202: || SQLERRM);
2203: END IF;
2204:
2205: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2206: RETURN FALSE;
2207: END check_subinventory;
2208:
2209: FUNCTION validate_validity_rule (

Line 2454: fnd_msg_pub.ADD;

2450: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
2451: fnd_message.set_token ('ITEM_NO', l_item_no);
2452: fnd_message.set_token ('FROM_UOM', l_from_uom);
2453: fnd_message.set_token ('TO_UOM', l_to_uom);
2454: fnd_msg_pub.ADD;
2455: RETURN FALSE;
2456: WHEN validation_failure THEN
2457: gme_common_pvt.log_message ('GME_INVALID_VALIDITY_RULE_QTY');
2458: RETURN FALSE;

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

2465: || ' Error is '
2466: || SQLERRM);
2467: END IF;
2468:
2469: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2470: RETURN FALSE;
2471: END validate_validity_rule;
2472:
2473: PROCEDURE get_batch_shortages (

Line 2950: fnd_msg_pub.add;

2946: fnd_message.set_token ('TO_UOM', l_item_rec.primary_uom_code);
2947: IF (cur_get_materials%ISOPEN) THEN
2948: CLOSE cur_get_materials;
2949: END IF;
2950: fnd_msg_pub.add;
2951: WHEN exception_ins_err THEN
2952: x_return_status := fnd_api.g_ret_sts_unexp_error;
2953: IF (cur_get_materials%ISOPEN) THEN
2954: CLOSE cur_get_materials;

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

2964: END IF;
2965: IF (cur_get_materials%ISOPEN) THEN
2966: CLOSE cur_get_materials;
2967: END IF;
2968: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2969: x_return_status := fnd_api.g_ret_sts_unexp_error;
2970: END get_batch_shortages;
2971:
2972: PROCEDURE get_open_qty (

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

3312: || ' Error is '
3313: || SQLERRM);
3314: END IF;
3315:
3316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3317: x_return_status := fnd_api.g_ret_sts_unexp_error;
3318: END get_open_qty;
3319:
3320: FUNCTION insert_exceptions (p_exception_rec IN gme_exceptions_gtmp%ROWTYPE)

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

3359: || ' Error is '
3360: || SQLERRM);
3361: END IF;
3362:
3363: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3364: RETURN FALSE;
3365: END insert_exceptions;
3366:
3367: FUNCTION populate_temp_from_struct (

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

3396: || ' Error is '
3397: || SQLERRM);
3398: END IF;
3399:
3400: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3401: RETURN FALSE;
3402: END populate_temp_from_struct;
3403:
3404: FUNCTION is_material_assoc_to_step (

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

3438: || ' Error is '
3439: || SQLERRM);
3440: END IF;
3441:
3442: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3443: l_is_assoc := FALSE;
3444: RETURN l_is_assoc;
3445: END is_material_assoc_to_step;
3446:

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

3490: || ' Error is '
3491: || SQLERRM);
3492: END IF;
3493: --FPBug#4585491 commented out the following line
3494: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3495: RETURN FALSE;
3496: WHEN OTHERS THEN
3497: IF g_debug <= gme_debug.g_log_unexpected THEN
3498: gme_debug.put_line ( 'When others exception in '

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

3502: || ' Error is '
3503: || SQLERRM);
3504: END IF;
3505:
3506: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3507: RETURN FALSE;
3508: END get_assoc_step;
3509:
3510: FUNCTION get_batch_header (

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

3590: || ' Error is '
3591: || SQLERRM);
3592: END IF;
3593:
3594: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3595: RETURN FALSE;
3596: END get_batch_header;
3597:
3598: FUNCTION get_batch_step (

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

3663: || ' Error is '
3664: || SQLERRM);
3665: END IF;
3666:
3667: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3668: RETURN FALSE;
3669: END get_batch_step;
3670:
3671: FUNCTION create_history (

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

3703: || ' Error is '
3704: || SQLERRM);
3705: END IF;
3706:
3707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3708: RETURN FALSE;
3709: END create_history;
3710:
3711: FUNCTION close_period_check_flexible (

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

3757: || ' Error is '
3758: || SQLERRM);
3759: END IF;
3760:
3761: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3762: RETURN FALSE;
3763: END close_period_check_flexible;
3764:
3765: FUNCTION get_batchstep_rsrc (

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

4191:
4192: RETURN TRUE;
4193: EXCEPTION
4194: WHEN invalid_validity_rule THEN
4195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4196: RETURN FALSE;
4197: WHEN OTHERS THEN
4198: IF (NVL (g_debug, 0) > 0) THEN
4199: gme_debug.put_line ( g_pkg_name

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

4203: || ' OTHERS:'
4204: || SQLERRM);
4205: END IF;
4206:
4207: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4208: RETURN FALSE;
4209: END check_validity_rule_dates;
4210:
4211: /*======================================================================

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

4770: || l_msg_data);
4771: END IF; -- 4944024 END
4772: WHEN OTHERS THEN
4773: x_return_status := fnd_api.g_ret_sts_unexp_error;
4774: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4775:
4776: IF (NVL (g_debug, 0) > 0) THEN
4777: gme_debug.put_line ( g_pkg_name
4778: || '.'

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

4849:
4850: RETURN l_is_auto;
4851: EXCEPTION
4852: WHEN OTHERS THEN
4853: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4854:
4855: IF (NVL (g_debug, 0) > 0) THEN
4856: gme_debug.put_line ( g_pkg_name
4857: || '.'

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

4929: || ' Error is '
4930: || SQLERRM);
4931: END IF;
4932:
4933: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4934: RETURN FALSE;
4935: END get_material_detail;
4936: -- Pawan Kumar Added for bug 5138929
4937: FUNCTION check_close_period (

Line 4957: FND_MSG_PUB.Add;

4953: ,period_id => l_period_id
4954: ,open_past_period => l_open_past_period);
4955: IF (l_period_id = 0) THEN
4956: FND_MESSAGE.SET_NAME('INV','INV_NO_OPEN_PERIOD');
4957: FND_MSG_PUB.Add;
4958: RETURN FALSE;
4959: ELSIF (l_period_id = -1) THEN
4960: FND_MESSAGE.SET_NAME('INV', 'INV_RETRIEVE_PERIOD');
4961: FND_MSG_PUB.Add;

Line 4961: FND_MSG_PUB.Add;

4957: FND_MSG_PUB.Add;
4958: RETURN FALSE;
4959: ELSIF (l_period_id = -1) THEN
4960: FND_MESSAGE.SET_NAME('INV', 'INV_RETRIEVE_PERIOD');
4961: FND_MSG_PUB.Add;
4962: RETURN FALSE;
4963: ELSIF (l_period_id > 0) THEN
4964: RETURN TRUE;
4965: END IF;

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

4974: || ' Error is '
4975: || SQLERRM);
4976: END IF;
4977:
4978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4979: RETURN FALSE;
4980: END check_close_period;
4981:
4982: /*======================================================================

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

5085: || g_pkg_name|| '.'||l_api_name||'Error is '
5086: || SQLERRM);
5087: END IF;
5088: x_return_status := fnd_api.g_ret_sts_unexp_error;
5089: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5090:
5091: END Validate_batch;
5092: /*======================================================================
5093: -- PROCEDURE :

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

5202: || ' Error is '
5203: || SQLERRM);
5204: END IF;
5205: x_return_status := fnd_api.g_ret_sts_unexp_error;
5206: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5207: gme_common_pvt.count_and_get (x_count => x_message_count
5208: ,p_encoded => fnd_api.g_false
5209: ,x_data => x_message_list);
5210: END Validate_material_detail;

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

5313: || ' Error is '
5314: || SQLERRM);
5315: END IF;
5316: x_return_status := fnd_api.g_ret_sts_unexp_error;
5317: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5318: gme_common_pvt.count_and_get (x_count => x_message_count
5319: ,p_encoded => fnd_api.g_false
5320: ,x_data => x_message_list);
5321: END Validate_batch_step;

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

5451: || ' Error is '
5452: || SQLERRM);
5453: END IF;
5454:
5455: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5456: x_return_status := fnd_api.g_ret_sts_unexp_error;
5457: END fetch_trans_date;
5458: /*======================================================================
5459: * -- PROCEDURE :

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

5521: END IF;
5522: RETURN TRUE;
5523: EXCEPTION
5524: WHEN OTHERS THEN
5525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5526: RETURN FALSE;
5527:
5528: END check_oprn_effectivity_dates ;
5529: