DBA Data[Home] [Help]

APPS.OKS_MASS_UPD_PVT dependencies on FND_MSG_PUB

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

943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_price_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
946:
947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
949: END IF;
950:
951: end mass_update_price_prc;

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

944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_price_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
946:
947: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
949: END IF;
950:
951: end mass_update_price_prc;
952:

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

1527:
1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_status_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
1530:
1531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1532: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1533: END IF;
1534:
1535: END;

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

1528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1529: --fnd_file.put_line (fnd_file.log,'Unexpected error in mass_update_status_prc: '||x_return_status||' sqlerrm: '||sqlerrm);
1530:
1531: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1532: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1533: END IF;
1534:
1535: END;
1536:

Line 1997: FOR a in 1 .. fnd_msg_pub.count_msg Loop

1993:
1994:
1995: -- Bug 5227077 --
1996: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1997: FOR a in 1 .. fnd_msg_pub.count_msg Loop
1998: fnd_msg_pub.get(p_msg_index => a,
1999: p_encoded => 'F',
2000: p_data => l_msg_data,
2001: p_msg_index_out => l_msg_index);

Line 1998: fnd_msg_pub.get(p_msg_index => a,

1994:
1995: -- Bug 5227077 --
1996: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1997: FOR a in 1 .. fnd_msg_pub.count_msg Loop
1998: fnd_msg_pub.get(p_msg_index => a,
1999: p_encoded => 'F',
2000: p_data => l_msg_data,
2001: p_msg_index_out => l_msg_index);
2002: x_msg_tbl(l_tot_msg_count).status := l_return_status;

Line 2014: fnd_msg_pub.initialize;

2010: l_err_eff_idx := l_err_eff_idx +1;
2011: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2012: Else
2013: if L_FLAG <> true then
2014: fnd_msg_pub.initialize;
2015:
2016: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,
2017: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2018: p_token1 => 'Line No ',

Line 2021: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2017: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2018: p_token1 => 'Line No ',
2019: p_token1_value => l_line_number);
2020:
2021: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2022: p_encoded => fnd_api.g_false);
2023: x_msg_tbl(l_tot_msg_count).status := 'E';
2024: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2025: l_tot_msg_count := l_tot_msg_count + 1;

Line 2155: FOR a in 1 .. fnd_msg_pub.count_msg Loop

2151: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Bug 5227077 --
2154: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2155: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2156: fnd_msg_pub.get(p_msg_index => a,
2157: p_encoded => 'F',
2158: p_data => l_msg_data,
2159: p_msg_index_out => l_msg_index);

Line 2156: fnd_msg_pub.get(p_msg_index => a,

2152: END IF;
2153: -- Bug 5227077 --
2154: /* IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2155: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2156: fnd_msg_pub.get(p_msg_index => a,
2157: p_encoded => 'F',
2158: p_data => l_msg_data,
2159: p_msg_index_out => l_msg_index);
2160: x_msg_tbl(l_tot_msg_count).status := l_return_status;

Line 2172: fnd_msg_pub.initialize;

2168: l_err_eff_idx := l_err_eff_idx +1;
2169: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2170: Else
2171: if L_FLAG <> true then
2172: fnd_msg_pub.initialize;
2173:
2174: OKC_API.SET_MESSAGE(p_app_name => 'OKS', --G_APP_NAME_OKS,
2175: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2176: p_token1 => 'Line No ',

Line 2179: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,

2175: p_msg_name => 'OKS_BA_UPDATE_NOT_ALLOWED',
2176: p_token1 => 'Line No ',
2177: p_token1_value => l_line_number);
2178:
2179: l_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_first,
2180: p_encoded => fnd_api.g_false);
2181: x_msg_tbl(l_tot_msg_count).status := 'E';
2182: x_msg_tbl(l_tot_msg_count).description := l_msg_data;
2183: l_tot_msg_count := l_tot_msg_count + 1;

Line 2233: FOR a in 1 .. fnd_msg_pub.count_msg Loop

2229: Raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2230: END IF;
2231:
2232: /* IF (l_return_status <> 'S') THEN
2233: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2234: fnd_msg_pub.get(p_msg_index => a,
2235: p_encoded => 'F',
2236: p_data => l_msg_data,
2237: p_msg_index_out => l_msg_index);

Line 2234: fnd_msg_pub.get(p_msg_index => a,

2230: END IF;
2231:
2232: /* IF (l_return_status <> 'S') THEN
2233: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2234: fnd_msg_pub.get(p_msg_index => a,
2235: p_encoded => 'F',
2236: p_data => l_msg_data,
2237: p_msg_index_out => l_msg_index);
2238:

Line 2294: FOR a in 1 .. fnd_msg_pub.count_msg Loop

2290: END IF;
2291:
2292: /* If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2293:
2294: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2295: fnd_msg_pub.get(p_msg_index => a,
2296: p_encoded => 'F',
2297: p_data => l_msg_data,
2298: p_msg_index_out => l_msg_index);

Line 2295: fnd_msg_pub.get(p_msg_index => a,

2291:
2292: /* If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2293:
2294: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2295: fnd_msg_pub.get(p_msg_index => a,
2296: p_encoded => 'F',
2297: p_data => l_msg_data,
2298: p_msg_index_out => l_msg_index);
2299:

Line 2442: FOR a in 1 .. fnd_msg_pub.count_msg Loop

2438: END IF;
2439:
2440: /*if (L_RETURN_STATUS <> 'S') then
2441: l_tot_msg_count := 0;
2442: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2443: fnd_msg_pub.get(p_msg_index => a,
2444: p_encoded => 'F',
2445: p_data => l_msg_data,
2446: p_msg_index_out => l_msg_index);

Line 2443: fnd_msg_pub.get(p_msg_index => a,

2439:
2440: /*if (L_RETURN_STATUS <> 'S') then
2441: l_tot_msg_count := 0;
2442: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2443: fnd_msg_pub.get(p_msg_index => a,
2444: p_encoded => 'F',
2445: p_data => l_msg_data,
2446: p_msg_index_out => l_msg_index);
2447:

Line 2515: FOR a in 1 .. fnd_msg_pub.count_msg Loop

2511: END IF;
2512:
2513: /*If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2514:
2515: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2516: fnd_msg_pub.get(p_msg_index => a,
2517: p_encoded => 'F',
2518: p_data => l_msg_data,
2519: p_msg_index_out => l_msg_index);

Line 2516: fnd_msg_pub.get(p_msg_index => a,

2512:
2513: /*If (l_return_status <> OKC_API.G_RET_STS_SUCCESS) Then
2514:
2515: FOR a in 1 .. fnd_msg_pub.count_msg Loop
2516: fnd_msg_pub.get(p_msg_index => a,
2517: p_encoded => 'F',
2518: p_data => l_msg_data,
2519: p_msg_index_out => l_msg_index);
2520: