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 1806: FND_MSG_PUB.initialize;

1802: END IF;
1803: --
1804: -- Initialize message list if p_init_msg_list is set to true
1805: IF FND_API.to_Boolean(p_init_msg_list) THEN
1806: FND_MSG_PUB.initialize;
1807: END IF;
1808: --
1809: -- Initialisize API return status to access
1810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2108: FND_MSG_PUB.Add;

2104: AND MTL_CCEOI_VAR_PVT.G_SYSTEM_QUANTITY = 0 THEN
2105: --
2106: x_errorcode := 17;
2107: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_ADJCALC_NO_SERIAL');
2108: FND_MSG_PUB.Add;
2109: RAISE FND_API.G_EXC_ERROR;
2110: --
2111: END IF;
2112: */

Line 2121: FND_MSG_PUB.Count_And_Get

2117: IF FND_API.to_Boolean(p_commit) THEN
2118: COMMIT;
2119: END IF;
2120: -- Standard call to get message count and if count is 1, get message info
2121: FND_MSG_PUB.Count_And_Get
2122: (p_count => x_msg_count
2123: , p_data => x_msg_data);
2124: EXCEPTION
2125: WHEN FND_API.G_EXC_ERROR THEN

Line 2131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2127: ROLLBACK TO Calculate_Adjustment;
2128: --
2129: x_return_status := FND_API.G_RET_STS_ERROR;
2130: --
2131: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2132: , p_data => x_msg_data);
2133: --
2134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2135: --

Line 2141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2137: --
2138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2139: --
2140: x_errorcode := -1;
2141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2142: , p_data => x_msg_data);
2143: --
2144: WHEN OTHERS THEN
2145: --

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

2147: --
2148: x_errorcode := -1;
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150: --
2151: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2153: END IF;
2154: --
2155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

2148: x_errorcode := -1;
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150: --
2151: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2153: END IF;
2154: --
2155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2156: , p_data => x_msg_data);

Line 2155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

2151: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2152: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2153: END IF;
2154: --
2155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
2156: , p_data => x_msg_data);
2157: END;
2158: END;
2159: --

Line 3371: FND_MSG_PUB.initialize;

3367: END IF;
3368: --
3369: -- Initialize message list if p_init_msg_list is set to true
3370: IF FND_API.to_Boolean(p_init_msg_list) THEN
3371: FND_MSG_PUB.initialize;
3372: END IF;
3373: --
3374: IF (l_debug = 1) THEN
3375: MDEBUG( 'SetCCExport : After Init');

Line 3410: FND_MSG_PUB.Add;

3406: IF (l_debug = 1) THEN
3407: MDEBUG( 'SetCCExport : Error Update');
3408: END IF;
3409: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_COULD_NOT_LOCK');
3410: FND_MSG_PUB.Add;
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413: --
3414: -- END of API body

Line 3421: FND_MSG_PUB.Count_And_Get

3417: COMMIT;
3418: END IF;
3419: -- --
3420: -- Standard call to get message count and if count is 1, get message info
3421: FND_MSG_PUB.Count_And_Get
3422: (p_count => x_msg_count
3423: , p_data => x_msg_data);
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR THEN

Line 3431: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3427: ROLLBACK TO Set_CCExport;
3428: --
3429: x_return_status := FND_API.G_RET_STS_ERROR;
3430: --
3431: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3432: , p_data => x_msg_data);
3433: --
3434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3435: --

Line 3440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3436: ROLLBACK TO Set_CCExport;
3437: --
3438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3439: --
3440: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3441: , p_data => x_msg_data);
3442: --
3443: WHEN OTHERS THEN
3444: --

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

3445: ROLLBACK TO Set_CCExport;
3446: --
3447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3448: --
3449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3451: END IF;
3452: --
3453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3446: --
3447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3448: --
3449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3451: END IF;
3452: --
3453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3454: , p_data => x_msg_data);

Line 3453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3449: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3450: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3451: END IF;
3452: --
3453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3454: , p_data => x_msg_data);
3455: END;
3456: END;
3457: --

Line 3540: FND_MSG_PUB.initialize;

3536:
3537: --
3538: -- Initialize message list if p_init_msg_list is set to true
3539: IF FND_API.to_Boolean(p_init_msg_list) THEN
3540: FND_MSG_PUB.initialize;
3541: END IF;
3542:
3543: --
3544: -- Initialisize API return status to access

Line 3578: FND_MSG_PUB.Add;

3574:
3575: --
3576: IF SQL%ROWCOUNT <> 1 THEN
3577: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_COULD_NOT_LOCK');
3578: FND_MSG_PUB.Add;
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581: --
3582: -- END of API body

Line 3589: FND_MSG_PUB.Count_And_Get

3585: COMMIT;
3586: END IF;
3587: -- --
3588: -- Standard call to get message count and if count is 1, get message info
3589: FND_MSG_PUB.Count_And_Get
3590: (p_count => x_msg_count
3591: , p_data => x_msg_data);
3592: EXCEPTION
3593: WHEN FND_API.G_EXC_ERROR THEN

Line 3602: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3598: ROLLBACK TO Set_CCEOIValid;
3599: --
3600: x_return_status := FND_API.G_RET_STS_ERROR;
3601: --
3602: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3603: , p_data => x_msg_data);
3604: --
3605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3606: --

Line 3614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3610: ROLLBACK TO Set_CCEOIValid;
3611: --
3612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3613: --
3614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3615: , p_data => x_msg_data);
3616: --
3617: WHEN OTHERS THEN
3618: --

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

3625: END IF;
3626: --
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: --
3629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3631: END IF;
3632: --
3633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3626: --
3627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3628: --
3629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3631: END IF;
3632: --
3633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3634: , p_data => x_msg_data);

Line 3633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3629: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3630: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3631: END IF;
3632: --
3633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3634: , p_data => x_msg_data);
3635: END;
3636: END;
3637: --

Line 3713: FND_MSG_PUB.initialize;

3709: END IF;
3710: --
3711: -- Initialize message list if p_init_msg_list is set to true
3712: IF FND_API.to_Boolean(p_init_msg_list) THEN
3713: FND_MSG_PUB.initialize;
3714: END IF;
3715: --
3716: -- Initialisize API return status to access
3717: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3783: FND_MSG_PUB.Count_And_Get

3779: IF FND_API.to_Boolean(p_commit) THEN
3780: COMMIT;
3781: END IF;
3782: -- Standard call to get message count and if count is 1, get message info
3783: FND_MSG_PUB.Count_And_Get
3784: (p_count => x_msg_count
3785: , p_data => x_msg_data);
3786: EXCEPTION
3787: WHEN FND_API.G_EXC_ERROR THEN

Line 3792: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3788: --
3789: --
3790: x_return_status := FND_API.G_RET_STS_ERROR;
3791: --
3792: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3793: , p_data => x_msg_data);
3794: --
3795: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3796: --

Line 3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3797: --
3798: x_errorcode := -1;
3799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3800: --
3801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3802: , p_data => x_msg_data);
3803: --
3804: WHEN OTHERS THEN
3805: --

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

3806: --
3807: x_errorcode := -1;
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3809: --
3810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3812: END IF;
3813: --
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3807: x_errorcode := -1;
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3809: --
3810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3812: END IF;
3813: --
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3815: , p_data => x_msg_data);

Line 3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3810: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3811: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3812: END IF;
3813: --
3814: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3815: , p_data => x_msg_data);
3816: END;
3817: END;
3818: --

Line 3899: FND_MSG_PUB.initialize;

3895: END IF;
3896: --
3897: -- Initialize message list if p_init_msg_list is set to true
3898: IF FND_API.to_Boolean(p_init_msg_list) THEN
3899: FND_MSG_PUB.initialize;
3900: END IF;
3901: --
3902: -- Initialisize API return status to access
3903: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3968: FND_MSG_PUB.Count_And_Get

3964: IF FND_API.to_Boolean(p_commit) THEN
3965: COMMIT;
3966: END IF;
3967: -- Standard call to get message count and if count is 1, get message info
3968: FND_MSG_PUB.Count_And_Get
3969: (p_count => x_msg_count
3970: , p_data => x_msg_data);
3971: EXCEPTION
3972: WHEN FND_API.G_EXC_ERROR THEN

Line 3977: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3973: --
3974: --
3975: x_return_status := FND_API.G_RET_STS_ERROR;
3976: --
3977: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3978: , p_data => x_msg_data);
3979: --
3980: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3981: --

Line 3986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3982: --
3983: x_errorcode := -1;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3985: --
3986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
3987: , p_data => x_msg_data);
3988: --
3989: WHEN OTHERS THEN
3990: --

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

3991: --
3992: x_errorcode := -1;
3993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3994: --
3995: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3996: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3997: END IF;
3998: --
3999: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

3992: x_errorcode := -1;
3993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3994: --
3995: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3996: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3997: END IF;
3998: --
3999: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4000: , p_data => x_msg_data);

Line 3999: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

3995: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3996: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3997: END IF;
3998: --
3999: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4000: , p_data => x_msg_data);
4001: END;
4002: END;
4003: --

Line 4142: FND_MSG_PUB.initialize;

4138: END IF;
4139: --
4140: -- Initialize message list if p_init_msg_list is set to true
4141: IF FND_API.to_Boolean(p_init_msg_list) THEN
4142: FND_MSG_PUB.initialize;
4143: END IF;
4144: --
4145: -- Initialisize API return status to access
4146: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4645: FND_MSG_PUB.Add;

4641: L_message_name := 'INV_CCEOI_SERIAL_NOT_ALLOWED';
4642: END IF;
4643: --
4644: FND_MESSAGE.SET_NAME('INV',L_message_name);
4645: FND_MSG_PUB.Add;
4646: -- Write INTO interface error TABLE
4647: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4648: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4649: , p_error_column_name => L_column_name

Line 4753: FND_MSG_PUB.Add;

4749: MDEBUG('Process: In Validate_ItemSKU Unsched not Allowed');
4750: END IF;
4751: x_errorcode := 48;
4752: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_NO_CCENTRY');
4753: FND_MSG_PUB.Add;
4754: -- Write INTO interface error TABLE
4755: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4756: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4757: , p_error_column_name => '*'

Line 4774: FND_MSG_PUB.Add;

4770: IF (l_debug = 1) THEN
4771: MDEBUG( 'Process: In Validate_ItemSKU call-4 ');
4772: END IF;
4773: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_MULT_REQUESTS');
4774: FND_MSG_PUB.Add;
4775: -- Write INTO interface error TABLE
4776: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
4777: p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID
4778: , p_error_column_name => '*'

Line 4797: FND_MSG_PUB.Count_And_Get

4793: IF (l_debug = 1) THEN
4794: MDEBUG( 'Process: In Validate_ItemSKU call-6 ');
4795: END IF;
4796: -- Standard call to get message count and if count is 1, get message info
4797: FND_MSG_PUB.Count_And_Get
4798: (p_count => x_msg_count
4799: , p_data => x_msg_data);
4800: IF (l_debug = 1) THEN
4801: MDEBUG( 'Process: In Validate_ItemSKU call-7 ');

Line 4811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4807: --
4808: IF (l_debug = 1) THEN
4809: MDEBUG( 'ItemSKU-Error');
4810: END IF;
4811: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4812: , p_data => x_msg_data);
4813: --
4814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4815: --

Line 4822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4818: IF (l_debug = 1) THEN
4819: MDEBUG( 'ItemSKU-Unexp Error');
4820: END IF;
4821: --
4822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4823: , p_data => x_msg_data);
4824: --
4825: WHEN OTHERS THEN
4826: --

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

4829: IF (l_debug = 1) THEN
4830: MDEBUG( 'ItemSKU-Others Error');
4831: END IF;
4832: --
4833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4835: END IF;
4836: --
4837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

4830: MDEBUG( 'ItemSKU-Others Error');
4831: END IF;
4832: --
4833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4835: END IF;
4836: --
4837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4838: , p_data => x_msg_data);

Line 4837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

4833: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4834: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4835: END IF;
4836: --
4837: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
4838: , p_data => x_msg_data);
4839: END;
4840: END;
4841: --

Line 4970: FND_MSG_PUB.initialize;

4966: END IF;
4967: --
4968: -- Initialize message list if p_init_msg_list is set to true
4969: IF FND_API.to_Boolean(p_init_msg_list) THEN
4970: FND_MSG_PUB.initialize;
4971: END IF;
4972: --
4973: -- Initialisize API return status to access
4974: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5244: FND_MSG_PUB.Count_And_Get

5240: IF FND_API.to_Boolean(p_commit) THEN
5241: COMMIT;
5242: END IF;
5243: -- Standard call to get message count and if count is 1, get message info
5244: FND_MSG_PUB.Count_And_Get
5245: (p_count => x_msg_count
5246: , p_data => x_msg_data);
5247: EXCEPTION
5248: WHEN FND_API.G_EXC_ERROR THEN

Line 5252: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5248: WHEN FND_API.G_EXC_ERROR THEN
5249: --
5250: x_return_status := FND_API.G_RET_STS_ERROR;
5251: --
5252: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5253: , p_data => x_msg_data);
5254: --
5255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5256: --

Line 5260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5256: --
5257: x_errorcode := -1;
5258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5259: --
5260: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5261: , p_data => x_msg_data);
5262: --
5263: WHEN OTHERS THEN
5264: --

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

5264: --
5265: x_errorcode := -1;
5266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5267: --
5268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5270: END IF;
5271: --
5272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

5265: x_errorcode := -1;
5266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5267: --
5268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5270: END IF;
5271: --
5272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5273: , p_data => x_msg_data);

Line 5272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5269: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5270: END IF;
5271: --
5272: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5273: , p_data => x_msg_data);
5274: END;
5275: END;
5276: --

Line 5361: FND_MSG_PUB.initialize;

5357: END IF;
5358: --
5359: -- Initialize message list if p_init_msg_list is set to true
5360: IF FND_API.to_Boolean(p_init_msg_list) THEN
5361: FND_MSG_PUB.initialize;
5362: END IF;
5363: --
5364: -- Initialisize API return status to access
5365: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5493: FND_MSG_PUB.Count_And_Get

5489: IF FND_API.to_Boolean(p_commit) THEN
5490: COMMIT;
5491: END IF;
5492: -- Standard call to get message count and if count is 1, get message info
5493: FND_MSG_PUB.Count_And_Get
5494: (p_count => x_msg_count
5495: , p_data => x_msg_data);
5496: EXCEPTION
5497: WHEN FND_API.G_EXC_ERROR THEN

Line 5501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5497: WHEN FND_API.G_EXC_ERROR THEN
5498: --
5499: x_return_status := FND_API.G_RET_STS_ERROR;
5500: --
5501: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5502: , p_data => x_msg_data);
5503: --
5504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5505: --

Line 5509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5505: --
5506: x_errorcode := -1;
5507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5508: --
5509: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5510: , p_data => x_msg_data);
5511: --
5512: WHEN OTHERS THEN
5513: --

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

5513: --
5514: x_errorcode := -1;
5515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5516: --
5517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5518: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5519: END IF;
5520: --
5521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

5514: x_errorcode := -1;
5515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5516: --
5517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5518: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5519: END IF;
5520: --
5521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5522: , p_data => x_msg_data);

Line 5521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

5517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5518: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
5519: END IF;
5520: --
5521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
5522: , p_data => x_msg_data);
5523: END;
5524: END;
5525: --

Line 5806: FND_MSG_PUB.initialize;

5802: END IF;
5803: --
5804: -- Initialize message list if p_init_msg_list is set to true
5805: IF FND_API.to_Boolean(p_init_msg_list) THEN
5806: FND_MSG_PUB.initialize;
5807: END IF;
5808: --
5809: -- Initialisize API return status to access
5810: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5935: FND_MSG_PUB.Add;

5931: END IF;
5932: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL_UNAVAILABLE');
5933: FND_MESSAGE.SET_TOKEN('FIRST-SERIAL',
5934: p_interface_rec.serial_number);
5935: FND_MSG_PUB.Add;
5936: --x_errorcode := -1;
5937: x_errorcode := 70;
5938: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5939: RAISE FND_API.G_EXC_ERROR;

Line 6001: FND_MSG_PUB.Count_And_Get

5997: IF FND_API.to_Boolean(p_commit) THEN
5998: COMMIT;
5999: END IF;
6000: -- Standard call to get message count and if count is 1, get message info
6001: FND_MSG_PUB.Count_And_Get
6002: (p_count => x_msg_count
6003: , p_data => x_msg_data);
6004: EXCEPTION
6005: WHEN FND_API.G_EXC_ERROR THEN

Line 6011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

6007: ROLLBACK TO Process_Data;
6008: --
6009: x_return_status := FND_API.G_RET_STS_ERROR;
6010: --
6011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
6012: , p_data => x_msg_data);
6013: --
6014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6015: --

Line 6021: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

6017: --
6018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6019: --
6020: x_errorcode := -1;
6021: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
6022: , p_data => x_msg_data);
6023: --
6024: WHEN OTHERS THEN
6025: --

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

6027: --
6028: x_errorcode := -1;
6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6030: --
6031: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6032: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6033: END IF;
6034: --
6035: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

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

6028: x_errorcode := -1;
6029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6030: --
6031: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6032: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6033: END IF;
6034: --
6035: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
6036: , p_data => x_msg_data);

Line 6035: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

6031: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6032: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
6033: END IF;
6034: --
6035: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
6036: , p_data => x_msg_data);
6037: END;
6038: END;
6039: --

Line 6476: fnd_msg_pub.add;

6472: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.APPROVAL_CONDITION := 1;
6473: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.ENTRY_STATUS_CODE := 2;
6474: fnd_message.set_name('INV', 'INV_CC_SERIAL_MULTI_TRANSACT2');
6475: fnd_message.set_token('SERIAL', v_serial_number);
6476: fnd_msg_pub.add;
6477:
6478: L_ret_value := TRUE;
6479: else
6480: IF (l_debug = 1) THEN

Line 6484: fnd_msg_pub.add;

6480: IF (l_debug = 1) THEN
6481: MDEBUG( 'Process- within check-serial-1-INV_CC_SERIAL_DISCREPANCY' );
6482: END IF;
6483: fnd_message.set_name('INV', 'INV_CC_SERIAL_DISCREPANCY');
6484: fnd_msg_pub.add;
6485:
6486: L_ret_value := FALSE;
6487: end if;
6488: elsif x_return_status <> 'S' then

Line 6493: fnd_msg_pub.add;

6489: IF (l_debug = 1) THEN
6490: MDEBUG( 'Process- within check-serial-2-INV_CC_SERIAL_DISCREPANCY' );
6491: END IF;
6492: fnd_message.set_name('INV', 'INV_CC_SERIAL_DISCREPANCY');
6493: fnd_msg_pub.add;
6494: L_ret_value := FALSE;
6495: end if;
6496: end if;
6497: return (L_ret_value);

Line 6593: fnd_msg_pub.initialize;

6589: END IF;
6590:
6591: -- Initialize message list if p_init_msg_list is set to true
6592: IF fnd_api.to_boolean (p_init_msg_list) THEN
6593: fnd_msg_pub.initialize;
6594: END IF;
6595:
6596: -- Initialisize API return status to success
6597: x_return_status := fnd_api.g_ret_sts_success;

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

6724: COMMIT;
6725: END IF;
6726:
6727: -- Standard call to get message count and if count is 1, get message info
6728: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6729: EXCEPTION
6730: WHEN fnd_api.g_exc_error THEN
6731: ROLLBACK TO validate_secondarycountuom;
6732: x_return_status := fnd_api.g_ret_sts_error;

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

6729: EXCEPTION
6730: WHEN fnd_api.g_exc_error THEN
6731: ROLLBACK TO validate_secondarycountuom;
6732: x_return_status := fnd_api.g_ret_sts_error;
6733: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6734: WHEN fnd_api.g_exc_unexpected_error THEN
6735: ROLLBACK TO validate_secondarycountuom;
6736: x_return_status := fnd_api.g_ret_sts_unexp_error;
6737: x_errorcode := -1;

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

6734: WHEN fnd_api.g_exc_unexpected_error THEN
6735: ROLLBACK TO validate_secondarycountuom;
6736: x_return_status := fnd_api.g_ret_sts_unexp_error;
6737: x_errorcode := -1;
6738: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6739: WHEN OTHERS THEN
6740: ROLLBACK TO validate_secondarycountuom;
6741: x_errorcode := -1;
6742: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

6740: ROLLBACK TO validate_secondarycountuom;
6741: x_errorcode := -1;
6742: x_return_status := fnd_api.g_ret_sts_unexp_error;
6743:
6744: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6745: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6746: END IF;
6747:
6748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

6741: x_errorcode := -1;
6742: x_return_status := fnd_api.g_ret_sts_unexp_error;
6743:
6744: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6745: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6746: END IF;
6747:
6748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6749: END validate_secondaryuomqty;

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

6744: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
6745: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
6746: END IF;
6747:
6748: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
6749: END validate_secondaryuomqty;
6750: -- END INVCONV
6751:
6752: END MTL_CCEOI_PROCESS_PVT;