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 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: l_revision VARCHAR2(30);
82: BEGIN
83: SAVEPOINT CSP_REQUIREMENT_POPULATE_PVT;
84: x_msg_count := 0;
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: IF NOT FND_API.Compatible_API_Call
88: ( l_api_version_number
89: , p_api_version

Line 87: IF NOT FND_API.Compatible_API_Call

83: SAVEPOINT CSP_REQUIREMENT_POPULATE_PVT;
84: x_msg_count := 0;
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: IF NOT FND_API.Compatible_API_Call
88: ( l_api_version_number
89: , p_api_version
90: , L_API_NAME
91: , G_PKG_NAME

Line 94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

90: , L_API_NAME
91: , G_PKG_NAME
92: )
93: THEN
94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message stack if required
98: IF FND_API.to_Boolean(p_init_msg_list)

Line 98: IF FND_API.to_Boolean(p_init_msg_list)

94: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
95: END IF;
96:
97: -- Initialize message stack if required
98: IF FND_API.to_Boolean(p_init_msg_list)
99: THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:

Line 122: l_header_return_status := FND_API.G_RET_STS_SUCCESS;

118: OPEN get_parts(l_product_task_id);
119: LOOP
120: FETCH get_parts INTO l_item_id,l_uom_code,l_quantity,l_likelihood,l_manual_quantity,l_rollup_quantity,l_revision;
121: EXIT WHEN get_parts%NOTFOUND;
122: l_header_return_status := FND_API.G_RET_STS_SUCCESS;
123: IF get_parts % ROWCOUNT = 1 AND p_called_by = 1 THEN
124: l_requirement_header_rec.CREATED_BY := l_user_id ;
125: l_requirement_header_rec.CREATION_DATE := SYSDATE ;
126: l_requirement_header_rec.LAST_UPDATED_BY := l_user_id ;

Line 135: ,P_Init_Msg_List => FND_API.G_FALSE

131: l_requirement_header_rec.order_type_id := fnd_profile.value(name => 'CSP_ORDER_TYPE');
132: l_requirement_header_rec.address_type := 'R';
133: CSP_Requirement_headers_PVT.Create_requirement_headers(
134: P_Api_Version_Number => l_api_version_number
135: ,P_Init_Msg_List => FND_API.G_FALSE
136: ,P_Commit => FND_API.G_TRUE
137: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
138: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
139: ,X_REQUIREMENT_HEADER_ID => px_header_id

Line 136: ,P_Commit => FND_API.G_TRUE

132: l_requirement_header_rec.address_type := 'R';
133: CSP_Requirement_headers_PVT.Create_requirement_headers(
134: P_Api_Version_Number => l_api_version_number
135: ,P_Init_Msg_List => FND_API.G_FALSE
136: ,P_Commit => FND_API.G_TRUE
137: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
138: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
139: ,X_REQUIREMENT_HEADER_ID => px_header_id
140: ,X_Return_Status => l_header_return_status

Line 137: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

133: CSP_Requirement_headers_PVT.Create_requirement_headers(
134: P_Api_Version_Number => l_api_version_number
135: ,P_Init_Msg_List => FND_API.G_FALSE
136: ,P_Commit => FND_API.G_TRUE
137: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
138: ,P_REQUIREMENT_HEADER_Rec => l_requirement_header_rec
139: ,X_REQUIREMENT_HEADER_ID => px_header_id
140: ,X_Return_Status => l_header_return_status
141: ,X_Msg_Count => x_msg_count

Line 151: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN

147: select CSP_Requirement_headers_s1.nextval
148: INTO px_header_id
149: FROM DUAL;
150: END IF;
151: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
152: If l_manual_quantity is null then
153: IF l_rollup_quantity is not null THEN
154: IF l_times_used >= FND_PROFILE.value(name => 'CSP_PROD_TASK_HIST_RULE') Then
155: count1 := count1 + 1;

Line 190: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN

186: x_return_status := l_header_return_status;
187: RETURN;
188: END IF;
189: END LOOP;
190: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: CSP_Requirement_Lines_PVT.Create_requirement_lines(
192: P_Api_Version_Number => l_api_version_number
193: ,P_Init_Msg_List => FND_API.G_FALSE
194: ,P_Commit => FND_API.G_TRUE

Line 193: ,P_Init_Msg_List => FND_API.G_FALSE

189: END LOOP;
190: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: CSP_Requirement_Lines_PVT.Create_requirement_lines(
192: P_Api_Version_Number => l_api_version_number
193: ,P_Init_Msg_List => FND_API.G_FALSE
194: ,P_Commit => FND_API.G_TRUE
195: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
196: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
197: ,X_Requirement_Line_TBL => x_requirement_line_tbl

Line 194: ,P_Commit => FND_API.G_TRUE

190: IF l_header_return_status = FND_API.G_RET_STS_SUCCESS THEN
191: CSP_Requirement_Lines_PVT.Create_requirement_lines(
192: P_Api_Version_Number => l_api_version_number
193: ,P_Init_Msg_List => FND_API.G_FALSE
194: ,P_Commit => FND_API.G_TRUE
195: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
196: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
197: ,X_Requirement_Line_TBL => x_requirement_line_tbl
198: ,X_Return_Status => l_line_return_status

Line 195: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

191: CSP_Requirement_Lines_PVT.Create_requirement_lines(
192: P_Api_Version_Number => l_api_version_number
193: ,P_Init_Msg_List => FND_API.G_FALSE
194: ,P_Commit => FND_API.G_TRUE
195: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
196: ,P_Requirement_Line_TBL => l_Requirement_Line_tbl
197: ,X_Requirement_Line_TBL => x_requirement_line_tbl
198: ,X_Return_Status => l_line_return_status
199: ,X_Msg_Count => x_msg_count

Line 202: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN

198: ,X_Return_Status => l_line_return_status
199: ,X_Msg_Count => x_msg_count
200: ,X_Msg_Data => x_msg_data
201: );
202: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN
203: x_return_status := l_line_return_status;
204: IF FND_API.to_Boolean( p_commit ) THEN
205: COMMIT;
206: END IF;

Line 204: IF FND_API.to_Boolean( p_commit ) THEN

200: ,X_Msg_Data => x_msg_data
201: );
202: IF l_line_return_status = FND_API.G_RET_STS_SUCCESS THEN
203: x_return_status := l_line_return_status;
204: IF FND_API.to_Boolean( p_commit ) THEN
205: COMMIT;
206: END IF;
207: ELSE
208: x_return_status := l_line_return_status;

Line 214: x_return_status :=FND_API.G_RET_STS_SUCCESS;

210: END IF;
211: END IF;
212: END IF;
213: CLOSE product_task_id;
214: x_return_status :=FND_API.G_RET_STS_SUCCESS;
215: EXCEPTION
216: WHEN OTHERS THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: ROLLBACK TO CSP_REQUIREMENT_POPULATE_PVT;

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213: CLOSE product_task_id;
214: x_return_status :=FND_API.G_RET_STS_SUCCESS;
215: EXCEPTION
216: WHEN OTHERS THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: ROLLBACK TO CSP_REQUIREMENT_POPULATE_PVT;
219: END POPULATE_REQUIREMENTS;
220: END CSP_REQUIREMENT_POPULATE_PVT;