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_API

Line 23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

19: --
20: -- NOTES:
21: --
22: PROCEDURE Validate_party_id (
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_party_id IN NUMBER,
25: x_return_status OUT VARCHAR2,
26: x_msg_count OUT NUMBER,
27: x_msg_data OUT VARCHAR2) IS

Line 40: IF FND_API.to_Boolean(p_init_msg_list) THEN

36: BEGIN
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;

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
46: IF (p_party_id is NOT NULL) and
47: (p_party_id <> FND_API.G_MISS_NUM) THEN
48:

Line 47: (p_party_id <> FND_API.G_MISS_NUM) THEN

43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:
46: IF (p_party_id is NOT NULL) and
47: (p_party_id <> FND_API.G_MISS_NUM) THEN
48:
49: OPEN C_party_exists(p_party_id);
50: FETCH C_party_exists into l_val;
51: IF (C_party_exists%NOTFOUND) THEN

Line 63: x_return_status := FND_API.G_RET_STS_ERROR;

59: p_token1_value => 'PARTY_ID',
60: p_token2 => 'VALUE',
61: p_token2_value => p_party_id);
62:
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,

Line 78: x_return_status := FND_API.G_RET_STS_ERROR;

74: p_token1_value => 'PARTY_ID',
75: p_token2 => 'VALUE',
76: p_token2_value => p_party_id);
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,

Line 95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

91: --
92: -- NOTES:
93: --
94: PROCEDURE Validate_fd_contact_role_code (
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_contact_role_code IN VARCHAR2,
97: x_return_status OUT VARCHAR2,
98: x_msg_count OUT NUMBER,
99: x_msg_data OUT VARCHAR2) IS

Line 113: IF FND_API.to_Boolean( p_init_msg_list ) THEN

109:
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

Line 118: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
119:
120: IF (p_contact_role_code is NOT NULL) and
121: (p_contact_role_code <> FND_API.G_MISS_CHAR) THEN
122:

Line 121: (p_contact_role_code <> FND_API.G_MISS_CHAR) THEN

117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: IF (p_contact_role_code is NOT NULL) and
121: (p_contact_role_code <> FND_API.G_MISS_CHAR) THEN
122:
123: OPEN C_contact_role_code_exists (p_contact_role_code,
124: 'AS_FUND_CONTACT_ROLE');
125: FETCH C_contact_role_code_exists into l_val;

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: p_token1_value => 'CONTACT_ROLE_CODE',
136: p_token2 => 'VALUE',
137: p_token2_value => p_contact_role_code );
138:
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: END IF;
141: CLOSE C_contact_role_code_exists;
142: END IF;
143:

Line 158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

154: --
155: -- NOTES:
156: --
157: PROCEDURE Validate_fund_strategy (
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_strategy IN VARCHAR2,
160: x_return_status OUT VARCHAR2,
161: x_msg_count OUT NUMBER,
162: x_msg_data OUT VARCHAR2) IS

Line 176: IF FND_API.to_Boolean( p_init_msg_list ) THEN

172:
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

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
182:
183: IF (p_strategy is NOT NULL) and
184: (p_strategy <> FND_API.G_MISS_CHAR) THEN
185:

Line 184: (p_strategy <> FND_API.G_MISS_CHAR) THEN

180: -- Initialize API return status to SUCCESS
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF (p_strategy is NOT NULL) and
184: (p_strategy <> FND_API.G_MISS_CHAR) THEN
185:
186: OPEN C_strategy_exists (p_strategy, 'AS_FUND_STRATEGY');
187: FETCH C_strategy_exists into l_val;
188:

Line 201: x_return_status := FND_API.G_RET_STS_ERROR;

197: p_token1_value => 'STRATEGY',
198: p_token2 => 'VALUE',
199: p_token2_value => p_strategy );
200:
201: x_return_status := FND_API.G_RET_STS_ERROR;
202: END IF;
203: CLOSE C_strategy_exists;
204: END IF;
205:

Line 220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

216: --
217: -- NOTES:
218: --
219: PROCEDURE Validate_scheme (
220: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221: p_scheme IN VARCHAR2,
222: x_return_status OUT VARCHAR2,
223: x_msg_count OUT NUMBER,
224: x_msg_data OUT VARCHAR2) IS

Line 239: IF FND_API.to_Boolean( p_init_msg_list ) THEN

235:
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

Line 244: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
245:
246: IF (p_scheme is NOT NULL) and
247: (p_scheme <> FND_API.G_MISS_CHAR) THEN
248:

Line 247: (p_scheme <> FND_API.G_MISS_CHAR) THEN

243: -- Initialize API return status to SUCCESS
244: x_return_status := FND_API.G_RET_STS_SUCCESS;
245:
246: IF (p_scheme is NOT NULL) and
247: (p_scheme <> FND_API.G_MISS_CHAR) THEN
248:
249: OPEN C_scheme_exists (p_scheme, 'AS_ISSUE_SCHEME');
250: FETCH C_scheme_exists into l_val;
251:

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

259: p_token1 => 'COLUMN',
260: p_token1_value => 'ISSUE_SCHEME',
261: p_token2 => 'VALUE',
262: p_token2_value => p_scheme);
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: END IF;
265: CLOSE C_scheme_exists;
266: END IF;
267:

Line 282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

278: --
279: -- NOTES:
280: --
281: PROCEDURE Validate_issue_type (
282: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
283: p_issue_type IN VARCHAR2,
284: x_return_status OUT VARCHAR2,
285: x_msg_count OUT NUMBER,
286: x_msg_data OUT VARCHAR2) IS

Line 301: IF FND_API.to_Boolean( p_init_msg_list ) THEN

297:
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

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
307:
308: IF (p_issue_type is NOT NULL) and
309: (p_issue_type <> FND_API.G_MISS_CHAR) THEN
310:

Line 309: (p_issue_type <> FND_API.G_MISS_CHAR) THEN

305: -- Initialize API return status to SUCCESS
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: IF (p_issue_type is NOT NULL) and
309: (p_issue_type <> FND_API.G_MISS_CHAR) THEN
310:
311: OPEN C_issue_type_exists (p_issue_type,
312: 'AS_ISSUE_TYPE');
313: FETCH C_issue_type_exists into l_val;

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

323: p_token1_value => 'ISSUE_TYPE',
324: p_token2 => 'VALUE',
325: p_token2_value => p_issue_type);
326:
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,

Line 342: x_return_status := FND_API.G_RET_STS_ERROR;

338: p_token1_value => 'ISSUE_TYPE',
339: p_token2 => 'VALUE',
340: p_token2_value => p_issue_type);
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,

Line 359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

355: --
356: -- NOTES:
357: --
358: PROCEDURE Validate_issue_group_type_code (
359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
360: p_issue_group_type_code IN VARCHAR2,
361: x_return_status OUT VARCHAR2,
362: x_msg_count OUT NUMBER,
363: x_msg_data OUT VARCHAR2) IS

Line 376: IF FND_API.to_Boolean( p_init_msg_list ) THEN

372:
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

Line 381: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
382:
383: IF (p_issue_group_type_code is NOT NULL) and
384: (p_issue_group_type_code <> FND_API.G_MISS_CHAR) THEN
385:

Line 384: (p_issue_group_type_code <> FND_API.G_MISS_CHAR) THEN

380: -- Initialize API return status to SUCCESS
381: x_return_status := FND_API.G_RET_STS_SUCCESS;
382:
383: IF (p_issue_group_type_code is NOT NULL) and
384: (p_issue_group_type_code <> FND_API.G_MISS_CHAR) THEN
385:
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:

Line 401: x_return_status := FND_API.G_RET_STS_ERROR;

397: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',
398: p_token2 => 'VALUE',
399: p_token2_value => p_issue_group_type_code);
400:
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,

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',
413: p_token2 => 'VALUE',
414: p_token2_value => p_issue_group_type_code);
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,

Line 433: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

429: --
430: -- NOTES:
431: --
432: PROCEDURE Validate_is_relationship_type (
433: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
434: p_issue_relationship_type IN VARCHAR2,
435: x_return_status OUT VARCHAR2,
436: x_msg_count OUT NUMBER,
437: x_msg_data OUT VARCHAR2) IS

Line 452: IF FND_API.to_Boolean( p_init_msg_list ) THEN

448:
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

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
458:
459: IF (p_issue_relationship_type is NOT NULL) and
460: (p_issue_relationship_type <> FND_API.G_MISS_CHAR) THEN
461:

Line 460: (p_issue_relationship_type <> FND_API.G_MISS_CHAR) THEN

456: -- Initialize API return status to SUCCESS
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459: IF (p_issue_relationship_type is NOT NULL) and
460: (p_issue_relationship_type <> FND_API.G_MISS_CHAR) THEN
461:
462: OPEN C_is_relationship_type_exists (
463: p_issue_relationship_type,
464: 'AS_ISSUE_RELATIONSHIP_TYPE');

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

475: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',
476: p_token2 => 'VALUE',
477: p_token2_value => p_issue_relationship_type);
478:
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,

Line 494: x_return_status := FND_API.G_RET_STS_ERROR;

490: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',
491: p_token2 => 'VALUE',
492: p_token2_value => p_issue_relationship_type);
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,

Line 510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

506: -- PURPOSE
507: -- Checks if country code is valid
508: --
509: PROCEDURE Validate_country_code (
510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
511: p_country_code IN VARCHAR2,
512: x_return_status OUT VARCHAR2,
513: x_msg_count OUT NUMBER,
514: x_msg_data OUT VARCHAR2) IS

Line 525: IF FND_API.to_Boolean( p_init_msg_list ) THEN

521: l_val VARCHAR2(1);
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

Line 530: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
531:
532: IF (p_country_code is NOT NULL) and
533: (p_country_code <> FND_API.G_MISS_CHAR) THEN
534:

Line 533: (p_country_code <> FND_API.G_MISS_CHAR) THEN

529: -- Initialize API return status to SUCCESS
530: x_return_status := FND_API.G_RET_STS_SUCCESS;
531:
532: IF (p_country_code is NOT NULL) and
533: (p_country_code <> FND_API.G_MISS_CHAR) THEN
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

Line 549: x_return_status := FND_API.G_RET_STS_ERROR;

545: p_token1_value => 'COUNTRY_CODE',
546: p_token2 => 'VALUE',
547: p_token2_value => p_country_code);
548:
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,

Line 564: x_return_status := FND_API.G_RET_STS_ERROR;

560: p_token1_value => 'COUNTRY_CODE',
561: p_token2 => 'VALUE',
562: p_token2_value => p_country_code);
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,

Line 580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

576: -- PURPOSE
577: -- Checks if currency code is valid
578: --
579: PROCEDURE Validate_currency_code (
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_currency_code IN VARCHAR2,
582: x_return_status OUT VARCHAR2,
583: x_msg_count OUT NUMBER,
584: x_msg_data OUT VARCHAR2) IS

Line 595: IF FND_API.to_Boolean( p_init_msg_list ) THEN

591: l_val VARCHAR2(1);
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

Line 600: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
601:
602: IF (p_currency_code is NOT NULL) and
603: (p_currency_code <> FND_API.G_MISS_CHAR) THEN
604:

Line 603: (p_currency_code <> FND_API.G_MISS_CHAR) THEN

599: -- Initialize API return status to SUCCESS
600: x_return_status := FND_API.G_RET_STS_SUCCESS;
601:
602: IF (p_currency_code is NOT NULL) and
603: (p_currency_code <> FND_API.G_MISS_CHAR) THEN
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

Line 619: x_return_status := FND_API.G_RET_STS_ERROR;

615: p_token1_value => 'CURRENCY_CODE',
616: p_token2 => 'VALUE',
617: p_token2_value => p_currency_code);
618:
619: x_return_status := FND_API.G_RET_STS_ERROR;
620: END IF;
621: CLOSE C_currency_code_exists;
622: END IF;
623: