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.JTF_RS_RESOURCE_UTL_PUB dependencies on FND_API

Line 155: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

151: l_count number;
152:
153: BEGIN
154:
155: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
156: end_date_active := to_date(to_char(p_end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
157: l_updated_by := jtf_resource_utl.updated_by;
158:
159: --Standard Start of API SAVEPOINT

Line 162: l_return_status := fnd_api.g_ret_sts_success;

158:
159: --Standard Start of API SAVEPOINT
160: SAVEPOINT res_save;
161:
162: l_return_status := fnd_api.g_ret_sts_success;
163: l_count := 0;
164: IF FND_API.To_boolean(P_INIT_MSG_LIST)
165: THEN
166: FND_MSG_PUB.Initialize;

Line 164: IF FND_API.To_boolean(P_INIT_MSG_LIST)

160: SAVEPOINT res_save;
161:
162: l_return_status := fnd_api.g_ret_sts_success;
163: l_count := 0;
164: IF FND_API.To_boolean(P_INIT_MSG_LIST)
165: THEN
166: FND_MSG_PUB.Initialize;
167: END IF;
168: open term_res_cur(p_resource_id);

Line 183: l_return_status := fnd_api.g_ret_sts_success;

179: fetch res_team_cur INTO res_team_rec;
180: WHILE(res_team_cur%FOUND)
181: LOOP
182:
183: l_return_status := fnd_api.g_ret_sts_success;
184: l_end_date_active := to_date(to_char(res_team_rec.end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
185: --if start date > sysdate -1 then delete the role
186: IF(trunc(res_team_rec.start_date_active) > trunc(p_end_date_active) )
187: THEN

Line 212: if ( l_return_status <> fnd_api.g_ret_sts_success)

208: X_MSG_DATA => l_msg_data);
209:
210: END IF; -- end of start_date check
211:
212: if ( l_return_status <> fnd_api.g_ret_sts_success)
213: then
214: raise fnd_api.g_exc_error;
215: END IF;
216: FETCH res_team_cur INTO res_team_rec;

Line 214: raise fnd_api.g_exc_error;

210: END IF; -- end of start_date check
211:
212: if ( l_return_status <> fnd_api.g_ret_sts_success)
213: then
214: raise fnd_api.g_exc_error;
215: END IF;
216: FETCH res_team_cur INTO res_team_rec;
217: END LOOP; -- end of res_team_cur
218: CLOSE res_team_cur;

Line 251: if ( l_return_status <> fnd_api.g_ret_sts_success)

247: X_MSG_COUNT => l_msg_count,
248: X_MSG_DATA => l_msg_data);
249:
250: END IF; -- end of start_date check
251: if ( l_return_status <> fnd_api.g_ret_sts_success)
252: then
253: raise fnd_api.g_exc_error;
254: END IF;
255: FETCH res_group_cur INTO res_group_rec;

Line 253: raise fnd_api.g_exc_error;

249:
250: END IF; -- end of start_date check
251: if ( l_return_status <> fnd_api.g_ret_sts_success)
252: then
253: raise fnd_api.g_exc_error;
254: END IF;
255: FETCH res_group_cur INTO res_group_rec;
256: END LOOP; -- end of res_group_cur
257: CLOSE res_group_cur;

Line 292: if ( l_return_status <> fnd_api.g_ret_sts_success)

288:
289: END IF; -- end of start_date check
290:
291:
292: if ( l_return_status <> fnd_api.g_ret_sts_success)
293: then
294: raise fnd_api.g_exc_error;
295: END IF;
296:

Line 294: raise fnd_api.g_exc_error;

290:
291:
292: if ( l_return_status <> fnd_api.g_ret_sts_success)
293: then
294: raise fnd_api.g_exc_error;
295: END IF;
296:
297:
298:

Line 327: raise fnd_api.g_exc_error;

323: IF res_srp_terr_dup_cur%FOUND THEN
324: fnd_message.set_name ('JTF','JTF_RS_DUP_TERR');
325: fnd_msg_pub.add;
326: CLOSE res_srp_terr_dup_cur;
327: raise fnd_api.g_exc_error;
328: END IF;
329: CLOSE res_srp_terr_dup_cur;
330:
331: update ra_salesrep_territories

Line 384: if ( l_return_status <> fnd_api.g_ret_sts_success)

380: X_RETURN_STATUS => l_return_status,
381: X_MSG_COUNT => l_msg_count,
382: X_MSG_DATA => l_msg_data ) ;
383: END IF; -- end of start_date check
384: if ( l_return_status <> fnd_api.g_ret_sts_success)
385: then
386: raise fnd_api.g_exc_error;
387: END IF;
388:

Line 386: raise fnd_api.g_exc_error;

382: X_MSG_DATA => l_msg_data ) ;
383: END IF; -- end of start_date check
384: if ( l_return_status <> fnd_api.g_ret_sts_success)
385: then
386: raise fnd_api.g_exc_error;
387: END IF;
388:
389:
390:

