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_RES_SSWA_PUB dependencies on FND_API

Line 13: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

9: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RES_SSWA_PUB';
10:
11: PROCEDURE create_emp_resource
12: (P_API_VERSION IN NUMBER,
13: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15: P_SOURCE_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
16: P_SOURCE_LAST_NAME IN VARCHAR2,
17: P_SOURCE_MIDDLE_NAME IN VARCHAR2 DEFAULT NULL,

Line 14: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

10:
11: PROCEDURE create_emp_resource
12: (P_API_VERSION IN NUMBER,
13: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
14: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
15: P_SOURCE_FIRST_NAME IN VARCHAR2 DEFAULT NULL,
16: P_SOURCE_LAST_NAME IN VARCHAR2,
17: P_SOURCE_MIDDLE_NAME IN VARCHAR2 DEFAULT NULL,
18: P_EMPLOYEE_NUMBER IN VARCHAR2 DEFAULT NULL,

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

40: ) IS
41:
42: l_api_version constant number := 1.0;
43: l_api_name constant varchar2(30) := 'CREATE_EMP_RESOURCE';
44: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
45: l_address_id number := to_number(p_source_address_id);
46: l_job_id number := p_source_job_id;
47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;

Line 210: x_return_status := fnd_api.g_ret_sts_success;

206: hr_api_error exception;
207: PRAGMA EXCEPTION_INIT(hr_api_error, -20001);
208:
209: BEGIN
210: x_return_status := fnd_api.g_ret_sts_success;
211:
212: savepoint cr_emp_save;
213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE

Line 215: if fnd_api.tO_BOOLEAN(p_init_msg_list)

211:
212: savepoint cr_emp_save;
213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
215: if fnd_api.tO_BOOLEAN(p_init_msg_list)
216: then
217: fnd_msg_pub.Initialize;
218: end if;
219:

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

338: x_return_status => l_return_status,
339: x_msg_count => x_msg_count,
340: x_msg_data => x_msg_data
341: );
342: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
343: raise fnd_api.g_exc_unexpected_error;
344: end if;
345:
346: p_user_password := l_user_password;

Line 343: raise fnd_api.g_exc_unexpected_error;

339: x_msg_count => x_msg_count,
340: x_msg_data => x_msg_data
341: );
342: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
343: raise fnd_api.g_exc_unexpected_error;
344: end if;
345:
346: p_user_password := l_user_password;
347:

Line 374: if(l_address_id <> fnd_api.g_miss_num)

370:
371: end if;
372:
373: /* Fetching Location datails */
374: if(l_address_id <> fnd_api.g_miss_num)
375: then
376: open address_cur(l_address_id);
377: fetch address_cur
378: into l_address_line_1,

Line 403: ,p_init_msg_list => fnd_api.g_false

399: -- Calling Create Resource API
400:
401: jtf_rs_resource_pub.create_resource
402: ( p_api_version => 1.0
403: ,p_init_msg_list => fnd_api.g_false
404: ,p_commit => fnd_api.g_false
405: ,p_category => 'EMPLOYEE'
406: ,p_source_id => l_person_id
407: ,p_address_id => p_source_address_id

Line 404: ,p_commit => fnd_api.g_false

400:
401: jtf_rs_resource_pub.create_resource
402: ( p_api_version => 1.0
403: ,p_init_msg_list => fnd_api.g_false
404: ,p_commit => fnd_api.g_false
405: ,p_category => 'EMPLOYEE'
406: ,p_source_id => l_person_id
407: ,p_address_id => p_source_address_id
408: ,p_contact_id => null

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

463: ,p_source_mailstop => p_source_mailstop
464: ,p_user_name => l_user_name
465: );
466:
467: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
468: raise fnd_api.g_exc_unexpected_error;
469: end if;
470:
471: x_resource_id := l_resource_id;

Line 468: raise fnd_api.g_exc_unexpected_error;

464: ,p_user_name => l_user_name
465: );
466:
467: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
468: raise fnd_api.g_exc_unexpected_error;
469: end if;
470:
471: x_resource_id := l_resource_id;
472:

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

502: ,x_msg_data => l_msg_data
503: ,x_salesrep_id => l_salesrep_id
504: );
505:
506: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
507: raise fnd_api.g_exc_unexpected_error;
508: end if;
509:
510: if (p_called_from <> 'CRT_BULK_IMPORT') then

Line 507: raise fnd_api.g_exc_unexpected_error;

503: ,x_salesrep_id => l_salesrep_id
504: );
505:
506: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
507: raise fnd_api.g_exc_unexpected_error;
508: end if;
509:
510: if (p_called_from <> 'CRT_BULK_IMPORT') then
511:

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

520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data
522: );
523:
524: -- if not (l_return_status = fnd_api.g_ret_sts_success) THEN
525: -- raise fnd_api.g_exc_unexpected_error;
526: -- end if;
527:
528: end if;

Line 525: -- raise fnd_api.g_exc_unexpected_error;

521: x_msg_data => x_msg_data
522: );
523:
524: -- if not (l_return_status = fnd_api.g_ret_sts_success) THEN
525: -- raise fnd_api.g_exc_unexpected_error;
526: -- end if;
527:
528: end if;
529:

Line 530: if fnd_api.to_boolean(p_commit)

526: -- end if;
527:
528: end if;
529:
530: if fnd_api.to_boolean(p_commit)
531: then
532: commit work;
533: end if;
534:

Line 539: x_return_status := fnd_api.g_ret_sts_error;

535: exception
536: WHEN hr_api_error
537: THEN
538: ROLLBACK TO cr_emp_save;
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
541: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
542: FND_MSG_PUB.add;
543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 544: when fnd_api.g_exc_unexpected_error

