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.AS_ISSUE_UTIL_PVT dependencies on FND_MSG_PUB

Line 41: FND_MSG_PUB.initialize;

37:
38: -- initialize message list if p_init_msg_list is set to TRUE;
39:
40: IF FND_API.to_Boolean(p_init_msg_list) THEN
41: FND_MSG_PUB.initialize;
42: END IF;
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:

Line 52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

48:
49: OPEN C_party_exists(p_party_id);
50: FETCH C_party_exists into l_val;
51: IF (C_party_exists%NOTFOUND) THEN
52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
53: 'party_id is not valid:' || p_party_id);
54:
55: AS_UTILITY_PVT.Set_Message(
56: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 56: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
53: 'party_id is not valid:' || p_party_id);
54:
55: AS_UTILITY_PVT.Set_Message(
56: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
57: p_msg_name => 'API_INVALID_ID',
58: p_token1 => 'COLUMN',
59: p_token1_value => 'PARTY_ID',
60: p_token2 => 'VALUE',

Line 67: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

63: x_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65: CLOSE C_Party_Exists;
66: ELSE
67: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
68: 'party_id is not valid:' || p_party_id);
69:
70: AS_UTILITY_PVT.Set_Message(
71: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 71: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

67: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
68: 'party_id is not valid:' || p_party_id);
69:
70: AS_UTILITY_PVT.Set_Message(
71: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
72: p_msg_name => 'API_INVALID_ID',
73: p_token1 => 'COLUMN',
74: p_token1_value => 'PARTY_ID',
75: p_token2 => 'VALUE',

Line 81: FND_MSG_PUB.Count_And_Get (

77:
78: x_return_status := FND_API.G_RET_STS_ERROR;
79: END IF;
80:
81: FND_MSG_PUB.Count_And_Get (
82: p_count => x_msg_count,
83: p_data => x_msg_data);
84:
85: END Validate_party_id;

Line 114: FND_MSG_PUB.initialize;

110: BEGIN
111:
112: -- Initialize message list if p_init_msg_list is set to TRUE.
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 128: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

124: 'AS_FUND_CONTACT_ROLE');
125: FETCH C_contact_role_code_exists into l_val;
126:
127: IF C_contact_role_code_exists%NOTFOUND THEN
128: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
129: 'contact_role_code is not valid:' || p_contact_role_code);
130:
131: AS_UTILITY_PVT.Set_Message(
132: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 132: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

128: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
129: 'contact_role_code is not valid:' || p_contact_role_code);
130:
131: AS_UTILITY_PVT.Set_Message(
132: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
133: p_msg_name => 'API_INVALID_ID',
134: p_token1 => 'COLUMN',
135: p_token1_value => 'CONTACT_ROLE_CODE',
136: p_token2 => 'VALUE',

Line 144: FND_MSG_PUB.Count_And_Get (

140: END IF;
141: CLOSE C_contact_role_code_exists;
142: END IF;
143:
144: FND_MSG_PUB.Count_And_Get (
145: p_count => x_msg_count,
146: p_data => x_msg_data);
147:
148: END Validate_fd_contact_role_code;

Line 177: FND_MSG_PUB.initialize;

173: BEGIN
174:
175: -- Initialize message list if p_init_msg_list is set to TRUE.
176: IF FND_API.to_Boolean( p_init_msg_list ) THEN
177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: -- Initialize API return status to SUCCESS
181: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

186: OPEN C_strategy_exists (p_strategy, 'AS_FUND_STRATEGY');
187: FETCH C_strategy_exists into l_val;
188:
189: IF C_strategy_exists%NOTFOUND THEN
190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
191: 'strategy is not valid:' || p_strategy);
192:
193: AS_UTILITY_PVT.Set_Message(
194: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 194: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
191: 'strategy is not valid:' || p_strategy);
192:
193: AS_UTILITY_PVT.Set_Message(
194: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
195: p_msg_name => 'API_INVALID_ID',
196: p_token1 => 'COLUMN',
197: p_token1_value => 'STRATEGY',
198: p_token2 => 'VALUE',

Line 206: FND_MSG_PUB.Count_And_Get (

202: END IF;
203: CLOSE C_strategy_exists;
204: END IF;
205:
206: FND_MSG_PUB.Count_And_Get (
207: p_count => x_msg_count,
208: p_data => x_msg_data);
209:
210: END Validate_fund_strategy;

Line 240: FND_MSG_PUB.initialize;

236: BEGIN
237:
238: -- Initialize message list if p_init_msg_list is set to TRUE.
239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
240: FND_MSG_PUB.initialize;
241: END IF;
242:
243: -- Initialize API return status to SUCCESS
244: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

249: OPEN C_scheme_exists (p_scheme, 'AS_ISSUE_SCHEME');
250: FETCH C_scheme_exists into l_val;
251:
252: IF C_scheme_exists%NOTFOUND THEN
253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'issue scheme is not valid:' || p_scheme);
255:
256: AS_UTILITY_PVT.Set_Message(
257: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 257: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

253: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'issue scheme is not valid:' || p_scheme);
255:
256: AS_UTILITY_PVT.Set_Message(
257: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
258: p_msg_name => 'API_INVALID_ID',
259: p_token1 => 'COLUMN',
260: p_token1_value => 'ISSUE_SCHEME',
261: p_token2 => 'VALUE',

Line 268: FND_MSG_PUB.Count_And_Get (

264: END IF;
265: CLOSE C_scheme_exists;
266: END IF;
267:
268: FND_MSG_PUB.Count_And_Get (
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: END Validate_scheme;

Line 302: FND_MSG_PUB.initialize;

298: BEGIN
299:
300: -- Initialize message list if p_init_msg_list is set to TRUE.
301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: -- Initialize API return status to SUCCESS
306: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 316: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

312: 'AS_ISSUE_TYPE');
313: FETCH C_issue_type_exists into l_val;
314:
315: IF C_issue_type_exists%NOTFOUND THEN
316: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
317: 'issue group type code is not valid:' || p_issue_type);
318:
319: AS_UTILITY_PVT.Set_Message(
320: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 320: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

316: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
317: 'issue group type code is not valid:' || p_issue_type);
318:
319: AS_UTILITY_PVT.Set_Message(
320: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
321: p_msg_name => 'API_INVALID_ID',
322: p_token1 => 'COLUMN',
323: p_token1_value => 'ISSUE_TYPE',
324: p_token2 => 'VALUE',

Line 331: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

327: x_return_status := FND_API.G_RET_STS_ERROR;
328: END IF;
329: CLOSE C_issue_type_exists;
330: ELSE
331: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
332: 'issue group type code is not valid:' || p_issue_type);
333:
334: AS_UTILITY_PVT.Set_Message(
335: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 335: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

331: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
332: 'issue group type code is not valid:' || p_issue_type);
333:
334: AS_UTILITY_PVT.Set_Message(
335: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
336: p_msg_name => 'API_INVALID_ID',
337: p_token1 => 'COLUMN',
338: p_token1_value => 'ISSUE_TYPE',
339: p_token2 => 'VALUE',

Line 345: FND_MSG_PUB.Count_And_Get (

341:
342: x_return_status := FND_API.G_RET_STS_ERROR;
343: END IF;
344:
345: FND_MSG_PUB.Count_And_Get (
346: p_count => x_msg_count,
347: p_data => x_msg_data);
348:
349: END Validate_issue_type;

Line 377: FND_MSG_PUB.initialize;

373: BEGIN
374:
375: -- Initialize message list if p_init_msg_list is set to TRUE.
376: IF FND_API.to_Boolean( p_init_msg_list ) THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379:
380: -- Initialize API return status to SUCCESS
381: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 390: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

386: OPEN C_issue_group_type_code_exists (p_issue_group_type_code);
387: FETCH C_issue_group_type_code_exists into l_val;
388:
389: IF C_issue_group_type_code_exists%NOTFOUND THEN
390: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
391: 'issue group type code is not valid:' || p_issue_group_type_code);
392:
393: AS_UTILITY_PVT.Set_Message(
394: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 394: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

390: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
391: 'issue group type code is not valid:' || p_issue_group_type_code);
392:
393: AS_UTILITY_PVT.Set_Message(
394: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
395: p_msg_name => 'API_INVALID_ID',
396: p_token1 => 'COLUMN',
397: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',
398: p_token2 => 'VALUE',

Line 405: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

401: x_return_status := FND_API.G_RET_STS_ERROR;
402: END IF;
403: CLOSE C_issue_group_type_code_exists;
404: ELSE
405: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
406: 'issue group type code is not valid:' || p_issue_group_type_code);
407:
408: AS_UTILITY_PVT.Set_Message(
409: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 409: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

405: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
406: 'issue group type code is not valid:' || p_issue_group_type_code);
407:
408: AS_UTILITY_PVT.Set_Message(
409: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
410: p_msg_name => 'API_INVALID_ID',
411: p_token1 => 'COLUMN',
412: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',
413: p_token2 => 'VALUE',

Line 419: FND_MSG_PUB.Count_And_Get (

415:
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: END IF;
418:
419: FND_MSG_PUB.Count_And_Get (
420: p_count => x_msg_count,
421: p_data => x_msg_data);
422:
423: END Validate_issue_group_type_code;

Line 453: FND_MSG_PUB.initialize;

449: BEGIN
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: -- Initialize API return status to SUCCESS
457: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 468: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

464: 'AS_ISSUE_RELATIONSHIP_TYPE');
465: FETCH C_is_relationship_type_exists into l_val;
466:
467: IF C_is_relationship_type_exists%NOTFOUND THEN
468: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
469: 'issue relationship type is not valid:' || p_issue_relationship_type);
470:
471: AS_UTILITY_PVT.Set_Message(
472: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 472: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

468: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
469: 'issue relationship type is not valid:' || p_issue_relationship_type);
470:
471: AS_UTILITY_PVT.Set_Message(
472: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
473: p_msg_name => 'API_INVALID_ID',
474: p_token1 => 'COLUMN',
475: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',
476: p_token2 => 'VALUE',

Line 483: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: CLOSE C_is_relationship_type_exists;
482: ELSE
483: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
484: 'issue relationship type is not valid:' || p_issue_relationship_type);
485:
486: AS_UTILITY_PVT.Set_Message(
487: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 487: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

483: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
484: 'issue relationship type is not valid:' || p_issue_relationship_type);
485:
486: AS_UTILITY_PVT.Set_Message(
487: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
488: p_msg_name => 'API_INVALID_ID',
489: p_token1 => 'COLUMN',
490: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',
491: p_token2 => 'VALUE',

Line 497: FND_MSG_PUB.Count_And_Get (

493:
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: END IF;
496:
497: FND_MSG_PUB.Count_And_Get (
498: p_count => x_msg_count,
499: p_data => x_msg_data);
500:
501: END Validate_is_relationship_type;

Line 526: FND_MSG_PUB.initialize;

522:
523: BEGIN
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_Boolean( p_init_msg_list ) THEN
526: FND_MSG_PUB.initialize;
527: END IF;
528:
529: -- Initialize API return status to SUCCESS
530: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

534:
535: OPEN C_country_code_exists ( p_country_code );
536: FETCH C_country_code_exists INTO l_val;
537: IF (C_country_code_exists%NOTFOUND) THEN
538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
539: 'country code is not valid:' || p_country_code);
540:
541: AS_UTILITY_PVT.Set_Message(
542: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 542: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

538: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
539: 'country code is not valid:' || p_country_code);
540:
541: AS_UTILITY_PVT.Set_Message(
542: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
543: p_msg_name => 'API_INVALID_ID',
544: p_token1 => 'COLUMN',
545: p_token1_value => 'COUNTRY_CODE',
546: p_token2 => 'VALUE',

Line 553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

549: x_return_status := FND_API.G_RET_STS_ERROR;
550: END IF;
551: CLOSE C_country_code_exists;
552: ELSE
553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'country code is not valid:' || p_country_code);
555:
556: AS_UTILITY_PVT.Set_Message(
557: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 557: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'country code is not valid:' || p_country_code);
555:
556: AS_UTILITY_PVT.Set_Message(
557: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
558: p_msg_name => 'API_INVALID_ID',
559: p_token1 => 'COLUMN',
560: p_token1_value => 'COUNTRY_CODE',
561: p_token2 => 'VALUE',

Line 567: FND_MSG_PUB.Count_And_Get (

563:
564: x_return_status := FND_API.G_RET_STS_ERROR;
565: END IF;
566:
567: FND_MSG_PUB.Count_And_Get (
568: p_count => x_msg_count,
569: p_data => x_msg_data);
570:
571: END Validate_country_code;

Line 596: FND_MSG_PUB.initialize;

592:
593: BEGIN
594: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF FND_API.to_Boolean( p_init_msg_list ) THEN
596: FND_MSG_PUB.initialize;
597: END IF;
598:
599: -- Initialize API return status to SUCCESS
600: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

604:
605: OPEN C_currency_code_exists ( p_currency_code );
606: FETCH C_currency_code_exists INTO l_val;
607: IF (C_currency_code_exists%NOTFOUND) THEN
608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'currency code is not valid:' || p_currency_code);
610:
611: AS_UTILITY_PVT.Set_Message(
612: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 612: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,

608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
609: 'currency code is not valid:' || p_currency_code);
610:
611: AS_UTILITY_PVT.Set_Message(
612: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
613: p_msg_name => 'API_INVALID_ID',
614: p_token1 => 'COLUMN',
615: p_token1_value => 'CURRENCY_CODE',
616: p_token2 => 'VALUE',

Line 624: FND_MSG_PUB.Count_And_Get (

620: END IF;
621: CLOSE C_currency_code_exists;
622: END IF;
623:
624: FND_MSG_PUB.Count_And_Get (
625: p_count => x_msg_count,
626: p_data => x_msg_data);
627:
628: END Validate_currency_code;