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: );
348:
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: );
358:
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:
368: WHEN OTHERS THEN
375: (G_PKG_NAME
376: , 'get_config_details'
377: );
378: END IF;
379: CTO_MSG_PUB.Count_And_Get
380: (p_msg_count => x_msg_count
381: ,p_msg_data => x_msg_data
382: );
383:
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: );
694:
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:
704: WHEN OTHERS THEN
711: (G_PKG_NAME
712: ,'get_config_details_bcol'
713: );
714: END IF;
715: CTO_MSG_PUB.Count_And_Get
716: (p_msg_count => x_msg_count
717: ,p_msg_data => x_msg_data
718: );
719:
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: );
1012:
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:
1022: WHEN OTHERS THEN
1029: (G_PKG_NAME
1030: ,'get_config_details_bom'
1031: );
1032: END IF;
1033: CTO_MSG_PUB.Count_And_Get
1034: (p_msg_count => x_msg_count
1035: ,p_msg_data => x_msg_data
1036: );
1037:
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: );
1305:
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:
1315: WHEN OTHERS THEN
1322: (G_PKG_NAME
1323: ,'cto_transfer_price'
1324: );
1325: END IF;
1326: CTO_MSG_PUB.Count_And_Get
1327: (p_msg_count => x_msg_count
1328: ,p_msg_data => x_msg_data
1329: );
1330: