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.OKL_SALES_QUOTE_QA_PVT dependencies on FND_MESSAGE

Line 40: -- PROCEDURE set_fnd_message

36: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
37: lp_lq_header_rec c_lq_header_rec%ROWTYPE;
38:
39: /*------------------------------------------------------------------------------
40: -- PROCEDURE set_fnd_message
41: ------------------------------------------------------------------------------
42: -- Start of comments
43: --
44: -- Procedure Name : set_fnd_message

Line 44: -- Procedure Name : set_fnd_message

40: -- PROCEDURE set_fnd_message
41: ------------------------------------------------------------------------------
42: -- Start of comments
43: --
44: -- Procedure Name : set_fnd_message
45: -- Description : This Procedure sets the message name and tokens in
46: fnd_message and returns the retrieved message text.
47: --
48: -- Business Rules :

Line 46: fnd_message and returns the retrieved message text.

42: -- Start of comments
43: --
44: -- Procedure Name : set_fnd_message
45: -- Description : This Procedure sets the message name and tokens in
46: fnd_message and returns the retrieved message text.
47: --
48: -- Business Rules :
49: --
50: -- Parameters : p_msg_name -- MESSAGE_NAME FROm FND_NEW_MESAGES

Line 59: PROCEDURE set_fnd_message(p_msg_name IN varchar2

55: -- Version :
56: -- History :
57: -- End of comments
58: ------------------------------------------------------------------------------*/
59: PROCEDURE set_fnd_message(p_msg_name IN varchar2
60: ,p_token1 IN varchar2 DEFAULT NULL
61: ,p_value1 IN varchar2 DEFAULT NULL
62: ,p_token2 IN varchar2 DEFAULT NULL
63: ,p_value2 IN varchar2 DEFAULT NULL

Line 70: l_module CONSTANT fnd_log_messages.module%TYPE := 'set_fnd_message';

66: ,p_token4 IN varchar2 DEFAULT NULL
67: ,p_value4 IN varchar2 DEFAULT NULL) IS
68:
69: l_msg varchar2(2700);
70: l_module CONSTANT fnd_log_messages.module%TYPE := 'set_fnd_message';
71: l_debug_enabled varchar2(10);
72: is_debug_procedure_on boolean;
73: is_debug_statement_on boolean;
74:

Line 83: ,'begin debug OKLRECUB.pls.pls call set_fnd_message');

79:
80: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
81: okl_debug_pub.log_debug(fnd_log.level_procedure
82: ,l_module
83: ,'begin debug OKLRECUB.pls.pls call set_fnd_message');
84: END IF;
85: fnd_message.set_name(g_app_name, p_msg_name);
86:
87: IF (p_token1 IS NOT NULL) THEN

Line 85: fnd_message.set_name(g_app_name, p_msg_name);

81: okl_debug_pub.log_debug(fnd_log.level_procedure
82: ,l_module
83: ,'begin debug OKLRECUB.pls.pls call set_fnd_message');
84: END IF;
85: fnd_message.set_name(g_app_name, p_msg_name);
86:
87: IF (p_token1 IS NOT NULL) THEN
88: fnd_message.set_token(token => p_token1, value => p_value1);
89: END IF;

Line 88: fnd_message.set_token(token => p_token1, value => p_value1);

84: END IF;
85: fnd_message.set_name(g_app_name, p_msg_name);
86:
87: IF (p_token1 IS NOT NULL) THEN
88: fnd_message.set_token(token => p_token1, value => p_value1);
89: END IF;
90:
91: IF (p_token2 IS NOT NULL) THEN
92: fnd_message.set_token(token => p_token2, value => p_value2);

Line 92: fnd_message.set_token(token => p_token2, value => p_value2);

88: fnd_message.set_token(token => p_token1, value => p_value1);
89: END IF;
90:
91: IF (p_token2 IS NOT NULL) THEN
92: fnd_message.set_token(token => p_token2, value => p_value2);
93: END IF;
94:
95: IF (p_token3 IS NOT NULL) THEN
96: fnd_message.set_token(token => p_token3, value => p_value3);

Line 96: fnd_message.set_token(token => p_token3, value => p_value3);

92: fnd_message.set_token(token => p_token2, value => p_value2);
93: END IF;
94:
95: IF (p_token3 IS NOT NULL) THEN
96: fnd_message.set_token(token => p_token3, value => p_value3);
97: END IF;
98:
99: IF (p_token4 IS NOT NULL) THEN
100: fnd_message.set_token(token => p_token4, value => p_value4);

Line 100: fnd_message.set_token(token => p_token4, value => p_value4);

96: fnd_message.set_token(token => p_token3, value => p_value3);
97: END IF;
98:
99: IF (p_token4 IS NOT NULL) THEN
100: fnd_message.set_token(token => p_token4, value => p_value4);
101: END IF;
102:
103: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
104: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 106: ,'end debug OKLRECUB.pls.pls call set_fnd_message');

102:
103: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
104: okl_debug_pub.log_debug(fnd_log.level_procedure
105: ,l_module
106: ,'end debug OKLRECUB.pls.pls call set_fnd_message');
107: END IF;
108:
109: END set_fnd_message;
110: /*------------------------------------------------------------------------------

Line 109: END set_fnd_message;

105: ,l_module
106: ,'end debug OKLRECUB.pls.pls call set_fnd_message');
107: END IF;
108:
109: END set_fnd_message;
110: /*------------------------------------------------------------------------------
111: -- PROCEDURE populate_lq_rec_values
112: ------------------------------------------------------------------------------
113: -- Start of comments

Line 368: set_fnd_message(p_msg_name => 'OKL_QA_SRT_MAX_RATE_VALID'

364: l_srt_effective_rate := l_srt_rec.srt_rate + nvl(l_srt_rec.spread,0) + nvl(l_adj_factor,0); -- Rate is being stored as Percentage
365: --l_okl_srt_table(i).srt_rate := l_okl_srt_rec.srt_rate + nvl(l_okl_srt_rec.spread,0) + nvl(l_adj_factor,0); -- Rate is being stored as Percentage
366: IF(l_srt_effective_rate IS NOT NULL) THEN
367: IF(nvl(l_srt_rec.max_adj_rate,l_srt_effective_rate) < l_srt_effective_rate )THEN
368: set_fnd_message(p_msg_name => 'OKL_QA_SRT_MAX_RATE_VALID'
369: ,p_token1 => 'SRT_NAME'
370: ,p_value1 => l_srt_rec.name
371: ,p_token2 => 'EFF_RATE'
372: ,p_value2 => l_srt_effective_rate

Line 384: x_qa_result_tbl(i).message_text:= fnd_message.get;

380: x_qa_result_tbl(i).check_meaning:='SRT_EFF_RATE_IS_INVALID';
381: x_qa_result_tbl(i).result_code:='ERROR';
382: x_qa_result_tbl(i).result_meaning:='ERROR';
383: x_qa_result_tbl(i).message_code:= 'OKL_QA_SRT_MAX_RATE_VALID';
384: x_qa_result_tbl(i).message_text:= fnd_message.get;
385:
386: ELSIF(nvl(l_srt_rec.min_adj_rate,l_srt_effective_rate) > l_srt_effective_rate) THEN
387: set_fnd_message(p_msg_name => 'OKL_QA_SRT_MIN_RATE_VALID'
388: ,p_token1 => 'SRT_NAME'

Line 387: set_fnd_message(p_msg_name => 'OKL_QA_SRT_MIN_RATE_VALID'

383: x_qa_result_tbl(i).message_code:= 'OKL_QA_SRT_MAX_RATE_VALID';
384: x_qa_result_tbl(i).message_text:= fnd_message.get;
385:
386: ELSIF(nvl(l_srt_rec.min_adj_rate,l_srt_effective_rate) > l_srt_effective_rate) THEN
387: set_fnd_message(p_msg_name => 'OKL_QA_SRT_MIN_RATE_VALID'
388: ,p_token1 => 'SRT_NAME'
389: ,p_value1 => l_srt_rec.name
390: ,p_token2 => 'EFF_RATE'
391: ,p_value2 => l_srt_effective_rate

Line 403: x_qa_result_tbl(i).message_text:= fnd_message.get;

399: x_qa_result_tbl(i).check_meaning:='SRT_EFF_RATE_IS_INVALID';
400: x_qa_result_tbl(i).result_code:='ERROR';
401: x_qa_result_tbl(i).result_meaning:='ERROR';
402: x_qa_result_tbl(i).message_code:= 'OKL_QA_SRT_MIN_RATE_VALID';
403: x_qa_result_tbl(i).message_text:= fnd_message.get;
404: END IF;
405: END IF;
406:
407: EXCEPTION

Line 1915: set_fnd_message(p_msg_name => l_message_name

1911: CLOSE c_lrs_rec;
1912: l_message_name := 'OKL_QA_LRS_TMPL_NOT_VALID';
1913: END IF;
1914: x_qa_result_tbl(i).message_code:= l_message_name;
1915: set_fnd_message(p_msg_name => l_message_name
1916: ,p_token1 => 'NAME'
1917: ,p_value1 => l_obj_name
1918: ,p_token2 => NULL
1919: ,p_value2 => NULL

Line 1924: x_qa_result_tbl(i).message_text:= fnd_message.get;

1920: ,p_token3 => NULL
1921: ,p_value3 => NULL
1922: ,p_token4 => NULL
1923: ,p_value4 => NULL);
1924: x_qa_result_tbl(i).message_text:= fnd_message.get;
1925: x_qa_result := okl_api.G_RET_STS_ERROR;
1926: END IF;
1927: END IF;
1928: --Bug # 5050143 ssdeshpa start

Line 1977: set_fnd_message(p_msg_name => l_message_name

1973: CLOSE c_lrs_rec;
1974: l_message_name := 'OKL_QA_LRS_TMPL_NOT_VALID';
1975: END IF;
1976: x_qa_result_tbl(i).message_code:= l_message_name;
1977: set_fnd_message(p_msg_name => l_message_name
1978: ,p_token1 => 'NAME'
1979: ,p_value1 => l_obj_name
1980: ,p_token2 => NULL
1981: ,p_value2 => NULL

Line 1986: x_qa_result_tbl(i).message_text:= fnd_message.get;

1982: ,p_token3 => NULL
1983: ,p_value3 => NULL
1984: ,p_token4 => NULL
1985: ,p_value4 => NULL);
1986: x_qa_result_tbl(i).message_text:= fnd_message.get;
1987: x_qa_result := okl_api.G_RET_STS_ERROR;
1988: EXIT;
1989: END IF;
1990: END IF;

Line 3823: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_FOUND'

3819: x_qa_result_tbl(i).check_meaning:='MISSING_PAYMENT_LEVEL_NOT_FOUND';
3820: x_qa_result_tbl(i).result_code:='ERROR';
3821: x_qa_result_tbl(i).result_meaning:='ERROR';
3822: x_qa_result_tbl(i).message_code:= 'OKL_QA_SM_ASSET_SRT_FOUND';
3823: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_FOUND'
3824: ,p_token1 => 'NAME'
3825: ,p_value1 => configuration_asset_rec.ID
3826: ,p_token2 => NULL
3827: ,p_value2 => NULL

Line 3832: x_qa_result_tbl(i).message_text:= fnd_message.get;

3828: ,p_token3 => NULL
3829: ,p_value3 => NULL
3830: ,p_token4 => NULL
3831: ,p_value4 => NULL);
3832: x_qa_result_tbl(i).message_text:= fnd_message.get;
3833: x_qa_result := okl_api.G_RET_STS_ERROR;
3834: END IF;
3835:
3836: IF(l_missing_pmts > 0 AND (l_cfl_count = 1)) THEN

Line 3966: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_FOUND'

3962: x_qa_result_tbl(i).check_meaning:='MISSING_PAYMENT_LEVEL_NOT_FOUND';
3963: x_qa_result_tbl(i).result_code:='ERROR';
3964: x_qa_result_tbl(i).result_meaning:='ERROR';
3965: x_qa_result_tbl(i).message_code:= 'OKL_QA_SM_ASSET_SRT_FOUND';
3966: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_FOUND'
3967: ,p_token1 => 'NAME'
3968: ,p_value1 => configuration_asset_rec.ID
3969: ,p_token2 => NULL
3970: ,p_value2 => NULL

Line 3975: x_qa_result_tbl(i).message_text:= fnd_message.get;

3971: ,p_token3 => NULL
3972: ,p_value3 => NULL
3973: ,p_token4 => NULL
3974: ,p_value4 => NULL);
3975: x_qa_result_tbl(i).message_text:= fnd_message.get;
3976: x_qa_result := okl_api.G_RET_STS_ERROR;
3977: END IF;
3978: --For line level override, if SRT is entered at the asset level, and no
3979: --missing payment is defined, There should be an error stating that the

Line 3989: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_REQ'

3985: x_qa_result_tbl(i).check_meaning:='MISSING_PAYMENT_LEVEL_NOT_FOUND';
3986: x_qa_result_tbl(i).result_code:='ERROR';
3987: x_qa_result_tbl(i).result_meaning:='ERROR';
3988: x_qa_result_tbl(i).message_code:= 'OKL_QA_SM_ASSET_SRT_REQ';
3989: set_fnd_message( p_msg_name => 'OKL_QA_SM_ASSET_SRT_REQ'
3990: ,p_token1 => 'NAME'
3991: ,p_value1 => configuration_asset_rec.ID
3992: ,p_token2 => NULL
3993: ,p_value2 => NULL

Line 3998: x_qa_result_tbl(i).message_text:= fnd_message.get;

3994: ,p_token3 => NULL
3995: ,p_value3 => NULL
3996: ,p_token4 => NULL
3997: ,p_value4 => NULL);
3998: x_qa_result_tbl(i).message_text:= fnd_message.get;
3999: x_qa_result := okl_api.G_RET_STS_ERROR;
4000:
4001: END IF;
4002: IF(l_missing_pmts > 0 AND (l_cfl_count = 1)) THEN

Line 4509: set_fnd_message( p_msg_name => 'OKL_QA_SM_FEE_SRT_REQ'

4505: x_qa_result_tbl(i).check_meaning:='MISSING_PAYMENT_LEVEL_NOT_FOUND';
4506: x_qa_result_tbl(i).result_code:='ERROR';
4507: x_qa_result_tbl(i).result_meaning:='ERROR';
4508: x_qa_result_tbl(i).message_code:= 'OKL_QA_SM_FEE_SRT_REQ';
4509: set_fnd_message( p_msg_name => 'OKL_QA_SM_FEE_SRT_REQ'
4510: ,p_token1 => 'NAME'
4511: ,p_value1 => configuration_fee_rec.name
4512: ,p_token2 => NULL
4513: ,p_value2 => NULL

Line 4518: x_qa_result_tbl(i).message_text:= fnd_message.get;

4514: ,p_token3 => NULL
4515: ,p_value3 => NULL
4516: ,p_token4 => NULL
4517: ,p_value4 => NULL);
4518: x_qa_result_tbl(i).message_text:= fnd_message.get;
4519: x_qa_result := okl_api.G_RET_STS_ERROR;
4520:
4521: ELSIF(l_missing_pmts = 0 AND configuration_fee_rec.RATE_TEMPLATE_ID IS NOT NULL) THEN
4522: i:=x_qa_result_tbl.COUNT;

Line 4529: set_fnd_message( p_msg_name => 'OKL_QA_SM_FEE_SRT_FOUND'

4525: x_qa_result_tbl(i).check_meaning:='MISSING_PAYMENT_LEVEL_NOT_FOUND';
4526: x_qa_result_tbl(i).result_code:='ERROR';
4527: x_qa_result_tbl(i).result_meaning:='ERROR';
4528: x_qa_result_tbl(i).message_code:= 'OKL_QA_SM_FEE_SRT_FOUND';
4529: set_fnd_message( p_msg_name => 'OKL_QA_SM_FEE_SRT_FOUND'
4530: ,p_token1 => 'NAME'
4531: ,p_value1 => configuration_fee_rec.name
4532: ,p_token2 => NULL
4533: ,p_value2 => NULL

Line 4538: x_qa_result_tbl(i).message_text:= fnd_message.get;

4534: ,p_token3 => NULL
4535: ,p_value3 => NULL
4536: ,p_token4 => NULL
4537: ,p_value4 => NULL);
4538: x_qa_result_tbl(i).message_text:= fnd_message.get;
4539: x_qa_result := okl_api.G_RET_STS_ERROR;
4540:
4541: END IF;
4542: l_total_missing_pmts := l_total_missing_pmts + l_missing_pmts;