APPS.JTF_RS_IMPORT_USER_PUB dependencies on FND_API

Line 18: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;

14: P_TRANSACTION_NO IN NUMBER
15: ) IS
16:
17: l_api_name constant varchar2(30) := 'CRT_BULK_IMPORT';
18: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
19: l_msg_count number;
20: l_msg_data varchar2(2000);
21: l_msg_data1 varchar2(2000);
22: l_msg_index_out varchar2(2000);

Line 378: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

374: X_RETURN_STATUS => l_return_status,
375: X_MSG_COUNT => l_msg_count,
376: X_MSG_DATA => l_msg_data
377: );
378: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
379: l_error_flag := 'Y';
380: end if;
381: end if;
382:

Line 398: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

394: x_msg_count => l_msg_count,
395: x_msg_data => l_msg_data,
396: x_group_member_id => l_group_member_id
397: );
398: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
399: l_error_flag_grp := 'Y';
400: end if;
401: end if;
402: end if;

Line 421: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

417: x_msg_count => l_msg_count,
418: x_msg_data => l_msg_data,
419: x_role_relate_id => l_role_relate_id
420: );
421: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
422: l_error_flag_role := 'Y';
423: end if;
424: end if;
425:

Line 441: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

437: x_msg_count => l_msg_count,
438: x_msg_data => l_msg_data,
439: x_role_relate_id => l_role_relate_id
440: );
441: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
442: l_error_flag_role := 'Y';
443: end if;
444: end if;
445: end if;

Line 464: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

460: x_msg_count => l_msg_count,
461: x_msg_data => l_msg_data,
462: x_role_relate_id => l_role_relate_id
463: );
464: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
465: l_error_flag_role := 'Y';
466: end if;
467: end if;
468:

Line 484: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

480: x_msg_count => l_msg_count,
481: x_msg_data => l_msg_data,
482: x_role_relate_id => l_role_relate_id
483: );
484: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
485: l_error_flag_role := 'Y';
486: end if;
487: end if;
488: end if;

Line 568: if not (l_return_status = fnd_api.g_ret_sts_success) THEN

564: x_msg_count => l_msg_count,
565: x_msg_data => l_msg_data
566: );
567:
568: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');
570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:

Line 633: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

629: END crt_bulk_import;
630:
631: PROCEDURE import_user
632: (P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
634: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
635: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
636: P_REQUEST_NO OUT NOCOPY NUMBER,
637: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 634: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

630:
631: PROCEDURE import_user
632: (P_API_VERSION IN NUMBER,
633: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
634: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
635: P_TRANSACTION_NO IN JTF_RS_UPLOAD_DATA.TRANSACTION_NO%TYPE,
636: P_REQUEST_NO OUT NOCOPY NUMBER,
637: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
638: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 648: x_return_status := fnd_api.g_ret_sts_success;

644: l_request NUMBER;
645:
646: begin
647:
648: x_return_status := fnd_api.g_ret_sts_success;
649:
650: l_request := fnd_request.submit_request(application => 'JTF',
651: program => 'JTFRSIMPUSER',
652: argument1 => p_transaction_no);

Line 666: x_return_status := fnd_api.g_ret_sts_unexp_error;

662: fnd_message.set_token('P_SQLCODE',SQLCODE);
663: fnd_message.set_token('P_SQLERRM',SQLERRM);
664: fnd_message.set_token('P_API_NAME', l_api_name);
665: FND_MSG_PUB.add;
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
668: RAISE fnd_api.g_exc_unexpected_error;
669:
670: END import_user;

Line 668: RAISE fnd_api.g_exc_unexpected_error;

664: fnd_message.set_token('P_API_NAME', l_api_name);
665: FND_MSG_PUB.add;
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
668: RAISE fnd_api.g_exc_unexpected_error;
669:
670: END import_user;
671:
672: procedure update_upload_data (