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

Line 99: FND_MSG_PUB.ADD;

95: OPEN C_Get_Item_Id;
96: FETCH C_Get_Item_Id INTO l_inventory_item_id;
97: IF C_Get_Item_Id%NOTFOUND THEN
98: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');
99: FND_MSG_PUB.ADD;
100: RAISE EXCP_USER_DEFINED;
101: END IF;
102: CLOSE C_Get_Item_Id;
103: x_pvt_RQL_Tbl(I).inventory_item_id := l_inventory_item_id;

Line 177: FND_MSG_PUB.ADD;

173: WHERE requirement_header_id = l_pvt_RQL_Tbl(I).requirement_header_id;
174: IF (l_count <= 0) THEN
175: fnd_message.set_name('CSP', 'CSP_INVALID_RQMT_HEADER');
176: fnd_message.set_token('HEADER_ID', to_char(l_pvt_RQL_Tbl(I).requirement_header_id), FALSE);
177: FND_MSG_PUB.ADD;
178: RAISE EXCP_USER_DEFINED;
179: END IF;
180: EXCEPTION
181: when no_Data_found then

Line 194: FND_MSG_PUB.ADD;

190: FROM mtl_system_items_b
191: WHERE inventory_item_id = l_pvt_RQL_Tbl(I).inventory_item_id;
192: IF (l_count <= 0) THEN
193: FND_MESSAGE.SET_NAME ('INV', 'INV_INVALID_ITEM');
194: FND_MSG_PUB.ADD;
195: RAISE EXCP_USER_DEFINED;
196: END IF;
197: EXCEPTION
198: when no_Data_found then

Line 212: FND_MSG_PUB.ADD;

208: WHERE organization_id = l_pvt_RQL_Tbl(I).source_organization_id;
209: IF (l_count <= 0) THEN
210: FND_MESSAGE.SET_NAME ('INV', 'INV_IOI_SOURCE_ORG_ID');
211: --FND_MESSAGE.SET_TOKEN ('PARAMETER', 'SOURCE_ORGANIZATION', FALSE);
212: FND_MSG_PUB.ADD;
213: RAISE EXCP_USER_DEFINED;
214: END IF;
215: EXCEPTION
216: when no_Data_found then

Line 232: FND_MSG_PUB.ADD;

228: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
229: AND uom_code = l_pvt_RQL_Tbl(I).uom_code;
230: IF (l_count <= 0) THEN
231: FND_MESSAGE.SET_NAME ('WSH', 'WSH_OI_INVALID_UOM');
232: FND_MSG_PUB.ADD;
233: RAISE EXCP_USER_DEFINED;
234: END IF;
235: EXCEPTION
236: when no_Data_found then

Line 252: FND_MSG_PUB.ADD;

248: decode(nvl(l_pvt_RQL_Tbl(I).source_organization_id, FND_API.G_MISS_NUM), FND_API.G_MISS_NUM, organization_id, l_pvt_RQL_Tbl(I).source_organization_id)
249: AND revision = l_pvt_RQL_Tbl(I).revision;
250: IF (l_count <= 0) THEN
251: FND_MESSAGE.SET_NAME ('INV', 'INV_INT_REVCODE');
252: FND_MSG_PUB.ADD;
253: RAISE EXCP_USER_DEFINED;
254: END IF;
255: EXCEPTION
256: when no_Data_found then

Line 298: FND_MSG_PUB.initialize;

294:
295: -- Initialize message list if p_init_msg_list is set to TRUE.
296: IF FND_API.to_Boolean( p_init_msg_list )
297: THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301:
302: -- Debug Message

Line 303: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

299: END IF;
300:
301:
302: -- Debug Message
303: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
304:
305:
306: -- Initialize API return status to SUCCESS
307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 314: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');

310: -- API body
311: --
312:
313: -- Debug Message
314: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
315:
316: -- Convert the values to ids
317: --
318: Convert_RQL_Values_To_Ids (

Line 398: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

394: END IF;
395:
396:
397: -- Debug Message
398: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
399:
400:
401: -- Standard call to get message count and if count is 1, get message info.
402: FND_MSG_PUB.Count_And_Get

Line 402: FND_MSG_PUB.Count_And_Get

398: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
399:
400:
401: -- Standard call to get message count and if count is 1, get message info.
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,
404: p_data => x_msg_data
405: );
406:

Line 412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

408: WHEN FND_API.G_EXC_ERROR THEN
409: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
410: P_API_NAME => L_API_NAME
411: ,P_PKG_NAME => G_PKG_NAME
412: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
413: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
414: ,X_MSG_COUNT => X_MSG_COUNT
415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
423: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
424: ,X_MSG_COUNT => X_MSG_COUNT
425: ,X_MSG_DATA => X_MSG_DATA
426: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 473: FND_MSG_PUB.initialize;

469:
470: -- Initialize message list if p_init_msg_list is set to TRUE.
471: IF FND_API.to_Boolean( p_init_msg_list )
472: THEN
473: FND_MSG_PUB.initialize;
474: END IF;
475:
476:
477: -- Debug Message

Line 478: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

474: END IF;
475:
476:
477: -- Debug Message
478: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
479:
480:
481: -- Initialize API return status to SUCCESS
482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 489: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');

485: -- API body
486: --
487:
488: -- Debug Message
489: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
490:
491: -- Convert the values to ids
492: --
493: Convert_RQL_Values_To_Ids (

Line 531: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

527: END IF;
528:
529:
530: -- Debug Message
531: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
532:
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get

Line 535: FND_MSG_PUB.Count_And_Get

531: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
532:
533:
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get
536: ( p_count => x_msg_count,
537: p_data => x_msg_data
538: );
539:

Line 545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

541: WHEN FND_API.G_EXC_ERROR THEN
542: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
543: P_API_NAME => L_API_NAME
544: ,P_PKG_NAME => G_PKG_NAME
545: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
546: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
547: ,X_MSG_COUNT => X_MSG_COUNT
548: ,X_MSG_DATA => X_MSG_DATA
549: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
553: P_API_NAME => L_API_NAME
554: ,P_PKG_NAME => G_PKG_NAME
555: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
556: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
557: ,X_MSG_COUNT => X_MSG_COUNT
558: ,X_MSG_DATA => X_MSG_DATA
559: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 609: FND_MSG_PUB.initialize;

605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list )
608: THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611:
612:
613: -- Debug Message

Line 614: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');

610: END IF;
611:
612:
613: -- Debug Message
614: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
615:
616:
617: -- Initialize API return status to SUCCESS
618: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 625: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');

621: -- API body
622: --
623:
624: -- Debug Message
625: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'AS: Public API: Convert_RQL_Values_To_Ids');
626:
627: -- Convert the values to ids
628: --
629: Convert_RQL_Values_To_Ids (

Line 644: FND_MSG_PUB.ADD;

640:
641: IF l_count > 0 THEN
642: FND_MESSAGE.SET_NAME ('CSP', 'CSP_RQMT_LINE_DELETE_ERROR');
643: FND_MESSAGE.SET_TOKEN ('PARAMETER', P_RQL_Tbl(I).requirement_line_id, FALSE);
644: FND_MSG_PUB.ADD;
645: RAISE EXCP_USER_DEFINED;
646: END IF;
647: EXCEPTION
648: WHEN NO_DATA_FOUND THEN

Line 684: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');

680: END IF;
681:
682:
683: -- Debug Message
684: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
685:
686:
687: -- Standard call to get message count and if count is 1, get message info.
688: FND_MSG_PUB.Count_And_Get

Line 688: FND_MSG_PUB.Count_And_Get

684: --JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'end');
685:
686:
687: -- Standard call to get message count and if count is 1, get message info.
688: FND_MSG_PUB.Count_And_Get
689: ( p_count => x_msg_count,
690: p_data => x_msg_data
691: );
692:

Line 698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

694: WHEN FND_API.G_EXC_ERROR THEN
695: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
696: P_API_NAME => L_API_NAME
697: ,P_PKG_NAME => G_PKG_NAME
698: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
699: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
700: ,X_MSG_COUNT => X_MSG_COUNT
701: ,X_MSG_DATA => X_MSG_DATA
702: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 708: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
705: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
706: P_API_NAME => L_API_NAME
707: ,P_PKG_NAME => G_PKG_NAME
708: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
709: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
710: ,X_MSG_COUNT => X_MSG_COUNT
711: ,X_MSG_DATA => X_MSG_DATA
712: ,X_RETURN_STATUS => X_RETURN_STATUS);