APPS.AR_CMGT_REASSIGN_CONC dependencies on FND_API

Line 50: l_cf_return_status := FND_API.G_RET_STS_SUCCESS;

46: l_start_date := FND_DATE.CANONICAL_TO_DATE(p_start_date);
47: l_end_date := FND_DATE.CANONICAL_TO_DATE(p_end_date);
48:
49: --Intialize the out NOCOPY variable
50: l_cf_return_status := FND_API.G_RET_STS_SUCCESS;
51: l_req_return_status := FND_API.G_RET_STS_SUCCESS;
52: l_prof_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: --Issue Save point

Line 51: l_req_return_status := FND_API.G_RET_STS_SUCCESS;

47: l_end_date := FND_DATE.CANONICAL_TO_DATE(p_end_date);
48:
49: --Intialize the out NOCOPY variable
50: l_cf_return_status := FND_API.G_RET_STS_SUCCESS;
51: l_req_return_status := FND_API.G_RET_STS_SUCCESS;
52: l_prof_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: --Issue Save point
55: SAVEPOINT assign_analyst_pvt;

Line 52: l_prof_return_status := FND_API.G_RET_STS_SUCCESS;

48:
49: --Intialize the out NOCOPY variable
50: l_cf_return_status := FND_API.G_RET_STS_SUCCESS;
51: l_req_return_status := FND_API.G_RET_STS_SUCCESS;
52: l_prof_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: --Issue Save point
55: SAVEPOINT assign_analyst_pvt;
56:

Line 68: l_cf_return_status := FND_API.G_RET_STS_ERROR;

64: WHERE credit_analyst_id = l_credit_analyst_id_from
65: AND status in ('CREATED','SAVED');
66: EXCEPTION
67: WHEN others THEN
68: l_cf_return_status := FND_API.G_RET_STS_ERROR;
69: END;
70:
71: --Update pending credit requests
72: BEGIN

Line 79: l_req_return_status := FND_API.G_RET_STS_ERROR;

75: WHERE credit_analyst_id = l_credit_analyst_id_from
76: AND status in ('IN_PROCESS','SAVED','SUBMIT');
77: EXCEPTION
78: WHEN others THEN
79: l_req_return_status := FND_API.G_RET_STS_ERROR;
80: END;
81:
82: ELSIF (NVL(l_assign_status,'NONE') = 'TEMPORARY') THEN
83:

Line 106: l_cf_return_status := FND_API.G_RET_STS_ERROR;

102: AND NVL(l_end_date,creation_date_time)
103: AND status in ('CREATED','SAVED');
104: EXCEPTION
105: WHEN others THEN
106: l_cf_return_status := FND_API.G_RET_STS_ERROR;
107: END;
108:
109: --Update pending credit requests
110: BEGIN

Line 119: l_req_return_status := FND_API.G_RET_STS_ERROR;

115: AND NVL(l_end_date,creation_date)
116: AND status in ('IN_PROCESS','SAVED','SUBMIT');
117: EXCEPTION
118: WHEN others THEN
119: l_req_return_status := FND_API.G_RET_STS_ERROR;
120: END;
121:
122: END IF;
123:

Line 131: l_prof_return_status := FND_API.G_RET_STS_ERROR;

127: SET credit_analyst_id = l_credit_analyst_id_to
128: WHERE credit_analyst_id = l_credit_analyst_id_from;
129: EXCEPTION
130: WHEN others THEN
131: l_prof_return_status := FND_API.G_RET_STS_ERROR;
132: END;
133:
134: IF l_cf_return_status <> FND_API.G_RET_STS_SUCCESS OR
135: l_req_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 134: IF l_cf_return_status <> FND_API.G_RET_STS_SUCCESS OR

130: WHEN others THEN
131: l_prof_return_status := FND_API.G_RET_STS_ERROR;
132: END;
133:
134: IF l_cf_return_status <> FND_API.G_RET_STS_SUCCESS OR
135: l_req_return_status <> FND_API.G_RET_STS_SUCCESS OR
136: l_prof_return_status <> FND_API.G_RET_STS_SUCCESS
137: THEN
138: IF PG_DEBUG in ('Y', 'C') THEN

Line 135: l_req_return_status <> FND_API.G_RET_STS_SUCCESS OR

131: l_prof_return_status := FND_API.G_RET_STS_ERROR;
132: END;
133:
134: IF l_cf_return_status <> FND_API.G_RET_STS_SUCCESS OR
135: l_req_return_status <> FND_API.G_RET_STS_SUCCESS OR
136: l_prof_return_status <> FND_API.G_RET_STS_SUCCESS
137: THEN
138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_util.debug('EXCEPTION: ' ||'ar_cmgt_reassign_conc.reassign_credit_analyst :'||SQLERRM);

Line 136: l_prof_return_status <> FND_API.G_RET_STS_SUCCESS

132: END;
133:
134: IF l_cf_return_status <> FND_API.G_RET_STS_SUCCESS OR
135: l_req_return_status <> FND_API.G_RET_STS_SUCCESS OR
136: l_prof_return_status <> FND_API.G_RET_STS_SUCCESS
137: THEN
138: IF PG_DEBUG in ('Y', 'C') THEN
139: arp_util.debug('EXCEPTION: ' ||'ar_cmgt_reassign_conc.reassign_credit_analyst :'||SQLERRM);
140: END IF;