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 644: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

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

Line 678: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 689: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 696: x_return_status := FND_API.G_RET_STS_SUCCESS;

692: END IF;
693:
694:
695: -- Initialize API return status to SUCCESS
696: x_return_status := FND_API.G_RET_STS_SUCCESS;
697:
698: --API Body
699:
700:

Line 718: p_init_msg_list => FND_API.G_FALSE,

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

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

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

Line 751: p_init_msg_list => FND_API.G_FALSE,

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

Line 752: p_commit => FND_API.G_FALSE,

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

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

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

Line 774: p_init_msg_list => FND_API.G_FALSE,

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

Line 775: p_commit => FND_API.G_FALSE,

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

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

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

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

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

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

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

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

857:
858: if ( i <= l_param2_count ) then
859: l_param2 := p_parameter2_tbl(i);
860: else
861: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
862: end if;
863:
864:
865: if ( i <= l_param_tag_count ) then

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

864:
865: if ( i <= l_param_tag_count ) then
866: l_param_tag := p_parameter_tag_tbl(i);
867: else
868: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
869: end if;
870:
871: iem_emailproc_hdl_pvt.create_item_action_dtls (
872: p_api_version_number=>p_api_version_number,

Line 874: p_commit => FND_API.G_FALSE,

870:
871: iem_emailproc_hdl_pvt.create_item_action_dtls (
872: p_api_version_number=>p_api_version_number,
873: p_init_msg_list => p_init_msg_list,
874: p_commit => FND_API.G_FALSE,
875: p_action_id => l_action_id,
876: p_param1 => p_parameter1_tbl(i),
877: p_param2 => l_param2,
878: p_param_tag => l_param_tag,

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

879: x_return_status =>l_return_status,
880: x_msg_count => l_msg_count,
881: x_msg_data => l_msg_data);
882:
883: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
884: raise IEM_ACTION_DTLS_NOT_CREATE;
885: end if;
886: end loop;
887: END IF;

Line 897: x_return_status := FND_API.G_RET_STS_ERROR ;

893: ROLLBACK TO update_item_wrap;
894: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
895:
896: -- FND_MSG_PUB.Add;
897: x_return_status := FND_API.G_RET_STS_ERROR ;
898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
899:
900: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
901: ROLLBACK TO update_item_wrap;

Line 905: x_return_status := FND_API.G_RET_STS_ERROR ;

901: ROLLBACK TO update_item_wrap;
902: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
903:
904: FND_MSG_PUB.Add;
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
907:
908: WHEN IEM_PROC_REDIRECT_SAME_ACCT THEN
909: ROLLBACK TO update_item_wrap;

Line 913: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 921: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 929: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 935: x_return_status := FND_API.G_RET_STS_ERROR ;

931: WHEN IEM_NO_RULE_UPDATE THEN
932: ROLLBACK TO update_item_wrap;
933: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
934: FND_MSG_PUB.Add;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
937:
938: WHEN IEM_RULE_NOT_DELETED THEN
939:

Line 943: x_return_status := FND_API.G_RET_STS_ERROR ;

939:
940: ROLLBACK TO update_item_wrap;
941: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
942: FND_MSG_PUB.Add;
943: x_return_status := FND_API.G_RET_STS_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
946:
947: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN

Line 951: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 960: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 968: x_return_status := FND_API.G_RET_STS_ERROR ;

964: ROLLBACK TO update_item_wrap;
965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
966: FND_MSG_PUB.Add;
967:
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: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO update_item_wrap;
972: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 970: WHEN FND_API.G_EXC_ERROR THEN

966: FND_MSG_PUB.Add;
967:
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: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO update_item_wrap;
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
974:

Line 972: x_return_status := FND_API.G_RET_STS_ERROR ;

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: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO update_item_wrap;
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
974:
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
974:
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO update_item_wrap;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
980:

Line 978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

974:
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO update_item_wrap;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
980:
981:
982: WHEN OTHERS THEN

Line 984: x_return_status := FND_API.G_RET_STS_ERROR;

980:
981:
982: WHEN OTHERS THEN
983: ROLLBACK TO update_item_wrap;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
987: END IF;
988:

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

1025: l_param_tag VARCHAR2(30);
1026: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1027: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
1028:
1029: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1030: l_msg_count NUMBER := 0;
1031: l_msg_data VARCHAR2(2000);
1032:
1033: IEM_EMAILPROC_NOT_CREATED EXCEPTION;

Line 1045: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1041: -- Standard Start of API savepoint
1042: SAVEPOINT create_item_wrap;
1043:
1044: -- Standard call to check for call compatibility.
1045: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1046: p_api_version_number,
1047: l_api_name,
1048: G_PKG_NAME)
1049: THEN

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1047: l_api_name,
1048: G_PKG_NAME)
1049: THEN
1050:
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052: END IF;
1053:
1054:
1055: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1056: IF FND_API.to_Boolean( p_init_msg_list )

1052: END IF;
1053:
1054:
1055: -- Initialize message list if p_init_msg_list is set to TRUE.
1056: IF FND_API.to_Boolean( p_init_msg_list )
1057: THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to SUCCESS
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063:
1064: --API Body
1065: --Auto-Processing: Execute Procedure/workflow validation
1066: if ( p_action = 'EXECPROCEDURE' ) then

Line 1074: p_init_msg_list => FND_API.G_FALSE,

1070: raise IEM_ADM_AUTOPRC_NO_PARAMETERS;
1071: else
1072: IEM_TAG_RUN_PROC_PVT.validProcedure(
1073: p_api_version_number => P_Api_Version_Number,
1074: p_init_msg_list => FND_API.G_FALSE,
1075: p_commit => P_Commit,
1076: p_ProcName => p_parameter1_tbl(1),
1077: x_return_status => l_return_status,
1078: x_msg_count => l_msg_count,

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

1077: x_return_status => l_return_status,
1078: x_msg_count => l_msg_count,
1079: x_msg_data => l_msg_data
1080: );
1081: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1082: raise IEM_ADM_INVALID_PROC_NAME;
1083: end if;
1084: end if;
1085: end if;

Line 1091: p_commit => FND_API.G_FALSE,

1087: --Create iem_emailprocs
1088: iem_emailproc_hdl_pvt.create_item_emailprocs (
1089: p_api_version_number=>p_api_version_number,
1090: p_init_msg_list => p_init_msg_list,
1091: p_commit => FND_API.G_FALSE,
1092: p_name => p_route_name,
1093: p_description => p_route_description,
1094: p_boolean_type_code =>p_route_boolean_type_code,
1095: p_all_email => p_all_email,

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

1099: x_msg_count => l_msg_count,
1100: x_msg_data => l_msg_data);
1101:
1102:
1103: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1104: raise IEM_EMAILPROC_NOT_CREATED;
1105: end if;
1106:
1107:

Line 1115: p_commit => FND_API.G_FALSE,

1111:
1112: iem_emailproc_hdl_pvt.create_item_emailproc_rules (
1113: p_api_version_number=>p_api_version_number,
1114: p_init_msg_list => p_init_msg_list,
1115: p_commit => FND_API.G_FALSE,
1116: p_emailproc_id => l_emailproc_id,
1117: p_key_type_code => p_rule_key_typecode_tbl(i),
1118: p_operator_type_code => p_rule_operator_typecode_tbl(i),
1119: p_value =>p_rule_value_tbl(i),

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

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

Line 1135: p_commit => FND_API.G_FALSE,

1131: -- IF ( p_rule_type = 'AUTOACKNOWLEDGE' or p_rule_type = 'AUTOPROCESSING' or p_rule_type = 'AUTORRRS' ) then
1132: iem_emailproc_hdl_pvt.create_item_actions (
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_action_name => p_action,
1138: x_action_id => l_action_id,
1139: x_return_status =>l_return_status,

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

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

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

1160:
1161: if ( i <= l_param2_count ) then
1162: l_param2 := p_parameter2_tbl(i);
1163: else
1164: l_param2 := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
1165: end if;
1166:
1167:
1168: if ( i <= l_param_tag_count ) then

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

1167:
1168: if ( i <= l_param_tag_count ) then
1169: l_param_tag := p_parameter_tag_tbl(i);
1170: else
1171: l_param_tag := null; --FND_API.G_MISS_CHAR;--null; --FND_API.G_MISS_CHAR;
1172: end if;
1173:
1174: iem_emailproc_hdl_pvt.create_item_action_dtls (
1175: p_api_version_number=>p_api_version_number,

Line 1177: p_commit => FND_API.G_FALSE,

1173:
1174: iem_emailproc_hdl_pvt.create_item_action_dtls (
1175: p_api_version_number=>p_api_version_number,
1176: p_init_msg_list => p_init_msg_list,
1177: p_commit => FND_API.G_FALSE,
1178: p_action_id => l_action_id,
1179: p_param1 => p_parameter1_tbl(i),
1180: p_param2 => l_param2,
1181: p_param_tag => l_param_tag,

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

1182: x_return_status =>l_return_status,
1183: x_msg_count => l_msg_count,
1184: x_msg_data => l_msg_data);
1185:
1186: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1187: raise IEM_ACTION_DTLS_NOT_CREATE;
1188: end if;
1189: end loop;
1190: END IF;

Line 1194: IF FND_API.To_Boolean(p_commit) THEN

1190: END IF;
1191:
1192: -- END IF;
1193:
1194: IF FND_API.To_Boolean(p_commit) THEN
1195: COMMIT WORK;
1196: END IF;
1197:
1198: EXCEPTION

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR ;

1197:
1198: EXCEPTION
1199: WHEN IEM_EMAILPROC_NOT_CREATED THEN
1200: ROLLBACK TO create_item_wrap;
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1203:
1204: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1205: ROLLBACK TO create_item_wrap;

Line 1208: x_return_status := FND_API.G_RET_STS_ERROR ;

1204: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1205: ROLLBACK TO create_item_wrap;
1206: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1207: FND_MSG_PUB.Add;
1208: x_return_status := FND_API.G_RET_STS_ERROR ;
1209: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1210:
1211: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1212: ROLLBACK TO create_item_wrap;

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR ;

1211: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1212: ROLLBACK TO create_item_wrap;
1213: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1214: -- FND_MSG_PUB.Add;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217:
1218: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1219: ROLLBACK TO create_item_wrap;

Line 1222: x_return_status := FND_API.G_RET_STS_ERROR ;

1218: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1219: ROLLBACK TO create_item_wrap;
1220: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1221: FND_MSG_PUB.Add;
1222: x_return_status := FND_API.G_RET_STS_ERROR ;
1223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1224:
1225: WHEN IEM_ACTION_NOT_CREATED THEN
1226: ROLLBACK TO create_item_wrap;

Line 1229: x_return_status := FND_API.G_RET_STS_ERROR ;

1225: WHEN IEM_ACTION_NOT_CREATED THEN
1226: ROLLBACK TO create_item_wrap;
1227: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1228: FND_MSG_PUB.Add;
1229: x_return_status := FND_API.G_RET_STS_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:
1233: ROLLBACK TO create_item_wrap;

Line 1236: x_return_status := FND_API.G_RET_STS_ERROR ;

1232:
1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1235: FND_MSG_PUB.Add;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: ROLLBACK TO create_item_wrap;

Line 1239: WHEN FND_API.G_EXC_ERROR THEN

1235: FND_MSG_PUB.Add;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: ROLLBACK TO create_item_wrap;
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:

Line 1241: x_return_status := FND_API.G_RET_STS_ERROR ;

1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: ROLLBACK TO create_item_wrap;
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:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246:
1247: ROLLBACK TO create_item_wrap;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246:
1247: ROLLBACK TO create_item_wrap;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO create_item_wrap;

Line 1253: 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 OTHERS THEN
1252: ROLLBACK TO create_item_wrap;
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1256: END IF;
1257:

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

1278: l_count number;
1279: l_account number;
1280: l_redirect_same_acct number := 0;
1281:
1282: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1283: l_msg_count NUMBER := 0;
1284: l_msg_data VARCHAR2(2000);
1285:
1286: IEM_ADMIN_ROUTE_NOT_EXIST EXCEPTION;

Line 1295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1291: -- Standard Start of API savepoint
1292: SAVEPOINT create_wrap_account_routes_PVT;
1293:
1294: -- Standard call to check for call compatibility.
1295: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1296:
1297: p_api_version_number,
1298: l_api_name,
1299: G_PKG_NAME)

Line 1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1297: p_api_version_number,
1298: l_api_name,
1299: G_PKG_NAME)
1300: THEN
1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303:
1304: -- Initialize message list if p_init_msg_list is set to TRUE.
1305: IF FND_API.to_Boolean( p_init_msg_list )

Line 1305: IF FND_API.to_Boolean( p_init_msg_list )

1301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1302: END IF;
1303:
1304: -- Initialize message list if p_init_msg_list is set to TRUE.
1305: IF FND_API.to_Boolean( p_init_msg_list )
1306: THEN
1307:
1308: FND_MSG_PUB.initialize;
1309: END IF;

Line 1313: x_return_status := FND_API.G_RET_STS_SUCCESS;

1309: END IF;
1310:
1311:
1312: -- Initialize API return status to SUCCESS
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315:
1316: -- check if the route_id exist in iem_routes
1317: select count(*) into l_count from iem_emailprocs

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

1352: x_return_status =>l_return_status,
1353: x_msg_count => l_msg_count,
1354: x_msg_data => l_msg_data);
1355:
1356: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1357: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
1358:
1359: end if;
1360:

Line 1362: IF FND_API.To_Boolean(p_commit) THEN

1358:
1359: end if;
1360:
1361: -- Standard Check Of p_commit.
1362: IF FND_API.To_Boolean(p_commit) THEN
1363: COMMIT WORK;
1364: END IF;
1365: -- Standard callto get message count and if count is 1, get message info.
1366: FND_MSG_PUB.Count_And_Get

Line 1378: x_return_status := FND_API.G_RET_STS_ERROR ;

1374: ROLLBACK TO create_wrap_account_routes_PVT;
1375: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1376:
1377: FND_MSG_PUB.Add;
1378: x_return_status := FND_API.G_RET_STS_ERROR ;
1379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1380:
1381: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1382: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1386: x_return_status := FND_API.G_RET_STS_ERROR ;

1382: ROLLBACK TO create_wrap_account_routes_PVT;
1383: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1384:
1385: FND_MSG_PUB.Add;
1386: x_return_status := FND_API.G_RET_STS_ERROR ;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1388:
1389:
1390: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR ;

1391: ROLLBACK TO create_wrap_account_routes_PVT;
1392: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1393: FND_MSG_PUB.Add;
1394:
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1397:
1398: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1399:

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR ;

1399:
1400: ROLLBACK TO create_wrap_account_routes_PVT;
1401: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1402: FND_MSG_PUB.Add;
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1406: WHEN FND_API.G_EXC_ERROR THEN

1402: FND_MSG_PUB.Add;
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: x_return_status := FND_API.G_RET_STS_ERROR ;
1409:
1410: FND_MSG_PUB.Count_And_Get

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR ;

1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: x_return_status := FND_API.G_RET_STS_ERROR ;
1409:
1410: FND_MSG_PUB.Count_And_Get
1411: ( p_count => x_msg_count,
1412: p_data => x_msg_data

Line 1416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1412: p_data => x_msg_data
1413:
1414: );
1415:
1416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1417: ROLLBACK TO create_wrap_account_routes_PVT;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: FND_MSG_PUB.Count_And_Get
1420: ( p_count => x_msg_count,

Line 1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1414: );
1415:
1416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1417: ROLLBACK TO create_wrap_account_routes_PVT;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1419: FND_MSG_PUB.Count_And_Get
1420: ( p_count => x_msg_count,
1421: p_data => x_msg_data
1422: );

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR;

1424:
1425: WHEN OTHERS THEN
1426: ROLLBACK TO create_wrap_account_routes_PVT;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: IF FND_MSG_PUB.Check_Msg_Level
1430: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.Add_Exc_Msg

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

1458: x_msg_data OUT NOCOPY VARCHAR2
1459: ) is
1460: l_api_name VARCHAR2(255):='update_wrap_account_emailprocs';
1461: l_api_version_number NUMBER:=1.0;
1462: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1463: l_msg_count NUMBER := 0;
1464: l_msg_data VARCHAR2(2000);
1465: IEM_ACCT_EMAILPROC_NOT_DELETED EXCEPTION;
1466: IEM_ACCT_EMAILPROC_NOT_UPDATED EXCEPTION;

Line 1472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1468: -- Standard Start of API savepoint
1469: SAVEPOINT update_wrap_acct_emailproc_PVT;
1470:
1471: -- Standard call to check for call compatibility.
1472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1473: p_api_version_number,
1474: l_api_name,
1475: G_PKG_NAME)
1476:

Line 1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1474: l_api_name,
1475: G_PKG_NAME)
1476:
1477: THEN
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END IF;
1480:
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list )

Line 1482: IF FND_API.to_Boolean( p_init_msg_list )

1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END IF;
1480:
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list )
1483: THEN
1484:
1485: FND_MSG_PUB.initialize;
1486: END IF;

Line 1488: x_return_status := FND_API.G_RET_STS_SUCCESS;

1484:
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487: -- Initialize API return status to SUCCESS
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489:
1490: -- update first
1491:
1492: if ( p_emailproc_ids_tbl.count <> 0 ) then

Line 1496: p_init_msg_list => FND_API.G_FALSE,

1492: if ( p_emailproc_ids_tbl.count <> 0 ) then
1493: FOR i IN p_emailproc_ids_tbl.FIRST..p_emailproc_ids_tbl.LAST LOOP
1494: iem_emailproc_hdl_pvt.update_account_emailprocs
1495: (p_api_version_number =>p_api_version_number,
1496: p_init_msg_list => FND_API.G_FALSE,
1497: p_commit => FND_API.G_TRUE,
1498: p_emailproc_id => p_emailproc_ids_tbl(i),
1499: p_email_account_id => p_email_account_id,
1500: p_enabled_flag => p_upd_enable_flag_tbl(i),

Line 1497: p_commit => FND_API.G_TRUE,

1493: FOR i IN p_emailproc_ids_tbl.FIRST..p_emailproc_ids_tbl.LAST LOOP
1494: iem_emailproc_hdl_pvt.update_account_emailprocs
1495: (p_api_version_number =>p_api_version_number,
1496: p_init_msg_list => FND_API.G_FALSE,
1497: p_commit => FND_API.G_TRUE,
1498: p_emailproc_id => p_emailproc_ids_tbl(i),
1499: p_email_account_id => p_email_account_id,
1500: p_enabled_flag => p_upd_enable_flag_tbl(i),
1501: x_return_status =>l_return_status,

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

1501: x_return_status =>l_return_status,
1502: x_msg_count => l_msg_count,
1503: x_msg_data => l_msg_data);
1504:
1505: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1506: raise IEM_ACCT_EMAILPROC_NOT_UPDATED;
1507: end if;
1508: END LOOP;
1509: end if;

Line 1515: P_init_msg_list => FND_API.G_FALSE,

1511:
1512: if ( p_delete_emailproc_ids_tbl.count <> 0 ) then
1513: iem_emailproc_hdl_pvt.delete_acct_emailproc_batch
1514: (p_api_version_number => p_api_version_number,
1515: P_init_msg_list => FND_API.G_FALSE,
1516: p_commit => FND_API.G_TRUE,
1517: p_emailproc_ids_tbl => p_delete_emailproc_ids_tbl,
1518: p_account_id => p_email_account_id,
1519: p_rule_type => p_rule_type,

Line 1516: p_commit => FND_API.G_TRUE,

1512: if ( p_delete_emailproc_ids_tbl.count <> 0 ) then
1513: iem_emailproc_hdl_pvt.delete_acct_emailproc_batch
1514: (p_api_version_number => p_api_version_number,
1515: P_init_msg_list => FND_API.G_FALSE,
1516: p_commit => FND_API.G_TRUE,
1517: p_emailproc_ids_tbl => p_delete_emailproc_ids_tbl,
1518: p_account_id => p_email_account_id,
1519: p_rule_type => p_rule_type,
1520: x_return_status => l_return_status,

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

1519: p_rule_type => p_rule_type,
1520: x_return_status => l_return_status,
1521: x_msg_count => l_msg_count,
1522: x_msg_data => l_msg_data) ;
1523: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1524: raise IEM_ACCT_EMAILPROC_NOT_DELETED;
1525: end if;
1526:
1527: end if;

Line 1531: IF FND_API.To_Boolean(p_commit) THEN

1527: end if;
1528:
1529:
1530: -- Standard Check Of p_commit.
1531: IF FND_API.To_Boolean(p_commit) THEN
1532: COMMIT WORK;
1533: END IF;
1534:
1535: -- Standard callto get message count and if count is 1, get message info.

Line 1548: x_return_status := FND_API.G_RET_STS_ERROR ;

1544: WHEN IEM_ACCT_EMAILPROC_NOT_UPDATED THEN
1545: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1546: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1547: FND_MSG_PUB.Add;
1548: x_return_status := FND_API.G_RET_STS_ERROR ;
1549:
1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1551:
1552: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN

Line 1556: x_return_status := FND_API.G_RET_STS_ERROR ;

1552: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1553: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1554: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1555: FND_MSG_PUB.Add;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1558:
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO update_wrap_acct_emailproc_PVT;

Line 1559: WHEN FND_API.G_EXC_ERROR THEN

1555: FND_MSG_PUB.Add;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1558:
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR ;
1562: FND_MSG_PUB.Count_And_Get
1563: ( p_count => x_msg_count,

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR ;

1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1558:
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR ;
1562: FND_MSG_PUB.Count_And_Get
1563: ( p_count => x_msg_count,
1564: p_data => x_msg_data
1565: );

Line 1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1563: ( p_count => x_msg_count,
1564: p_data => x_msg_data
1565: );
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1568: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,

Line 1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1565: );
1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1568: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );

Line 1577: x_return_status := FND_API.G_RET_STS_ERROR;

1573: );
1574:
1575: WHEN OTHERS THEN
1576: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN

Line 1623: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1619: --Standard Savepoint
1620: SAVEPOINT delete_item_batch;
1621:
1622: -- Standard call to check for call compatibility.
1623: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1624: p_api_version_number,
1625: l_api_name,
1626: G_PKG_NAME)
1627: THEN

Line 1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1624: p_api_version_number,
1625: l_api_name,
1626: G_PKG_NAME)
1627: THEN
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629: END IF;
1630:
1631: --Initialize the message list if p_init_msg_list is set to TRUE
1632: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 1632: If FND_API.to_Boolean(p_init_msg_list) THEN

1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629: END IF;
1630:
1631: --Initialize the message list if p_init_msg_list is set to TRUE
1632: If FND_API.to_Boolean(p_init_msg_list) THEN
1633: FND_MSG_PUB.initialize;
1634: END IF;
1635:
1636: --Initialize API status return

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

1633: FND_MSG_PUB.initialize;
1634: END IF;
1635:
1636: --Initialize API status return
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638:
1639: --Actual API starts here
1640: DELETE
1641: FROM IEM_EMAILPROCS

Line 1687: IF FND_API.to_Boolean(p_commit) THEN

1683: delete from iem_actions where emailproc_id = p_emailproc_id;
1684:
1685:
1686: --Standard check of p_commit
1687: IF FND_API.to_Boolean(p_commit) THEN
1688: COMMIT WORK;
1689: END IF;
1690:
1691:

Line 1696: x_return_status := FND_API.G_RET_STS_ERROR;

1692: EXCEPTION
1693:
1694: WHEN IEM_ROUTE_NOT_DELETED THEN
1695: ROLLBACK TO delete_item_batch;
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1698:
1699: FND_MSG_PUB.ADD;
1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1702: WHEN FND_API.G_EXC_ERROR THEN

1698:
1699: FND_MSG_PUB.ADD;
1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO delete_item_batch;
1704: x_return_status := FND_API.G_RET_STS_ERROR ;
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,p_data => x_msg_data);

Line 1704: x_return_status := FND_API.G_RET_STS_ERROR ;

1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO delete_item_batch;
1704: x_return_status := FND_API.G_RET_STS_ERROR ;
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,p_data => x_msg_data);
1707:
1708:

Line 1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,p_data => x_msg_data);
1707:
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710: ROLLBACK TO delete_item_batch;
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1713:

Line 1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1707:
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710: ROLLBACK TO delete_item_batch;
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1713:
1714:
1715: WHEN OTHERS THEN

Line 1717: x_return_status := FND_API.G_RET_STS_ERROR;

1713:
1714:
1715: WHEN OTHERS THEN
1716: ROLLBACK TO delete_item_batch;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1719: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1720: END IF;
1721:

Line 1746: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1742: --Standard Savepoint
1743: SAVEPOINT delete_acct_emailproc_by_acct;
1744:
1745: -- Standard call to check for call compatibility.
1746: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)
1750: THEN

Line 1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1747: p_api_version_number,
1748: l_api_name,
1749: G_PKG_NAME)
1750: THEN
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
1753:
1754:
1755:

Line 1757: If FND_API.to_Boolean(p_init_msg_list) THEN

1753:
1754:
1755:
1756: --Initialize the message list if p_init_msg_list is set to TRUE
1757: If FND_API.to_Boolean(p_init_msg_list) THEN
1758: FND_MSG_PUB.initialize;
1759: END IF;
1760:
1761: --Initialize API status return

Line 1762: x_return_status := FND_API.G_RET_STS_SUCCESS;

1758: FND_MSG_PUB.initialize;
1759: END IF;
1760:
1761: --Initialize API status return
1762: x_return_status := FND_API.G_RET_STS_SUCCESS;
1763:
1764: --Actual API starts here
1765: DELETE
1766: FROM IEM_ACCOUNT_EMAILPROCS

Line 1771: IF FND_API.to_Boolean(p_commit) THEN

1767: WHERE email_account_id = p_email_account_id;
1768:
1769:
1770: --Standard check of p_commit
1771: IF FND_API.to_Boolean(p_commit) THEN
1772: COMMIT WORK;
1773: END IF;
1774:
1775: FND_MSG_PUB.Count_And_Get

Line 1779: WHEN FND_API.G_EXC_ERROR THEN

1775: FND_MSG_PUB.Count_And_Get
1776: ( p_count => x_msg_count,p_data => x_msg_data);
1777:
1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN
1780: ROLLBACK TO delete_acct_emailproc_by_acct;
1781: x_return_status := FND_API.G_RET_STS_ERROR ;
1782: FND_MSG_PUB.Count_And_Get
1783:

Line 1781: x_return_status := FND_API.G_RET_STS_ERROR ;

1777:
1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN
1780: ROLLBACK TO delete_acct_emailproc_by_acct;
1781: x_return_status := FND_API.G_RET_STS_ERROR ;
1782: FND_MSG_PUB.Count_And_Get
1783:
1784: ( p_count => x_msg_count,p_data => x_msg_data);
1785:

Line 1786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1782: FND_MSG_PUB.Count_And_Get
1783:
1784: ( p_count => x_msg_count,p_data => x_msg_data);
1785:
1786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1787: ROLLBACK TO delete_acct_emailproc_by_acct;
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1790:

Line 1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1784: ( p_count => x_msg_count,p_data => x_msg_data);
1785:
1786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1787: ROLLBACK TO delete_acct_emailproc_by_acct;
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1790:
1791:
1792: WHEN OTHERS THEN

Line 1794: x_return_status := FND_API.G_RET_STS_ERROR;

1790:
1791:
1792: WHEN OTHERS THEN
1793: ROLLBACK TO delete_acct_emailproc_by_acct;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1797:
1798: END IF;