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

Line 1709: FND_MSG_PUB.initialize;

1705: END IF;
1706: --
1707: -- Initialize message list if p_init_msg_list is set to true
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711: --
1712: -- Initialisize API return status to access
1713: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1990: FND_MSG_PUB.Add;

1986: AND MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY = 0 THEN
1987: --
1988: x_errorcode := 17;
1989: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_ADJCALC_NO_SERIAL');
1990: FND_MSG_PUB.Add;
1991: RAISE FND_API.G_EXC_ERROR;
1992: --
1993: END IF;
1994: */

Line 2003: FND_MSG_PUB.Count_And_Get

1999: IF FND_API.to_Boolean(p_commit) THEN
2000: COMMIT;
2001: END IF;
2002: -- Standard call to get message count and if count is 1, get message info
2003: FND_MSG_PUB.Count_And_Get
2004: (p_count => x_msg_count
2005: , p_data => x_msg_data);
2006: EXCEPTION
2007: WHEN FND_API.G_EXC_ERROR THEN

Line 2013: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2009: ROLLBACK TO Calculate_Adjustment;
2010: --
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012: --
2013: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2014: , p_data => x_msg_data);
2015: --
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: --

Line 2023: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2019: --
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: --
2022: x_errorcode := -1;
2023: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2024: , p_data => x_msg_data);
2025: --
2026: WHEN OTHERS THEN
2027: --

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

2029: --
2030: x_errorcode := -1;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: --
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2034: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2035: END IF;
2036: --
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

2030: x_errorcode := -1;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: --
2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2034: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2035: END IF;
2036: --
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2038: , p_data => x_msg_data);

Line 2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2033: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2034: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2035: END IF;
2036: --
2037: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2038: , p_data => x_msg_data);
2039: END;
2040: END;
2041: --

Line 3233: FND_MSG_PUB.initialize;

3229: END IF;
3230: --
3231: -- Initialize message list if p_init_msg_list is set to true
3232: IF FND_API.to_Boolean(p_init_msg_list) THEN
3233: FND_MSG_PUB.initialize;
3234: END IF;
3235: --
3236: IF (l_debug = 1) THEN
3237: MDEBUG( 'SetCCExport : After Init');

Line 3269: FND_MSG_PUB.Add;

3265: IF (l_debug = 1) THEN
3266: MDEBUG( 'SetCCExport : Error Update');
3267: END IF;
3268: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_COULD_NOT_LOCK');
3269: FND_MSG_PUB.Add;
3270: RAISE FND_API.G_EXC_ERROR;
3271: END IF;
3272: --
3273: -- END of API body

Line 3280: FND_MSG_PUB.Count_And_Get

3276: COMMIT;
3277: END IF;
3278: -- --
3279: -- Standard call to get message count and if count is 1, get message info
3280: FND_MSG_PUB.Count_And_Get
3281: (p_count => x_msg_count
3282: , p_data => x_msg_data);
3283: EXCEPTION
3284: WHEN FND_API.G_EXC_ERROR THEN

Line 3290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3286: ROLLBACK TO Set_CCExport;
3287: --
3288: x_return_status := FND_API.G_RET_STS_ERROR;
3289: --
3290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3291: , p_data => x_msg_data);
3292: --
3293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3294: --

Line 3299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3295: ROLLBACK TO Set_CCExport;
3296: --
3297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3298: --
3299: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3300: , p_data => x_msg_data);
3301: --
3302: WHEN OTHERS THEN
3303: --

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

3304: ROLLBACK TO Set_CCExport;
3305: --
3306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3307: --
3308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3310: END IF;
3311: --
3312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3305: --
3306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3307: --
3308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3310: END IF;
3311: --
3312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3313: , p_data => x_msg_data);

Line 3312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3309: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3310: END IF;
3311: --
3312: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3313: , p_data => x_msg_data);
3314: END;
3315: END;
3316: --

Line 3399: FND_MSG_PUB.initialize;

3395:
3396: --
3397: -- Initialize message list if p_init_msg_list is set to true
3398: IF FND_API.to_Boolean(p_init_msg_list) THEN
3399: FND_MSG_PUB.initialize;
3400: END IF;
3401:
3402: --
3403: -- Initialisize API return status to access

Line 3437: FND_MSG_PUB.Add;

3433:
3434: --
3435: IF SQL%ROWCOUNT <> 1 THEN
3436: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_COULD_NOT_LOCK');
3437: FND_MSG_PUB.Add;
3438: RAISE FND_API.G_EXC_ERROR;
3439: END IF;
3440: --
3441: -- END of API body

Line 3448: FND_MSG_PUB.Count_And_Get

3444: COMMIT;
3445: END IF;
3446: -- --
3447: -- Standard call to get message count and if count is 1, get message info
3448: FND_MSG_PUB.Count_And_Get
3449: (p_count => x_msg_count
3450: , p_data => x_msg_data);
3451: EXCEPTION
3452: WHEN FND_API.G_EXC_ERROR THEN

Line 3461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3457: ROLLBACK TO Set_CCEOIValid;
3458: --
3459: x_return_status := FND_API.G_RET_STS_ERROR;
3460: --
3461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3462: , p_data => x_msg_data);
3463: --
3464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3465: --

Line 3473: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3469: ROLLBACK TO Set_CCEOIValid;
3470: --
3471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3472: --
3473: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3474: , p_data => x_msg_data);
3475: --
3476: WHEN OTHERS THEN
3477: --

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

3484: END IF;
3485: --
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3487: --
3488: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3490: END IF;
3491: --
3492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3485: --
3486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3487: --
3488: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3490: END IF;
3491: --
3492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3493: , p_data => x_msg_data);

Line 3492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3488: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3489: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3490: END IF;
3491: --
3492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3493: , p_data => x_msg_data);
3494: END;
3495: END;
3496: --

Line 3572: FND_MSG_PUB.initialize;

3568: END IF;
3569: --
3570: -- Initialize message list if p_init_msg_list is set to true
3571: IF FND_API.to_Boolean(p_init_msg_list) THEN
3572: FND_MSG_PUB.initialize;
3573: END IF;
3574: --
3575: -- Initialisize API return status to access
3576: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3642: FND_MSG_PUB.Count_And_Get

3638: IF FND_API.to_Boolean(p_commit) THEN
3639: COMMIT;
3640: END IF;
3641: -- Standard call to get message count and if count is 1, get message info
3642: FND_MSG_PUB.Count_And_Get
3643: (p_count => x_msg_count
3644: , p_data => x_msg_data);
3645: EXCEPTION
3646: WHEN FND_API.G_EXC_ERROR THEN

Line 3651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3647: --
3648: --
3649: x_return_status := FND_API.G_RET_STS_ERROR;
3650: --
3651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3652: , p_data => x_msg_data);
3653: --
3654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3655: --

Line 3660: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3656: --
3657: x_errorcode := -1;
3658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3659: --
3660: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3661: , p_data => x_msg_data);
3662: --
3663: WHEN OTHERS THEN
3664: --

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

3665: --
3666: x_errorcode := -1;
3667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3668: --
3669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3670: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3671: END IF;
3672: --
3673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3666: x_errorcode := -1;
3667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3668: --
3669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3670: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3671: END IF;
3672: --
3673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3674: , p_data => x_msg_data);

Line 3673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3670: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3671: END IF;
3672: --
3673: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3674: , p_data => x_msg_data);
3675: END;
3676: END;
3677: --

Line 3758: FND_MSG_PUB.initialize;

3754: END IF;
3755: --
3756: -- Initialize message list if p_init_msg_list is set to true
3757: IF FND_API.to_Boolean(p_init_msg_list) THEN
3758: FND_MSG_PUB.initialize;
3759: END IF;
3760: --
3761: -- Initialisize API return status to access
3762: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3827: FND_MSG_PUB.Count_And_Get

3823: IF FND_API.to_Boolean(p_commit) THEN
3824: COMMIT;
3825: END IF;
3826: -- Standard call to get message count and if count is 1, get message info
3827: FND_MSG_PUB.Count_And_Get
3828: (p_count => x_msg_count
3829: , p_data => x_msg_data);
3830: EXCEPTION
3831: WHEN FND_API.G_EXC_ERROR THEN

Line 3836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3832: --
3833: --
3834: x_return_status := FND_API.G_RET_STS_ERROR;
3835: --
3836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3837: , p_data => x_msg_data);
3838: --
3839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3840: --

Line 3845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3841: --
3842: x_errorcode := -1;
3843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3844: --
3845: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3846: , p_data => x_msg_data);
3847: --
3848: WHEN OTHERS THEN
3849: --

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

3850: --
3851: x_errorcode := -1;
3852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3855: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3856: END IF;
3857: --
3858: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3851: x_errorcode := -1;
3852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3855: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3856: END IF;
3857: --
3858: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3859: , p_data => x_msg_data);

Line 3858: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3854: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3855: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3856: END IF;
3857: --
3858: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3859: , p_data => x_msg_data);
3860: END;
3861: END;
3862: --

Line 4000: FND_MSG_PUB.initialize;

3996: END IF;
3997: --
3998: -- Initialize message list if p_init_msg_list is set to true
3999: IF FND_API.to_Boolean(p_init_msg_list) THEN
4000: FND_MSG_PUB.initialize;
4001: END IF;
4002: --
4003: -- Initialisize API return status to access
4004: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4502: FND_MSG_PUB.Add;

4498: L_message_name := 'INV_CCEOI_SERIAL_NOT_ALLOWED';
4499: END IF;
4500: --
4501: FND_MESSAGE.SET_NAME('INV',L_message_name);
4502: FND_MSG_PUB.Add;
4503: -- Write INTO interface error TABLE
4504: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4505: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4506: , p_error_column_name => L_column_name

Line 4582: FND_MSG_PUB.Add;

4578: MDEBUG('Process: In Validate_ItemSKU Unsched not Allowed');
4579: END IF;
4580: x_errorcode := 48;
4581: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_CCENTRY');
4582: FND_MSG_PUB.Add;
4583: -- Write INTO interface error TABLE
4584: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4585: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4586: , p_error_column_name => '*'

Line 4603: FND_MSG_PUB.Add;

4599: IF (l_debug = 1) THEN
4600: MDEBUG( 'Process: In Validate_ItemSKU call-4 ');
4601: END IF;
4602: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_MULT_REQUESTS');
4603: FND_MSG_PUB.Add;
4604: -- Write INTO interface error TABLE
4605: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4606: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4607: , p_error_column_name => '*'

Line 4626: FND_MSG_PUB.Count_And_Get

4622: IF (l_debug = 1) THEN
4623: MDEBUG( 'Process: In Validate_ItemSKU call-6 ');
4624: END IF;
4625: -- Standard call to get message count and if count is 1, get message info
4626: FND_MSG_PUB.Count_And_Get
4627: (p_count => x_msg_count
4628: , p_data => x_msg_data);
4629: IF (l_debug = 1) THEN
4630: MDEBUG( 'Process: In Validate_ItemSKU call-7 ');

Line 4640: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4636: --
4637: IF (l_debug = 1) THEN
4638: MDEBUG( 'ItemSKU-Error');
4639: END IF;
4640: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4641: , p_data => x_msg_data);
4642: --
4643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4644: --

Line 4651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4647: IF (l_debug = 1) THEN
4648: MDEBUG( 'ItemSKU-Unexp Error');
4649: END IF;
4650: --
4651: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4652: , p_data => x_msg_data);
4653: --
4654: WHEN OTHERS THEN
4655: --

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

4658: IF (l_debug = 1) THEN
4659: MDEBUG( 'ItemSKU-Others Error');
4660: END IF;
4661: --
4662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4664: END IF;
4665: --
4666: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

4659: MDEBUG( 'ItemSKU-Others Error');
4660: END IF;
4661: --
4662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4664: END IF;
4665: --
4666: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4667: , p_data => x_msg_data);

Line 4666: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4662: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4663: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4664: END IF;
4665: --
4666: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4667: , p_data => x_msg_data);
4668: END;
4669: END;
4670: --

Line 4799: FND_MSG_PUB.initialize;

4795: END IF;
4796: --
4797: -- Initialize message list if p_init_msg_list is set to true
4798: IF FND_API.to_Boolean(p_init_msg_list) THEN
4799: FND_MSG_PUB.initialize;
4800: END IF;
4801: --
4802: -- Initialisize API return status to access
4803: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5073: FND_MSG_PUB.Count_And_Get

5069: IF FND_API.to_Boolean(p_commit) THEN
5070: COMMIT;
5071: END IF;
5072: -- Standard call to get message count and if count is 1, get message info
5073: FND_MSG_PUB.Count_And_Get
5074: (p_count => x_msg_count
5075: , p_data => x_msg_data);
5076: EXCEPTION
5077: WHEN FND_API.G_EXC_ERROR THEN

Line 5081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5077: WHEN FND_API.G_EXC_ERROR THEN
5078: --
5079: x_return_status := FND_API.G_RET_STS_ERROR;
5080: --
5081: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5082: , p_data => x_msg_data);
5083: --
5084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5085: --

Line 5089: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5085: --
5086: x_errorcode := -1;
5087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5088: --
5089: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5090: , p_data => x_msg_data);
5091: --
5092: WHEN OTHERS THEN
5093: --

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

5093: --
5094: x_errorcode := -1;
5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5096: --
5097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5098: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5099: END IF;
5100: --
5101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

5094: x_errorcode := -1;
5095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5096: --
5097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5098: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5099: END IF;
5100: --
5101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5102: , p_data => x_msg_data);

Line 5101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5098: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5099: END IF;
5100: --
5101: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5102: , p_data => x_msg_data);
5103: END;
5104: END;
5105: --

Line 5189: FND_MSG_PUB.initialize;

5185: END IF;
5186: --
5187: -- Initialize message list if p_init_msg_list is set to true
5188: IF FND_API.to_Boolean(p_init_msg_list) THEN
5189: FND_MSG_PUB.initialize;
5190: END IF;
5191: --
5192: -- Initialisize API return status to access
5193: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5318: FND_MSG_PUB.Count_And_Get

5314: IF FND_API.to_Boolean(p_commit) THEN
5315: COMMIT;
5316: END IF;
5317: -- Standard call to get message count and if count is 1, get message info
5318: FND_MSG_PUB.Count_And_Get
5319: (p_count => x_msg_count
5320: , p_data => x_msg_data);
5321: EXCEPTION
5322: WHEN FND_API.G_EXC_ERROR THEN

Line 5326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5322: WHEN FND_API.G_EXC_ERROR THEN
5323: --
5324: x_return_status := FND_API.G_RET_STS_ERROR;
5325: --
5326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5327: , p_data => x_msg_data);
5328: --
5329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5330: --

Line 5334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5330: --
5331: x_errorcode := -1;
5332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5333: --
5334: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5335: , p_data => x_msg_data);
5336: --
5337: WHEN OTHERS THEN
5338: --

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

5338: --
5339: x_errorcode := -1;
5340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5341: --
5342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5344: END IF;
5345: --
5346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

5339: x_errorcode := -1;
5340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5341: --
5342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5344: END IF;
5345: --
5346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5347: , p_data => x_msg_data);

Line 5346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5342: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5344: END IF;
5345: --
5346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5347: , p_data => x_msg_data);
5348: END;
5349: END;
5350: --

Line 5631: FND_MSG_PUB.initialize;

5627: END IF;
5628: --
5629: -- Initialize message list if p_init_msg_list is set to true
5630: IF FND_API.to_Boolean(p_init_msg_list) THEN
5631: FND_MSG_PUB.initialize;
5632: END IF;
5633: --
5634: -- Initialisize API return status to access
5635: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5760: FND_MSG_PUB.Add;

5756: END IF;
5757: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL_UNAVAILABLE');
5758: FND_MESSAGE.SET_TOKEN('FIRST-SERIAL',
5759: p_interface_rec.serial_number);
5760: FND_MSG_PUB.Add;
5761: --x_errorcode := -1;
5762: x_errorcode := 70;
5763: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5764: RAISE FND_API.G_EXC_ERROR;

Line 5826: FND_MSG_PUB.Count_And_Get

5822: IF FND_API.to_Boolean(p_commit) THEN
5823: COMMIT;
5824: END IF;
5825: -- Standard call to get message count and if count is 1, get message info
5826: FND_MSG_PUB.Count_And_Get
5827: (p_count => x_msg_count
5828: , p_data => x_msg_data);
5829: EXCEPTION
5830: WHEN FND_API.G_EXC_ERROR THEN

Line 5836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5832: ROLLBACK TO Process_Data;
5833: --
5834: x_return_status := FND_API.G_RET_STS_ERROR;
5835: --
5836: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5837: , p_data => x_msg_data);
5838: --
5839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5840: --

Line 5846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5842: --
5843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5844: --
5845: x_errorcode := -1;
5846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5847: , p_data => x_msg_data);
5848: --
5849: WHEN OTHERS THEN
5850: --

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

5852: --
5853: x_errorcode := -1;
5854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5855: --
5856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5857: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5858: END IF;
5859: --
5860: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

5853: x_errorcode := -1;
5854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5855: --
5856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5857: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5858: END IF;
5859: --
5860: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5861: , p_data => x_msg_data);

Line 5860: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5856: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5857: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5858: END IF;
5859: --
5860: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5861: , p_data => x_msg_data);
5862: END;
5863: END;
5864: --

Line 6301: fnd_msg_pub.add;

6297: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.APPROVAL_CONDITION := 1;
6298: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE := 2;
6299: fnd_message.set_name('INV', 'INV_CC_SERIAL_MULTI_TRANSACT2');
6300: fnd_message.set_token('SERIAL', v_serial_number);
6301: fnd_msg_pub.add;
6302:
6303: L_ret_value := TRUE;
6304: else
6305: IF (l_debug = 1) THEN

Line 6309: fnd_msg_pub.add;

6305: IF (l_debug = 1) THEN
6306: MDEBUG( 'Process- within check-serial-1-INV_CC_SERIAL_DISCREPANCY' );
6307: END IF;
6308: fnd_message.set_name('INV', 'INV_CC_SERIAL_DISCREPANCY');
6309: fnd_msg_pub.add;
6310:
6311: L_ret_value := FALSE;
6312: end if;
6313: elsif x_return_status <> 'S' then

Line 6318: fnd_msg_pub.add;

6314: IF (l_debug = 1) THEN
6315: MDEBUG( 'Process- within check-serial-2-INV_CC_SERIAL_DISCREPANCY' );
6316: END IF;
6317: fnd_message.set_name('INV', 'INV_CC_SERIAL_DISCREPANCY');
6318: fnd_msg_pub.add;
6319: L_ret_value := FALSE;
6320: end if;
6321: end if;
6322: return (L_ret_value);

Line 6418: fnd_msg_pub.initialize;

6414: END IF;
6415:
6416: -- Initialize message list if p_init_msg_list is set to true
6417: IF fnd_api.to_boolean (p_init_msg_list) THEN
6418: fnd_msg_pub.initialize;
6419: END IF;
6420:
6421: -- Initialisize API return status to success
6422: x_return_status := fnd_api.g_ret_sts_success;

Line 6553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

6549: COMMIT;
6550: END IF;
6551:
6552: -- Standard call to get message count and if count is 1, get message info
6553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6554: EXCEPTION
6555: WHEN fnd_api.g_exc_error THEN
6556: ROLLBACK TO validate_secondarycountuom;
6557: x_return_status := fnd_api.g_ret_sts_error;

Line 6558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

6554: EXCEPTION
6555: WHEN fnd_api.g_exc_error THEN
6556: ROLLBACK TO validate_secondarycountuom;
6557: x_return_status := fnd_api.g_ret_sts_error;
6558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6559: WHEN fnd_api.g_exc_unexpected_error THEN
6560: ROLLBACK TO validate_secondarycountuom;
6561: x_return_status := fnd_api.g_ret_sts_unexp_error;
6562: x_errorcode := -1;

Line 6563: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

6559: WHEN fnd_api.g_exc_unexpected_error THEN
6560: ROLLBACK TO validate_secondarycountuom;
6561: x_return_status := fnd_api.g_ret_sts_unexp_error;
6562: x_errorcode := -1;
6563: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6564: WHEN OTHERS THEN
6565: ROLLBACK TO validate_secondarycountuom;
6566: x_errorcode := -1;
6567: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 6569: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

6565: ROLLBACK TO validate_secondarycountuom;
6566: x_errorcode := -1;
6567: x_return_status := fnd_api.g_ret_sts_unexp_error;
6568:
6569: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6570: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6571: END IF;
6572:
6573: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

6566: x_errorcode := -1;
6567: x_return_status := fnd_api.g_ret_sts_unexp_error;
6568:
6569: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6570: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6571: END IF;
6572:
6573: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6574: END validate_secondaryuomqty;

Line 6573: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

6569: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6570: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6571: END IF;
6572:
6573: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6574: END validate_secondaryuomqty;
6575: -- END INVCONV
6576:
6577: END MTL_CCEOI_PROCESS_PVT;