APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on FND_API

Line 13: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM

9: PROCEDURE CREATE_ACCOUNT
10: (
11: P_PARTY_ID NUMBER,
12: P_PARTY_TYPE VARCHAR2,
13: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
14: )
15: IS
16:
17:

Line 121: if(x_return_status <> fnd_api.g_ret_sts_success)

117: );
118: end if;
119:
120: end if;
121: if(x_return_status <> fnd_api.g_ret_sts_success)
122: then
123: jtf_debug_pub.log_exception(p_module => MODULE_NAME
124: ,p_message => ' message stack in account creation:'||x_msg_data);
125: raise_application_error(-20101,'Failed to create account:'||x_msg_data);

Line 152: if(x_return_status <> fnd_api.g_ret_sts_success)

148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data
150: );
151:
152: if(x_return_status <> fnd_api.g_ret_sts_success)
153: then
154: raise_application_error(-20101,'Failed to create cust account role:'||x_msg_data);
155: end if;
156: end if;

Line 172: AND (NVL(END_DATE,SYSDATE+1) > SYSDATE OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;

168: IS
169: SELECT CUSTOMER_ID
170: FROM FND_USER
171: WHERE USER_ID = X_USER_ID
172: AND (NVL(END_DATE,SYSDATE+1) > SYSDATE OR to_char(END_DATE) = to_char(FND_API.G_MISS_DATE)) ;
173:
174: CURSOR ORG_PARTY_ID
175: IS
176: SELECT FU.CUSTOMER_ID,HZR.SUBJECT_ID,HZR.OBJECT_ID

Line 186: AND ( NVL(FU.end_date,SYSDATE+1) > SYSDATE OR to_char(FU.END_DATE) = to_char(FND_API.G_MISS_DATE));

182: AND HZR.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
183: AND HZR.object_table_name = 'HZ_PARTIES'
184: AND HZR.START_DATE <= SYSDATE
185: AND NVL(HZR.END_DATE, SYSDATE + 1) > SYSDATE
186: AND ( NVL(FU.end_date,SYSDATE+1) > SYSDATE OR to_char(FU.END_DATE) = to_char(FND_API.G_MISS_DATE));
187:
188: l_procedure_name CONSTANT varchar2(30) := 'QUERY_ACCOUNT';
189: l_party_type HZ_PARTIES.party_type%type;
190: l_customer_id NUMBER;

Line 613: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE) and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then

609:
610: select start_date,end_date into userStartDate,userEndDate from FND_USER
611: where user_id = X_USER_ID;
612:
613: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE) and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
614: fnd_user_pkg.EnableUser (
615: username => X_USER_NAME,
616: start_date => sysdate,
617: end_date => fnd_user_pkg.null_date);

Line 800: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM

796: PROCEDURE ASSIGN_ACCOUNT
797: (
798: P_PARTY_ID NUMBER,
799: P_USERTYPE_KEY VARCHAR2,
800: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
801: )
802: IS
803:
804: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B

Line 899: if(x_return_status <> fnd_api.g_ret_sts_success)

895: );
896: end if;
897:
898: end if;
899: if(x_return_status <> fnd_api.g_ret_sts_success)
900: then
901: jtf_debug_pub.log_exception(p_module => MODULE_NAME
902: ,p_message => ' message stack in account creation:'||x_msg_data);
903: raise_application_error(-20101,'Failed to create account:'||x_msg_data);

Line 924: if(x_return_status <> fnd_api.g_ret_sts_success)

920: x_msg_count => x_msg_count,
921: x_msg_data => x_msg_data
922: );
923:
924: if(x_return_status <> fnd_api.g_ret_sts_success)
925: then
926: raise_application_error(-20101,'Failed to create cust account role:'||x_msg_data);
927: end if;
928: end if;

Line 1577: RETCODE := FND_API.G_RET_STS_SUCCESS;

1573:
1574:
1575: BEGIN
1576:
1577: RETCODE := FND_API.G_RET_STS_SUCCESS;
1578:
1579: OPEN FIND_BUS_UT_ID;
1580: FETCH FIND_BUS_UT_ID INTO l_new_usertype_id;
1581: IF FIND_BUS_UT_ID%NOTFOUND THEN

Line 1583: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1579: OPEN FIND_BUS_UT_ID;
1580: FETCH FIND_BUS_UT_ID INTO l_new_usertype_id;
1581: IF FIND_BUS_UT_ID%NOTFOUND THEN
1582: ERRBUF := ERRBUF || fnd_global.newline || 'Could not find valid Business User type';
1583: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1584: END IF;
1585: CLOSE FIND_BUS_UT_ID;
1586:
1587:

Line 1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN

1588: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USER_HEADER');
1589: fnd_file.new_line(fnd_file.log,1);
1590: fnd_file.put_line(fnd_file.log, fnd_message.get);
1591:
1592: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1593:
1594: FOR i IN PRIMARY_USERS LOOP
1595: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');
1596: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id