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_PENDING_PRODUCT_LOTS_PVT dependencies on FND_MSG_PUB

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

45: WHEN OTHERS THEN
46: IF g_debug <= gme_debug.g_log_unexpected THEN
47: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
48: END IF;
49: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
51: END get_pending_lot;
52:
53: PROCEDURE relieve_pending_lot

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

127: WHEN OTHERS THEN
128: IF g_debug <= gme_debug.g_log_unexpected THEN
129: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
130: END IF;
131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: END relieve_pending_lot;
134:
135: PROCEDURE create_product_lot

Line 323: fnd_msg_pub.ADD;

319: ELSIF l_shelf_life_code = 4 THEN
320: IF p_expiration_date IS NULL THEN /* user-defined */
321: FND_MESSAGE.SET_NAME('INV','INV_NULL_EXPIRATION_DATE_EXP');
322: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
323: fnd_msg_pub.ADD;
324: RAISE error_null_exp_dt;
325: ELSE
326: l_in_lot_rec.expiration_date := p_expiration_date;
327: END IF;

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

368: NULL;
369: WHEN error_not_prod OR error_lot_create OR error_gen_lot_no_create OR error_null_lots OR error_null_exp_dt THEN
370: x_return_status := fnd_api.g_ret_sts_error;
371: WHEN OTHERS THEN
372: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
373: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
374: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
375: END IF;
376: x_return_status := FND_API.g_ret_sts_unexp_error;

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

413: WHEN OTHERS THEN
414: IF g_debug <= gme_debug.g_log_unexpected THEN
415: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
416: END IF;
417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: END create_pending_product_lot;
420:
421: PROCEDURE update_pending_product_lot

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

456: WHEN OTHERS THEN
457: IF g_debug <= gme_debug.g_log_unexpected THEN
458: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
459: END IF;
460: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: END update_pending_product_lot;
463:
464: PROCEDURE delete_pending_product_lot

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

491: WHEN OTHERS THEN
492: IF g_debug <= gme_debug.g_log_unexpected THEN
493: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
494: END IF;
495: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: END delete_pending_product_lot;
498:
499: --Bug#5078853 created the following over loaded procedure

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

542: WHEN OTHERS THEN
543: IF g_debug <= gme_debug.g_log_unexpected THEN
544: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
545: END IF;
546: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: END delete_pending_product_lot;
549:
550: PROCEDURE validate_material_for_create

Line 583: fnd_msg_pub.ADD;

579:
580: IF l_item_rec.lot_control_code = 1 THEN
581: FND_MESSAGE.SET_NAME('INV','INV_NO_LOT_CONTROL');
582: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
583: fnd_msg_pub.ADD;
584: RAISE error_not_lot_control;
585: END IF;
586:
587: IF p_batch_header_rec.update_inventory_ind = 'N' THEN

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

606: WHEN OTHERS THEN
607: IF g_debug <= gme_debug.g_log_unexpected THEN
608: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
609: END IF;
610: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: END validate_material_for_create;
613:
614: FUNCTION get_last_sequence

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

644: WHEN OTHERS THEN
645: IF g_debug <= gme_debug.g_log_unexpected THEN
646: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
647: END IF;
648: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: END get_last_sequence;
651:
652: PROCEDURE validate_record_for_create

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

828: WHEN OTHERS THEN
829: IF g_debug <= gme_debug.g_log_unexpected THEN
830: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
831: END IF;
832: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: END validate_record_for_create;
835:
836: PROCEDURE validate_material_for_update

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

855: WHEN OTHERS THEN
856: IF g_debug <= gme_debug.g_log_unexpected THEN
857: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
858: END IF;
859: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: END validate_material_for_update;
862:
863: PROCEDURE validate_record_for_update

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

1071: WHEN OTHERS THEN
1072: IF g_debug <= gme_debug.g_log_unexpected THEN
1073: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1074: END IF;
1075: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1077: END validate_record_for_update;
1078:
1079: PROCEDURE validate_material_for_delete

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

1098: WHEN OTHERS THEN
1099: IF g_debug <= gme_debug.g_log_unexpected THEN
1100: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1101: END IF;
1102: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: END validate_material_for_delete;
1105:
1106: PROCEDURE validate_record_for_delete

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

1148: WHEN OTHERS THEN
1149: IF g_debug <= gme_debug.g_log_unexpected THEN
1150: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1151: END IF;
1152: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: END validate_record_for_delete;
1155:
1156: -- Call this procedure at the record level because fields besides lot number are required

Line 1299: fnd_msg_pub.ADD;

1295: RETURN FALSE;
1296: WHEN error_um_conv THEN
1297: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1298: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1299: fnd_msg_pub.ADD;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: RETURN FALSE;
1302: WHEN OTHERS THEN
1303: IF g_debug <= gme_debug.g_log_unexpected THEN

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

1302: WHEN OTHERS THEN
1303: IF g_debug <= gme_debug.g_log_unexpected THEN
1304: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1305: END IF;
1306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: RETURN FALSE;
1309: END validate_quantities;
1310:

Line 1347: fnd_msg_pub.ADD;

1343: l_return := TRUE;
1344: ELSE
1345: FND_MESSAGE.SET_NAME('INV','INV_LOT_NOT_EXISTS');
1346: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1347: fnd_msg_pub.ADD;
1348: l_return := FALSE;
1349: END IF;
1350:
1351: IF g_debug <= gme_debug.g_log_procedure THEN

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

1358: WHEN OTHERS THEN
1359: IF g_debug <= gme_debug.g_log_unexpected THEN
1360: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1361: END IF;
1362: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: RETURN FALSE;
1365: END validate_lot_number;
1366:

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

1420: WHEN OTHERS THEN
1421: IF g_debug <= gme_debug.g_log_unexpected THEN
1422: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1423: END IF;
1424: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: RETURN FALSE;
1427: END validate_sequence;
1428:

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

1467: WHEN OTHERS THEN
1468: IF g_debug <= gme_debug.g_log_unexpected THEN
1469: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1470: END IF;
1471: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: RETURN FALSE;
1474: END validate_revision;
1475:

Line 1508: fnd_msg_pub.ADD;

1504:
1505: IF l_is_reason = 0 THEN
1506: FND_MESSAGE.SET_NAME('INV','INV_INT_REACODE');
1507: FND_MESSAGE.SET_TOKEN('PGM_NAME',g_pkg_name||'.'||l_api_name);
1508: fnd_msg_pub.ADD;
1509: l_return := FALSE;
1510: ELSE
1511: l_return := TRUE;
1512: END IF;

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

1520: WHEN OTHERS THEN
1521: IF g_debug <= gme_debug.g_log_unexpected THEN
1522: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1523: END IF;
1524: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: RETURN FALSE;
1527: END validate_reason_id;
1528:

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

1567: WHEN OTHERS THEN
1568: IF g_debug <= gme_debug.g_log_unexpected THEN
1569: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1570: END IF;
1571: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1572: RETURN FALSE;
1573: END pending_product_lot_exist;
1574:
1575: -- nsinghi bug#5689035. Added this procedure.

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

1618: || ' Error is '
1619: || SQLERRM);
1620: END IF;
1621:
1622: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1623: x_return_status := fnd_api.g_ret_sts_unexp_error;
1624: END get_pnd_prod_lot_qty;
1625:
1626: END gme_pending_product_lots_pvt;