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

Line 52: FND_MSG_PUB.initialize;

48:
49: -- Initialize message list if p_init_msg_list is set to TRUE.
50: IF FND_API.to_Boolean( p_init_msg_list )
51: THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55:
56: -- Debug Message

Line 57: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

53: END IF;
54:
55:
56: -- Debug Message
57: AS_UTILITY_PVT.Debug_Message(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 71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

67: -- Validate Environment
68: -- ******************************************************************
69: IF FND_GLOBAL.User_Id IS NULL
70: THEN
71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
72: THEN
73: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
74: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
75: FND_MSG_PUB.ADD;

Line 75: FND_MSG_PUB.ADD;

71: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
72: THEN
73: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
74: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
75: FND_MSG_PUB.ADD;
76: END IF;
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79:

Line 101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_rs_cust_relation');

97:
98: END IF;
99: */
100: -- Debug message
101: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_rs_cust_relation');
102:
103: -- Invoke validation procedures
104: Validate_rs_cust_relation(
105: p_init_msg_list => FND_API.G_FALSE,

Line 120: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

116:
117: -- Hint: Add corresponding Master-Detail business logic here if necessary.
118:
119: -- Debug Message
120: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
121:
122: -- Invoke table handler(CSP_RS_CUST_RELATIONS_PKG.Insert_Row)
123: CSP_RS_CUST_RELATIONS_PKG.Insert_Row(
124: px_RS_CUST_RELATION_ID => x_RS_CUST_RELATION_ID,

Line 168: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

164: END IF;
165:
166:
167: -- Debug Message
168: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
169:
170:
171: -- Standard call to get message count and if count is 1, get message info.
172: FND_MSG_PUB.Count_And_Get

Line 172: FND_MSG_PUB.Count_And_Get

168: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
169:
170:
171: -- Standard call to get message count and if count is 1, get message info.
172: FND_MSG_PUB.Count_And_Get
173: ( p_count => x_msg_count,
174: p_data => x_msg_data
175: );
176:

Line 182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

178: WHEN FND_API.G_EXC_ERROR THEN
179: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
180: P_API_NAME => L_API_NAME
181: ,P_PKG_NAME => G_PKG_NAME
182: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
183: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
184: ,X_MSG_COUNT => X_MSG_COUNT
185: ,X_MSG_DATA => X_MSG_DATA
186: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 192: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
189: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
190: P_API_NAME => L_API_NAME
191: ,P_PKG_NAME => G_PKG_NAME
192: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
193: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
194: ,X_MSG_COUNT => X_MSG_COUNT
195: ,X_MSG_DATA => X_MSG_DATA
196: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 282: FND_MSG_PUB.initialize;

278:
279: -- Initialize message list if p_init_msg_list is set to TRUE.
280: IF FND_API.to_Boolean( p_init_msg_list )
281: THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284:
285:
286: -- Debug Message

Line 287: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

283: END IF;
284:
285:
286: -- Debug Message
287: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
288:
289:
290: -- Initialize API return status to SUCCESS
291: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 317: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');

313:
314: END IF;
315: */
316: -- Debug Message
317: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
318:
319: /*
320: Open C_Get_rs_cust_relation( l_tar_RCR_rec.RS_CUST_RELATION_ID);
321:

Line 351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

347: l_ref_RCR_rec.ATTRIBUTE14,
348: l_ref_RCR_rec.ATTRIBUTE15;
349:
350: If ( C_Get_rs_cust_relation%NOTFOUND) Then
351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
352: THEN
353: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
354: FND_MESSAGE.Set_Token ('INFO', 'rs_cust_relation', FALSE);
355: FND_MSG_PUB.Add;

Line 355: FND_MSG_PUB.Add;

351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
352: THEN
353: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
354: FND_MESSAGE.Set_Token ('INFO', 'rs_cust_relation', FALSE);
355: FND_MSG_PUB.Add;
356: END IF;
357: Close C_Get_rs_cust_relation;
358: raise FND_API.G_EXC_ERROR;
359: END IF;

Line 361: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

357: Close C_Get_rs_cust_relation;
358: raise FND_API.G_EXC_ERROR;
359: END IF;
360: -- Debug Message
361: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
362: Close C_Get_rs_cust_relation;
363: */
364:
365:

Line 368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

364:
365:
366: If (l_tar_RCR_rec.last_update_date is NULL or
367: l_tar_RCR_rec.last_update_date = FND_API.G_MISS_Date ) Then
368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
369: THEN
370: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
371: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
372: FND_MSG_PUB.ADD;

Line 372: FND_MSG_PUB.ADD;

368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
369: THEN
370: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
371: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
372: FND_MSG_PUB.ADD;
373: END IF;
374: raise FND_API.G_EXC_ERROR;
375: End if;
376: -- Check Whether record has been changed by someone else

Line 378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

374: raise FND_API.G_EXC_ERROR;
375: End if;
376: -- Check Whether record has been changed by someone else
377: If (l_tar_RCR_rec.last_update_date <> l_ref_RCR_rec.last_update_date) Then
378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
379: THEN
380: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
381: FND_MESSAGE.Set_Token('INFO', 'rs_cust_relation', FALSE);
382: FND_MSG_PUB.ADD;

Line 382: FND_MSG_PUB.ADD;

378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
379: THEN
380: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
381: FND_MESSAGE.Set_Token('INFO', 'rs_cust_relation', FALSE);
382: FND_MSG_PUB.ADD;
383: END IF;
384: raise FND_API.G_EXC_ERROR;
385: End if;
386:

Line 388: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_rs_cust_relation');

384: raise FND_API.G_EXC_ERROR;
385: End if;
386:
387: -- Debug message
388: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_rs_cust_relation');
389:
390: -- Invoke validation procedures
391: Validate_rs_cust_relation(
392: p_init_msg_list => FND_API.G_FALSE,

Line 407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

403:
404: -- Hint: Add corresponding Master-Detail business logic here if necessary.
405:
406: -- Debug Message
407: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
408:
409: -- Invoke table handler(CSP_RS_CUST_RELATIONS_PKG.Update_Row)
410: CSP_RS_CUST_RELATIONS_PKG.Update_Row(
411: p_RS_CUST_RELATION_ID => p_RCR_rec.RS_CUST_RELATION_ID,

Line 448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

444: END IF;
445:
446:
447: -- Debug Message
448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
449:
450:
451: -- Standard call to get message count and if count is 1, get message info.
452: FND_MSG_PUB.Count_And_Get

Line 452: FND_MSG_PUB.Count_And_Get

448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
449:
450:
451: -- Standard call to get message count and if count is 1, get message info.
452: FND_MSG_PUB.Count_And_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456:

Line 462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

458: WHEN FND_API.G_EXC_ERROR THEN
459: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
460: P_API_NAME => L_API_NAME
461: ,P_PKG_NAME => G_PKG_NAME
462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
463: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
464: ,X_MSG_COUNT => X_MSG_COUNT
465: ,X_MSG_DATA => X_MSG_DATA
466: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 472: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
469: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
470: P_API_NAME => L_API_NAME
471: ,P_PKG_NAME => G_PKG_NAME
472: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
473: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
474: ,X_MSG_COUNT => X_MSG_COUNT
475: ,X_MSG_DATA => X_MSG_DATA
476: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 527: FND_MSG_PUB.initialize;

523:
524: -- Initialize message list if p_init_msg_list is set to TRUE.
525: IF FND_API.to_Boolean( p_init_msg_list )
526: THEN
527: FND_MSG_PUB.initialize;
528: END IF;
529:
530:
531: -- Debug Message

Line 532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

528: END IF;
529:
530:
531: -- Debug Message
532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
533:
534:
535: -- Initialize API return status to SUCCESS
536: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

559: END IF;
560: */
561:
562: -- Debug Message
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
564:
565: -- Invoke table handler(CSP_RS_CUST_RELATIONS_PKG.Delete_Row)
566: CSP_RS_CUST_RELATIONS_PKG.Delete_Row(
567: p_RS_CUST_RELATION_ID => p_RCR_rec.RS_CUST_RELATION_ID);

Line 580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

576: END IF;
577:
578:
579: -- Debug Message
580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
581:
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get

Line 584: FND_MSG_PUB.Count_And_Get

580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
581:
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get
585: ( p_count => x_msg_count,
586: p_data => x_msg_data
587: );
588:

Line 594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

590: WHEN FND_API.G_EXC_ERROR THEN
591: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
592: P_API_NAME => L_API_NAME
593: ,P_PKG_NAME => G_PKG_NAME
594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
595: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
596: ,X_MSG_COUNT => X_MSG_COUNT
597: ,X_MSG_DATA => X_MSG_DATA
598: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
602: P_API_NAME => L_API_NAME
603: ,P_PKG_NAME => G_PKG_NAME
604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
605: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
606: ,X_MSG_COUNT => X_MSG_COUNT
607: ,X_MSG_DATA => X_MSG_DATA
608: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');

628: )
629: IS
630: BEGIN
631: -- Debug Message
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
633:
634: -- define all columns for CSP_RS_CUST_RELATIONS view
635: dbms_sql.define_column(p_cur_get_RCR, 1, P_RCR_Rec.RS_CUST_RELATION_ID);
636: dbms_sql.define_column(p_cur_get_RCR, 2, P_RCR_Rec.RESOURCE_TYPE, 30);

Line 657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');

653: dbms_sql.define_column(p_cur_get_RCR, 20, P_RCR_Rec.ATTRIBUTE14, 150);
654: dbms_sql.define_column(p_cur_get_RCR, 21, P_RCR_Rec.ATTRIBUTE15, 150);
655:
656: -- Debug Message
657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
658: END Define_Columns;
659:
660: -- This procudure gets column values by the Dynamic SQL.
661: PROCEDURE Get_Column_Values(

Line 668: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');

664: )
665: IS
666: BEGIN
667: -- Debug Message
668: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
669:
670: -- get all column values for CSP_RS_CUST_RELATIONS table
671: dbms_sql.column_value(p_cur_get_RCR, 1, X_RCR_Rec.RS_CUST_RELATION_ID);
672: dbms_sql.column_value(p_cur_get_RCR, 2, X_RCR_Rec.RESOURCE_TYPE);

Line 693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');

689: dbms_sql.column_value(p_cur_get_RCR, 20, X_RCR_Rec.ATTRIBUTE14);
690: dbms_sql.column_value(p_cur_get_RCR, 21, X_RCR_Rec.ATTRIBUTE15);
691:
692: -- Debug Message
693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
694: END Get_Column_Values;
695:
696: PROCEDURE Gen_RCR_order_cl(
697: p_order_by_rec IN CSP_RS_CUST_RELATION_PUB.RCR_sort_rec_type,

Line 708: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');

704: l_order_by_cl VARCHAR2(1000) := NULL;
705: l_util_order_by_tbl AS_UTILITY_PVT.Util_order_by_tbl_type;
706: BEGIN
707: -- Debug Message
708: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Begins');
709:
710: -- Hint: Developer should add more statements according to CSP_sort_rec_type
711: -- Ex:
712: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;

Line 716: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke AS_UTILITY_PVT.Translate_OrderBy');

712: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
713: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
714:
715: -- Debug Message
716: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Invoke AS_UTILITY_PVT.Translate_OrderBy');
717:
718: AS_UTILITY_PVT.Translate_OrderBy(
719: p_api_version_number => 1.0
720: ,p_init_msg_list => FND_API.G_FALSE

Line 735: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');

731: x_order_by_cl := NULL;
732: END IF;
733:
734: -- Debug Message
735: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Order by Ends');
736: END Gen_RCR_order_cl;
737:
738: -- This procedure bind the variables for the Dynamic SQL
739: PROCEDURE Bind(

Line 749: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');

745: BEGIN
746: -- Bind variables
747: -- Only those that are not NULL
748: -- Debug Message
749: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
750:
751: -- The following example applies to all columns,
752: -- developers can copy and paste them.
753: IF( (P_RCR_Rec.RS_CUST_RELATION_ID IS NOT NULL) AND (P_RCR_Rec.RS_CUST_RELATION_ID <> FND_API.G_MISS_NUM) )

Line 759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');

755: DBMS_SQL.BIND_VARIABLE(p_cur_get_RCR, ':p_RS_CUST_RELATION_ID', P_RCR_Rec.RS_CUST_RELATION_ID);
756: END IF;
757:
758: -- Debug Message
759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
760: END Bind;
761:
762: PROCEDURE Gen_Select(
763: x_select_cl OUT NOCOPY VARCHAR2

Line 768: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');

764: )
765: IS
766: BEGIN
767: -- Debug Message
768: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
769:
770: x_select_cl := 'Select ' ||
771: 'CSP_RS_CUST_RELATIONS.RS_CUST_RELATION_ID,' ||
772: 'CSP_RS_CUST_RELATIONS.RESOURCE_TYPE,' ||

Line 798: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');

794: 'CSP_RS_CUST_RELATIONS.ATTRIBUTE14,' ||
795: 'CSP_RS_CUST_RELATIONS.ATTRIBUTE15 ' ||
796: 'from CSP_RS_CUST_RELATIONS';
797: -- Debug Message
798: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
799:
800: END Gen_Select;
801:
802: PROCEDURE Gen_RCR_Where(

Line 822: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');

818: str_csr2 NUMBER;
819: l_operator VARCHAR2(10);
820: BEGIN
821: -- Debug Message
822: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
823:
824: -- There are three examples for each kind of datatype:
825: -- NUMBER, DATE, VARCHAR2.
826: -- Developer can copy and paste the following codes for your own record.

Line 908: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');

904:
905: -- Add more IF statements for each column below
906:
907: -- Debug Message
908: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
909:
910: END Gen_RCR_Where;
911:
912:

Line 929: FND_MSG_PUB.initialize;

925:
926: -- Initialize message list if p_init_msg_list is set to TRUE.
927: IF FND_API.to_Boolean( p_init_msg_list )
928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931:
932:
933: -- Initialize API return status to SUCCESS

Line 960: FND_MSG_PUB.Count_And_Get

956: NULL;
957: END IF;
958:
959: -- Standard call to get message count and if count is 1, get message info.
960: FND_MSG_PUB.Count_And_Get
961: ( p_count => x_msg_count,
962: p_data => x_msg_data
963: );
964:

Line 983: FND_MSG_PUB.initialize;

979:
980: -- Initialize message list if p_init_msg_list is set to TRUE.
981: IF FND_API.to_Boolean( p_init_msg_list )
982: THEN
983: FND_MSG_PUB.initialize;
984: END IF;
985:
986:
987: -- Initialize API return status to SUCCESS

Line 1014: FND_MSG_PUB.Count_And_Get

1010: NULL;
1011: END IF;
1012:
1013: -- Standard call to get message count and if count is 1, get message info.
1014: FND_MSG_PUB.Count_And_Get
1015: ( p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018:

Line 1037: FND_MSG_PUB.initialize;

1033:
1034: -- Initialize message list if p_init_msg_list is set to TRUE.
1035: IF FND_API.to_Boolean( p_init_msg_list )
1036: THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040:
1041: -- Initialize API return status to SUCCESS

Line 1068: FND_MSG_PUB.Count_And_Get

1064: NULL;
1065: END IF;
1066:
1067: -- Standard call to get message count and if count is 1, get message info.
1068: FND_MSG_PUB.Count_And_Get
1069: ( p_count => x_msg_count,
1070: p_data => x_msg_data
1071: );
1072:

Line 1091: FND_MSG_PUB.initialize;

1087:
1088: -- Initialize message list if p_init_msg_list is set to TRUE.
1089: IF FND_API.to_Boolean( p_init_msg_list )
1090: THEN
1091: FND_MSG_PUB.initialize;
1092: END IF;
1093:
1094:
1095: -- Initialize API return status to SUCCESS

Line 1122: FND_MSG_PUB.Count_And_Get

1118: NULL;
1119: END IF;
1120:
1121: -- Standard call to get message count and if count is 1, get message info.
1122: FND_MSG_PUB.Count_And_Get
1123: ( p_count => x_msg_count,
1124: p_data => x_msg_data
1125: );
1126:

Line 1148: FND_MSG_PUB.initialize;

1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )
1147: THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151:
1152: -- Initialize API return status to SUCCESS

Line 1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1157: -- THEN
1158: -- x_return_status := FND_API.G_RET_STS_ERROR;
1159:
1160: -- Debug Message
1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get
1165: ( p_count => x_msg_count,

Line 1164: FND_MSG_PUB.Count_And_Get

1160: -- Debug Message
1161: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1162:
1163: -- Standard call to get message count and if count is 1, get message info.
1164: FND_MSG_PUB.Count_And_Get
1165: ( p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168:

Line 1185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

1181: l_api_name CONSTANT VARCHAR2(30) := 'Validate_rs_cust_relation';
1182: BEGIN
1183:
1184: -- Debug Message
1185: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1186:
1187:
1188: -- Initialize API return status to SUCCESS
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

1268: END IF;
1269:
1270:
1271: -- Debug Message
1272: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1273:
1274: END Validate_rs_cust_relation;
1275:
1276: End CSP_RS_CUST_RELATION_PVT;