3294: Begin
3295: hr_utility.set_location('Entering:'||l_proc, 15);
3296:
3297: /* l_dynamicSqlString := '
3298: ota_om_upd_api.create_rma(
3299: :p_Line_id,
3300: :p_org_id);';
3301: EXECUTE IMMEDIATE l_dynamicSqlString
3302: USING IN p_line_id,
3300: :p_org_id);';
3301: EXECUTE IMMEDIATE l_dynamicSqlString
3302: USING IN p_line_id,
3303: IN p_org_id;*/
3304: ota_om_upd_api.create_rma(p_line_id,p_org_id);
3305: exception when others then
3306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3307: hr_utility.set_message_token('PROCEDURE', l_proc);
3308: hr_utility.set_message_token('STEP','15');
3312: ELSE
3313: Begin
3314: hr_utility.set_location('Entering:'||l_proc, 20);
3315: /*l_dynamicSqlString := '
3316: ota_om_upd_api.cancel_order(
3317: p_Line_id,
3318: p_org_id);' ;
3319: EXECUTE IMMEDIATE l_dynamicSqlString
3320: USING IN p_line_id,
3318: p_org_id);' ;
3319: EXECUTE IMMEDIATE l_dynamicSqlString
3320: USING IN p_line_id,
3321: IN p_org_id;*/
3322: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3323: exception when others then
3324: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3325: hr_utility.set_message_token('PROCEDURE', l_proc);
3326: hr_utility.set_message_token('STEP','20');