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 564: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)

560:
561: select start_date,end_date into userStartDate,userEndDate from FND_USER
562: where user_id = X_USER_ID;
563:
564: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
566: fnd_user_pkg.EnableUser (
567: username => X_USER_NAME,
568: start_date => sysdate,

Line 565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then

561: select start_date,end_date into userStartDate,userEndDate from FND_USER
562: where user_id = X_USER_ID;
563:
564: if to_char(userStartDate) = to_char(FND_API.G_MISS_DATE)
565: and to_char(userEndDate) = to_char(FND_API.G_MISS_DATE) then
566: fnd_user_pkg.EnableUser (
567: username => X_USER_NAME,
568: start_date => sysdate,
569: end_date => fnd_user_pkg.null_date);

Line 745: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM

741: PROCEDURE ASSIGN_ACCOUNT
742: (
743: P_PARTY_ID NUMBER,
744: P_USERTYPE_KEY VARCHAR2,
745: P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
746: )
747: IS
748:
749: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B

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

840: );
841: end if;
842:
843: end if;
844: if(x_return_status <> fnd_api.g_ret_sts_success)
845: then
846: jtf_debug_pub.log_exception(p_module => MODULE_NAME
847: ,p_message => ' message stack in account creation:'||x_msg_data);
848: raise_application_error(-20101,'Failed to create account:'||x_msg_data);

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

865: x_msg_count => x_msg_count,
866: x_msg_data => x_msg_data
867: );
868:
869: if(x_return_status <> fnd_api.g_ret_sts_success)
870: then
871: raise_application_error(-20101,'Failed to create cust account role:'||x_msg_data);
872: end if;
873: end if;

Line 1521: RETCODE := FND_API.G_RET_STS_SUCCESS;

1517:
1518:
1519: BEGIN
1520:
1521: RETCODE := FND_API.G_RET_STS_SUCCESS;
1522:
1523: OPEN FIND_BUS_UT_ID;
1524: FETCH FIND_BUS_UT_ID INTO l_new_usertype_id;
1525: IF FIND_BUS_UT_ID%NOTFOUND THEN

Line 1527: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1523: OPEN FIND_BUS_UT_ID;
1524: FETCH FIND_BUS_UT_ID INTO l_new_usertype_id;
1525: IF FIND_BUS_UT_ID%NOTFOUND THEN
1526: ERRBUF := ERRBUF || fnd_global.newline || 'Could not find valid Business User type';
1527: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1528: END IF;
1529: CLOSE FIND_BUS_UT_ID;
1530:
1531:

Line 1536: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN

1532: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USER_HEADER');
1533: fnd_file.new_line(fnd_file.log,1);
1534: fnd_file.put_line(fnd_file.log, fnd_message.get);
1535:
1536: IF RETCODE = FND_API.G_RET_STS_SUCCESS THEN
1537:
1538: FOR i IN PRIMARY_USERS LOOP
1539: fnd_message.set_name('JTF','JTA_UM_PRI_UP_USERS');
1540: UPDATE JTF_UM_USERTYPE_REG SET USERTYPE_ID = l_new_usertype_id