Line 406: P_INIT_MSG_LIST => fnd_api.g_true,

402:
403: --for future dated resources terminate it anyway
404: jtf_rs_resource_pub.update_resource
405: (P_API_VERSION => 1,
406: P_INIT_MSG_LIST => fnd_api.g_true,
407: P_COMMIT => fnd_api.g_false,
408: P_RESOURCE_ID => term_res_rec.resource_id,
409: P_RESOURCE_NUMBER => term_res_rec.resource_number,
410: P_START_DATE_ACTIVE => trunc(p_end_date_active - 1) ,

Line 407: P_COMMIT => fnd_api.g_false,

403: --for future dated resources terminate it anyway
404: jtf_rs_resource_pub.update_resource
405: (P_API_VERSION => 1,
406: P_INIT_MSG_LIST => fnd_api.g_true,
407: P_COMMIT => fnd_api.g_false,
408: P_RESOURCE_ID => term_res_rec.resource_id,
409: P_RESOURCE_NUMBER => term_res_rec.resource_number,
410: P_START_DATE_ACTIVE => trunc(p_end_date_active - 1) ,
411: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,

Line 422: P_INIT_MSG_LIST => fnd_api.g_true,

418:
419: --put end_date to p_end_date_active
420: jtf_rs_resource_pub.update_resource
421: ( P_API_VERSION => 1,
422: P_INIT_MSG_LIST => fnd_api.g_true,
423: P_COMMIT => fnd_api.g_false,
424: P_RESOURCE_ID => term_res_rec.resource_id,
425: P_RESOURCE_NUMBER => term_res_rec.resource_number,
426: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,

Line 423: P_COMMIT => fnd_api.g_false,

419: --put end_date to p_end_date_active
420: jtf_rs_resource_pub.update_resource
421: ( P_API_VERSION => 1,
422: P_INIT_MSG_LIST => fnd_api.g_true,
423: P_COMMIT => fnd_api.g_false,
424: P_RESOURCE_ID => term_res_rec.resource_id,
425: P_RESOURCE_NUMBER => term_res_rec.resource_number,
426: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,
427: P_OBJECT_VERSION_NUM => l_object_version_num_res,

Line 436: if ( l_return_status <> fnd_api.g_ret_sts_success)

432: END IF; -- end of terminate employee
433:
434: x_object_ver_number := l_object_version_num_res;
435:
436: if ( l_return_status <> fnd_api.g_ret_sts_success)
437: then
438: raise fnd_api.g_exc_error;
439: END IF;
440: --------------------------------------------------

Line 438: raise fnd_api.g_exc_error;

434: x_object_ver_number := l_object_version_num_res;
435:
436: if ( l_return_status <> fnd_api.g_ret_sts_success)
437: then
438: raise fnd_api.g_exc_error;
439: END IF;
440: --------------------------------------------------
441:
442: end if; -- end of term_res_cur

Line 449: WHEN fnd_api.g_exc_unexpected_error

445:
446: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
447:
448: EXCEPTION
449: WHEN fnd_api.g_exc_unexpected_error
450: THEN
451: ROLLBACK TO res_save;
452: x_return_status := fnd_api.g_ret_sts_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 452: x_return_status := fnd_api.g_ret_sts_error;

448: EXCEPTION
449: WHEN fnd_api.g_exc_unexpected_error
450: THEN
451: ROLLBACK TO res_save;
452: x_return_status := fnd_api.g_ret_sts_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO res_save;

Line 454: WHEN fnd_api.g_exc_error

450: THEN
451: ROLLBACK TO res_save;
452: x_return_status := fnd_api.g_ret_sts_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO res_save;
457: x_return_status := fnd_api.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 457: x_return_status := fnd_api.g_ret_sts_error;

453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO res_save;
457: x_return_status := fnd_api.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:
460: WHEN OTHERS
461: THEN

Line 468: x_return_status := fnd_api.g_ret_sts_unexp_error;

464: fnd_message.set_token('P_SQLCODE',SQLCODE);
465: fnd_message.set_token('P_SQLERRM',SQLERRM);
466: fnd_message.set_token('P_API_NAME',l_api_name);
467: FND_MSG_PUB.add;
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
470: END end_date_employee;
471:
472: PROCEDURE add_message

Line 487: x_return_status := fnd_api.g_ret_sts_success;

483: AS
484: l_api_name VARCHAR2(30);
485: BEGIN
486: l_api_name := 'ADD_MESSAGE';
487: x_return_status := fnd_api.g_ret_sts_success;
488: FND_MSG_PUB.Initialize;
489: if(P_MESSAGE_CODE is not null)
490: then
491: fnd_message.set_name ('JTF', p_message_code);

Line 492: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))

488: FND_MSG_PUB.Initialize;
489: if(P_MESSAGE_CODE is not null)
490: then
491: fnd_message.set_name ('JTF', p_message_code);
492: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))
493: then
494: fnd_message.set_token (p_token1_name, p_token1_value);
495: end if;
496: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))

Line 496: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))

492: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))
493: then
494: fnd_message.set_token (p_token1_name, p_token1_value);
495: end if;
496: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))
497: then
498: fnd_message.set_token (p_token2_name, p_token2_value);
499: end if;
500: FND_MSG_PUB.add;

Line 512: x_return_status := fnd_api.g_ret_sts_unexp_error;

508: fnd_message.set_token('P_SQLCODE',SQLCODE);
509: fnd_message.set_token('P_SQLERRM',SQLERRM);
510: fnd_message.set_token('P_API_NAME',l_api_name);
511: FND_MSG_PUB.add;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
514:
515: END add_message ;
516:

Line 818: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

814: grp_relations_rec grp_relations_cur%rowtype;
815:
816: BEGIN
817:
818: l_fnd_date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
819: end_date_active := to_date(to_char(p_end_date_active, 'DD-MM-RRRR'), 'DD-MM-RRRR');
820:
821: --Standard Start of API SAVEPOINT
822: SAVEPOINT group_mem_roles_save;

Line 824: l_return_status := fnd_api.g_ret_sts_success;

820:
821: --Standard Start of API SAVEPOINT
822: SAVEPOINT group_mem_roles_save;
823:
824: l_return_status := fnd_api.g_ret_sts_success;
825:
826: IF FND_API.To_boolean(P_INIT_MSG_LIST)
827: THEN
828: FND_MSG_PUB.Initialize;

Line 826: IF FND_API.To_boolean(P_INIT_MSG_LIST)

822: SAVEPOINT group_mem_roles_save;
823:
824: l_return_status := fnd_api.g_ret_sts_success;
825:
826: IF FND_API.To_boolean(P_INIT_MSG_LIST)
827: THEN
828: FND_MSG_PUB.Initialize;
829: END IF;
830:

Line 869: if ( l_return_status <> fnd_api.g_ret_sts_success)

865: X_MSG_COUNT => l_msg_count,
866: X_MSG_DATA => l_msg_data);
867:
868: END IF; -- end of start_date check
869: if ( l_return_status <> fnd_api.g_ret_sts_success)
870: then
871: raise fnd_api.g_exc_error;
872: END IF;
873: FETCH group_mem_roles_cur INTO group_mem_roles_rec;

Line 871: raise fnd_api.g_exc_error;

867:
868: END IF; -- end of start_date check
869: if ( l_return_status <> fnd_api.g_ret_sts_success)
870: then
871: raise fnd_api.g_exc_error;
872: END IF;
873: FETCH group_mem_roles_cur INTO group_mem_roles_rec;
874: END LOOP; -- end of group_mem_roles_cur
875: CLOSE group_mem_roles_cur;

Line 908: if ( l_return_status <> fnd_api.g_ret_sts_success)

904: X_MSG_COUNT => l_msg_count,
905: X_MSG_DATA => l_msg_data);
906:
907: END IF; -- end of start_date check
908: if ( l_return_status <> fnd_api.g_ret_sts_success)
909: then
910: raise fnd_api.g_exc_error;
911: END IF;
912: FETCH grp_relations_cur INTO grp_relations_rec;

Line 910: raise fnd_api.g_exc_error;

906:
907: END IF; -- end of start_date check
908: if ( l_return_status <> fnd_api.g_ret_sts_success)
909: then
910: raise fnd_api.g_exc_error;
911: END IF;
912: FETCH grp_relations_cur INTO grp_relations_rec;
913: END LOOP; -- end of grp_relations_cur
914: CLOSE grp_relations_cur;

Line 925: P_INIT_MSG_LIST => fnd_api.g_true,

921:
922: --for future dated groups terminate it anyway
923: jtf_rs_groups_pub.update_resource_group
924: (P_API_VERSION => 1.0,
925: P_INIT_MSG_LIST => fnd_api.g_true,
926: P_COMMIT => fnd_api.g_false,
927: P_GROUP_ID => term_grp_rec.group_id,
928: P_GROUP_NUMBER => term_grp_rec.group_number,
929: P_START_DATE_ACTIVE => trunc(p_end_date_active - 1) ,

Line 926: P_COMMIT => fnd_api.g_false,

922: --for future dated groups terminate it anyway
923: jtf_rs_groups_pub.update_resource_group
924: (P_API_VERSION => 1.0,
925: P_INIT_MSG_LIST => fnd_api.g_true,
926: P_COMMIT => fnd_api.g_false,
927: P_GROUP_ID => term_grp_rec.group_id,
928: P_GROUP_NUMBER => term_grp_rec.group_number,
929: P_START_DATE_ACTIVE => trunc(p_end_date_active - 1) ,
930: P_END_DATE_ACTIVE => trunc(p_end_date_active) ,

Line 941: P_INIT_MSG_LIST => fnd_api.g_true,

937:
938: --put end_date to p_end_date_active
939: jtf_rs_groups_pub.update_resource_group
940: (P_API_VERSION => 1.0,
941: P_INIT_MSG_LIST => fnd_api.g_true,
942: P_COMMIT => fnd_api.g_false,
943: P_GROUP_ID => term_grp_rec.group_id,
944: P_GROUP_NUMBER => term_grp_rec.group_number,
945: P_END_DATE_ACTIVE => trunc(p_end_date_active),

Line 942: P_COMMIT => fnd_api.g_false,

938: --put end_date to p_end_date_active
939: jtf_rs_groups_pub.update_resource_group
940: (P_API_VERSION => 1.0,
941: P_INIT_MSG_LIST => fnd_api.g_true,
942: P_COMMIT => fnd_api.g_false,
943: P_GROUP_ID => term_grp_rec.group_id,
944: P_GROUP_NUMBER => term_grp_rec.group_number,
945: P_END_DATE_ACTIVE => trunc(p_end_date_active),
946: P_OBJECT_VERSION_NUM => l_object_version_num_grp,

Line 955: if ( l_return_status <> fnd_api.g_ret_sts_success) then

951: END IF; -- end of terminate group
952:
953: x_object_ver_number := l_object_version_num_grp;
954:
955: if ( l_return_status <> fnd_api.g_ret_sts_success) then
956: raise fnd_api.g_exc_error;
957: END IF;
958:
959: end if; -- end of term_grp_cur

Line 956: raise fnd_api.g_exc_error;

952:
953: x_object_ver_number := l_object_version_num_grp;
954:
955: if ( l_return_status <> fnd_api.g_ret_sts_success) then
956: raise fnd_api.g_exc_error;
957: END IF;
958:
959: end if; -- end of term_grp_cur
960: close term_grp_cur;

Line 965: WHEN fnd_api.g_exc_unexpected_error

961:
962: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
963:
964: EXCEPTION
965: WHEN fnd_api.g_exc_unexpected_error
966: THEN
967: ROLLBACK TO group_mem_roles_save;
968: x_return_status := fnd_api.g_ret_sts_error;
969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 968: x_return_status := fnd_api.g_ret_sts_error;

964: EXCEPTION
965: WHEN fnd_api.g_exc_unexpected_error
966: THEN
967: ROLLBACK TO group_mem_roles_save;
968: x_return_status := fnd_api.g_ret_sts_error;
969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
970: WHEN fnd_api.g_exc_error
971: THEN
972: ROLLBACK TO group_mem_roles_save;

Line 970: WHEN fnd_api.g_exc_error

966: THEN
967: ROLLBACK TO group_mem_roles_save;
968: x_return_status := fnd_api.g_ret_sts_error;
969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
970: WHEN fnd_api.g_exc_error
971: THEN
972: ROLLBACK TO group_mem_roles_save;
973: x_return_status := fnd_api.g_ret_sts_error;
974: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 973: x_return_status := fnd_api.g_ret_sts_error;

969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
970: WHEN fnd_api.g_exc_error
971: THEN
972: ROLLBACK TO group_mem_roles_save;
973: x_return_status := fnd_api.g_ret_sts_error;
974: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
975:
976: WHEN OTHERS
977: THEN

Line 984: x_return_status := fnd_api.g_ret_sts_unexp_error;

980: fnd_message.set_token('P_SQLCODE',SQLCODE);
981: fnd_message.set_token('P_SQLERRM',SQLERRM);
982: fnd_message.set_token('P_API_NAME',l_api_name);
983: FND_MSG_PUB.add;
984: x_return_status := fnd_api.g_ret_sts_unexp_error;
985: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
986:
987: END end_date_group;
988: