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

Line 12: -- Fixed NOCOPY, FND_API.G_MISS.. GSCC warning

8: -- MODIFICATION HISTORY
9: -- Person Date Comments
10: -- Liang Xia 8/1/2002 Created
11: -- Liang Xia 11/15/2002 Added dynamic Classification
12: -- Fixed NOCOPY, FND_API.G_MISS.. GSCC warning
13: -- Liang Xia 12/04/2002 Completely fixed NOCOPY FND_API.G_MISS GSCC warning
14: -- Liang Xia 06/10/2003 Added Document Retrieval Rule type
15: -- Liang Xia 08/11/2003 Added Auto-Redirect Rule type
16: -- Liang Xia 01/20/2004 Bugfix:3362872. Do not auto-redirect to the same account.

Line 13: -- Liang Xia 12/04/2002 Completely fixed NOCOPY FND_API.G_MISS GSCC warning

9: -- Person Date Comments
10: -- Liang Xia 8/1/2002 Created
11: -- Liang Xia 11/15/2002 Added dynamic Classification
12: -- Fixed NOCOPY, FND_API.G_MISS.. GSCC warning
13: -- Liang Xia 12/04/2002 Completely fixed NOCOPY FND_API.G_MISS GSCC warning
14: -- Liang Xia 06/10/2003 Added Document Retrieval Rule type
15: -- Liang Xia 08/11/2003 Added Auto-Redirect Rule type
16: -- Liang Xia 01/20/2004 Bugfix:3362872. Do not auto-redirect to the same account.
17: -- Liang Xia 12/03/2004 Changed for 115.11 schema: iem_mstemail_accounts. file version:115.9

Line 79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

75: --Standard Savepoint
76: SAVEPOINT loadEmailProc_pvt;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: --Initialize the message list if p_init_msg_list is set to TRUE
88: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 88: If FND_API.to_Boolean(p_init_msg_list) THEN

84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: --Initialize the message list if p_init_msg_list is set to TRUE
88: If FND_API.to_Boolean(p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: --Initialize API status return

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: --Initialize API status return
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: --Actual API starts here
96: x := 1;
97: FOR v_classifications IN c_classifications LOOP

Line 213: IF FND_API.to_Boolean(p_commit) THEN

209: x_document := l_documents;
210: x_route := l_routes;
211:
212: --Standard check of p_commit
213: IF FND_API.to_Boolean(p_commit) THEN
214: COMMIT WORK;
215: END IF;
216:
217:

Line 219: WHEN FND_API.G_EXC_ERROR THEN

215: END IF;
216:
217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO loadEmailProc_pvt;
221: x_return_status := FND_API.G_RET_STS_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,p_data => x_msg_data);

Line 221: x_return_status := FND_API.G_RET_STS_ERROR ;

217:
218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO loadEmailProc_pvt;
221: x_return_status := FND_API.G_RET_STS_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,p_data => x_msg_data);
224:
225:

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,p_data => x_msg_data);
224:
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO loadEmailProc_pvt;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
230:

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

224:
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO loadEmailProc_pvt;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
230:
231:
232: WHEN OTHERS THEN

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230:
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO loadEmailProc_pvt;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
237: END IF;
238:

Line 313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

309: --Standard Savepoint
310: SAVEPOINT loadAcctEmailProc_pvt;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN

Line 318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: --Initialize the message list if p_init_msg_list is set to TRUE
322: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 322: If FND_API.to_Boolean(p_init_msg_list) THEN

318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320:
321: --Initialize the message list if p_init_msg_list is set to TRUE
322: If FND_API.to_Boolean(p_init_msg_list) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: --Initialize API status return

Line 327: x_return_status := FND_API.G_RET_STS_SUCCESS;

323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: --Initialize API status return
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328:
329: --Actual API starts here
330: x := 1;
331: FOR v_classifications IN c_classifications(p_acct_id) LOOP

Line 441: IF FND_API.to_Boolean(p_commit) THEN

437: x_document := l_documents;
438: x_route := l_routes;
439:
440: --Standard check of p_commit
441: IF FND_API.to_Boolean(p_commit) THEN
442: COMMIT WORK;
443: END IF;
444:
445:

Line 447: WHEN FND_API.G_EXC_ERROR THEN

443: END IF;
444:
445:
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: ROLLBACK TO loadAcctEmailProc_pvt;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get
451: ( p_count => x_msg_count,p_data => x_msg_data);

Line 449: x_return_status := FND_API.G_RET_STS_ERROR ;

445:
446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: ROLLBACK TO loadAcctEmailProc_pvt;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get
451: ( p_count => x_msg_count,p_data => x_msg_data);
452:
453:

Line 454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

450: FND_MSG_PUB.Count_And_Get
451: ( p_count => x_msg_count,p_data => x_msg_data);
452:
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: ROLLBACK TO loadAcctEmailProc_pvt;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
458:

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

452:
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: ROLLBACK TO loadAcctEmailProc_pvt;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
458:
459:
460: WHEN OTHERS THEN

Line 462: x_return_status := FND_API.G_RET_STS_ERROR;

458:
459:
460: WHEN OTHERS THEN
461: ROLLBACK TO loadAcctEmailProc_pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
465: END IF;
466:

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

485: l_api_name varchar2(30):='deleteAcctEmailProc';
486: l_api_version_number number:=1.0;
487: l_delete_class_ids_tbl jtf_varchar2_Table_100:=jtf_varchar2_Table_100();
488:
489: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
490: l_msg_count NUMBER := 0;
491: l_msg_data VARCHAR2(2000);
492:
493: IEM_EMAILPROC_NOT_DELETED EXCEPTION;

Line 505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

501: --Standard Savepoint
502: SAVEPOINT loadAcctEmailProc_pvt;
503:
504: -- Standard call to check for call compatibility.
505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
506: p_api_version_number,
507: l_api_name,
508: G_PKG_NAME)
509: THEN

Line 510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

506: p_api_version_number,
507: l_api_name,
508: G_PKG_NAME)
509: THEN
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: --Initialize the message list if p_init_msg_list is set to TRUE
514: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 514: If FND_API.to_Boolean(p_init_msg_list) THEN

510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
511: END IF;
512:
513: --Initialize the message list if p_init_msg_list is set to TRUE
514: If FND_API.to_Boolean(p_init_msg_list) THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: --Initialize API status return

Line 519: x_return_status := FND_API.G_RET_STS_SUCCESS;

515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: --Initialize API status return
519: x_return_status := FND_API.G_RET_STS_SUCCESS;
520:
521: --Actual API starts here
522: IF ( p_rule_type = 'CLASSIFICATION') THEN
523:

Line 531: p_commit => FND_API.G_FALSE,

527: if ( l_delete_class_ids_tbl.count <> 0 ) then
528: iem_route_class_pvt.delete_acct_class_batch
529: (p_api_version_number => p_api_version_number,
530: P_init_msg_list => p_init_msg_list,
531: p_commit => FND_API.G_FALSE,
532: p_class_ids_tbl => l_delete_class_ids_tbl,
533:
534: p_account_id => p_acct_id,
535: x_return_status => l_return_status,

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

534: p_account_id => p_acct_id,
535: x_return_status => l_return_status,
536: x_msg_count => l_msg_count,
537: x_msg_data => l_msg_data) ;
538: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
539: raise MY_EXCEPTION;
540: end if;
541: end if;
542:

Line 574: IF FND_API.to_Boolean(p_commit) THEN

570:
571: END IF;
572:
573: --Standard check of p_commit
574: IF FND_API.to_Boolean(p_commit) THEN
575: COMMIT WORK;
576: END IF;
577:
578: EXCEPTION

Line 582: x_return_status := FND_API.G_RET_STS_ERROR ;

578: EXCEPTION
579: WHEN MY_EXCEPTION THEN
580: ROLLBACK TO loadAcctEmailProc_pvt;
581:
582: x_return_status := FND_API.G_RET_STS_ERROR ;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
584: WHEN FND_API.G_EXC_ERROR THEN
585: ROLLBACK TO loadAcctEmailProc_pvt;
586: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 584: WHEN FND_API.G_EXC_ERROR THEN

580: ROLLBACK TO loadAcctEmailProc_pvt;
581:
582: x_return_status := FND_API.G_RET_STS_ERROR ;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
584: WHEN FND_API.G_EXC_ERROR THEN
585: ROLLBACK TO loadAcctEmailProc_pvt;
586: x_return_status := FND_API.G_RET_STS_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,p_data => x_msg_data);

Line 586: x_return_status := FND_API.G_RET_STS_ERROR ;

582: x_return_status := FND_API.G_RET_STS_ERROR ;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
584: WHEN FND_API.G_EXC_ERROR THEN
585: ROLLBACK TO loadAcctEmailProc_pvt;
586: x_return_status := FND_API.G_RET_STS_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,p_data => x_msg_data);
589:
590:

Line 591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,p_data => x_msg_data);
589:
590:
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: ROLLBACK TO loadAcctEmailProc_pvt;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
595:

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

589:
590:
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: ROLLBACK TO loadAcctEmailProc_pvt;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
595:
596:
597: WHEN OTHERS THEN

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595:
596:
597: WHEN OTHERS THEN
598: ROLLBACK TO loadAcctEmailProc_pvt;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
602: END IF;
603:

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

641:
642: l_api_name VARCHAR2(255):='update_emailproc_wrap';
643: l_api_version_number NUMBER:=1.0;
644:
645: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
646: l_msg_count NUMBER := 0;
647: l_msg_data VARCHAR2(2000);
648:
649: l_action_id IEM_ACTIONS.ACTION_ID%type;

Line 681: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

677: -- Standard Start of API savepoint
678: SAVEPOINT update_item_wrap;
679:
680: -- Standard call to check for call compatibility.
681: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
682:
683: p_api_version_number,
684: l_api_name,
685: G_PKG_NAME)

Line 687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

683: p_api_version_number,
684: l_api_name,
685: G_PKG_NAME)
686: THEN
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688:
689: END IF;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 692: IF FND_API.to_Boolean( p_init_msg_list )

688:
689: END IF;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE.
692: IF FND_API.to_Boolean( p_init_msg_list )
693: THEN
694: FND_MSG_PUB.initialize;
695: END IF;
696:

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: END IF;
696:
697:
698: -- Initialize API return status to SUCCESS
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: --API Body
702:
703:

Line 721: p_init_msg_list => FND_API.G_FALSE,

717: raise IEM_ADM_AUTOPRC_NO_PARAMETERS;
718: else
719: IEM_TAG_RUN_PROC_PVT.validProcedure(
720: p_api_version_number => P_Api_Version_Number,
721: p_init_msg_list => FND_API.G_FALSE,
722: p_commit => P_Commit,
723: p_ProcName => p_parameter1_tbl(1),
724: x_return_status => l_return_status,
725: x_msg_count => l_msg_count,

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

724: x_return_status => l_return_status,
725: x_msg_count => l_msg_count,
726: x_msg_data => l_msg_data
727: );
728: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
729: raise IEM_ADM_INVALID_PROC_NAME;
730: end if;
731: end if;
732: --Auto-Redirect: Do not auto-redirect to the same email account validation

Line 754: p_init_msg_list => FND_API.G_FALSE,

750: --update iem_routes table
751:
752: iem_emailproc_hdl_pvt.update_item_emailproc(
753: p_api_version_number => l_api_version_number,
754: p_init_msg_list => FND_API.G_FALSE,
755: p_commit => FND_API.G_FALSE,
756: p_emailproc_id => p_emailproc_id,
757: p_name => p_name,
758: p_description =>p_description,

Line 755: p_commit => FND_API.G_FALSE,

751:
752: iem_emailproc_hdl_pvt.update_item_emailproc(
753: p_api_version_number => l_api_version_number,
754: p_init_msg_list => FND_API.G_FALSE,
755: p_commit => FND_API.G_FALSE,
756: p_emailproc_id => p_emailproc_id,
757: p_name => p_name,
758: p_description =>p_description,
759: p_ruling_chain =>p_ruling_chain,

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

763: x_msg_count => l_msg_count,
764: x_msg_data => l_msg_data);
765:
766:
767: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
768: raise l_IEM_FAIL_TO_CALL;
769: end if;
770:
771:

Line 777: p_init_msg_list => FND_API.G_FALSE,

773: if ( p_update_rule_ids_tbl.count <>0 ) then
774:
775: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
776: iem_emailproc_hdl_pvt.update_item_rule(p_api_version_number => l_api_version_number,
777: p_init_msg_list => FND_API.G_FALSE,
778: p_commit => FND_API.G_FALSE,
779: p_emailproc_rule_id => p_update_rule_ids_tbl(i),
780: p_key_type_code =>p_update_rule_keys_tbl(i),
781: p_operator_type_code =>p_update_rule_operators_tbl(i),

Line 778: p_commit => FND_API.G_FALSE,

774:
775: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
776: iem_emailproc_hdl_pvt.update_item_rule(p_api_version_number => l_api_version_number,
777: p_init_msg_list => FND_API.G_FALSE,
778: p_commit => FND_API.G_FALSE,
779: p_emailproc_rule_id => p_update_rule_ids_tbl(i),
780: p_key_type_code =>p_update_rule_keys_tbl(i),
781: p_operator_type_code =>p_update_rule_operators_tbl(i),
782: p_value => p_update_rule_values_tbl(i),

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

783: x_return_status => l_return_status,
784: x_msg_count => l_msg_count,
785: x_msg_data => l_msg_data);
786:
787: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
788: raise IEM_NO_RULE_UPDATE;
789: end if;
790: end loop;
791: end if;

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

816: x_return_status =>l_return_status,
817: x_msg_count => l_msg_count,
818: x_msg_data => l_msg_data);
819:
820: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
821: raise IEM_ROUTE_RULE_NOT_CREATED;
822: end if;
823: END LOOP;
824: end if;

Line 842: if ( p_action <> FND_API.G_MISS_CHAR ) or ( p_action is not null ) then

838:
839: -- updating action
840: select action_id into l_action_id from iem_actions where emailproc_id = p_emailproc_id;
841:
842: if ( p_action <> FND_API.G_MISS_CHAR ) or ( p_action is not null ) then
843: update iem_actions set action=p_action where action_id = l_action_id;
844: end if;
845:
846: -- updating action dtls

Line 870: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

866:
867: if ( i <= l_param2_count ) then
868: l_param2 := p_parameter2_tbl(i);
869: else
870: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
871: end if;
872:
873: if ( i <= l_param3_count ) then
874: l_param3 := p_parameter3_tbl(i);

Line 876: l_param3 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

872:
873: if ( i <= l_param3_count ) then
874: l_param3 := p_parameter3_tbl(i);
875: else
876: l_param3 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
877: end if;
878:
879:
880:

Line 884: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

880:
881: if ( i <= l_param_tag_count ) then
882: l_param_tag := p_parameter_tag_tbl(i);
883: else
884: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
885: end if;
886:
887: iem_emailproc_hdl_pvt.create_item_action_dtls (
888: p_api_version_number=>p_api_version_number,

Line 890: p_commit => FND_API.G_FALSE,

886:
887: iem_emailproc_hdl_pvt.create_item_action_dtls (
888: p_api_version_number=>p_api_version_number,
889: p_init_msg_list => p_init_msg_list,
890: p_commit => FND_API.G_FALSE,
891: p_action_id => l_action_id,
892: p_param1 => p_parameter1_tbl(i),
893: p_param2 => l_param2,
894: p_param3 => l_param3,

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

896: x_return_status =>l_return_status,
897: x_msg_count => l_msg_count,
898: x_msg_data => l_msg_data);
899:
900: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
901: raise IEM_ACTION_DTLS_NOT_CREATE;
902: end if;
903: end loop;
904: END IF;

Line 914: x_return_status := FND_API.G_RET_STS_ERROR ;

910: ROLLBACK TO update_item_wrap;
911: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
912:
913: -- FND_MSG_PUB.Add;
914: x_return_status := FND_API.G_RET_STS_ERROR ;
915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
916:
917: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
918: ROLLBACK TO update_item_wrap;

Line 922: x_return_status := FND_API.G_RET_STS_ERROR ;

918: ROLLBACK TO update_item_wrap;
919: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
920:
921: FND_MSG_PUB.Add;
922: x_return_status := FND_API.G_RET_STS_ERROR ;
923: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
924:
925: WHEN IEM_PROC_REDIRECT_SAME_ACCT THEN
926: ROLLBACK TO update_item_wrap;

Line 930: x_return_status := FND_API.G_RET_STS_ERROR ;

926: ROLLBACK TO update_item_wrap;
927: FND_MESSAGE.SET_NAME('IEM','IEM_PROC_REDIRECT_SAME_ACCT');
928:
929: FND_MSG_PUB.Add;
930: x_return_status := FND_API.G_RET_STS_ERROR ;
931: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
932:
933: WHEN IEM_ADM_INVALID_PROC_NAME THEN
934: ROLLBACK TO update_item_wrap;

Line 938: x_return_status := FND_API.G_RET_STS_ERROR ;

934: ROLLBACK TO update_item_wrap;
935: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
936:
937: -- FND_MSG_PUB.Add;
938: x_return_status := FND_API.G_RET_STS_ERROR ;
939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
940:
941: WHEN IEM_NO_ROUTE_UPDATE THEN
942: ROLLBACK TO update_item_wrap;

Line 946: x_return_status := FND_API.G_RET_STS_ERROR ;

942: ROLLBACK TO update_item_wrap;
943: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
944:
945: FND_MSG_PUB.Add;
946: x_return_status := FND_API.G_RET_STS_ERROR ;
947: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
948: WHEN IEM_NO_RULE_UPDATE THEN
949: ROLLBACK TO update_item_wrap;
950: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');

Line 952: x_return_status := FND_API.G_RET_STS_ERROR ;

948: WHEN IEM_NO_RULE_UPDATE THEN
949: ROLLBACK TO update_item_wrap;
950: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
951: FND_MSG_PUB.Add;
952: x_return_status := FND_API.G_RET_STS_ERROR ;
953: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
954:
955: WHEN IEM_RULE_NOT_DELETED THEN
956:

Line 960: x_return_status := FND_API.G_RET_STS_ERROR ;

956:
957: ROLLBACK TO update_item_wrap;
958: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
959: FND_MSG_PUB.Add;
960: x_return_status := FND_API.G_RET_STS_ERROR ;
961:
962: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
963:
964: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN

Line 968: x_return_status := FND_API.G_RET_STS_ERROR ;

964: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
965: ROLLBACK TO update_item_wrap;
966: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
967: FND_MSG_PUB.Add;
968: x_return_status := FND_API.G_RET_STS_ERROR ;
969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
970:
971:
972: WHEN IEM_ADMIN_EMAILPROC_NO_RULE THEN

Line 977: x_return_status := FND_API.G_RET_STS_ERROR ;

973: ROLLBACK TO update_item_wrap;
974: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_EMAILPROC_NO_RULE');
975: FND_MSG_PUB.Add;
976:
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
981: ROLLBACK TO update_item_wrap;

Line 985: x_return_status := FND_API.G_RET_STS_ERROR ;

981: ROLLBACK TO update_item_wrap;
982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
983: FND_MSG_PUB.Add;
984:
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN
988: ROLLBACK TO update_item_wrap;
989: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 987: WHEN FND_API.G_EXC_ERROR THEN

983: FND_MSG_PUB.Add;
984:
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN
988: ROLLBACK TO update_item_wrap;
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
991:

Line 989: x_return_status := FND_API.G_RET_STS_ERROR ;

985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN
988: ROLLBACK TO update_item_wrap;
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
991:
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
991:
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: ROLLBACK TO update_item_wrap;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

991:
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: ROLLBACK TO update_item_wrap;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
998:
999: WHEN OTHERS THEN

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR;

997:
998:
999: WHEN OTHERS THEN
1000: ROLLBACK TO update_item_wrap;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1004: END IF;
1005:

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

1045: l_param_tag VARCHAR2(30);
1046: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1047: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
1048:
1049: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1050: l_msg_count NUMBER := 0;
1051: l_msg_data VARCHAR2(2000);
1052:
1053: IEM_EMAILPROC_NOT_CREATED EXCEPTION;

Line 1065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1061: -- Standard Start of API savepoint
1062: SAVEPOINT create_item_wrap;
1063:
1064: -- Standard call to check for call compatibility.
1065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1066: p_api_version_number,
1067: l_api_name,
1068: G_PKG_NAME)
1069: THEN

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: l_api_name,
1068: G_PKG_NAME)
1069: THEN
1070:
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073:
1074:
1075: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1076: IF FND_API.to_Boolean( p_init_msg_list )

