DBA Data[Home] [Help]

APPS.OE_LINE_FULLFILL dependencies on CSI_ONT_TXN_PUB

Line 1066: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

1062: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1063: AND NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1064: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1065: THEN
1066: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1067: csi_ont_txn_pub.posttransaction
1068: (
1069: p_order_line_id => p_line_rec.line_id,
1070: x_return_status => l_return_status,

Line 1067: csi_ont_txn_pub.posttransaction

1063: AND NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1064: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1065: THEN
1066: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1067: csi_ont_txn_pub.posttransaction
1068: (
1069: p_order_line_id => p_line_rec.line_id,
1070: x_return_status => l_return_status,
1071: x_message_id => l_message_id,

Line 1074: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);

1070: x_return_status => l_return_status,
1071: x_message_id => l_message_id,
1072: x_error_code => l_error_code,
1073: x_error_message => l_error_message);
1074: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1075:
1076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1077: IF l_debug_level > 0 THEN
1078: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

Line 1078: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

1074: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1075:
1076: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1077: IF l_debug_level > 0 THEN
1078: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1079: END IF;
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: IF l_debug_level > 0 THEN

Line 1083: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

1079: END IF;
1080: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1081: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: IF l_debug_level > 0 THEN
1083: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
1084: END IF;
1085: RAISE FND_API.G_EXC_ERROR;
1086: END IF;
1087: END IF;

Line 1370: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

1366: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1367: AND NVL(p_line_tbl(l_index).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1368: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1369: THEN
1370: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1371: csi_ont_txn_pub.posttransaction(
1372: p_order_line_id => p_line_tbl(l_index).line_id,
1373: x_return_status => x_return_status,
1374: x_message_id => l_message_id,

Line 1371: csi_ont_txn_pub.posttransaction(

1367: AND NVL(p_line_tbl(l_index).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1368: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1369: THEN
1370: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1371: csi_ont_txn_pub.posttransaction(
1372: p_order_line_id => p_line_tbl(l_index).line_id,
1373: x_return_status => x_return_status,
1374: x_message_id => l_message_id,
1375: x_error_code => l_error_code,

Line 1377: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);

1373: x_return_status => x_return_status,
1374: x_message_id => l_message_id,
1375: x_error_code => l_error_code,
1376: x_error_message => l_error_message);
1377: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1378:
1379: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1380: IF l_debug_level > 0 THEN
1381: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);

Line 1381: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);

1377: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
1378:
1379: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1380: IF l_debug_level > 0 THEN
1381: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1382: END IF;
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1385: IF l_debug_level > 0 THEN

Line 1386: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);

1382: END IF;
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction '||sqlerrm,1);
1387: END IF;
1388: RAISE FND_API.G_EXC_ERROR;
1389: END IF;
1390: END IF;

Line 2258: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);

2254: IF l_old_line_tbl(1).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
2255: AND NVL(l_old_line_tbl(1).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165
2256: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y')
2257: THEN
2258: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
2259: csi_ont_txn_pub.posttransaction
2260: (
2261: p_order_line_id => l_line_tbl(1).line_id,
2262: x_return_status => l_return_status,

Line 2259: csi_ont_txn_pub.posttransaction

2255: AND NVL(l_old_line_tbl(1).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165
2256: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y')
2257: THEN
2258: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
2259: csi_ont_txn_pub.posttransaction
2260: (
2261: p_order_line_id => l_line_tbl(1).line_id,
2262: x_return_status => l_return_status,
2263: x_message_id => l_message_id,

Line 2266: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);

2262: x_return_status => l_return_status,
2263: x_message_id => l_message_id,
2264: x_error_code => l_error_code,
2265: x_error_message => l_error_message);
2266: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
2267:
2268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

Line 2270: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

2266: oe_debug_pub.add('After Call to csi_ont_txn_pub.posttransaction',1);
2267:
2268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('raising unexpected error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
2271: END IF;
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2274: IF l_debug_level > 0 THEN

Line 2275: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);

2271: END IF;
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2273: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2274: IF l_debug_level > 0 THEN
2275: oe_debug_pub.add('raising exc error in csi_ont_txn_pub.posttransaction'||sqlerrm,1);
2276: END IF;
2277: RAISE FND_API.G_EXC_ERROR;
2278: END IF;
2279: END IF;