DBA Data[Home] [Help]

APPS.PA_ASGMT_WFSTD dependencies on FND_MSG_PUB

Line 308: IF fnd_msg_pub.count_msg > 0 THEN

304: BEGIN
305: -- dbms_output.put_line ('inside start workflow');
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307: /*
308: IF fnd_msg_pub.count_msg > 0 THEN
309: insert_into_temp ('msgs in stack inside start_workflow is',
310: fnd_msg_pub.count_msg);
311: END IF;
312: */

Line 310: fnd_msg_pub.count_msg);

306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307: /*
308: IF fnd_msg_pub.count_msg > 0 THEN
309: insert_into_temp ('msgs in stack inside start_workflow is',
310: fnd_msg_pub.count_msg);
311: END IF;
312: */
313: fnd_msg_pub.initialize;
314: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_workflow');

Line 313: fnd_msg_pub.initialize;

309: insert_into_temp ('msgs in stack inside start_workflow is',
310: fnd_msg_pub.count_msg);
311: END IF;
312: */
313: fnd_msg_pub.initialize;
314: pa_debug.init_err_stack ('pa_asgmt_wfstd.start_workflow');
315: x_msg_count := 0;
316: -- Create the unique item key to launch WF with
317: SELECT pa_prm_wf_item_key_s.nextval

Line 471: l_msg_count := fnd_msg_pub.count_msg;

467: END IF;
468: END IF;
469: -- If there are any busines rules violations , then do
470: -- not proceed. Return
471: l_msg_count := fnd_msg_pub.count_msg;
472: IF l_msg_count > 0 THEN
473: IF l_msg_count = 1 THEN
474: pa_interface_utils_pub.get_messages
475: (p_encoded => FND_API.G_TRUE,

Line 1459: fnd_msg_pub.add_exc_msg

1455: -- 4537865 : RESET other OUT params also
1456: x_msg_data := SUBSTRB(SQLERRM,1,240);
1457: x_error_message_code := SQLCODE ;
1458: -- 4537865 : End
1459: fnd_msg_pub.add_exc_msg
1460: (p_pkg_name => 'PA_ASGMT_WFSTD',
1461: p_procedure_name => pa_debug.g_err_stack );
1462: x_msg_count := fnd_msg_pub.count_msg;
1463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1462: x_msg_count := fnd_msg_pub.count_msg;

1458: -- 4537865 : End
1459: fnd_msg_pub.add_exc_msg
1460: (p_pkg_name => 'PA_ASGMT_WFSTD',
1461: p_procedure_name => pa_debug.g_err_stack );
1462: x_msg_count := fnd_msg_pub.count_msg;
1463: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1464: END Start_Workflow ;
1465:
1466:

Line 1560: fnd_msg_pub.add_exc_msg

1556: x_wf_process := NULL ;
1557: x_wf_type := NULL ;
1558:
1559: -- 4537865 : End
1560: fnd_msg_pub.add_exc_msg
1561: (p_pkg_name => 'PA_ASGMT_WFSTD',
1562: p_procedure_name => pa_debug.g_err_stack );
1563: x_msg_count := fnd_msg_pub.count_msg;
1564: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1563: x_msg_count := fnd_msg_pub.count_msg;

1559: -- 4537865 : End
1560: fnd_msg_pub.add_exc_msg
1561: (p_pkg_name => 'PA_ASGMT_WFSTD',
1562: p_procedure_name => pa_debug.g_err_stack );
1563: x_msg_count := fnd_msg_pub.count_msg;
1564: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1565: RAISE ;
1566: END Get_workflow_process_info ;
1567:

Line 3812: l_msg_count := FND_MSG_PUB.Count_Msg;

3808: WHERE notification_id = document_id;
3809:
3810: BEGIN
3811: l_newline := FND_GLOBAL.newline;
3812: l_msg_count := FND_MSG_PUB.Count_Msg;
3813: OPEN l_nf_csr;
3814: FETCH l_nf_csr INTO l_item_type, l_item_key;
3815: IF l_nf_csr%NOTFOUND THEN
3816: document := 'Item Key not found';

Line 4501: FND_MSG_PUB.initialize;

4497: -- Initialize the return status to success
4498: x_return_status := FND_API.G_RET_STS_SUCCESS;
4499:
4500: --Clear the global PL/SQL message table
4501: FND_MSG_PUB.initialize;
4502:
4503: log_message('Inside Start mass approval flow: 0');
4504: log_message('Value of updated info doc:' || p_update_info_doc);
4505:

Line 4765: FND_MSG_PUB.add_exc_msg

4761: --Setting the original value
4762: wf_engine.threshold := l_save_threshold;
4763:
4764: -- Set the excetption Message and the stack
4765: FND_MSG_PUB.add_exc_msg
4766: ( p_pkg_name => 'PA_ASGMT_WFSTD.start_mass_Approval_flow'
4767: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4768:
4769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4931: FND_MSG_PUB.initialize;

4927: -- Initialize the return status to success
4928: x_return_status := FND_API.G_RET_STS_SUCCESS;
4929:
4930: --Clear the global PL/SQL message table
4931: FND_MSG_PUB.initialize;
4932: x_msg_count := 0;
4933:
4934: ---------------------------------
4935: --Set the pending approval flag

Line 5442: x_msg_count := FND_MSG_PUB.Count_Msg;

5438: wf_engine.threshold := l_save_threshold;
5439:
5440: -- IF the number of messages is 1 then fetch the message code from
5441: -- the stack and return its text
5442: x_msg_count := FND_MSG_PUB.Count_Msg;
5443:
5444: IF x_msg_count = 1 THEN
5445: pa_interface_utils_pub.get_messages
5446: ( p_encoded => FND_API.G_TRUE

Line 5456: IF FND_MSG_PUB.Count_Msg >0 THEN

5452: -- Reset the error stack when returning to the calling program
5453: PA_DEBUG.Reset_Err_Stack;
5454:
5455: -- If g_error_exists is TRUE then set the x_return_status to 'E'
5456: IF FND_MSG_PUB.Count_Msg >0 THEN
5457: x_return_status := FND_API.G_RET_STS_ERROR;
5458: END IF;
5459:
5460: EXCEPTION

Line 5467: FND_MSG_PUB.add_exc_msg

5463: --Setting the original value
5464: wf_engine.threshold := l_save_threshold;
5465:
5466: -- Set the excetption Message and the stack
5467: FND_MSG_PUB.add_exc_msg
5468: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_res_fyi_notification'
5469: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
5470:
5471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6018: FND_MSG_PUB.initialize;

6014: -- Initialize the return status to success
6015: x_return_status := FND_API.G_RET_STS_SUCCESS;
6016:
6017: --Clear the global PL/SQL message table
6018: FND_MSG_PUB.initialize;
6019:
6020: --------------------------------------------
6021: --Get Project Manager for these assignments
6022: --------------------------------------------

Line 6414: x_msg_count := FND_MSG_PUB.Count_Msg;

6410: wf_engine.threshold := l_save_threshold;
6411:
6412: -- IF the number of messages is 1 then fetch the message code from
6413: -- the stack and return its text
6414: x_msg_count := FND_MSG_PUB.Count_Msg;
6415:
6416: IF x_msg_count = 1 THEN
6417: pa_interface_utils_pub.get_messages
6418: ( p_encoded => FND_API.G_TRUE

Line 6428: IF FND_MSG_PUB.Count_Msg >0 THEN

6424: -- Reset the error stack when returning to the calling program
6425: PA_DEBUG.Reset_Err_Stack;
6426:
6427: -- If g_error_exists is TRUE then set the x_return_status to 'E'
6428: IF FND_MSG_PUB.Count_Msg >0 THEN
6429: x_return_status := FND_API.G_RET_STS_ERROR;
6430: END IF;
6431:
6432: EXCEPTION

Line 6436: FND_MSG_PUB.add_exc_msg

6432: EXCEPTION
6433: WHEN OTHERS THEN
6434:
6435: -- Set the excetption Message and the stack
6436: FND_MSG_PUB.add_exc_msg
6437: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_mgr_fyi_notification'
6438: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6439:
6440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6501: FND_MSG_PUB.initialize;

6497: -- Initialize the return status to success
6498: x_return_status := FND_API.G_RET_STS_SUCCESS;
6499:
6500: --Clear the global PL/SQL message table
6501: FND_MSG_PUB.initialize;
6502:
6503: log_message('Inside mass_process_approval_result_wf 2');
6504:
6505: ---------------------------------------------------

Line 6606: x_msg_count := FND_MSG_PUB.Count_Msg;

6602: ------------------------------------------------------------------
6603: -- IF the number of messages is 1 then fetch the message code from
6604: -- the stack and return its text
6605: ------------------------------------------------------------------
6606: x_msg_count := FND_MSG_PUB.Count_Msg;
6607:
6608: IF x_msg_count = 1 THEN
6609: pa_interface_utils_pub.get_messages
6610: ( p_encoded => FND_API.G_TRUE

Line 6620: IF FND_MSG_PUB.Count_Msg >0 THEN

6616: -- Reset the error stack when returning to the calling program
6617: PA_DEBUG.Reset_Err_Stack;
6618:
6619: -- If g_error_exists is TRUE then set the x_return_status to 'E'
6620: IF FND_MSG_PUB.Count_Msg >0 THEN
6621: x_return_status := FND_API.G_RET_STS_ERROR;
6622: END IF;
6623:
6624: EXCEPTION

Line 6628: FND_MSG_PUB.add_exc_msg

6624: EXCEPTION
6625: WHEN OTHERS THEN
6626:
6627: -- Set the excetption Message and the stack
6628: FND_MSG_PUB.add_exc_msg
6629: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_approval_result_wf'
6630: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
6631:
6632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 6816: IF FND_MSG_PUB.Count_Msg > 0 THEN

6812: ,x_msg_data => l_msg_data);
6813:
6814: log_message('After Calling process res fyi');
6815:
6816: IF FND_MSG_PUB.Count_Msg > 0 THEN
6817:
6818: log_message('Error in res_fyi');
6819:
6820: ROLLBACK TO UPDATE_APPROVAL_STATUS;

Line 7385: FND_MSG_PUB.initialize;

7381: -- Initialize the return status to success
7382: x_return_status := FND_API.G_RET_STS_SUCCESS;
7383:
7384: --Clear the global PL/SQL message table
7385: FND_MSG_PUB.initialize;
7386: x_msg_count := 0;
7387:
7388: log_message('Inside submitter notification');
7389:

Line 7746: x_msg_count := FND_MSG_PUB.Count_Msg;

7742: wf_engine.threshold := l_save_threshold;
7743:
7744: -- IF the number of messages is 1 then fetch the message code from
7745: -- the stack and return its text
7746: x_msg_count := FND_MSG_PUB.Count_Msg;
7747:
7748: IF x_msg_count = 1 THEN
7749: pa_interface_utils_pub.get_messages
7750: ( p_encoded => FND_API.G_TRUE

Line 7760: IF FND_MSG_PUB.Count_Msg >0 THEN

7756: -- Reset the error stack when returning to the calling program
7757: PA_DEBUG.Reset_Err_Stack;
7758:
7759: -- If g_error_exists is TRUE then set the x_return_status to 'E'
7760: IF FND_MSG_PUB.Count_Msg >0 THEN
7761: x_return_status := FND_API.G_RET_STS_ERROR;
7762: END IF;
7763:
7764: EXCEPTION

Line 7773: FND_MSG_PUB.add_exc_msg

7769: --Setting the original value
7770: wf_engine.threshold := l_save_threshold;
7771:
7772: -- Set the excetption Message and the stack
7773: FND_MSG_PUB.add_exc_msg
7774: ( p_pkg_name => 'PA_ASGMT_WFSTD.process_submitter_notification'
7775: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
7776:
7777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 8125: FND_MSG_PUB.initialize;

8121: IF l_assignment_id_tbl.COUNT > 0 THEN
8122:
8123: FOR i IN l_assignment_id_tbl.FIRST .. l_assignment_id_tbl.LAST LOOP
8124:
8125: FND_MSG_PUB.initialize;
8126:
8127: PA_UTILS.Add_Message( p_app_short_name => 'PA'
8128: ,p_msg_name => 'PA_PROCESS_ABORTED_SYSADMIN');
8129: