121:
122: oe_debug_pub.add ('cto_fs: ' || 'before calling create sub-assembly jobs',1);
123:
124: l_stmt_num := 111;
125: CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs(
126: l_mlsupply_parameter,
127: p_config_line_id,
128: null,
129: null,
141:
142:
143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
144: IF PG_DEBUG <> 0 THEN
145: oe_debug_pub.add ('cto_fs: ' || 'failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs ' || l_return_status ,1);
146: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
147: END IF;
148: RAISE FND_API.G_EXC_ERROR;
149: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
150: IF PG_DEBUG <> 0 THEN
151: oe_debug_pub.add ('cto_fs: ' || ' failed after CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' || l_return_status ,1);
152: oe_debug_pub.add ('cto_fs: ' || 'error message' || l_error_message ,1);
153: END IF;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE
153: END IF;
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: ELSE
156: IF PG_DEBUG <> 0 THEN
157: oe_debug_pub.add('cto_fs: ' || 'success from CTO_SUBASSEMBLY_SUP_PK.create_subassembly_jobs' ,1);
158: oe_debug_pub.add('cto_fs: ' || l_error_message ,1);
159:
160: END IF;
161: END IF;