1072: END IF;
1073:
1074:
1075: -- Initialize message list if p_init_msg_list is set to TRUE.
1076: IF FND_API.to_Boolean( p_init_msg_list )
1077: THEN
1078: FND_MSG_PUB.initialize;
1079: END IF;
1080:

Line 1082: x_return_status := FND_API.G_RET_STS_SUCCESS;

1078: FND_MSG_PUB.initialize;
1079: END IF;
1080:
1081: -- Initialize API return status to SUCCESS
1082: x_return_status := FND_API.G_RET_STS_SUCCESS;
1083:
1084: --API Body
1085: --Auto-Processing: Execute Procedure/workflow validation
1086: if ( p_action = 'EXECPROCEDURE' ) then

Line 1094: p_init_msg_list => FND_API.G_FALSE,

1090: raise IEM_ADM_AUTOPRC_NO_PARAMETERS;
1091: else
1092: IEM_TAG_RUN_PROC_PVT.validProcedure(
1093: p_api_version_number => P_Api_Version_Number,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_commit => P_Commit,
1096: p_ProcName => p_parameter1_tbl(1),
1097: x_return_status => l_return_status,
1098: x_msg_count => l_msg_count,

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

1097: x_return_status => l_return_status,
1098: x_msg_count => l_msg_count,
1099: x_msg_data => l_msg_data
1100: );
1101: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1102: raise IEM_ADM_INVALID_PROC_NAME;
1103: end if;
1104: end if;
1105: end if;

Line 1111: p_commit => FND_API.G_FALSE,

1107: --Create iem_emailprocs
1108: iem_emailproc_hdl_pvt.create_item_emailprocs (
1109: p_api_version_number=>p_api_version_number,
1110: p_init_msg_list => p_init_msg_list,
1111: p_commit => FND_API.G_FALSE,
1112: p_name => p_route_name,
1113: p_description => p_route_description,
1114: p_boolean_type_code =>p_route_boolean_type_code,
1115: p_all_email => p_all_email,

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

1119: x_msg_count => l_msg_count,
1120: x_msg_data => l_msg_data);
1121:
1122:
1123: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1124: raise IEM_EMAILPROC_NOT_CREATED;
1125: end if;
1126:
1127:

Line 1135: p_commit => FND_API.G_FALSE,

1131:
1132: iem_emailproc_hdl_pvt.create_item_emailproc_rules (
1133: p_api_version_number=>p_api_version_number,
1134: p_init_msg_list => p_init_msg_list,
1135: p_commit => FND_API.G_FALSE,
1136: p_emailproc_id => l_emailproc_id,
1137: p_key_type_code => p_rule_key_typecode_tbl(i),
1138: p_operator_type_code => p_rule_operator_typecode_tbl(i),
1139: p_value =>p_rule_value_tbl(i),

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

1140: x_return_status =>l_return_status,
1141: x_msg_count => l_msg_count,
1142: x_msg_data => l_msg_data);
1143:
1144: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1145: raise IEM_EMAILPROC_RULE_NOT_CREATED;
1146: end if;
1147: end loop;
1148: end if;

Line 1155: p_commit => FND_API.G_FALSE,

1151: -- IF ( p_rule_type = 'AUTOACKNOWLEDGE' or p_rule_type = 'AUTOPROCESSING' or p_rule_type = 'AUTORRRS' ) then
1152: iem_emailproc_hdl_pvt.create_item_actions (
1153: p_api_version_number=>p_api_version_number,
1154: p_init_msg_list => p_init_msg_list,
1155: p_commit => FND_API.G_FALSE,
1156: p_emailproc_id => l_emailproc_id,
1157: p_action_name => p_action,
1158: x_action_id => l_action_id,
1159: x_return_status =>l_return_status,

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

1159: x_return_status =>l_return_status,
1160: x_msg_count => l_msg_count,
1161: x_msg_data => l_msg_data);
1162:
1163: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1164: raise IEM_ACTION_NOT_CREATED;
1165: end if;
1166:
1167:

Line 1190: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

1186:
1187: if ( i <= l_param2_count ) then
1188: l_param2 := p_parameter2_tbl(i);
1189: else
1190: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
1191: end if;
1192:
1193: if ( i <= l_param3_count ) then
1194: l_param3 := p_parameter3_tbl(i);

Line 1196: l_param3 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

1192:
1193: if ( i <= l_param3_count ) then
1194: l_param3 := p_parameter3_tbl(i);
1195: else
1196: l_param3 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
1197: end if;
1198:
1199:
1200: if ( i <= l_param_tag_count ) then

Line 1203: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;

1199:
1200: if ( i <= l_param_tag_count ) then
1201: l_param_tag := p_parameter_tag_tbl(i);
1202: else
1203: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
1204: end if;
1205:
1206: iem_emailproc_hdl_pvt.create_item_action_dtls (
1207: p_api_version_number=>p_api_version_number,

Line 1209: p_commit => FND_API.G_FALSE,

1205:
1206: iem_emailproc_hdl_pvt.create_item_action_dtls (
1207: p_api_version_number=>p_api_version_number,
1208: p_init_msg_list => p_init_msg_list,
1209: p_commit => FND_API.G_FALSE,
1210: p_action_id => l_action_id,
1211: p_param1 => p_parameter1_tbl(i),
1212: p_param2 => l_param2,
1213: p_param3 => l_param3,

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

1215: x_return_status =>l_return_status,
1216: x_msg_count => l_msg_count,
1217: x_msg_data => l_msg_data);
1218:
1219: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1220: raise IEM_ACTION_DTLS_NOT_CREATE;
1221: end if;
1222: end loop;
1223: END IF;

Line 1227: IF FND_API.To_Boolean(p_commit) THEN

1223: END IF;
1224:
1225: -- END IF;
1226:
1227: IF FND_API.To_Boolean(p_commit) THEN
1228: COMMIT WORK;
1229: END IF;
1230:
1231: EXCEPTION

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR ;

1230:
1231: EXCEPTION
1232: WHEN IEM_EMAILPROC_NOT_CREATED THEN
1233: ROLLBACK TO create_item_wrap;
1234: x_return_status := FND_API.G_RET_STS_ERROR ;
1235: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1236:
1237: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1238: ROLLBACK TO create_item_wrap;

Line 1241: x_return_status := FND_API.G_RET_STS_ERROR ;

1237: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1238: ROLLBACK TO create_item_wrap;
1239: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1240: FND_MSG_PUB.Add;
1241: x_return_status := FND_API.G_RET_STS_ERROR ;
1242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1243:
1244: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1245: ROLLBACK TO create_item_wrap;

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR ;

1244: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1245: ROLLBACK TO create_item_wrap;
1246: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1247: -- FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1252: ROLLBACK TO create_item_wrap;

Line 1255: x_return_status := FND_API.G_RET_STS_ERROR ;

1251: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1252: ROLLBACK TO create_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1254: FND_MSG_PUB.Add;
1255: x_return_status := FND_API.G_RET_STS_ERROR ;
1256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1257:
1258: WHEN IEM_ACTION_NOT_CREATED THEN
1259: ROLLBACK TO create_item_wrap;

Line 1262: x_return_status := FND_API.G_RET_STS_ERROR ;

1258: WHEN IEM_ACTION_NOT_CREATED THEN
1259: ROLLBACK TO create_item_wrap;
1260: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1261: FND_MSG_PUB.Add;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:
1266: ROLLBACK TO create_item_wrap;

Line 1269: x_return_status := FND_API.G_RET_STS_ERROR ;

1265:
1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1268: FND_MSG_PUB.Add;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO create_item_wrap;

Line 1272: WHEN FND_API.G_EXC_ERROR THEN

1268: FND_MSG_PUB.Add;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO create_item_wrap;
1274: x_return_status := FND_API.G_RET_STS_ERROR ;
1275: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1276:

Line 1274: x_return_status := FND_API.G_RET_STS_ERROR ;

1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO create_item_wrap;
1274: x_return_status := FND_API.G_RET_STS_ERROR ;
1275: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1276:
1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1274: x_return_status := FND_API.G_RET_STS_ERROR ;
1275: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1276:
1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279:
1280: ROLLBACK TO create_item_wrap;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279:
1280: ROLLBACK TO create_item_wrap;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1283:
1284: WHEN OTHERS THEN
1285: ROLLBACK TO create_item_wrap;

Line 1286: x_return_status := FND_API.G_RET_STS_ERROR;

1282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1283:
1284: WHEN OTHERS THEN
1285: ROLLBACK TO create_item_wrap;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1289: END IF;
1290:

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

1311: l_count number;
1312: l_account number;
1313: l_redirect_same_acct number := 0;
1314:
1315: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1316: l_msg_count NUMBER := 0;
1317: l_msg_data VARCHAR2(2000);
1318:
1319: IEM_ADMIN_ROUTE_NOT_EXIST EXCEPTION;

Line 1328: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1324: -- Standard Start of API savepoint
1325: SAVEPOINT create_wrap_account_routes_PVT;
1326:
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1329:
1330: p_api_version_number,
1331: l_api_name,
1332: G_PKG_NAME)

Line 1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1330: p_api_version_number,
1331: l_api_name,
1332: G_PKG_NAME)
1333: THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;
1336:
1337: -- Initialize message list if p_init_msg_list is set to TRUE.
1338: IF FND_API.to_Boolean( p_init_msg_list )

Line 1338: IF FND_API.to_Boolean( p_init_msg_list )

1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;
1336:
1337: -- Initialize message list if p_init_msg_list is set to TRUE.
1338: IF FND_API.to_Boolean( p_init_msg_list )
1339: THEN
1340:
1341: FND_MSG_PUB.initialize;
1342: END IF;

Line 1346: x_return_status := FND_API.G_RET_STS_SUCCESS;

1342: END IF;
1343:
1344:
1345: -- Initialize API return status to SUCCESS
1346: x_return_status := FND_API.G_RET_STS_SUCCESS;
1347:
1348:
1349: -- check if the route_id exist in iem_routes
1350: select count(*) into l_count from iem_emailprocs

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

1385: x_return_status =>l_return_status,
1386: x_msg_count => l_msg_count,
1387: x_msg_data => l_msg_data);
1388:
1389: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1390: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
1391:
1392: end if;
1393:

Line 1395: IF FND_API.To_Boolean(p_commit) THEN

1391:
1392: end if;
1393:
1394: -- Standard Check Of p_commit.
1395: IF FND_API.To_Boolean(p_commit) THEN
1396: COMMIT WORK;
1397: END IF;
1398: -- Standard callto get message count and if count is 1, get message info.
1399: FND_MSG_PUB.Count_And_Get

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR ;

1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1409:
1410: FND_MSG_PUB.Add;
1411: x_return_status := FND_API.G_RET_STS_ERROR ;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413:
1414: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1415: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1419: x_return_status := FND_API.G_RET_STS_ERROR ;

1415: ROLLBACK TO create_wrap_account_routes_PVT;
1416: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1417:
1418: FND_MSG_PUB.Add;
1419: x_return_status := FND_API.G_RET_STS_ERROR ;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422:
1423: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR ;

1424: ROLLBACK TO create_wrap_account_routes_PVT;
1425: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1426: FND_MSG_PUB.Add;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:
1431: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1432:

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR ;

1432:
1433: ROLLBACK TO create_wrap_account_routes_PVT;
1434: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1435: FND_MSG_PUB.Add;
1436: x_return_status := FND_API.G_RET_STS_ERROR ;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1439: WHEN FND_API.G_EXC_ERROR THEN

1435: FND_MSG_PUB.Add;
1436: x_return_status := FND_API.G_RET_STS_ERROR ;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: ROLLBACK TO create_wrap_account_routes_PVT;
1441: x_return_status := FND_API.G_RET_STS_ERROR ;
1442:
1443: FND_MSG_PUB.Count_And_Get

Line 1441: x_return_status := FND_API.G_RET_STS_ERROR ;

1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: ROLLBACK TO create_wrap_account_routes_PVT;
1441: x_return_status := FND_API.G_RET_STS_ERROR ;
1442:
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1445: p_data => x_msg_data

Line 1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1445: p_data => x_msg_data
1446:
1447: );
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO create_wrap_account_routes_PVT;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_count => x_msg_count,

Line 1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1447: );
1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO create_wrap_account_routes_PVT;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );

Line 1461: x_return_status := FND_API.G_RET_STS_ERROR;

1457:
1458: WHEN OTHERS THEN
1459: ROLLBACK TO create_wrap_account_routes_PVT;
1460:
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: IF FND_MSG_PUB.Check_Msg_Level
1463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.Add_Exc_Msg

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

1491: x_msg_data OUT NOCOPY VARCHAR2
1492: ) is
1493: l_api_name VARCHAR2(255):='update_wrap_account_emailprocs';
1494: l_api_version_number NUMBER:=1.0;
1495: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1496: l_msg_count NUMBER := 0;
1497: l_msg_data VARCHAR2(2000);
1498: IEM_ACCT_EMAILPROC_NOT_DELETED EXCEPTION;
1499: IEM_ACCT_EMAILPROC_NOT_UPDATED EXCEPTION;

Line 1505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1501: -- Standard Start of API savepoint
1502: SAVEPOINT update_wrap_acct_emailproc_PVT;
1503:
1504: -- Standard call to check for call compatibility.
1505: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1506: p_api_version_number,
1507: l_api_name,
1508: G_PKG_NAME)
1509:

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1507: l_api_name,
1508: G_PKG_NAME)
1509:
1510: THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513:
1514: -- Initialize message list if p_init_msg_list is set to TRUE.
1515: IF FND_API.to_Boolean( p_init_msg_list )

Line 1515: IF FND_API.to_Boolean( p_init_msg_list )

1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513:
1514: -- Initialize message list if p_init_msg_list is set to TRUE.
1515: IF FND_API.to_Boolean( p_init_msg_list )
1516: THEN
1517:
1518: FND_MSG_PUB.initialize;
1519: END IF;

Line 1521: x_return_status := FND_API.G_RET_STS_SUCCESS;

1517:
1518: FND_MSG_PUB.initialize;
1519: END IF;
1520: -- Initialize API return status to SUCCESS
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522:
1523: -- update first
1524:
1525: if ( p_emailproc_ids_tbl.count <> 0 ) then

Line 1529: p_init_msg_list => FND_API.G_FALSE,

1525: if ( p_emailproc_ids_tbl.count <> 0 ) then
1526: FOR i IN p_emailproc_ids_tbl.FIRST..p_emailproc_ids_tbl.LAST LOOP
1527: iem_emailproc_hdl_pvt.update_account_emailprocs
1528: (p_api_version_number =>p_api_version_number,
1529: p_init_msg_list => FND_API.G_FALSE,
1530: p_commit => FND_API.G_TRUE,
1531: p_emailproc_id => p_emailproc_ids_tbl(i),
1532: p_email_account_id => p_email_account_id,
1533: p_enabled_flag => p_upd_enable_flag_tbl(i),

Line 1530: p_commit => FND_API.G_TRUE,

1526: FOR i IN p_emailproc_ids_tbl.FIRST..p_emailproc_ids_tbl.LAST LOOP
1527: iem_emailproc_hdl_pvt.update_account_emailprocs
1528: (p_api_version_number =>p_api_version_number,
1529: p_init_msg_list => FND_API.G_FALSE,
1530: p_commit => FND_API.G_TRUE,
1531: p_emailproc_id => p_emailproc_ids_tbl(i),
1532: p_email_account_id => p_email_account_id,
1533: p_enabled_flag => p_upd_enable_flag_tbl(i),
1534: x_return_status =>l_return_status,

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

1534: x_return_status =>l_return_status,
1535: x_msg_count => l_msg_count,
1536: x_msg_data => l_msg_data);
1537:
1538: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1539: raise IEM_ACCT_EMAILPROC_NOT_UPDATED;
1540: end if;
1541: END LOOP;
1542: end if;

Line 1548: P_init_msg_list => FND_API.G_FALSE,

1544:
1545: if ( p_delete_emailproc_ids_tbl.count <> 0 ) then
1546: iem_emailproc_hdl_pvt.delete_acct_emailproc_batch
1547: (p_api_version_number => p_api_version_number,
1548: P_init_msg_list => FND_API.G_FALSE,
1549: p_commit => FND_API.G_TRUE,
1550: p_emailproc_ids_tbl => p_delete_emailproc_ids_tbl,
1551: p_account_id => p_email_account_id,
1552: p_rule_type => p_rule_type,

Line 1549: p_commit => FND_API.G_TRUE,

1545: if ( p_delete_emailproc_ids_tbl.count <> 0 ) then
1546: iem_emailproc_hdl_pvt.delete_acct_emailproc_batch
1547: (p_api_version_number => p_api_version_number,
1548: P_init_msg_list => FND_API.G_FALSE,
1549: p_commit => FND_API.G_TRUE,
1550: p_emailproc_ids_tbl => p_delete_emailproc_ids_tbl,
1551: p_account_id => p_email_account_id,
1552: p_rule_type => p_rule_type,
1553: x_return_status => l_return_status,

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

1552: p_rule_type => p_rule_type,
1553: x_return_status => l_return_status,
1554: x_msg_count => l_msg_count,
1555: x_msg_data => l_msg_data) ;
1556: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1557: raise IEM_ACCT_EMAILPROC_NOT_DELETED;
1558: end if;
1559:
1560: end if;

Line 1564: IF FND_API.To_Boolean(p_commit) THEN

1560: end if;
1561:
1562:
1563: -- Standard Check Of p_commit.
1564: IF FND_API.To_Boolean(p_commit) THEN
1565: COMMIT WORK;
1566: END IF;
1567:
1568: -- Standard callto get message count and if count is 1, get message info.

Line 1581: x_return_status := FND_API.G_RET_STS_ERROR ;

1577: WHEN IEM_ACCT_EMAILPROC_NOT_UPDATED THEN
1578: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1579: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1580: FND_MSG_PUB.Add;
1581: x_return_status := FND_API.G_RET_STS_ERROR ;
1582:
1583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1584:
1585: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN

Line 1589: x_return_status := FND_API.G_RET_STS_ERROR ;

1585: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1586: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1587: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1588: FND_MSG_PUB.Add;
1589: x_return_status := FND_API.G_RET_STS_ERROR ;
1590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1591:
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: ROLLBACK TO update_wrap_acct_emailproc_PVT;

Line 1592: WHEN FND_API.G_EXC_ERROR THEN

1588: FND_MSG_PUB.Add;
1589: x_return_status := FND_API.G_RET_STS_ERROR ;
1590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1591:
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1594: x_return_status := FND_API.G_RET_STS_ERROR ;
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_count => x_msg_count,

Line 1594: x_return_status := FND_API.G_RET_STS_ERROR ;

1590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1591:
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1594: x_return_status := FND_API.G_RET_STS_ERROR ;
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );

Line 1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1596: ( p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599:
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1603: FND_MSG_PUB.Count_And_Get
1604: ( p_count => x_msg_count,

Line 1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1598: );
1599:
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1603: FND_MSG_PUB.Count_And_Get
1604: ( p_count => x_msg_count,
1605: p_data => x_msg_data
1606: );

Line 1610: x_return_status := FND_API.G_RET_STS_ERROR;

1606: );
1607:
1608: WHEN OTHERS THEN
1609: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611:
1612: IF FND_MSG_PUB.Check_Msg_Level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN

Line 1656: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1652: --Standard Savepoint
1653: SAVEPOINT delete_item_batch;
1654:
1655: -- Standard call to check for call compatibility.
1656: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1657: p_api_version_number,
1658: l_api_name,
1659: G_PKG_NAME)
1660: THEN

Line 1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1657: p_api_version_number,
1658: l_api_name,
1659: G_PKG_NAME)
1660: THEN
1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: END IF;
1663:
1664: --Initialize the message list if p_init_msg_list is set to TRUE
1665: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 1665: If FND_API.to_Boolean(p_init_msg_list) THEN

1661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1662: END IF;
1663:
1664: --Initialize the message list if p_init_msg_list is set to TRUE
1665: If FND_API.to_Boolean(p_init_msg_list) THEN
1666: FND_MSG_PUB.initialize;
1667: END IF;
1668:
1669: --Initialize API status return

Line 1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

1666: FND_MSG_PUB.initialize;
1667: END IF;
1668:
1669: --Initialize API status return
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;
1671:
1672: --Actual API starts here
1673: DELETE
1674: FROM IEM_EMAILPROCS

Line 1720: IF FND_API.to_Boolean(p_commit) THEN

1716: delete from iem_actions where emailproc_id = p_emailproc_id;
1717:
1718:
1719: --Standard check of p_commit
1720: IF FND_API.to_Boolean(p_commit) THEN
1721: COMMIT WORK;
1722: END IF;
1723:
1724:

Line 1729: x_return_status := FND_API.G_RET_STS_ERROR;

1725: EXCEPTION
1726:
1727: WHEN IEM_ROUTE_NOT_DELETED THEN
1728: ROLLBACK TO delete_item_batch;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1731:
1732: FND_MSG_PUB.ADD;
1733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1735: WHEN FND_API.G_EXC_ERROR THEN

1731:
1732: FND_MSG_PUB.ADD;
1733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1734:
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO delete_item_batch;
1737: x_return_status := FND_API.G_RET_STS_ERROR ;
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_count => x_msg_count,p_data => x_msg_data);

Line 1737: x_return_status := FND_API.G_RET_STS_ERROR ;

1733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1734:
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO delete_item_batch;
1737: x_return_status := FND_API.G_RET_STS_ERROR ;
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_count => x_msg_count,p_data => x_msg_data);
1740:
1741:

Line 1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1738: FND_MSG_PUB.Count_And_Get
1739: ( p_count => x_msg_count,p_data => x_msg_data);
1740:
1741:
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: ROLLBACK TO delete_item_batch;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1746:

Line 1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1740:
1741:
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: ROLLBACK TO delete_item_batch;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1746:
1747:
1748: WHEN OTHERS THEN

Line 1750: x_return_status := FND_API.G_RET_STS_ERROR;

1746:
1747:
1748: WHEN OTHERS THEN
1749: ROLLBACK TO delete_item_batch;
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1753: END IF;
1754:

Line 1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1775: --Standard Savepoint
1776: SAVEPOINT delete_acct_emailproc_by_acct;
1777:
1778: -- Standard call to check for call compatibility.
1779: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1780: p_api_version_number,
1781: l_api_name,
1782: G_PKG_NAME)
1783: THEN

Line 1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1780: p_api_version_number,
1781: l_api_name,
1782: G_PKG_NAME)
1783: THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: END IF;
1786:
1787:
1788:

Line 1790: If FND_API.to_Boolean(p_init_msg_list) THEN

1786:
1787:
1788:
1789: --Initialize the message list if p_init_msg_list is set to TRUE
1790: If FND_API.to_Boolean(p_init_msg_list) THEN
1791: FND_MSG_PUB.initialize;
1792: END IF;
1793:
1794: --Initialize API status return

Line 1795: x_return_status := FND_API.G_RET_STS_SUCCESS;

1791: FND_MSG_PUB.initialize;
1792: END IF;
1793:
1794: --Initialize API status return
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;
1796:
1797: --Actual API starts here
1798: DELETE
1799: FROM IEM_ACCOUNT_EMAILPROCS

Line 1804: IF FND_API.to_Boolean(p_commit) THEN

1800: WHERE email_account_id = p_email_account_id;
1801:
1802:
1803: --Standard check of p_commit
1804: IF FND_API.to_Boolean(p_commit) THEN
1805: COMMIT WORK;
1806: END IF;
1807:
1808: FND_MSG_PUB.Count_And_Get

Line 1812: WHEN FND_API.G_EXC_ERROR THEN

1808: FND_MSG_PUB.Count_And_Get
1809: ( p_count => x_msg_count,p_data => x_msg_data);
1810:
1811: EXCEPTION
1812: WHEN FND_API.G_EXC_ERROR THEN
1813: ROLLBACK TO delete_acct_emailproc_by_acct;
1814: x_return_status := FND_API.G_RET_STS_ERROR ;
1815: FND_MSG_PUB.Count_And_Get
1816:

Line 1814: x_return_status := FND_API.G_RET_STS_ERROR ;

1810:
1811: EXCEPTION
1812: WHEN FND_API.G_EXC_ERROR THEN
1813: ROLLBACK TO delete_acct_emailproc_by_acct;
1814: x_return_status := FND_API.G_RET_STS_ERROR ;
1815: FND_MSG_PUB.Count_And_Get
1816:
1817: ( p_count => x_msg_count,p_data => x_msg_data);
1818:

Line 1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1815: FND_MSG_PUB.Count_And_Get
1816:
1817: ( p_count => x_msg_count,p_data => x_msg_data);
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: ROLLBACK TO delete_acct_emailproc_by_acct;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1823:

Line 1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1817: ( p_count => x_msg_count,p_data => x_msg_data);
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: ROLLBACK TO delete_acct_emailproc_by_acct;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1823:
1824:
1825: WHEN OTHERS THEN

Line 1827: x_return_status := FND_API.G_RET_STS_ERROR;

1823:
1824:
1825: WHEN OTHERS THEN
1826: ROLLBACK TO delete_acct_emailproc_by_acct;
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1830:
1831: END IF;