497: );
498: exception
499: when others then
500: rollback to CREATE_WO;
501: l_msg_count := fnd_msg_pub.count_msg;
502: if(l_msg_count>0) then
503: get_all_mesg(mesg=>l_message_text);
504: end if;
505: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
524: else
525: X_wip_entity_id := 0;
526: rollback to CREATE_WO;
527:
528: l_msg_count := fnd_msg_pub.count_msg;
529: if(l_msg_count>0) then
530: get_all_mesg(mesg=>l_message_text);
531: end if;
532: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
1503: x_return_status := l_return_status; /*7003588*/
1504: exception
1505: when others then
1506: ROLLBACK TO UPDATE_WO;
1507: l_msg_count := FND_MSG_PUB.count_msg;
1508: l_message_text :=' ';
1509: if(l_msg_count>0) then
1510: get_all_mesg(mesg=>l_message_text);
1511: end if;
1529: select rowid into X_We_Rowid from WIP_ENTITIES where wip_entity_id=X_wip_entity_id;
1530:
1531: else
1532: ROLLBACK TO UPDATE_WO;
1533: l_msg_count := FND_MSG_PUB.count_msg;
1534: l_message_text :=' ';
1535: if(l_msg_count>0) then
1536: get_all_mesg(mesg=>l_message_text);
1537: end if;
1961: BEGIN
1962: mesg := '';
1963:
1964:
1965: l_msg_count := fnd_msg_pub.count_msg;
1966: msg_index := l_msg_count;
1967:
1968: for i in 1..l_msg_count loop
1969: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,
1965: l_msg_count := fnd_msg_pub.count_msg;
1966: msg_index := l_msg_count;
1967:
1968: for i in 1..l_msg_count loop
1969: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_NEXT,
1970: p_encoded => 'F',
1971: p_data => temp,
1972: p_msg_index_out => msg_index);
1973: msg_index := msg_index-1;