540: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
541: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
542: FND_MSG_PUB.add;
543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
544: when fnd_api.g_exc_unexpected_error
545: then
546: rollback to cr_emp_save;
547: x_return_status := fnd_api.g_ret_sts_error;
548: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 547: x_return_status := fnd_api.g_ret_sts_error;

543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
544: when fnd_api.g_exc_unexpected_error
545: then
546: rollback to cr_emp_save;
547: x_return_status := fnd_api.g_ret_sts_error;
548: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
549: when others
550: then
551: rollback to cr_emp_save;

Line 557: x_return_status := fnd_api.g_ret_sts_unexp_error;

553: fnd_message.set_token('P_SQLCODE',SQLCODE);
554: fnd_message.set_token('P_SQLERRM',SQLERRM);
555: fnd_message.set_token('P_API_NAME',l_api_name);
556: FND_MSG_PUB.add;
557: x_return_status := fnd_api.g_ret_sts_unexp_error;
558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
559:
560: END create_emp_resource;
561:

Line 564: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

560: END create_emp_resource;
561:
562: PROCEDURE update_resource
563: (P_API_VERSION IN NUMBER,
564: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
565: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
566: P_RESOURCE_ID IN NUMBER,
567: P_RESOURCE_NUMBER IN VARCHAR2,
568: P_RESOURCE_NAME IN VARCHAR2 ,

Line 565: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

561:
562: PROCEDURE update_resource
563: (P_API_VERSION IN NUMBER,
564: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
565: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
566: P_RESOURCE_ID IN NUMBER,
567: P_RESOURCE_NUMBER IN VARCHAR2,
568: P_RESOURCE_NAME IN VARCHAR2 ,
569: P_SOURCE_NAME IN VARCHAR2 ,

Line 578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

574: P_SOURCE_PHONE IN VARCHAR2 ,
575: P_SOURCE_EMAIL IN VARCHAR2 ,
576: P_OBJECT_VERSION_NUMBER IN NUMBER,
577: P_APPROVED IN VARCHAR2 DEFAULT 'N',
578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

575: P_SOURCE_EMAIL IN VARCHAR2 ,
576: P_OBJECT_VERSION_NUMBER IN NUMBER,
577: P_APPROVED IN VARCHAR2 DEFAULT 'N',
578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

576: P_OBJECT_VERSION_NUMBER IN NUMBER,
577: P_APPROVED IN VARCHAR2 DEFAULT 'N',
578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

577: P_APPROVED IN VARCHAR2 DEFAULT 'N',
578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,

578: P_SOURCE_JOB_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

579: P_SOURCE_JOB_TITLE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

580: P_SALESREP_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
588: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

581: P_SALES_CREDIT_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
588: X_MSG_COUNT OUT NOCOPY NUMBER,
589: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

582: P_END_DATE_ACTIVE IN DATE DEFAULT FND_API.G_MISS_DATE,
583: P_USER_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
584: P_USER_NAME IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
585: P_MGR_RESOURCE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
588: X_MSG_COUNT OUT NOCOPY NUMBER,
589: X_MSG_DATA OUT NOCOPY VARCHAR2,
590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,

586: P_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
588: X_MSG_COUNT OUT NOCOPY NUMBER,
589: X_MSG_DATA OUT NOCOPY VARCHAR2,
590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,

587: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
588: X_MSG_COUNT OUT NOCOPY NUMBER,
589: X_MSG_DATA OUT NOCOPY VARCHAR2,
590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

Line 592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

588: X_MSG_COUNT OUT NOCOPY NUMBER,
589: X_MSG_DATA OUT NOCOPY VARCHAR2,
590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

589: X_MSG_DATA OUT NOCOPY VARCHAR2,
590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
597: ) IS

Line 594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,

590: P_TIME_ZONE IN NUMBER DEFAULT FND_API.G_MISS_NUM,
591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
597: ) IS
598:

Line 595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

591: P_COST_PER_HR IN NUMBER DEFAULT FND_API.G_MISS_NUM,
592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
597: ) IS
598:
599: l_api_version CONSTANT NUMBER := 1.0;

Line 596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

592: P_PRIMARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
593: P_SECONDARY_LANGUAGE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
594: P_SUPPORT_SITE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
595: P_SOURCE_MOBILE_PHONE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
596: P_SOURCE_PAGER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
597: ) IS
598:
599: l_api_version CONSTANT NUMBER := 1.0;
600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';

Line 601: l_return_status VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;

597: ) IS
598:
599: l_api_version CONSTANT NUMBER := 1.0;
600: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RESOURCE';
601: l_return_status VARCHAR2(100) := FND_API.G_RET_STS_SUCCESS;
602: l_job_id number := p_source_job_id;
603: l_job_title varchar2(2000) := p_source_job_title;
604: l_supervisor_id number ;
605:

Line 755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;

751: -- Bug # 2186026
752: -- OK_... fields are set for changes for which no approval needed or just the
753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;

Line 756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;

752: -- OK_... fields are set for changes for which no approval needed or just the
753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;

Line 757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;

753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;

Line 758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;

754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;

Line 759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;

755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;

Line 760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;

756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;

Line 761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;

757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;

Line 762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;

758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;

Line 763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;

759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;

Line 764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;

760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;

Line 765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;

761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;

Line 766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;

762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:

Line 767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;

763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;

Line 768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;

764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;

Line 769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;

765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);

Line 895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;

891: source_name
892: from jtf_rs_resource_extns
893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:

Line 896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;

892: from jtf_rs_resource_extns
893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:
900: l_fnd_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

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

896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:
900: l_fnd_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
901:
902: hr_api_error exception;
903: PRAGMA EXCEPTION_INIT(hr_api_error, -20001);
904: BEGIN

Line 905: x_return_status := fnd_api.g_ret_sts_success;

901:
902: hr_api_error exception;
903: PRAGMA EXCEPTION_INIT(hr_api_error, -20001);
904: BEGIN
905: x_return_status := fnd_api.g_ret_sts_success;
906: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
907: IF FND_API.To_boolean(P_INIT_MSG_LIST)
908: THEN
909: FND_MSG_PUB.Initialize;

Line 907: IF FND_API.To_boolean(P_INIT_MSG_LIST)

903: PRAGMA EXCEPTION_INIT(hr_api_error, -20001);
904: BEGIN
905: x_return_status := fnd_api.g_ret_sts_success;
906: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
907: IF FND_API.To_boolean(P_INIT_MSG_LIST)
908: THEN
909: FND_MSG_PUB.Initialize;
910: END IF;
911: SAVEPOINT sp_save;

Line 919: x_return_status := fnd_api.g_ret_sts_success;

915: l_u := 1;
916: END IF;
917: IF(P_APPROVED='N')
918: THEN
919: x_return_status := fnd_api.g_ret_sts_success;
920: --fetch the attributes
921: open attr_cur;
922: fetch attr_cur into attr_rec;
923: while(attr_cur%found)

Line 939: if(nvl(ok_resource_name, fnd_api.g_miss_char) <>

935: fetch old_cur into old_rec;
936: if (old_cur%found)
937: then
938: --resource name
939: if(nvl(ok_resource_name, fnd_api.g_miss_char) <>
940: nvl(old_rec.resource_name, fnd_api.g_miss_char))
941: then
942: i:= 0;
943: l_found := FALSE;

Line 940: nvl(old_rec.resource_name, fnd_api.g_miss_char))

936: if (old_cur%found)
937: then
938: --resource name
939: if(nvl(ok_resource_name, fnd_api.g_miss_char) <>
940: nvl(old_rec.resource_name, fnd_api.g_miss_char))
941: then
942: i:= 0;
943: l_found := FALSE;
944: for i in 1..l_attr_rec.COUNT

Line 959: ok_resource_name := fnd_api.g_miss_char;

955: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
956: then
957: l_uwa := 1;
958: aprvl_resource_name := ok_resource_name;
959: ok_resource_name := fnd_api.g_miss_char;
960: end if;
961:
962: end if;
963: if(l_found) then exit; end if;

Line 968: if(nvl(ok_source_name, fnd_api.g_miss_char) <>

964: end loop;
965: end if;
966:
967: --source name
968: if(nvl(ok_source_name, fnd_api.g_miss_char) <>
969: nvl(old_rec.source_name, fnd_api.g_miss_char))
970: then
971: i:= 0;
972: l_found := FALSE;

Line 969: nvl(old_rec.source_name, fnd_api.g_miss_char))

965: end if;
966:
967: --source name
968: if(nvl(ok_source_name, fnd_api.g_miss_char) <>
969: nvl(old_rec.source_name, fnd_api.g_miss_char))
970: then
971: i:= 0;
972: l_found := FALSE;
973: for i in 1..l_attr_rec.COUNT

Line 988: ok_source_name := fnd_api.g_miss_char;

984: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
985: then
986: l_uwa := 1;
987: aprvl_source_name := ok_source_name;
988: ok_source_name := fnd_api.g_miss_char;
989: end if;
990:
991: end if;
992: if(l_found) then exit; end if;

Line 999: if(nvl(ok_address_id, fnd_api.g_miss_num) <>

995:
996:
997: --address
998:
999: if(nvl(ok_address_id, fnd_api.g_miss_num) <>
1000: nvl(old_rec.address_id, fnd_api.g_miss_num))
1001: then
1002: i:= 0;
1003: l_found := FALSE;

Line 1000: nvl(old_rec.address_id, fnd_api.g_miss_num))

996:
997: --address
998:
999: if(nvl(ok_address_id, fnd_api.g_miss_num) <>
1000: nvl(old_rec.address_id, fnd_api.g_miss_num))
1001: then
1002: i:= 0;
1003: l_found := FALSE;
1004: for i in 1..l_attr_rec.COUNT

Line 1019: ok_address_id := fnd_api.g_miss_num;

1015: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1016: then
1017: l_uwa := 1;
1018: aprvl_address_id := ok_address_id;
1019: ok_address_id := fnd_api.g_miss_num;
1020: end if;
1021:
1022: end if;
1023: if(l_found) then exit; end if;

Line 1026: ok_address_id := fnd_api.g_miss_num;

1022: end if;
1023: if(l_found) then exit; end if;
1024: end loop;
1025: else
1026: ok_address_id := fnd_api.g_miss_num;
1027: end if;
1028:
1029:
1030: --office

Line 1032: if(nvl(ok_source_office, fnd_api.g_miss_char) <>

1028:
1029:
1030: --office
1031:
1032: if(nvl(ok_source_office, fnd_api.g_miss_char) <>
1033: nvl(old_rec.source_office, fnd_api.g_miss_char))
1034: then
1035: i:= 0;
1036: l_found := FALSE;

Line 1033: nvl(old_rec.source_office, fnd_api.g_miss_char))

1029:
1030: --office
1031:
1032: if(nvl(ok_source_office, fnd_api.g_miss_char) <>
1033: nvl(old_rec.source_office, fnd_api.g_miss_char))
1034: then
1035: i:= 0;
1036: l_found := FALSE;
1037: for i in 1..l_attr_rec.COUNT

Line 1067: if(nvl(ok_source_mailstop, fnd_api.g_miss_char) <>

1063: end if;
1064:
1065: --mailstop
1066:
1067: if(nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1068: nvl(old_rec.source_mailstop, fnd_api.g_miss_char))
1069: then
1070: i:= 0;
1071: l_found := FALSE;

Line 1068: nvl(old_rec.source_mailstop, fnd_api.g_miss_char))

1064:
1065: --mailstop
1066:
1067: if(nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1068: nvl(old_rec.source_mailstop, fnd_api.g_miss_char))
1069: then
1070: i:= 0;
1071: l_found := FALSE;
1072: for i in 1..l_attr_rec.COUNT

