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 176: --JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');

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

Line 180: /* FND_MSG_PUB.Count_And_Get

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

Line 190: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 209: FND_MSG_PUB.ADD;

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

Line 210: fnd_msg_pub.count_and_get

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

Line 291: FND_MSG_PUB.initialize;

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

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

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

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

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

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

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

Line 370: FND_MSG_PUB.Add;

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

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

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

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

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

Line 387: FND_MSG_PUB.ADD;

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

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

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

Line 397: FND_MSG_PUB.ADD;

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

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

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

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

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

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

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

Line 483: FND_MSG_PUB.Count_And_Get

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

Line 493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

489: WHEN FND_API.G_EXC_ERROR THEN
490: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
491: P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
494: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
499: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
500: P_API_NAME => L_API_NAME
501: ,P_PKG_NAME => G_PKG_NAME
502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
503: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
504: ,X_MSG_COUNT => X_MSG_COUNT
505: ,X_MSG_DATA => X_MSG_DATA
506: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 512: FND_MSG_PUB.ADD;

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

Line 513: fnd_msg_pub.count_and_get

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

Line 553: FND_MSG_PUB.initialize;

549:
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF FND_API.to_Boolean( p_init_msg_list )
552: THEN
553: FND_MSG_PUB.initialize;
554: END IF;
555:
556:
557: -- Debug Message

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

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

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

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

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

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

Line 594: FND_MSG_PUB.Count_And_Get

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

Line 604: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

600: WHEN FND_API.G_EXC_ERROR THEN
601: JTF_PLSQL_API.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_ERROR
605: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
606: ,X_MSG_COUNT => X_MSG_COUNT
607: ,X_MSG_DATA => X_MSG_DATA
608: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
614: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 623: FND_MSG_PUB.ADD;

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

Line 624: fnd_msg_pub.count_and_get

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

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

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

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

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

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

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

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

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

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

720: BEGIN
721: -- Bind variables
722: -- Only those that are not NULL
723: -- Debug Message
724: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Begins');
725:
726: -- The following example applies to all columns,
727: -- developers can copy and paste them.
728: 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 734: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Bind Variables Ends');

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

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

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

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

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

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

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

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

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

Line 908: FND_MSG_PUB.initialize;

904:
905: -- Initialize message list if p_init_msg_list is set to TRUE.
906: IF FND_API.to_Boolean( p_init_msg_list )
907: THEN
908: FND_MSG_PUB.initialize;
909: END IF;
910:
911:
912: -- Initialize API return status to SUCCESS

Line 939: FND_MSG_PUB.Count_And_Get

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

Line 962: FND_MSG_PUB.initialize;

958:
959: -- Initialize message list if p_init_msg_list is set to TRUE.
960: IF FND_API.to_Boolean( p_init_msg_list )
961: THEN
962: FND_MSG_PUB.initialize;
963: END IF;
964:
965:
966: -- Initialize API return status to SUCCESS

Line 986: FND_MSG_PUB.Count_And_Get

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

Line 1009: FND_MSG_PUB.initialize;

1005:
1006: -- Initialize message list if p_init_msg_list is set to TRUE.
1007: IF FND_API.to_Boolean( p_init_msg_list )
1008: THEN
1009: FND_MSG_PUB.initialize;
1010: END IF;
1011:
1012:
1013: -- Initialize API return status to SUCCESS

Line 1033: FND_MSG_PUB.Count_And_Get

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

Line 1056: FND_MSG_PUB.initialize;

1052:
1053: -- Initialize message list if p_init_msg_list is set to TRUE.
1054: IF FND_API.to_Boolean( p_init_msg_list )
1055: THEN
1056: FND_MSG_PUB.initialize;
1057: END IF;
1058:
1059:
1060: -- Initialize API return status to SUCCESS

Line 1080: FND_MSG_PUB.Count_And_Get

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

Line 1103: FND_MSG_PUB.initialize;

1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list )
1102: THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105:
1106:
1107: -- Initialize API return status to SUCCESS

Line 1127: FND_MSG_PUB.Count_And_Get

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

Line 1150: FND_MSG_PUB.initialize;

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

Line 1174: FND_MSG_PUB.Count_And_Get

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

Line 1197: FND_MSG_PUB.initialize;

1193:
1194: -- Initialize message list if p_init_msg_list is set to TRUE.
1195: IF FND_API.to_Boolean( p_init_msg_list )
1196: THEN
1197: FND_MSG_PUB.initialize;
1198: END IF;
1199:
1200:
1201: -- Initialize API return status to SUCCESS

Line 1221: FND_MSG_PUB.Count_And_Get

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

Line 1244: FND_MSG_PUB.initialize;

1240:
1241: -- Initialize message list if p_init_msg_list is set to TRUE.
1242: IF FND_API.to_Boolean( p_init_msg_list )
1243: THEN
1244: FND_MSG_PUB.initialize;
1245: END IF;
1246:
1247:
1248: -- Initialize API return status to SUCCESS

Line 1268: FND_MSG_PUB.Count_And_Get

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

Line 1291: FND_MSG_PUB.initialize;

1287:
1288: -- Initialize message list if p_init_msg_list is set to TRUE.
1289: IF FND_API.to_Boolean( p_init_msg_list )
1290: THEN
1291: FND_MSG_PUB.initialize;
1292: END IF;
1293:
1294:
1295: -- Initialize API return status to SUCCESS

Line 1315: FND_MSG_PUB.Count_And_Get

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

Line 1341: FND_MSG_PUB.initialize;

1337:
1338: -- Initialize message list if p_init_msg_list is set to TRUE.
1339: IF FND_API.to_Boolean( p_init_msg_list )
1340: THEN
1341: FND_MSG_PUB.initialize;
1342: END IF;
1343:
1344:
1345: -- Initialize API return status to SUCCESS

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

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

Line 1357: FND_MSG_PUB.Count_And_Get

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

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

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

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

1521: END IF;
1522:
1523:
1524: -- Debug Message
1525: JTF_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'end');
1526:
1527: END Validate_requirement_headers; */
1528:
1529: End CSP_Requirement_headers_PVT;