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.OKS_EXTWAR_UTIL_PUB dependencies on FND_MESSAGE

Line 522: GET_FND_MESSAGE

518: (
519: p_contract_header_id,
520: p_contract_number,
521: p_contract_number_modifier,
522: GET_FND_MESSAGE
523: );
524: END IF;
525: END IF;
526:

Line 718: FUNCTION GET_FND_MESSAGE RETURN VARCHAR2 IS

714:
715: x_return_status := l_return_status;
716: END CREATE_CONTACT;
717:
718: FUNCTION GET_FND_MESSAGE RETURN VARCHAR2 IS
719: i NUMBER := 0;
720: l_return_status VARCHAR2(1);
721: l_msg_count NUMBER;
722: l_msg_data VARCHAR2(2000);

Line 736: FND_MESSAGE.CLEAR;

732: p_msg_index_out => l_msg_index_out
733: );
734: l_mesg := l_mesg || ':' || i || ':' || l_msg_data;
735: END LOOP;
736: FND_MESSAGE.CLEAR;
737: return(l_mesg);
738: END GET_FND_MESSAGE;
739:
740: PROCEDURE NOTIFY_SETUP_ADMIN IS

Line 738: END GET_FND_MESSAGE;

734: l_mesg := l_mesg || ':' || i || ':' || l_msg_data;
735: END LOOP;
736: FND_MESSAGE.CLEAR;
737: return(l_mesg);
738: END GET_FND_MESSAGE;
739:
740: PROCEDURE NOTIFY_SETUP_ADMIN IS
741: l_setup_admin VARCHAR2(200) := FND_PROFILE.VALUE('OKS_SETUP_ADMIN_ID');
742: BEGIN

Line 779: l_subj := FND_MESSAGE.get_string('OKS','OKS_TERR_SETUP_ERR_SUB');

775: 'Inside NOTIFY_TERRITORY_ADMIN');
776: END IF;
777:
778: l_terr_admin_id := FND_PROFILE.VALUE('OKS_TERR_ADMIN_ID');
779: l_subj := FND_MESSAGE.get_string('OKS','OKS_TERR_SETUP_ERR_SUB');
780: IF (l_terr_admin_id IS NULL) THEN
781: l_contract_admin_id := FND_PROFILE.VALUE('OKS_CONTRACT_ADMIN_ID');
782: END IF;
783: IF l_terr_admin_id IS NOT NULL THEN

Line 808: l_con_num_prompt := FND_MESSAGE.get_string('OKS','OKS_CONTRACT_NUMBER');

804: END IF;
805:
806: END IF;
807:
808: l_con_num_prompt := FND_MESSAGE.get_string('OKS','OKS_CONTRACT_NUMBER');
809: l_subj := l_subj || ' ' || l_con_num_prompt || ' - ' || p_contract_number ||' '||p_contract_number_modifier;
810:
811: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

Line 892: l_subj := FND_MESSAGE.get_string('OKS','OKS_VENDOR_REASSIGNED');

888: l_subj := 'Territory Setup Error';
889: elsif p_type = 'NCA' Then
890: l_subj := 'Vendor Contact Creation Error';
891: elsif p_type = 'NSR' Then
892: l_subj := FND_MESSAGE.get_string('OKS','OKS_VENDOR_REASSIGNED');
893: end if;
894:
895: open l_fnd_csr;
896: fetch l_fnd_csr into l_user_name;

Line 2337: l_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_INVALID_SALES_PERSON');

2333: ,null
2334: ,null
2335: ,null);
2336: ELSE
2337: l_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_INVALID_SALES_PERSON');
2338: OPEN get_contract_num_mod(l_winning_tbl(idx4).chr_id);
2339: FETCH get_contract_num_mod into l_e_contract_number,l_e_contract_number_mod;
2340: CLOSE get_contract_num_mod;
2341:

Line 2383: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_NO_TERR_RESOURCES');

2379:
2380: -- Send notification for those contracts with no resource setup
2381: FOR contract_noresource_rec in contract_noresource
2382: LOOP
2383: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_NO_TERR_RESOURCES');
2384: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2385: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2386: 'Contract with no resource setup : ' || contract_noresource_rec.Contract_number || ' '
2387: || contract_noresource_rec.Contract_number_modifier);

Line 2402: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_VENDOR_STAMP_ERROR');

2398: -- Send notification for those contracts which has a vendor contact starting in future.
2399: l_f_chr_id := 0;
2400: FOR contact_resource_inf_rec IN contact_resource_in_future
2401: LOOP
2402: l_terr_admin_msg := FND_MESSAGE.GET_STRING('OKS','OKS_VENDOR_STAMP_ERROR');
2403: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2404: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2405: 'Contract with vendor contact starting in future: ' || contact_resource_inf_rec.Contract_number || ' '
2406: || contact_resource_inf_rec.Contract_number_modifier);

Line 2687: FND_MESSAGE.SET_NAME('OKS','OKS_NOTIFY_SALESREP');

2683: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2684: 'Update contract header return status '
2685: || l_return_status );
2686: END IF;
2687: FND_MESSAGE.SET_NAME('OKS','OKS_NOTIFY_SALESREP');
2688: FND_MESSAGE.SET_TOKEN(token => 'CONTRACTNUM',
2689: Value => l_ctcv_rec_out_ins.attribute2);
2690: l_salesrep_msg := FND_MESSAGE.GET;
2691: NOTIFY_SALESREP(to_number(l_ctcv_rec_out_ins.attribute1),

Line 2688: FND_MESSAGE.SET_TOKEN(token => 'CONTRACTNUM',

2684: 'Update contract header return status '
2685: || l_return_status );
2686: END IF;
2687: FND_MESSAGE.SET_NAME('OKS','OKS_NOTIFY_SALESREP');
2688: FND_MESSAGE.SET_TOKEN(token => 'CONTRACTNUM',
2689: Value => l_ctcv_rec_out_ins.attribute2);
2690: l_salesrep_msg := FND_MESSAGE.GET;
2691: NOTIFY_SALESREP(to_number(l_ctcv_rec_out_ins.attribute1),
2692: l_ctcv_rec_out_ins.dnz_chr_id,

Line 2690: l_salesrep_msg := FND_MESSAGE.GET;

2686: END IF;
2687: FND_MESSAGE.SET_NAME('OKS','OKS_NOTIFY_SALESREP');
2688: FND_MESSAGE.SET_TOKEN(token => 'CONTRACTNUM',
2689: Value => l_ctcv_rec_out_ins.attribute2);
2690: l_salesrep_msg := FND_MESSAGE.GET;
2691: NOTIFY_SALESREP(to_number(l_ctcv_rec_out_ins.attribute1),
2692: l_ctcv_rec_out_ins.dnz_chr_id,
2693: l_ctcv_rec_out_ins.attribute2,
2694: NULL,

Line 2710: GET_FND_MESSAGE );

2706: --Assemble Data for errorneous condition
2707: NOTIFY_CONTRACT_ADMIN(l_ctcv_rec_out_ins.dnz_chr_id,
2708: NULL,
2709: NULL,
2710: GET_FND_MESSAGE );
2711: END IF;
2712: EXIT WHEN idx3 = l_ctcv_tbl_in.LAST;
2713: idx3 := l_ctcv_tbl_in.NEXT(idx3);
2714: END LOOP;

Line 2827: 'Error occured : ' || get_fnd_message() );

2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2827: 'Error occured : ' || get_fnd_message() );
2828: END IF;
2829: rollback;
2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2835: 'Unexpected Error : ' || get_fnd_message() );

2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2835: 'Unexpected Error : ' || get_fnd_message() );
2836: END IF;
2837: rollback;
2838: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2839: WHEN OTHERS THEN