Line 1101: if(nvl(ok_source_location, fnd_api.g_miss_char) <>

1097: end if;
1098:
1099: --location
1100:
1101: if(nvl(ok_source_location, fnd_api.g_miss_char) <>
1102: nvl(old_rec.source_location, fnd_api.g_miss_char))
1103: then
1104: i:= 0;
1105: l_found := FALSE;

Line 1102: nvl(old_rec.source_location, fnd_api.g_miss_char))

1098:
1099: --location
1100:
1101: if(nvl(ok_source_location, fnd_api.g_miss_char) <>
1102: nvl(old_rec.source_location, fnd_api.g_miss_char))
1103: then
1104: i:= 0;
1105: l_found := FALSE;
1106: for i in 1..l_attr_rec.COUNT

Line 1135: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>

1131: end if;
1132:
1133:
1134: --phone
1135: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>
1136: nvl(old_rec.source_phone, fnd_api.g_miss_char))
1137: then
1138: i:= 0;
1139: l_found := FALSE;

Line 1136: nvl(old_rec.source_phone, fnd_api.g_miss_char))

1132:
1133:
1134: --phone
1135: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>
1136: nvl(old_rec.source_phone, fnd_api.g_miss_char))
1137: then
1138: i:= 0;
1139: l_found := FALSE;
1140: for i in 1..l_attr_rec.COUNT

Line 1168: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>

1164: end loop;
1165: end if;
1166:
1167: --mobile phone
1168: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>
1169: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))
1170: then
1171: i:= 0;
1172: l_found := FALSE;

Line 1169: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))

1165: end if;
1166:
1167: --mobile phone
1168: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>
1169: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))
1170: then
1171: i:= 0;
1172: l_found := FALSE;
1173: for i in 1..l_attr_rec.COUNT

Line 1201: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>

1197: end loop;
1198: end if;
1199:
1200: --pager
1201: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>
1202: nvl(old_rec.source_pager, fnd_api.g_miss_char))
1203: then
1204: i:= 0;
1205: l_found := FALSE;

Line 1202: nvl(old_rec.source_pager, fnd_api.g_miss_char))

1198: end if;
1199:
1200: --pager
1201: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>
1202: nvl(old_rec.source_pager, fnd_api.g_miss_char))
1203: then
1204: i:= 0;
1205: l_found := FALSE;
1206: for i in 1..l_attr_rec.COUNT

Line 1234: if(nvl(ok_source_email, fnd_api.g_miss_char) <>

1230: end loop;
1231: end if;
1232:
1233: --email
1234: if(nvl(ok_source_email, fnd_api.g_miss_char) <>
1235: nvl(old_rec.source_email, fnd_api.g_miss_char))
1236: then
1237: i:= 0;
1238: l_found := FALSE;

Line 1235: nvl(old_rec.source_email, fnd_api.g_miss_char))

1231: end if;
1232:
1233: --email
1234: if(nvl(ok_source_email, fnd_api.g_miss_char) <>
1235: nvl(old_rec.source_email, fnd_api.g_miss_char))
1236: then
1237: i:= 0;
1238: l_found := FALSE;
1239: for i in 1..l_attr_rec.COUNT

Line 1267: if(nvl(ok_time_zone, fnd_api.g_miss_num) <>

1263: end loop;
1264: end if;
1265:
1266: --time zone
1267: if(nvl(ok_time_zone, fnd_api.g_miss_num) <>
1268: nvl(old_rec.time_zone, fnd_api.g_miss_num))
1269: then
1270: i:= 0;
1271: l_found := FALSE;

Line 1268: nvl(old_rec.time_zone, fnd_api.g_miss_num))

1264: end if;
1265:
1266: --time zone
1267: if(nvl(ok_time_zone, fnd_api.g_miss_num) <>
1268: nvl(old_rec.time_zone, fnd_api.g_miss_num))
1269: then
1270: i:= 0;
1271: l_found := FALSE;
1272: for i in 1..l_attr_rec.COUNT

Line 1287: ok_time_zone := fnd_api.g_miss_num;

1283: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1284: then
1285: l_uwa := 1;
1286: aprvl_time_zone := ok_time_zone;
1287: ok_time_zone := fnd_api.g_miss_num;
1288: end if;
1289:
1290: end if;
1291: if(l_found) then exit; end if;

Line 1294: ok_time_zone := fnd_api.g_miss_num;

1290: end if;
1291: if(l_found) then exit; end if;
1292: end loop;
1293: else
1294: ok_time_zone := fnd_api.g_miss_num;
1295: end if;
1296:
1297: --Support site
1298: if(nvl(ok_support_site_id, fnd_api.g_miss_num) <>

Line 1298: if(nvl(ok_support_site_id, fnd_api.g_miss_num) <>

1294: ok_time_zone := fnd_api.g_miss_num;
1295: end if;
1296:
1297: --Support site
1298: if(nvl(ok_support_site_id, fnd_api.g_miss_num) <>
1299: nvl(old_rec.support_site_id, fnd_api.g_miss_num))
1300: then
1301: i:= 0;
1302: l_found := FALSE;

Line 1299: nvl(old_rec.support_site_id, fnd_api.g_miss_num))

1295: end if;
1296:
1297: --Support site
1298: if(nvl(ok_support_site_id, fnd_api.g_miss_num) <>
1299: nvl(old_rec.support_site_id, fnd_api.g_miss_num))
1300: then
1301: i:= 0;
1302: l_found := FALSE;
1303: for i in 1..l_attr_rec.COUNT

Line 1318: ok_support_site_id := fnd_api.g_miss_num;

1314: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1315: then
1316: l_uwa := 1;
1317: aprvl_support_site_id := ok_support_site_id;
1318: ok_support_site_id := fnd_api.g_miss_num;
1319: end if;
1320:
1321: end if;
1322: if(l_found) then exit; end if;

Line 1325: ok_support_site_id := fnd_api.g_miss_num;

1321: end if;
1322: if(l_found) then exit; end if;
1323: end loop;
1324: else
1325: ok_support_site_id := fnd_api.g_miss_num;
1326: end if;
1327:
1328: --primary language
1329: if(nvl(ok_primary_language, fnd_api.g_miss_char) <>

Line 1329: if(nvl(ok_primary_language, fnd_api.g_miss_char) <>

1325: ok_support_site_id := fnd_api.g_miss_num;
1326: end if;
1327:
1328: --primary language
1329: if(nvl(ok_primary_language, fnd_api.g_miss_char) <>
1330: nvl(old_rec.primary_language, fnd_api.g_miss_char))
1331: then
1332: i:= 0;
1333: l_found := FALSE;

Line 1330: nvl(old_rec.primary_language, fnd_api.g_miss_char))

1326: end if;
1327:
1328: --primary language
1329: if(nvl(ok_primary_language, fnd_api.g_miss_char) <>
1330: nvl(old_rec.primary_language, fnd_api.g_miss_char))
1331: then
1332: i:= 0;
1333: l_found := FALSE;
1334: for i in 1..l_attr_rec.COUNT

Line 1349: ok_primary_language := fnd_api.g_miss_char;

1345: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1346: then
1347: l_uwa := 1;
1348: aprvl_primary_language := ok_primary_language;
1349: ok_primary_language := fnd_api.g_miss_char;
1350: end if;
1351:
1352: end if;
1353: if(l_found) then exit; end if;

Line 1356: ok_primary_language := fnd_api.g_miss_char;

1352: end if;
1353: if(l_found) then exit; end if;
1354: end loop;
1355: else
1356: ok_primary_language := fnd_api.g_miss_char;
1357: end if;
1358:
1359: --secondary language
1360: if(nvl(ok_secondary_language, fnd_api.g_miss_char) <>

Line 1360: if(nvl(ok_secondary_language, fnd_api.g_miss_char) <>

1356: ok_primary_language := fnd_api.g_miss_char;
1357: end if;
1358:
1359: --secondary language
1360: if(nvl(ok_secondary_language, fnd_api.g_miss_char) <>
1361: nvl(old_rec.secondary_language, fnd_api.g_miss_char))
1362: then
1363: i:= 0;
1364: l_found := FALSE;

Line 1361: nvl(old_rec.secondary_language, fnd_api.g_miss_char))

1357: end if;
1358:
1359: --secondary language
1360: if(nvl(ok_secondary_language, fnd_api.g_miss_char) <>
1361: nvl(old_rec.secondary_language, fnd_api.g_miss_char))
1362: then
1363: i:= 0;
1364: l_found := FALSE;
1365: for i in 1..l_attr_rec.COUNT

Line 1380: ok_secondary_language := fnd_api.g_miss_char;

1376: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1377: then
1378: l_uwa := 1;
1379: aprvl_secondary_language := ok_secondary_language;
1380: ok_secondary_language := fnd_api.g_miss_char;
1381: end if;
1382:
1383: end if;
1384: if(l_found) then exit; end if;

Line 1387: ok_secondary_language := fnd_api.g_miss_char;

1383: end if;
1384: if(l_found) then exit; end if;
1385: end loop;
1386: else
1387: ok_secondary_language := fnd_api.g_miss_char;
1388: end if;
1389:
1390: --Rate
1391: if(nvl(ok_cost_per_hr, fnd_api.g_miss_num) <>

Line 1391: if(nvl(ok_cost_per_hr, fnd_api.g_miss_num) <>

1387: ok_secondary_language := fnd_api.g_miss_char;
1388: end if;
1389:
1390: --Rate
1391: if(nvl(ok_cost_per_hr, fnd_api.g_miss_num) <>
1392: nvl(old_rec.cost_per_hr, fnd_api.g_miss_num))
1393: then
1394: i:= 0;
1395: l_found := FALSE;

Line 1392: nvl(old_rec.cost_per_hr, fnd_api.g_miss_num))

1388: end if;
1389:
1390: --Rate
1391: if(nvl(ok_cost_per_hr, fnd_api.g_miss_num) <>
1392: nvl(old_rec.cost_per_hr, fnd_api.g_miss_num))
1393: then
1394: i:= 0;
1395: l_found := FALSE;
1396: for i in 1..l_attr_rec.COUNT

Line 1411: ok_cost_per_hr := fnd_api.g_miss_num;

1407: elsif(l_attr_rec(i).attribute_access_level = 'UWA')
1408: then
1409: l_uwa := 1;
1410: aprvl_cost_per_hr := ok_cost_per_hr;
1411: ok_cost_per_hr := fnd_api.g_miss_num;
1412: end if;
1413:
1414: end if;
1415: if(l_found) then exit; end if;

Line 1418: ok_cost_per_hr := fnd_api.g_miss_num;

1414: end if;
1415: if(l_found) then exit; end if;
1416: end loop;
1417: else
1418: ok_cost_per_hr := fnd_api.g_miss_num;
1419: end if;
1420:
1421:
1422: end if; -- end of old cou

Line 1431: if p_user_id = fnd_api.g_miss_num

1427: open old_cur;
1428: fetch old_cur into old_rec;
1429: if (old_cur%found)
1430: then
1431: if p_user_id = fnd_api.g_miss_num
1432: then
1433: --fetch user name (use the user_id of resource_id from table)
1434: open user_cur(old_rec.user_id);
1435: fetch user_cur into l_user_name;

Line 1457: if(nvl(l_mgr_source_id, fnd_api.g_miss_num) = nvl(old_rec.source_mgr_id, fnd_api.g_miss_num))

1453: open mgr_res_cur(p_mgr_resource_id);
1454: fetch mgr_res_cur into mgr_res_rec;
1455: l_mgr_source_id := mgr_res_rec.source_id;
1456: l_mgr_source_name := mgr_res_rec.source_name;
1457: if(nvl(l_mgr_source_id, fnd_api.g_miss_num) = nvl(old_rec.source_mgr_id, fnd_api.g_miss_num))
1458: then
1459: l_supervisor_id := fnd_api.g_miss_num;
1460: else
1461: l_supervisor_id := l_mgr_source_id;

Line 1459: l_supervisor_id := fnd_api.g_miss_num;

1455: l_mgr_source_id := mgr_res_rec.source_id;
1456: l_mgr_source_name := mgr_res_rec.source_name;
1457: if(nvl(l_mgr_source_id, fnd_api.g_miss_num) = nvl(old_rec.source_mgr_id, fnd_api.g_miss_num))
1458: then
1459: l_supervisor_id := fnd_api.g_miss_num;
1460: else
1461: l_supervisor_id := l_mgr_source_id;
1462: end if;
1463:

Line 1466: if(nvl(l_job_title, fnd_api.g_miss_char) = nvl(old_rec.source_job_title, fnd_api.g_miss_char))

1462: end if;
1463:
1464: close mgr_res_cur;
1465:
1466: if(nvl(l_job_title, fnd_api.g_miss_char) = nvl(old_rec.source_job_title, fnd_api.g_miss_char))
1467: then
1468: l_job_id := fnd_api.g_miss_num;
1469: l_job_title := fnd_api.g_miss_char;
1470: -- added these checks for invalid job title validation

Line 1468: l_job_id := fnd_api.g_miss_num;

1464: close mgr_res_cur;
1465:
1466: if(nvl(l_job_title, fnd_api.g_miss_char) = nvl(old_rec.source_job_title, fnd_api.g_miss_char))
1467: then
1468: l_job_id := fnd_api.g_miss_num;
1469: l_job_title := fnd_api.g_miss_char;
1470: -- added these checks for invalid job title validation
1471: elsif((l_job_id is null) and (l_job_title is not null))
1472: then

Line 1469: l_job_title := fnd_api.g_miss_char;

1465:
1466: if(nvl(l_job_title, fnd_api.g_miss_char) = nvl(old_rec.source_job_title, fnd_api.g_miss_char))
1467: then
1468: l_job_id := fnd_api.g_miss_num;
1469: l_job_title := fnd_api.g_miss_char;
1470: -- added these checks for invalid job title validation
1471: elsif((l_job_id is null) and (l_job_title is not null))
1472: then
1473: l_job_id := fnd_api.g_miss_num;

Line 1473: l_job_id := fnd_api.g_miss_num;

1469: l_job_title := fnd_api.g_miss_char;
1470: -- added these checks for invalid job title validation
1471: elsif((l_job_id is null) and (l_job_title is not null))
1472: then
1473: l_job_id := fnd_api.g_miss_num;
1474: l_job_title := fnd_api.g_miss_char;
1475: elsif((l_job_id is not null) and (l_job_title is null))
1476: then
1477: l_job_id := null;

Line 1474: l_job_title := fnd_api.g_miss_char;

1470: -- added these checks for invalid job title validation
1471: elsif((l_job_id is null) and (l_job_title is not null))
1472: then
1473: l_job_id := fnd_api.g_miss_num;
1474: l_job_title := fnd_api.g_miss_char;
1475: elsif((l_job_id is not null) and (l_job_title is null))
1476: then
1477: l_job_id := null;
1478: end if;

Line 1480: if(nvl(ok_address_id, fnd_api.g_miss_num) =

1476: then
1477: l_job_id := null;
1478: end if;
1479:
1480: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1481: nvl(old_rec.address_id, fnd_api.g_miss_num))
1482: then
1483: ok_address_id := fnd_api.g_miss_num;
1484: end if;

Line 1481: nvl(old_rec.address_id, fnd_api.g_miss_num))

1477: l_job_id := null;
1478: end if;
1479:
1480: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1481: nvl(old_rec.address_id, fnd_api.g_miss_num))
1482: then
1483: ok_address_id := fnd_api.g_miss_num;
1484: end if;
1485: else

Line 1483: ok_address_id := fnd_api.g_miss_num;

1479:
1480: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1481: nvl(old_rec.address_id, fnd_api.g_miss_num))
1482: then
1483: ok_address_id := fnd_api.g_miss_num;
1484: end if;
1485: else
1486: l_job_id := fnd_api.g_miss_num;
1487: l_supervisor_id := fnd_api.g_miss_num;

Line 1486: l_job_id := fnd_api.g_miss_num;

1482: then
1483: ok_address_id := fnd_api.g_miss_num;
1484: end if;
1485: else
1486: l_job_id := fnd_api.g_miss_num;
1487: l_supervisor_id := fnd_api.g_miss_num;
1488: l_job_title := fnd_api.g_miss_char;
1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =

Line 1487: l_supervisor_id := fnd_api.g_miss_num;

1483: ok_address_id := fnd_api.g_miss_num;
1484: end if;
1485: else
1486: l_job_id := fnd_api.g_miss_num;
1487: l_supervisor_id := fnd_api.g_miss_num;
1488: l_job_title := fnd_api.g_miss_char;
1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1491: nvl(old_rec.address_id, fnd_api.g_miss_num))

Line 1488: l_job_title := fnd_api.g_miss_char;

1484: end if;
1485: else
1486: l_job_id := fnd_api.g_miss_num;
1487: l_supervisor_id := fnd_api.g_miss_num;
1488: l_job_title := fnd_api.g_miss_char;
1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1491: nvl(old_rec.address_id, fnd_api.g_miss_num))
1492: then

Line 1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =

1486: l_job_id := fnd_api.g_miss_num;
1487: l_supervisor_id := fnd_api.g_miss_num;
1488: l_job_title := fnd_api.g_miss_char;
1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1491: nvl(old_rec.address_id, fnd_api.g_miss_num))
1492: then
1493: ok_address_id := fnd_api.g_miss_num;
1494: end if;

Line 1491: nvl(old_rec.address_id, fnd_api.g_miss_num))

1487: l_supervisor_id := fnd_api.g_miss_num;
1488: l_job_title := fnd_api.g_miss_char;
1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1491: nvl(old_rec.address_id, fnd_api.g_miss_num))
1492: then
1493: ok_address_id := fnd_api.g_miss_num;
1494: end if;
1495: end if;

Line 1493: ok_address_id := fnd_api.g_miss_num;

1489:
1490: if(nvl(ok_address_id, fnd_api.g_miss_num) =
1491: nvl(old_rec.address_id, fnd_api.g_miss_num))
1492: then
1493: ok_address_id := fnd_api.g_miss_num;
1494: end if;
1495: end if;
1496:
1497: if(l_uwn=1)

Line 1531: If (l_supervisor_id <> fnd_api.g_miss_num)

1527: elsif((l_u = 1) OR (p_approved IN ('A', 'T', 'AE', 'TE') ))
1528: then
1529:
1530: --call the hr api's
1531: If (l_supervisor_id <> fnd_api.g_miss_num)
1532: then
1533: -- call the api for per_assigments_f update
1534: open assg_cur(old_rec.source_id);
1535: fetch assg_cur into assg_rec;

Line 1564: if((ok_address_id <> fnd_api.g_miss_num)

1560: end if; --end of assg cur check
1561: close assg_cur;
1562: end if;
1563:
1564: if((ok_address_id <> fnd_api.g_miss_num)
1565: OR (ok_address_id is null)
1566: OR (l_job_id <> fnd_api.g_miss_num)
1567: OR (l_job_id is null))
1568: then

Line 1566: OR (l_job_id <> fnd_api.g_miss_num)

1562: end if;
1563:
1564: if((ok_address_id <> fnd_api.g_miss_num)
1565: OR (ok_address_id is null)
1566: OR (l_job_id <> fnd_api.g_miss_num)
1567: OR (l_job_id is null))
1568: then
1569: --update location and job
1570: open assg_cur(old_rec.source_id);

Line 1574: if(l_job_id = fnd_api.g_miss_num)

1570: open assg_cur(old_rec.source_id);
1571: fetch assg_cur into assg_rec;
1572: if(assg_cur%found)
1573: then
1574: if(l_job_id = fnd_api.g_miss_num)
1575: then
1576: l_job_id := assg_rec.job_id;
1577: end if;
1578: if(ok_address_id = fnd_api.g_miss_num)

Line 1578: if(ok_address_id = fnd_api.g_miss_num)

1574: if(l_job_id = fnd_api.g_miss_num)
1575: then
1576: l_job_id := assg_rec.job_id;
1577: end if;
1578: if(ok_address_id = fnd_api.g_miss_num)
1579: then
1580: ok_address_id := assg_rec.location_id;
1581: end if;
1582: l_object_version_number_assg := assg_rec.object_version_number;

Line 1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>

1609: end if;
1610: close assg_cur;
1611: end if;
1612:
1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>

Line 1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )

1610: close assg_cur;
1611: end if;
1612:
1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )

Line 1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>

1611: end if;
1612:
1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>

Line 1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )

1612:
1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))

Line 1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>

1613: if((nvl(ok_source_mailstop, fnd_api.g_miss_char) <>
1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))
1621: then

Line 1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )

1614: nvl(old_rec.source_mailstop, fnd_api.g_miss_char) )
1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))
1621: then
1622: --update per_all_people_f

Line 1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>

1615: OR (nvl(ok_source_location, fnd_api.g_miss_char) <>
1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))
1621: then
1622: --update per_all_people_f
1623: open per_cur(old_rec.source_id);

Line 1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))

1616: nvl(old_rec.source_location, fnd_api.g_miss_char) )
1617: OR (nvl(ok_source_email, fnd_api.g_miss_char) <>
1618: nvl(old_rec.source_email, fnd_api.g_miss_char) )
1619: OR (nvl(ok_source_office, fnd_api.g_miss_char) <>
1620: nvl(old_rec.source_office, fnd_api.g_miss_char)))
1621: then
1622: --update per_all_people_f
1623: open per_cur(old_rec.source_id);
1624: fetch per_cur into per_rec;

Line 1661: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>

1657: end if; -- end of source col change check
1658:
1659:
1660: --call phone api
1661: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>
1662: nvl(old_rec.source_phone, fnd_api.g_miss_char))
1663: then
1664: --update per_phones
1665: open phone_cur(old_rec.source_id);

Line 1662: nvl(old_rec.source_phone, fnd_api.g_miss_char))

1658:
1659:
1660: --call phone api
1661: if(nvl(ok_source_phone, fnd_api.g_miss_char) <>
1662: nvl(old_rec.source_phone, fnd_api.g_miss_char))
1663: then
1664: --update per_phones
1665: open phone_cur(old_rec.source_id);
1666: fetch phone_cur into phone_rec;

Line 1701: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>

1697: end if; -- end of source_phone change check
1698:
1699:
1700: --call mobile phone api
1701: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>
1702: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))
1703: then
1704: --update per_phones
1705: open mobile_phone_cur(old_rec.source_id);

Line 1702: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))

1698:
1699:
1700: --call mobile phone api
1701: if(nvl(ok_source_mobile_phone, fnd_api.g_miss_char) <>
1702: nvl(old_rec.source_mobile_phone, fnd_api.g_miss_char))
1703: then
1704: --update per_phones
1705: open mobile_phone_cur(old_rec.source_id);
1706: fetch mobile_phone_cur into mobile_phone_rec;

Line 1740: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>

1736: close mobile_phone_cur;
1737: end if; -- end of source_mobile_phone change check
1738:
1739: --call pager api
1740: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>
1741: nvl(old_rec.source_pager, fnd_api.g_miss_char))
1742: then
1743: --update per_phones
1744: open pager_cur(old_rec.source_id);

Line 1741: nvl(old_rec.source_pager, fnd_api.g_miss_char))

1737: end if; -- end of source_mobile_phone change check
1738:
1739: --call pager api
1740: if(nvl(ok_source_pager, fnd_api.g_miss_char) <>
1741: nvl(old_rec.source_pager, fnd_api.g_miss_char))
1742: then
1743: --update per_phones
1744: open pager_cur(old_rec.source_id);
1745: fetch pager_cur into pager_rec;

Line 1783: if((ok_address_id <> fnd_api.g_miss_num) OR (ok_address_id is NULL))

1779: --end of hr api calls
1780:
1781: --call update resource api
1782:
1783: if((ok_address_id <> fnd_api.g_miss_num) OR (ok_address_id is NULL))
1784: then
1785: if (ok_address_id is NULL) then
1786: address_rec := NULL;
1787: else

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

1810: , x_msg_count => x_msg_count
1811: , x_msg_data => x_msg_data);
1812:
1813:
1814: if(x_return_status <> fnd_api.g_ret_sts_success)
1815: then
1816: raise fnd_api.g_exc_error;
1817: end if;
1818:

Line 1816: raise fnd_api.g_exc_error;

1812:
1813:
1814: if(x_return_status <> fnd_api.g_ret_sts_success)
1815: then
1816: raise fnd_api.g_exc_error;
1817: end if;
1818:
1819: END IF; -- edn of date check
1820:

Line 1823: , p_init_msg_list => fnd_api.g_false

1819: END IF; -- edn of date check
1820:
1821: jtf_rs_resource_pub.update_resource
1822: (p_api_version => 1.0
1823: , p_init_msg_list => fnd_api.g_false
1824: , p_commit => p_commit
1825: , p_resource_id => p_resource_id
1826: , p_resource_number => null
1827: , p_resource_name => ok_resource_name

Line 1860: if(x_return_status = fnd_api.g_ret_sts_success)

1856: , x_msg_count => x_msg_count
1857: , x_msg_data => x_msg_data);
1858:
1859:
1860: if(x_return_status = fnd_api.g_ret_sts_success)
1861: then
1862: if((p_org_id is not null)
1863: OR (p_org_id <> fnd_api.g_miss_num))
1864: then

Line 1863: OR (p_org_id <> fnd_api.g_miss_num))

1859:
1860: if(x_return_status = fnd_api.g_ret_sts_success)
1861: then
1862: if((p_org_id is not null)
1863: OR (p_org_id <> fnd_api.g_miss_num))
1864: then
1865: --update srp
1866: open salesrep_cur(p_resource_id, p_org_id);
1867: fetch salesrep_cur into salesrep_rec;

Line 1886: AND (p_sales_credit_type_id <> fnd_api.g_miss_num))

1882: end if;
1883: close salesrep_cur;
1884:
1885: elsif(( p_sales_credit_type_id is not null)
1886: AND (p_sales_credit_type_id <> fnd_api.g_miss_num))
1887: then
1888: --create srp
1889: -- below call to MO_GLOBAL init is added for MOAC changes.
1890: -- If we didn't pass a value for org id in create_salesrep API,

Line 1948: if(x_return_status=fnd_api.g_ret_sts_success)

1944:
1945: end if;
1946:
1947: l_mgr_name := old_rec.source_mgr_name;
1948: if(x_return_status=fnd_api.g_ret_sts_success)
1949: then
1950: -- bug # 2185983 success message was showed
1951: -- two times if atleast one field requires
1952: -- notification/apporval and atleast one field has

Line 2005: x_return_status := fnd_api.g_ret_sts_error;

2001: EXCEPTION
2002: WHEN hr_api_error
2003: THEN
2004: ROLLBACK TO sp_save;
2005: x_return_status := fnd_api.g_ret_sts_error;
2006: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
2007: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
2008: FND_MSG_PUB.add;
2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2010: WHEN fnd_api.g_exc_unexpected_error

2006: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
2007: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
2008: FND_MSG_PUB.add;
2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2010: WHEN fnd_api.g_exc_unexpected_error
2011: THEN
2012: ROLLBACK TO sp_save;
2013: x_return_status := fnd_api.g_ret_sts_error;
2014: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2013: x_return_status := fnd_api.g_ret_sts_error;

2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2010: WHEN fnd_api.g_exc_unexpected_error
2011: THEN
2012: ROLLBACK TO sp_save;
2013: x_return_status := fnd_api.g_ret_sts_error;
2014: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2015: WHEN fnd_api.g_exc_error
2016: THEN
2017: ROLLBACK TO sp_save;

Line 2015: WHEN fnd_api.g_exc_error

2011: THEN
2012: ROLLBACK TO sp_save;
2013: x_return_status := fnd_api.g_ret_sts_error;
2014: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2015: WHEN fnd_api.g_exc_error
2016: THEN
2017: ROLLBACK TO sp_save;
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2018: x_return_status := fnd_api.g_ret_sts_error;

2014: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2015: WHEN fnd_api.g_exc_error
2016: THEN
2017: ROLLBACK TO sp_save;
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2020:
2021: WHEN OTHERS
2022: THEN

Line 2029: x_return_status := fnd_api.g_ret_sts_unexp_error;

2025: fnd_message.set_token('P_SQLCODE',SQLCODE);
2026: fnd_message.set_token('P_SQLERRM',SQLERRM);
2027: fnd_message.set_token('P_API_NAME',l_api_name);
2028: FND_MSG_PUB.add;
2029: x_return_status := fnd_api.g_ret_sts_unexp_error;
2030: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2031: END update_resource;
2032:
2033: