72:
73: EXCEPTION
74:
75: WHEN OTHERS THEN
76: FND_MESSAGE.SET_NAME('EAM','EAM_UPDATE_GENEALOGY_FAIL');
77: FND_MESSAGE.RAISE_ERROR;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79:
80: END;
73: EXCEPTION
74:
75: WHEN OTHERS THEN
76: FND_MESSAGE.SET_NAME('EAM','EAM_UPDATE_GENEALOGY_FAIL');
77: FND_MESSAGE.RAISE_ERROR;
78: APP_EXCEPTION.RAISE_EXCEPTION;
79:
80: END;
81:
499: l_msg_count := fnd_msg_pub.count_msg;
500: if(l_msg_count>0) then
501: get_all_mesg(mesg=>l_message_text);
502: end if;
503: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
504:
505: fnd_message.set_token(token => 'MESG',
506: value => l_message_text,
507: translate => FALSE);
501: get_all_mesg(mesg=>l_message_text);
502: end if;
503: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
504:
505: fnd_message.set_token(token => 'MESG',
506: value => l_message_text,
507: translate => FALSE);
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: end;
526: l_msg_count := fnd_msg_pub.count_msg;
527: if(l_msg_count>0) then
528: get_all_mesg(mesg=>l_message_text);
529: end if;
530: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
531:
532: fnd_message.set_token(token => 'MESG',
533: value => l_message_text,
534: translate => FALSE);
528: get_all_mesg(mesg=>l_message_text);
529: end if;
530: fnd_message.set_name('EAM','EAM_ERROR_CREATE_WO');
531:
532: fnd_message.set_token(token => 'MESG',
533: value => l_message_text,
534: translate => FALSE);
535: APP_EXCEPTION.RAISE_EXCEPTION;
536: end if;
1503: l_message_text :=' ';
1504: if(l_msg_count>0) then
1505: get_all_mesg(mesg=>l_message_text);
1506: end if;
1507: fnd_message.set_name('EAM','EAM_ERROR_UPDATE_WO');
1508:
1509: fnd_message.set_token(token => 'MESG',
1510: value => l_message_text,
1511: translate => FALSE);
1505: get_all_mesg(mesg=>l_message_text);
1506: end if;
1507: fnd_message.set_name('EAM','EAM_ERROR_UPDATE_WO');
1508:
1509: fnd_message.set_token(token => 'MESG',
1510: value => l_message_text,
1511: translate => FALSE);
1512:
1513:
1529: l_message_text :=' ';
1530: if(l_msg_count>0) then
1531: get_all_mesg(mesg=>l_message_text);
1532: end if;
1533: fnd_message.set_name('EAM','EAM_ERROR_UPDATE_WO');
1534:
1535: fnd_message.set_token(token => 'MESG',
1536: value => l_message_text,
1537: translate => FALSE);
1531: get_all_mesg(mesg=>l_message_text);
1532: end if;
1533: fnd_message.set_name('EAM','EAM_ERROR_UPDATE_WO');
1534:
1535: fnd_message.set_token(token => 'MESG',
1536: value => l_message_text,
1537: translate => FALSE);
1538:
1539:
1764: OPEN C_WDJ;
1765: FETCH C_WDJ INTO Recinfo1;
1766: if (C_WDJ%NOTFOUND) then
1767: CLOSE C_WDJ;
1768: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1769: APP_EXCEPTION.Raise_Exception;
1770: end if;
1771: CLOSE C_WDJ;
1772:
1884: nvl(X_activity_source, 'XXXX'))
1885: then
1886: null;
1887: else
1888: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1889: APP_EXCEPTION.Raise_Exception;
1890: null;
1891: end if;
1892: else
1889: APP_EXCEPTION.Raise_Exception;
1890: null;
1891: end if;
1892: else
1893: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1894: APP_EXCEPTION.Raise_Exception;
1895: null;
1896: end if;
1897:
1900: OPEN C_WE;
1901: FETCH C_WE INTO Recinfo2;
1902: if (C_WE%NOTFOUND) then
1903: CLOSE C_WE;
1904: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1905: APP_EXCEPTION.Raise_Exception;
1906: end if;
1907: CLOSE C_WE;
1908: if (Recinfo2.wip_entity_id = X_Wip_Entity_Id)
1915: nvl(X_Primary_Item_Id, 0))
1916: then
1917: return;
1918: else
1919: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1920: APP_EXCEPTION.Raise_Exception;
1921: end if;
1922:
1923: -- eam_work_order_details
1924: OPEN C_EWOD;
1925: FETCH C_EWOD INTO Recinfo3;
1926: IF (C_EWOD%NOTFOUND) THEN
1927: CLOSE C_EWOD;
1928: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1929: APP_EXCEPTION.Raise_Exception;
1930: END IF;
1931: CLOSE C_EWOD;
1932: IF (Recinfo3.wip_entity_id = X_Wip_Entity_Id)
1939: AND (NVL(Recinfo3.material_shortage_check_date,sysdate) = NVL(X_material_shortage_check_date,sysdate))
1940: THEN
1941: return;
1942: ELSE
1943: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1944: APP_EXCEPTION.Raise_Exception;
1945: END IF;
1946: END Lock_Row;
1947: