DBA Data[Home] [Help]

APPS.OKC_OC_INT_KTQ_PVT dependencies on FND_MSG_PUB

Line 762: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

758: x_msg_count NUMBER;
759: x_msg_data VARCHAR2(1000);
760: BEGIN
761: IF okc_util.l_trace_flag OR okc_util.l_log_flag THEN
762: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
763: p_data => x_msg_data
764: );
765: IF (l_debug = 'Y') THEN
766: okc_util.print_trace(pos, '==EXCEPTION=================');

Line 768: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,

764: );
765: IF (l_debug = 'Y') THEN
766: okc_util.print_trace(pos, '==EXCEPTION=================');
767: END IF;
768: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
769: p_encoded => 'F'
770: );
771: IF (l_debug = 'Y') THEN
772: okc_util.print_trace(pos, 'Message : '||x_msg_data);

Line 2150: FND_MSG_PUB.Count_And_Get (

2146: END LOOP;
2147:
2148: ELSE -- IF is_top_line_orderable_i(r_cle ...) THEN
2149:
2150: FND_MSG_PUB.Count_And_Get (
2151: p_count => x_msg_count,
2152: p_data => x_msg_data);
2153: IF x_msg_count > 0 THEN
2154: FOR i IN 1..x_msg_count LOOP

Line 2155: x_msg_data := fnd_msg_pub.get( p_msg_index => i,

2151: p_count => x_msg_count,
2152: p_data => x_msg_data);
2153: IF x_msg_count > 0 THEN
2154: FOR i IN 1..x_msg_count LOOP
2155: x_msg_data := fnd_msg_pub.get( p_msg_index => i,
2156: p_encoded => 'F'
2157: );
2158: IF (l_debug = 'Y') THEN
2159: okc_util.print_trace(2, '==EXCEPTION=================');

Line 2313: FND_MSG_PUB.Count_And_Get (

2309:
2310:
2311: ELSE -- IF is_top_line_orderable_i(r_cle ...) THEN
2312:
2313: FND_MSG_PUB.Count_And_Get (
2314: p_count => x_msg_count,
2315: p_data => x_msg_data);
2316: FOR i IN x_msg_count-1..x_msg_count LOOP
2317: x_msg_data := fnd_msg_pub.get( p_msg_index => i,

Line 2317: x_msg_data := fnd_msg_pub.get( p_msg_index => i,

2313: FND_MSG_PUB.Count_And_Get (
2314: p_count => x_msg_count,
2315: p_data => x_msg_data);
2316: FOR i IN x_msg_count-1..x_msg_count LOOP
2317: x_msg_data := fnd_msg_pub.get( p_msg_index => i,
2318: p_encoded => 'F'
2319: );
2320: IF (l_debug = 'Y') THEN
2321: okc_util.print_trace(2, '==EXCEPTION=================');

Line 4090: l_init_msg_count:=fnd_msg_pub.count_msg;

4086: IF (l_debug = 'Y') THEN
4087: okc_util.print_trace(1, 'Initialize the message list');
4088: END IF;
4089: okc_api.init_msg_list(p_init_msg_list => p_init_msg_list);
4090: l_init_msg_count:=fnd_msg_pub.count_msg;
4091:
4092: --
4093: -- fetch the contract
4094: --

Line 4635: FND_MSG_PUB.Count_And_Get (

4631: END IF;
4632:
4633: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4634:
4635: FND_MSG_PUB.Count_And_Get (
4636: p_count => x_msg_count,
4637: p_data => x_msg_data);
4638:
4639: FOR k in 1..x_msg_count LOOP

Line 4640: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

4636: p_count => x_msg_count,
4637: p_data => x_msg_data);
4638:
4639: FOR k in 1..x_msg_count LOOP
4640: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
4641: p_encoded => 'F'
4642: );
4643: IF x_msg_data IS NOT NULL THEN
4644: IF (l_debug = 'Y') THEN

Line 4834: FND_MSG_PUB.Count_And_Get (

4830: p_token4_value => lx_qte_header_rec.quote_expiration_date,
4831: p_token5 => 'TRACEFILE',
4832: p_token5_value => okc_util.l_complete_trace_file_name2
4833: );
4834: FND_MSG_PUB.Count_And_Get (
4835: p_count => x_msg_count,
4836: p_data => x_msg_data);
4837: x_msg_data := fnd_msg_pub.get(
4838: p_msg_index => x_msg_count,

Line 4837: x_msg_data := fnd_msg_pub.get(

4833: );
4834: FND_MSG_PUB.Count_And_Get (
4835: p_count => x_msg_count,
4836: p_data => x_msg_data);
4837: x_msg_data := fnd_msg_pub.get(
4838: p_msg_index => x_msg_count,
4839: p_encoded => 'F');
4840:
4841: l_qte_creation_message := x_msg_data;

Line 4842: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

4838: p_msg_index => x_msg_count,
4839: p_encoded => 'F');
4840:
4841: l_qte_creation_message := x_msg_data;
4842: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
4843:
4844: END IF;
4845: EXCEPTION
4846: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 4858: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

4854: IF c_hdr_subject_to%ISOPEN THEN
4855: CLOSE c_hdr_subject_to;
4856: END IF;
4857: x_return_status := OKC_API.G_RET_STS_ERROR;
4858: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4859: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
4860: ,p_procedure_name => l_api_name
4861: ,p_error_text => 'Encountered error condition'
4862: );

Line 4859: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

4855: CLOSE c_hdr_subject_to;
4856: END IF;
4857: x_return_status := OKC_API.G_RET_STS_ERROR;
4858: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4859: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
4860: ,p_procedure_name => l_api_name
4861: ,p_error_text => 'Encountered error condition'
4862: );
4863: END IF;

Line 4884: FND_MSG_PUB.Count_And_Get (

4880: p_token2_value => l_chr.contract_number,
4881: p_token3 => 'KMODIFIER',
4882: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
4883: );
4884: FND_MSG_PUB.Count_And_Get (
4885: p_count => x_msg_count,
4886: p_data => x_msg_data);
4887: x_msg_data := fnd_msg_pub.get(
4888: p_msg_index => x_msg_count,

Line 4887: x_msg_data := fnd_msg_pub.get(

4883: );
4884: FND_MSG_PUB.Count_And_Get (
4885: p_count => x_msg_count,
4886: p_data => x_msg_data);
4887: x_msg_data := fnd_msg_pub.get(
4888: p_msg_index => x_msg_count,
4889: p_encoded => 'F');
4890:
4891: l_qte_creation_message := x_msg_data;

Line 4892: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

4888: p_msg_index => x_msg_count,
4889: p_encoded => 'F');
4890:
4891: l_qte_creation_message := x_msg_data;
4892: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
4893:
4894: okc_util.print_output(0, l_qte_creation_message);
4895: END IF;
4896: FND_MSG_PUB.Count_And_Get (

Line 4896: FND_MSG_PUB.Count_And_Get (

4892: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
4893:
4894: okc_util.print_output(0, l_qte_creation_message);
4895: END IF;
4896: FND_MSG_PUB.Count_And_Get (
4897: p_count => x_msg_count,
4898: p_data => x_msg_data);
4899: FOR k in l_init_msg_count..x_msg_count LOOP
4900: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 4900: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

4896: FND_MSG_PUB.Count_And_Get (
4897: p_count => x_msg_count,
4898: p_data => x_msg_data);
4899: FOR k in l_init_msg_count..x_msg_count LOOP
4900: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
4901: p_encoded => 'F'
4902: );
4903: IF x_msg_data IS NOT NULL THEN
4904: IF (l_debug = 'Y') THEN

Line 4928: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN

4924: IF c_hdr_subject_to%ISOPEN THEN
4925: CLOSE c_hdr_subject_to;
4926: END IF;
4927: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4928: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4929: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
4930: ,p_procedure_name => l_api_name
4931: ,p_error_text => 'Encountered unexpected error'
4932: );

Line 4929: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name

4925: CLOSE c_hdr_subject_to;
4926: END IF;
4927: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
4928: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
4929: fnd_msg_pub.add_exc_msg(p_pkg_name => g_pkg_name
4930: ,p_procedure_name => l_api_name
4931: ,p_error_text => 'Encountered unexpected error'
4932: );
4933: END IF;

Line 4954: FND_MSG_PUB.Count_And_Get (

4950: p_token2_value => l_chr.contract_number,
4951: p_token3 => 'KMODIFIER',
4952: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
4953: );
4954: FND_MSG_PUB.Count_And_Get (
4955: p_count => x_msg_count,
4956: p_data => x_msg_data);
4957: x_msg_data := fnd_msg_pub.get(
4958: p_msg_index => x_msg_count,

Line 4957: x_msg_data := fnd_msg_pub.get(

4953: );
4954: FND_MSG_PUB.Count_And_Get (
4955: p_count => x_msg_count,
4956: p_data => x_msg_data);
4957: x_msg_data := fnd_msg_pub.get(
4958: p_msg_index => x_msg_count,
4959: p_encoded => 'F');
4960:
4961: l_qte_creation_message := x_msg_data;

Line 4962: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

4958: p_msg_index => x_msg_count,
4959: p_encoded => 'F');
4960:
4961: l_qte_creation_message := x_msg_data;
4962: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
4963:
4964: okc_util.print_output(0, l_qte_creation_message);
4965: END IF;
4966: FND_MSG_PUB.Count_And_Get (

Line 4966: FND_MSG_PUB.Count_And_Get (

4962: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
4963:
4964: okc_util.print_output(0, l_qte_creation_message);
4965: END IF;
4966: FND_MSG_PUB.Count_And_Get (
4967: p_count => x_msg_count,
4968: p_data => x_msg_data);
4969: FOR k in l_init_msg_count..x_msg_count LOOP
4970: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 4970: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

4966: FND_MSG_PUB.Count_And_Get (
4967: p_count => x_msg_count,
4968: p_data => x_msg_data);
4969: FOR k in l_init_msg_count..x_msg_count LOOP
4970: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
4971: p_encoded => 'F'
4972: );
4973: IF x_msg_data IS NOT NULL THEN
4974: IF (l_debug = 'Y') THEN

Line 5025: FND_MSG_PUB.Count_And_Get (

5021: p_token2_value => l_chr.contract_number,
5022: p_token3 => 'KMODIFIER',
5023: p_token3_value => NVL(l_chr.contract_number_modifier, ' ')
5024: );
5025: FND_MSG_PUB.Count_And_Get (
5026: p_count => x_msg_count,
5027: p_data => x_msg_data);
5028: x_msg_data := fnd_msg_pub.get(
5029: p_msg_index => x_msg_count,

Line 5028: x_msg_data := fnd_msg_pub.get(

5024: );
5025: FND_MSG_PUB.Count_And_Get (
5026: p_count => x_msg_count,
5027: p_data => x_msg_data);
5028: x_msg_data := fnd_msg_pub.get(
5029: p_msg_index => x_msg_count,
5030: p_encoded => 'F');
5031:
5032: l_qte_creation_message := x_msg_data;

Line 5033: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);

5029: p_msg_index => x_msg_count,
5030: p_encoded => 'F');
5031:
5032: l_qte_creation_message := x_msg_data;
5033: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
5034:
5035: okc_util.print_output(0, l_qte_creation_message);
5036: END IF;
5037: FND_MSG_PUB.Count_And_Get (

Line 5037: FND_MSG_PUB.Count_And_Get (

5033: FND_MSG_PUB.Delete_Msg ( p_msg_index => x_msg_count);
5034:
5035: okc_util.print_output(0, l_qte_creation_message);
5036: END IF;
5037: FND_MSG_PUB.Count_And_Get (
5038: p_count => x_msg_count,
5039: p_data => x_msg_data);
5040: FOR k in l_init_msg_count..x_msg_count LOOP
5041: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

Line 5041: x_msg_data := fnd_msg_pub.get( p_msg_index => k,

5037: FND_MSG_PUB.Count_And_Get (
5038: p_count => x_msg_count,
5039: p_data => x_msg_data);
5040: FOR k in l_init_msg_count..x_msg_count LOOP
5041: x_msg_data := fnd_msg_pub.get( p_msg_index => k,
5042: p_encoded => 'F'
5043: );
5044: IF x_msg_data IS NOT NULL THEN
5045: IF (l_debug = 'Y') THEN