eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_IFA_TRANS_PKG dependencies on FND_API

Line 18: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |

14: -- | another within the same asset. If the destination distribution does |
15: -- | not exist, it will be created during the transfer. |
16: -- | |
17: -- | If the transfer is successful, P_RETURN_STATUS will be set to |
18: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |
19: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |
20: -- | P_ERROR_MSG will contain the error description. |
21: -- | |
22: -- | The new from distribution id and new to distribution id will be |

Line 19: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |

15: -- | not exist, it will be created during the transfer. |
16: -- | |
17: -- | If the transfer is successful, P_RETURN_STATUS will be set to |
18: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |
19: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |
20: -- | P_ERROR_MSG will contain the error description. |
21: -- | |
22: -- | The new from distribution id and new to distribution id will be |
23: -- | returned after the transfer is completed successfully. |

Line 46: l_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;

42: l_from_units NUMBER;
43: l_seq_num NUMBER;
44: l_user_id NUMBER := fnd_global.user_id;
45: l_login_id NUMBER := fnd_global.login_id;
46: l_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
47: l_msg_count NUMBER := 0;
48: l_msg_data VARCHAR2(1024) := NULL;
49: l_new_from_dist_id NUMBER;
50: l_new_to_dist_id NUMBER;

Line 156: p_init_msg_list => FND_API.G_TRUE,

152: -- Process the records
153:
154: fa_modify_distributions_pkg.modify_distributions(
155: p_api_version => 1.0,
156: p_init_msg_list => FND_API.G_TRUE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
159: p_debug_flag => 'NO',
160: x_return_status => l_status,

Line 157: p_commit => FND_API.G_FALSE,

153:
154: fa_modify_distributions_pkg.modify_distributions(
155: p_api_version => 1.0,
156: p_init_msg_list => FND_API.G_TRUE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
159: p_debug_flag => 'NO',
160: x_return_status => l_status,
161: x_msg_count => l_msg_count,

Line 158: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

154: fa_modify_distributions_pkg.modify_distributions(
155: p_api_version => 1.0,
156: p_init_msg_list => FND_API.G_TRUE,
157: p_commit => FND_API.G_FALSE,
158: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
159: p_debug_flag => 'NO',
160: x_return_status => l_status,
161: x_msg_count => l_msg_count,
162: x_msg_data => l_msg_data);

Line 165: if (l_status <> FND_API.G_RET_STS_SUCCESS)

161: x_msg_count => l_msg_count,
162: x_msg_data => l_msg_data);
163:
164: cse_util_pkg.write_log('Status from MODIFY_DISTRIBUTIONS: ' || l_status);
165: if (l_status <> FND_API.G_RET_STS_SUCCESS)
166: then
167: if (l_msg_count > 0)
168: then
169: l_msg_index := 1;

Line 174: FND_API.G_FALSE)||x_error_msg ;

170: x_error_msg :=l_msg_data;
171: WHILE l_msg_count > 0
172: LOOP
173: x_error_msg :=FND_MSG_PUB.GET(l_msg_index,
174: FND_API.G_FALSE)||x_error_msg ;
175: l_msg_index := l_msg_index + 1;
176: l_Msg_Count := l_Msg_Count - 1;
177: END LOOP;
178: end if ;

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: l_Msg_Count := l_Msg_Count - 1;
177: END LOOP;
178: end if ;
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181: x_new_from_dist_id := NULL;
182: x_new_to_dist_id := NULL;
183: cse_util_pkg.write_log('Error : '||x_error_msg);
184: raise MOD_DIST_FAIL;

Line 220: x_return_status := FND_API.G_RET_STS_SUCCESS;

216: code_combination_id = p_to_expense_ccid AND
217: nvl(assigned_to, -1) = nvl(p_to_employee_id, -1) AND
218: date_ineffective is null;
219:
220: x_return_status := FND_API.G_RET_STS_SUCCESS;
221: x_error_msg := NULL;
222: x_new_from_dist_id := l_new_from_dist_id;
223: x_new_to_dist_id := l_new_to_dist_id;
224:

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228:
229: EXCEPTION
230:
231: WHEN MOD_DIST_FAIL THEN
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
234: fnd_message.set_token('API_NAME',l_api_name);
235: x_new_from_dist_id := NULL;
236: x_new_to_dist_id := NULL;

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: x_new_from_dist_id := NULL;
236: x_new_to_dist_id := NULL;
237:
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_ERROR;
240: x_error_msg := sqlerrm;
241: x_new_from_dist_id := NULL;
242: x_new_to_dist_id := NULL;
243:

Line 261: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |

257: -- | For unit increase, P_UNITS must be positive. For unit decrease, |
258: -- | P_UNITS must be negative. |
259: -- | |
260: -- | If the adjustment is successful, P_RETURN_STATUS will be set to |
261: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |
262: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |
263: -- | P_ERROR_MSG will contain the error description. |
264: -- | |
265: -- | The new distribution id of the adjusted distribution will be |

Line 262: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |

258: -- | P_UNITS must be negative. |
259: -- | |
260: -- | If the adjustment is successful, P_RETURN_STATUS will be set to |
261: -- | FND_API.G_RET_STS_SUCCESS and P_ERROR_MSG will be NULL. Otherwise, |
262: -- | P_RETURN_STATUS will be set to FND_API.G_RET_STS_ERROR and |
263: -- | P_ERROR_MSG will contain the error description. |
264: -- | |
265: -- | The new distribution id of the adjusted distribution will be |
266: -- | returned after the adjustment is completed successfully. |

Line 285: l_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;

281: l_from_units NUMBER;
282: l_seq_num NUMBER;
283: l_user_id NUMBER := fnd_global.user_id;
284: l_login_id NUMBER := fnd_global.login_id;
285: l_status VARCHAR2(10) := FND_API.G_RET_STS_ERROR;
286: l_msg_count NUMBER := 0;
287: l_msg_data VARCHAR2(1024) := NULL;
288: l_temp_dist_id NUMBER;
289: l_new_dist_id NUMBER;

Line 502: p_init_msg_list => FND_API.G_TRUE,

498: -- Process the records
499:
500: fa_modify_distributions_pkg.modify_distributions(
501: p_api_version => 1.0,
502: p_init_msg_list => FND_API.G_TRUE,
503: p_commit => FND_API.G_FALSE,
504: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
505: p_debug_flag => 'NO',
506: x_return_status => l_status,

Line 503: p_commit => FND_API.G_FALSE,

499:
500: fa_modify_distributions_pkg.modify_distributions(
501: p_api_version => 1.0,
502: p_init_msg_list => FND_API.G_TRUE,
503: p_commit => FND_API.G_FALSE,
504: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
505: p_debug_flag => 'NO',
506: x_return_status => l_status,
507: x_msg_count => l_msg_count,

Line 504: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

500: fa_modify_distributions_pkg.modify_distributions(
501: p_api_version => 1.0,
502: p_init_msg_list => FND_API.G_TRUE,
503: p_commit => FND_API.G_FALSE,
504: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
505: p_debug_flag => 'NO',
506: x_return_status => l_status,
507: x_msg_count => l_msg_count,
508: x_msg_data => l_msg_data);

Line 512: if (l_status <> FND_API.G_RET_STS_SUCCESS)

508: x_msg_data => l_msg_data);
509:
510: cse_util_pkg.write_log('Status from MODIFY_DISTRIBUTIONS: ' || l_status);
511:
512: if (l_status <> FND_API.G_RET_STS_SUCCESS)
513: then
514: if (l_msg_count > 0)
515: then
516: l_msg_index := 1;

Line 521: FND_API.G_FALSE)||x_error_msg ;

517: x_error_msg :=l_msg_data;
518: WHILE l_msg_count > 0
519: LOOP
520: x_error_msg :=FND_MSG_PUB.GET(l_msg_index,
521: FND_API.G_FALSE)||x_error_msg ;
522: l_msg_index := l_msg_index + 1;
523: l_Msg_Count := l_Msg_Count - 1;
524: END LOOP;
525: end if ;

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: l_Msg_Count := l_Msg_Count - 1;
524: END LOOP;
525: end if ;
526:
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: x_new_dist_id := NULL;
529: cse_util_pkg.write_log('Error : '||x_error_msg);
530: raise MOD_DIST_FAIL;
531:

Line 558: x_return_status := FND_API.G_RET_STS_SUCCESS;

554: code_combination_id = p_expense_ccid AND
555: nvl(assigned_to, -1) = nvl(p_employee_id, -1) AND
556: date_ineffective is null;
557:
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559: x_error_msg := NULL;
560: x_new_dist_id := l_new_dist_id;
561:
562: end if;

Line 659: p_init_msg_list => FND_API.G_TRUE,

655: -- Process the records
656:
657: fa_modify_distributions_pkg.modify_distributions(
658: p_api_version => 1.0,
659: p_init_msg_list => FND_API.G_TRUE,
660: p_commit => FND_API.G_FALSE,
661: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
662: p_debug_flag => 'NO',
663: x_return_status => l_status,

Line 660: p_commit => FND_API.G_FALSE,

656:
657: fa_modify_distributions_pkg.modify_distributions(
658: p_api_version => 1.0,
659: p_init_msg_list => FND_API.G_TRUE,
660: p_commit => FND_API.G_FALSE,
661: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
662: p_debug_flag => 'NO',
663: x_return_status => l_status,
664: x_msg_count => l_msg_count,

Line 661: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

657: fa_modify_distributions_pkg.modify_distributions(
658: p_api_version => 1.0,
659: p_init_msg_list => FND_API.G_TRUE,
660: p_commit => FND_API.G_FALSE,
661: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
662: p_debug_flag => 'NO',
663: x_return_status => l_status,
664: x_msg_count => l_msg_count,
665: x_msg_data => l_msg_data);

Line 669: if (l_status <> FND_API.G_RET_STS_SUCCESS)

665: x_msg_data => l_msg_data);
666:
667: cse_util_pkg.write_log('Status from MODIFY_DISTRIBUTIONS: ' || l_status);
668:
669: if (l_status <> FND_API.G_RET_STS_SUCCESS)
670: then
671: if (l_msg_count > 0)
672: then
673: l_msg_index := 1;

Line 678: FND_API.G_FALSE)||x_error_msg ;

674: x_error_msg :=l_msg_data;
675: WHILE l_msg_count > 0
676: LOOP
677: x_error_msg :=FND_MSG_PUB.GET(l_msg_index,
678: FND_API.G_FALSE)||x_error_msg ;
679: l_msg_index := l_msg_index + 1;
680: l_Msg_Count := l_Msg_Count - 1;
681: END LOOP;
682: end if ;

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: l_msg_index := l_msg_index + 1;
680: l_Msg_Count := l_Msg_Count - 1;
681: END LOOP;
682: end if ;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: x_new_dist_id := NULL;
685: cse_util_pkg.write_log('Error : '||x_error_msg);
686: raise MOD_DIST_FAIL;
687:

Line 705: x_return_status := FND_API.G_RET_STS_SUCCESS;

701: when NO_DATA_FOUND then
702: l_new_dist_id := NULL;
703: end;
704:
705: x_return_status := FND_API.G_RET_STS_SUCCESS;
706: x_error_msg := NULL;
707: x_new_dist_id := l_new_dist_id;
708:
709: end if;

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

712:
713: EXCEPTION
714:
715: WHEN NO_DIST_EXISTS THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: fnd_message.set_name('CSE', 'CSE_NO_FA_DIST_FOR_ADJ');
718: x_error_msg := fnd_message.get;
719: x_new_dist_id := NULL;
720:

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: x_error_msg := fnd_message.get;
719: x_new_dist_id := NULL;
720:
721: WHEN UPDATE_FAIL THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: x_error_msg := l_update_err_msg;
724: x_new_dist_id := NULL;
725:
726: WHEN MOD_DIST_FAIL THEN

Line 727: x_return_status := FND_API.G_RET_STS_ERROR;

723: x_error_msg := l_update_err_msg;
724: x_new_dist_id := NULL;
725:
726: WHEN MOD_DIST_FAIL THEN
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
729: fnd_message.set_token('API_NAME',l_api_name);
730: x_error_msg := fnd_message.get;
731: x_new_dist_id := NULL;

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: x_error_msg := fnd_message.get;
731: x_new_dist_id := NULL;
732:
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: x_error_msg := sqlerrm;
736: x_new_dist_id := NULL;
737:
738: END adjust_fa_distribution;