[Home] [Help]
130: THEN
131: x_err_text := G_PKG_NAME || '(Check_Approved_For_Process) - '
132: || 'ECO Header' || substrb(SQLERRM,1,60);
133: END IF;
134: RAISE FND_API.G_EXC_ERROR;
135:
136: END Check_Approved_For_Process;
137:
138: PROCEDURE Set_Request_For_Approval
178: x_err_text := G_PKG_NAME || '(Set_Request_For_Approval) -
179: ECO Header and Revised Items' || substrb(SQLERRM,1,60);
180: END IF;
181:
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183:
184: END Set_Request_For_Approval;
185:
186: PROCEDURE Init_Process_Name
1339: END IF;
1340:
1341: IF (p_entity IN ('Bom_Header','Bom_Comps','Bom_Ref_Desgs','Bom_Sub_Comps','Bom_Comp_Ops')
1342: AND
1343: NVL(p_transaction_type, FND_API.G_MISS_CHAR)
1344: NOT IN ('CREATE', 'UPDATE', 'DELETE')
1345: )
1346: OR
1347: ( p_entity ='Bom_Rev' AND
1344: NOT IN ('CREATE', 'UPDATE', 'DELETE')
1345: )
1346: OR
1347: ( p_entity ='Bom_Rev' AND
1348: NVL(p_transaction_type, FND_API.G_MISS_CHAR)
1349: NOT IN ('CREATE', 'UPDATE')
1350: )
1351: THEN
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2147:
2148: EXECUTE IMMEDIATE l_eng_api_call
2149: USING IN p_comp_seq_id, OUT l_edit_flag;
2150:
2151: IF l_edit_flag = FND_API.G_TRUE
2152: THEN
2153: RETURN 'Y';
2154: ELSE
2155: RETURN 'N';
2478: ,x_errorcode => l_errorcode
2479: ,x_msg_count => l_msg_count
2480: ,x_msg_data => l_msg_data
2481: );
2482: IF x_Return_Status <> FND_API.G_RET_STS_SUCCESS
2483: THEN
2484: fnd_message.set_name('BOM', 'BOM_SPLIT_FAILED');
2485: return;
2486: END IF;
2754: , SYSDATE
2755: , ref_desg.CREATED_BY
2756: , ref_desg.LAST_UPDATE_LOGIN
2757: , DECODE( ref_desg.ref_designator_comment
2758: , FND_API.G_MISS_CHAR
2759: , NULL
2760: , ref_desg.ref_designator_comment )
2761: , ref_desg.change_notice
2762: , l_component_seqeunce_id
3156: x_return_status := l_return_status ;
3157:
3158: EXCEPTION
3159: WHEN OTHERS THEN
3160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3161: x_msg_data := SQLERRM;
3162:
3163: END uda_attribute_defaulting;
3164: