21: l_Duplicate_Flag NUMBER;
22:
23: BEGIN
24:
25: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
26:
27: -- Bill_Rate_Sch_ID should be from the sequence PA_STD_BILL_SCH_S next value
28: SELECT PA_STD_BILL_SCH_S.NextVal
29: INTO l_Bill_Rate_Sch_ID
45: AND Organization_ID = P_Source_Organization_ID;
46: EXCEPTION
47: WHEN others THEN
48: Raise;
49: X_Return_Status := FND_API.G_RET_STS_ERROR;
50: X_Msg_Data := 'PA_UNEXPECTED_ERROR';
51: RETURN;
52: END;
53:
173: --
174: EXCEPTION WHEN OTHERS THEN
175: ROLLBACK;
176: raise;
177: X_Return_Status := FND_API.G_RET_STS_ERROR;
178: -- X_Msg_Data := 'PA_UNEXPECTED_ERROR';
179:
180: END Copy_Rate_Schedules;
181: