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_POPULATE_PVT dependencies on FND_API

Line 15: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgrqpb.pls';
12:
13: PROCEDURE POPULATE_REQUIREMENTS(p_task_id IN NUMBER
14: ,p_api_version IN NUMBER
15: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,x_return_status OUT NOCOPY VARCHAR2
18: ,x_msg_data OUT NOCOPY NUMBER
19: ,x_msg_count OUT NOCOPY NUMBER

Line 16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

12:
13: PROCEDURE POPULATE_REQUIREMENTS(p_task_id IN NUMBER
14: ,p_api_version IN NUMBER
15: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
16: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
17: ,x_return_status OUT NOCOPY VARCHAR2
18: ,x_msg_data OUT NOCOPY NUMBER
19: ,x_msg_count OUT NOCOPY NUMBER
20: ,px_header_id IN OUT NOCOPY NUMBER

Line 101: x_return_status := FND_API.G_RET_STS_SUCCESS;

97: l_revision VARCHAR2(30);
98: BEGIN
99: SAVEPOINT CSP_REQUIREMENT_POPULATE_PVT;
100: x_msg_count := 0;
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: IF NOT FND_API.Compatible_API_Call
104: ( l_api_version_number
105: , p_api_version

Line 103: IF NOT FND_API.Compatible_API_Call

99: SAVEPOINT CSP_REQUIREMENT_POPULATE_PVT;
100: x_msg_count := 0;
101: x_return_status := FND_API.G_RET_STS_SUCCESS;
102:
103: IF NOT FND_API.Compatible_API_Call
104: ( l_api_version_number
105: , p_api_version
106: , L_API_NAME
107: , G_PKG_NAME

Line 110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

106: , L_API_NAME
107: , G_PKG_NAME
108: )
109: THEN
110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Initialize message stack if required
114: IF FND_API.to_Boolean(p_init_msg_list)

Line 114: IF FND_API.to_Boolean(p_init_msg_list)

110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
111: END IF;
112:
113: -- Initialize message stack if required
114: IF FND_API.to_Boolean(p_init_msg_list)
115: THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118:

Line 138: l_header_return_status := FND_API.G_RET_STS_SUCCESS;

134: OPEN get_parts(l_product_task_id);
135: LOOP
136: FETCH get_parts INTO l_item_id,l_uom_code,l_quantity,l_likelihood,l_manual_quantity,l_rollup_quantity,l_revision;
137: EXIT WHEN get_parts%NOTFOUND;
138: l_header_return_status := FND_API.G_RET_STS_SUCCESS;
139: IF get_parts % ROWCOUNT = 1 AND p_called_by = 1 THEN
140: l_requirement_header_rec.CREATED_BY := l_user_id ;
141: l_requirement_header_rec.CREATION_DATE := SYSDATE ;
142: l_requirement_header_rec.LAST_UPDATED_BY := l_user_id ;

Line 151: ,P_Init_Msg_List => FND_API.G_FALSE

147: l_requirement_header_rec.order_type_id := fnd_profile.value(name => 'CSP_ORDER_TYPE');
148: l_requirement_header_rec.address_type := 'R';
149: CSP_Requirement_headers_PVT.Create_requirement_headers(
150: P_Api_Version_Number => l_api_version_number
151: ,P_Init_Msg_List => FND_API.G_FALSE
152: ,P_Commit => FND_API.G_TRUE
153: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
154: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
155: ,X_REQUIREMENT_HEADER_ID => px_header_id

Line 152: ,P_Commit => FND_API.G_TRUE

148: l_requirement_header_rec.address_type := 'R';
149: CSP_Requirement_headers_PVT.Create_requirement_headers(
150: P_Api_Version_Number => l_api_version_number
151: ,P_Init_Msg_List => FND_API.G_FALSE
152: ,P_Commit => FND_API.G_TRUE
153: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
154: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
155: ,X_REQUIREMENT_HEADER_ID => px_header_id
156: ,X_Return_Status => l_header_return_status

Line 153: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

149: CSP_Requirement_headers_PVT.Create_requirement_headers(
150: P_Api_Version_Number => l_api_version_number
151: ,P_Init_Msg_List => FND_API.G_FALSE
152: ,P_Commit => FND_API.G_TRUE
153: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
154: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
155: ,X_REQUIREMENT_HEADER_ID => px_header_id
156: ,X_Return_Status => l_header_return_status
157: ,X_Msg_Count => x_msg_count

Line 167: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN

163: select CSP_Requirement_headers_s1.nextval
164: INTO px_header_id
165: FROM DUAL;
166: END IF;
167: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
168: If l_manual_quantity is null then
169: IF l_rollup_quantity is not null THEN
170: IF l_times_used >= FND_PROFILE.value(name => 'CSP_PROD_TASK_HIST_RULE') Then
171: count1 := count1 + 1;

Line 206: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN

202: x_return_status := l_header_return_status;
203: RETURN;
204: END IF;
205: END LOOP;
206: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
207: CSP_Requirement_Lines_PVT.Create_requirement_lines(
208: P_Api_Version_Number => l_api_version_number
209: ,P_Init_Msg_List => FND_API.G_FALSE
210: ,P_Commit => FND_API.G_TRUE

Line 209: ,P_Init_Msg_List => FND_API.G_FALSE

205: END LOOP;
206: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
207: CSP_Requirement_Lines_PVT.Create_requirement_lines(
208: P_Api_Version_Number => l_api_version_number
209: ,P_Init_Msg_List => FND_API.G_FALSE
210: ,P_Commit => FND_API.G_TRUE
211: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
213: ,X_Requirement_Line_TBL => x_requirement_line_tbl

Line 210: ,P_Commit => FND_API.G_TRUE

206: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
207: CSP_Requirement_Lines_PVT.Create_requirement_lines(
208: P_Api_Version_Number => l_api_version_number
209: ,P_Init_Msg_List => FND_API.G_FALSE
210: ,P_Commit => FND_API.G_TRUE
211: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
213: ,X_Requirement_Line_TBL => x_requirement_line_tbl
214: ,X_Return_Status => l_line_return_status

Line 211: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

207: CSP_Requirement_Lines_PVT.Create_requirement_lines(
208: P_Api_Version_Number => l_api_version_number
209: ,P_Init_Msg_List => FND_API.G_FALSE
210: ,P_Commit => FND_API.G_TRUE
211: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
212: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
213: ,X_Requirement_Line_TBL => x_requirement_line_tbl
214: ,X_Return_Status => l_line_return_status
215: ,X_Msg_Count => x_msg_count

Line 218: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN

214: ,X_Return_Status => l_line_return_status
215: ,X_Msg_Count => x_msg_count
216: ,X_Msg_Data => x_msg_data
217: );
218: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN
219: x_return_status := l_line_return_status;
220: IF FND_API.to_Boolean( p_commit ) THEN
221: COMMIT;
222: END IF;

Line 220: IF FND_API.to_Boolean( p_commit ) THEN

216: ,X_Msg_Data => x_msg_data
217: );
218: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN
219: x_return_status := l_line_return_status;
220: IF FND_API.to_Boolean( p_commit ) THEN
221: COMMIT;
222: END IF;
223: ELSE
224: x_return_status := l_line_return_status;

Line 230: x_return_status :=FND_API.G_RET_STS_SUCCESS;

226: END IF;
227: END IF;
228: END IF;
229: CLOSE product_task_id;
230: x_return_status :=FND_API.G_RET_STS_SUCCESS;
231: EXCEPTION
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: ROLLBACK TO CSP_REQUIREMENT_POPULATE_PVT;

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229: CLOSE product_task_id;
230: x_return_status :=FND_API.G_RET_STS_SUCCESS;
231: EXCEPTION
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: ROLLBACK TO CSP_REQUIREMENT_POPULATE_PVT;
235: END POPULATE_REQUIREMENTS;
236: END CSP_REQUIREMENT_POPULATE_PVT;