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.ASO_PARTY_RLTSHIP_PVT dependencies on ASO_UTILITY_PVT

Line 57: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

53: END IF;
54:
55:
56: -- Debug Message
57: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
58:
59:
60: -- Initialize API return status to SUCCESS
61: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 85: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_party_rltship');

81:
82: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
83: THEN
84: -- Debug message
85: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_party_rltship');
86:
87: -- Invoke validation procedures
88: Validate_party_rltship(
89: p_init_msg_list => FND_API.G_FALSE,

Line 91: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,

87: -- Invoke validation procedures
88: Validate_party_rltship(
89: p_init_msg_list => FND_API.G_FALSE,
90: p_validation_level => p_validation_level,
91: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,
92: P_PARTY_RLTSHIP_Rec => P_PARTY_RLTSHIP_Rec,
93: x_return_status => x_return_status,
94: x_msg_count => x_msg_count,
95: x_msg_data => x_msg_data);

Line 105: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

101:
102: -- Hint: Add corresponding Master-Detail business logic here if necessary.
103:
104: -- Debug Message
105: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
106:
107: -- Invoke table handler(ASO_PARTY_RELATIONSHIPS_PKG.Insert_Row)
108: ASO_PARTY_RELATIONSHIPS_PKG.Insert_Row(
109: px_PARTY_RELATIONSHIP_ID => x_PARTY_RELATIONSHIP_ID,

Line 143: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

139: END IF;
140:
141:
142: -- Debug Message
143: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
144:
145:
146: -- Standard call to get message count and if count is 1, get message info.
147: FND_MSG_PUB.Count_And_Get

Line 155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

151:
152: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 159: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

155: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
159: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:

Line 165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 169: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

165: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
169: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
170: ,X_MSG_COUNT => X_MSG_COUNT
171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:

Line 175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

171: ,X_MSG_DATA => X_MSG_DATA
172: ,X_RETURN_STATUS => X_RETURN_STATUS);
173:
174: WHEN OTHERS THEN
175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

174: WHEN OTHERS THEN
175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
180: ,X_MSG_COUNT => X_MSG_COUNT
181: ,X_MSG_DATA => X_MSG_DATA
182: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

175: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
176: P_API_NAME => L_API_NAME
177: ,P_PKG_NAME => G_PKG_NAME
178: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
179: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
180: ,X_MSG_COUNT => X_MSG_COUNT
181: ,X_MSG_DATA => X_MSG_DATA
182: ,X_RETURN_STATUS => X_RETURN_STATUS);
183: End Create_party_rltship;

Line 250: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

246: END IF;
247:
248:
249: -- Debug Message
250: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
251:
252:
253: -- Initialize API return status to SUCCESS
254: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 290: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

286: END IF;
287: raise FND_API.G_EXC_ERROR;
288: END IF;
289: -- Debug Message
290: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
291: Close C_Get_party_rltship;
292:
293:
294: If (l_tar_PARTY_RLTSHIP_rec.last_update_date is NULL or

Line 318: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_party_rltship');

314:
315: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
316: THEN
317: -- Debug message
318: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_party_rltship');
319:
320: -- Invoke validation procedures
321: Validate_party_rltship(
322: p_init_msg_list => FND_API.G_FALSE,

Line 324: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,

320: -- Invoke validation procedures
321: Validate_party_rltship(
322: p_init_msg_list => FND_API.G_FALSE,
323: p_validation_level => p_validation_level,
324: p_validation_mode => ASO_UTILITY_PVT.G_UPDATE,
325: P_PARTY_RLTSHIP_Rec => P_PARTY_RLTSHIP_Rec,
326: x_return_status => x_return_status,
327: x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data);

Line 337: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

333: END IF;
334:
335:
336: -- Debug Message
337: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
338:
339: -- Invoke table handler(ASO_PARTY_RELATIONSHIPS_PKG.Update_Row)
340: ASO_PARTY_RELATIONSHIPS_PKG.Update_Row(
341: p_PARTY_RELATIONSHIP_ID => p_PARTY_RLTSHIP_rec.PARTY_RELATIONSHIP_ID,

Line 369: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

365: END IF;
366:
367:
368: -- Debug Message
369: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
370:
371:
372: -- Standard call to get message count and if count is 1, get message info.
373: FND_MSG_PUB.Count_And_Get

Line 381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

377:
378: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
385: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 385: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

381: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
382: P_API_NAME => L_API_NAME
383: ,P_PKG_NAME => G_PKG_NAME
384: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
385: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
386: ,X_MSG_COUNT => X_MSG_COUNT
387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:

Line 391: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

387: ,X_MSG_DATA => X_MSG_DATA
388: ,X_RETURN_STATUS => X_RETURN_STATUS);
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
395: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 395: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

391: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
392: P_API_NAME => L_API_NAME
393: ,P_PKG_NAME => G_PKG_NAME
394: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
395: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
396: ,X_MSG_COUNT => X_MSG_COUNT
397: ,X_MSG_DATA => X_MSG_DATA
398: ,X_RETURN_STATUS => X_RETURN_STATUS);
399:

Line 401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

397: ,X_MSG_DATA => X_MSG_DATA
398: ,X_RETURN_STATUS => X_RETURN_STATUS);
399:
400: WHEN OTHERS THEN
401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 404: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

