DBA Data[Home] [Help]

APPS.GMI_PR_PICK_SLIP_NUMBER dependencies on WSH_UTIL_CORE

Line 160: WSH_UTIL_CORE.Println('calling Print_Pvt, num =' || l_ps_num);

156: /* Loop through key table and print all remaining pick slips */
157: WHILE l_index IS NOT NULL LOOP
158: /* Print pick slip */
159: l_ps_num := g_pskey_table(l_index).pick_slip_number;
160: WSH_UTIL_CORE.Println('calling Print_Pvt, num =' || l_ps_num);
161: Print_Pvt(p_report_set_id, p_organization_id, l_ps_num, x_api_status);
162: WSH_UTIL_CORE.Println('x_api_status Print_Pvt:'|| x_api_status);
163:
164: /* Remove from table */

Line 162: WSH_UTIL_CORE.Println('x_api_status Print_Pvt:'|| x_api_status);

158: /* Print pick slip */
159: l_ps_num := g_pskey_table(l_index).pick_slip_number;
160: WSH_UTIL_CORE.Println('calling Print_Pvt, num =' || l_ps_num);
161: Print_Pvt(p_report_set_id, p_organization_id, l_ps_num, x_api_status);
162: WSH_UTIL_CORE.Println('x_api_status Print_Pvt:'|| x_api_status);
163:
164: /* Remove from table */
165: g_pskey_table.delete(l_index);
166:

Line 187: 'WSH_UTIL_CORE.Print_Document_Sets in ' ||

183: END IF;
184:
185: IF x_api_status <> FND_API.G_RET_STS_SUCCESS THEN
186: x_error_message := 'Error occurred in call to ' ||
187: 'WSH_UTIL_CORE.Print_Document_Sets in ' ||
188: 'WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
189: END IF;
190:
191: EXCEPTION

Line 195: WSH_UTIL_CORE.Println('SQL error: ' || SQLERRM(SQLCODE));

191: EXCEPTION
192: WHEN OTHERS THEN
193: x_error_message := 'Exception occurred in WSH_PR_PICK_SLIP_NUMBER.Print_Pick_Slip';
194: x_api_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: WSH_UTIL_CORE.Println('SQL error: ' || SQLERRM(SQLCODE));
196: END Print_Pick_Slip;
197:
198: /* =======================================================================
199: | Name

Line 573: l_trip_ids WSH_UTIL_CORE.Id_Tab_Type;

569: p_pick_slip_number IN NUMBER,
570: x_api_status OUT NOCOPY VARCHAR2)
571: IS
572: l_report_set_id NUMBER;
573: l_trip_ids WSH_UTIL_CORE.Id_Tab_Type;
574: l_stop_ids WSH_UTIL_CORE.Id_Tab_Type;
575: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
576: l_document_info WSH_DOCUMENT_SETS.document_set_tab_type;
577: l_organization_id NUMBER;

Line 574: l_stop_ids WSH_UTIL_CORE.Id_Tab_Type;

570: x_api_status OUT NOCOPY VARCHAR2)
571: IS
572: l_report_set_id NUMBER;
573: l_trip_ids WSH_UTIL_CORE.Id_Tab_Type;
574: l_stop_ids WSH_UTIL_CORE.Id_Tab_Type;
575: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
576: l_document_info WSH_DOCUMENT_SETS.document_set_tab_type;
577: l_organization_id NUMBER;
578: BEGIN

Line 575: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;

571: IS
572: l_report_set_id NUMBER;
573: l_trip_ids WSH_UTIL_CORE.Id_Tab_Type;
574: l_stop_ids WSH_UTIL_CORE.Id_Tab_Type;
575: l_delivery_ids WSH_UTIL_CORE.Id_Tab_Type;
576: l_document_info WSH_DOCUMENT_SETS.document_set_tab_type;
577: l_organization_id NUMBER;
578: BEGIN
579: l_document_info(1).p_report_set_id := p_report_set_id;

Line 589: WSH_UTIL_CORE.Println('calling WSH_UTIL_CORE.Print_Document_Sets');

585: l_document_info(1).p_pick_status := 'A';
586:
587: l_organization_id := p_organization_id;
588:
589: WSH_UTIL_CORE.Println('calling WSH_UTIL_CORE.Print_Document_Sets');
590: WSH_DOCUMENT_SETS.Print_Document_Sets(
591: p_report_set_id => l_report_set_id,
592: p_organization_id => l_organization_id,
593: p_trip_ids => l_trip_ids,