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.CTO_TRANSFER_PRICE_PK dependencies on FND_API

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57:
58: BEGIN
59:
60: lStmtNumber := 10;
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: IF PG_DEBUG <> 0 THEN
64: oe_debug_pub.add('get_config_details:entering');
65: oe_debug_pub.add('get_config_details:ItemId::'||to_char(p_item_id));

Line 111: raise FND_API.G_EXC_ERROR;

107: WHEN no_data_found THEN
108: IF PG_DEBUG <> 0 THEN
109: oe_debug_pub.add('get_config_details:NDF:Mode is OM and no order line for this item.', 1);
110: END IF;
111: raise FND_API.G_EXC_ERROR;
112: END;
113:
114: lStmtNumber := 30;
115: select bom_explosion_temp_s.nextval

Line 134: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

130: x_msg_count,
131: x_msg_data,
132: x_return_status);
133:
134: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: IF PG_DEBUG <> 0 THEN
136: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
137: END IF;
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 138: raise FND_API.G_EXC_UNEXPECTED_ERROR;

134: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
135: IF PG_DEBUG <> 0 THEN
136: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
137: END IF;
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139:
140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
141: IF PG_DEBUG <> 0 THEN
142: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);

Line 140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

136: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
137: END IF;
138: raise FND_API.G_EXC_UNEXPECTED_ERROR;
139:
140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
141: IF PG_DEBUG <> 0 THEN
142: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
143: END IF;
144: raise FND_API.G_EXC_ERROR;

Line 144: raise FND_API.G_EXC_ERROR;

140: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
141: IF PG_DEBUG <> 0 THEN
142: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
143: END IF;
144: raise FND_API.G_EXC_ERROR;
145: END IF;
146:
147: ELSIF p_mode_id = 2 THEN
148:

Line 171: raise FND_API.G_EXC_ERROR;

167: WHEN no_data_found THEN
168: IF PG_DEBUG <> 0 THEN
169: oe_debug_pub.add('get_config_details:NDF:Mode is BOM and no BOM exists for this item.', 1);
170: END IF;
171: raise FND_API.G_EXC_ERROR;
172: END;
173:
174: lStmtNumber := 60;
175: select bom_explosion_temp_s.nextval

Line 194: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

190: x_msg_count,
191: x_msg_data,
192: x_return_status);
193:
194: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: IF PG_DEBUG <> 0 THEN
196: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
197: END IF;
198: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 198: raise FND_API.G_EXC_UNEXPECTED_ERROR;

194: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
195: IF PG_DEBUG <> 0 THEN
196: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
197: END IF;
198: raise FND_API.G_EXC_UNEXPECTED_ERROR;
199:
200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
201: IF PG_DEBUG <> 0 THEN
202: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);

Line 200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

196: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
197: END IF;
198: raise FND_API.G_EXC_UNEXPECTED_ERROR;
199:
200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
201: IF PG_DEBUG <> 0 THEN
202: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
203: END IF;
204: raise FND_API.G_EXC_ERROR;

Line 204: raise FND_API.G_EXC_ERROR;

200: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
201: IF PG_DEBUG <> 0 THEN
202: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
203: END IF;
204: raise FND_API.G_EXC_ERROR;
205: END IF;
206:
207: ELSE
208:

Line 256: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

252: x_msg_count,
253: x_msg_data,
254: x_return_status);
255:
256: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
259: END IF;
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 260: raise FND_API.G_EXC_UNEXPECTED_ERROR;

256: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
257: IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
259: END IF;
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261:
262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
263: IF PG_DEBUG <> 0 THEN
264: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);

Line 262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

258: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with unexp error',1);
259: END IF;
260: raise FND_API.G_EXC_UNEXPECTED_ERROR;
261:
262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
263: IF PG_DEBUG <> 0 THEN
264: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
265: END IF;
266: raise FND_API.G_EXC_ERROR;

Line 266: raise FND_API.G_EXC_ERROR;

262: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
263: IF PG_DEBUG <> 0 THEN
264: oe_debug_pub.add('get_config_details:get_config_details_bcol returned with exp error',1);
265: END IF;
266: raise FND_API.G_EXC_ERROR;
267: END IF;
268:
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN

Line 294: raise FND_API.G_EXC_ERROR;

290: WHEN no_data_found THEN
291: IF PG_DEBUG <> 0 THEN
292: oe_debug_pub.add('get_config_details:NDF:Mode is BOTH, but no order line and no BOM exists for this item.', 1);
293: END IF;
294: raise FND_API.G_EXC_ERROR;
295: END;
296:
297: lStmtNumber := 120;
298: select bom_explosion_temp_s.nextval

Line 317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

313: x_msg_count,
314: x_msg_data,
315: x_return_status);
316:
317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: IF PG_DEBUG <> 0 THEN
319: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
320: END IF;
321: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 321: raise FND_API.G_EXC_UNEXPECTED_ERROR;

317: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
318: IF PG_DEBUG <> 0 THEN
319: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
320: END IF;
321: raise FND_API.G_EXC_UNEXPECTED_ERROR;
322:
323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF PG_DEBUG <> 0 THEN
325: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);

Line 323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

319: oe_debug_pub.add('get_config_details:get_config_details_bom returned with unexp error',1);
320: END IF;
321: raise FND_API.G_EXC_UNEXPECTED_ERROR;
322:
323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF PG_DEBUG <> 0 THEN
325: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
326: END IF;
327: raise FND_API.G_EXC_ERROR;

Line 327: raise FND_API.G_EXC_ERROR;

323: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
324: IF PG_DEBUG <> 0 THEN
325: oe_debug_pub.add('get_config_details:get_config_details_bom returned with exp error',1);
326: END IF;
327: raise FND_API.G_EXC_ERROR;
328: END IF;
329:
330: END; -- sub block
331:

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: WHEN NO_DATA_FOUND THEN
340: IF PG_DEBUG <> 0 THEN
341: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);
342: END IF;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: CTO_MSG_PUB.Count_And_Get
345: (p_msg_count => x_msg_count
346: ,p_msg_data => x_msg_data
347: );

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: (p_msg_count => x_msg_count
346: ,p_msg_data => x_msg_data
347: );
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: IF PG_DEBUG <> 0 THEN
351: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);
352: END IF;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: IF PG_DEBUG <> 0 THEN
351: oe_debug_pub.add('get_config_details:unexp error::'||lStmtNumber||sqlerrm,1);
352: END IF;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: CTO_MSG_PUB.Count_And_Get
355: (p_msg_count => x_msg_count
356: ,p_msg_data => x_msg_data
357: );

Line 359: WHEN FND_API.G_EXC_ERROR THEN

355: (p_msg_count => x_msg_count
356: ,p_msg_data => x_msg_data
357: );
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: IF PG_DEBUG <> 0 THEN
361: oe_debug_pub.add('get_config_details:exp error::'||lStmtNumber||sqlerrm,1);
362: END IF;
363: x_return_status := FND_API.G_RET_STS_ERROR;

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: WHEN FND_API.G_EXC_ERROR THEN
360: IF PG_DEBUG <> 0 THEN
361: oe_debug_pub.add('get_config_details:exp error::'||lStmtNumber||sqlerrm,1);
362: END IF;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: CTO_MSG_PUB.Count_And_Get
365: (p_msg_count => x_msg_count
366: ,p_msg_data => x_msg_data);
367:

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368: WHEN OTHERS THEN
369: IF PG_DEBUG <> 0 THEN
370: oe_debug_pub.add('get_config_details:others::'||lStmtNumber||sqlerrm,1);
371: END IF;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
374: FND_MSG_PUB.Add_Exc_Msg
375: (G_PKG_NAME
376: , 'get_config_details'

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423:
424: BEGIN
425:
426: lStmtNumber := 10;
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429: open get_oeval_org_id;
430: fetch get_oeval_org_id into l_oeval_org_id;
431: close get_oeval_org_id;

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

681:
682: END IF;
683:
684: EXCEPTION
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('get_config_details_bcol:unexp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: IF PG_DEBUG <> 0 THEN
687: oe_debug_pub.add('get_config_details_bcol:unexp error::'||lStmtNumber||sqlerrm,1);
688: END IF;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: CTO_MSG_PUB.Count_And_Get
691: (p_msg_count => x_msg_count
692: ,p_msg_data => x_msg_data
693: );

Line 695: WHEN FND_API.G_EXC_ERROR THEN

691: (p_msg_count => x_msg_count
692: ,p_msg_data => x_msg_data
693: );
694:
695: WHEN FND_API.G_EXC_ERROR THEN
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add('get_config_details_bcol:exp error::'||lStmtNumber||sqlerrm,1);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: WHEN FND_API.G_EXC_ERROR THEN
696: IF PG_DEBUG <> 0 THEN
697: oe_debug_pub.add('get_config_details_bcol:exp error::'||lStmtNumber||sqlerrm,1);
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: CTO_MSG_PUB.Count_And_Get
701: (p_msg_count => x_msg_count
702: ,p_msg_data => x_msg_data);
703:

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

704: WHEN OTHERS THEN
705: IF PG_DEBUG <> 0 THEN
706: oe_debug_pub.add('get_config_details_bcol:others::'||lStmtNumber||sqlerrm,1);
707: END IF;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
710: FND_MSG_PUB.Add_Exc_Msg
711: (G_PKG_NAME
712: ,'get_config_details_bcol'

Line 747: x_return_status := FND_API.G_RET_STS_SUCCESS;

743:
744: BEGIN
745:
746: lStmtNumber := 10;
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748:
749: IF PG_DEBUG <> 0 THEN
750: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','entering');
751: cto_wip_workflow_api_pk.cto_debug('get_config_details_bom:','p_grp_id::'||to_char(p_grp_id));

Line 1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

999:
1000: END IF; /* g_configs_only = N */
1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: IF PG_DEBUG <> 0 THEN
1005: oe_debug_pub.add('get_config_details_bom:unexp error::'||lStmtNumber||sqlerrm,1);
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: IF PG_DEBUG <> 0 THEN
1005: oe_debug_pub.add('get_config_details_bom:unexp error::'||lStmtNumber||sqlerrm,1);
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: CTO_MSG_PUB.Count_And_Get
1009: (p_msg_count => x_msg_count
1010: ,p_msg_data => x_msg_data
1011: );

Line 1013: WHEN FND_API.G_EXC_ERROR THEN

1009: (p_msg_count => x_msg_count
1010: ,p_msg_data => x_msg_data
1011: );
1012:
1013: WHEN FND_API.G_EXC_ERROR THEN
1014: IF PG_DEBUG <> 0 THEN
1015: oe_debug_pub.add('get_config_details_bom:exp error::'||lStmtNumber||sqlerrm,1);
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

1013: WHEN FND_API.G_EXC_ERROR THEN
1014: IF PG_DEBUG <> 0 THEN
1015: oe_debug_pub.add('get_config_details_bom:exp error::'||lStmtNumber||sqlerrm,1);
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: CTO_MSG_PUB.Count_And_Get
1019: (p_msg_count => x_msg_count
1020: ,p_msg_data => x_msg_data);
1021:

Line 1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1022: WHEN OTHERS THEN
1023: IF PG_DEBUG <> 0 THEN
1024: oe_debug_pub.add('get_config_details_bom:others::'||lStmtNumber||sqlerrm,1);
1025: END IF;
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1028: FND_MSG_PUB.Add_Exc_Msg
1029: (G_PKG_NAME
1030: ,'get_config_details_bom'

Line 1138: raise FND_API.G_EXC_ERROR;

1134: If PG_DEBUG <> 0 Then
1135: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'ERROR::Config item passed by INV is not valid');
1136: End if;
1137:
1138: raise FND_API.G_EXC_ERROR;
1139: END IF;
1140:
1141: x_transfer_price := 0;
1142:

Line 1158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1154: If PG_DEBUG <> 0 Then
1155: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'x_group_id::'||to_char(x_group_id));
1156: End if;
1157:
1158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1159: If PG_DEBUG <> 0 Then
1160: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_config_details:'||sqlerrm);
1161: End if;
1162: raise FND_API.G_EXC_ERROR;

Line 1162: raise FND_API.G_EXC_ERROR;

1158: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1159: If PG_DEBUG <> 0 Then
1160: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_config_details:'||sqlerrm);
1161: End if;
1162: raise FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: If PG_DEBUG <> 0 Then
1165: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_config_details:'||sqlerrm);
1166: End if;

Line 1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1159: If PG_DEBUG <> 0 Then
1160: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_config_details:'||sqlerrm);
1161: End if;
1162: raise FND_API.G_EXC_ERROR;
1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: If PG_DEBUG <> 0 Then
1165: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_config_details:'||sqlerrm);
1166: End if;
1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1163: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1164: If PG_DEBUG <> 0 Then
1165: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_config_details:'||sqlerrm);
1166: End if;
1167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: --<< Get_Options >>
1171: FOR v_options IN c_options(l_current_item_id) LOOP

Line 1205: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1201: , p_from_organization_id => p_from_organization_id
1202: , p_cto_item_flag => 'Y'
1203: );
1204:
1205: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: If PG_DEBUG <> 0 Then
1207: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1208: End if;
1209: raise FND_API.G_EXC_ERROR;

Line 1209: raise FND_API.G_EXC_ERROR;

1205: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1206: If PG_DEBUG <> 0 Then
1207: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1208: End if;
1209: raise FND_API.G_EXC_ERROR;
1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: If PG_DEBUG <> 0 Then
1212: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1213: End if;

Line 1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1206: If PG_DEBUG <> 0 Then
1207: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1208: End if;
1209: raise FND_API.G_EXC_ERROR;
1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: If PG_DEBUG <> 0 Then
1212: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1213: End if;
1214: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1214: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1210: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1211: If PG_DEBUG <> 0 Then
1212: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1213: End if;
1214: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216: If PG_DEBUG <> 0 Then
1217: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));
1218: End if;

Line 1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1261: --, p_cto_item_flag => 'Y'
1262: , p_cto_item_flag => 'N'
1263: );
1264:
1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: If PG_DEBUG <> 0 Then
1267: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1268: End if;
1269: raise FND_API.G_EXC_ERROR;

Line 1269: raise FND_API.G_EXC_ERROR;

1265: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1266: If PG_DEBUG <> 0 Then
1267: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1268: End if;
1269: raise FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: If PG_DEBUG <> 0 Then
1272: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1273: End if;

Line 1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1266: If PG_DEBUG <> 0 Then
1267: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Exp error in get_transfer_price_for_item:'||sqlerrm);
1268: End if;
1269: raise FND_API.G_EXC_ERROR;
1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: If PG_DEBUG <> 0 Then
1272: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1273: End if;
1274: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1274: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1270: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1271: If PG_DEBUG <> 0 Then
1272: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexp error in get_transfer_price_for_item:'||sqlerrm);
1273: End if;
1274: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: If PG_DEBUG <> 0 Then
1278: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Transfer price of comp '||to_char(v_options.component_item_id)||' is '||to_char(l_transfer_price));

Line 1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1292: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Total Transfer price of item is '||to_char(x_transfer_price));
1293: End if;
1294:
1295: EXCEPTION
1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: If PG_DEBUG <> 0 Then
1298: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexpected error:'||lStmtNumber||sqlerrm);
1299: End if;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1297: If PG_DEBUG <> 0 Then
1298: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Unexpected error:'||lStmtNumber||sqlerrm);
1299: End if;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: CTO_MSG_PUB.Count_And_Get
1302: (p_msg_count => x_msg_count
1303: ,p_msg_data => x_msg_data
1304: );

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: (p_msg_count => x_msg_count
1303: ,p_msg_data => x_msg_data
1304: );
1305:
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: If PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Expected error:'||lStmtNumber||sqlerrm);
1309: End if;
1310: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1310: x_return_status := FND_API.G_RET_STS_ERROR;

1306: WHEN FND_API.G_EXC_ERROR THEN
1307: If PG_DEBUG <> 0 Then
1308: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Expected error:'||lStmtNumber||sqlerrm);
1309: End if;
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311: CTO_MSG_PUB.Count_And_Get
1312: (p_msg_count => x_msg_count
1313: ,p_msg_data => x_msg_data);
1314:

Line 1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1315: WHEN OTHERS THEN
1316: If PG_DEBUG <> 0 Then
1317: cto_wip_workflow_api_pk.cto_debug('cto_transfer_price:', 'Others error:'||lStmtNumber||sqlerrm);
1318: End if;
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1320: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1321: FND_MSG_PUB.Add_Exc_Msg
1322: (G_PKG_NAME
1323: ,'cto_transfer_price'