400: WHEN OTHERS THEN
401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

401: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
402: P_API_NAME => L_API_NAME
403: ,P_PKG_NAME => G_PKG_NAME
404: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
405: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
406: ,X_MSG_COUNT => X_MSG_COUNT
407: ,X_MSG_DATA => X_MSG_DATA
408: ,X_RETURN_STATUS => X_RETURN_STATUS);
409: End Update_party_rltship;

Line 451: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

447: END IF;
448:
449:
450: -- Debug Message
451: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
452:
453:
454: -- Initialize API return status to SUCCESS
455: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 476: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

472: END IF;
473:
474:
475: -- Debug Message
476: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
477:
478:
479: -- Standard call to get message count and if count is 1, get message info.
480: FND_MSG_PUB.Count_And_Get

Line 488: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

484:
485: -- Un-comment the following statements when AS_CALLOUT_PKG is ready.
486: EXCEPTION
487: WHEN FND_API.G_EXC_ERROR THEN
488: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
489: P_API_NAME => L_API_NAME
490: ,P_PKG_NAME => G_PKG_NAME
491: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
492: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 492: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

488: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
489: P_API_NAME => L_API_NAME
490: ,P_PKG_NAME => G_PKG_NAME
491: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
492: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
493: ,X_MSG_COUNT => X_MSG_COUNT
494: ,X_MSG_DATA => X_MSG_DATA
495: ,X_RETURN_STATUS => X_RETURN_STATUS);
496:

Line 498: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

494: ,X_MSG_DATA => X_MSG_DATA
495: ,X_RETURN_STATUS => X_RETURN_STATUS);
496:
497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
498: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
499: P_API_NAME => L_API_NAME
500: ,P_PKG_NAME => G_PKG_NAME
501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
502: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 502: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

498: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
499: P_API_NAME => L_API_NAME
500: ,P_PKG_NAME => G_PKG_NAME
501: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
502: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
503: ,X_MSG_COUNT => X_MSG_COUNT
504: ,X_MSG_DATA => X_MSG_DATA
505: ,X_RETURN_STATUS => X_RETURN_STATUS);
506:

Line 508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

504: ,X_MSG_DATA => X_MSG_DATA
505: ,X_RETURN_STATUS => X_RETURN_STATUS);
506:
507: WHEN OTHERS THEN
508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 511: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

507: WHEN OTHERS THEN
508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MSG_DATA
515: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

508: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
509: P_API_NAME => L_API_NAME
510: ,P_PKG_NAME => G_PKG_NAME
511: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
512: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
513: ,X_MSG_COUNT => X_MSG_COUNT
514: ,X_MSG_DATA => X_MSG_DATA
515: ,X_RETURN_STATUS => X_RETURN_STATUS);
516:

Line 547: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(PARTY_RELATIONSHIP_ID)');

543:
544: -- validate NOT NULL column
545: IF(p_PARTY_RELATIONSHIP_ID is NULL)
546: THEN
547: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(PARTY_RELATIONSHIP_ID)');
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;
550:
551: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 551: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

547: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(PARTY_RELATIONSHIP_ID)');
548: x_return_status := FND_API.G_RET_STS_ERROR;
549: END IF;
550:
551: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
552: THEN
553: -- Hint: Validate data
554: -- IF p_PARTY_RELATIONSHIP_ID is not NULL and p_PARTY_RELATIONSHIP_ID <> G_MISS_CHAR
555: -- verify if data is valid

Line 558: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

554: -- IF p_PARTY_RELATIONSHIP_ID is not NULL and p_PARTY_RELATIONSHIP_ID <> G_MISS_CHAR
555: -- verify if data is valid
556: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
557: NULL;
558: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
559: THEN
560: -- Hint: Validate data
561: -- IF p_PARTY_RELATIONSHIP_ID <> G_MISS_CHAR
562: -- verify if data is valid

Line 597: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

593:
594: -- Initialize API return status to SUCCESS
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
598: THEN
599: -- Hint: Validate data
600: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
601: -- verify if data is valid

Line 604: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

600: -- IF p_REQUEST_ID is not NULL and p_REQUEST_ID <> G_MISS_CHAR
601: -- verify if data is valid
602: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
603: NULL;
604: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
605: THEN
606: -- Hint: Validate data
607: -- IF p_REQUEST_ID <> G_MISS_CHAR
608: -- verify if data is valid

Line 643: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

639:
640: -- Initialize API return status to SUCCESS
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
644: THEN
645: -- Hint: Validate data
646: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
647: -- verify if data is valid

Line 650: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

646: -- IF p_PROGRAM_APPLICATION_ID is not NULL and p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
647: -- verify if data is valid
648: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
649: NULL;
650: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
651: THEN
652: -- Hint: Validate data
653: -- IF p_PROGRAM_APPLICATION_ID <> G_MISS_CHAR
654: -- verify if data is valid

Line 689: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

685:
686: -- Initialize API return status to SUCCESS
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688:
689: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
690: THEN
691: -- Hint: Validate data
692: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
693: -- verify if data is valid

Line 696: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

692: -- IF p_PROGRAM_ID is not NULL and p_PROGRAM_ID <> G_MISS_CHAR
693: -- verify if data is valid
694: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
695: NULL;
696: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
697: THEN
698: -- Hint: Validate data
699: -- IF p_PROGRAM_ID <> G_MISS_CHAR
700: -- verify if data is valid

Line 735: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

731:
732: -- Initialize API return status to SUCCESS
733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734:
735: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
736: THEN
737: -- Hint: Validate data
738: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
739: -- verify if data is valid

Line 742: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

738: -- IF p_PROGRAM_UPDATE_DATE is not NULL and p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
739: -- verify if data is valid
740: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
741: NULL;
742: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
743: THEN
744: -- Hint: Validate data
745: -- IF p_PROGRAM_UPDATE_DATE <> G_MISS_CHAR
746: -- verify if data is valid

Line 781: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

777:
778: -- Initialize API return status to SUCCESS
779: x_return_status := FND_API.G_RET_STS_SUCCESS;
780:
781: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
782: THEN
783: -- Hint: Validate data
784: -- IF p_QUOTE_OBJECT_TYPE is not NULL and p_QUOTE_OBJECT_TYPE <> G_MISS_CHAR
785: -- verify if data is valid

Line 788: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

784: -- IF p_QUOTE_OBJECT_TYPE is not NULL and p_QUOTE_OBJECT_TYPE <> G_MISS_CHAR
785: -- verify if data is valid
786: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
787: NULL;
788: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
789: THEN
790: -- Hint: Validate data
791: -- IF p_QUOTE_OBJECT_TYPE <> G_MISS_CHAR
792: -- verify if data is valid

Line 827: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

823:
824: -- Initialize API return status to SUCCESS
825: x_return_status := FND_API.G_RET_STS_SUCCESS;
826:
827: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
828: THEN
829: -- Hint: Validate data
830: -- IF p_QUOTE_OBJECT_ID is not NULL and p_QUOTE_OBJECT_ID <> G_MISS_CHAR
831: -- verify if data is valid

Line 834: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

830: -- IF p_QUOTE_OBJECT_ID is not NULL and p_QUOTE_OBJECT_ID <> G_MISS_CHAR
831: -- verify if data is valid
832: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
833: NULL;
834: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
835: THEN
836: -- IF p_QUOTE_OBJECT_ID <> G_MISS_CHAR
837: -- verify if data is valid
838: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line 875: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');

871:
872: -- validate NOT NULL column
873: IF(p_RELATIONSHIP_TYPE_CODE is NULL)
874: THEN
875: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');
876: x_return_status := FND_API.G_RET_STS_ERROR;
877: END IF;
878:
879: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 879: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

875: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(RELATIONSHIP_TYPE_CODE)');
876: x_return_status := FND_API.G_RET_STS_ERROR;
877: END IF;
878:
879: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
880: THEN
881: -- Hint: Validate data
882: -- IF p_RELATIONSHIP_TYPE_CODE is not NULL and p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
883: -- verify if data is valid

Line 886: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

882: -- IF p_RELATIONSHIP_TYPE_CODE is not NULL and p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
883: -- verify if data is valid
884: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
885: NULL;
886: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
887: THEN
888: -- Hint: Validate data
889: -- IF p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
890: -- verify if data is valid

Line 925: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

921:
922: -- Initialize API return status to SUCCESS
923: x_return_status := FND_API.G_RET_STS_SUCCESS;
924:
925: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
926: THEN
927: -- Hint: Validate data
928: -- IF p_RELATED_OBJECT_TYPE_CODE is not NULL and p_RELATED_OBJECT_TYPE_CODE <> G_MISS_CHAR
929: -- verify if data is valid

Line 932: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

928: -- IF p_RELATED_OBJECT_TYPE_CODE is not NULL and p_RELATED_OBJECT_TYPE_CODE <> G_MISS_CHAR
929: -- verify if data is valid
930: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
931: NULL;
932: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
933: THEN
934: -- Hint: Validate data
935: -- IF p_RELATED_OBJECT_TYPE_CODE <> G_MISS_CHAR
936: -- verify if data is valid

Line 971: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

967:
968: -- Initialize API return status to SUCCESS
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970:
971: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
972: THEN
973: -- Hint: Validate data
974: -- IF p_RELATED_OBJECT_ID is not NULL and p_RELATED_OBJECT_ID <> G_MISS_CHAR
975: -- verify if data is valid

Line 978: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

974: -- IF p_RELATED_OBJECT_ID is not NULL and p_RELATED_OBJECT_ID <> G_MISS_CHAR
975: -- verify if data is valid
976: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
977: NULL;
978: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
979: THEN
980: -- Hint: Validate data
981: -- IF p_RELATED_OBJECT_ID <> G_MISS_CHAR
982: -- verify if data is valid

Line 1020: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_HEADER_ID)');

1016:
1017: -- validate NOT NULL column
1018: IF(p_QUOTE_HEADER_ID is NULL)
1019: THEN
1020: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_HEADER_ID)');
1021: x_return_status := FND_API.G_RET_STS_ERROR;
1022: END IF;
1023:
1024: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1024: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1020: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_HEADER_ID)');
1021: x_return_status := FND_API.G_RET_STS_ERROR;
1022: END IF;
1023:
1024: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1025: THEN
1026: -- Hint: Validate data
1027: -- IF p_QUOTE_HEADER_ID is not NULL and p_QUOTE_HEADER_ID <> G_MISS_CHAR
1028: -- verify if data is valid

Line 1031: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1027: -- IF p_QUOTE_HEADER_ID is not NULL and p_QUOTE_HEADER_ID <> G_MISS_CHAR
1028: -- verify if data is valid
1029: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1030: NULL;
1031: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1032: THEN
1033: -- Hint: Validate data
1034: -- IF p_QUOTE_HEADER_ID <> G_MISS_CHAR
1035: -- verify if data is valid

Line 1073: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');

1069:
1070: -- validate NOT NULL column
1071: IF(p_QUOTE_LINE_ID is NULL)
1072: THEN
1073: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: END IF;
1076:
1077: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1077: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1073: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(QUOTE_LINE_ID)');
1074: x_return_status := FND_API.G_RET_STS_ERROR;
1075: END IF;
1076:
1077: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1078: THEN
1079: -- Hint: Validate data
1080: -- IF p_QUOTE_LINE_ID is not NULL and p_QUOTE_LINE_ID <> G_MISS_CHAR
1081: -- verify if data is valid

Line 1084: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1080: -- IF p_QUOTE_LINE_ID is not NULL and p_QUOTE_LINE_ID <> G_MISS_CHAR
1081: -- verify if data is valid
1082: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1083: NULL;
1084: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1085: THEN
1086: -- Hint: Validate data
1087: -- IF p_QUOTE_LINE_ID <> G_MISS_CHAR
1088: -- verify if data is valid

Line 1126: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');

1122:
1123: -- validate NOT NULL column
1124: IF(p_OBJECT_TYPE_CODE is NULL)
1125: THEN
1126: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129:
1130: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1130: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1126: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_TYPE_CODE)');
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129:
1130: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1131: THEN
1132: -- Hint: Validate data
1133: -- IF p_OBJECT_TYPE_CODE is not NULL and p_OBJECT_TYPE_CODE <> G_MISS_CHAR
1134: -- verify if data is valid

Line 1137: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1133: -- IF p_OBJECT_TYPE_CODE is not NULL and p_OBJECT_TYPE_CODE <> G_MISS_CHAR
1134: -- verify if data is valid
1135: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1136: NULL;
1137: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1138: THEN
1139: -- Hint: Validate data
1140: -- IF p_OBJECT_TYPE_CODE <> G_MISS_CHAR
1141: -- verify if data is valid

Line 1179: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_ID)');

1175:
1176: -- validate NOT NULL column
1177: IF(p_OBJECT_ID is NULL)
1178: THEN
1179: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_ID)');
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: END IF;
1182:
1183: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

Line 1183: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)

1179: --ASO_UTILITY_PVT.Print('ERROR', 'Private party_rltship API: -Violate NOT NULL constraint(OBJECT_ID)');
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: END IF;
1182:
1183: IF(p_validation_mode = ASO_UTILITY_PVT.G_CREATE)
1184: THEN
1185: -- Hint: Validate data
1186: -- IF p_OBJECT_ID is not NULL and p_OBJECT_ID <> G_MISS_CHAR
1187: -- verify if data is valid

Line 1190: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)

1186: -- IF p_OBJECT_ID is not NULL and p_OBJECT_ID <> G_MISS_CHAR
1187: -- verify if data is valid
1188: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
1189: NULL;
1190: ELSIF(p_validation_mode = ASO_UTILITY_PVT.G_UPDATE)
1191: THEN
1192: -- Hint: Validate data
1193: -- IF p_OBJECT_ID <> G_MISS_CHAR
1194: -- verify if data is valid

Line 1209: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor

1205: END Validate_OBJECT_ID;
1206:
1207:
1208: -- Hint: inter-field level validation can be added here.
1209: -- Hint: If p_validation_mode = ASO_UTILITY_PVT.G_VALIDATE_UPDATE, we should use cursor
1210: -- to get old values for all fields used in inter-field validation and set all G_MISS_XXX fields to original value
1211: -- stored in database table.
1212: PROCEDURE Validate_PARTY_RLTSHIP_rec(
1213: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

Line 1239: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1235: -- THEN
1236: -- x_return_status := FND_API.G_RET_STS_ERROR;
1237:
1238: -- Debug Message
1239: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1240:
1241: -- Standard call to get message count and if count is 1, get message info.
1242: FND_MSG_PUB.Count_And_Get
1243: ( p_count => x_msg_count,

Line 1263: -- --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1259: l_api_name CONSTANT VARCHAR2(30) := 'Validate_party_rltship';
1260: BEGIN
1261:
1262: -- Debug Message
1263: -- --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1264:
1265:
1266: -- Initialize API return status to SUCCESS
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1269: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

1265:
1266: -- Initialize API return status to SUCCESS
1267: x_return_status := FND_API.G_RET_STS_SUCCESS;
1268:
1269: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
1270: -- Hint: We provide validation procedure for every column. Developer should delete
1271: -- unnecessary validation procedures.
1272: Validate_PARTY_RLTSHIP_ID(
1273: p_init_msg_list => FND_API.G_FALSE,

Line 1430: /* IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD) THEN

1426: END IF;
1427:
1428: END IF;
1429:
1430: /* IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD) THEN
1431: -- Hint: Inter-field level validation can be added here
1432: -- invoke record level validation procedures
1433: Validate_PARTY_RLTSHIP_Rec(
1434: p_init_msg_list => FND_API.G_FALSE,

Line 1446: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD) THEN

1442: raise FND_API.G_EXC_ERROR;
1443: END IF;
1444: END IF;
1445:
1446: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD) THEN
1447: -- invoke inter-record level validation procedures
1448: NULL;
1449: END IF;
1450:

Line 1451: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY) THEN

1447: -- invoke inter-record level validation procedures
1448: NULL;
1449: END IF;
1450:
1451: IF (p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY) THEN
1452: -- invoke inter-entity level validation procedures
1453: NULL;
1454: END IF;
1455:

Line 1458: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1454: END IF;
1455:
1456:
1457: -- Debug Message
1458: --ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1459: */
1460:
1461: END Validate_party_rltship;
1462: