DBA Data[Home] [Help]

APPS.IGC_CC_REVALUE_PROCESS_PKG dependencies on FND_MSG_PUB

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

1493: WHEN FND_API.G_EXC_ERROR THEN
1494: RETURN;
1495:
1496: WHEN OTHERS THEN
1497: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1498: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1499: END IF;
1500: RETURN;
1501:

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

1494: RETURN;
1495:
1496: WHEN OTHERS THEN
1497: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
1498: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1499: END IF;
1500: RETURN;
1501:
1502: END Output_Debug;

Line 2148: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2144: -- the user if any are present.
2145: -- ------------------------------------------------------------------------------------
2146: IF (l_budg_status = FALSE )
2147: THEN
2148: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2149: p_data => l_msg_data );
2150:
2151: IF (l_msg_count > 0)
2152: THEN

Line 2156: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

2152: THEN
2153: l_error_text := '';
2154: FOR l_cur IN 1..l_msg_count
2155: LOOP
2156: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2157: -- fnd_file.put_line (FND_FILE.LOG,
2158: -- l_error_text);
2159: -- bug 3199488 start block
2160: IF (l_state_level >= l_debug_level) THEN

Line 2269: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

2265: -- ------------------------------------------------------------------------------------
2266: -- Ensure that any exceptions raised are output into the log file to be reported to
2267: -- the user if any are present.
2268: -- ------------------------------------------------------------------------------------
2269: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
2270: p_data => l_msg_data );
2271:
2272: IF (l_msg_count > 0) THEN
2273: l_error_text := '';

Line 2275: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

2271:
2272: IF (l_msg_count > 0) THEN
2273: l_error_text := '';
2274: FOR l_cur IN 1..l_msg_count LOOP
2275: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
2276: -- fnd_file.put_line (FND_FILE.LOG,
2277: -- l_error_text);
2278: -- bug 3199488 start block
2279: IF (l_state_level >= l_debug_level) THEN

Line 4955: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

4951: -- ------------------------------------------------------------------------------------
4952: -- Ensure that any exceptions raised are output into the log file to be reported to
4953: -- the user if any are present.
4954: -- ------------------------------------------------------------------------------------
4955: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
4956: p_data => l_msg_data );
4957:
4958: IF (l_msg_count > 0) THEN
4959: l_error_text := '';

Line 4961: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

4957:
4958: IF (l_msg_count > 0) THEN
4959: l_error_text := '';
4960: FOR l_cur IN 1..l_msg_count LOOP
4961: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
4962: -- fnd_file.put_line (FND_FILE.LOG,
4963: -- l_error_text);
4964: -- bug 3199488 start block
4965: IF (l_state_level >= l_debug_level) THEN

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

4973: EXCEPTION
4974:
4975: WHEN insert_data
4976: THEN
4977: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4978: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
4979: END IF;
4980: -- bug 3199488 start block
4981: IF (l_unexp_level >= l_debug_level) THEN

Line 4978: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');

4974:
4975: WHEN insert_data
4976: THEN
4977: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
4978: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
4979: END IF;
4980: -- bug 3199488 start block
4981: IF (l_unexp_level >= l_debug_level) THEN
4982: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp1',TRUE);

Line 4985: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

4981: IF (l_unexp_level >= l_debug_level) THEN
4982: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp1',TRUE);
4983: END IF;
4984: -- bug 3199488, end block
4985: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
4986: p_data => l_msg_data );
4987:
4988: IF (l_msg_count > 0) THEN
4989:

Line 4992: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

4988: IF (l_msg_count > 0) THEN
4989:
4990: l_error_text := '';
4991: FOR l_cur IN 1..l_msg_count LOOP
4992: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
4993: -- fnd_file.put_line (FND_FILE.LOG,
4994: -- l_error_text);
4995: -- bug 3199488 start block
4996: IF (l_state_level >= l_debug_level) THEN

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

5012: END IF;
5013: ROLLBACK TO REVALUE3;
5014:
5015: WHEN OTHERS THEN
5016: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5017: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
5018: END IF;
5019: -- bug 3199488, start block
5020: IF (l_unexp_level >= l_debug_level) THEN

Line 5017: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');

5013: ROLLBACK TO REVALUE3;
5014:
5015: WHEN OTHERS THEN
5016: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
5017: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'revalue_main');
5018: END IF;
5019: -- bug 3199488, start block
5020: IF (l_unexp_level >= l_debug_level) THEN
5021: FND_MESSAGE.SET_NAME('IGC','IGC_LOGGING_UNEXP_ERROR');

Line 5027: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,

5023: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
5024: FND_LOG.MESSAGE(l_unexp_level, 'igc.plsql.igc_cc_revalue_process_pkg.revalue_main.Unexp2',TRUE);
5025: END IF;
5026: -- bug 3199488, end block
5027: FND_MSG_PUB.Count_And_Get ( p_count => l_msg_count,
5028: p_data => l_msg_data );
5029:
5030: IF (l_msg_count > 0) THEN
5031:

Line 5034: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);

5030: IF (l_msg_count > 0) THEN
5031:
5032: l_error_text := '';
5033: FOR l_cur IN 1..l_msg_count LOOP
5034: l_error_text := ' Mesg No : '|| l_cur ||' '|| FND_MSG_PUB.GET(l_cur, FND_API.G_FALSE);
5035: -- fnd_file.put_line (FND_FILE.LOG,
5036: -- l_error_text);
5037: -- bug 3199488 start block
5038: IF (l_state_level >= l_debug_level) THEN