DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC dependencies on FND_MSG_PUB

Line 186: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

182:
183: EXCEPTION
184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
187:
188: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
189: THEN
190: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

203: END IF;
204: RAISE;
205:
206: WHEN OTHERS THEN
207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
208: THEN
209: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
210: , 'Others exception in '||l_api_name
211: );

Line 209: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

205:
206: WHEN OTHERS THEN
207: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
208: THEN
209: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
210: , 'Others exception in '||l_api_name
211: );
212: END IF;
213:

Line 575: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

571: EXCEPTION
572:
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
576:
577: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
578: THEN
579: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

592: END IF;
593: RAISE;
594:
595: WHEN OTHERS THEN
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
599: , 'Others exception in '||l_api_name
600: );

Line 598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

594:
595: WHEN OTHERS THEN
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
599: , 'Others exception in '||l_api_name
600: );
601: END IF;
602:

Line 702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

698: WHEN NO_DATA_FOUND THEN
699: RAISE;
700:
701: WHEN OTHERS THEN
702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
705: , 'Process_Transaction (OVERLOADED)'
706: );

Line 704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

700:
701: WHEN OTHERS THEN
702: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
705: , 'Process_Transaction (OVERLOADED)'
706: );
707: RAISE;
708: END IF;

Line 1050: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

1046:
1047: EXCEPTION
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1051:
1052: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1071: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1067: END IF;
1068: RAISE;
1069:
1070: WHEN OTHERS THEN
1071: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1074: , 'Others exception in '||l_api_name
1075: );

Line 1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1069:
1070: WHEN OTHERS THEN
1071: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1074: , 'Others exception in '||l_api_name
1075: );
1076: END IF;
1077:

Line 1632: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

1628:
1629: EXCEPTION
1630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1632: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
1633:
1634: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1635: THEN
1636: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 1653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1649: END IF;
1650: RAISE;
1651:
1652: WHEN OTHERS THEN
1653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1654: THEN
1655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1656: , 'Others exception in '||l_api_name
1657: );

Line 1655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

1651:
1652: WHEN OTHERS THEN
1653: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1654: THEN
1655: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
1656: , 'Others exception in '||l_api_name
1657: );
1658: END IF;
1659:

Line 2397: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

2393:
2394: EXCEPTION
2395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2397: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2398:
2399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2400: THEN
2401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 2418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2414: END IF;
2415: RAISE;
2416:
2417: WHEN OTHERS THEN
2418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2419: THEN
2420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2421: , 'Others exception in '||l_api_name
2422: );

Line 2420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

2416:
2417: WHEN OTHERS THEN
2418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2419: THEN
2420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2421: , 'Others exception in '||l_api_name
2422: );
2423: END IF;
2424:

Line 2866: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

2862: END IF;
2863: EXCEPTION
2864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
2867:
2868: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2869: THEN
2870: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 2887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2883: END IF;
2884: RAISE;
2885:
2886: WHEN OTHERS THEN
2887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2888: THEN
2889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2890: , 'Others exception in '||l_api_name
2891: );

Line 2889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

2885:
2886: WHEN OTHERS THEN
2887: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2888: THEN
2889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
2890: , 'Others exception in '||l_api_name
2891: );
2892: END IF;
2893:

Line 3402: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

3398:
3399: EXCEPTION
3400: WHEN OTHERS THEN
3401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3402: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
3403:
3404: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3405: THEN
3406: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 4297: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

4293:
4294: EXCEPTION
4295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4297: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4298:
4299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4300: THEN
4301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 4318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4314: END IF;
4315: RAISE;
4316:
4317: WHEN OTHERS THEN
4318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4319: THEN
4320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
4321: , 'Others exception in '||l_api_name
4322: );

Line 4320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

4316:
4317: WHEN OTHERS THEN
4318: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4319: THEN
4320: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
4321: , 'Others exception in '||l_api_name
4322: );
4323: END IF;
4324:

Line 4833: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

4829:
4830: EXCEPTION
4831: WHEN OTHERS THEN
4832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4833: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
4834:
4835: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4836: THEN
4837: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 5720: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

5716:
5717: EXCEPTION
5718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5720: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
5721:
5722: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5723: THEN
5724: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 5741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5737: END IF;
5738: RAISE;
5739:
5740: WHEN OTHERS THEN
5741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5742: THEN
5743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
5744: , 'Others exception in '||l_api_name
5745: );

Line 5743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

5739:
5740: WHEN OTHERS THEN
5741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5742: THEN
5743: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
5744: , 'Others exception in '||l_api_name
5745: );
5746: END IF;
5747:

Line 6074: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

6070:
6071: EXCEPTION
6072: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6074: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6075:
6076: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6077: THEN
6078: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 6095: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6091: END IF;
6092: RAISE;
6093:
6094: WHEN OTHERS THEN
6095: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6096: THEN
6097: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6098: , 'Others exception in '||l_api_name
6099: );

Line 6097: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

6093:
6094: WHEN OTHERS THEN
6095: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6096: THEN
6097: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6098: , 'Others exception in '||l_api_name
6099: );
6100: END IF;
6101:

Line 6446: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

6442:
6443: EXCEPTION
6444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6446: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6447:
6448: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6449: THEN
6450: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 6467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6463: END IF;
6464: RAISE;
6465:
6466: WHEN OTHERS THEN
6467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6468: THEN
6469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6470: , 'Others exception in '||l_api_name
6471: );

Line 6469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

6465:
6466: WHEN OTHERS THEN
6467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6468: THEN
6469: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6470: , 'Others exception in '||l_api_name
6471: );
6472: END IF;
6473:

Line 6845: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);

6841:
6842: EXCEPTION
6843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6845: l_error := SUBSTRB(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE),1,250);
6846:
6847: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
6848: THEN
6849: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

Line 6866: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

6862: END IF;
6863: RAISE;
6864:
6865: WHEN OTHERS THEN
6866: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6867: THEN
6868: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6869: , 'Others exception in '||l_api_name
6870: );

Line 6868: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME

6864:
6865: WHEN OTHERS THEN
6866: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6867: THEN
6868: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
6869: , 'Others exception in '||l_api_name
6870: );
6871: END IF;
6872: