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_REQUIREMENT_HEADERS_PVT dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.initialize;

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

Line 54: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

50: END IF;
51:
52:
53: -- Debug Message
54: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
55:
56:
57: -- Initialize API return status to SUCCESS
58: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 72: FND_MSG_PUB.ADD;

68: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
69: THEN
70: FND_MESSAGE.Set_Name('CSP', 'UT_CANNOT_GET_PROFILE_VALUE');
71: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
72: FND_MSG_PUB.ADD;
73: END IF;
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76: */

Line 95: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_requirement_headers');

91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93: */
94: -- Debug message
95: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_requirement_headers');
96:
97: -- Invoke validation procedures
98: /* Validate_requirement_headers(
99: p_init_msg_list => FND_API.G_FALSE,

Line 112: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');

108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110: */
111: -- Debug Message
112: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling create table handler');
113:
114: x_requirement_header_id := p_requirement_header_rec.requirement_header_id;
115:
116: -- Invoke table handler(CSP_REQUIREMENT_HEADERS_PKG.Insert_Row)

Line 175: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

171: END IF;
172:
173:
174: -- Debug Message
175: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
176:
177:
178: -- Standard call to get message count and if count is 1, get message info.
179: /* FND_MSG_PUB.Count_And_Get

Line 179: /* FND_MSG_PUB.Count_And_Get

175: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
176:
177:
178: -- Standard call to get message count and if count is 1, get message info.
179: /* FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count,
181: p_data => x_msg_data
182: ); */
183:

Line 189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

185: WHEN FND_API.G_EXC_ERROR THEN
186: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
187: P_API_NAME => L_API_NAME
188: ,P_PKG_NAME => G_PKG_NAME
189: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
190: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
191: ,X_MSG_COUNT => X_MSG_COUNT
192: ,X_MSG_DATA => X_MSG_DATA
193: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
199: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
200: ,X_MSG_COUNT => X_MSG_COUNT
201: ,X_MSG_DATA => X_MSG_DATA
202: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 208: FND_MSG_PUB.ADD;

204: Rollback to CREATE_Requirement_headers_PUB;
205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data);
212: x_return_status := FND_API.G_RET_STS_ERROR;

Line 209: fnd_msg_pub.count_and_get

205: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
206: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
207: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
208: FND_MSG_PUB.ADD;
209: fnd_msg_pub.count_and_get
210: ( p_count => x_msg_count
211: , p_data => x_msg_data);
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: End Create_requirement_headers;

Line 289: FND_MSG_PUB.initialize;

285:
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list )
288: THEN
289: FND_MSG_PUB.initialize;
290: END IF;
291:
292:
293: -- Debug Message

Line 294: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

290: END IF;
291:
292:
293: -- Debug Message
294: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
295:
296:
297: -- Initialize API return status to SUCCESS
298: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

320:
321: END IF;
322: */
323: -- Debug Message
324: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
325:
326: /*
327: Open C_Get_requirement_headers( l_tar_REQUIREMENT_HEADER_rec.REQUIREMENT_HEADER_ID);
328:

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

359: l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE14,
360: l_ref_REQUIREMENT_HEADER_rec.ATTRIBUTE15,
361:
362: If ( C_Get_requirement_headers%NOTFOUND) Then
363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
364: THEN
365: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
366: FND_MESSAGE.Set_Token ('INFO', 'requirement_headers', FALSE);
367: FND_MSG_PUB.Add;

Line 367: FND_MSG_PUB.Add;

363: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
364: THEN
365: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_UPDATE_TARGET');
366: FND_MESSAGE.Set_Token ('INFO', 'requirement_headers', FALSE);
367: FND_MSG_PUB.Add;
368: END IF;
369: Close C_Get_requirement_headers;
370: raise FND_API.G_EXC_ERROR;
371: END IF;

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

369: Close C_Get_requirement_headers;
370: raise FND_API.G_EXC_ERROR;
371: END IF;
372: -- Debug Message
373: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
374: Close C_Get_requirement_headers;
375: */
376:
377:

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

376:
377:
378: /* If (l_tar_REQUIREMENT_HEADER_rec.last_update_date is NULL or
379: l_tar_REQUIREMENT_HEADER_rec.last_update_date = FND_API.G_MISS_Date ) Then
380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
381: THEN
382: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
383: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
384: FND_MSG_PUB.ADD;

Line 384: FND_MSG_PUB.ADD;

380: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
381: THEN
382: FND_MESSAGE.Set_Name('CSP', 'API_MISSING_ID');
383: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
384: FND_MSG_PUB.ADD;
385: END IF;
386: raise FND_API.G_EXC_ERROR;
387: End if;
388: -- Check Whether record has been changed by someone else

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

386: raise FND_API.G_EXC_ERROR;
387: End if;
388: -- Check Whether record has been changed by someone else
389: If (l_tar_REQUIREMENT_HEADER_rec.last_update_date <> l_ref_REQUIREMENT_HEADER_rec.last_update_date) Then
390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
393: FND_MESSAGE.Set_Token('INFO', 'requirement_headers', FALSE);
394: FND_MSG_PUB.ADD;

Line 394: FND_MSG_PUB.ADD;

390: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
391: THEN
392: FND_MESSAGE.Set_Name('CSP', 'API_RECORD_CHANGED');
393: FND_MESSAGE.Set_Token('INFO', 'requirement_headers', FALSE);
394: FND_MSG_PUB.ADD;
395: END IF;
396: raise FND_API.G_EXC_ERROR;
397: End if;
398:

Line 400: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_requirement_headers');

396: raise FND_API.G_EXC_ERROR;
397: End if;
398:
399: -- Debug message
400: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: Validate_requirement_headers');
401:
402: -- Invoke validation procedures
403: Validate_requirement_headers(
404: p_init_msg_list => FND_API.G_FALSE,

Line 422: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

418: END IF;
419: */
420:
421: -- Debug Message
422: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
423:
424: -- Invoke table handler(CSP_REQUIREMENT_HEADERS_PKG.Update_Row)
425: CSP_REQUIREMENT_HEADERS_PKG.Update_Row(
426: p_REQUIREMENT_HEADER_ID => p_REQUIREMENT_HEADER_rec.REQUIREMENT_HEADER_ID,

Line 475: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

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

Line 479: FND_MSG_PUB.Count_And_Get

475: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
476:
477:
478: -- Standard call to get message count and if count is 1, get message info.
479: FND_MSG_PUB.Count_And_Get
480: ( p_count => x_msg_count,
481: p_data => x_msg_data
482: );
483:

Line 489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

485: WHEN FND_API.G_EXC_ERROR THEN
486: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
487: P_API_NAME => L_API_NAME
488: ,P_PKG_NAME => G_PKG_NAME
489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
490: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
491: ,X_MSG_COUNT => X_MSG_COUNT
492: ,X_MSG_DATA => X_MSG_DATA
493: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 498: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 508: FND_MSG_PUB.ADD;

504: Rollback to UPDATE_Requirement_headers_PUB;
505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
508: FND_MSG_PUB.ADD;
509: fnd_msg_pub.count_and_get
510: ( p_count => x_msg_count
511: , p_data => x_msg_data);
512: x_return_status := FND_API.G_RET_STS_ERROR;

Line 509: fnd_msg_pub.count_and_get

505: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
506: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
507: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
508: FND_MSG_PUB.ADD;
509: fnd_msg_pub.count_and_get
510: ( p_count => x_msg_count
511: , p_data => x_msg_data);
512: x_return_status := FND_API.G_RET_STS_ERROR;
513: End Update_requirement_headers;

Line 549: FND_MSG_PUB.initialize;

545:
546: -- Initialize message list if p_init_msg_list is set to TRUE.
547: IF FND_API.to_Boolean( p_init_msg_list )
548: THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552:
553: -- Debug Message

Line 554: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');

550: END IF;
551:
552:
553: -- Debug Message
554: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
555:
556:
557: -- Initialize API return status to SUCCESS
558: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 569: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');

565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567:
568: -- Debug Message
569: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling delete table handler');
570:
571: -- Invoke table handler(CSP_REQUIREMENT_HEADERS_PKG.Delete_Row)
572: CSP_REQUIREMENT_HEADERS_PKG.Delete_Row(
573: p_REQUIREMENT_HEADER_ID => p_REQUIREMENT_HEADER_rec.REQUIREMENT_HEADER_ID);

Line 586: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

582: END IF;
583:
584:
585: -- Debug Message
586: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
587:
588:
589: -- Standard call to get message count and if count is 1, get message info.
590: FND_MSG_PUB.Count_And_Get

Line 590: FND_MSG_PUB.Count_And_Get

586: -- JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
587:
588:
589: -- Standard call to get message count and if count is 1, get message info.
590: FND_MSG_PUB.Count_And_Get
591: ( p_count => x_msg_count,
592: p_data => x_msg_data
593: );
594:

Line 600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

596: WHEN FND_API.G_EXC_ERROR THEN
597: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
601: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
602: ,X_MSG_COUNT => X_MSG_COUNT
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
606: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
607: P_API_NAME => L_API_NAME
608: ,P_PKG_NAME => G_PKG_NAME
609: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
610: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
611: ,X_MSG_COUNT => X_MSG_COUNT
612: ,X_MSG_DATA => X_MSG_DATA
613: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 619: FND_MSG_PUB.ADD;

615: Rollback to DELETE_Requirement_headers_PUB;
616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count
622: , p_data => x_msg_data);
623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 620: fnd_msg_pub.count_and_get

616: FND_MESSAGE.SET_NAME('CSP', 'CSP_UNEXPECTED_EXEC_ERRORS');
617: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name, TRUE);
618: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm, TRUE);
619: FND_MSG_PUB.ADD;
620: fnd_msg_pub.count_and_get
621: ( p_count => x_msg_count
622: , p_data => x_msg_data);
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: End Delete_requirement_headers;

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

631: )
632: IS
633: BEGIN
634: -- Debug Message
635: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Begins');
636:
637: -- define all columns for CSP_REQUIREMENT_HEADERS view
638: dbms_sql.define_column(p_cur_get_REQUIREMENT_HEADER, 1, P_REQUIREMENT_HEADER_Rec.REQUIREMENT_HEADER_ID);
639: dbms_sql.define_column(p_cur_get_REQUIREMENT_HEADER, 2, P_REQUIREMENT_HEADER_Rec.OPEN_REQUIREMENT, 240);

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

661: dbms_sql.define_column(p_cur_get_REQUIREMENT_HEADER, 24, P_REQUIREMENT_HEADER_Rec.ATTRIBUTE14, 150);
662: dbms_sql.define_column(p_cur_get_REQUIREMENT_HEADER, 25, P_REQUIREMENT_HEADER_Rec.ATTRIBUTE15, 150);
663:
664: -- Debug Message
665: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Define Columns Ends');
666: END Define_Columns;
667:
668: -- This procudure gets column values by the Dynamic SQL.
669: PROCEDURE Get_Column_Values(

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

672: )
673: IS
674: BEGIN
675: -- Debug Message
676: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Begins');
677:
678: -- get all column values for CSP_REQUIREMENT_HEADERS table
679: dbms_sql.column_value(p_cur_get_REQUIREMENT_HEADER, 1, X_REQUIREMENT_HEADER_Rec.REQUIREMENT_HEADER_ID);
680: dbms_sql.column_value(p_cur_get_REQUIREMENT_HEADER, 2, X_REQUIREMENT_HEADER_Rec.OPEN_REQUIREMENT);

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

702: dbms_sql.column_value(p_cur_get_REQUIREMENT_HEADER, 24, X_REQUIREMENT_HEADER_Rec.ATTRIBUTE14);
703: dbms_sql.column_value(p_cur_get_REQUIREMENT_HEADER, 25, X_REQUIREMENT_HEADER_Rec.ATTRIBUTE15);
704:
705: -- Debug Message
706: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Get Column Values Ends');
707: END Get_Column_Values;
708:
709: -- This procedure bind the variables for the Dynamic SQL
710: PROCEDURE Bind(

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

716: BEGIN
717: -- Bind variables
718: -- Only those that are not NULL
719: -- Debug Message
720: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
721:
722: -- The following example applies to all columns,
723: -- developers can copy and paste them.
724: IF( (P_REQUIREMENT_HEADER_Rec.REQUIREMENT_HEADER_ID IS NOT NULL) AND (P_REQUIREMENT_HEADER_Rec.REQUIREMENT_HEADER_ID <> FND_API.G_MISS_NUM) )

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

726: DBMS_SQL.BIND_VARIABLE(p_cur_get_REQUIREMENT_HEADER, ':p_REQUIREMENT_HEADER_ID', P_REQUIREMENT_HEADER_Rec.REQUIREMENT_HEADER_ID);
727: END IF;
728:
729: -- Debug Message
730: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');
731: END Bind;
732:
733: PROCEDURE Gen_Select(
734: x_select_cl OUT NOCOPY VARCHAR2

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

735: )
736: IS
737: BEGIN
738: -- Debug Message
739: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Begins');
740:
741: x_select_cl := 'Select ' ||
742: 'CSP_REQUIREMENT_HEADERS.REQUIREMENT_HEADER_ID,' ||
743: 'CSP_REQUIREMENT_HEADERS.CREATED_BY,' ||

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

770: 'CSP_REQUIREMENT_HEADERS.ATTRIBUTE14,' ||
771: 'CSP_REQUIREMENT_HEADERS.ATTRIBUTE15,' ||
772: 'from CSP_REQUIREMENT_HEADERS';
773: -- Debug Message
774: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Select Ends');
775:
776: END Gen_Select;
777:
778: PROCEDURE Gen_REQUIREMENT_HEADER_Where(

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

794: str_csr2 NUMBER;
795: l_operator VARCHAR2(10);
796: BEGIN
797: -- Debug Message
798: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Begins');
799:
800: -- There are three examples for each kind of datatype:
801: -- NUMBER, DATE, VARCHAR2.
802: -- Developer can copy and paste the following codes for your own record.

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

880:
881: -- Add more IF statements for each column below
882:
883: -- Debug Message
884: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Generate Where Ends');
885:
886: END Gen_REQUIREMENT_HEADER_Where;
887:
888: -- Item-level validation procedures

Line 904: FND_MSG_PUB.initialize;

900:
901: -- Initialize message list if p_init_msg_list is set to TRUE.
902: IF FND_API.to_Boolean( p_init_msg_list )
903: THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907:
908: -- Initialize API return status to SUCCESS

Line 935: FND_MSG_PUB.Count_And_Get

931: NULL;
932: END IF;
933:
934: -- Standard call to get message count and if count is 1, get message info.
935: FND_MSG_PUB.Count_And_Get
936: ( p_count => x_msg_count,
937: p_data => x_msg_data
938: );
939:

Line 958: FND_MSG_PUB.initialize;

954:
955: -- Initialize message list if p_init_msg_list is set to TRUE.
956: IF FND_API.to_Boolean( p_init_msg_list )
957: THEN
958: FND_MSG_PUB.initialize;
959: END IF;
960:
961:
962: -- Initialize API return status to SUCCESS

Line 982: FND_MSG_PUB.Count_And_Get

978: NULL;
979: END IF;
980:
981: -- Standard call to get message count and if count is 1, get message info.
982: FND_MSG_PUB.Count_And_Get
983: ( p_count => x_msg_count,
984: p_data => x_msg_data
985: );
986:

Line 1005: FND_MSG_PUB.initialize;

1001:
1002: -- Initialize message list if p_init_msg_list is set to TRUE.
1003: IF FND_API.to_Boolean( p_init_msg_list )
1004: THEN
1005: FND_MSG_PUB.initialize;
1006: END IF;
1007:
1008:
1009: -- Initialize API return status to SUCCESS

Line 1029: FND_MSG_PUB.Count_And_Get

1025: NULL;
1026: END IF;
1027:
1028: -- Standard call to get message count and if count is 1, get message info.
1029: FND_MSG_PUB.Count_And_Get
1030: ( p_count => x_msg_count,
1031: p_data => x_msg_data
1032: );
1033:

Line 1052: FND_MSG_PUB.initialize;

1048:
1049: -- Initialize message list if p_init_msg_list is set to TRUE.
1050: IF FND_API.to_Boolean( p_init_msg_list )
1051: THEN
1052: FND_MSG_PUB.initialize;
1053: END IF;
1054:
1055:
1056: -- Initialize API return status to SUCCESS

Line 1076: FND_MSG_PUB.Count_And_Get

1072: NULL;
1073: END IF;
1074:
1075: -- Standard call to get message count and if count is 1, get message info.
1076: FND_MSG_PUB.Count_And_Get
1077: ( p_count => x_msg_count,
1078: p_data => x_msg_data
1079: );
1080:

Line 1099: FND_MSG_PUB.initialize;

1095:
1096: -- Initialize message list if p_init_msg_list is set to TRUE.
1097: IF FND_API.to_Boolean( p_init_msg_list )
1098: THEN
1099: FND_MSG_PUB.initialize;
1100: END IF;
1101:
1102:
1103: -- Initialize API return status to SUCCESS

Line 1123: FND_MSG_PUB.Count_And_Get

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

Line 1146: FND_MSG_PUB.initialize;

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

Line 1170: FND_MSG_PUB.Count_And_Get

1166: NULL;
1167: END IF;
1168:
1169: -- Standard call to get message count and if count is 1, get message info.
1170: FND_MSG_PUB.Count_And_Get
1171: ( p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );
1174:

Line 1193: FND_MSG_PUB.initialize;

1189:
1190: -- Initialize message list if p_init_msg_list is set to TRUE.
1191: IF FND_API.to_Boolean( p_init_msg_list )
1192: THEN
1193: FND_MSG_PUB.initialize;
1194: END IF;
1195:
1196:
1197: -- Initialize API return status to SUCCESS

Line 1217: FND_MSG_PUB.Count_And_Get

1213: NULL;
1214: END IF;
1215:
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: ( p_count => x_msg_count,
1219: p_data => x_msg_data
1220: );
1221:

Line 1240: FND_MSG_PUB.initialize;

1236:
1237: -- Initialize message list if p_init_msg_list is set to TRUE.
1238: IF FND_API.to_Boolean( p_init_msg_list )
1239: THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242:
1243:
1244: -- Initialize API return status to SUCCESS

Line 1264: FND_MSG_PUB.Count_And_Get

1260: NULL;
1261: END IF;
1262:
1263: -- Standard call to get message count and if count is 1, get message info.
1264: FND_MSG_PUB.Count_And_Get
1265: ( p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );
1268:

Line 1287: FND_MSG_PUB.initialize;

1283:
1284: -- Initialize message list if p_init_msg_list is set to TRUE.
1285: IF FND_API.to_Boolean( p_init_msg_list )
1286: THEN
1287: FND_MSG_PUB.initialize;
1288: END IF;
1289:
1290:
1291: -- Initialize API return status to SUCCESS

Line 1311: FND_MSG_PUB.Count_And_Get

1307: NULL;
1308: END IF;
1309:
1310: -- Standard call to get message count and if count is 1, get message info.
1311: FND_MSG_PUB.Count_And_Get
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315:

Line 1337: FND_MSG_PUB.initialize;

1333:
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
1335: IF FND_API.to_Boolean( p_init_msg_list )
1336: THEN
1337: FND_MSG_PUB.initialize;
1338: END IF;
1339:
1340:
1341: -- Initialize API return status to SUCCESS

Line 1350: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');

1346: -- THEN
1347: -- x_return_status := FND_API.G_RET_STS_ERROR;
1348:
1349: -- Debug Message
1350: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1351:
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,

Line 1353: FND_MSG_PUB.Count_And_Get

1349: -- Debug Message
1350: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'API_INVALID_RECORD');
1351:
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.Count_And_Get
1354: ( p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );
1357:

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

1370: l_api_name CONSTANT VARCHAR2(30) := 'Validate_requirement_headers';
1371: BEGIN
1372:
1373: -- Debug Message
1374: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1375:
1376:
1377: -- Initialize API return status to SUCCESS
1378: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1517: END IF;
1518:
1519:
1520: -- Debug Message
1521: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1522:
1523: END Validate_requirement_headers; */
1524:
1525: End CSP_Requirement_headers_PVT;