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

Line 250: FND_MSG_PUB.initialize;

246:
247: --
248: -- Initialize message list if p_init_msg_list is set to true
249: IF FND_API.to_Boolean(p_init_msg_list) THEN
250: FND_MSG_PUB.initialize;
251: END IF;
252:
253: -- Initialize API return status to success
254: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 315: FND_MSG_PUB.Add;

311: IF (l_debug = 1) THEN
312: mdebug('fatal error: exported by someone else');
313: END IF;
314: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_ENTRY_EXPORTED');
315: FND_MSG_PUB.Add;
316: x_errorcode := 201;
317: RAISE FND_API.G_EXC_ERROR;
318: end if;
319:

Line 323: FND_MSG_PUB.Add;

319:
320:
321: if (not (c_rec.entry_status_code in (1,3))) then
322: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_ENTRY_STATUS_NA');
323: FND_MSG_PUB.Add;
324: x_errorcode := 202;
325: RAISE FND_API.G_EXC_ERROR;
326: end if;
327:

Line 357: FND_MSG_PUB.Add;

353: -- if user provided cycle_count_entry_id does not correspond
354: -- to anything report an error
355: if (counter = 0) then
356: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_NO_CCE_WITH_CCEID');
357: FND_MSG_PUB.Add;
358: x_errorcode := 203;
359: raise fnd_api.g_exc_error;
360: end if;
361:

Line 372: FND_MSG_PUB.Count_And_Get

368: IF FND_API.to_Boolean(p_commit) THEN
369: COMMIT;
370: END IF;
371:
372: FND_MSG_PUB.Count_And_Get
373: (p_count => x_msg_count
374: , p_data => x_msg_data);
375:
376: EXCEPTION

Line 384: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

380:
381: --
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: --
384: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
385: , p_data => x_msg_data);
386: --
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: --

Line 394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

390: --
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: x_errorcode := -1;
393: --
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
395: , p_data => x_msg_data);
396: --
397: WHEN OTHERS THEN
398: --

Line 404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

400: --
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: x_errorcode := -1;
403: --
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: --
408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: x_errorcode := -1;
403: --
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: --
408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
409: , p_data => x_msg_data);

Line 408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: --
408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
409: , p_data => x_msg_data);
410: END;
411:
412:

Line 489: FND_MSG_PUB.initialize;

485:
486: --
487: -- Initialize message list if p_init_msg_list is set to true
488: IF FND_API.to_Boolean(p_init_msg_list) THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:
492: -- Initialize API return status to success
493: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 512: FND_MSG_PUB.Add;

508:
509: if (c_rec.lock_flag = 1) then
510:
511: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_IFACE_ROW_LOCKED');
512: FND_MSG_PUB.Add;
513: x_errorcode := 200;
514: RAISE FND_API.G_EXC_ERROR;
515:
516: end if;

Line 520: FND_MSG_PUB.Add;

516: end if;
517:
518: if (c_rec.delete_flag = 1) then
519: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_IFACE_MARKED_DELETED');
520: FND_MSG_PUB.Add;
521: x_errorcode := 204;
522: RAISE FND_API.G_EXC_ERROR;
523: end if;
524:

Line 527: FND_MSG_PUB.Add;

523: end if;
524:
525: if (c_rec.status_flag in (0, 1)) then
526: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_IFACE_STATUS_DONE');
527: FND_MSG_PUB.Add;
528: x_errorcode := 206;
529: RAISE FND_API.G_EXC_ERROR;
530: end if;
531:

Line 534: FND_MSG_PUB.Add;

530: end if;
531:
532: if (nvl(c_rec.process_flag,1) = 2) then
533: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_IFACE_NOT_READY');
534: FND_MSG_PUB.Add;
535: x_errorcode := 207;
536: RAISE FND_API.G_EXC_ERROR;
537: end if;
538:

Line 669: FND_MSG_PUB.Add;

665: end if;
666:
667: else
668: FND_MESSAGE.Set_Name('INV', 'INV_CCEOI_INVALID_CEI_ID');
669: FND_MSG_PUB.Add;
670: x_errorcode := 205;
671: raise fnd_api.g_exc_error;
672: end if;
673: end if;

Line 686: FND_MSG_PUB.Count_And_Get

682: IF FND_API.to_Boolean(p_commit) THEN
683: COMMIT;
684: END IF;
685:
686: FND_MSG_PUB.Count_And_Get
687: (p_count => x_msg_count
688: , p_data => x_msg_data);
689:
690: EXCEPTION

Line 698: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

694:
695: --
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: --
698: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
699: , p_data => x_msg_data);
700: --
701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
702: --

Line 708: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

704: --
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_errorcode := -1;
707: --
708: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
709: , p_data => x_msg_data);
710: --
711: WHEN OTHERS THEN
712: --

Line 718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

714: --
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_errorcode := -1;
717: --
718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
720: END IF;
721: --
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_errorcode := -1;
717: --
718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
720: END IF;
721: --
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
723: , p_data => x_msg_data);

Line 722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
719: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
720: END IF;
721: --
722: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
723: , p_data => x_msg_data);
724: END;
725:
726:

Line 796: FND_MSG_PUB.initialize;

792: END IF;
793: --
794: -- Initialize message list if p_init_msg_list is set to true
795: IF FND_API.to_Boolean(p_init_msg_list) THEN
796: FND_MSG_PUB.initialize;
797: END IF;
798: --
799: -- Initialisize API return status to access
800: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 821: FND_MSG_PUB.ADD;

817: IF (l_debug = 1) THEN
818: mdebug('invalid cost group id or cost group name');
819: END IF;
820: FND_MESSAGE.SET_NAME('INV', 'INV_INT_CSTEXT');
821: FND_MSG_PUB.ADD;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END IF;
825:

Line 913: FND_MSG_PUB.Add;

909: -- set an error
910:
911:
912: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UNKNOWN_ACTION_CODE');
913: FND_MSG_PUB.Add;
914:
915: if (MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE) THEN
916:
917: -- this is a really dangerous call since

Line 1030: FND_MSG_PUB.Count_And_Get

1026: IF FND_API.to_Boolean(p_commit) THEN
1027: COMMIT;
1028: END IF;
1029: -- Standard call to get message count and if count is 1, get message info
1030: FND_MSG_PUB.Count_And_Get
1031: (p_count => x_msg_count
1032: , p_data => x_msg_data);
1033:
1034:

Line 1042: FND_MSG_PUB.Count_And_Get(

1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: IF (l_debug = 1) THEN
1040: mdebug('Exception: ' || sqlerrm);
1041: END IF;
1042: FND_MSG_PUB.Count_And_Get(
1043: p_count => x_msg_count
1044: , p_data => x_msg_data);
1045:
1046:

Line 1054: FND_MSG_PUB.Count_And_Get(

1050: x_errorcode := -1;
1051: IF (l_debug = 1) THEN
1052: mdebug('Unexp-Exception: ' || sqlerrm);
1053: END IF;
1054: FND_MSG_PUB.Count_And_Get(
1055: p_count => x_msg_count
1056: , p_data => x_msg_data);
1057:
1058:

Line 1067: IF FND_MSG_PUB.Check_Msg_Level(

1063: IF (l_debug = 1) THEN
1064: mdebug('Other-Exception: ' || sqlerrm);
1065: END IF;
1066:
1067: IF FND_MSG_PUB.Check_Msg_Level(
1068: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1070: END IF;
1071:

Line 1068: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1064: mdebug('Other-Exception: ' || sqlerrm);
1065: END IF;
1066:
1067: IF FND_MSG_PUB.Check_Msg_Level(
1068: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1070: END IF;
1071:
1072: FND_MSG_PUB.Count_And_Get(

Line 1069: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1065: END IF;
1066:
1067: IF FND_MSG_PUB.Check_Msg_Level(
1068: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1070: END IF;
1071:
1072: FND_MSG_PUB.Count_And_Get(
1073: p_count => x_msg_count

Line 1072: FND_MSG_PUB.Count_And_Get(

1068: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1070: END IF;
1071:
1072: FND_MSG_PUB.Count_And_Get(
1073: p_count => x_msg_count
1074: , p_data => x_msg_data);
1075: END;
1076:

Line 1141: FND_MSG_PUB.initialize;

1137: END IF;
1138:
1139: -- Initialize message list if p_init_msg_list is set to true
1140: IF FND_API.to_Boolean(p_init_msg_list) THEN
1141: FND_MSG_PUB.initialize;
1142: END IF;
1143: --
1144: -- Initialisize API return status to access
1145: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1191: FND_MSG_PUB.ADD;

1187: IF (l_debug = 1) THEN
1188: mdebug('invalid parent lpn id or parent lpn');
1189: END IF;
1190: FND_MESSAGE.SET_NAME('INV', 'INV_WMS_CONT_INVALID_LPN');
1191: FND_MSG_PUB.ADD;
1192: RAISE e_Invalid_Inputs;
1193: END IF;
1194: -- Assing validated values to l_item_rec.
1195: l_item_rec.parent_lpn_id := l_lpn.lpn_id;

Line 1216: FND_MSG_PUB.ADD;

1212: END IF;
1213: IF p_interface_rec.parent_lpn_id <> p_interface_rec.outermost_lpn_id THEN
1214: -- error out, this case not supported
1215: FND_MESSAGE.SET_NAME('INV', 'INV_WMS_CC_NESTED_LPN_DISCR');
1216: FND_MSG_PUB.ADD;
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSE
1219: -- set lpn discrepancy flag to 1 (yes)
1220: l_lpn_discrepancy := 1;

Line 1454: FND_MSG_PUB.ADD;

1450: IF (l_debug = 1) THEN
1451: mdebug('invalid parent lpn id or parent lpn');
1452: END IF;
1453: FND_MESSAGE.SET_NAME('INV', 'INV_WMS_CONT_INVALID_LPN');
1454: FND_MSG_PUB.ADD;
1455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1456: END IF;
1457:
1458: -- put new lpn in record

Line 1583: FND_MSG_PUB.Count_And_Get(

1579: x_return_status := FND_API.G_RET_STS_ERROR;
1580: IF (l_debug = 1) THEN
1581: mdebug('Exception: ' || sqlerrm);
1582: END IF;
1583: FND_MSG_PUB.Count_And_Get(
1584: p_count => x_msg_count
1585: , p_data => x_msg_data);
1586:
1587:

Line 1595: FND_MSG_PUB.Count_And_Get(

1591: x_errorcode := -1;
1592: IF (l_debug = 1) THEN
1593: mdebug('Unexp-Exception: ' || sqlerrm);
1594: END IF;
1595: FND_MSG_PUB.Count_And_Get(
1596: p_count => x_msg_count
1597: , p_data => x_msg_data);
1598:
1599: WHEN e_Invalid_Inputs THEN

Line 1602: FND_MSG_PUB.Count_And_Get

1598:
1599: WHEN e_Invalid_Inputs THEN
1600: ROLLBACK TO Process_LPN_CountRequest;
1601: x_return_status := FND_API.G_RET_STS_ERROR;
1602: FND_MSG_PUB.Count_And_Get
1603: ( p_count => x_msg_count,
1604: p_data => x_msg_data
1605: );
1606:

Line 1614: IF FND_MSG_PUB.Check_Msg_Level(

1610: IF (l_debug = 1) THEN
1611: mdebug('Other-Exception: ' || sqlerrm);
1612: END IF;
1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1617: END IF;
1618:

Line 1615: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1611: mdebug('Other-Exception: ' || sqlerrm);
1612: END IF;
1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1617: END IF;
1618:
1619: FND_MSG_PUB.Count_And_Get(

Line 1616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1612: END IF;
1613:
1614: IF FND_MSG_PUB.Check_Msg_Level(
1615: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1617: END IF;
1618:
1619: FND_MSG_PUB.Count_And_Get(
1620: p_count => x_msg_count

Line 1619: FND_MSG_PUB.Count_And_Get(

1615: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1617: END IF;
1618:
1619: FND_MSG_PUB.Count_And_Get(
1620: p_count => x_msg_count
1621: , p_data => x_msg_data);
1622: END Process_LPN_CountRequest;
1623: