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.IEM_EMAIL_PROC_PVT dependencies on FND_API

Line 207: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

203: l_msg_index_out number;
204: --siahmed
205: begin
206: -- Standard call to check for call compatibility.
207: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
208: p_api_version_number,
209: l_api_name,
210: G_PKG_NAME)
211: THEN

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: p_api_version_number,
209: l_api_name,
210: G_PKG_NAME)
211: THEN
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: END IF;
214: FND_LOG_REPOSITORY.init(null,null);
215: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
216: g_statement_log:=true;

Line 1170: p_commit=>FND_API.G_FALSE,

1166: END IF;
1167:
1168: -- Calling Auto Processing Engine For 'AUTODELETE'
1169: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1170: p_commit=>FND_API.G_FALSE,
1171: p_rule_type=>'AUTODELETE',
1172: p_keyvals_tbl=>l_class_val_tbl,
1173: p_accountid=>l_post_rec.email_account_id,
1174: x_result=>l_autoproc_result,

Line 1376: p_commit=>FND_API.G_FALSE,

1372: l_logmessage:='Calling Autoack RE iem_rules_engine_pub.auto_process_email';
1373: iem_logger(l_logmessage);
1374: end if;
1375: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1376: p_commit=>FND_API.G_FALSE,
1377: p_rule_type=>'AUTOACKNOWLEDGE',
1378: p_keyvals_tbl=>l_class_val_tbl,
1379: p_accountid=>l_post_rec.email_account_id,
1380: x_result=>l_autoproc_result,

Line 1411: p_commit=>FND_API.G_FALSE,

1407: l_logmessage:='Calling auto processing RE iem_rules_engine_pub.auto_process_email';
1408: iem_logger(l_logmessage);
1409: end if;
1410: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1411: p_commit=>FND_API.G_FALSE,
1412: p_rule_type=>'AUTOPROCESSING',
1413: p_keyvals_tbl=>l_class_val_tbl,
1414: p_accountid=>l_post_rec.email_account_id,
1415: x_result=>l_autoproc_result,

Line 1873: p_init_msg_list => FND_API.G_TRUE,

1869: p_parser_id => l_parser_id,
1870: p_account_type => l_acct_type,
1871: p_default_type_id => l_status_id,
1872: p_default_customer_id => l_party_id,
1873: p_init_msg_list => FND_API.G_TRUE,
1874: --p_commit => FND_API.G_FALSE,
1875: p_commit => FND_API.G_TRUE,
1876: p_note => l_text,
1877: p_subject => l_header_rec.subject,

Line 1874: --p_commit => FND_API.G_FALSE,

1870: p_account_type => l_acct_type,
1871: p_default_type_id => l_status_id,
1872: p_default_customer_id => l_party_id,
1873: p_init_msg_list => FND_API.G_TRUE,
1874: --p_commit => FND_API.G_FALSE,
1875: p_commit => FND_API.G_TRUE,
1876: p_note => l_text,
1877: p_subject => l_header_rec.subject,
1878: p_note_type => l_note_type,

Line 1875: p_commit => FND_API.G_TRUE,

1871: p_default_type_id => l_status_id,
1872: p_default_customer_id => l_party_id,
1873: p_init_msg_list => FND_API.G_TRUE,
1874: --p_commit => FND_API.G_FALSE,
1875: p_commit => FND_API.G_TRUE,
1876: p_note => l_text,
1877: p_subject => l_header_rec.subject,
1878: p_note_type => l_note_type,
1879: p_contact_id => l_contact_id,

Line 1898: p_init_msg_list => FND_API.G_TRUE,

1894: iem_logger(l_logmessage);
1895:
1896: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1897: p_api_version => 1.0,
1898: p_init_msg_list => FND_API.G_TRUE,
1899: p_commit => FND_API.G_FALSE,
1900: p_message_id => l_message_id,
1901: p_note => l_text,
1902: p_party_id => l_party_id,

Line 1899: p_commit => FND_API.G_FALSE,

1895:
1896: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1897: p_api_version => 1.0,
1898: p_init_msg_list => FND_API.G_TRUE,
1899: p_commit => FND_API.G_FALSE,
1900: p_message_id => l_message_id,
1901: p_note => l_text,
1902: p_party_id => l_party_id,
1903: p_sr_type_id => l_status_id,

Line 1950: p_init_msg_list => FND_API.G_TRUE,

1946: iem_logger(l_logmessage);
1947:
1948: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1949: p_api_version => 1.0,
1950: p_init_msg_list => FND_API.G_TRUE,
1951: p_commit => FND_API.G_FALSE,
1952: p_message_id => l_message_id,
1953: p_note => l_text,
1954: p_party_id => l_party_id,

Line 1951: p_commit => FND_API.G_FALSE,

1947:
1948: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1949: p_api_version => 1.0,
1950: p_init_msg_list => FND_API.G_TRUE,
1951: p_commit => FND_API.G_FALSE,
1952: p_message_id => l_message_id,
1953: p_note => l_text,
1954: p_party_id => l_party_id,
1955: p_sr_type_id => l_status_id,

Line 2530: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

2526: iem_logger(l_logmessage);
2527: end if;
2528: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
2529: FND_MSG_PUB.Add;
2530: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
2531: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
2532: p_mailer =>l_header_rec.from_str,
2533: p_sender=>l_sender,
2534: p_subject=>l_header_rec.subject,

Line 2583: p_commit=>FND_API.G_FALSE,

2579: -- Prior to calling this check if the email is to be redirected on the profile
2580: -- set for autocreate/auto update SR fails for employee type
2581: if l_redirect_flag='N' then
2582: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
2583: p_commit=>FND_API.G_FALSE,
2584: p_rule_type=>'AUTOREDIRECT',
2585: p_keyvals_tbl=>l_class_val_tbl,
2586: p_accountid=>l_post_rec.email_account_id,
2587: x_result=>l_autoproc_result,

Line 2763: p_commit=>FND_API.G_FALSE,

2759: l_logmessage:='calling iem_rules_engine_pub.auto_process_email AUTORRRS';
2760: iem_logger(l_logmessage);
2761: end if;
2762: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
2763: p_commit=>FND_API.G_FALSE,
2764: p_rule_type=>'AUTORRRS',
2765: p_keyvals_tbl=>l_class_val_tbl,
2766: p_accountid=>l_post_rec.email_account_id,
2767: x_result=>l_autoproc_result,

Line 2847: p_commit=>FND_API.G_FALSE,

2843: l_logmessage:='calling iem_rules_engine_pub.auto_process_email doc retrieval';
2844: iem_logger(l_logmessage);
2845: end if;
2846: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
2847: p_commit=>FND_API.G_FALSE,
2848: p_rule_type=>'DOCUMENTRETRIEVAL',
2849: p_keyvals_tbl=>l_class_val_tbl,
2850: p_accountid=>l_post_rec.email_account_id,
2851: x_result=>l_autoproc_result,

Line 3360: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

3356: iem_logger(l_logmessage);
3357: end if;
3358: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
3359: FND_MSG_PUB.Add;
3360: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
3361:
3362:
3363: if g_statement_log then
3364: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING';

Line 3502: IF FND_API.To_Boolean(p_commit) THEN

3498: l_count:=l_count+1;
3499: EXIT when l_count>p_count;
3500: END LOOP;
3501: -- Standard Check Of p_commit.
3502: IF FND_API.To_Boolean(p_commit) THEN
3503: COMMIT WORK;
3504: END IF;
3505: EXCEPTION
3506: WHEN FND_API.G_EXC_ERROR THEN

Line 3506: WHEN FND_API.G_EXC_ERROR THEN

3502: IF FND_API.To_Boolean(p_commit) THEN
3503: COMMIT WORK;
3504: END IF;
3505: EXCEPTION
3506: WHEN FND_API.G_EXC_ERROR THEN
3507:
3508: ROLLBACK TO process_emails_pvt;
3509: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
3510: l_Error_Message := FND_MESSAGE.GET;

Line 3513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3509: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
3510: l_Error_Message := FND_MESSAGE.GET;
3511: fnd_file.put_line(fnd_file.log, l_Error_Message);
3512: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
3513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3514:
3515: ROLLBACK TO process_emails_pvt;
3516: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_UNXPTD_ERR');
3517: l_Error_Message := FND_MESSAGE.GET;

Line 3809: p_init_msg_list => FND_API.G_FALSE,

3805: raise CUSTOM_WF_EXCEP;
3806: end if;
3807:
3808: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
3809: p_init_msg_list => FND_API.G_FALSE,
3810: p_commit => FND_API.G_FALSE,
3811: p_type => 'WORKFLOW',
3812: p_param => p_message_id,
3813: p_value => l_outval,

Line 3810: p_commit => FND_API.G_FALSE,

3806: end if;
3807:
3808: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
3809: p_init_msg_list => FND_API.G_FALSE,
3810: p_commit => FND_API.G_FALSE,
3811: p_type => 'WORKFLOW',
3812: p_param => p_message_id,
3813: p_value => l_outval,
3814: x_return_status => l_stat,

Line 3900: p_init_msg_list =>fnd_api.g_true,

3896: IF l_status_flag<>'C' THEN -- SR is not closed so we can update
3897: l_status_id:=p_status_id;
3898: IEM_ServiceRequest_PVT.Update_Status_Wrap
3899: ( p_api_version =>2.0,
3900: p_init_msg_list =>fnd_api.g_true,
3901: p_commit => fnd_api.g_false,
3902: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3903: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3904: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

Line 3901: p_commit => fnd_api.g_false,

3897: l_status_id:=p_status_id;
3898: IEM_ServiceRequest_PVT.Update_Status_Wrap
3899: ( p_api_version =>2.0,
3900: p_init_msg_list =>fnd_api.g_true,
3901: p_commit => fnd_api.g_false,
3902: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3903: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3904: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3905: x_return_status =>l_ret_status,

Line 4430: p_init_msg_list=>FND_API.G_FALSE,

4426: AND b.language=USERENV('LANG')
4427: and rownum=1;
4428:
4429: IEM_OUTBOX_PROC_PUB.attachDocument(p_api_version_number=>1.0,
4430: p_init_msg_list=>FND_API.G_FALSE,
4431: p_commit=>FND_API.G_TRUE,
4432: p_outbox_item_id=>l_outbox_id,
4433: p_document_source=>'MES',
4434: p_document_id=>p_doc_tbl(i).doc_id,

Line 4431: p_commit=>FND_API.G_TRUE,

4427: and rownum=1;
4428:
4429: IEM_OUTBOX_PROC_PUB.attachDocument(p_api_version_number=>1.0,
4430: p_init_msg_list=>FND_API.G_FALSE,
4431: p_commit=>FND_API.G_TRUE,
4432: p_outbox_item_id=>l_outbox_id,
4433: p_document_source=>'MES',
4434: p_document_id=>p_doc_tbl(i).doc_id,
4435: p_binary_source=>NULL,

Line 4468: P_INTERACTION_ID=>fnd_api.g_miss_num,

4464: p_bcc_address_list=>null,
4465: P_SUBJECT=>l_header_rec.subject,
4466: P_TAG_KEY_VALUE_TBL=>p_tag_key_value_tbl,
4467: P_CUSTOMER_ID=>p_customer_id,
4468: P_INTERACTION_ID=>fnd_api.g_miss_num,
4469: P_RESOURCE_ID=>p_resource_id,
4470: p_qualifiers =>p_qualifiers ,
4471: p_contact_id=>g_contact_id,
4472: p_relationship_id=>g_relation_id,

Line 4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

4507: END IF;
4508: else
4509: FND_MESSAGE.Set_Name('IEM','IEM_REDIRECT_EXT_HDR');
4510: FND_MSG_PUB.Add;
4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;
4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

Line 4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;
4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4516: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_post_rec.email_account_id,
4517: p_mailer=>l_header_rec.from_str, -- passing the sender name, sanjana rao, bug 8839425
4518: p_dflt_sender=>l_dflt_sender ,
4519: p_subject=>l_header_rec.subject, --passing the subject, sanjana rao , bug 8839425

Line 4961: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

4957:
4958: begin
4959: l_api_version_number:=1.0;
4960: -- Standard call to check for call compatibility.
4961: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4962: p_api_version_number,
4963: l_api_name,
4964: G_PKG_NAME)
4965: THEN

Line 4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4962: p_api_version_number,
4963: l_api_name,
4964: G_PKG_NAME)
4965: THEN
4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END IF;
4968: l_level:='STATEMENT';
4969: FND_LOG_REPOSITORY.init(null,null);
4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');

Line 5171: p_commit=>FND_API.G_FALSE,

5167:
5168: -- Now Calling Document Retrieval Rule
5169: l_rule_id:=0;
5170: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
5171: p_commit=>FND_API.G_FALSE,
5172: p_rule_type=>'DOCUMENTRETRIEVAL',
5173: p_keyvals_tbl=>l_class_val_tbl,
5174: p_accountid=>l_mail_rec.email_account_id,
5175: x_result=>l_autoproc_result,

Line 5445: x_return_status := FND_API.G_RET_STS_ERROR;

5441: l_logmessage:='Error occur during Reprocessing autoreply message '||sqlerrm ;
5442: iem_logger(l_logmessage);
5443: end if;
5444: rollback to processautoreply;
5445: x_return_status := FND_API.G_RET_STS_ERROR;
5446: IF FND_MSG_PUB.Check_Msg_Level
5447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5448: THEN
5449: FND_MSG_PUB.Add_Exc_Msg

Line 5576: p_init_msg_list => fnd_api.g_true,

5572: end if;
5573: l_rep :=cs_kb_varchar100_tbl_type('MES') ;
5574: cs_knowledge_grp.Specific_Search(
5575: p_api_version => 1.0,
5576: p_init_msg_list => fnd_api.g_true,
5577: --p_validation_level => p_validation_level,
5578: x_return_status => l_return_status,
5579: x_msg_count => l_msg_count,
5580: x_msg_data => l_msg_data,

Line 5584: p_check_login_user => FND_API.G_FALSE,

5580: x_msg_data => l_msg_data,
5581: p_repository_tbl => l_rep,
5582: p_search_string => l_imt_string,
5583: p_updated_in_days => l_days,
5584: p_check_login_user => FND_API.G_FALSE,
5585: p_application_id => G_APP_ID,
5586: p_area_array => l_area_array,
5587: p_content_array => l_content_array,
5588: p_param_array => l_param_array,

Line 5591: p_include_subcats => FND_API.G_FALSE,

5587: p_content_array => l_content_array,
5588: p_param_array => l_param_array,
5589: p_user_id => l_user_id,
5590: p_category_id => l_category_id,
5591: p_include_subcats => FND_API.G_FALSE,
5592: p_external_contents => FND_API.G_TRUE,
5593: p_rows_requested_tbl => l_rows_req,
5594: p_start_row_pos_tbl => l_start_row,
5595: p_get_total_cnt_flag => 'T',

Line 5592: p_external_contents => FND_API.G_TRUE,

5588: p_param_array => l_param_array,
5589: p_user_id => l_user_id,
5590: p_category_id => l_category_id,
5591: p_include_subcats => FND_API.G_FALSE,
5592: p_external_contents => FND_API.G_TRUE,
5593: p_rows_requested_tbl => l_rows_req,
5594: p_start_row_pos_tbl => l_start_row,
5595: p_get_total_cnt_flag => 'T',
5596: x_rows_returned_tbl => l_rows_returned,

Line 5650: p_init_msg_list => fnd_api.g_true,

5646: -- Calling Search Api for Response String Separately
5647: IF r_imt_string is not null then
5648: cs_knowledge_grp.Specific_Search(
5649: p_api_version => 1.0,
5650: p_init_msg_list => fnd_api.g_true,
5651: --p_validation_level => p_validation_level,
5652: x_return_status => l_return_status,
5653: x_msg_count => l_msg_count,
5654: x_msg_data => l_msg_data,

Line 5658: p_check_login_user => FND_API.G_FALSE,

5654: x_msg_data => l_msg_data,
5655: p_repository_tbl => l_rep,
5656: p_search_string => r_imt_string,
5657: p_updated_in_days => l_days,
5658: p_check_login_user => FND_API.G_FALSE,
5659: p_application_id => G_APP_ID,
5660: p_area_array => l_area_array,
5661: p_content_array => l_content_array,
5662: p_param_array => l_param_array,

Line 5665: p_include_subcats => FND_API.G_FALSE,

5661: p_content_array => l_content_array,
5662: p_param_array => l_param_array,
5663: p_user_id => l_user_id,
5664: p_category_id => l_category_id,
5665: p_include_subcats => FND_API.G_FALSE,
5666: p_external_contents => FND_API.G_TRUE,
5667: p_rows_requested_tbl => l_rows_req,
5668: p_start_row_pos_tbl => l_start_row,
5669: p_get_total_cnt_flag => 'T',

Line 5666: p_external_contents => FND_API.G_TRUE,

5662: p_param_array => l_param_array,
5663: p_user_id => l_user_id,
5664: p_category_id => l_category_id,
5665: p_include_subcats => FND_API.G_FALSE,
5666: p_external_contents => FND_API.G_TRUE,
5667: p_rows_requested_tbl => l_rows_req,
5668: p_start_row_pos_tbl => l_start_row,
5669: p_get_total_cnt_flag => 'T',
5670: x_rows_returned_tbl => l_rows_returned,

Line 5738: p_init_msg_list => fnd_api.g_true,

5734: l_imt_string:=substr(l_sms_string,1,l_sms_count-1);
5735: END IF;
5736: cs_knowledge_grp.Specific_Search(
5737: p_api_version => 1.0,
5738: p_init_msg_list => fnd_api.g_true,
5739: --p_validation_level => p_validation_level,
5740: x_return_status => l_return_status,
5741: x_msg_count => l_msg_count,
5742: x_msg_data => l_msg_data,

Line 5746: p_check_login_user => FND_API.G_FALSE,

5742: x_msg_data => l_msg_data,
5743: p_repository_tbl => l_rep,
5744: p_search_string => l_imt_string,
5745: p_updated_in_days => l_days,
5746: p_check_login_user => FND_API.G_FALSE,
5747: p_application_id => G_APP_ID,
5748: p_area_array => l_area_array,
5749: p_content_array => l_content_array,
5750: p_param_array => l_param_array,

Line 5753: p_include_subcats => FND_API.G_TRUE,

5749: p_content_array => l_content_array,
5750: p_param_array => l_param_array,
5751: p_user_id => l_user_id,
5752: p_category_id => l_category_id,
5753: p_include_subcats => FND_API.G_TRUE,
5754: p_external_contents => FND_API.G_TRUE,
5755: p_rows_requested_tbl => l_rows_req,
5756: p_start_row_pos_tbl => l_start_row,
5757: p_get_total_cnt_flag => 'T',

Line 5754: p_external_contents => FND_API.G_TRUE,

5750: p_param_array => l_param_array,
5751: p_user_id => l_user_id,
5752: p_category_id => l_category_id,
5753: p_include_subcats => FND_API.G_TRUE,
5754: p_external_contents => FND_API.G_TRUE,
5755: p_rows_requested_tbl => l_rows_req,
5756: p_start_row_pos_tbl => l_start_row,
5757: p_get_total_cnt_flag => 'T',
5758: x_rows_returned_tbl => l_rows_returned,

Line 5812: p_init_msg_list => fnd_api.g_true,

5808: IF r_imt_string is not null then
5809: -- Calling Specific Search for Response String
5810: cs_knowledge_grp.Specific_Search(
5811: p_api_version => 1.0,
5812: p_init_msg_list => fnd_api.g_true,
5813: --p_validation_level => p_validation_level,
5814: x_return_status => l_return_status,
5815: x_msg_count => l_msg_count,
5816: x_msg_data => l_msg_data,

Line 5820: p_check_login_user => FND_API.G_FALSE,

5816: x_msg_data => l_msg_data,
5817: p_repository_tbl => l_rep,
5818: p_search_string => r_imt_string,
5819: p_updated_in_days => l_days,
5820: p_check_login_user => FND_API.G_FALSE,
5821: p_application_id => G_APP_ID,
5822: p_area_array => l_area_array,
5823: p_content_array => l_content_array,
5824: p_param_array => l_param_array,

Line 5827: p_include_subcats => FND_API.G_FALSE,

5823: p_content_array => l_content_array,
5824: p_param_array => l_param_array,
5825: p_user_id => l_user_id,
5826: p_category_id => l_category_id,
5827: p_include_subcats => FND_API.G_FALSE,
5828: p_external_contents => FND_API.G_TRUE,
5829: p_rows_requested_tbl => l_rows_req,
5830: p_start_row_pos_tbl => l_start_row,
5831: p_get_total_cnt_flag => 'T',

Line 5828: p_external_contents => FND_API.G_TRUE,

5824: p_param_array => l_param_array,
5825: p_user_id => l_user_id,
5826: p_category_id => l_category_id,
5827: p_include_subcats => FND_API.G_FALSE,
5828: p_external_contents => FND_API.G_TRUE,
5829: p_rows_requested_tbl => l_rows_req,
5830: p_start_row_pos_tbl => l_start_row,
5831: p_get_total_cnt_flag => 'T',
5832: x_rows_returned_tbl => l_rows_returned,

Line 5960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

5956: p_parser_id IN NUMBER,
5957: p_account_type IN VARCHAR2 DEFAULT NULL, --p_employee_flag
5958: p_default_type_id IN NUMBER DEFAULT NULL, --p_sr_type_id
5959: p_default_customer_id IN NUMBER DEFAULT NULL, --p_party_id
5960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5962: p_note IN VARCHAR2,
5963: p_subject IN VARCHAR2,
5964: p_note_type IN VARCHAR2,

Line 5961: p_commit IN VARCHAR2 := FND_API.G_FALSE,

5957: p_account_type IN VARCHAR2 DEFAULT NULL, --p_employee_flag
5958: p_default_type_id IN NUMBER DEFAULT NULL, --p_sr_type_id
5959: p_default_customer_id IN NUMBER DEFAULT NULL, --p_party_id
5960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
5962: p_note IN VARCHAR2,
5963: p_subject IN VARCHAR2,
5964: p_note_type IN VARCHAR2,
5965: p_contact_id IN NUMBER := NULL,

Line 5974: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

5970: x_request_id OUT NOCOPY NUMBER
5971: )
5972: IS
5973: -- local var for creating SR
5974: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
5975: l_msg_count NUMBER := 0;
5976: l_msg_data VARCHAR2(2000);
5977: l_index NUMBER := 1;
5978:

Line 6832: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

6828: SAVEPOINT ADVANCED_CREATE_SR;
6829:
6830: -- Standard call to check for call compatibility.
6831: /*
6832: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
6833: 1.0,
6834: l_api_name,
6835: G_PKG_NAME)
6836: THEN

Line 6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6833: 1.0,
6834: l_api_name,
6835: G_PKG_NAME)
6836: THEN
6837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6838: END IF;
6839: */
6840:
6841: l_logmessage:='Came to create SR ' ;

Line 6846: IF FND_API.to_Boolean( p_init_msg_list )

6842: iem_logger(l_logmessage);
6843: --dbms_output.put_line(l_logmessage);
6844:
6845: -- Initialize message list if p_init_msg_list is set to TRUE.
6846: IF FND_API.to_Boolean( p_init_msg_list )
6847: THEN
6848: FND_MSG_PUB.initialize;
6849: END IF;
6850:

Line 6867: x_return_status := FND_API.G_RET_STS_ERROR;

6863: IF (caller_type%NOTFOUND) THEN
6864: l_logmessage:='caller type fail for customer_id '|| g_customer_id ;
6865: iem_logger(l_logmessage);
6866: --dbms_output.put_line(l_logmessage);
6867: x_return_status := FND_API.G_RET_STS_ERROR;
6868: CLOSE caller_type;
6869: END IF;
6870:
6871: CLOSE caller_type;

Line 7117: p_init_msg_list => FND_API.G_FALSE,

7113: iem_logger(l_logmessage);
7114: --dbms_output.put_line(l_logmessage);
7115: CS_ServiceRequest_PUB.Create_ServiceRequest (
7116: p_api_version => l_cs_version_number,
7117: p_init_msg_list => FND_API.G_FALSE,
7118: p_commit => FND_API.G_FALSE,
7119: x_return_status => l_return_status,
7120: x_msg_count => l_msg_count,
7121: x_msg_data => l_msg_data,

Line 7118: p_commit => FND_API.G_FALSE,

7114: --dbms_output.put_line(l_logmessage);
7115: CS_ServiceRequest_PUB.Create_ServiceRequest (
7116: p_api_version => l_cs_version_number,
7117: p_init_msg_list => FND_API.G_FALSE,
7118: p_commit => FND_API.G_FALSE,
7119: x_return_status => l_return_status,
7120: x_msg_count => l_msg_count,
7121: x_msg_data => l_msg_data,
7122: p_resp_appl_id => NULL,

Line 7142: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

7138: p_default_coverage_template_id => l_coverage_template_id
7139: --end of addition by siahmed for fixing the bug 8251673
7140: );
7141:
7142: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
7143: l_logmessage:='raise IEM_SR_NOT_CREATE ' ;
7144: iem_logger(l_logmessage);
7145: --dbms_output.put_line(l_logmessage);
7146: raise IEM_SR_NOT_CREATE;

Line 7148: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

7144: iem_logger(l_logmessage);
7145: --dbms_output.put_line(l_logmessage);
7146: raise IEM_SR_NOT_CREATE;
7147: --end if;
7148: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7149: IF (FND_MSG_PUB.Count_Msg > 1) THEN
7150: --Display all the warning messages
7151: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7152: FND_MSG_PUB.Get(

Line 7207: IF FND_API.to_Boolean(p_commit) THEN

7203: x_return_status := l_return_status ;
7204: x_request_id := l_sr_create_out_rec.request_id;
7205:
7206: --Standard check of p_commit
7207: IF FND_API.to_Boolean(p_commit) THEN
7208: COMMIT WORK;
7209: END IF;
7210:
7211: EXCEPTION

Line 7241: WHEN FND_API.G_EXC_ERROR THEN

7237: iem_logger(l_logmessage);
7238: --dbms_output.put_line(l_logmessage);
7239: END LOOP;
7240:
7241: WHEN FND_API.G_EXC_ERROR THEN
7242: ROLLBACK TO ADVANCED_CREATE_SR;
7243: x_return_status := FND_API.G_RET_STS_ERROR ;
7244: FND_MSG_PUB.Count_And_Get
7245: ( p_count => x_msg_count,p_data => x_msg_data);

Line 7243: x_return_status := FND_API.G_RET_STS_ERROR ;

7239: END LOOP;
7240:
7241: WHEN FND_API.G_EXC_ERROR THEN
7242: ROLLBACK TO ADVANCED_CREATE_SR;
7243: x_return_status := FND_API.G_RET_STS_ERROR ;
7244: FND_MSG_PUB.Count_And_Get
7245: ( p_count => x_msg_count,p_data => x_msg_data);
7246:
7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

7243: x_return_status := FND_API.G_RET_STS_ERROR ;
7244: FND_MSG_PUB.Count_And_Get
7245: ( p_count => x_msg_count,p_data => x_msg_data);
7246:
7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7248: ROLLBACK TO ADVANCED_CREATE_SR;
7249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
7251:

Line 7249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

7245: ( p_count => x_msg_count,p_data => x_msg_data);
7246:
7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7248: ROLLBACK TO ADVANCED_CREATE_SR;
7249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
7251:
7252: WHEN OTHERS THEN
7253: ROLLBACK TO ADVANCED_CREATE_SR;

Line 7254: x_return_status := FND_API.G_RET_STS_ERROR;

7250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
7251:
7252: WHEN OTHERS THEN
7253: ROLLBACK TO ADVANCED_CREATE_SR;
7254: x_return_status := FND_API.G_RET_STS_ERROR;
7255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
7257: END IF;
7258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 8857: p_parent_type_id => FND_API.G_MISS_NUM,

8853: p_api_name => 'Advanced_SR_PROCESSING.GETSERVICEREQUESTTYPE',
8854: p_parameter_name => 'LOOKUP_TYPE',
8855: p_type_name => p_service_request_type,
8856: p_subtype => 'INC',
8857: p_parent_type_id => FND_API.G_MISS_NUM,
8858: p_type_id => l_type_id,
8859: x_return_status => l_return_status);
8860:
8861: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 8861: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

8857: p_parent_type_id => FND_API.G_MISS_NUM,
8858: p_type_id => l_type_id,
8859: x_return_status => l_return_status);
8860:
8861: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
8862: x_type_id := l_type_id;
8863: l_logmessage:='sr_type_id found sr_type_id :'||l_type_id;
8864: iem_logger(l_logmessage);
8865: --dbms_output.put_line(l_logmessage);

Line 8927: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

8923: p_urgency_name => p_urgency,
8924: p_urgency_id => l_urgency_id,
8925: x_return_status => l_return_status);
8926:
8927: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
8928: x_urgency_id := l_urgency_id;
8929: END IF;
8930:
8931: END getUrgency;