DBA Data[Home] [Help]

APPS.AS_ISSUE_UTIL_PVT dependencies on AS_UTILITY_PVT

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 55: AS_UTILITY_PVT.Set_Message(

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,
57: p_msg_name => 'API_INVALID_ID',
58: p_token1 => 'COLUMN',
59: p_token1_value => 'PARTY_ID',

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 70: AS_UTILITY_PVT.Set_Message(

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,
72: p_msg_name => 'API_INVALID_ID',
73: p_token1 => 'COLUMN',
74: p_token1_value => 'PARTY_ID',

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 131: AS_UTILITY_PVT.Set_Message(

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,
133: p_msg_name => 'API_INVALID_ID',
134: p_token1 => 'COLUMN',
135: p_token1_value => 'CONTACT_ROLE_CODE',

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 193: AS_UTILITY_PVT.Set_Message(

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,
195: p_msg_name => 'API_INVALID_ID',
196: p_token1 => 'COLUMN',
197: p_token1_value => 'STRATEGY',

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 256: AS_UTILITY_PVT.Set_Message(

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,
258: p_msg_name => 'API_INVALID_ID',
259: p_token1 => 'COLUMN',
260: p_token1_value => 'ISSUE_SCHEME',

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 319: AS_UTILITY_PVT.Set_Message(

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,
321: p_msg_name => 'API_INVALID_ID',
322: p_token1 => 'COLUMN',
323: p_token1_value => 'ISSUE_TYPE',

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 334: AS_UTILITY_PVT.Set_Message(

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,
336: p_msg_name => 'API_INVALID_ID',
337: p_token1 => 'COLUMN',
338: p_token1_value => 'ISSUE_TYPE',

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 393: AS_UTILITY_PVT.Set_Message(

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,
395: p_msg_name => 'API_INVALID_ID',
396: p_token1 => 'COLUMN',
397: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',

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 408: AS_UTILITY_PVT.Set_Message(

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,
410: p_msg_name => 'API_INVALID_ID',
411: p_token1 => 'COLUMN',
412: p_token1_value => 'ISSUE_GROUP_TYPE_CODE',

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 471: AS_UTILITY_PVT.Set_Message(

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,
473: p_msg_name => 'API_INVALID_ID',
474: p_token1 => 'COLUMN',
475: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',

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 486: AS_UTILITY_PVT.Set_Message(

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,
488: p_msg_name => 'API_INVALID_ID',
489: p_token1 => 'COLUMN',
490: p_token1_value => 'ISSUE_RELATIONSHIP_TYPE',

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 541: AS_UTILITY_PVT.Set_Message(

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,
543: p_msg_name => 'API_INVALID_ID',
544: p_token1 => 'COLUMN',
545: p_token1_value => 'COUNTRY_CODE',

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 556: AS_UTILITY_PVT.Set_Message(

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,
558: p_msg_name => 'API_INVALID_ID',
559: p_token1 => 'COLUMN',
560: p_token1_value => 'COUNTRY_CODE',

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 611: AS_UTILITY_PVT.Set_Message(

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,
613: p_msg_name => 'API_INVALID_ID',
614: p_token1 => 'COLUMN',
615: p_token1_value => 'CURRENCY_CODE',